Welcome To my Blog

Semoga blog ini bermanfaat buat Rekan-Rekan.
Blog ini dibuat untuk membantu teman-teman mempelajari SAP Business One dengan versi bahasa indonesia yang telah saya buat sendiri. Blog ini berisi mengenai configurasi, Pembuatan Query, Print layout Designer, Cystal Report, Formatted Search, Addons.
Saya tidak segan untuk membantu teman-teman yang ingin mengenal SAP Business One, Apabila terdapat pertanyaan mari kita diskusikan di dalam komentar yang sesuai dengan topik. Sehingga teman-teman yang lain juga dapat berinteraksi di blog ini, Jika Topik yang teman-teman inginkan tetapi belum ada dalam blog ini jangan ragu untuk request melalui email. (Saya juga membuka Private class untuk teman-teman yang ingin mempelajari SAP B1, Untuk Pendaftaran dapat Email ke saya)
Saya akan menjawab pertanyaan anda selama saya dapat menjawabnya. ^_^

Semoga Blog ini bermanfaat dan tidak disalahgunakan.
Ditunggu Vote Dan Komentar nya

Regards,
Ang Sukarno

Email : karno_indonezia@yahoo.co.id


Friday, June 13, 2014

Related Table in SAP Business One

Related Table di SAP BUSINESS ONE
Dapat berfungsi untuk membantu teman-teman dalam melakukan Join Table.

Object From Object To Join String
CPN1 CPN1 CPN1 T0
CPN1 OCRD CPN1 T0 INNER JOIN OCRD T1 ON T0.BpCode = T1.CardCode
CPN1 OCRD CPN1 T0 INNER JOIN OCRD T1 ON T0."BpCode" = T1."CardCode"
CRD1 OCRD CRD1 T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
CRD1 OCRD CRD1 T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"
CTR1 CTR1 CTR1 T0
CTR1 OCRD CTR1 T0 INNER JOIN  OCTR T2 ON T0.ContractID = T2.ContractID
INNER JOIN OCRD T1 ON T2.CstmrCode = T1.CardCode
CTR1 OCRD CTR1 T0 INNER JOIN OCTR T2 ON T0."ContractID" = T2."ContractID"
INNER JOIN OCRD T1 ON T2."CstmrCode" = T1."CardCode"
CTR1 OCTR CTR1 T0 INNER JOIN OCTR T1 ON T0.ContractID = T1.ContractID
CTR1 OCTR CTR1 T0 INNER JOIN OCTR T1 ON T0."ContractID" = T1."ContractID"
CTR1 OINS CTR1 T0 INNER JOIN OINS T1 ON T0.InsID = T1.insID
CTR1 OINS CTR1 T0 INNER JOIN OINS T1 ON T0."InsID" = T1."insID"
CTR1 OITB CTR1 T0 INNER JOIN OITB T1 ON T0.ItemGroup = T1.ItmsGrpCod
CTR1 OITB CTR1 T0 INNER JOIN OITB T1 ON T0."ItemGroup" = T1."ItmsGrpCod"
CTR1 OITM CTR1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
CTR1 OITM CTR1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DLN1 DLN1 DLN1 T0
DLN1 DPI1 DLN1 T0 INNER JOIN DPI1 T1 ON T1.BaseEntry = T0.DocEntry
AND T1.BaseType = 15 AND T1.BaseLine = T0.LineNum
DLN1 DPI1 DLN1 T0 INNER JOIN DPI1 T1 ON T1."BaseEntry" = T0."DocEntry"
AND T1."BaseType" = 15 AND T1."BaseLine" = T0."LineNum"
DLN1 INV1 DLN1 T0 INNER JOIN INV1 T1 ON T1.BaseEntry = T0.DocEntry
AND T1.BaseType = 15 AND T1.BaseLine = T0.LineNum
DLN1 INV1 DLN1 T0 INNER JOIN INV1 T1 ON T1."BaseEntry" = T0."DocEntry"
AND T1."BaseType" = 15 AND T1."BaseLine" = T0."LineNum"
DLN1 OACT DLN1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
DLN1 OACT DLN1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
DLN1 OCLG DLN1 T0 INNER JOIN  ODLN T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode
INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
DLN1

OCLG

DLN1 T0 INNER JOIN ODLN T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
DLN1 OCPR DLN1 T0 INNER JOIN ODLN T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
DLN1 OCPR DLN1 T0 INNER JOIN ODLN T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
DLN1 OCRD DLN1 T0 INNER JOIN ODLN T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
DLN1 OCRD DLN1 T0 INNER JOIN ODLN T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
DLN1 ODLN DLN1 T0 INNER JOIN ODLN T1 ON T0.DocEntry = T1.DocEntry
DLN1 ODLN DLN1 T0 INNER JOIN ODLN T1 ON T0."DocEntry" = T1."DocEntry"
DLN1 ODPI ODPI T1 INNER JOIN DPI1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry
AND T2.BaseType = 15 AND T2.BaseLine = T0.LineNum
DLN1

ODPI

ODPI T1 INNER JOIN DPI1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry"
AND T2."BaseType" = 15 AND T2."BaseLine" = T0."LineNum"
DLN1

OINV

OINV T1 INNER JOIN INV1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry
AND T2.BaseType = 15 AND T2.BaseLine = T0.LineNum
DLN1

OINV

OINV T1 INNER JOIN INV1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry"
AND T2."BaseType" = 15 AND T2."BaseLine" = T0."LineNum"
DLN1 OITB DLN1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
DLN1 OITB DLN1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
DLN1 OITM DLN1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
DLN1 OITM DLN1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DLN1 OMRC DLN1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
DLN1 OMRC DLN1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
DLN1 OPRJ DLN1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
DLN1 OPRJ DLN1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
DLN1

ORDN

ORDN T1 INNER JOIN RDN1 T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry
AND T2.BaseType = 15 AND T2.BaseLine = T0.LineNum
DLN1

ORDN

ORDN T1 INNER JOIN RDN1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry"
AND T2."BaseType" = 15 AND T2."BaseLine" = T0."LineNum"
DLN1 ORDR ORDR T1 INNER JOIN RDR1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DLN1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 17 AND T0.BaseLine = T2.LineNum
DLN1

ORDR

ORDR T1 INNER JOIN RDR1  T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DLN1 T0 ON T0."BaseEntry" = T2."DocEntry"
AND T0."BaseType" = 17 AND T0."BaseLine" = T2."LineNum"
DLN1 OSLP DLN1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
DLN1 OSLP DLN1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
DLN1 OWHS DLN1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
DLN1 OWHS DLN1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
DLN1 RDR1 NULL
DPI1 DLN1 DPI1 T0 INNER JOIN DLN1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 15 AND T0.BaseLine = T1.LineNum
DPI1 DLN1 DPI1 T0 INNER JOIN DLN1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 15 AND T0."BaseLine" = T1."LineNum"
DPI1 DPI1 DPI1 T0
DPI1 OACT DPI1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
DPI1 OACT DPI1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
DPI1

