PMProformaLine

PX.Objects.PM

71 of 71 fields

	Field Name	Type	Display Name	Foreign Key
	`LineNbr`	`int`	Line Number	-
Description:The original sequence number of the line among all the pro forma invoice lines. The sequence of line numbers of the pro forma invoice lines belonging to a single document can include gaps.
	`RefNbr`Default Navigation	`nvarchar(15)`	Ref. Number	-
Description:No description available
	`RevisionID`	`int`	Revision	PMProforma
Description:The revision number of the parent pro forma invoice. The value of this field corresponds to the value of the PMProforma.RevisionID field.
	`AccountGroupID`	`int`		PMAccountGroup
Description:The identifier of the account group associated with the pro forma invoice line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`AccountID`Default Navigation	`int`	Sales Account	Account
Description:No description available
	`ActualQty`	`decimal(19, 6)`	Actual Quantity	-
Description:No description available
	`AllocatedRetainedAmount`	`decimal(19, 4)`		-
Description:The allocated retained amount (in the base currency).
	`Amount`	`decimal(19, 4)`	Amount	-
Description:The line amount in the base currency.
	`ARInvoiceDocType`	`char(3)`		-
Description:The type of the corresponding accounts receivable document created on the release of the pro forma invoice.
	`ARInvoiceLineNbr`	`int`		-
Description:The line number of the corresponding accounts receivable document created on the release of the pro forma invoice.
	`ARInvoiceRefNbr`	`nvarchar(15)`		-
Description:The reference number of the corresponding accounts receivable document created on the release of the pro forma invoice.
	`BillableAmount`	`decimal(19, 4)`	Billed Amount in Base Currency	-
Description:No description available
	`BillableQty`	`decimal(19, 6)`	Billed Quantity	-
Description:The quantity to bill the customer provided by the billing rule.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The identifier of the branch associated with the pro forma invoice line. The branch is provided from the source defined by the Use Destination Branch from setting of the particular step of the billing rule. The value of this field corresponds to the value of the Branch.BranchID field.
	`CompletedPct`Nonexistent in DB	`decimal`	Total Completed (%)	-
Description:The percentage of the revised budgeted amount of the revenue budget line of the project that has been invoiced by all the pro forma invoices of the project, including the current one.
	`Corrected`	`bit`	Corrected	-
Description:Specifies (if set to ) that the parent pro forma invoice has been corrected.
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The identifier of the cost code associated with the pro forma invoice line. The value of this field corresponds to the value of the PMCostCode.CostCodeID field.
	`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
	`CurrentInvoicedPct`Nonexistent in DB	`decimal`	Currently Invoiced (%)	-
Description:The percentage of the revised budgeted amount of the revenue budget line of the project that is invoiced by this pro forma invoice line.
	`CuryAllocatedRetainedAmount`	`decimal(19, 4)`	Allocated Retained Amount	-
Description:The allocated retained amount.
	`CuryAmount`	`decimal(19, 4)`	Amount	-
Description:The line amount.
	`CuryBillableAmount`	`decimal(19, 4)`	Billed Amount	-
Description:The amount to bill the customer provided by the billing rule.
	`CuryInfoID`	`bigint`		-
Description:An identifier of the currency info object associated with the pro forma invoice line.
	`CuryLineTotal`	`decimal(19, 4)`	Amount to Invoice	-
Description:The amount that is billed to the customer.
	`CuryMaterialStoredAmount`	`decimal(19, 4)`	Stored Material	-
Description:The amount of stored material.
	`CuryMergedAmount`	`decimal(19, 4)`	Amount Included in Progress Billing	-
Description:The amount that is merged to the progress billing line.
	`CuryPrepaidAmount`	`decimal(19, 4)`	Prepaid Applied	-
Description:The field is reserved for a feature that is currently not supported.
	`CuryPreviouslyInvoiced`	`decimal(19, 4)`	Previously Invoiced Amount	-
Description:No description available
	`CuryRetainage`	`decimal(19, 4)`	Retainage Amount	-
Description:The amount to be retained by the customer. The amount is calculated by multiplying the values of Amount to Invoice and Retainage.
	`CuryTimeMaterialAmount`	`decimal(19, 4)`	Time and Material Amount	-
Description:The amount of material stored.
	`CuryUnitPrice`	`decimal(19, 6)`	Unit Price	-
Description:The price of the item or the rate of the service.
	`Date`	`datetime2`	Date	-
Description:The date of the pro forma invoice line. Defaults to the current business date.
	`DefCode`Default Navigation	`nvarchar(10)`	Deferral Code	DRDeferredCode
Description:The deferral code assigned to the stock item or non-stock item specified in this document line.
	`Description`	`nvarchar(256)`	Description	-
Description:The description of the line, which is provided by the billing rule and can be manually modified.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The identifier of the inventory item associated with the pro forma invoice line. The value of this field corresponds to the value of the InventoryItem.InventoryID field.
	`IsPrepayment`	`bit`		-
Description:The field is reserved for a feature that is currently not supported.
	`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
	`LineTotal`	`decimal(19, 4)`	Amount To Invoice in Base Currency	-
