Related Table in SAP Business One
Related Table in SAP Business One
Related Table In SAP BUSINESS ONE
Can function to help friends in Join Table.
Can function to help friends in 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 |