OCLG

DPI1 T0 INNER JOIN  ODPI T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode
INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
DPI1

OCLG

DPI1 T0 INNER JOIN ODPI T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
DPI1 OCPR
 
DPI1 T0 INNER JOIN ODPI T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
DPI1 OCPR DPI1 T0 INNER JOIN ODPI T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
DPI1 OCRD DPI1 T0 INNER JOIN ODPI T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
DPI1 OCRD DPI1 T0 INNER JOIN ODPI T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
DPI1

ODLN

ODLN T1 INNER JOIN DLN1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DPI1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 15 AND T0.BaseLine = T2.LineNum
DPI1

ODLN

ODLN T1 INNER JOIN DLN1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DPI1 T0 ON T0."BaseEntry" = T2."DocEntry"
AND T0."BaseType" = 15 AND T0."BaseLine" = T2."LineNum"
DPI1 ODPI DPI1 T0 INNER JOIN ODPI T1 ON T0.DocEntry = T1.DocEntry
DPI1 ODPI DPI1 T0 INNER JOIN ODPI T1 ON T0."DocEntry" = T1."DocEntry"
DPI1 OITB DPI1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
DPI1 OITB DPI1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
DPI1 OITM DPI1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
DPI1 OITM DPI1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DPI1 OMRC DPI1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
DPI1 OMRC DPI1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
DPI1 OPRJ DPI1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
DPI1 OPRJ DPI1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
DPI1

OQUT

OQUT T1 INNER JOIN QUT1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DPI1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 23 AND T0.BaseLine = T2.LineNum
DPI1

OQUT

OQUT T1 INNER JOIN QUT1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DPI1 T0 ON T0."BaseEntry" = T2."DocEntry"
AND T0."BaseType" = 23 AND T0."BaseLine" = T2."LineNum"
DPI1

ORDR

ORDR T1 INNER JOIN RDR1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DPI1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 17 AND T0.BaseLine = T2.LineNum
DPI1

ORDR

ORDR T1 INNER JOIN RDR1 T2 ON T1."DocEntry" = T2."DocEntry"
 INNER JOIN DPI1 T0 ON T0."BaseEntry" = T2."DocEntry"
AND T0."BaseType" = 17 AND T0."BaseLine" = T2."LineNum"
DPI1

ORIN

ORIN T1 INNER JOIN RIN1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DLN1 T0 ON T2.BaseEntry = T0.DocEntry
AND T2.BaseType = 203 AND T2.BaseLine = T0.LineNum
DPI1

ORIN

ORIN T1 INNER JOIN RIN1  T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DLN1 T0 ON T2."BaseEntry" = T0."DocEntry"
AND T2."BaseType" = 203 AND T2."BaseLine" = T0."LineNum"
DPI1 OSLP DPI1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
DPI1 OSLP DPI1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
DPI1 OWHS DPI1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
DPI1 OWHS DPI1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
DPI1 QUT1 DPI1 T0 INNER JOIN QUT1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 23 AND T0.BaseLine = T1.LineNum
DPI1 QUT1 DPI1 T0 INNER JOIN QUT1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 23 AND T0."BaseLine" = T1."LineNum"
DPI1 RDR1 DPI1 T0 INNER JOIN RDR1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 17 AND T0.BaseLine = T1.LineNum
DPI1 RDR1 DPI1 T0 INNER JOIN RDR1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 17 AND T0."BaseLine" = T1."LineNum"
DPO1 DPO1 DPO1 T0
DPO1 OACT DPO1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
DPO1 OACT DPO1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
DPO1

OCLG

DPO1 T0 INNER JOIN  ODPO T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode
INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
DPO1

OCLG

DPO1 T0 INNER JOIN ODPO T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
DPO1 OCPR DPO1 T0 INNER JOIN ODPO T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
DPO1 OCPR DPO1 T0 INNER JOIN ODPO T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
DPO1 OCRD DPO1 T0 INNER JOIN ODPO T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
DPO1 OCRD DPO1 T0 INNER JOIN ODPO T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
DPO1 ODPO DPO1 T0 INNER JOIN ODPO T1 ON T0.DocEntry = T1.DocEntry
DPO1 ODPO DPO1 T0 INNER JOIN ODPO T1 ON T0."DocEntry" = T1."DocEntry"
DPO1 OITB DPO1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
DPO1 OITB DPO1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
DPO1 OITM DPO1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
DPO1 OITM DPO1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
DPO1 OMRC DPO1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
DPO1 OMRC DPO1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
 INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
DPO1

OPDN

OPDN T1 INNER JOIN PDN1 T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DPO1 T0 ON T2.BaseEntry = T0.DocEntry
AND T2.BaseType = 204 AND T2.BaseLine = T0.LineNum
DPO1

OPDN

OPDN T1 INNER JOIN PDN1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DPO1 T0 ON T2."BaseEntry" = T0."DocEntry"
AND T2."BaseType" = 204 AND T2."BaseLine" = T0."LineNum"
DPO1

OPOR

OPOR T1 INNER JOIN POR1 T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN  DPO1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 22 AND T0.BaseLine = T2.LineNum
DPO1

OPOR

OPOR T1 INNER JOIN POR1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN DPO1 T0 ON T0."BaseEntry" = T2."DocEntry"
AND T0."BaseType" = 22 AND T0."BaseLine" = T2."LineNum"
DPO1

OPQT

 
OPQT T1 INNER JOIN PQT1 T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN DPO1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 540000006 AND T0.BaseLine = T2.LineNum
DPO1 OPRJ DPO1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
DPO1 OPRJ DPO1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
DPO1 OSLP DPO1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
DPO1 OSLP DPO1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
DPO1 OWHS DPO1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
DPO1 OWHS DPO1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
DPO1 PDN1 DPO1 T0 INNER JOIN PDN1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 20 AND T0.BaseLine = T1.LineNum
DPO1 PDN1 DPO1 T0 INNER JOIN PDN1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 20 AND T0."BaseLine" = T1."LineNum"
DPO1 POR1 DPO1 T0 INNER JOIN POR1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 22 AND T0.BaseLine = T1.LineNum
DPO1 POR1 DPO1 T0 INNER JOIN POR1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 22 AND T0."BaseLine" = T1."LineNum"
DPO1 PQT1 DPO1 T0 INNER JOIN PQT1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 540000006 AND T0.BaseLine = T1.LineNum
INV1 DLN1 INV1 T0 INNER JOIN DLN1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 15 AND T0.BaseLine = T1.LineNum
INV1 DLN1 INV1 T0 INNER JOIN DLN1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 15 AND T0."BaseLine" = T1."LineNum"
INV1 INV1 INV1 T0
INV1 OACT INV1 T0 INNER JOIN OACT T1 ON T0.AcctCode = T1.AcctCode
INV1 OACT INV1 T0 INNER JOIN OACT T1 ON T0."AcctCode" = T1."AcctCode"
INV1

