| 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 |
Komentar
Posting Komentar