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 |