OCLG

INV1 T0 INNER JOIN  OINV T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN  OCRD T3 ON T2.CardCode = T3.CardCode
INNER JOIN OCLG T1 ON T3.CardCode = T1.CardCode
INV1

OCLG

INV1 T0 INNER JOIN OINV T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN OCLG T1 ON T3."CardCode" = T1."CardCode"
INV1 OCPR INV1 T0 INNER JOIN OINV T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCPR T1 ON T2.CntctCode = T1.CntctCode
INV1 OCPR INV1 T0 INNER JOIN OINV T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCPR T1 ON T2."CntctCode" = T1."CntctCode"
INV1 OCRD INV1 T0 INNER JOIN OINV T2 ON T0.DocEntry = T2.DocEntry
INNER JOIN OCRD T1 ON T2.CardCode = T1.CardCode
INV1 OCRD INV1 T0 INNER JOIN OINV T2 ON T0."DocEntry" = T2."DocEntry"
INNER JOIN OCRD T1 ON T2."CardCode" = T1."CardCode"
INV1 ODLN ODLN T1 INNER JOIN DLN1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN INV1 T0 ON T2.BaseEntry = T0.DocEntry
AND T2.BaseType = 13 AND T2.BaseLine = T0.LineNum
INV1 ODLN ODLN T1 INNER JOIN DLN1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN INV1 T0 ON T2."BaseEntry" = T0."DocEntry"
AND T2."BaseType" = 13 AND T2."BaseLine" = T0."LineNum"
INV1 OINV INV1 T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry
INV1 OINV INV1 T0 INNER JOIN OINV T1 ON T0."DocEntry" = T1."DocEntry"
INV1 OITB INV1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OITB T1 ON T2.ItmsGrpCod = T1.ItmsGrpCod
INV1 OITB INV1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
INNER JOIN OITB T1 ON T2."ItmsGrpCod" = T1."ItmsGrpCod"
INV1 OITM INV1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
INV1 OITM INV1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
INV1 OMRC INV1 T0 INNER JOIN  OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN  OMRC T1 ON T2.FirmCode = T1.FirmCode
INV1 OMRC INV1 T0 INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
INNER JOIN OMRC T1 ON T2."FirmCode" = T1."FirmCode"
INV1 OPRJ INV1 T0 INNER JOIN OPRJ T1 ON T0.Project = T1.PrjCode
INV1 OPRJ INV1 T0 INNER JOIN OPRJ T1 ON T0."Project" = T1."PrjCode"
INV1

OQUT

OQUT T1 INNER JOIN QUT1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN INV1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 23 AND T0.BaseLine = T2.LineNum
INV1

OQUT

OQUT T1 INNER JOIN QUT1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN INV1 T0 ON T0."BaseEntry" = T2."DocEntry"
AND T0."BaseType" = 23 AND T0."BaseLine" = T2."LineNum"
INV1

ORDR

ORDR T1 INNER JOIN RDR1  T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN INV1 T0 ON T0.BaseEntry = T2.DocEntry
AND T0.BaseType = 17 AND T0.BaseLine = T2.LineNum
INV1

ORDR
 
ORDR T1 INNER JOIN RDR1 T2 ON T1."DocEntry" = T2."DocEntry"
 INNER JOIN INV1 T0 ON T0."BaseEntry" = T2."DocEntry"
AND T0."BaseType" = 17 AND T0."BaseLine" = T2."LineNum"
INV1

ORIN

ORIN T1 INNER JOIN RIN1 T2 ON T1.DocEntry = T2.DocEntry
INNER JOIN INV1 T0 ON T2.BaseEntry = T0.DocEntry
AND T2.BaseType = 13 AND T2.BaseLine = T0.LineNum
INV1

ORIN

ORIN T1 INNER JOIN RIN1 T2 ON T1."DocEntry" = T2."DocEntry"
INNER JOIN INV1 T0 ON T2."BaseEntry" = T0."DocEntry"
AND T2."BaseType" = 13 AND T2."BaseLine" = T0."LineNum"
INV1 OSLP INV1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
INV1 OSLP INV1 T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
INV1 OWHS INV1 T0 INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
INV1 OWHS INV1 T0 INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
INV1 QUT1 INV1 T0 INNER JOIN QUT1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 23 AND T0.BaseLine = T1.LineNum
INV1 QUT1 INV1 T0 INNER JOIN QUT1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 23 AND T0."BaseLine" = T1."LineNum"
INV1 RDR1 INV1 T0 INNER JOIN RDR1 T1 ON T0.BaseEntry = T1.DocEntry
AND T0.BaseType = 17 AND T0.BaseLine = T1.LineNum
INV1 RDR1 INV1 T0 INNER JOIN RDR1 T1 ON T0."BaseEntry" = T1."DocEntry"
AND T0."BaseType" = 17 AND T0."BaseLine" = T1."LineNum"
JDT1 JDT1 JDT T0
JDT1 OACT JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode
JDT1 OACT JDT1 T0 INNER JOIN OACT T1 ON T0."Account" = T1."AcctCode"
JDT1 OCRD JDT1 T0 INNER JOIN  OCRD T1 ON T0.ShortName = T1.CardCode
JDT1 OCRD JDT1 T0 INNER JOIN OCRD T1 ON T0."ShortName" = T1."CardCode"
JDT1 ODPI JDT1 T0 INNER JOIN ODPI T1 ON T0.TransId = T1.TransId
JDT1 ODPI JDT1 T0 INNER JOIN ODPI T1 ON T0."TransId" = T1."TransId"
JDT1 ODPO JDT1 T0 INNER JOIN ODPO T1 ON T0.TransId = T1.TransId
JDT1 ODPO JDT1 T0 INNER JOIN ODPO T1 ON T0."TransId" = T1."TransId"
JDT1 OINV JDT1 T0 INNER JOIN OINV T1 ON T0.TransId = T1.TransId
JDT1 OINV JDT1 T0 INNER JOIN OINV T1 ON T0."TransId" = T1."TransId"
JDT1 OJDT JDT1 T0 INNER JOIN OJDT T1 ON T0.TransId = T1.TransId
JDT1 OJDT JDT1 T0 INNER JOIN OJDT T1 ON T0."TransId" = T1."TransId"
JDT1 OPCH JDT1 T0 INNER JOIN OPCH T1 ON T0.TransId = T1.TransId
JDT1 OPCH JDT1 T0 INNER JOIN OPCH T1 ON T0."TransId" = T1."TransId"
JDT1 ORIN JDT1 T0 INNER JOIN ORIN T1 ON T0.TransId = T1.TransId
JDT1 ORIN JDT1 T0 INNER JOIN ORIN T1 ON T0."TransId" = T1."TransId"
JDT1 ORPC JDT1 T0 INNER JOIN ORPC T1 ON T0.TransId = T1.TransId
JDT1 ORPC JDT1 T0 INNER JOIN ORPC T1 ON T0."TransId" = T1."TransId"
OACT DLN1 OACT T0 INNER JOIN DLN1 T1 ON T0.AcctCode = T1.AcctCode
OACT DLN1 OACT T0 INNER JOIN DLN1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT DPI1 OACT T0 INNER JOIN DPI1 T1 ON T0.AcctCode = T1.AcctCode
OACT DPI1 OACT T0 INNER JOIN DPI1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT DPO1 OACT T0 INNER JOIN DPO1 T1 ON T0.AcctCode = T1.AcctCode
OACT DPO1 OACT T0 INNER JOIN DPO1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT INV1 OACT T0 INNER JOIN INV1 T1 ON T0.AcctCode = T1.AcctCode
OACT INV1 OACT T0 INNER JOIN INV1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT JDT1 OACT T0 INNER JOIN JDT1 T1 ON T0.AcctCode = T1.Account
OACT JDT1 OACT T0 INNER JOIN JDT1 T1 ON T0."AcctCode" = T1."Account"
OACT OACT OACT T0
OACT  OJDT OACT T0 INNER JOIN JDT1 T2 ON T0.AcctCode = T2.Account
INNER JOIN OJDT T1 ON T2.TransId = T1.TransId
OACT OJDT OACT T0 INNER JOIN JDT1 T2 ON T0."AcctCode" = T2."Account"
INNER JOIN OJDT T1 ON T2."TransId" = T1."TransId"
OACT PCH1 OACT T0 INNER JOIN PCH1 T1 ON T0.AcctCode = T1.AcctCode
OACT PCH1 OACT T0 INNER JOIN PCH1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT PDN1 OACT T0 INNER JOIN PDN1 T1 ON T0.AcctCode = T1.AcctCode
OACT PDN1 OACT T0 INNER JOIN PDN1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT POR1 OACT T0 INNER JOIN POR1 T1 ON T0.AcctCode = T1.AcctCode
OACT POR1 OACT T0 INNER JOIN POR1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT PQT1 OACT T0 INNER JOIN PQT1 T1 ON T0.AcctCode = T1.AcctCode
OACT QUT1 OACT T0 INNER JOIN QUT1 T1 ON T0.AcctCode = T1.AcctCode
OACT QUT1 OACT T0 INNER JOIN QUT1 T1 ON T0."AcctCode" = T1."AcctCode"
OACT RDR1 OACT T0 INNER JOIN RDR1 T1 ON T0.AcctCode = T1.AcctCode
OACT RDR1 OACT T0 INNER JOIN RDR1 T1 ON T0."AcctCode" = T1."AcctCode"
OAT1 OAT1 OAT1 T0
OAT1 OCRD OAT1 T0 INNER JOIN OOAT T2 ON T0.AgrNo = T2.AbsID
INNER JOIN OCRD T1 ON T2.BpCode = T1.CardCode
OAT1 OCRD OAT1 T0 INNER JOIN OOAT T2 ON T0."AgrNo" = T2."AbsID"
INNER JOIN OCRD T1 ON T2."BpCode" = T1."CardCode"
OAT1 OITB OAT1 T0 INNER JOIN OITB T1 ON T0.ItemGroup = T1.ItmsGrpCod
OAT1 OITB OAT1 T0 INNER JOIN OITB T1 ON T0."ItemGroup" = T1."ItmsGrpCod"
OAT1 OITM OAT1 T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode
OAT1 OITM OAT1 T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode"
OAT1 OOAT OAT1 T0 INNER JOIN OOAT T1 ON T0.AgrNo = T1.AbsID
OAT1 OOAT OAT1 T0 INNER JOIN OOAT T1 ON T0."AgrNo" = T1."AbsID"
OCLG

DLN1

OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ODLN T3 ON T2.CardCode = T3.CardCode
INNER JOIN DLN1 T1 ON T3.DocEntry = T1.DocEntry
OCLG

DLN1

OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN ODLN T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN DLN1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG

DPI1

OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ODPI T3 ON T2.CardCode = T3.CardCode
INNER JOIN DPI1 T1 ON T3.DocEntry = T1.DocEntry
OCLG

DPI1

OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN ODPI T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN DPI1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG

DPO1

OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ODPO T3 ON T2.CardCode = T3.CardCode
INNER JOIN DPO1 T1 ON T3.DocEntry = T1.DocEntry
OCLG

DPO1

OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN ODPO T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN DPO1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG

INV1

OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OINV T3 ON T2.CardCode = T3.CardCode
INNER JOIN INV1 T1 ON T3.DocEntry = T1.DocEntry
OCLG

INV1

OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN OINV T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN INV1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG OCLG OCLG T0
OCLG OCRD OCLG T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
OCLG OCRD OCLG T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"
OCLG ODLN OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ODLN T1 ON T2.CardCode = T1.CardCode
OCLG ODLN OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN ODLN T1 ON T2."CardCode" = T1."CardCode"
OCLG ODPI OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ODPI T1 ON T2.CardCode = T1.CardCode
OCLG ODPI OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN ODPI T1 ON T2."CardCode" = T1."CardCode"
OCLG ODPO OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ODPO T1 ON T2.CardCode = T1.CardCode
OCLG ODPO OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN ODPO T1 ON T2."CardCode" = T1."CardCode"
OCLG OINV OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OINV T1 ON T2.CardCode = T1.CardCode
OCLG OINV OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN OINV T1 ON T2."CardCode" = T1."CardCode"
OCLG OPCH OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPCH T1 ON T2.CardCode = T1.CardCode
OCLG OPCH OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN OPCH T1 ON T2."CardCode" = T1."CardCode"
OCLG OPDN OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPDN T1 ON T2.CardCode = T1.CardCode
OCLG OPDN OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN OPDN T1 ON T2."CardCode" = T1."CardCode"
OCLG OPOR OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPOR T1 ON T2.CardCode = T1.CardCode
OCLG OPOR OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN OPOR T1 ON T2."CardCode" = T1."CardCode"
OCLG OPQT OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPQT T1 ON T2.CardCode = T1.CardCode
OCLG OQUT OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OQUT T1 ON T2.CardCode = T1.CardCode
OCLG OQUT OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN OQUT T1 ON T2."CardCode" = T1."CardCode"
OCLG ORDR OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ORDR T1 ON T2.CardCode = T1.CardCode
OCLG ORDR OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN ORDR T1 ON T2."CardCode" = T1."CardCode"
OCLG PCH1 OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPCH T3 ON T2.CardCode = T3.CardCode
INNER JOIN PCH1 T1 ON T3.DocEntry = T1.DocEntry
OCLG PCH1 OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN OPCH T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN PCH1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG PDN1 OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPDN T3 ON T2.CardCode = T3.CardCode
INNER JOIN PDN1 T1 ON T3.DocEntry = T1.DocEntry
OCLG PDN1 OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN OPDN T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN PDN1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG POR1 OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPOR T3 ON T2.CardCode = T3.CardCode
INNER JOIN POR1 T1 ON T3.DocEntry = T1.DocEntry
OCLG POR1 OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN OPOR T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN POR1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG PQT1 OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OPQT T3 ON T2.CardCode = T3.CardCode
INNER JOIN PQT1 T1 ON T3.DocEntry = T1.DocEntry
OCLG QUT1 OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN OQUT T3 ON T2.CardCode = T3.CardCode
INNER JOIN QUT1 T1 ON T3.DocEntry = T1.DocEntry
OCLG QUT1 OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN OQUT T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN QUT1 T1 ON T3."DocEntry" = T1."DocEntry"
OCLG RDR1 OCLG T0 INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode
INNER JOIN ORDR T3 ON T2.CardCode = T3.CardCode
INNER JOIN RDR1 T1 ON T3.DocEntry = T1.DocEntry
OCLG RDR1 OCLG T0 INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN ORDR T3 ON T2."CardCode" = T3."CardCode"
INNER JOIN RDR1 T1 ON T3."DocEntry" = T1."DocEntry"
OCPN CPN1 OCPN T0 INNER JOIN CPN1 T1 ON T0.CpnNo = T1.CpnNo
OCPN CPN1 OCPN T0 INNER JOIN CPN1 T1 ON T0."CpnNo" = T1."CpnNo"
OCPN OCPN OCPN T0
OCPN OCRD OCPN T0 INNER JOIN CPN1 T2 ON T0.CpnNo = T2.CpnNo
INNER JOIN OCRD T1 ON T2.BpCode = T1.CardCode
OCPN OCRD OCPN T0 INNER JOIN CPN1 T2 ON T0."CpnNo" = T2."CpnNo"
INNER JOIN OCRD T1 ON T2."BpCode" = T1."CardCode"
OCPN OITM OCPN T0 INNER JOIN CPN2 T2 ON T0.CpnNo = T2.CpnNo
INNER JOIN OITM T1 ON T2.ItemCode = T1.ItemCode
OCPN OITM OCPN T0 INNER JOIN CPN2 T2 ON T0."CpnNo" = T2."CpnNo"
INNER JOIN OITM T1 ON T2."ItemCode" = T1."ItemCode"
OCPN OPRT OCPN T0 INNER JOIN CPN3 T2 ON T0.CpnNo = T2.CpnNo
INNER JOIN OPRT T1 ON T2.ParterId = T1.PrtId
OCPN OPRT OCPN T0 INNER JOIN CPN3 T2 ON T0."CpnNo" = T2."CpnNo"
INNER JOIN OPRT T1 ON T2."ParterId" = T1."PrtId"
OCPN OTGG OCPN T0 INNER JOIN OTGG T1 ON T0.TargetGrp = T1.TargetCode
OCPN OTGG OCPN T0 INNER JOIN OTGG T1 ON T0."TargetGrp" = T1."TargetCode"
OCPR DLN1 OCPR T0 INNER JOIN ODLN T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN DLN1 T1 ON T2.DocEntry = T1.DocEntry
OCPR DLN1 OCPR T0 INNER JOIN ODLN T2 ON T0."CntctCode" = T2."CntctCode"
 INNER JOIN DLN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR DPI1 OCPR T0 INNER JOIN ODPI T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN DPI1 T1 ON T2.DocEntry = T1.DocEntry
