PMProformaTransactLine

PX.Objects.PM

77 of 77 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	PMProforma
Description:No description available
	`RevisionID`	`int`	Revision	-
Description:No description available
	`AccountGroupID`	`int`		PMAccountGroup
Description:No description available
	`AccountID`Default Navigation	`int`	Sales Account	Account
Description:No description available
	`ActualQty`	`decimal`	Actual Quantity	-
Description:No description available
	`AllocatedRetainedAmount`	`decimal`		-
Description:No description available
	`Amount`	`decimal`	Amount	-
Description:No description available
	`ARInvoiceDocType`	`varchar(3)`		-
Description:No description available
	`ARInvoiceLineNbr`	`int`		-
Description:No description available
	`ARInvoiceRefNbr`	`nvarchar(15)`		-
Description:No description available
	`AvailableAmount`Nonexistent in DB	`decimal`	Max Available Amount in Base Currency	-
Description:The maximum amount in the base currency available to bill the customer based on the billing limit amount of the corresponding revenue budget line of the project.
	`BillableAmount`	`decimal`	Billed Amount in Base Currency	-
Description:No description available
	`BillableQty`	`decimal`	Billed Quantity	-
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`CompletedPct`Nonexistent in DB	`decimal`	Total Completed (%)	-
Description:No description available
	`Corrected`	`bit`	Corrected	-
Description:No description available
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`varchar(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CurrentInvoicedPct`Nonexistent in DB	`decimal`	Currently Invoiced (%)	-
Description:No description available
	`CuryAllocatedRetainedAmount`	`decimal`	Allocated Retained Amount	-
Description:No description available
	`CuryAmount`	`decimal(19, 4)`	Amount	-
Description:The line amount. Calculated by multiplying the values of Quantity to Invoice and Unit Price.
	`CuryAvailableAmount`Nonexistent in DB	`decimal`	Max Available Amount	-
Description:The maximum amount available to bill the customer based on the billing limit amount of the corresponding revenue budget line of the project.
	`CuryBillableAmount`	`decimal`	Billed Amount	-
Description:No description available
	`CuryInfoID`	`bigint`		-
Description:No description available
	`CuryLineTotal`	`decimal(19, 4)`	Amount to Invoice	-
Description:No description available
	`CuryMaterialStoredAmount`	`decimal`	Stored Material	-
Description:No description available
	`CuryMaxAmount`Nonexistent in DB	`decimal`	Max Limit Amount	-
Description:The billing limit amount (Maximum Amount) of the corresponding revenue budget line of the project. If no billing limit amount is defined for the revenue budget line of the project, the Max Limit Amount of each corresponding pro forma invoice line is 0.
	`CuryMergedAmount`	`decimal`	Amount Included in Progress Billing	-
Description:No description available
	`CuryOverflowAmount`Nonexistent in DB	`decimal`	Over-Limit Amount	-
Description:The amount that exceeds the billing limit. The amount is calculated as the difference between the Amount to Invoice and Max Available Amount. If this difference is negative - that is, if the Max Available Amount is greater than the Amount to Invoice - the Over-Limit Amount is 0. The invoice lines for which the Over-Limit Amount becomes nonzero exceed the limit.
	`CuryPrepaidAmount`	`decimal`	Prepaid Applied	-
Description:No description available
	`CuryPreviouslyInvoiced`	`decimal`	Previously Invoiced Amount	-
Description:No description available
	`CuryRetainage`	`decimal(19, 4)`	Retainage Amount	-
Description:No description available
	`CuryTimeMaterialAmount`	`decimal`	Time and Material Amount	-
Description:No description available
	`CuryUnitPrice`	`decimal`	Unit Price	-
Description:No description available
	`Date`	`datetime2`	Date	-
Description:No description available
	`DefCode`Default Navigation	`nvarchar(10)`	Deferral Code	DRDeferredCode
Description:No description available
	`Description`	`nvarchar(256)`	Description	-
Description:No description available
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:No description available
	`IsPrepayment`	`bit`		-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`varchar(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LineTotal`	`decimal`	Amount To Invoice in Base Currency	-
Description:No description available
	`MaterialStoredAmount`	`decimal`	Stored Material in Base Currency	-
Description:No description available
	`MaxAmount`Nonexistent in DB	`decimal`	Max Limit Amount in Base Currency	-
Description:The billing limit amount (Maximum Amount) of the corresponding revenue budget line of the project in the base currency.
	`Merged`	`bit`	Include in Progress Billing	-
Description:No description available
	`MergedAmount`	`decimal`		-
Description:No description available
	`MergedToLineNbr`	`int`	Progress Billing Line Nbr.	-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`Option`	`char(1)`	Status	-
Description:No description available
	`OrigAccountGroupID`	`int`		-
Description:No description available
	`OverflowAmount`Nonexistent in DB	`decimal`	Overflow Amount in Base Currency	-
Description:The amount that exceeds the billing limit in the base currency.
	`PrepaidAmount`	`decimal`	Prepaid Applied in Base Currency	-
Description:No description available
	`PreviouslyInvoiced`	`decimal`	Previously Invoiced in Base Currency	-
Description:No description available
	`PreviouslyInvoicedQty`	`decimal`	Previously Invoiced Quantity	-
Description:No description available
	`ProgressBillingBase`	`nvarchar(MAX)`	Progress Billing Basis	-
Description:No description available
	`ProjectID`	`int`		PMProject
Description:No description available
	`Qty`	`decimal`	Quantity to Invoice	-
Description:No description available
	`Released`	`bit`	Released	-
Description:No description available
	`ResourceID`Default Navigation	`int`	Employee	EPEmployee
Description:No description available
	`Retainage`	`decimal`	Retained Amount in Base Currency	-
Description:No description available
	`RetainagePct`	`decimal`	Retainage (%)	-
Description:No description available
	`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:No description available
	`SubID`Default Navigation	`int`	Sales Subaccount	Sub
Description:No description available
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:No description available
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:No description available
	`TimeMaterialAmount`	`decimal`	Time and Material Amount in Base Currency	-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`Type`	`char(1)`		-
Description:The type of the pro forma invoice line. Defaults to the Transaction type.
	`UnitPrice`	`decimal`	Unit Price in Base Currency	-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:No description available
	`VendorID`Default Navigation	`int`	Vendor	BAccount
Description:No description available