|
|
DTW Administration / Setup / Financials / Fixed Assets / Asset Classes / Asset Classes
API Asset Classes Service / Asset Class
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 100 | |||||
| AssetType | Asset Type | VarChar | G) General L) Low Value Asset | 1 | G | |||
| LimitFrom | Value Limit From | Num | 20 | |||||
| LimitTo | Value Limit To | Num | 20 | |||||
| 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 | Create Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| AttrGrp | Attribute Group | Int | 11 | OFAA Asset Attributes | -1 | |||
| SnapshotId | Snapshot ID | Int | 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
AssetClassesService
Object
AssetClass
Collection
Enumeration
Method
Property
AssetType
DTW DB
AttributeGroup
DTW DB
BPLID
DTW DB
Code
DTW DB
Description
DTW DB
ValueLimitFrom
DTW DB
ValueLimitTo
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates