FA
FABookHistory
PX.Objects.FA52 of 52 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AssetID | int | FixedAsset | ||
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 | int | FABook | ||
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. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
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. | ||||