Commonly Used Tables for Queries

For those who would like to try their hand at doing some queries for formatted searches, alerts, or reports, but do not know what the common table names are, here is a short list. Check back and I will update the list from time to time.

Master Files:

OITM = Item Master
OCRD = Customer, Vendor, and Lead Master
CRD1 = Customer Master Address
OCRG = Customer Master Group Code

OHEM = Employee Master
OUSR = SBO Users

Document Files:

ORDR = Sales Order Header
RDR1 = Sales Order Detail (Items)

OINV = Invoice Header
INV1 = Invoice Line Details (Items)