FA
FAClass
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcceleratedDepreciation | bit | Accelerated 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 | nvarchar(30) | Combine Accumulated Depreciation Sub. from | - | |
Description:A subaccount mask that is used to generate the Accumulated Depreciation subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute | ||||
AccumulatedDepreciationAccountID | int | Accumulated Depreciation Account | Account | |
Description:The reference to the Accumulated Depreciation account, Account An integer identifier of the account. By default, the value is inserted from the fixed asset class. | ||||
AccumulatedDepreciationSubID | int | Accumulated 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 | bit | Active | - | |
Description:A flag that indicates whether the fixed asset is active. | ||||
AssetCD | nvarchar(15) | Asset Class ID | FixedAsset.FADetails | |
Description:A string identifier, which contains a key value. This field is also a selector for navigation. The value can be entered manually or can be auto-numbered. | ||||
AssetID | int | - | ||
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. | ||||
AssetTypeID | nvarchar(10) | Asset Type | FAType | |
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. | ||||
BaseCuryID | nvarchar(5) | Currency | CurrencyList | |
Description:The base Currency of the Fixed Asset, corresponds to the Base Currency of the Branch of Fixed Asset. | ||||
BranchID | int | Branch | - | |
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. | ||||
ClassID | int | Asset Class | FAClass | |
Description:A reference to the fixed asset class. An integer identifier of the fixed asset class. It is a required value. | ||||
ConstructionAccountID | int | Construction Account | Account | |
Description:The reference to the construction account, Account An integer identifier of the construction account. By default, the value is inserted from the fixed asset class. | ||||
ConstructionSubID | int | Construction Sub. | Sub | |
Description:The reference to the construction subaccount associated with the construction account, Sub An integer identifier of the construction subaccount. By default, the value is inserted from the fixed asset class. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DeprExpenceSubMask | nvarchar(30) | Combine Depreciation Expense Sub. from | - | |
Description:A subaccount mask that is used to generate the Depreciation Expence subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute | ||||
Depreciable | bit | Depreciable | - | |
Description:A flag that determines whether the fixed asset should be depreciated. By default, the value is inserted from the appropriate fixed asset class. | ||||
DepreciatedExpenseAccountID | int | Depreciation Expense Account | Account | |
Description:The reference to the Depreciation Expense account, Account An integer identifier of the account. By default, the value is inserted from the fixed asset class. | ||||
DepreciatedExpenseSubID | int | Depreciation 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. | ||||
Description | nvarchar(256) | Description | - | |
Description:The description of fixed asset. | ||||
DisposalAccountID | int | Proceeds Account | Account | |
Description:The reference to the Proceeds account, Account An integer identifier of the account. By default, the value is inserted from the fixed asset class. | ||||
DisposalAmtNonexistent in DB | decimal? | Proceeds Amount | - | |
Description:The disposal amount of the asset. | ||||
DisposalSubID | int | Proceeds Sub. | Sub | |
Description:The reference to the Proceeds subaccount associated with the Proceeds account, Sub An integer identifier of the subaccount. By default, the value is inserted from the fixed asset class. | ||||
FAAccountID | int | Fixed Assets Account | Account | |
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. | ||||
FAAccrualAcctID | int | FA Accrual Account | Account | |
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. | ||||
FAAccrualSubID | int | FA 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. | ||||
FASubID | int | Fixed 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 | nvarchar(30) | Combine Fixed Asset Sub. from | - | |
Description:A subaccount mask that is used to generate the Fixed Assets subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute | ||||
GainAcctID | int | Gain Account | Account | |
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 | nvarchar(30) | Combine Gain/Loss Sub. from | - | |
Description:A subaccount mask that is used to generate the Gain and Loss subaccounts. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute | ||||
GainSubID | int | Gain Sub. | Sub | |
Description:The reference to the Gain subaccount associated with the Gain account, Sub An integer identifier of the subaccount. By default, the value is inserted from the fixed asset class. | ||||
HoldEntry | bit | Hold 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 | bit | Tangible | - | |
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". | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LeaseAccountID | int | Lease Account | Account | |
Description:The reference to the Lease account, Account An integer identifier of the account | ||||
LeaseSubID | int | Lease Sub. | Sub | |
Description:The reference to the Lease subaccount associated with the Lease account, Sub An integer identifier of the subaccount. | ||||
LossAcctID | int | Loss Account | Account | |
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. | ||||
LossSubID | int | Loss Sub. | Sub | |
Description:The reference to the Loss subaccount associated with the Loss account, Sub An integer identifier of the subaccount. By default, the value is inserted from the fixed asset class. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OldClassIDNonexistent in DB | 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. | ||||
ParentAssetID | int | Parent Asset | FixedAsset | |
Description:The reference to the parent fixed asset, which is generally used in fixed asset components. An integer identifier of the fixed asset. It is a required value for the fixed asset component. | ||||
ProceedsSubMask | nvarchar(30) | Combine Proceeds Sub. from | - | |
Description:A subaccount mask that is used to generate the Proceed subaccount. The allowed symbols of the subaccount mask described in SubAccountMaskAttribute | ||||
Qty | decimal | 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: - ""C"": indicates a fixed asset class. - ""A"": indicates a fixed asset. - ""E"": indicates a fixed asset element (also called component). | ||||
RentAccountID | int | Rent Account | Account | |
Description:The reference to the Rent account, Account An integer identifier of the account | ||||
RentSubID | int | Rent 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 | bool? | Selected | - | |
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. | ||||
ServiceScheduleID | int | Service Schedule | FAServiceSchedule | |
Description:The reference to the service schedule, FAServiceSchedule. This field is reserved for future use. An integer identifier of the service schedule. By default, the value is inserted from the appropriate fixed asset class. | ||||
SplittedFrom | int | - | ||
Description:An identifier of the source fixed asset if the current fixed asset has been splitted. | ||||
StatusNonexistent in DB | string | Status | - | |
Description:The status of the fixed asset. The allowed values of the asset status described in FixedAssetStatus.ListAttribute | ||||
Suspended | bit | Suspended | - | |
Description:A flag that indicates whether the fixed asset is suspended. | ||||
UnderConstruction | bit | Under 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. | ||||
UsageScheduleID | int | Usage Measurement Schedule | FAUsageSchedule | |
Description:The reference to the usage schedule, FAUsageSchedule. This field is reserved for future use. An integer identifier of the usage schedule. By default, the value is inserted from the appropriate fixed asset class. | ||||
UseFASubMask | bit | Use 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 | 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. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||