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)