biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Fixed Assets / Attribute Groups
API Attribute Groups Service / Attribute Group
OFAA - Asset Attributes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
11
PRIMARYYes
Name KEY UNIQUENamenVarChar
100
NameYes
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
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
LockedLockedVarChar
Y) Yes
N) No
1
N
SnapshotIdSnapshot IDInt
11
0

Table relationship map

SELECT statement

SELECT OFAA.Code AS 'Code', OFAA.Name AS 'Name', OFAA.DataSource AS 'Data Source', OFAA.UserSign AS 'User Signature', OFAA.LogInstanc AS 'Log Instance', OFAA.CreateDate AS 'Creation Date', OFAA.UserSign2 AS 'Updating User', OFAA.UpdateDate AS 'Date of Update', OFAA.Locked AS 'Locked', OFAA.SnapshotId AS 'Snapshot ID' FROM OFAA AS OFAA

Related information


Attribute Group AttributeGroup Object· Table: OFAA
Source table: OFAA.
   Parent: Attribute Groups Service AttributeGroupsService Service
OFAA 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates