FA
FADetails
Contains the additional properties of FixedAsset.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccrualBalance | decimal | - | ||
Description:The reconciled part of the current cost of the fixed asset. The value is read-only and is selected from the appropriate FABookHistoryRecon.ytdReconciled field. | ||||
AcquisitionCost | decimal | Orig. Acquisition Cost | - | |
Description:The cost of the fixed asset at the time of acquisition. The value can be changed during the life of the asset. | ||||
AssetID | int | FixedAsset | ||
Description:A reference to FixedAsset. An integer identifier of the fixed asset. It is a required value. By default, the value is set to the current fixed asset identifier. | ||||
Barcode | nvarchar(20) | Barcode | - | |
Description:The barcode of the fixed asset. The information field, which value is entered manually. | ||||
BaseCuryIDNonexistent in DB | string | Currency | - | |
Description:No description available | ||||
BillNumber | nvarchar(15) | Bill Number | - | |
Description:The number of the bill. The information field, which value is entered manually. | ||||
Condition | char(1) | Condition | - | |
Description:The condition of the fixed asset. The field can have one of the values described in condition.ListAttribute. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CurrentCost | decimal | Basis | - | |
Description:The cost of the fixed asset in the current depreciation period. The value is read-only and is selected from the appropriate FABookHistoryRecon.ytdAcquired field. | ||||
DepreciateFromDate | datetime | Placed-in-Service Date | - | |
Description:The date when depreciation of the fixed asset starts. The date can not be greater than receiptDate. | ||||
DisplayDisposalDateNonexistent in DB | DateTime? | Disposal Date | - | |
Description:The date of fixed asset disposal. The field is filled in only for disposed fixed assets. | ||||
DisplayDisposalMethodIDNonexistent in DB | int? | Disposal Method | FADisposalMethod | |
Description:A reference to FADisposalMethod. An integer identifier of the disposal method. The field is filled in only for disposed fixed assets. | ||||
DisplayDisposalPeriodIDNonexistent in DB | string | - | ||
Description:The period of fixed asset disposal. The field is filled in only for disposed fixed assets. | ||||
DisplaySaleAmountNonexistent in DB | decimal? | Disposal Amount | - | |
Description:The amount of fixed asset disposal. The field is filled in only for disposed fixed assets. The value of the field can be zero. | ||||
DisposalDate | datetime | Disposal Date | - | |
Description:The date of fixed asset disposal. The field is filled in only for disposed fixed assets. | ||||
DisposalMethodID | int | Disposal Method | FADisposalMethod | |
Description:A reference to FADisposalMethod. An integer identifier of the disposal method. The field is filled in only for disposed fixed assets. | ||||
DisposalPeriodID | string | - | ||
Description:The period of fixed asset disposal. The field is filled in only for disposed fixed assets. | ||||
FairMarketValue | decimal | Fair Market Value | - | |
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:A flag that indicates (if set to "true") that the fixed asset is on hold and thus cannot be depreciated. | ||||
IsReconciledNonexistent in DB | bool? | - | ||
Description:A flag that indicates (if set to "true") that a fixed asset is fully reconciled with the General Ledger module. | ||||
IsTemplate | bit | Is Template | - | |
Description:No description available | ||||
LastCountDate | datetime | Last Count Date | - | |
Description:No description available | ||||
LastMeasurementUsageDate | datetime | Last Measurement Date | - | |
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 | ||||
LastServiceDate | datetime | Last Service Date | - | |
Description:No description available | ||||
LastServiceValue | decimal | Last Service Value | - | |
Description:No description available | ||||
LeaseNumber | nvarchar(15) | Lease Number | - | |
Description:No description available | ||||
LeaseRentTerm | int | Lease/Rent Term, months | - | |
Description:No description available | ||||
LessorID | int | Lessor | - | |
Description:No description available | ||||
LocationRevID | int | - | ||
Description:The number of the actual revision of the asset location. This field is a part of the compound reference to FALocationHistory. The full reference contains the assetID and locationRevID fields. | ||||
Manufacturer | nvarchar(60) | Manufacturer | - | |
Description:The name of the fixed asset manufacturer. The information field, which value is entered manually. | ||||
ManufacturingYear | char(4) | Manufacturing Year | - | |
Description:No description available | ||||
Model | nvarchar(60) | Model | - | |
Description:The name of the fixed asset model. The information field, which value is entered manually. | ||||
NextMeasurementUsageDate | datetime | Next Measurement Date | - | |
Description:No description available | ||||
NextServiceDate | datetime | Next Service Date | - | |
Description:No description available | ||||
NextServiceValue | decimal | Next Service Value | - | |
Description:No description available | ||||
PONumber | nvarchar(15) | PO Number | - | |
Description:The number of the purchase order related to the purchase document. The information field. | ||||
PropertyType | char(2) | Property Type | - | |
Description:The type of the fixed asset property. The field can have one of the values described in propertyType.ListAttribute. | ||||
ReceiptDate | datetime | Receipt Date | - | |
Description:The acquisition date of the fixed asset. | ||||
ReceiptNbr | nvarchar(15) | Receipt Nbr. | POReceipt | |
Description:The number of the purchase receipt. This field is a part of the compound reference to the purchasing document (. The full reference contains the receiptType and receiptNbr fields. | ||||
ReceiptType | char(2) | Receipt Type | POReceipt | |
Description:The type of the purchase receipt. This field is a part of the compound reference to the purchasing document (POReceipt). The full reference contains the receiptType and receiptNbr fields. The field can have one of the values described in POReceiptType.ListAttribute. | ||||
RentAmount | decimal | Rent Amount | - | |
Description:No description available | ||||
ReplacementCost | decimal | Replacement Cost | - | |
Description:The replacement cost of the fixed asset. | ||||
ReportingLineNbr | char(3) | Personal Property Type | - | |
Description:No description available | ||||
RetailCost | decimal | Retail Cost | - | |
Description:No description available | ||||
SaleAmount | decimal | Disposal Amount | - | |
Description:The amount of fixed asset disposal. The field is filled in only for disposed fixed assets. The value of the field can be zero. | ||||
SalvageAmount | decimal | Salvage Amount | - | |
Description:The salvage amount of the fixed asset. | ||||
SerialNumber | nvarchar(60) | Serial Number | - | |
Description:The serial number of the fixed asset. The information field, which value is entered manually. | ||||
Status | char(1) | Status | - | |
Description:The status of the fixed asset. The field can have one of the values described in FixedAssetStatus.ListAttribute. | ||||
TagNbr | nvarchar(20) | Tag Number | - | |
Description:The tag of the fixed asset. The value can be entered manually or can be auto-numbered. | ||||
TemplateID | int | Template | FixedAsset | |
Description:No description available | ||||
TotalExpectedUsage | decimal | Total Expected Usage | - | |
Description:No description available | ||||
TransferPeriodNonexistent in DBObsolete | string | Transfer Period | - | |
Description:The identifier of the transfer period. This is an unbound service field that is used to pass the parameter to transfer processing. | ||||
Warrantor | nvarchar(40) | Warrantor | - | |
Description:The name of the fixed asset warrantor. The information field, which value is entered manually. | ||||
WarrantyCertificateNumber | nvarchar(30) | Warranty Certificate Number | - | |
Description:The certificate number of the fixed asset warranty. The information field, which value is entered manually. | ||||
WarrantyExpirationDate | datetime | Warranty Expires On | - | |
Description:The expiration date of the fixed asset warranty. The information field, which value is entered manually. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||