biuan SAP® BUSINESS ONE SDK
API AADT
AADT - Fixed Assets Account Determination - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
15
PRIMARYYes
DescrDescriptionnVarChar
100
BalanceActAsset Balance Sheet AccountnVarChar
15OACT
G/L Accounts
ClrAcqActAcquisition Clearing AccountnVarChar
15OACT
G/L Accounts
RevResvActRevaluation ReservenVarChar
15OACT
G/L Accounts
OrdDprActOrdinary DepreciationnVarChar
15OACT
G/L Accounts
OrdDprAccAccumulated Ordinary Depr.nVarChar
15OACT
G/L Accounts
UnpDprActUnplanned DepreciationnVarChar
15OACT
G/L Accounts
UnpDprAccAccumulated Unplanned Depr.nVarChar
15OACT
G/L Accounts
SpDprActSpecial DepreciationnVarChar
15OACT
G/L Accounts
SpDprAccAccumulated Special Depr.nVarChar
15OACT
G/L Accounts
SaRevNActRevenue from Asset Sales (Net)nVarChar
15OACT
G/L Accounts
ReExpNActRetirement with Expense (Net)nVarChar
15OACT
G/L Accounts
ReRevNActRetirement with Revenue (Net)nVarChar
15OACT
G/L Accounts
ReNBVeActNBV Retirement Expense (Gross)nVarChar
15OACT
G/L Accounts
ReNBVrActNBV Retirement Revenue (Gross)nVarChar
15OACT
G/L Accounts
ClrDscActCash Discount Clearing AccountnVarChar
15OACT
G/L Accounts
RevReActRevenue Account for RetirementnVarChar
15OACT
G/L Accounts
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6
UpdateDateDate of UpdateDate
8
ClearAccReRevenue Clearing AccountnVarChar
15OACT
G/L Accounts
RevResvClrRevaluation Reserve ClearingnVarChar
15OACT
G/L Accounts
SnapshotIdSnapshot IDInt
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



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