|
|
DTW Administration / System Initialization / Opening Balances / GL Accounts Opening Balance
API DATB
DATB - Data Archive Tax Balance Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Numerator | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LocCode | Location Code | Int | 11 | OLCT Location | ||||
| NfTaxId | ID of Nota Fiscal Tax Category | Int | 11 | ONFT Nota Fiscal Tax Category (Brazil) | ||||
| TaxComId | Tax Component ID | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| MatType | Material Type | Int | 11 | |||||
| ArchBal | Data Archived Balance | Num | 20 | |||||
| TaxAcct | Tax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| IsPLA | PLA Field | VarChar | 1 | |||||
| IsTaxCred | Tax Credit Field | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
