📚 SAP Business One SDK Help

Table Name: OFAM

Table Description: Fixed Asset Data Migration

Field Description Type Size Related Default Value Constraints
WizardId Wizard ID Int 11 -      
WizardName Migration Run Name nVarChar 100 -      
CreateDate Migration Run Date Date 8 -      
AcctDtn Migrate Account Determination VarChar 1 - Y Y Yes
            N No
DprArea Migrate Depreciation Areas VarChar 1 - Y Y Yes
            N No
DprType Migrate Depreciation Types VarChar 1 - Y Y Yes
            N No
AssetClass Migrate Asset Classes VarChar 1 - Y Y Yes
            N No
AssetNum Migrate Asset Numbering VarChar 1 - Y Y Yes
            N No
AssetItem Migrate Asset Items VarChar 1 - Y Y Yes
            N No
UpdExstItm Overwrite Existing Data VarChar 1 - N Y Overwrite Existing Data
            N Skip if Data Already Exists
Status Status of Migration Run VarChar 1 - S S Successful
            P Partially Successful
            F Failed
Remarks Remarks nVarChar 254 -      
FiscalYear Migration Data to Fiscal Year nVarChar 10 -      
Key Unique Field
PRIMARY Yes WizardId