biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Fixed Assets / Asset Classes
API Asset Class Collection / Asset Class Line
ACS1 - Asset Classes - Depreciation Areas Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
20OACS
Asset Classes
UNIQUEYes
LineNumLine NumberInt
11
DprAreaIDDepreciation Area IDnVarChar
15ODPA
Fixed Asset Depreciation Areas
ActiveActiveVarChar
Y) Yes
N) No
1
Y
AcctDtnAccount DeterminationnVarChar
15OADT
Fixed Assets Account Determination
DprTypIDDepreciation Type IDnVarChar
15ODTP
Fixed Assets Depreciation Types
UseLifeUseful LifeInt
11
LogInstancLog InstanceInt
11
0
SnapshotIdSnapshot IDInt
11
0

Table relationship map

SELECT statement

SELECT ACS1.Code AS 'Code', ACS1.LineNum AS 'Line Number', ACS1.DprAreaID AS 'Depreciation Area ID', ACS1.Active AS 'Active', ACS1.AcctDtn AS 'Account Determination', ACS1.DprTypID AS 'Depreciation Type ID', ACS1.UseLife AS 'Useful Life', ACS1.LogInstanc AS 'Log Instance', ACS1.SnapshotId AS 'Snapshot ID' FROM ACS1 AS ACS1

Related information


Asset Class Line AssetClassLine Object· Table: ACS1
AssetClassLine is a child object of AssetClass object and represents the depreciation area fields of an asset class. Source table: ACS1.
   Parent: Asset Class Collection AssetClassCollection Collection
Fixed Assets Account Determination OADT SQL Table

Asset Classes OACS SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Fixed Assets Depreciation Types ODTP SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates