biuan SAP® BUSINESS ONE SDK
SQL Finance / Fixed Asset Parameter Change - Rows
API FAC1
FAC1 - Fixed Asset Parameter Change - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OFAC
Fixed Asset Parameter Change		PRIMARYYes
LineNumRow NumberInt
11
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
TransTypeTransaction TypenVarChar
0
510) Change of Depreciation Type
520) Change of Useful Life
530) Change of Depreciation Start Date
540) Change of Salvage Value
560) Change of Period Control
4
OldDprTypeOld Depreciation TypenVarChar
15ODTP
Fixed Assets Depreciation Types
NewDprTypeNew Depreciation TypenVarChar
15ODTP
Fixed Assets Depreciation Types
OldUsfLifeOld Useful LifeInt
11
NewUsfLifeNew Useful LifeInt
11
OldDprDateOld Depreciation Start DateDate
8
NewDprDateNew Depreciation Start DateDate
8
OldSalValOld Salvage ValueNum
20
NewSalValNew Salvage ValueNum
20

Table relationship map

SELECT statement

SELECT FAC1.AbsEntry AS 'Internal Number', FAC1.LineNum AS 'Row Number', FAC1.DprArea AS 'Depreciation Area', FAC1.TransType AS 'Transaction Type', FAC1.OldDprType AS 'Old Depreciation Type', FAC1.NewDprType AS 'New Depreciation Type', FAC1.OldUsfLife AS 'Old Useful Life', FAC1.NewUsfLife AS 'New Useful Life', FAC1.OldDprDate AS 'Old Depreciation Start Date', FAC1.NewDprDate AS 'New Depreciation Start Date', FAC1.OldSalVal AS 'Old Salvage Value', FAC1.NewSalVal AS 'New Salvage Value' FROM FAC1 AS FAC1

Related information


Fixed Asset Parameter Change OFAC SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Fixed Assets Depreciation Types ODTP 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