Skip to main content
FA

FADetailsTransfer

PX.Objects.FA
Field NameTypeDisplay NameForeign Key
AssetID
intAssetIDFixedAsset
Description:No description available
AccrualBalance
decimal-
Description:No description available
AcquisitionCost
decimalOrig. Acquisition Cost-
Description:No description available
Barcode
nvarchar(20)Barcode-
Description:No description available
BaseCuryIDNonexistent in DB
nvarchar(MAX)Currency-
Description:No description available
BillNumber
nvarchar(15)Bill Number-
Description:No description available
Condition
char(1)Condition-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
varchar(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
CurrentCost
decimalBasis-
Description:No description available
DepreciateFromDate
datetime2Placed-in-Service Date-
Description:No description available
DisplayDisposalDateNonexistent in DB
datetimeDisposal Date-
Description:No description available
DisplayDisposalMethodIDDefault NavigationNonexistent in DB
intDisposal MethodFADisposalMethod
Description:No description available
DisplayDisposalPeriodIDNonexistent in DB
nchar(6)-
Description:No description available
DisplaySaleAmountNonexistent in DB
decimalDisposal Amount-
Description:No description available
DisposalDate
datetime2Disposal Date-
Description:No description available
DisposalMethodIDDefault Navigation
intDisposal MethodFADisposalMethod
Description:No description available
DisposalPeriodID
char(6)-
Description:No description available
FairMarketValue
decimalFair Market Value-
Description:No description available
Hold
bitHold-
Description:No description available
IsReconciled
bit-
Description:No description available
IsTemplate
bitIs Template-
Description:No description available
LastCountDate
datetime2Last Count Date-
Description:No description available
LastMeasurementUsageDate
datetime2Last Measurement Date-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
varchar(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
LastServiceDate
datetime2Last Service Date-
Description:No description available
LastServiceValue
decimalLast Service Value-
Description:No description available
LeaseNumber
nvarchar(15)Lease Number-
Description:No description available
LeaseRentTerm
intLease/Rent Term, months-
Description:No description available
LessorIDDefault Navigation
intLessorBAccount
Description:No description available
LocationRevID
int-
Description:No description available
Manufacturer
nvarchar(60)Manufacturer-
Description:No description available
ManufacturingYear
char(4)Manufacturing Year-
Description:No description available
Model
nvarchar(60)Model-
Description:No description available
NextMeasurementUsageDate
datetime2Next Measurement Date-
Description:No description available
NextServiceDate
datetime2Next Service Date-
Description:No description available
NextServiceValue
decimalNext Service Value-
Description:No description available
PONumber
nvarchar(15)PO Number-
Description:No description available
PropertyType
char(2)Property Type-
Description:No description available
ReceiptDate
datetimeReceipt Date-
Description:No description available
ReceiptNbrDefault Navigation
nvarchar(15)Receipt Nbr.POReceipt
Description:No description available
ReceiptType
char(2)Receipt Type-
Description:No description available
RentAmount
decimalRent Amount-
Description:No description available
ReplacementCost
decimalReplacement Cost-
Description:No description available
ReportingLineNbr
char(3)Personal Property Type-
Description:No description available
RetailCost
decimalRetail Cost-
Description:No description available
SaleAmount
decimalDisposal Amount-
Description:No description available
SalvageAmount
decimalSalvage 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
TemplateIDDefault Navigation
intTemplateFixedAsset
Description:No description available
TotalExpectedUsage
decimalTotal Expected Usage-
Description:No description available
TransferPeriodNonexistent in DBObsolete
nchar(6)Transfer Period-
Description:No description available
TransferPeriodID
char(6)Transfer Period-
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
datetime2Warranty Expires On-
Description:No description available