biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / Opening Balances / GL Accounts Opening Balance
API DATB
DATB - Data Archive Tax Balance Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUENumeratorInt
11
PRIMARYYes
LocCodeLocation CodeInt
11OLCT
Location
NfTaxIdID of Nota Fiscal Tax CategoryInt
11ONFT
Nota Fiscal Tax Category (Brazil)
TaxComIdTax Component IDInt
11OSTT
Sales Tax Authorities Type
MatTypeMaterial TypeInt
11
ArchBalData Archived BalanceNum
20
TaxAcctTax AccountnVarChar
15OACT
G/L Accounts
IsPLAPLA FieldVarChar
1
IsTaxCredTax Credit FieldVarChar
1

Table relationship map

SELECT statement

SELECT DATB.AbsEntry AS 'Numerator', DATB.LocCode AS 'Location Code', DATB.NfTaxId AS 'ID of Nota Fiscal Tax Category', DATB.TaxComId AS 'Tax Component ID', DATB.MatType AS 'Material Type', DATB.ArchBal AS 'Data Archived Balance', DATB.TaxAcct AS 'Tax Account', DATB.IsPLA AS 'PLA Field', DATB.IsTaxCred AS 'Tax Credit Field' FROM DATB AS DATB

Related information


Location OLCT SQL Table

Nota Fiscal Tax Category (Brazil) ONFT SQL Table

G/L Accounts OACT SQL Table

Sales Tax Authorities Type OSTT SQL Table



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