PMProforma

PX.Objects.PM

79 of 79 fields

	Field Name	Type	Display Name	Foreign Key
	`RefNbr`Default Navigation	`nvarchar(15)`	Reference Nbr.	-
Description:No description available
	`RevisionID`	`int`	Revision	-
Description:The revision number of the pro forma invoice, which is an integer that the system assigns sequentially, starting from 1.
	`AllocatedRetainedTotal`	`decimal(19, 4)`		-
Description:The allocated retained total (in the base currency).
	`AmountDue`Nonexistent in DB	`decimal`	Amount Due Total in Base Currency	-
Description:The amount due in the base currency. The difference between the invoice total and retainage total.
	`Approved`	`bit`		-
Description:Specifies (if set to ) that the document is approved.
	`ARInvoiceDocType`	`char(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.
	`ARInvoiceRefName`Nonexistent in DB	`nvarchar(MAX)`	AR Ref. Nbr.	-
Description:The reference name to the corresponding accounts receivable document created on release of the pro forma invoice. The value of this field corresponds to the value of the ARInvoiceRefNbr field.
	`ARInvoiceRefNbr`Default Navigation	`nvarchar(15)`	AR Ref. Nbr.	ARInvoice
Description:No description available
	`ARInvoiceRefStatus`	`nvarchar(MAX)`	AR Doc. Status	-
Description:No description available
	`AvalaraCustomerUsageType`	`char(1)`	Tax Exemption Type	-
Description:No description available
	`BillAddressID`	`int`		-
Description:No description available
	`BillContactID`Default Navigation	`int`	Billing Contact	PMContact
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The identifier of the Branch to which the pro forma invoice belongs. The value of this field corresponds to the value of the Branch.BranchID field.
	`Corrected`	`bit`	Corrected	-
Description:Specifies (if set to ) that the document has been corrected.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CuryAllocatedRetainedTotal`	`decimal(19, 4)`	Allocated Retained Total	-
Description:The allocated retained total.
	`CuryAmountDue`Nonexistent in DB	`decimal`	Amount Due	-
Description:The amount due. The difference between the Invoice Total and Retainage Total.
	`CuryDocTotal`	`decimal(19, 4)`	Invoice Total	-
Description:The invoice total. The sum of the progress billing total, time and material total, and tax total values.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The identifier of the pro forma invoice currency. The value of this field corresponds to the value of the Currency.CuryID field.
	`CuryInfoID`	`bigint`		-
Description:The identifier of the CurrencyInfo object associated with the document. Corresponds to the CurrencyInfoID field.
	`CuryProgressiveTotal`	`decimal(19, 4)`	Progress Billing Total	-
Description:The total amount to invoice of the progress billing lines of the document.
	`CuryRetainageDetailTotal`	`decimal(19, 4)`	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(19, 4)`	Retained Inclusive Tax Total	-
Description:The total inclusive retained tax amount in document currency.
	`CuryRetainageTaxTotal`	`decimal(19, 4)`	Retained Tax Total	-
Description:The total retained tax amount.
	`CuryRetainageTotal`Nonexistent in DB	`decimal`	Retainage Total	-
Description:The total retained amount. Calculated as the sum of CuryRetainageDetailTotal and CuryRetainageTaxTotal.
	`CuryTaxInclTotal`	`decimal(19, 4)`	Inclusive Tax Total	-
Description:The total inclusive tax amount of the document in document currency.
	`CuryTaxTotal`	`decimal(19, 4)`	Tax Total	-
Description:The total tax amount of the document.
	`CuryTaxTotalWithRetainage`Nonexistent in DB	`decimal`	Tax Total	-
Description:The tax amount of the document. Calculated as the sum of CuryTaxTotal plus CuryRetainageTaxTotal.
	`CuryTransactionalTotal`	`decimal(19, 4)`	Time and Material Total	-
Description:The total amount to invoice of the time and material lines of the document.
	`CustomerID`Default Navigation	`int`	Customer	BAccount
Description:The identifier of the Customer associated with the pro forma invoice. Defaults to the customer associated with the project. The value of this field corresponds to the value of the BAccount.BAccountID field.
	`Description`	`nvarchar(255)`	Description	-
Description:The description of the pro forma invoice, which is provided by the billing rule and can be manually modified.
	`DiscDate`	`datetime2`	Cash Discount Date	-
Description:The end date of the cash discount period, which the system calculates by using the credit terms.
	`DocTotal`	`decimal(19, 4)`	Invoice Total in Base Currency	-
Description:The invoice total in the base currency.
	`DueDate`	`datetime2`	Due Date	-
Description:The date when the payment for the document is due, in accordance with the credit terms.
	`EnableProgressive`	`bit`	Enable Progressive Tab	-
Description:Specifies (if set to ) that the document has lines of project progress billing type.
	`EnableTransactional`	`bit`	Enable Transactions Tab	-
Description:Specifies (if set to ) that the document has lines of project time and material billing type.
	`ExternalTaxExemptionNumber`	`nvarchar(30)`	Tax Exemption Number	-
Description:No description available
	`ExtRefNbr`	`nvarchar(30)`	External Ref. Nbr	-
Description:The reference number of the external document.
	`FinPeriodID`Default Navigation	`char(6)`	Post Period	-
Description:No description available
	`Hold`	`bit`	Hold	-
Description:Specifies (if set to ) that the document is on hold.
	`InvoiceDate`	`datetime2`	Invoice Date	-
Description:The date on which the pro forma invoice was created.
	`InvoiceNbr`	`nvarchar(40)`	Customer Order Nbr.	-
Description:The original reference number or ID assigned by the customer to the customer document.
	`IsAIAOutdated`	`bit`	AIA Is Outdated	-
Description:Specifies (if set to ) that the current version of the AIA report is not up-to-date and should be reprinted.
	`IsMigratedRecord`	`bit`	Migrated	-
Description:No description available
	`IsTaxValid`	`bit`	Tax Is Up to Date	-
Description:Specifies (if set to ) that the amount of tax calculated with the external tax engine (such as Avalara) is up to date. If this field equals , the document was updated since the last synchronization with the tax Engine and taxes might need recalculation.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LineCntr`	`int`		-
Description:A counter of the document lines, which is used internally to assign numbers to newly created lines. We do not recommend that you rely on this field to determine the exact number of lines because it might not reflect the this number under various conditions.
	`LocationID`Default Navigation	`int`	Location	Location
