FADetails

PX.Objects.FA

61 of 61 fields

	Field Name	Type	Display Name	Foreign Key
	`AssetID`	`int`	AssetID	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.
	`AccrualBalance`	`decimal`		-
Description:No description available
	`AcquisitionCost`	`decimal(19, 4)`	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.
	`Barcode`	`nvarchar(20)`	Barcode	-
Description:The barcode of the fixed asset. The information field, which value is entered manually.
	`BaseCuryID`Nonexistent in DB	`nvarchar(MAX)`	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`Default Navigation	`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: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.
	`DisplayDisposalDate`Nonexistent in DB	`datetime`	Disposal Date	-
Description:No description available
	`DisplayDisposalMethodID`Default NavigationNonexistent in DB	`int`	Disposal Method	FADisposalMethod
Description:No description available
	`DisplayDisposalPeriodID`Nonexistent in DB	`nchar(6)`		-
Description:The period of fixed asset disposal. The field is filled in only for disposed fixed assets.
	`DisplaySaleAmount`Nonexistent in DB	`decimal`	Disposal Amount	-
Description:No description available
	`DisposalDate`	`datetime`	Disposal Date	-
Description:The date of fixed asset disposal. The field is filled in only for disposed fixed assets.
	`DisposalMethodID`Default Navigation	`int`	Disposal Method	FADisposalMethod
Description:No description available
	`DisposalPeriodID`	`char(6)`		-
Description:The period of fixed asset disposal. The field is filled in only for disposed fixed assets.
	`FairMarketValue`	`decimal(19, 4)`	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.
	`IsReconciled`	`bit`		-
Description:No description available
	`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`Default Navigation	`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(19, 4)`	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`Default Navigation	`int`	Lessor	BAccount
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(19, 4)`	Next Service Value	-
Description:No description available
	`PONumber`	`nvarchar(15)`	PO Number	-
Description:No description available
	`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`Default Navigation	`nvarchar(15)`	Receipt Nbr.	POReceipt
Description:No description available
	`ReceiptType`	`char(2)`	Receipt Type	-
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(19, 4)`	Rent Amount	-
Description:No description available
	`ReplacementCost`	`decimal(19, 4)`	Replacement Cost	-
Description:The replacement cost of the fixed asset.
	`ReportingLineNbr`	`char(3)`	Personal Property Type	-
Description:No description available
	`RetailCost`	`decimal(19, 4)`	Retail Cost	-
Description:No description available
	`SaleAmount`	`decimal(19, 4)`	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(19, 4)`	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`Default Navigation	`int`	Template	FixedAsset
Description:No description available
	`TotalExpectedUsage`	`decimal(19, 4)`	Total Expected Usage	-
Description:No description available
	`TransferPeriod`Nonexistent in DBObsolete	`nchar(6)`	Transfer Period	-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`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.