FA
FADetails
PX.Objects.FA.Standalone38 of 38 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AssetID | int | AssetID | FixedAsset | |
Description:No description available | ||||
AcquisitionCost | decimal(19, 4) | Orig. Acquisition Cost | - | |
Description:No description available | ||||
Barcode | nvarchar(20) | Barcode | - | |
Description:No description available | ||||
BillNumber | nvarchar(15) | Bill Number | - | |
Description:No description available | ||||
Condition | char(1) | Condition | - | |
Description:No description available | ||||
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:No description available | ||||
DisplayDisposalDateNonexistent in DB | datetime | Disposal Date | - | |
Description:No description available | ||||
DisplayDisposalMethodIDNonexistent in DB | int | Disposal Method | FADisposalMethod | |
Description:No description available | ||||
DisplayDisposalPeriodIDNonexistent in DB | nchar(6) | - | ||
Description:No description available | ||||
DisplaySaleAmountNonexistent in DB | decimal | Disposal Amount | - | |
Description:No description available | ||||
DisposalDate | datetime | Disposal Date | - | |
Description:No description available | ||||
DisposalMethodID | int | Disposal Method | FADisposalMethod | |
Description:No description available | ||||
DisposalPeriodID | char(6) | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
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 | ||||
LocationRevID | int | - | ||
Description:No description available | ||||
Manufacturer | nvarchar(60) | Manufacturer | - | |
Description:No description available | ||||
Model | nvarchar(60) | Model | - | |
Description:No description available | ||||
PONumber | nvarchar(15) | PO Number | - | |
Description:No description available | ||||
PropertyType | char(2) | Property Type | - | |
Description:No description available | ||||
ReceiptDate | datetime | Receipt Date | - | |
Description:No description available | ||||
ReceiptNbr | nvarchar(15) | Receipt Nbr. | POReceipt | |
Description:No description available | ||||
ReceiptType | char(2) | Receipt Type | - | |
Description:No description available | ||||
ReplacementCost | decimal(19, 4) | Replacement Cost | - | |
Description:No description available | ||||
SaleAmount | decimal(19, 4) | Disposal Amount | - | |
Description:No description available | ||||
SalvageAmount | decimal(19, 4) | Salvage Amount | - | |
Description:No description available | ||||
SerialNumber | nvarchar(60) | Serial Number | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TagNbr | nvarchar(20) | Tag Number | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Warrantor | nvarchar(40) | Warrantor | - | |
Description:No description available | ||||
WarrantyCertificateNumber | nvarchar(30) | Warranty Certificate Number | - | |
Description:No description available | ||||
WarrantyExpirationDate | datetime | Warranty Expires On | - | |
Description:No description available | ||||