biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Fixed Assets / Asset Classes / Asset Classes
API Asset Classes Service / Asset Class
OACS - Asset Classes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
20
PRIMARYYes
NameNamenVarChar
100
AssetTypeAsset TypeVarChar
G) General
L) Low Value Asset
1
G
LimitFromValue Limit FromNum
20
LimitToValue Limit ToNum
20
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
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
BPLIdBranchInt
11OBPL
Business Place
AttrGrpAttribute GroupInt
11OFAA
Asset Attributes
-1
SnapshotIdSnapshot IDInt
11
0

Table relationship map

SELECT statement

SELECT OACS.Code AS 'Code', OACS.Name AS 'Name', OACS.AssetType AS 'Asset Type', OACS.LimitFrom AS 'Value Limit From', OACS.LimitTo AS 'Value Limit To', OACS.DataSource AS 'Data Source', OACS.UserSign AS 'User Signature', OACS.LogInstanc AS 'Log Instance', OACS.CreateDate AS 'Create Date', OACS.UserSign2 AS 'Updating User', OACS.UpdateDate AS 'Date of Update', OACS.BPLId AS 'Branch', OACS.AttrGrp AS 'Attribute Group', OACS.SnapshotId AS 'Snapshot ID' FROM OACS AS OACS

Related information


Asset Class AssetClass Object· Table: OACS
With SAP Business One, you can use asset classes to classify fixed assets according to business and legal requirements. For each asset class, you can assign various depreciation areas and depreciation types. After you assign an asset class to an...
   Parent: Asset Classes Service AssetClassesService Service· Table: OACS

Asset Classes Service AssetClassesService Service· Table: OACS
The AssetClassesService service enables you to create, update and view asset classes. Source table: OACS.

OACS SQL Table

Asset Attributes OFAA SQL Table

Business Place OBPL 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