Skip to main content
FA

FixedAsset

PX.Objects.FA
Field NameTypeDisplay NameForeign Key
AssetCDDefault Navigation
nvarchar(15)Asset ID-
Description:No description available
AcceleratedDepreciation
bitAccelerated Depreciation for SL Depr. Method-
Description:A flag that determines whether the Straight Line depreciation method is equivalent to the Remaining Value depreciation method.
AccumDeprSubMask
varchar(30)-
Description:A subaccount mask that is used to generate the Accumulated Depreciation subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute
AccumulatedDepreciationAccountIDDefault Navigation
intAccumulated Depreciation AccountAccount
Description:No description available
AccumulatedDepreciationSubIDDefault Navigation
intAccumulated Depreciation Sub.Sub
Description:The reference to the Accumulated Depreciation subaccount associated with the Accumulated Depreciation account, Sub An integer identifier of the subaccount. By default, the value is inserted from the fixed asset class.
Active
bitActive-
Description:A flag that indicates whether the fixed asset is active.
AssetID
intAssetID-
Description:The identifier of the fixed asset. The identifier is used for foreign references; it can be negative for newly inserted records. A unique integer number.
AssetTypeIDDefault Navigation
nvarchar(10)Asset TypeFAType
Description:The reference to the fixed asset type, FAType An integer identifier of the fixed asset type. It is a required value. By default, the value is inserted from the fixed asset class.
BaseCuryIDDefault Navigation
nvarchar(5)CurrencyCurrencyList
Description:The base Currency of the Fixed Asset, corresponds to the Base Currency of the Branch of Fixed Asset.
BranchIDDefault Navigation
intBranchBranch
Description:A reference to the branch, Branch. An integer identifier of the branch. It is a required value. By default, the value is set to the identifier of the current branch.
ClassIDDefault Navigation
intAsset ClassFixedAsset
Description:No description available
ConstructionAccountIDDefault Navigation
intConstruction AccountAccount
Description:No description available
ConstructionSubIDDefault Navigation
intConstruction Sub.Sub
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
Depreciable
bitDepreciable-
Description:No description available
DepreciatedExpenseAccountIDDefault Navigation
intDepreciation Expense AccountAccount
Description:No description available
DepreciatedExpenseSubIDDefault Navigation
intDepreciation Expense Sub.Sub
Description:The reference to the Depreciation Expense subaccount associated with the Depreciation Expense account, Sub An integer identifier of the subaccount. By default, the value is inserted from the fixed asset class.
DeprExpenceSubMask
varchar(30)-
Description:A subaccount mask that is used to generate the Depreciation Expence subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute
Description
nvarchar(256)Description-
Description:The description of fixed asset.
DisposalAccountIDDefault Navigation
intProceeds AccountAccount
Description:No description available
DisposalAmtNonexistent in DB
decimalProceeds Amount-
Description:The disposal amount of the asset.
DisposalSubIDDefault Navigation
intProceeds Sub.Sub
Description:No description available
FAAccountIDDefault Navigation
intFixed Assets AccountAccount
Description:The reference to the Fixed Assets account, Account An integer identifier of the account. By default, the value is inserted from the fixed asset class.
FAAccrualAcctIDDefault Navigation
intFA Accrual AccountAccount
Description:The reference to the FA Accrual account, Account An integer identifier of the account. By default, the value is inserted from the fixed asset class.
FAAccrualSubIDDefault Navigation
intFA Accrual Sub.Sub
Description:The reference to the FA Accrual subaccount associated with the FA Accrual account, Sub An integer identifier of the subaccount. By default, the value is inserted from the fixed asset class.
FASubIDDefault Navigation
intFixed Assets Sub.Sub
Description:The reference to the Fixed Assets subaccount associated with the Fixed Assets account, Sub An integer identifier of the subaccount. By default, the value is inserted from the fixed asset class.
FASubMask
varchar(30)-
Description:A subaccount mask that is used to generate the Fixed Assets subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute
GainAcctIDDefault Navigation
intGain AccountAccount
Description:The reference to the Gain account, Account An integer identifier of the account. By default, the value is inserted from the fixed asset class.
GainLossSubMask
varchar(30)-
Description:A subaccount mask that is used to generate the Gain and Loss subaccounts. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute
GainSubIDDefault Navigation
intGain Sub.Sub
Description:No description available
HoldEntry
bitHold on Entry-
Description:A flag that determines whether new fixed assets should have the On Hold status by default. This field makes sense only for fixed asset classes.
IsAcquired
bit-
Description:A flag that indicates whether the fixed asset was acquired.
IsTangible
bitTangible-
Description:A flag that indicates whether the fixed asset is tangible. If a type is associated with the fixed asset, the default value is inserted from the fixed asset type (FAType). If no type is associated with the fixed asset, the default value is "true".
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LeaseAccountIDDefault Navigation
intLease AccountAccount
Description:The reference to the Lease account, Account An integer identifier of the account
LeaseSubIDDefault Navigation
intLease Sub.Sub
Description:The reference to the Lease subaccount associated with the Lease account, Sub An integer identifier of the subaccount.
LossAcctIDDefault Navigation
intLoss AccountAccount
Description:The reference to the Loss account, Account An integer identifier of the account. By default, the value is inserted from the fixed asset class.
LossSubIDDefault Navigation
intLoss Sub.Sub
Description:No description available
NoteID
uniqueidentifier-
Description:No description available
OldClassID
int-
Description:The service reference to the previous class, which is used in the transfer process only. An integer identifier of the fixed asset class.
ParentAssetIDDefault Navigation
intParent AssetFixedAsset
Description:No description available
ProceedsSubMask
varchar(30)-
Description:A subaccount mask that is used to generate the Proceed subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute
Qty
decimal(25, 6)Quantity-
Description:The number of objects in the fixed asset. A decimal number (which can be a fractional number). The default value is "1.0".
RecordType
char(1)Record Type-
Description:A type of the entity: fixed asset, class, or element. The field can have one of the following values:
RentAccountIDDefault Navigation
intRent AccountAccount
Description:The reference to the Rent account, Account An integer identifier of the account
RentSubIDDefault Navigation
intRent Sub.Sub
Description:The reference to the Rent subaccount associated with the Rent account, Sub An integer identifier of the subaccount.
SalvageAmtAfterSplitNonexistent in DB
decimal-
Description:No description available
SelectedNonexistent in DB
bitSelected-
Description:An unbound service field, which indicates that the fixed asset is marked for processing. If the value of the field is "true", the asset will be processed; otherwise, the asset will not be processed.
ServiceScheduleIDDefault Navigation
intService ScheduleFAServiceSchedule
Description:No description available
SplittedFrom
int-
Description:An identifier of the source fixed asset if the current fixed asset has been splitted.
Status
nchar(1)Status-
Description:The status of the fixed asset. The allowed values of the asset status described in FixedAssetStatus.ListAttribute
Suspended
bitSuspended-
Description:A flag that indicates whether the fixed asset is suspended.
tstamp
timestamp-
Description:No description available
UnderConstruction
bitUnder Construction-
Description:A flag that determines whether the fixed asset is under construction. By default, the value is inserted from the appropriate fixed asset class.
UsageScheduleIDDefault Navigation
intUsage Measurement ScheduleFAUsageSchedule
Description:No description available
UseFASubMask
bitUse Fixed Asset Sub. Mask-
Description:A flag that determines whether the Fixed Assets subaccount mask has to be used for the Accumulated Depreciation subaccount.
UsefulLife
decimal(7, 4)Useful Life, Years-
Description:The useful life of the fixed asset measured in years. An integer number of years of useful life. By default, the value is inserted from the appropriate fixed asset class.