PM
PMBudgetAccum
PX.Objects.PM115 of 115 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AccountGroupID | int | - | ||
Description:No description available | ||||
CostCodeID | int | - | ||
Description:No description available | ||||
InventoryID | int | - | ||
Description:No description available | ||||
ProjectID | int | - | ||
Description:No description available | ||||
ProjectTaskID | int | - | ||
Description:No description available | ||||
ActualAmount | decimal | 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) | - | ||
Description:No description available | ||||
Amount | decimal | Original Budgeted Amount in Base Currency | - | |
Description:No description available | ||||
AmountToInvoice | decimal | 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 | Budgeted CO Amount in Base Currency | - | |
Description:No description available | ||||
ChangeOrderQty | decimal | Budgeted CO Quantity | - | |
Description:No description available | ||||
CommittedAmount | decimal | 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 | Committed Invoiced Amount in Base Currency | - | |
Description:No description available | ||||
CommittedInvoicedQty | decimal | Committed Invoiced Quantity | - | |
Description:No description available | ||||
CommittedOpenAmount | decimal | Committed Open Amount in Base Currency | - | |
Description:No description available | ||||
CommittedOpenQty | decimal | Committed Open Quantity | - | |
Description:No description available | ||||
CommittedOrigAmount | decimal | Original Committed Amount in Base Currency | - | |
Description:No description available | ||||
CommittedOrigQty | decimal | Original Committed Quantity | - | |
Description:No description available | ||||
CommittedQty | decimal | Revised Committed Quantity | - | |
Description:No description available | ||||
CommittedReceivedQty | decimal | Committed Received Quantity | - | |
Description:No description available | ||||
CompletedPct | decimal | Completed (%) | - | |
Description:No description available | ||||
CostAtCompletion | decimal | Cost at Completion | - | |
Description:No description available | ||||
CostProjectionCompletedPct | decimal | Projected Completed (%) | - | |
Description:No description available | ||||
CostProjectionCostAtCompletion | decimal | Projected Cost at Completion in Base Currency | - | |
Description:No description available | ||||
CostProjectionCostToComplete | decimal | Projected Cost To Complete in Base Currency | - | |
Description:No description available | ||||
CostProjectionQtyAtCompletion | decimal | Projected Quantity at Completion | - | |
Description:No description available | ||||
CostProjectionQtyToComplete | decimal | Projected Quantity to Complete | - | |
Description:No description available | ||||
CostToComplete | decimal | Cost To Complete in Base Currency | - | |
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 | ||||
CuryActualAmount | decimal | Actual Amount | - | |
Description:No description available | ||||
CuryActualPlusOpenCommittedAmountNonexistent in DB | decimal | Actual + Open Committed Amount | - | |
Description:No description available | ||||
CuryAmount | decimal | Original Budgeted Amount | - | |
Description:No description available | ||||
CuryAmountToInvoice | decimal | Pending Invoice Amount | - | |
Description:No description available | ||||
CuryChangeOrderAmount | decimal | Budgeted CO Amount | - | |
Description:No description available | ||||
CuryCommittedAmount | decimal | Revised Committed Amount | - | |
Description:No description available | ||||
CuryCommittedCOAmountNonexistent in DB | decimal | Committed CO Amount | - | |
Description:No description available | ||||
CuryCommittedInvoicedAmount | decimal | Committed Invoiced Amount | - | |
Description:No description available | ||||
CuryCommittedOpenAmount | decimal | Committed Open Amount | - | |
Description:No description available | ||||
CuryCommittedOrigAmount | decimal | Original Committed Amount | - | |
Description:No description available | ||||
CuryCostAtCompletion | decimal | Cost at Completion | - | |
Description:No description available | ||||
CuryCostProjectionCostAtCompletion | decimal | Projected Cost at Completion | - | |
Description:No description available | ||||
CuryCostProjectionCostToComplete | decimal | Projected Cost to Complete | - | |
Description:No description available | ||||
CuryCostToComplete | decimal | Cost to Complete | - | |
Description:No description available | ||||
CuryDraftChangeOrderAmount | decimal | Potential CO Amount | - | |
Description:No description available | ||||
CuryDraftRetainedAmount | decimal | Draft Retained Amount | - | |
Description:No description available | ||||
CuryInclTaxAmount | decimal | Inclusive Tax Amount | - | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryInvoicedAmount | decimal | Draft Invoice Amount | - | |
Description:No description available | ||||
CuryLastCostAtCompletion | decimal | Last Cost at Completion | - | |
Description:No description available | ||||
CuryLastCostToComplete | decimal | Last Cost to Complete | - | |
Description:No description available | ||||
CuryMaxAmount | decimal | Maximum Amount | - | |
Description:No description available | ||||
CuryPrepaymentAmount | decimal | Prepaid Amount | - | |
Description:No description available | ||||
CuryPrepaymentAvailable | decimal | Prepaid Available | - | |
Description:No description available | ||||
CuryPrepaymentInvoiced | decimal | Prepaid Invoiced | - | |
Description:No description available | ||||
CuryRetainedAmount | decimal | Retained Amount | - | |
Description:No description available | ||||
CuryRevisedAmount | decimal | Revised Budgeted Amount | - | |
Description:No description available | ||||
CuryTotalRetainedAmount | decimal | Total Retained Amount | - | |
Description:No description available | ||||
CuryUnitPrice | decimal | Unit Price | - | |
Description:No description available | ||||
CuryUnitRate | decimal | 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 | Potential CO Amount in Base Currency | - | |
Description:No description available | ||||
DraftChangeOrderQty | decimal | Potential CO Quantity | - | |
Description:No description available | ||||
DraftRetainedAmount | decimal | Draft Retained Amount | - | |
Description:No description available | ||||
InclTaxAmount | decimal | Inclusive Tax Amount in Base Currency | - | |
Description:No description available | ||||
InvoicedAmount | decimal | Draft Invoices Amount in Base Currency | - | |
Description:No description available | ||||
InvoicedQty | decimal(19, 6) | - | ||
Description:No description available | ||||
IsProduction | bit | Auto Completed (%) | - | |
Description:No description available | ||||
LastCostAtCompletion | decimal | Last Cost at Completion in Base Currency | - | |
Description:No description available | ||||
LastCostToComplete | decimal | Last Cost to Complete in Base Currency | - | |
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 | ||||
LastPercentCompleted | decimal | 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 | Maximum Amount in Base Currency | - | |
Description:No description available | ||||
MaxQty | decimal | Maximum Quantity | - | |
Description:No description available | ||||
Mode | char(1) | Mode | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PercentCompleted | decimal | Percentage of Completion | - | |
Description:No description available | ||||
PerformanceNonexistent in DB | decimal | Performance (%) | - | |
Description:No description available | ||||
PrepaymentAmount | decimal | Prepaid Amount in Base Currency | - | |
Description:No description available | ||||
PrepaymentAvailable | decimal | Prepaid Available in Base Currency | - | |
Description:No description available | ||||
PrepaymentInvoiced | decimal | Prepaid Invoiced in Base Currency | - | |
Description:No description available | ||||
PrepaymentPctNonexistent in DB | decimal | Prepaid (%) | - | |
Description:No description available | ||||
ProductivityTracking | varchar(1) | Productivity Tracking | - | |
Description:No description available | ||||
ProgressBillingBase | nvarchar(MAX) | Progress Billing Basis | - | |
Description:No description available | ||||
Qty | decimal | Original Budgeted Quantity | - | |
Description:No description available | ||||
QtyToInvoice | decimal | Pending Invoice Quantity | - | |
Description:No description available | ||||
Rate | decimal | - | ||
Description:No description available | ||||
RetainageMaxPct | decimal | Cap (%) | - | |
Description:No description available | ||||
RetainagePct | decimal | Retainage (%) | - | |
Description:No description available | ||||
RetainedAmount | decimal | Retained Amount | - | |
Description:No description available | ||||
RevenueInventoryIDObsolete | int | - | ||
Description:No description available | ||||
RevenueTaskID | int | - | ||
Description:The identifier of the revenue project task associated with the budget line. | ||||
RevenueTaskIDApiEndPointNonexistent in DB | int | - | ||
Description:No description available | ||||
RevisedAmount | decimal | Revised Budgeted Amount in Base Currency | - | |
Description:No description available | ||||
RevisedQty | decimal | 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 | Total Retained Amount in Base Currency | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(1) | - | ||
Description:The type of the budget line. The field can have one of the following values: ""A"": Asset, ""L"": Liability, ""I"": Income, ""E"": Expense, ""O"": Off-Balance | ||||
UnitPrice | decimal | 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 | ||||