OCPR DPI1 OCPR T0 INNER JOIN ODPI T2 ON T0."CntctCode" = T2."CntctCode"
INNER JOIN DPI1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR DPO1 OCPR T0 INNER JOIN ODPO T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN DPO1 T1 ON T2.DocEntry = T1.DocEntry
OCPR DPO1 OCPR T0 INNER JOIN ODPO T2 ON T0."CntctCode" = T2."CntctCode"
INNER JOIN DPO1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR INV1 OCPR T0 INNER JOIN OINV T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN INV1 T1 ON T2.DocEntry = T1.DocEntry
OCPR INV1 OCPR T0 INNER JOIN OINV T2 ON T0."CntctCode" = T2."CntctCode"
INNER JOIN INV1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR OCPR OCPR T0
OCPR OCRD OCPR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
OCPR OCRD OCPR T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"
OCPR OCTR OCPR T0 INNER JOIN OCTR T1 ON T0.CntctCode = T1.CntctCode
OCPR OCTR OCPR T0 INNER JOIN OCTR T1 ON T0."CntctCode" = T1."CntctCode"
OCPR ODLN OCPR T0 INNER JOIN ODLN T1 ON T0.CntctCode = T1.CntctCode
OCPR ODLN OCPR T0 INNER JOIN ODLN T1 ON T0."CntctCode" = T1."CntctCode"
OCPR ODPI OCPR T0 INNER JOIN ODPI T1 ON T0.CntctCode = T1.CntctCode
OCPR ODPI OCPR T0 INNER JOIN ODPI T1 ON T0."CntctCode" = T1."CntctCode"
OCPR ODPO OCPR T0 INNER JOIN ODPO T1 ON T0.CntctCode = T1.CntctCode
OCPR ODPO OCPR T0 INNER JOIN ODPO T1 ON T0."CntctCode" = T1."CntctCode"
OCPR OINS OCPR T0 INNER JOIN OINS T1 ON T0.CntctCode = T1.contactCod
OCPR OINS OCPR T0 INNER JOIN OINS T1 ON T0."CntctCode" = T1."contactCod"
OCPR OINV OCPR T0 INNER JOIN OINV T1 ON T0.CntctCode = T1.CntctCode
OCPR OINV OCPR T0 INNER JOIN OINV T1 ON T0."CntctCode" = T1."CntctCode"
OCPR OPCH OCPR T0 INNER JOIN OPCH T1 ON T0.CntctCode = T1.CntctCode
OCPR OPCH OCPR T0 INNER JOIN OPCH T1 ON T0."CntctCode" = T1."CntctCode"
OCPR OPDN OCPR T0 INNER JOIN OPDN T1 ON T0.CntctCode = T1.CntctCode
OCPR OPDN OCPR T0 INNER JOIN OPDN T1 ON T0."CntctCode" = T1."CntctCode"
OCPR OPOR OCPR T0 INNER JOIN OPOR T1 ON T0.CntctCode = T1.CntctCode
OCPR OPOR OCPR T0 INNER JOIN OPOR T1 ON T0."CntctCode" = T1."CntctCode"
OCPR OPQT OCPR T0 INNER JOIN OPQT T1 ON T0.CntctCode = T1.CntctCode
OCPR OQUT OCPR T0 INNER JOIN OQUT T1 ON T0.CntctCode = T1.CntctCode
OCPR OQUT OCPR T0 INNER JOIN OQUT T1 ON T0."CntctCode" = T1."CntctCode"
OCPR ORDR OCPR T0 INNER JOIN ORDR T1 ON T0.CntctCode = T1.CntctCode
OCPR ORDR OCPR T0 INNER JOIN ORDR T1 ON T0."CntctCode" = T1."CntctCode"
OCPR OSCL OCPR T0 INNER JOIN OSCL T1 ON T0.CntctCode = T1.contctCode
OCPR OSCL OCPR T0 INNER JOIN OSCL T1 ON T0."CntctCode" = T1."contctCode"
OCPR PCH1 OCPR T0 INNER JOIN OPCH T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN PCH1 T1 ON T2.DocEntry = T1.DocEntry
OCPR PCH1 OCPR T0 INNER JOIN OPCH T2 ON T0."CntctCode" = T2."CntctCode"
INNER JOIN PCH1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR PDN1 OCPR T0 INNER JOIN OPDN T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN PDN1 T1 ON T2.DocEntry = T1.DocEntry
OCPR PDN1 OCPR T0 INNER JOIN OPDN T2 ON T0."CntctCode" = T2."CntctCode"
INNER JOIN PDN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR POR1 OCPR T0 INNER JOIN OPOR T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN POR1 T1 ON T2.DocEntry = T1.DocEntry
OCPR POR1 OCPR T0 INNER JOIN OPOR T2 ON T0."CntctCode" = T2."CntctCode"
INNER JOIN POR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR PQT1 OCPR T0 INNER JOIN OPQT T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN PQT1 T1 ON T2.DocEntry = T1.DocEntry
OCPR QUT1 OCPR T0 INNER JOIN OQUT T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN QUT1 T1 ON T2.DocEntry = T1.DocEntry
OCPR QUT1 OCPR T0 INNER JOIN OQUT T2 ON T0."CntctCode" = T2."CntctCode"
INNER JOIN QUT1 T1 ON T2."DocEntry" = T1."DocEntry"
OCPR RDR1 OCPR T0 INNER JOIN ORDR T2 ON T0.CntctCode = T2.CntctCode
INNER JOIN RDR1 T1 ON T2.DocEntry = T1.DocEntry
OCPR RDR1 OCPR T0 INNER JOIN ORDR T2 ON T0."CntctCode" = T2."CntctCode"
 INNER JOIN RDR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD CRD1 OCRD T0 INNER JOIN CRD1 T1 ON T0.CardCode = T1.CardCode
