biuan SAP® BUSINESS ONE SDK
SQL Finance / Fixed Asset Data Migration
API OFAM
OFAM - Fixed Asset Data Migration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WizardId KEY UNIQUEWizard IDInt
11
PRIMARYYes
WizardNameMigration Run NamenVarChar
100
CreateDateMigration Run DateDate
8
AcctDtnMigrate Account DeterminationVarChar
Y) Yes
N) No
1
Y
DprAreaMigrate Depreciation AreasVarChar
Y) Yes
N) No
1
Y
DprTypeMigrate Depreciation TypesVarChar
Y) Yes
N) No
1
Y
AssetClassMigrate Asset ClassesVarChar
Y) Yes
N) No
1
Y
AssetNumMigrate Asset NumberingVarChar
Y) Yes
N) No
1
Y
AssetItemMigrate Asset ItemsVarChar
Y) Yes
N) No
1
Y
UpdExstItmOverwrite Existing DataVarChar
Y) Overwrite Existing Data
N) Skip if Data Already Exists
1
N
StatusStatus of Migration RunVarChar
S) Successful
P) Partially Successful
F) Failed
1
S
RemarksRemarksnVarChar
127
FiscalYearMigration Data to Fiscal YearnVarChar
10

SELECT statement

SELECT OFAM.WizardId AS 'Wizard ID', OFAM.WizardName AS 'Migration Run Name', OFAM.CreateDate AS 'Migration Run Date', OFAM.AcctDtn AS 'Migrate Account Determination', OFAM.DprArea AS 'Migrate Depreciation Areas', OFAM.DprType AS 'Migrate Depreciation Types', OFAM.AssetClass AS 'Migrate Asset Classes', OFAM.AssetNum AS 'Migrate Asset Numbering', OFAM.AssetItem AS 'Migrate Asset Items', OFAM.UpdExstItm AS 'Overwrite Existing Data', OFAM.Status AS 'Status of Migration Run', OFAM.Remarks AS 'Remarks', OFAM.FiscalYear AS 'Migration Data to Fiscal Year' FROM OFAM AS OFAM

Related information


OFAM 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