|
|
DTW Administration / Setup / Financials / Fixed Assets / Attribute Groups
API Attribute Group Collection / Attribute Group Line
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | Int | 11 | OFAA Asset Attributes | UNIQUE | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| AttrID | Attribute ID | Int | 11 | |||||
| AttrName | Attribute Name | nVarChar | 100 | |||||
| FieldType | Field Type | VarChar | A) Text N) Numeric D) Date S) Amount P) Price Q) Quantity | 1 | ||||
| DefaultVal | Default Value | nVarChar | 100 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| SnapshotId | Snapshot ID | Int | 11 | 0 |
SELECT statement
SELECT
FAA1.Code AS 'Code',
FAA1.LineNum AS 'Row Number',
FAA1.AttrID AS 'Attribute ID',
FAA1.AttrName AS 'Attribute Name',
FAA1.FieldType AS 'Field Type',
FAA1.DefaultVal AS 'Default Value',
FAA1.LogInstanc AS 'Log Instance',
FAA1.SnapshotId AS 'Snapshot ID'
FROM FAA1 AS FAA1
Related information
Attribute Group Line AttributeGroupLine Object· Table: FAA1
Source table: FAA1.
Parent: Attribute Group Collection AttributeGroupCollection CollectionAsset Attributes OFAA SQL Table
AttributeGroupCollection
Object
AttributeGroupLine
Enumeration
Method
Property
AttributeID
DB
Code
DB
DefaultValue
DB
FieldType
DB
SortNumber
DB
Method
Property
Code
9.0 DB
Description
9.0 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates