biuan SAP® BUSINESS ONE SDK
API WTQ9
WTQ9 - Inventory Transfer Request - Drawn DPM Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal Document IDInt
11OWTQ
Inventory Transfer Request
PRIMARYYes
LineNumRow NumberInt
11
BaseAbsBase Document Internal IDInt
11
BaseLineBase Document RowInt
11
TargetBaseTarget or Base DocumentVarChar
B) Base
T) Target
1
B
ObjTypeBase Object TypenVarChar
20
DrawnSumNet LCNum
20
DrawnSumFcNet FCNum
20
DrawnSumScNet SCNum
20
LogInstancLog InstanceInt
11
0
ObjCodeObject TypenVarChar
20ADP1
Object Settings - History
1250000001
ApplDrawnApplied Net LCNum
20
ApplDrawnFApplied Net FCNum
20
ApplDrawnSApplied Net SCNum
20
BaseDocNumBase Document NumberInt
11
BsDocDateBase Posting DateDate
8
BsDueDateBase Due DateDate
8
BsCardNameBase BP NamenVarChar
100
BsCommentsBase RemarksnVarChar
127
PostedBase Document PostedVarChar
Y) Yes
N) No
1
Y
VatTax LCNum
20
VatFcTax FCNum
20
VatScTax SCNum
20
GrossGross LCNum
20
GrossFcGross FCNum
20
GrossScGross SCNum
20
IsGrossIs Gross LineVarChar
N) Net Line
Y) Gross Line
1
N

Table relationship map

SELECT statement

SELECT WTQ9.DocEntry AS 'Internal Document ID', WTQ9.LineNum AS 'Row Number', WTQ9.BaseAbs AS 'Base Document Internal ID', WTQ9.BaseLine AS 'Base Document Row', WTQ9.TargetBase AS 'Target or Base Document', WTQ9.ObjType AS 'Base Object Type', WTQ9.DrawnSum AS 'Net LC', WTQ9.DrawnSumFc AS 'Net FC', WTQ9.DrawnSumSc AS 'Net SC', WTQ9.LogInstanc AS 'Log Instance', WTQ9.ObjCode AS 'Object Type', WTQ9.ApplDrawn AS 'Applied Net LC', WTQ9.ApplDrawnF AS 'Applied Net FC', WTQ9.ApplDrawnS AS 'Applied Net SC', WTQ9.BaseDocNum AS 'Base Document Number', WTQ9.BsDocDate AS 'Base Posting Date', WTQ9.BsDueDate AS 'Base Due Date', WTQ9.BsCardName AS 'Base BP Name', WTQ9.BsComments AS 'Base Remarks', WTQ9.Posted AS 'Base Document Posted', WTQ9.Vat AS 'Tax LC', WTQ9.VatFc AS 'Tax FC', WTQ9.VatSc AS 'Tax SC', WTQ9.Gross AS 'Gross LC', WTQ9.GrossFc AS 'Gross FC', WTQ9.GrossSc AS 'Gross SC', WTQ9.IsGross AS 'Is Gross Line' FROM WTQ9 AS WTQ9

Related information


Inventory Transfer Request OWTQ SQL Table

Object Settings - History ADP1 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