biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Fixed Assets / Attribute Groups
API Attribute Group Collection / Attribute Group Line
FAA1 - Asset Attributes - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
11OFAA
Asset Attributes
UNIQUEYes
LineNumRow NumberInt
11
AttrIDAttribute IDInt
11
AttrNameAttribute NamenVarChar
100
FieldTypeField TypeVarChar
A) Text
N) Numeric
D) Date
S) Amount
P) Price
Q) Quantity
1
DefaultValDefault ValuenVarChar
100
LogInstancLog InstanceInt
11
0
SnapshotIdSnapshot IDInt
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 Collection
Asset Attributes OFAA 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