biuan SAP® BUSINESS ONE SDK
API OFAC
OFAC - Fixed Asset Parameter Change Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItemCodeItem No.nVarChar
20OITM
Items
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
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT OFAC.AbsEntry AS 'Internal Number', OFAC.ItemCode AS 'Item No.', OFAC.DataSource AS 'Data Source', OFAC.UserSign AS 'User Signature', OFAC.CreateDate AS 'Create Date', OFAC.UserSign2 AS 'Updating User', OFAC.UpdateDate AS 'Date of Update' FROM OFAC AS OFAC

Related information


OFAC SQL Table

Items OITM 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