OCRD CRD1 OCRD T0 INNER JOIN CRD1 T1 ON T0."CardCode" = T1."CardCode"
OCRD CTR1 OCRD T0 INNER JOIN  OCTR T2 ON  T0.CardCode = T2.CstmrCode
INNER JOIN CTR1 T1 ON T1.ContractID = T2.ContractID
OCRD CTR1 OCRD T0 INNER JOIN OCTR T2 ON  T0."CardCode" = T2."CstmrCode"
INNER JOIN CTR1 T1 ON T1."ContractID" = T2."ContractID"
OCRD DLN1 OCRD T0 INNER JOIN ODLN T2 ON T0.CardCode = T2.CardCode
INNER JOIN DLN1 T1 ON T2.DocEntry = T1.DocEntry
OCRD DLN1 OCRD T0 INNER JOIN ODLN T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN DLN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD DPI1 OCRD T0 INNER JOIN ODPI T2 ON T0.CardCode = T2.CardCode
INNER JOIN DPI1 T1 ON T2.DocEntry = T1.DocEntry
OCRD DPI1 OCRD T0 INNER JOIN ODPI T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN DPI1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD DPO1 OCRD T0 INNER JOIN ODPO T2 ON T0.CardCode = T2.CardCode
INNER JOIN DPO1 T1 ON T2.DocEntry = T1.DocEntry
OCRD DPO1 OCRD T0 INNER JOIN ODPO T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN DPO1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD INV1 OCRD T0 INNER JOIN OINV T2 ON T0.CardCode = T2.CardCode
INNER JOIN INV1 T1 ON T2.DocEntry = T1.DocEntry
OCRD INV1 OCRD T0 INNER JOIN OINV T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN INV1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD JDT1 OCRD T0 INNER JOIN JDT1 T1 ON T1.ShortName = T0.CardCode
OCRD JDT1 OCRD T0 INNER JOIN JDT1 T1 ON T1."ShortName" = T0."CardCode"
OCRD OCLG OCRD T0 INNER JOIN OCLG T1 ON T0.CardCode = T1.CardCode
OCRD OCLG OCRD T0 INNER JOIN OCLG T1 ON T0."CardCode" = T1."CardCode"
OCRD OCPR OCRD T0 INNER JOIN OCPR T1 ON T0.CardCode = T1.CardCode
AND T0.CardCode = T1.CardCode
OCRD OCPR OCRD T0 INNER JOIN OCPR T1 ON T0."CardCode" = T1."CardCode"
AND T0."CardCode" = T1."CardCode"
OCRD OCRD OCRD T0
OCRD OCRG OCRG T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode
OCRD OCRG OCRG T0 INNER JOIN OCRG T1 ON T0."GroupCode" = T1."GroupCode"
OCRD OCTG OCRD T0 INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum
OCRD OCTG OCRD T0 INNER JOIN OCTG T1 ON T0."GroupNum" = T1."GroupNum"
OCRD OCTR OCRD T0 INNER JOIN OCTR T1 ON T0.CardCode = T1.CstmrCode
OCRD OCTR OCRD T0 INNER JOIN OCTR T1 ON T0."CardCode" = T1."CstmrCode"
OCRD ODLN OCRD T0 INNER JOIN ODLN T1 ON T0.CardCode = T1.CardCode
OCRD ODLN OCRD T0 INNER JOIN ODLN T1 ON T0."CardCode" = T1."CardCode"
OCRD ODPI OCRD T0 INNER JOIN ODPI T1 ON T0.CardCode = T1.CardCode
OCRD ODPI OCRD T0 INNER JOIN ODPI T1 ON T0."CardCode" = T1."CardCode"
OCRD ODPO OCRD T0 INNER JOIN ODPO T1 ON T0.CardCode = T1.CardCode
OCRD ODPO OCRD T0 INNER JOIN ODPO T1 ON T0."CardCode" = T1."CardCode"
OCRD OINS OCRD T0 INNER JOIN OINS T1 ON T0.CardCode = T1.customer
OCRD OINS OCRD T0 INNER JOIN OINS T1 ON T0."CardCode" = T1."customer"
OCRD OINV OCRD T0 INNER JOIN OINV T1 ON T0.CardCode = T1.CardCode
OCRD OINV OCRD T0 INNER JOIN OINV T1 ON T0."CardCode" = T1."CardCode"
OCRD OITM OCRD T0 INNER JOIN OITM T1 ON T0.CardCode = T1.CardCode
OCRD OITM OCRD T0 INNER JOIN OITM T1 ON T0."CardCode" = T1."CardCode"
OCRD OJDT OJDT T1 INNER JOIN JDT1 T2 ON T1.TransId = T2.TransId
INNER JOIN OCRD T0 ON T2.ShortName = T0.CardCode
OCRD OJDT OJDT T1 INNER JOIN JDT1 T2 ON T1."TransId" = T2."TransId"
INNER JOIN OCRD T0 ON T2."ShortName" = T0."CardCode"
OCRD OMRC OINM T2 INNER JOIN  OCRD T0 ON T2.CardCode = T0.CardCode
INNER JOIN  OMRC T1
INNER JOIN  OITM T3 ON T1.FirmCode = T3.FirmCode
ON T2.ItemCode = T3.ItemCode
OCRD OMRC OINM T2 INNER JOIN OCRD T0 ON T2."CardCode" = T0."CardCode"
INNER JOIN OMRC T1
INNER JOIN OITM T3 ON T1."FirmCode" = T3."FirmCode"
ON T2."ItemCode" = T3."ItemCode"
OCRD OPCH OCRD T0 INNER JOIN OPCH T1 ON T0.CardCode = T1.CardCode
OCRD OPCH OCRD T0 INNER JOIN OPCH T1 ON T0."CardCode" = T1."CardCode"
OCRD OPDN OCRD T0 INNER JOIN OPDN T1 ON T0.CardCode = T1.CardCode
OCRD OPDN OCRD T0 INNER JOIN OPDN T1 ON T0."CardCode" = T1."CardCode"
OCRD OPOR OCRD T0 INNER JOIN OPOR T1 ON T0.CardCode = T1.CardCode
OCRD OPOR OCRD T0 INNER JOIN OPOR T1 ON T0."CardCode" = T1."CardCode"
OCRD OPQT OCRD T0 INNER JOIN OPQT T1 ON T0.CardCode = T1.CardCode
OCRD OQUT OCRD T0 INNER JOIN OQUT T1 ON T0.CardCode = T1.CardCode
OCRD OQUT OCRD T0 INNER JOIN OQUT T1 ON T0."CardCode" = T1."CardCode"
OCRD ORDR OCRD T0 INNER JOIN ORDR T1 ON T0.CardCode = T1.CardCode
OCRD ORDR OCRD T0 INNER JOIN ORDR T1 ON T0."CardCode" = T1."CardCode"
OCRD OSCL OCRD T0 INNER JOIN OSCL T1 ON T0.CardCode = T1.customer
OCRD OSCL OCRD T0 INNER JOIN OSCL T1 ON T0."CardCode" = T1."customer"
OCRD OSLP OCRD T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
OCRD OSLP OCRD T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
OCRD PCH1 OCRD T0 INNER JOIN OPCH T2 ON T0.CardCode = T2.CardCode
INNER JOIN PCH1 T1 ON T2.DocEntry = T1.DocEntry
OCRD PCH1 OCRD T0 INNER JOIN OPCH T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN PCH1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD PDN1 OCRD T0 INNER JOIN OPDN T2 ON T0.CardCode = T2.CardCode
INNER JOIN PDN1 T1 ON T2.DocEntry = T1.DocEntry
OCRD PDN1 OCRD T0 INNER JOIN OPDN T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN PDN1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD POR1 OCRD T0 INNER JOIN OPOR T2 ON T0.CardCode = T2.CardCode
INNER JOIN POR1 T1 ON T2.DocEntry = T1.DocEntry
OCRD POR1 OCRD T0 INNER JOIN OPOR T2 ON T0."CardCode" = T2."CardCode"
INNER JOIN POR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD PQT1 OCRD T0 INNER JOIN OPQT T2 ON T0.CardCode = T2.CardCode
INNER JOIN PQT1 T1 ON T2.DocEntry = T1.DocEntry
OCRD QUT1 OCRD T0 INNER JOIN OQUT T2 ON T0.CardCode = T2.CardCode
INNER JOIN QUT1 T1 ON T2.DocEntry = T1.DocEntry
OCRD QUT1 OCRD T0 INNER JOIN OQUT T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN QUT1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRD RDR1 OCRD T0 INNER JOIN ORDR T2 ON T0.CardCode = T2.CardCode
INNER JOIN RDR1 T1 ON T2.DocEntry = T1.DocEntry
OCRD RDR1 OCRD T0 INNER JOIN ORDR T2 ON T0."CardCode" = T2."CardCode"
 INNER JOIN RDR1 T1 ON T2."DocEntry" = T1."DocEntry"
OCRG OCLG NULL
OCRG OCRD OCRG T0 INNER JOIN  OCRD T1 ON T0.GroupCode = T1.GroupCode
OCRG OCRD OCRG T0 INNER JOIN OCRD T1 ON T0."GroupCode" = T1."GroupCode"
OCRG OCRG OCRG T0
OCRG ODLN OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  ODLN T1 ON T2.CardCode = T1.CardCode
OCRG ODLN OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN ODLN T1 ON T2."CardCode" = T1."CardCode"
OCRG ODPI OCRG T0 INNER JOIN OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  ODPI T1 ON T2.CardCode = T1.CardCode
OCRG ODPI OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN ODPI T1 ON T2."CardCode" = T1."CardCode"
OCRG ODPO OCRG T0 INNER JOIN OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  ODPO T1 ON T2.CardCode = T1.CardCode
OCRG ODPO OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN ODPO T1 ON T2."CardCode" = T1."CardCode"
OCRG OINV OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  OINV T1 ON T2.CardCode = T1.CardCode
OCRG OINV OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
 INNER JOIN OINV T1 ON T2."CardCode" = T1."CardCode"
OCRG OPCH OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  OPCH T1 ON T2.CardCode = T1.CardCode
OCRG OPCH OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN OPCH T1 ON T2."CardCode" = T1."CardCode"
OCRG OPDN OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  OPDN T1 ON T2.CardCode = T1.CardCode
OCRG OPDN OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN OPDN T1 ON T2."CardCode" = T1."CardCode"
OCRG OPOR OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  OPOR T1 ON T2.CardCode = T1.CardCode
OCRG OPOR OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN OPOR T1 ON T2."CardCode" = T1."CardCode"
OCRG OPQT OCRG T0 INNER JOIN OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN OPQT T1 ON T2.CardCode = T1.CardCode
OCRG OQUT OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  OQUT T1 ON T2.CardCode = T1.CardCode
OCRG OQUT OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN OQUT T1 ON T2."CardCode" = T1."CardCode"
OCRG ORDN OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  ORDN T1 ON T2.CardCode = T1.CardCode
OCRG ORDN OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
 INNER JOIN ORDN T1 ON T2."CardCode" = T1."CardCode"
OCRG ORDR OCRG T0 INNER JOIN  OCRD T2 ON T0.GroupCode = T2.GroupCode
INNER JOIN  ORDR T1 ON T2.CardCode = T1.CardCode
OCRG ORDR OCRG T0 INNER JOIN OCRD T2 ON T0."GroupCode" = T2."GroupCode"
INNER JOIN ORDR T1 ON T2."CardCode" = T1."CardCode"
OCRG RDR1 NULL
OCTG OCRD OCTG T0 INNER JOIN OCRD T1 ON T0.GroupNum = T1.GroupNum
OCTG OCRD OCTG T0 INNER JOIN OCRD T1 ON T0."GroupNum" = T1."GroupNum"
OCTG OCTG OCTG T0
OCTG ODLN OCTG T0 INNER JOIN ODLN T1 ON T0.GroupNum = T1.GroupNum
OCTG ODLN OCTG T0 INNER JOIN ODLN T1 ON T0."GroupNum" = T1."GroupNum"
OCTG ODPI OCTG T0 INNER JOIN ODPI T1 ON T0.GroupNum = T1.GroupNum
OCTG ODPI OCTG T0 INNER JOIN ODPI T1 ON T0."GroupNum" = T1."GroupNum"
OCTG ODPO OCTG T0 INNER JOIN ODPO T1 ON T0.GroupNum = T1.GroupNum
OCTG ODPO OCTG T0 INNER JOIN ODPO T1 ON T0."GroupNum" = T1."GroupNum"
OCTG OINV OCTG T0 INNER JOIN OINV T1 ON T0.GroupNum = T1.GroupNum
OCTG OINV OCTG T0 INNER JOIN OINV T1 ON T0."GroupNum" = T1."GroupNum"
OCTG OPCH OCTG T0 INNER JOIN OPCH T1 ON T0.GroupNum = T1.GroupNum
OCTG OPCH OCTG T0 INNER JOIN OPCH T1 ON T0."GroupNum" = T1."GroupNum"
OCTG OPDN OCTG T0 INNER JOIN OPDN T1 ON T0.GroupNum = T1.GroupNum
OCTG OPDN OCTG T0 INNER JOIN OPDN T1 ON T0."GroupNum" = T1."GroupNum"
OCTG OPOR OCTG T0 INNER JOIN OPOR T1 ON T0.GroupNum = T1.GroupNum
OCTG OPOR OCTG T0 INNER JOIN OPOR T1 ON T0."GroupNum" = T1."GroupNum"
OCTG OPQT OCTG T0 INNER JOIN OPQT T1 ON T0.GroupNum = T1.GroupNum
OCTG OQUT OCTG T0 INNER JOIN OQUT T1 ON T0.GroupNum = T1.GroupNum
OCTG OQUT OCTG T0 INNER JOIN OQUT T1 ON T0."GroupNum" = T1."GroupNum"
OCTG ORDR OCTG T0 INNER JOIN ORDR T1 ON T0.GroupNum = T1.GroupNum
OCTG ORDR OCTG T0 INNER JOIN ORDR T1 ON T0."GroupNum" = T1."GroupNum"
OCTG RDR1 NULL
OCTR OCPR OCTR T0 INNER JOIN OCPR T1 ON T0.CntctCode = T1.CntctCode
OCTR OCPR OCTR T0 INNER JOIN OCPR T1 ON T0."CntctCode" = T1."CntctCode"
OCTR OCRD OCTR T0 INNER JOIN OCRD T1 ON T0.CstmrCode = T1.CardCode
OCTR OCRD OCTR T0 INNER JOIN OCRD T1 ON T0."CstmrCode" = T1."CardCode"
OCTR OCTR OCTR T0
OCTR OCTT OCTR T0 INNER JOIN OCTT T1 ON T0.CntrcTmplt = T1.TmpltName
OCTR OCTT OCTR T0 INNER JOIN OCTT T1 ON T0."CntrcTmplt" = T1."TmpltName"
OCTR OINS OCTR T0 INNER JOIN CTR1 T2 ON T0.ContractID = T2.ContractID
INNER JOIN OINS T1 ON T2.InsID = T1.insID
OCTR OINS OCTR T0 INNER JOIN CTR1 T2 ON T0."ContractID" = T2."ContractID"
INNER JOIN OINS T1 ON T2."InsID" = T1."insID"
OCTR OITB OCTR T0 INNER JOIN CTR1 T2 ON T0.ContractID = T2.ContractID
INNER JOIN OITB T1 ON T2.ItemGroup = T1.ItmsGrpCod
OCTR OITB OCTR T0 INNER JOIN CTR1 T2 ON T0."ContractID" = T2."ContractID"
INNER JOIN OITB T1 ON T2."ItemGroup" = T1."ItmsGrpCod"
OCTR OITM OCTR T0 INNER JOIN CTR1 T2 ON T0.ContractID = T2.ContractID
INNER JOIN OITM T1 ON T2.ItemCode = T1.ItemCode
OCTR OITM OCTR T0 INNER JOIN CTR1 T2 ON T0."ContractID" = T2."ContractID"
INNER JOIN OITM T1 ON T2."ItemCode" = T1."ItemCode"
OCTR OSCL OCTR T0 INNER JOIN OSCL T1 ON T0.ContractID = T1.contractID
OCTR OSCL OCTR T0 INNER JOIN OSCL T1 ON T0."ContractID" = T1."contractID"
OCTT OCTR OCTT T0 INNER JOIN OCTR T1 ON T0.TmpltName = T1.CntrcTmplt
OCTT OCTR OCTT T0 INNER JOIN OCTR T1 ON T0."TmpltName" = T1."CntrcTmplt"
OCTT OCTT OCTT T0

No comments:

Post a Comment