SAP Business One (SBO) Tables


Tables
TABLE NAMEDESCRIPTION
OCRGGroupCode Definition table
OITMItem table
ORDRParent Order Record Table
RDR1Child order record table
OCRDCustomer record table
ITM1Product Pricing
OWHSWarehouse code + name
OITWStock levels of each product in each warehouse
OCTRService Contracts Header
CTR1Membership Item Detail
OCTTContract Template
OINVinvoice table
INV1Invoice Line Table
OCRCCredit card type

Relationships
TABLE 1TABLE 2JOIN FIELD
ORDRRDR1DocEntry
ORDROCRDCardCode
RDR1OITMItemCode
OCRGOCRDGroupCode
OITMITM1ItemCode
OITMOITWItemCode
OWHSOITWWhsCode
OCTRCTR1ContractID
OINVINV1DocEntry

This was built by Martin Belcher