biuan SAP® BUSINESS ONE SDK
SQL Inventory Transfer - Tax Extension
DTW Inventory Transfer - Tax Extension
API Stock Transfer Tax Extension / Form Number
WTR12 - Inventory Transfer - Tax Extension Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OWTR
Inventory Transfer		PRIMARYYes
TaxId0Tax ID 0nVarChar
100
TaxId1Tax ID 1nVarChar
100
TaxId2Tax ID 2nVarChar
100
TaxId3Tax ID 3nVarChar
100
TaxId4Tax ID 4nVarChar
100
TaxId5Tax ID 5nVarChar
100
TaxId6Tax ID 6nVarChar
100
TaxId7Tax ID 7nVarChar
100
TaxId8Tax ID 8nVarChar
100
TaxId9Tax ID 9nVarChar
100
StateState CodenVarChar
3
CountyCounty CodenVarChar
7
IncotermsIncotermsnVarChar
3
VehicleVehicle IDnVarChar
10
VidStateVehicle ID (State)nVarChar
3
NfRefNota Fiscal ReferencenVarChar
127
CarrierCarrier CodenVarChar
15
QoPQuantity of PacksInt
11
PackDescPack DescriptionnVarChar
10
BrandBrandnVarChar
20
NoSUNumber of Shipping UnitInt
11
NetWeightNet WeightNum
20
GrsWeightGross WeightNum
20
LogInstancLog InstanceInt
11
0
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History		67
TaxId10Tax ID 10nVarChar
100
TransCatTransaction CategorynVarChar
100
FormNoForm No.nVarChar
100
TaxId11Tax ID 11nVarChar
100
StreetSStreetnVarChar
100
BlockSBlocknVarChar
100
BuildingSBuilding/Floor/RoomText
16
CitySCitynVarChar
100
ZipCodeSZip CodenVarChar
20
CountySCountynVarChar
100
StateSStatenVarChar
3OCST
States
CountrySCountrynVarChar
3OCRY
Countries
AddrTypeSAddress TypenVarChar
100
StreetNoSStreet No.nVarChar
100
StreetBStreetnVarChar
100
BlockBBlocknVarChar
100
BuildingBBuilding/Floor/RoomText
16
CityBCitynVarChar
100
ZipCodeBZip CodenVarChar
20
CountyBCountynVarChar
100
StateBStatenVarChar
3OCST
States
CountryBCountrynVarChar
3OCRY
Countries
AddrTypeBAddress TypenVarChar
100
StreetNoBStreet No.nVarChar
100
ImpORExpImport or ExportVarChar
N)
Y)
1
VatVATVarChar
N) No VAT Support
Y) VAT Support
1
N
AltCrdNamBAlternative BP NamenVarChar
100
AltTaxIdBAlternative Tax IDnVarChar
32
Address2SAddress Name 2nVarChar
50
Address3SAddress Name 3nVarChar
50
Address2BAddress Name 2nVarChar
50
Address3BAddress Name 3nVarChar
50
MainUsageMain Usage Code of DocumentInt
11OUSG
Usage of Nota Fiscal
GlbLocNumSGlobal Location NumbernVarChar
50
GlbLocNumBGlobal Location NumbernVarChar
50
CollectDTDate and Time of CollectionnVarChar
20
TransprtDTTransport Starting DateDate
8
TransprtRSTransport ReasonnVarChar
100
TaxId12Tax ID 12nVarChar
50
TaxId13Deductee Ref. No. in IndianVarChar
100

Table relationship map

SELECT statement

SELECT WTR12.DocEntry AS 'Document Internal ID', WTR12.TaxId0 AS 'Tax ID 0', WTR12.TaxId1 AS 'Tax ID 1', WTR12.TaxId2 AS 'Tax ID 2', WTR12.TaxId3 AS 'Tax ID 3', WTR12.TaxId4 AS 'Tax ID 4', WTR12.TaxId5 AS 'Tax ID 5', WTR12.TaxId6 AS 'Tax ID 6', WTR12.TaxId7 AS 'Tax ID 7', WTR12.TaxId8 AS 'Tax ID 8', WTR12.TaxId9 AS 'Tax ID 9', WTR12.State AS 'State Code', WTR12.County AS 'County Code', WTR12.Incoterms AS 'Incoterms', WTR12.Vehicle AS 'Vehicle ID', WTR12.VidState AS 'Vehicle ID (State)', WTR12.NfRef AS 'Nota Fiscal Reference', WTR12.Carrier AS 'Carrier Code', WTR12.QoP AS 'Quantity of Packs', WTR12.PackDesc AS 'Pack Description', WTR12.Brand AS 'Brand', WTR12.NoSU AS 'Number of Shipping Unit', WTR12.NetWeight AS 'Net Weight', WTR12.GrsWeight AS 'Gross Weight', WTR12.LogInstanc AS 'Log Instance', WTR12.ObjectType AS 'Object Type', WTR12.TaxId10 AS 'Tax ID 10', WTR12.TransCat AS 'Transaction Category', WTR12.FormNo AS 'Form No.', WTR12.TaxId11 AS 'Tax ID 11', WTR12.StreetS AS 'Street', WTR12.BlockS AS 'Block', WTR12.BuildingS AS 'Building/Floor/Room', WTR12.CityS AS 'City', WTR12.ZipCodeS AS 'Zip Code', WTR12.CountyS AS 'County', WTR12.StateS AS 'State', WTR12.CountryS AS 'Country', WTR12.AddrTypeS AS 'Address Type', WTR12.StreetNoS AS 'Street No.', WTR12.StreetB AS 'Street', WTR12.BlockB AS 'Block', WTR12.BuildingB AS 'Building/Floor/Room', WTR12.CityB AS 'City', WTR12.ZipCodeB AS 'Zip Code', WTR12.CountyB AS 'County', WTR12.StateB AS 'State', WTR12.CountryB AS 'Country', WTR12.AddrTypeB AS 'Address Type', WTR12.StreetNoB AS 'Street No.', WTR12.ImpORExp AS 'Import or Export', WTR12.Vat AS 'VAT', WTR12.AltCrdNamB AS 'Alternative BP Name', WTR12.AltTaxIdB AS 'Alternative Tax ID', WTR12.Address2S AS 'Address Name 2', WTR12.Address3S AS 'Address Name 3', WTR12.Address2B AS 'Address Name 2', WTR12.Address3B AS 'Address Name 3', WTR12.MainUsage AS 'Main Usage Code of Document', WTR12.GlbLocNumS AS 'Global Location Number', WTR12.GlbLocNumB AS 'Global Location Number', WTR12.CollectDT AS 'Date and Time of Collection', WTR12.TransprtDT AS 'Transport Starting Date', WTR12.TransprtRS AS 'Transport Reason', WTR12.TaxId12 AS 'Tax ID 12', WTR12.TaxId13 AS 'Deductee Ref. No. in India' FROM WTR12 AS WTR12

Related information


Form Number FormNumber Property· Table: WTR12
Sets or returns the form number used for the transaction category in Warehouse Transfer. Field name: FormNo.
· Table: WTR12 WTQ12    Parent: Stock Transfer Tax Extension StockTransfer_TaxExtension Object· Table: WTR12 WTQ12
Countries OCRY SQL Table

Inventory Transfer OWTR SQL Table

Usage of Nota Fiscal OUSG SQL Table

Object Settings - History ADP1 SQL Table

States OCST 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