PM
PMProformaRevision
The projection of the PMProforma that contains the pro forma invoices that have been corrected.
| Field Name | Type | Display Name | Foreign 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. | ||||
ARInvoiceRefNbr | 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 | decimal | Invoice 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 | decimal | Retainage 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 | decimal | Retained Inclusive Tax Total | - | |
Description:The total inclusive retained tax amount in document currency. | ||||
CuryRetainageTaxTotal | decimal | Retained 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 | decimal | Tax 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 | decimal | Invoice 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 | decimal | Retainage 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 | decimal | Retainage Inclusive Tax in Base Currency | - | |
Description:The total inclusive retained tax amount in base currency. | ||||
RetainageTaxTotal | decimal | Retainage 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. | ||||
ReversedARInvoiceRefNbr | 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 | int | Revision | - | |
Description:The revision number of the pro forma invoice, which is an integer that the system assigns sequentially, starting from 1. | ||||
TaxTotal | decimal | Tax Total in Base Currency | - | |
Description:The total tax amount of the document in the base currency. | ||||