Skip to main content
FA

FABookHistory

PX.Objects.FA
Field NameTypeDisplay NameForeign Key
AssetID
intFixedAsset
Description:A reference to FixedAsset. The field is a part of the primary key. The full primary key contains AssetID, BookID, and FinPeriodID fields. An integer identifier of the fixed asset. This is a required field.
BookID
intFABook
Description:A reference to FABook. The field is a part of the primary key. The full primary key contains AssetID, BookID, and FinPeriodID fields. An integer identifier of the book. This is a required field.
FinPeriodID
char(6)-
Description:No description available
BegBal
decimal(19, 4)-
Description:The beginning balance (net value) of the fixed asset in the financial period. By default, the value is 0.0.
BegDeprBase
decimal(19, 4)-
Description:The beginning value of the depreciation basis of the fixed asset in the financial period. By default, the value is 0.0.
Closed
bit-
Description:A flag that indicates (if set to "true") that the financial period is closed for the depreciation. The financial period is closed when the depreciation amount of the fixed asset in the financial period is calculated and successfully posted to the General Ledger module. By default, the value is set to false.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
PtdAcquired
decimal(19, 4)-
Description:The change of the acquisition amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdAdjusted
decimal(19, 4)-
Description:The change of the depreciation amount of the fixed asset because of split of the assets in the financial period. By default, the value is 0.0.
PtdBonus
decimal(19, 4)-
Description:The change of the bonus amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdBonusCalculated
decimal(19, 4)-
Description:The calculated bonus amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdBonusRecap
decimal(19, 4)-
Description:The recaptured bonus amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdBonusTaken
decimal(19, 4)-
Description:The taken bonus amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdCalculated
decimal(19, 4)-
Description:The calculated depreciation amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdDeprBase
decimal(19, 4)-
Description:The change of the depreciation basis of the fixed asset in the financial period. By default, the value is 0.0.
PtdDeprDisposed
decimal(19, 4)-
Description:The change of the depreciation amount of the fixed asset because of disposal of the assets in the financial period. By default, the value is 0.0.
PtdDepreciated
decimal(19, 4)-
Description:The change of the depreciation amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdDisposalAmount
decimal(19, 4)-
Description:The sale amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdReconciled
decimal(19, 4)-
Description:The change of the GL reconciliation amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdRevalueAmount
decimal(19, 4)-
Description:A reserved field, which is currently not used.
PtdRGOL
decimal(19, 4)-
Description:The positive gain or negative loss amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdTax179
decimal(19, 4)-
Description:The change of the Tax 179 amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdTax179Calculated
decimal(19, 4)-
Description:The calculated Tax 179 amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdTax179Recap
decimal(19, 4)-
Description:The recaptured Tax 179 amount of the fixed asset in the financial period. By default, the value is 0.0.
PtdTax179Taken
decimal(19, 4)-
Description:The taken Tax 179 amount of the fixed asset in the financial period. By default, the value is 0.0.
ReopenNonexistent in DB
bit-
Description:A flag that indicates (if set to "true") that the financial period is reopened. The financial period becomes reopen, if, in the financial period, negative depreciation adjustment to zero amount has been performed manually. By default, the value is set to false.
Suspended
bit-
Description:A flag that indicates (if set to "true") that the fixed asset is suspended in the financial period. By default, the value is set to false.
tstamp
timestamp-
Description:No description available
YtdAcquired
decimal(19, 4)-
Description:The ending value of the acquisition amount of the fixed asset in the financial period. By default, the value is 0.0.
YtdBal
decimal(19, 4)-
Description:The ending balance (net value) of the fixed asset in the financial period. By default, the value is 0.0.
YtdBonus
decimal(19, 4)-
Description:The bonus amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdBonusCalculated
decimal(19, 4)-
Description:The calculated bonus amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdBonusRecap
decimal(19, 4)-
Description:The recaptured bonus amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdBonusTaken
decimal(19, 4)-
Description:The taken bonus amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdCalculated
decimal(19, 4)-
Description:The calculated depreciation amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdDeprBase
decimal(19, 4)-
Description:The ending value of the depreciation basis of the fixed asset in the financial period. By default, the value is 0.0.
YtdDepreciated
decimal(19, 4)-
Description:The accumulated depreciation amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdDisposalAmount
decimal(19, 4)-
Description:The sale amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdReconciled
decimal(19, 4)-
Description:The ending value of the GL reconciliation amount of the fixed asset in the financial period. By default, the value is 0.0.
YtdRevalueAmount
decimal(19, 4)-
Description:A reserved field, which is currently not used.
YtdReversed
int-
Description:The service field. The number of financial periods at the end of which the fixed asset has been reversed from suspend.
YtdRGOL
decimal(19, 4)-
Description:The positive gain or negative loss amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdSuspended
int-
Description:The service field. The number of financial periods at the end of which the fixed asset has been suspended.
YtdTax179
decimal(19, 4)-
Description:The Tax 179 amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdTax179Calculated
decimal(19, 4)-
Description:The calculated Tax 179 amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdTax179Recap
decimal(19, 4)-
Description:The recaptured Tax 179 amount of the fixed asset at the end of the financial period. By default, the value is 0.0.
YtdTax179Taken
decimal(19, 4)-
Description:The taken Tax 179 amount of the fixed asset at the end of the financial period. By default, the value is 0.0.