PM
PMProformaProgressLine
PX.Objects.PM71 of 71 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Number | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Number | PMProforma | |
Description:No description available | ||||
RevisionID | int | Revision | - | |
Description:No description available | ||||
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
AccountID | 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 | ||||
BillableAmount | decimal | Billed Amount in Base Currency | - | |
Description:No description available | ||||
BillableQty | decimal | Billed Quantity | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CompletedPctNonexistent in DB | decimal | Total Completed (%) | - | |
Description:No description available | ||||
Corrected | bit | Corrected | - | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CurrentInvoicedPctNonexistent in DB | decimal | Currently Invoiced (%) | - | |
Description:No description available | ||||
CuryAllocatedRetainedAmount | decimal | Allocated Retained Amount | - | |
Description:No description available | ||||
CuryAmount | decimal | Amount | - | |
Description:No description available | ||||
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 | ||||
CuryMergedAmount | decimal | Amount Included in Progress Billing | - | |
Description:No description available | ||||
CuryPrepaidAmount | decimal | Prepaid Applied | - | |
Description:No description available | ||||
CuryPreviouslyInvoiced | decimal | Previously Invoiced Amount | - | |
Description:The running total of the amount to invoice column for all the lines of preceding pro forma invoices that refer to the same revenue budget line. The preceding pro forma invoices are the pro forma invoices that have a reference number that is less than the reference number of the current pro forma invoice, and have the same project budget key (that is, the same project task, account group, and optionally inventory item or cost code). | ||||
CuryRetainage | decimal(19, 4) | Retainage Amount | - | |
Description:No description available | ||||
CuryTimeMaterialAmount | decimal | Time and Material Amount | - | |
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
Date | datetime2 | Date | - | |
Description:No description available | ||||
DefCode | nvarchar(10) | Deferral Code | DRDeferredCode | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
IsPrepayment | bit | - | ||
Description:No description available | ||||
LastModifiedByID | 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 | ||||
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 | varchar(MAX) | Status | - | |
Description:No description available | ||||
OrigAccountGroupID | int | - | ||
Description:No description available | ||||
PrepaidAmount | decimal | Prepaid Applied in Base Currency | - | |
Description:No description available | ||||
PreviouslyInvoiced | decimal | Previously Invoiced in Base Currency | - | |
Description:The running total of the Amount to Invoice column in the base currency for all the lines of preceding pro forma invoices that refer to the same revenue budget line. | ||||
PreviouslyInvoicedQty | decimal | Previously Invoiced Quantity | - | |
Description:The running total of the Quantity to Invoice column for all the lines of preceding pro forma invoices that refer to the same revenue budget line. | ||||
ProgressBillingBase | nvarchar(1) | 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 | 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 | int | Revenue Task | PMTask | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SortOrder | int | Sort Order | - | |
Description:No description available | ||||
SubID | int | Sales Subaccount | Sub | |
Description:No description available | ||||
TaskID | 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 | 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 Progressive type. | ||||
UnitPrice | decimal | Unit Price in Base Currency | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | Vendor | BAccount | |
Description:No description available | ||||