| TABLE NAME | DESCRIPTION |
|---|---|
| OCRG | GroupCode Definition table |
| OITM | Item table |
| ORDR | Parent Order Record Table |
| RDR1 | Child order record table |
| OCRD | Customer record table |
| ITM1 | Product Pricing |
| OWHS | Warehouse code + name |
| OITW | Stock levels of each product in each warehouse |
| OCTR | Service Contracts Header |
| CTR1 | Membership Item Detail |
| OCTT | Contract Template |
| OINV | invoice table |
| INV1 | Invoice Line Table |
| OCRC | Credit card type |
| TABLE 1 | TABLE 2 | JOIN FIELD |
|---|---|---|
| ORDR | RDR1 | DocEntry |
| ORDR | OCRD | CardCode |
| RDR1 | OITM | ItemCode |
| OCRG | OCRD | GroupCode |
| OITM | ITM1 | ItemCode |
| OITM | OITW | ItemCode |
| OWHS | OITW | WhsCode |
| OCTR | CTR1 | ContractID |
| OINV | INV1 | DocEntry |