Skip to main content
PM

PMProformaRevision

PX.Objects.PMRelease 2025.2

The projection of the PMProforma that contains the pro forma invoices that have been corrected.

Field NameTypeDisplay NameForeign Key
ARInvoiceDocType
nvarchar(3)AR Doc. Type-
Description:The type of the corresponding accounts receivable document created on release of the pro forma invoice. The field can have one of the values described in ARInvoiceType.ListAttribute.
ARInvoiceRefNbrDefault Navigation
nvarchar(15)AR Ref. Nbr.ARInvoice
Description:The reference number of the corresponding accounts receivable document created on release of the pro forma invoice. The value of this field corresponds to the value of the ARInvoice.RefNbr field.
CuryDocTotal
decimalInvoice Total-
Description:The invoice total. The sum of the progress billing total, time and material total, and tax total values.
CuryInfoID
bigint-
Description:The identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfoID field.
CuryRetainageDetailTotal
decimalRetainage Detail Total-
Description:The total retained amount for the progress billing lines and time and material lines of the pro forma invoice. Calculated as the sum of the values in the retainage amount column for the lines with progressive type plus the sum of the values in the retainage amount column for the lines with transaction type of the pro forma invoice.
CuryRetainageTaxInclTotal
decimalRetained Inclusive Tax Total-
Description:The total inclusive retained tax amount in document currency.
CuryRetainageTaxTotal
decimalRetained Tax Total-
Description:The total retained tax amount.
CuryRetainageTotalNonexistent in DB
decimal?Retainage Total-
Description:The total retained amount. Calculated as the sum of CuryRetainageDetailTotal and CuryRetainageTaxTotal.
CuryTaxTotal
decimalTax Total-
Description:The total tax amount of the document.
Description
nvarchar(255)Description-
Description:The description of the pro forma invoice, which is provided by the billing rule and can be manually modified.
DocTotal
decimalInvoice Total in Base Currency-
Description:The invoice total in the base currency.
RefNbr
nvarchar(15)-
Description:The reference number of the pro forma invoice. The number is generated from the numbering sequence, which is specified on the Projects Preferences (PM101000) form.
RetainageDetailTotal
decimalRetainage Detail Total in Base Currency-
Description:The total retained amount for the progress billing lines and time and material lines of the pro forma invoice in the base currency.
RetainageTaxInclTotal
decimalRetainage Inclusive Tax in Base Currency-
Description:The total inclusive retained tax amount in base currency.
RetainageTaxTotal
decimalRetainage Tax Total in Base Currency-
Description:The total retained tax amount in the base currency.
RetainageTotalNonexistent in DB
decimal?Retainage Total in Base Currency-
Description:The total retained amount in the base currency. Calculated as the sum of RetainageDetailTotal and RetainageTaxTotal.
ReversedARInvoiceDocType
nvarchar(3)Reversing Doc. Type-
Description:The type of the AR document that reverses the AR document specified in the AR Ref. Nbr. field. The field can have one of the values described in ARInvoiceType.ListAttribute.
ReversedARInvoiceRefNbrDefault Navigation
nvarchar(15)Reversing Ref. Nbr.ARInvoice
Description:The reference number of the AR document that reverses the AR document specified in the AR Ref. Nbr. field. The value of this field corresponds to the value of the ARInvoice.RefNbr field.
RevisionID
intRevision-
Description:The revision number of the pro forma invoice, which is an integer that the system assigns sequentially, starting from 1.
TaxTotal
decimalTax Total in Base Currency-
Description:The total tax amount of the document in the base currency.