Description:The identifier of the Location associated with the pro forma invoice. The value of this field corresponds to the value of the Location.LocationID field.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`NumberOfLines`	`int`		-
Description:No description available
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:The contact responsible for the document. Corresponds to the Contact.ContactID field.
	`ProgressiveTotal`	`decimal(19, 4)`	Progress Billing Total in Base Currency	-
Description:The total amount to invoice of the progress billing lines of the document in the base currency.
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:No description available
	`ProjectNbr`	`nvarchar(15)`	Application Nbr.	-
Description:The application number.
	`Rejected`	`bit`		-
Description:Specifies (if set to ) that the document is rejected.
	`Released`	`bit`	Released	-
Description:Specifies (if set to ) that the document has been released.
	`RetainageDetailTotal`	`decimal(19, 4)`	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.
	`RetainagePct`	`decimal(19, 6)`	Retainage (%)	-
Description:The retainage in percents.
	`RetainageTaxInclTotal`	`decimal(19, 4)`	Retainage Inclusive Tax in Base Currency	-
Description:The total inclusive retained tax amount in base currency.
	`RetainageTaxTotal`	`decimal(19, 4)`	Retainage Tax Total in Base Currency	-
Description:The total retained tax amount in the base currency.
	`RetainageTotal`Nonexistent 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`	`char(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`Default 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.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`ShipAddressID`	`int`		-
Description:No description available
	`ShipContactID`Default Navigation	`int`	Shipping Contact	PMContact
Description:No description available
	`Status`	`char(1)`	Status	-
Description:The read-only status of the document. The field can have one of the following values: ""H"": On Hold, ""A"": Pending Approval, ""O"": Open, ""C"": Closed, ""R"": Rejected
	`TaxInclTotal`	`decimal(19, 4)`	Inclusive Tax Total in Base Currency	-
Description:The total inclusive tax amount of the document in base currency.
	`TaxTotal`	`decimal(19, 4)`	Tax Total in Base Currency	-
Description:The total tax amount of the document in the base currency.
	`TaxTotalWithRetainage`Nonexistent in DB	`decimal`	Amount Due Total in Base Currency	-
Description:The tax amount of the document in the base currency. Calculated as the sum of TaxTotal and RetainageTaxTotal.
	`TaxZoneID`Default Navigation	`nvarchar(15)`	Customer Tax Zone	TaxZone
Description:The identifier of the TaxZone associated with the document. Corresponds to the TaxZone.TaxZoneID field.
	`TermsID`Default Navigation	`nvarchar(10)`	Terms	Terms
Description:The identifier of the credit terms object associated with the document. Defaults to the credit terms that are selected for the customer. The value corresponds to the value of the Terms.TermsID field.
	`TransactionalTotal`	`decimal(19, 4)`	Time and Material Total in Base Currency	-
Description:The total amount to invoice of the time and material lines of the document in the base currency.
	`tstamp`	`timestamp`		-
Description:No description available
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The workgroup that is responsible for the document. Corresponds to the EPCompanyTree.WorkGroupID field.