biuan SAP® BUSINESS ONE SDK
API WTR20
WTR20 - Intrastat Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OWTR
Inventory Transfer
PRIMARYYes
ExpnsCodeFreight CodeInt
11OEXD
Freight Setup
TotalLCTotalNum
20
TotalFCTotal (FC)Num
20
TotalSCTotal (SC)Num
20
DistribMDistribution MethodVarChar
Q) Quantity
V) Volume
W) Weight
E) Equally
T) Row Total
1
T
DrawnLCDrawn TotalNum
20
DrawnFCDrawn Total (FC)Num
20
DrawnSCDrawn Total (SC)Num
20
LineNumLine NumberInt
11
-1
BaseAbsEntBase Abs. EntryInt
11
-1
BaseTypeBase Document TypeInt
23) Sales Quotation
17) Sales Order
15) Delivery Notes
16) Return
13) A/R Invoice
203) Down Payment Incoming
204) Down Payment Outgoing
22) Purchase Order
20) Goods Receipt PO
21) Goods Return
18) A/P Invoice
540000006) Purchase Quotation
0
-1)
11
-1
BaseRefBase Document ReferenceInt
11
BaseLnNumBase Document Row No.Int
11
-1
LogInstancLog InstanceInt
11
0
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History
67
FixCurrFixation CurrencynVarChar
3OCRN
Currency Codes

Table relationship map

SELECT statement

SELECT WTR20.DocEntry AS 'Document Internal ID', WTR20.ExpnsCode AS 'Freight Code', WTR20.TotalLC AS 'Total', WTR20.TotalFC AS 'Total (FC)', WTR20.TotalSC AS 'Total (SC)', WTR20.DistribM AS 'Distribution Method', WTR20.DrawnLC AS 'Drawn Total', WTR20.DrawnFC AS 'Drawn Total (FC)', WTR20.DrawnSC AS 'Drawn Total (SC)', WTR20.LineNum AS 'Line Number', WTR20.BaseAbsEnt AS 'Base Abs. Entry', WTR20.BaseType AS 'Base Document Type', WTR20.BaseRef AS 'Base Document Reference', WTR20.BaseLnNum AS 'Base Document Row No.', WTR20.LogInstanc AS 'Log Instance', WTR20.ObjectType AS 'Object Type', WTR20.FixCurr AS 'Fixation Currency' FROM WTR20 AS WTR20

Related information


Inventory Transfer OWTR SQL Table

Freight Setup OEXD SQL Table

Currency Codes OCRN 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