PM
PMProformaLineWithPrevious
PX.Objects.PM72 of 72 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Number | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Number | - | |
Description:No description available | ||||
RevisionID | int | Revision | PMProforma | |
Description:No description available | ||||
AccountGroupID | int | 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 | 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(19, 4) | Previously Invoiced | - | |
Description:No description available | ||||
CuryRetainage | decimal | 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 | 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(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:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
Qty | decimal(19, 6) | Quantity to Invoice | - | |
Description:No description available | ||||
QuantityBaseCompletedPctNonexistent in DB | decimal | Total Completed (%) | - | |
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:No description available | ||||
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 | varchar(1) | - | ||
Description:No description available | ||||
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 | ||||