|
|
API AADT
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 15 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Descr | Description | nVarChar | 100 | |||||
| BalanceAct | Asset Balance Sheet Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ClrAcqAct | Acquisition Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| RevResvAct | Revaluation Reserve | nVarChar | 15 | OACT G/L Accounts | ||||
| OrdDprAct | Ordinary Depreciation | nVarChar | 15 | OACT G/L Accounts | ||||
| OrdDprAcc | Accumulated Ordinary Depr. | nVarChar | 15 | OACT G/L Accounts | ||||
| UnpDprAct | Unplanned Depreciation | nVarChar | 15 | OACT G/L Accounts | ||||
| UnpDprAcc | Accumulated Unplanned Depr. | nVarChar | 15 | OACT G/L Accounts | ||||
| SpDprAct | Special Depreciation | nVarChar | 15 | OACT G/L Accounts | ||||
| SpDprAcc | Accumulated Special Depr. | nVarChar | 15 | OACT G/L Accounts | ||||
| SaRevNAct | Revenue from Asset Sales (Net) | nVarChar | 15 | OACT G/L Accounts | ||||
| ReExpNAct | Retirement with Expense (Net) | nVarChar | 15 | OACT G/L Accounts | ||||
| ReRevNAct | Retirement with Revenue (Net) | nVarChar | 15 | OACT G/L Accounts | ||||
| ReNBVeAct | NBV Retirement Expense (Gross) | nVarChar | 15 | OACT G/L Accounts | ||||
| ReNBVrAct | NBV Retirement Revenue (Gross) | nVarChar | 15 | OACT G/L Accounts | ||||
| ClrDscAct | Cash Discount Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| RevReAct | Revenue Account for Retirement | nVarChar | 15 | OACT G/L Accounts | ||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| ClearAccRe | Revenue Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| RevResvClr | Revaluation Reserve Clearing | nVarChar | 15 | OACT G/L Accounts | ||||
| SnapshotId | Snapshot ID | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
AADT.Code AS 'Code',
AADT.Descr AS 'Description',
AADT.BalanceAct AS 'Asset Balance Sheet Account',
AADT.ClrAcqAct AS 'Acquisition Clearing Account',
AADT.RevResvAct AS 'Revaluation Reserve',
AADT.OrdDprAct AS 'Ordinary Depreciation',
AADT.OrdDprAcc AS 'Accumulated Ordinary Depr.',
AADT.UnpDprAct AS 'Unplanned Depreciation',
AADT.UnpDprAcc AS 'Accumulated Unplanned Depr.',
AADT.SpDprAct AS 'Special Depreciation',
AADT.SpDprAcc AS 'Accumulated Special Depr.',
AADT.SaRevNAct AS 'Revenue from Asset Sales (Net)',
AADT.ReExpNAct AS 'Retirement with Expense (Net)',
AADT.ReRevNAct AS 'Retirement with Revenue (Net)',
AADT.ReNBVeAct AS 'NBV Retirement Expense (Gross)',
AADT.ReNBVrAct AS 'NBV Retirement Revenue (Gross)',
AADT.ClrDscAct AS 'Cash Discount Clearing Account',
AADT.RevReAct AS 'Revenue Account for Retirement',
AADT.DataSource AS 'Data Source',
AADT.UserSign AS 'User Signature',
AADT.LogInstanc AS 'Log Instance',
AADT.CreateDate AS 'Creation Date',
AADT.UserSign2 AS 'Updating User',
AADT.UpdateDate AS 'Date of Update',
AADT.ClearAccRe AS 'Revenue Clearing Account',
AADT.RevResvClr AS 'Revaluation Reserve Clearing',
AADT.SnapshotId AS 'Snapshot ID'
FROM AADT AS AADT
Related information
G/L Accounts OACT SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates