PMProjectAPHistory

PX.Objects.PMRelease 2025.2

Represents a line of the project AP history by date.

Select a row for its description 74 of 74 fields

	Field Name	Type	Display Name	Foreign Key
	`APAmount`	`decimal`	AP Amount (Base Curr.)	-
Description:The AP amount in the base currency.
	`APCashDiscount`	`decimal`	AP Cash Discount (Base Curr.)	-
Description:The AP cash discount amount in the base currency.
	`APDocType`	`char(3)`	AP Document Type	-
Description:The type of the corresponding accounts payable document associated with the transaction.
	`APLineNbr`	`int`	AP Document Line Nbr.	-
Description:The line number in the corresponding accounts receivable document associated with the transaction.
	`APRefNbr`Default Navigation	`nvarchar(15)`	AP Document Ref. Nbr.	APInvoice
Description:The reference number of the corresponding accounts payable document associated with the transaction.
	`APRetainageHeld`	`decimal`	AP Retained Amount (Base Curr.)	-
Description:The AP retained amount in the base currency.
	`APRetainedTaxHeld`	`decimal`	AP Retained Taxes (Base Curr.)	-
Description:The AP retained tax 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.
	`BilledExclusiveTax`	`decimal`	Billed Tax (Base Curr.)	-
Description:The billed tax amount in the base currency.
	`BilledInclusiveTax`	`decimal`	Billed Inclusive Tax (Base Curr.)	-
Description:The billed inclusive tax amount in the base currency.
	`BilledQty`	`decimal`	Billed Qty.	-
Description:The billed quantity for the transaction line.
	`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.
	`CommittedAmt`	`decimal`	Committed Amount (Base Curr.)	-
Description:The committed amount in the base currency.
	`CommittedQty`	`decimal`	Committed Qty.	-
Description:The committed quantity for the transaction line.
	`CommittedRetainage`	`decimal`	Committed Retainage (Base Curr.)	-
Description:The committed retainage amount in the base currency.
	`CommittedUnitCost`Nonexistent in DB	`decimal?`	Committed Unit Cost (Base Curr.)	-
Description:The committed unit cost (in the base currency of the project).
	`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)`		-
Description:The identifier of the base currency. The value of this field corresponds to the value of the CurrencyList.CuryID field.
	`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. The field can have one of the values described in APHistoryEntityType.
	`ExtCost`	`decimal`	Extended Cost (Base Curr.)	-
Description:The extended cost 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.
	`IsRetainageDocument`	`bit`	Retainage Document	-
Description:A Boolean value that indicates (if set to true) that the document is a retainage document.
	`POLineNbr`	`int`	Commitment Line Nbr.	-
Description:The number of the corresponding purchase order line. The value of this field corresponds to the value of the POLine.LineNbr field.
	`POOrderNbr`Default Navigation	`nvarchar(15)`	Commitment Ref. Nbr.	POOrder
Description:The reference number of the corresponding PO Order. The value of this field corresponds to the value of the POOrder.OrderNbr field.
	`POOrderType`	`char(2)`	Commitment Doc. Type	-
Description:The type of the corresponding PO Order. The value of this field corresponds to the value of the POOrder.OrderType field.
	`PaidAPAmount`	`decimal`	AP Paid Amount (Base Curr.)	-
Description:The paid AP amount in the base currency.
	`PaidExclusiveTax`	`decimal`	Exclusive Taxes on Paid AP (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.
	`ProjectCuryAPAmount`	`decimal`	AP Amount (Project Curr.)	-
Description:The AP amount in the project currency.
	`ProjectCuryAPCashDiscount`	`decimal`	AP Cash Discount (Project Curr.)	-
Description:The AP cash discount amount in the project currency.
	`ProjectCuryAPRetainageHeld`	`decimal`	AP Retained Amount (Project Curr.)	-
Description:The AP retained amount in the project currency.
	`ProjectCuryAPRetainedTaxHeld`	`decimal`	AP Retained Taxes (Project Curr.)	-
Description:The AP retained tax amount in the project currency.
	`ProjectCuryBilledExclusiveTax`	`decimal`	Billed Tax (Project Curr.)	-
Description:The billed tax amount in the project currency.
	`ProjectCuryBilledInclusiveTax`	`decimal`	Billed Inclusive Tax (Project Curr.)	-
Description:The billed inclusive tax amount in the project currency.
	`ProjectCuryCommittedAmt`	`decimal`	Committed Amount (Project Curr.)	-
Description:The committed amount in the project currency.
	`ProjectCuryCommittedRetainage`	`decimal`	Committed Retainage (Project Curr.)	-
Description:The committed retainage amount in the project currency.
	`ProjectCuryCommittedUnitCost`Nonexistent in DB	`decimal?`	Committed Unit Cost (Project Curr.)	-
Description:The committed unit cost (in the project currency).
	`ProjectCuryExtCost`	`decimal`	Extended Cost (Project Curr.)	-
Description:The extended cost 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.
	`ProjectCuryPaidAPAmount`	`decimal`	AP Paid Amount (Project Curr.)	-
Description:The paid AP amount in the project currency.
	`ProjectCuryPaidExclusiveTax`	`decimal`	Exclusive Taxes on Paid AP (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.
	`ProjectCuryUnitCost`Nonexistent in DB	`decimal?`	Unit Cost (Project Curr.)	-
Description:The unit cost in the project currency.
	`ProjectCuryUseTax`	`decimal`	Use Tax (Project Curr.)	-
Description:The use tax amount in the project currency.
	`ProjectCuryWithheldTax`	`decimal`	Withheld Tax Amount (Project Curr.)	-
Description:The withheld tax 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 payable 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.
	`TranCuryAPAmount`	`decimal`	AP Amount	-
Description:The AP amount in the transaction currency.
	`TranCuryAPCashDiscount`	`decimal`		-
Description:The AP cash discount amount in the transaction currency.
	`TranCuryAPRetainageHeld`	`decimal`		-
Description:The AP retained amount in the transaction currency.
	`TranCuryAPRetainedTaxHeld`	`decimal`		-
Description:The AP retained tax amount in the transaction currency.
	`TranCuryBilledExclusiveTax`	`decimal`		-
Description:The billed tax amount in the transaction currency.
	`TranCuryBilledInclusiveTax`	`decimal`		-
Description:The billed inclusive tax amount in the transaction currency.
	`TranCuryCommittedAmt`	`decimal`		-
Description:The committed amount in the transaction currency.
	`TranCuryCommittedRetainage`	`decimal`		-
Description:The committed retainage amount in the transaction currency.
	`TranCuryExtCost`	`decimal`	Extended Cost	-
Description:The extended cost in the transaction currency.
	`TranCuryPaidAPAmount`	`decimal`	AP Paid Amount	-
Description:The paid AP 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.
	`TranCuryUseTax`	`decimal`		-
Description:The use tax amount in the transaction currency.
	`TranCuryWithheldTax`	`decimal`		-
Description:The withheld tax amount in the transaction currency.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure of the line.
	`UnitCost`Nonexistent in DB	`decimal?`	Unit Cost (Base Curr.)	-
Description:The unit cost in the project base currency.
	`UseTax`	`decimal`	Use Tax (Base Curr.)	-
Description:The use tax amount in the base currency.
	`VendorID`Default Navigation	`int`	Vendor	Vendor
Description:The identifier of the Vendor record associated with the document.
	`WithheldTax`	`decimal`	Withheld Tax Amount (Base Curr.)	-
Description:The withheld tax amount in the base currency.