PMProjectARHistory

PX.Objects.PMRelease 2025.2

Represents a line of the project AR history by date.

Select a row for its description 59 of 59 fields

	Field Name	Type	Display Name	Foreign Key
	`ARAmount`	`decimal`	AR Amount (Base Curr.)	-
Description:The amount in the base currency.
	`ARCashDiscount`	`decimal`	AR Cash Discount (Base Curr.)	-
Description:The cash discount amount in the base currency.
	`ARDocType`	`char(3)`	AR Document Type	-
Description:The type of the corresponding accounts receivable document associated with the transaction.
	`ARLineNbr`	`int`	AR Document Line Nbr.	-
Description:The line number in the corresponding accounts receivable document associated with the transaction.
	`ARRefNbr`Default Navigation	`nvarchar(15)`	AR Document Ref. Nbr.	ARInvoice
Description:The reference number of the corresponding accounts receivable document associated with the transaction.
	`ARRetainageHeld`	`decimal`	AR Retained Amount (Base Curr.)	-
Description:The retainage held amount in the base currency.
	`ARRetainedTaxHeld`	`decimal`	AR Retained Taxes (Base Curr.)	-
Description:The retained tax held amount in the base currency.
	`AccountGroupID`Default Navigation	`int`	Account Group	PMAccountGroup
Description:The project account group of the project transaction. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`BaseCuryInfoID`	`bigint`		-
Description:The identifier of the CurrencyInfo record that stores the exchange rate from the transaction currency to the base currency. The value of this field corresponds to the value of the CurrencyInfo.CuryInfoID field.
	`BranchID`Default Navigation	`int`	Branch	-
Description:The identifier of the branch associated with the AR history record. This field is a part of the compound key of the record. The value of this field corresponds to the Branch.BAccountID field.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The project cost code of the project transaction. The value of this field corresponds to the value of the PMCostCode.CostCodeID field.
	`CuryID`	`nvarchar(5)`	Project Currency	-
Description:The identifier of the base currency. The value of this field corresponds to the value of the CurrencyList.CuryID field.
	`CustomerID`Default Navigation	`int`	Customer	Customer
Description:The identifier of the customer for the project. Projects can be of the internal or external type. Internal projects are those that have the value of this property equal to NULL and hence are not billable.
	`Date`	`datetime`	Date	-
Description:The project transaction date.
	`EntityDocType`	`char(3)`	Document Type	-
Description:The document type of the related entity.
	`EntityRefNbr`	`nvarchar(30)`	Ref. Nbr.	-
Description:The reference number of the related entity document.
	`EntityType`	`char(1)`	Record Type	-
Description:The entity type. This field can have one of the values described in ARHistoryEntityType.
	`ExtPrice`	`decimal`	Extended Price (Base Curr.)	-
Description:The extended price in the base currency.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The inventory item of the project transaction. The value of this field corresponds to the value of the InventoryItem.InventoryID field.
	`InvoicedExclusiveTax`	`decimal`	Exclusive Taxes on AR (Base Curr.)	-
Description:The exclusive tax amount in the base currency.
	`InvoicedInclusiveTax`	`decimal`	Inclusive Taxes on AR (Base Curr.)	-
Description:The invoiced inclusive tax amount in the base currency.
	`InvoicedQty`	`decimal`	AR Document Qty.	-
Description:The invoiced quantity for the transaction line.
	`IsRetainageDocument`	`bit`	Retainage Document	-
Description:A Boolean value that indicates (if set to true) that the document is a retainage document.
	`PaidARAmount`	`decimal`	AR Paid Amount (Base Curr.)	-
Description:The paid amount in the base currency.
	`PaidExclusiveTax`	`decimal`	Exclusive Taxes on Paid AR (Base Curr.)	-
Description:The paid exclusive tax amount in the base currency.
	`PaidInclusiveTax`	`decimal`	Paid Inclusive Tax (Base Curr.)	-
Description:The paid inclusive tax amount in the base currency.
	`ProjectCuryARAmount`	`decimal`	AR Amount (Project Curr.)	-
Description:The amount in the project currency.
	`ProjectCuryARCashDiscount`	`decimal`	AR Cash Discount (Project Curr.)	-
Description:The cash discount amount in the project currency.
	`ProjectCuryARRetainageHeld`	`decimal`	AR Retained Amount (Project Curr.)	-
Description:The retainage held amount in the project currency.
	`ProjectCuryARRetainedTaxHeld`	`decimal`	AR Retained Taxes (Project Curr.)	-
Description:The retained tax held amount in the project currency.
	`ProjectCuryExtPrice`	`decimal`	Extended Price (Project Curr.)	-
Description:The extended price in the project currency.
	`ProjectCuryInfoID`	`bigint`		-
Description:The identifier of the CurrencyInfo record that stores the exchange rate from the transaction currency to the project currency. The value of this field corresponds to the value of the CurrencyInfo.CuryInfoID field.
	`ProjectCuryInvoicedExclusiveTax`	`decimal`	Exclusive Taxes on AR (Project Curr.)	-
Description:The exclusive tax amount in the project currency.
	`ProjectCuryInvoicedInclusiveTax`	`decimal`	Inclusive Taxes on AR (Project Curr.)	-
Description:The invoiced inclusive tax amount in the project currency.
	`ProjectCuryPaidARAmount`	`decimal`	AR Paid Amount (Project Curr.)	-
Description:The paid amount in the project currency.
	`ProjectCuryPaidExclusiveTax`	`decimal`	Exclusive Taxes on Paid AR (Project Curr.)	-
Description:The paid exclusive tax amount in the project currency.
	`ProjectCuryPaidInclusiveTax`	`decimal`	Paid Inclusive Tax (Project Curr.)	-
Description:The paid inclusive tax amount in the project currency.
	`ProjectCuryRGOL`	`decimal`	Realized Gain/Loss (Project Curr.)	-
Description:The realized gain or loss amount in the project currency.
	`ProjectCuryUnitPrice`Nonexistent in DB	`decimal?`	Unit Price (Project Curr.)	-
Description:The unit price in the project currency.
	`ProjectCuryWriteOff`	`decimal`	Write-Off Amount (Project Curr.)	-
Description:The write-off amount in the project currency.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:The project to which the transaction belongs. The value of this field corresponds to the value of the PMProject.ContractID field.
	`RGOL`	`decimal`	Realized Gain/Loss (Base Curr.)	-
Description:The realized gain or loss amount in the base currency.
	`RefLineNbr`	`int`	Line Nbr.	-
Description:The line number in the corresponding accounts receivable document associated with the transaction.
	`RefNoteID`	`uniqueidentifier`		-
Description:The INotable.NoteID value of the related entity.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:The project task of the project transaction. The value of this field corresponds to the value of the PMTask.taskID field.
	`TranCuryARAmount`	`decimal`	AR Amount	-
Description:The amount in the transaction currency.
	`TranCuryARCashDiscount`	`decimal`		-
Description:The cash discount amount in the transaction currency.
	`TranCuryARRetainageHeld`	`decimal`		-
Description:The retainage held amount in the transaction currency.
	`TranCuryARRetainedTaxHeld`	`decimal`		-
Description:The retained tax held amount in the transaction currency.
	`TranCuryExtPrice`	`decimal`	Extended Price	-
Description:The extended price in the transaction currency.
	`TranCuryInvoicedExclusiveTax`	`decimal`		-
Description:The exclusive tax amount in the transaction currency.
	`TranCuryInvoicedInclusiveTax`	`decimal`		-
Description:The invoiced inclusive tax amount in the transaction currency.
	`TranCuryPaidARAmount`	`decimal`	AR Paid Amount	-
Description:The paid amount in the transaction currency.
	`TranCuryPaidExclusiveTax`	`decimal`		-
Description:The paid exclusive tax amount in the transaction currency.
	`TranCuryPaidInclusiveTax`	`decimal`		-
Description:The paid inclusive tax amount in the transaction currency.
	`TranCuryWriteOff`	`decimal`		-
Description:The write-off amount in the transaction currency.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure of the line.
	`UnitPrice`Nonexistent in DB	`decimal?`	Unit Price (Base Curr.)	-
Description:The unit price in the project base currency.
	`WriteOff`	`decimal`	Write-Off Amount (Base Curr.)	-
Description:The write-off amount in the base currency.