biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inv. Transfer Request - Drawn Dpm Det.
API WTQ11
WTQ11 - Inv. Transfer Request - Drawn Dpm Det. Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal Document IDInt
11OWTQ
Inventory Transfer Request		PRIMARYYes
LineNumRow NumberInt
11
LineSeqSequence NumberInt
11
BaseAbsBase Document Internal IDInt
11
BaseTypeBase Object TypeInt
-1)
11
-1
VatGroupVAT Group CodenVarChar
8OVTG
Tax Definition
VatPrcntVAT PercentNum
20
LineTotalNet LCNum
20
TotalFrgnNet FCNum
20
TotalSumSyNet SCNum
20
VatSumTax LCNum
20
VatSumFrgnTax FCNum
20
VatSumSysTax SCNum
20
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		1250000001
LogInstancLog InstanceInt
11
IsAcqAcquisition Tax LiableVarChar
N) No
Y) Yes
1
N
IsAllDrawnRemaining Amount DrawnVarChar
Y) Yes
N) No
1
N
IsGrossIs Gross LineVarChar
N) Net Line
Y) Gross Line
1
N
GrossGross LCNum
20
GrossFcGross FCNum
20
GrossScGross SCNum
20
ApplNetApplied Net LCNum
20
ApplNetFcApplied Net FCNum
20
ApplNetScApplied Net SCNum
20
ApplVatApplied Tax LCNum
20
ApplVatFcApplied Tax FCNum
20
ApplVatScApplied Tax SCNum
20
BaseNetBase Net LCNum
20
BaseNetFcBase Net FCNum
20
BaseNetScBase Net SCNum
20
BaseVatBase Tax LCNum
20
BaseVatFcBase Tax FCNum
20
BaseVatScBase Tax SCNum
20
BaseGrossBase Gross LCNum
20
BaseGrossFBase Gross FCNum
20
BaseGrossSBase Gross SCNum
20
LineTypeLine TypeVarChar
D) Document Row
R) Currency Rounding
H) Down Payment Document Rounding
1
D
DctSumDeductible Sum (LC)Num
20
DctSumFcDeductible Sum (FC)Num
20
DctSumScDeductible Sum (SC)Num
20
EqSumEqualization Sum LCNum
20
EqSumFcEqualization Sum FCNum
20
EqSumScEqualization Sum SCNum
20
ApplDctApplied Deductible Sum (LC)Num
20
ApplDctFcApplied Deductible Sum (FC)Num
20
ApplDctScApplied Deductible Sum (SC)Num
20
ApplEqApplied Equalization Sum LCNum
20
ApplEqFcApplied Equalization Sum FCNum
20
ApplEqScApplied Equalization Sum SCNum
20
BaseDctBase Deductible Sum (LC)Num
20
BaseDctFcBase Deductible Sum (FC)Num
20
BaseDctScBase Deductible Sum (SC)Num
20
BaseEqBase Equalization Sum LCNum
20
BaseEqFcBase Equalization Sum FCNum
20
BaseEqScBase Equalization Sum SCNum
20
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
ApplGrossApplied Gross LCNum
20
ApplGrossFApplied Gross FCNum
20
ApplGrossSApplied Gross SCNum
20
TaxAdjustManual Tax AdjustmentVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT WTQ11.DocEntry AS 'Internal Document ID', WTQ11.LineNum AS 'Row Number', WTQ11.LineSeq AS 'Sequence Number', WTQ11.BaseAbs AS 'Base Document Internal ID', WTQ11.BaseType AS 'Base Object Type', WTQ11.VatGroup AS 'VAT Group Code', WTQ11.VatPrcnt AS 'VAT Percent', WTQ11.LineTotal AS 'Net LC', WTQ11.TotalFrgn AS 'Net FC', WTQ11.TotalSumSy AS 'Net SC', WTQ11.VatSum AS 'Tax LC', WTQ11.VatSumFrgn AS 'Tax FC', WTQ11.VatSumSys AS 'Tax SC', WTQ11.ObjType AS 'Object Type', WTQ11.LogInstanc AS 'Log Instance', WTQ11.IsAcq AS 'Acquisition Tax Liable', WTQ11.IsAllDrawn AS 'Remaining Amount Drawn', WTQ11.IsGross AS 'Is Gross Line', WTQ11.Gross AS 'Gross LC', WTQ11.GrossFc AS 'Gross FC', WTQ11.GrossSc AS 'Gross SC', WTQ11.ApplNet AS 'Applied Net LC', WTQ11.ApplNetFc AS 'Applied Net FC', WTQ11.ApplNetSc AS 'Applied Net SC', WTQ11.ApplVat AS 'Applied Tax LC', WTQ11.ApplVatFc AS 'Applied Tax FC', WTQ11.ApplVatSc AS 'Applied Tax SC', WTQ11.BaseNet AS 'Base Net LC', WTQ11.BaseNetFc AS 'Base Net FC', WTQ11.BaseNetSc AS 'Base Net SC', WTQ11.BaseVat AS 'Base Tax LC', WTQ11.BaseVatFc AS 'Base Tax FC', WTQ11.BaseVatSc AS 'Base Tax SC', WTQ11.BaseGross AS 'Base Gross LC', WTQ11.BaseGrossF AS 'Base Gross FC', WTQ11.BaseGrossS AS 'Base Gross SC', WTQ11.LineType AS 'Line Type', WTQ11.DctSum AS 'Deductible Sum (LC)', WTQ11.DctSumFc AS 'Deductible Sum (FC)', WTQ11.DctSumSc AS 'Deductible Sum (SC)', WTQ11.EqSum AS 'Equalization Sum LC', WTQ11.EqSumFc AS 'Equalization Sum FC', WTQ11.EqSumSc AS 'Equalization Sum SC', WTQ11.ApplDct AS 'Applied Deductible Sum (LC)', WTQ11.ApplDctFc AS 'Applied Deductible Sum (FC)', WTQ11.ApplDctSc AS 'Applied Deductible Sum (SC)', WTQ11.ApplEq AS 'Applied Equalization Sum LC', WTQ11.ApplEqFc AS 'Applied Equalization Sum FC', WTQ11.ApplEqSc AS 'Applied Equalization Sum SC', WTQ11.BaseDct AS 'Base Deductible Sum (LC)', WTQ11.BaseDctFc AS 'Base Deductible Sum (FC)', WTQ11.BaseDctSc AS 'Base Deductible Sum (SC)', WTQ11.BaseEq AS 'Base Equalization Sum LC', WTQ11.BaseEqFc AS 'Base Equalization Sum FC', WTQ11.BaseEqSc AS 'Base Equalization Sum SC', WTQ11.TaxCode AS 'Tax Code', WTQ11.ApplGross AS 'Applied Gross LC', WTQ11.ApplGrossF AS 'Applied Gross FC', WTQ11.ApplGrossS AS 'Applied Gross SC', WTQ11.TaxAdjust AS 'Manual Tax Adjustment' FROM WTQ11 AS WTQ11

Related information


Inventory Transfer Request OWTQ SQL Table

Object Settings - History ADP1 SQL Table

Sales Tax Codes OSTC SQL Table

Tax Definition OVTG SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates