FAM1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Finance / Fixed Asset Data Migration - Rows

API FAM1

FAM1 - Fixed Asset Data Migration - Rows Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
WizardId ^KEY ^UNIQUE	Wizard ID	Int		11	OFAM Fixed Asset Data Migration		PRIMARY	Yes
LineNum	Line Number	Int		11
ObjectType	Object Type	nVarChar	1470000002) Account Determination 1470000003) Depreciation Areas 1470000004) Depreciation Type Pools 1470000000) Depreciation Types 1470000032) Asset Classes 4) Items 35) Item Numbering	20
ObjectCode	Object Code	nVarChar		20
ObjectName	Object Name	nVarChar		100
Status	Status	VarChar	Y) Successful N) Failed	1		Y
Message	Message	nVarChar		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

OFAM SQL Table

biuan SAP® BUSINESS ONE

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