|
|
DTW Administration / Setup / Financials / Fixed Assets / Account Determination / Fixed Assets Account Determination
API FA Account Determinations Service / FA Account Determination
OADT - Fixed Assets Account Determination Table
FA Account Determination FAAccountDetermination Object· Table: OADT
Parent: FA Account Determinations Service FAAccountDeterminationsService Service· Table: OADT
FA Account Determinations Service FAAccountDeterminationsService Service· Table: OADT
OADT SQL Table
G/L Accounts OACT SQL Table
Users OUSR SQL Table
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 | OUSR Users | ||||
| 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
OADT.Code AS 'Code',
OADT.Descr AS 'Description',
OADT.BalanceAct AS 'Asset Balance Sheet Account',
OADT.ClrAcqAct AS 'Acquisition Clearing Account',
OADT.RevResvAct AS 'Revaluation Reserve',
OADT.OrdDprAct AS 'Ordinary Depreciation',
OADT.OrdDprAcc AS 'Accumulated Ordinary Depr.',
OADT.UnpDprAct AS 'Unplanned Depreciation',
OADT.UnpDprAcc AS 'Accumulated Unplanned Depr.',
OADT.SpDprAct AS 'Special Depreciation',
OADT.SpDprAcc AS 'Accumulated Special Depr.',
OADT.SaRevNAct AS 'Revenue from Asset Sales (Net)',
OADT.ReExpNAct AS 'Retirement with Expense (Net)',
OADT.ReRevNAct AS 'Retirement with Revenue (Net)',
OADT.ReNBVeAct AS 'NBV Retirement Expense (Gross)',
OADT.ReNBVrAct AS 'NBV Retirement Revenue (Gross)',
OADT.ClrDscAct AS 'Cash Discount Clearing Account',
OADT.RevReAct AS 'Revenue Account for Retirement',
OADT.DataSource AS 'Data Source',
OADT.UserSign AS 'User Signature',
OADT.LogInstanc AS 'Log Instance',
OADT.CreateDate AS 'Creation Date',
OADT.UserSign2 AS 'Updating User',
OADT.UpdateDate AS 'Date of Update',
OADT.ClearAccRe AS 'Revenue Clearing Account',
OADT.RevResvClr AS 'Revaluation Reserve Clearing',
OADT.SnapshotId AS 'Snapshot ID'
FROM OADT AS OADT
Related information
FA Account Determination FAAccountDetermination Object· Table: OADT
Account determination enables the system to automatically determine the relevant general ledger accounts for a fixed asset when an asset transaction takes place.
SAP Business One lets you define multiple account determination sets. For each...
Parent: FA Account Determinations Service FAAccountDeterminationsService Service· Table: OADT FA Account Determinations Service FAAccountDeterminationsService Service· Table: OADT
The FAAccountDeterminationsService service enables you to define and view different sets of G/L accounts for your fixed assets.
Source table: OADT.
OADT SQL Table
G/L Accounts OACT SQL Table
Users OUSR SQL Table
FAAccountDeterminationsService
Object
FAAccountDetermination
Method
Property
AccumulatedOrdinaryDepr
DTW DB
AccumulatedSpecialDepr
DTW DB
AccumulatedUnplannedDepr
DTW DB
AssetBalanceSheetAccount
DTW DB
ClearingAccountAcquisition
DTW DB
Code
DTW DB
Description
DTW DB
LeavewithExpenseNBVGross
DTW DB
LeavewithRevenueNBVGross
DTW DB
OrdinaryDepreciation
DTW DB
RetirementwithExpenseNet
DTW DB
RetirementwithRevenueNet
DTW DB
RevaluationReserveAccount
DTW DB
RevaluationReserveClearing
DTW DB
RevenueAccountforRetirement
DTW DB
RevenueClearingAccount
DTW DB
RevenuefromAssetSalesNet
DTW DB
SpecialDepreciation
DTW DB
UnplannedDepreciation
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
