| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Administration / System Initialization / Opening Balances / GL Accounts Opening Balance API DATB | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DATB - Data Archive Tax Balance Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationLocation 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. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |