biuan SAP® BUSINESS ONE SDK
API FAM1
FAM1 - Fixed Asset Data Migration - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizardId KEY UNIQUEWizard IDInt
11OFAM
Fixed Asset Data Migration
PRIMARYYes
LineNumLine NumberInt
11
ObjectTypeObject TypenVarChar
1470000002) Account Determination
1470000003) Depreciation Areas
1470000004) Depreciation Type Pools
1470000000) Depreciation Types
1470000032) Asset Classes
4) Items
35) Item Numbering
20
ObjectCodeObject CodenVarChar
20
ObjectNameObject NamenVarChar
100
StatusStatusVarChar
Y) Successful
N) Failed
1
Y
MessageMessagenVarChar
127

SELECT statement

SELECT FAM1.WizardId AS 'Wizard ID', FAM1.LineNum AS 'Line Number', FAM1.ObjectType AS 'Object Type', FAM1.ObjectCode AS 'Object Code', FAM1.ObjectName AS 'Object Name', FAM1.Status AS 'Status', FAM1.Message AS 'Message' FROM FAM1 AS FAM1

Related information


Fixed Asset Data Migration OFAM 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