FA
FADetails
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
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. | ||||
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 | ||||
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 | char(6) | - | ||
Description:The period of fixed asset disposal. The field is filled in only for disposed fixed assets. | ||||
Hold | bit | Hold | - | |
Description:A flag that indicates (if set to "true") that the fixed asset is on hold and thus cannot be depreciated. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
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. | ||||
Model | nvarchar(60) | Model | - | |
Description:The name of the fixed asset model. The information field, which value is entered manually. | ||||
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. | ||||
ReplacementCost | decimal | Replacement Cost | - | |
Description:The replacement cost of the fixed asset. | ||||
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. | ||||
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 | ||||