/* Business Partners */
SELECT * FROM OCRD
/* Chart of Accounts */
SELECT * FROM OACT
/* Item Master */
SELECT * FROM OITM
/* Terms Codes */
SELECT * FROM OCTG
/* Business Partners and their assigned payment terms */
SELECT OCTG.PymntGroup, OCRD.* FROM OCRD
LEFT OUTER JOIN OCTG ON OCRD.GroupNum = OCTG.GroupNum
/* Employee Master (HR) */
SELECT * FROM OHEM
/* Sales Quotations and their Line Items */
SELECT * FROM OQUT
INNER JOIN QUT1 ON OQUT.DocEntry = QUT1.DocEntry
/* Sales Orders and the Line Items */
SELECT * FROM ORDR
INNER JOIN RDR1 ON ORDR.DocEntry = RDR1.DocEntry
/* Credit Memos and the Line Items */
SELECT * FROM ORIN
INNER JOIN RIN1 ON ORIN.DocEntry = RIN1.DocEntry
/* Incomming Payments and the line level Information */
/* I have not validated this link */
SELECT * FROM ORCT
INNER JOIN RCT1 ON ORCT.DocNum = RCT1.DocNum
Thanks to Ed Monk of SBOnotes.com
