PM
PMBudget
PX.Objects.PM115 of 115 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
ProjectID | int | PMProject | ||
Description:No description available | ||||
ProjectTaskID | int | PMTask | ||
Description:No description available | ||||
ActualAmount | decimal(19, 4) | Hist. Actual Amount in Base Currency | - | |
Description:No description available | ||||
ActualPlusOpenCommittedAmountNonexistent in DB | decimal | Actual + Open Committed Amount in Base Currency | - | |
Description:No description available | ||||
ActualQty | decimal(19, 6) | Actual Quantity | - | |
Description:No description available | ||||
Amount | decimal(19, 4) | Original Budgeted Amount in Base Currency | - | |
Description:No description available | ||||
AmountToInvoice | decimal(19, 4) | Pending Invoice Amount in Base Currency | - | |
Description:No description available | ||||
BaseActualAmountNonexistent in DB | decimal | Actual Amount in Base Currency | - | |
Description:No description available | ||||
ChangeOrderAmount | decimal(19, 4) | Budgeted CO Amount in Base Currency | - | |
Description:No description available | ||||
ChangeOrderQty | decimal(19, 6) | Budgeted CO Quantity | - | |
Description:No description available | ||||
CommittedAmount | decimal(19, 4) | Revised Committed Amount in Base Currency | - | |
Description:No description available | ||||
CommittedCOAmountNonexistent in DB | decimal | Committed CO Amount in Base Currency | - | |
Description:No description available | ||||
CommittedCOQtyNonexistent in DB | decimal | Committed CO Quantity | - | |
Description:No description available | ||||
CommittedInvoicedAmount | decimal(19, 4) | Committed Invoiced Amount in Base Currency | - | |
Description:No description available | ||||
CommittedInvoicedQty | decimal(19, 6) | Committed Invoiced Quantity | - | |
Description:No description available | ||||
CommittedOpenAmount | decimal(19, 4) | Committed Open Amount in Base Currency | - | |
Description:No description available | ||||
CommittedOpenQty | decimal(19, 6) | Committed Open Quantity | - | |
Description:No description available | ||||
CommittedOrigAmount | decimal(19, 4) | Original Committed Amount in Base Currency | - | |
Description:No description available | ||||
CommittedOrigQty | decimal(19, 6) | Original Committed Quantity | - | |
Description:No description available | ||||
CommittedQty | decimal(19, 6) | Revised Committed Quantity | - | |
Description:No description available | ||||
CommittedReceivedQty | decimal(19, 6) | Committed Received Quantity | - | |
Description:No description available | ||||
CompletedPct | decimal(19, 4) | Completed (%) | - | |
Description:No description available | ||||
CostAtCompletion | decimal(19, 4) | Cost at Completion | - | |
Description:No description available | ||||
CostProjectionCompletedPct | decimal(19, 6) | Projected Completed (%) | - | |
Description:No description available | ||||
CostProjectionCostAtCompletion | decimal(19, 6) | Projected Cost at Completion in Base Currency | - | |
Description:No description available | ||||
CostProjectionCostToComplete | decimal(19, 6) | Projected Cost To Complete in Base Currency | - | |
Description:No description available | ||||
CostProjectionQtyAtCompletion | decimal(19, 6) | Projected Quantity at Completion | - | |
Description:No description available | ||||
CostProjectionQtyToComplete | decimal(19, 6) | Projected Quantity to Complete | - | |
Description:No description available | ||||
CostToComplete | decimal(19, 4) | Cost To Complete in Base Currency | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryActualAmount | decimal(19, 4) | Actual Amount | - | |
Description:No description available | ||||
CuryActualPlusOpenCommittedAmountNonexistent in DB | decimal | Actual + Open Committed Amount | - | |
Description:No description available | ||||
CuryAmount | decimal(19, 4) | Original Budgeted Amount | - | |
Description:No description available | ||||
CuryAmountToInvoice | decimal(19, 4) | Pending Invoice Amount | - | |
Description:No description available | ||||
CuryChangeOrderAmount | decimal(19, 4) | Budgeted CO Amount | - | |
Description:No description available | ||||
CuryCommittedAmount | decimal(19, 4) | Revised Committed Amount | - | |
Description:No description available | ||||
CuryCommittedCOAmountNonexistent in DB | decimal | Committed CO Amount | - | |
Description:No description available | ||||
CuryCommittedInvoicedAmount | decimal(19, 4) | Committed Invoiced Amount | - | |
Description:No description available | ||||
CuryCommittedOpenAmount | decimal(19, 4) | Committed Open Amount | - | |
Description:No description available | ||||
CuryCommittedOrigAmount | decimal(19, 4) | Original Committed Amount | - | |
Description:No description available | ||||
CuryCostAtCompletion | decimal(19, 4) | Cost at Completion | - | |
Description:No description available | ||||
CuryCostProjectionCostAtCompletion | decimal(19, 6) | Projected Cost at Completion | - | |
Description:No description available | ||||
CuryCostProjectionCostToComplete | decimal(19, 6) | Projected Cost to Complete | - | |
Description:No description available | ||||
CuryCostToComplete | decimal(19, 4) | Cost to Complete | - | |
Description:No description available | ||||
CuryDraftChangeOrderAmount | decimal(19, 4) | Potential CO Amount | - | |
Description:No description available | ||||
CuryDraftRetainedAmount | decimal(19, 4) | Draft Retained Amount | - | |
Description:No description available | ||||
CuryInclTaxAmount | decimal(19, 4) | Inclusive Tax Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryInvoicedAmount | decimal(19, 4) | Draft Invoice Amount | - | |
Description:No description available | ||||
CuryLastCostAtCompletion | decimal(19, 4) | Last Cost at Completion | - | |
Description:No description available | ||||
CuryLastCostToComplete | decimal(19, 4) | Last Cost to Complete | - | |
Description:No description available | ||||
CuryMaxAmount | decimal(19, 4) | Maximum Amount | - | |
Description:No description available | ||||
CuryPrepaymentAmount | decimal(19, 4) | Prepaid Amount | - | |
Description:No description available | ||||
CuryPrepaymentAvailable | decimal(19, 4) | Prepaid Available | - | |
Description:No description available | ||||
CuryPrepaymentInvoiced | decimal(19, 4) | Prepaid Invoiced | - | |
Description:No description available | ||||
CuryRetainedAmount | decimal(19, 4) | Retained Amount | - | |
Description:No description available | ||||
CuryRevisedAmount | decimal(19, 4) | Revised Budgeted Amount | - | |
Description:No description available | ||||
CuryTotalRetainedAmount | decimal(19, 4) | Total Retained Amount | - | |
Description:No description available | ||||
CuryUnitPrice | decimal(19, 6) | Unit Price | - | |
Description:No description available | ||||
CuryUnitRate | decimal(19, 6) | Unit Rate | - | |
Description:No description available | ||||
CuryVarianceAmountNonexistent in DB | decimal | Variance Amount | - | |
Description:No description available | ||||
Description | nvarchar(256) | Description | - | |
Description:No description available | ||||
DraftChangeOrderAmount | decimal(19, 4) | Potential CO Amount in Base Currency | - | |
Description:No description available | ||||
DraftChangeOrderQty | decimal(19, 6) | Potential CO Quantity | - | |
Description:No description available | ||||
DraftRetainedAmount | decimal(19, 4) | Draft Retained Amount | - | |
Description:No description available | ||||
InclTaxAmount | decimal(19, 4) | Inclusive Tax Amount in Base Currency | - | |
Description:No description available | ||||
InvoicedAmount | decimal(19, 4) | Draft Invoices Amount in Base Currency | - | |
Description:No description available | ||||
InvoicedQty | decimal(19, 6) | Draft Invoice Quantity | - | |
Description:No description available | ||||
IsProduction | bit | Auto Completed (%) | - | |
Description:No description available | ||||
LastCostAtCompletion | decimal(19, 4) | Last Cost at Completion in Base Currency | - | |
Description:No description available | ||||
LastCostToComplete | decimal(19, 4) | Last Cost to Complete in Base Currency | - | |
Description:No description available | ||||
LastModifiedByID | 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 | ||||
LastPercentCompleted | decimal(19, 4) | Last Percentage of Completion | - | |
Description:No description available | ||||
LimitAmount | bit | Limit Amount | - | |
Description:No description available | ||||
LimitQty | bit | Limit Quantity | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
MaxAmount | decimal(19, 4) | Maximum Amount in Base Currency | - | |
Description:No description available | ||||
MaxQty | decimal(19, 6) | Maximum Quantity | - | |
Description:No description available | ||||
Mode | char(1) | Mode | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PercentCompleted | decimal(19, 4) | Percentage of Completion | - | |
Description:No description available | ||||
PerformanceNonexistent in DB | decimal | Performance (%) | - | |
Description:No description available | ||||
PrepaymentAmount | decimal(19, 4) | Prepaid Amount in Base Currency | - | |
Description:No description available | ||||
PrepaymentAvailable | decimal(19, 4) | Prepaid Available in Base Currency | - | |
Description:No description available | ||||
PrepaymentInvoiced | decimal(19, 4) | Prepaid Invoiced in Base Currency | - | |
Description:No description available | ||||
PrepaymentPctNonexistent in DB | decimal | Prepaid (%) | - | |
Description:No description available | ||||
ProductivityTracking | char(1) | Productivity Tracking | - | |
Description:No description available | ||||
ProgressBillingBase | nvarchar(1) | Progress Billing Basis | - | |
Description:No description available | ||||
Qty | decimal(19, 6) | Original Budgeted Quantity | - | |
Description:No description available | ||||
QtyToInvoice | decimal(19, 6) | Pending Invoice Quantity | - | |
Description:No description available | ||||
Rate | decimal(19, 6) | - | ||
Description:No description available | ||||
RetainageMaxPct | decimal(19, 6) | Cap (%) | - | |
Description:No description available | ||||
RetainagePct | decimal(19, 6) | Retainage (%) | - | |
Description:No description available | ||||
RetainedAmount | decimal(19, 4) | Retained Amount | - | |
Description:No description available | ||||
RevenueInventoryIDObsolete | int | - | ||
Description:No description available | ||||
RevenueTaskID | int | Revenue Task | PMTask | |
Description:The reference to a revenue budget line by task. | ||||
RevenueTaskIDApiEndPointNonexistent in DB | int | - | ||
Description:No description available | ||||
RevisedAmount | decimal(19, 4) | Revised Budgeted Amount in Base Currency | - | |
Description:No description available | ||||
RevisedQty | decimal(19, 6) | Revised Budgeted Quantity | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SortOrderNonexistent in DB | int | - | ||
Description:No description available | ||||
TaxCategoryID | nvarchar(15) | Tax Category | TaxCategory | |
Description:No description available | ||||
TotalRetainedAmount | decimal(19, 4) | Total Retained Amount in Base Currency | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(1) | Type | - | |
Description:No description available | ||||
UnitPrice | decimal(19, 6) | Unit Price in Base Currency | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VarianceAmountNonexistent in DB | decimal | Variance Amount in Base Currency | - | |
Description:No description available | ||||