Description:The amount to bill the customer in the base currency.
	`MaterialStoredAmount`	`decimal(19, 4)`	Stored Material in Base Currency	-
Description:The amount of stored material (in the base currency).
	`Merged`	`bit`	Include in Progress Billing	-
Description:A Boolean value that indicates whether the line is merged into the progress line.
	`MergedAmount`	`decimal(19, 4)`		-
Description:No description available
	`MergedToLineNbr`	`int`	Progress Billing Line Nbr.	-
Description:The line number of the progress billing record to which this transaction line is merged.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`Option`	`char(1)`	Status	-
Description:The status that defines how to bill the line. The field can have one of the following values: - "N": Bill - "C": Write Off Remainder - "U": Hold Remainder - "X": Write Off
	`OrigAccountGroupID`	`int`		-
Description:The identifier of the original cost account group associated with the pro forma invoice line. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.
	`PrepaidAmount`	`decimal(19, 4)`	Prepaid Applied in Base Currency	-
Description:The field is reserved for a feature that is currently not supported.
	`PreviouslyInvoiced`	`decimal(19, 4)`	Previously Invoiced in Base Currency	-
Description:No description available
	`PreviouslyInvoicedQty`	`decimal(19, 6)`	Previously Invoiced Quantity	-
Description:No description available
	`ProgressBillingBase`	`nvarchar(1)`	Progress Billing Basis	-
Description:The value that the system has used as the basis for the progress billing operation that has generated this pro forma invoice line.
	`ProjectID`	`int`		PMProject
Description:The identifier of the project associated with the pro forma invoice line. Defaults to the project of the parent pro forma invoice. The value of this field corresponds to the value of the PMProject.ContractID field.
	`Qty`	`decimal(19, 6)`	Quantity to Invoice	-
Description:The quantity to bill the customer. The value can be manually modified.
	`Released`	`bit`	Released	-
Description:Specifies (if set to ) that the parent pro forma invoice has been released.
	`ResourceID`Default Navigation	`int`	Employee	EPEmployee
Description:The identifier of the employee associated with the pro forma invoice line.
	`Retainage`	`decimal(19, 4)`	Retained Amount in Base Currency	-
Description:The amount to be retained by the customer in the base currency.
	`RetainagePct`	`decimal(19, 6)`	Retainage (%)	-
Description:The percent of the invoice line amount to be retained by the customer.
	`RevenueTaskID`Default Navigation	`int`	Revenue Task	PMTask
Description:The reference to a revenue budget line by task.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`SortOrder`	`int`	Sort Order	-
Description:The sequence number of the line, which is used to sort the lines on the tab. These numbers are assigned automatically and are changed automatically when reordering lines by dragging them to appropriate positions.
	`SubID`Default Navigation	`int`	Sales Subaccount	Sub
Description:The identifier of the sales subaccount associated with the pro forma invoice line. The value of this field corresponds to the value of the Sub.SubID field.
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:The identifier of the task associated with the pro forma invoice line. The value of this field corresponds to the value of the PMTask.TaskID field.
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TimeMaterialAmount`	`decimal(19, 4)`	Time and Material Amount in Base Currency	-
Description:The amount of material stored in the base currency.
	`tstamp`	`timestamp`		-
Description:No description available
	`Type`	`char(1)`		-
Description:The type of the pro forma invoice line. The field can have one of the following values and regulates on which tab (Progress Billing or Time and Material Billing) of the Pro Forma Invoices (PM307000) form the invoice line appears: ""P"": Progressive, ""T"": Transaction
	`UnitPrice`	`decimal(19, 6)`	Unit Price in Base Currency	-
Description:The price of the item or the rate of the service in the base currency.
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure for the quantity associated with the pro forma invoice line.
	`VendorID`Default Navigation	`int`	Vendor	BAccount
Description:The identifier of the vendor associated with the pro forma invoice line. The value of this field corresponds to the value of the BAccount.BAccountID field.