PM
PMProject
PX.Objects.PMView API Entity: Project
/entity/Default/24.200.001/Project166 of 166 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseType | char(1) | Base Type | - | |
Description:The type of the record. The value can be either Contract or Project. The default value is Project. | ||||
ContractCD | nvarchar(30) | Project ID | - | |
Description:No description available | ||||
AccountingMode | char(1) | Inventory Tracking | - | |
Description:The way how the system manages inventory for the project. The field can have one of the following values: ""P"": Track by Project Quantity and Cost, ""V"": Track by Project Quantity, ""L"": Track by Location | ||||
ActivationDate | datetime2 | Activation Date | - | |
Description:No description available | ||||
AIALevel | char(1) | AIA Level | - | |
Description:No description available | ||||
AllocationID | nvarchar(15) | Allocation Rule | PMAllocation | |
Description:Gets or sets the allocation rule for the project. The allocation rule is set at the PMTask level. This field contains the default value for the tasks created under the given project. | ||||
AllowIssueFromFreeStock | bit | Allow Issue from Free Stock | - | |
Description:A Boolean value that indicates whether materials from stock not allocated to any project can be issued. | ||||
AllowOverride | bit | - | ||
Description:This field is not used with projects. | ||||
AllowOverrideCury | bit | Enable Currency Override | - | |
Description:No description available | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:No description available | ||||
Approved | bit | - | ||
Description:Specifies (if set to ) that the project has been approved. | ||||
ApproverID | int | Time Activity Approver | EPEmployee | |
Description:The project manager for the project. The project manager can approve and reject activities that require approval. An activity requires an approval only if the PMTask.ApproverID is specified for a given PMTask. | ||||
AssistantID | int | Project Manager Assistant | EPEmployee | |
Description:No description available | ||||
unspecified | - | |||
Description:The entity attributes. | ||||
AutoAllocate | bit | Run Allocation on Release of Project Transactions | - | |
Description:Specifies (if set to ) that the allocation should be run every time a PMTran is released. | ||||
AutomaticReleaseAR | bit | Automatically Release AR Documents | - | |
Description:No description available | ||||
AutoRenew | bit | - | ||
Description:This field in not used with projects. | ||||
AutoRenewDays | int | - | ||
Description:This field in not used with projects. | ||||
BalanceNonexistent in DB | decimal | Balance | - | |
Description:No description available | ||||
BaseCuryID | nvarchar(5) | Base Currency | CurrencyList | |
Description:No description available | ||||
BillAddressID | int | - | ||
Description:No description available | ||||
BillContactID | int | Billing Contact | PMContact | |
Description:No description available | ||||
BillingCuryID | nvarchar(5) | Billing Currency | CurrencyList | |
Description:No description available | ||||
BillingID | nvarchar(15) | Billing Rule | PMBilling | |
Description:The billing rule for the project. The billing rule is set at the PMTask level. This field contains the default value for the tasks created under the given project. | ||||
BillingLineCntr | int | - | ||
Description:No description available | ||||
BudgetFinalized | bit | - | ||
Description:Specifies (if set to ) that the project budget is locked (using the Lock Budget action). | ||||
BudgetLevel | char(1) | Revenue Budget Level | - | |
Description:The detail level of the revenue budget. The field can have one of the following values: ""T"": Task, ""I"": Task and Item, ""C"": Task and Cost Code, ""D"": Task, Item, and Cost Code | ||||
BudgetMetricsEnabled | bit | Track Production Data | - | |
Description:No description available | ||||
CalendarID | nvarchar(10) | Calendar | CSCalendar | |
Description:No description available | ||||
CapAmountNonexistent in DB | decimal | - | ||
Description:The retainage cap amount (in the base currency). | ||||
CaseItemID | int | - | ||
Description:This field in not used with projects. | ||||
CertifiedJob | bit | Certified Job | - | |
Description:No description available | ||||
ChangeOrderWorkflow | bit | Change Order Workflow | - | |
Description:No description available | ||||
ChangeOrderWorkflowCopyNonexistent in DB | bit | Change Order Workflow | - | |
Description:The copy of 'ChangeOrderWorkflow' which is used for visibility control in the classic UI. | ||||
ClassIDNonexistent in DB | nvarchar(20) | - | ||
Description:The class ID for the attributes. Always returns the current GroupTypes.Project. | ||||
ClassType | char(1) | - | ||
Description:No description available | ||||
ContractAccountGroup | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
ContractID | int | Project ID | - | |
Description:The project ID. | ||||
ContractInfoNonexistent in DB | nvarchar(MAX) | ContractInfo | - | |
Description:No description available | ||||
CostBudgetLevel | char(1) | Cost Budget Level | - | |
Description:The detail level of the cost budget. The field can have one of the following values: ""T"": Task, ""I"": Task and Item, ""C"": Task and Cost Code, ""D"": Task, Item, and Cost Code | ||||
CostTaxZoneID | nvarchar(10) | Cost Tax Zone | TaxZone | |
Description:Identifier of the cost tax zone associated with the document. Corresponds to the TaxZone.TaxZoneID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CreateProforma | bit | Create Pro Forma Invoice on Billing | - | |
Description:No description available | ||||
CurrentRecurringNonexistent in DB | decimal | Current Recurring | - | |
Description:No description available | ||||
CurrentRenewalNonexistent in DB | decimal | Current Renewal | - | |
Description:No description available | ||||
CurrentSetupNonexistent in DB | decimal | Current Setup | - | |
Description:No description available | ||||
CuryCapAmountNonexistent in DB | decimal | Cap Amount | - | |
Description:The retainage cap amount. | ||||
CuryID | nvarchar(5) | Budget Currency | CurrencyList | |
Description:No description available | ||||
CuryIDCopyNonexistent in DB | nvarchar(5) | Project Currency | CurrencyList | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:The identifier of the CurrencyInfo record associated with the project. | ||||
CuryRateNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:The identifier of the customer for the project. Projects can be of the internal or external type. Internal projects are those that have the value of this property equal to NULL and hense are not billable. | ||||
DaysNonexistent in DB | nvarchar(MAX) | Days | - | |
Description:No description available | ||||
DaysBeforeExpirationNonexistent in DB | nvarchar(MAX) | DaysBeforeExpiration | - | |
Description:No description available | ||||
DefaultAccrualAccountID | int | Accrual Account | Account | |
Description:No description available | ||||
DefaultAccrualSubID | int | Accrual Subaccount | Sub | |
Description:The default project accrual subaccount. The field is used depending on the PMSetup.ExpenseAccrualSubMask mask setting. | ||||
DefaultBranchID | int | Branch | Branch | |
Description:No description available | ||||
DefaultExpenseAccountID | int | Default Cost Account | Account | |
Description:No description available | ||||
DefaultExpenseSubID | int | Default Cost Subaccount | Sub | |
Description:The default cost subaccount associated with the project. This subaccount can be used in allocation and cost transactions. | ||||
DefaultOverbillingAccountID | int | Overbilling Account | Account | |
Description:No description available | ||||
DefaultOverbillingSubID | int | Overbilling Subaccount | Sub | |
Description:No description available | ||||
DefaultSalesAccountID | int | Default Sales Account | Account | |
Description:No description available | ||||
DefaultSalesSubID | int | Default Sales Subaccount | Sub | |
Description:No description available | ||||
DefaultUnderbillingAccountID | int | Underbilling Account | Account | |
Description:No description available | ||||
DefaultUnderbillingSubID | int | Underbilling Subaccount | Sub | |
Description:No description available | ||||
Description API | nvarchar(255) | Description | - | |
Description:The project description. | ||||
DetailedBilling | int | - | ||
Description:This field in not used with projects. | ||||
DiscontinueAfter | datetime2 | Discontinue After | - | |
Description:No description available | ||||
DiscountID | nvarchar(10) | Promo Code | - | |
Description:No description available | ||||
DropshipExpenseAccountSource | char(1) | Use Expense Account From | - | |
Description:The source of the expense account to be used in the project drop-ship order. The field can have one of the following values: ""O"": Posting Class or Item, ""P"": Project, ""T"": Task | ||||
DropshipExpenseRecording | char(1) | Record Drop-Ship Expenses | - | |
Description:Defines when the expense transaction should be recorded. The field can have one of the following values: ""B"": On Bill Release, ""R"": On Receipt Release | ||||
DropshipExpenseSubMask | varchar(30) | Combine Expense Sub. From | - | |
Description:The subaccount mask for items used in the project drop-ships orders. | ||||
DropshipReceiptProcessing | char(1) | Drop-Ship Receipt Processing | - | |
Description:Defines whether a receipt will be generated for drop-shipped items that are purchased for the project. The field can have one of the following values: ""R"": Generate Receipt, ""S"": Skip Receipt Generation | ||||
Duration | int | - | ||
Description:This field in not used with projects. | ||||
DurationType | char(1) | - | ||
Description:This field in not used with projects. | ||||
EffectiveFrom | datetime2 | Effective From | - | |
Description:No description available | ||||
ExpireDate | datetime | End Date | - | |
Description:The end date of a project. | ||||
ExtRefNbr | nvarchar(30) | External Ref. Nbr | - | |
Description:The external reference number. | ||||
GraceDate | datetime | - | ||
Description:No description available | ||||
GracePeriod | int | - | ||
Description:This field in not used with projects. | ||||
GroupMask | varbinary(32) | - | ||
Description:No description available | ||||
Hold API | bit | Hold | - | |
Description:Specifies (if set to ) that the project is on hold. | ||||
IncludeCO | bit | Include CO | - | |
Description:Include Change Orders in Contract Total | ||||
IncludedNonexistent in DB | bit | Included | - | |
Description:An unbound field used in the user interface to include the project into a restriction group. | ||||
IncludeQtyInAIA | bit | Show Quantity in AIA Report | - | |
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:Specifies (if set to ) that the project is active. Transactions can be added only to the active projects. | ||||
IsCancelled | bit | - | ||
Description:No description available | ||||
IsCompleted | bit | Completed | - | |
Description:Specifies (if set to ) that the project is completed. | ||||
IsContinuous | bit | - | ||
Description:This field in not used with projects. | ||||
IsLastActionUndoable | bit | - | ||
Description:No description available | ||||
IsPendingUpdate | bit | - | ||
Description:No description available | ||||
IsTemplateObsolete | bit | - | ||
Description:No description available | ||||
LastActiveRevID | int | - | ||
Description:No description available | ||||
LastChangeOrderNumber | nvarchar(15) | Last Revenue Change Nbr. | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LastProformaNumber | nvarchar(15) | Last Application Nbr. | - | |
Description:No description available | ||||
LimitsEnabled | bit | Use T&M Revenue Budget Limits | - | |
Description:No description available | ||||
LineCtr | int | - | ||
Description:No description available | ||||
LocationID | int | Customer Location | Location | |
Description:The customer location. | ||||
LockCommitments | bit | - | ||
Description:No description available | ||||
MasterContractID | int | - | ||
Description:This field in not used with projects. | ||||
MinNonexistent in DB | nvarchar(MAX) | Min | - | |
Description:No description available | ||||
NonProject | bit | Is Global | - | |
Description:Specifies (if set to ) that the project is a non-project. Only one project in the system is a non-project. A non-project is used whenever you have a transaction that is not applicable to any other project. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OriginalContractID | int | - | ||
Description:This field in not used with projects. | ||||
OwnerID | int | Project Manager | Contact | |
Description:No description available | ||||
PendingRecurringNonexistent in DB | decimal | Pending Recurring | - | |
Description:No description available | ||||
PendingRenewalNonexistent in DB | decimal | Pending Renewal | - | |
Description:No description available | ||||
PendingSetupNonexistent in DB | decimal | Pending Setup | - | |
Description:No description available | ||||
PrepaymentDefCode | nvarchar(10) | Deferral Code | DRDeferredCode | |
Description:No description available | ||||
PrepaymentEnabled | bit | Use Prepaid Amount | - | |
Description:No description available | ||||
ProjectGroupID | nvarchar(15) | Project Group | PMProjectGroup | |
Description:No description available | ||||
ProjectTypeNonexistent in DB | nvarchar(MAX) | Type | - | |
Description:The type of the project. | ||||
QuoteNbr | nvarchar(15) | Quote Ref. Nbr. | PMQuote | |
Description:No description available | ||||
RateTableID | nvarchar(15) | Rate Table Code | PMRateTable | |
Description:The rate table for the project. | ||||
RateTypeID | nvarchar(6) | Currency Rate Type | CurrencyRateType | |
Description:The default rate type for the currency rate that is used for the budget. The value of this field corresponds to the value of the CurrencyRateType.CuryRateTypeID field. | ||||
RefreshOnRenewal | bit | - | ||
Description:This field in not used with projects. | ||||
Refundable | bit | Refundable | - | |
Description:No description available | ||||
RefundPeriod | int | Refund Period | - | |
Description:No description available | ||||
Rejected | bit | - | ||
Description:Specifies (if set to ) that the project has been rejected. | ||||
RenewalBillingStartDate | datetime2 | - | ||
Description:No description available | ||||
RestrictProjectSelect | nvarchar(1) | Restrict Project Selection | - | |
Description:No description available | ||||
RestrictToEmployeeList | bit | Restrict Employees | - | |
Description:No description available | ||||
RestrictToResourceList | bit | Restrict Equipment | - | |
Description:No description available | ||||
RetainageMaxPct | decimal | Cap (%) | - | |
Description:No description available | ||||
RetainageMode | nchar(1) | Retainage Mode | - | |
Description:No description available | ||||
RetainagePct | decimal(19, 6) | Retainage (%) | - | |
Description:The percent of an invoice amount issued for the project that is retained by the customer. | ||||
RevenueTaxZoneID | nvarchar(10) | Revenue Tax Zone | TaxZone | |
Description:Identifier of the revenue tax zone associated with the document. Corresponds to the TaxZone.TaxZoneID field. | ||||
RevID | int | - | ||
Description:No description available | ||||
SalesPersonID | int | Sales Person | SalesPerson | |
Description:No description available | ||||
ScheduleStartsOn | char(1) | Billing Schedule Starts On | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ServiceActivate | bit | - | ||
Description:This field in not used with projects. | ||||
SiteAddressObsolete | nvarchar(255) | Site Address | - | |
Description:No description available | ||||
SiteAddressID | int | - | ||
Description:The identifier of the project site address record associated with the project. | ||||
StartDate | datetime | Start Date | - | |
Description:The start date of the project. | ||||
Status API | char(1) | Status | - | |
Description:The status of the project. | ||||
StatusCode | int | - | ||
Description:Specifies the status code if the project is not valid after system upgrade. | ||||
SteppedRetainage | bit | Use Steps | - | |
Description:No description available | ||||
SteppedRetainageOptionNonexistent in DB | nvarchar(MAX) | Retainage Type | - | |
Description:Stepped Retainage | ||||
StrIsTemplateNonexistent in DB | nvarchar(MAX) | Type | - | |
Description:No description available | ||||
TemplateID | int | Template | PMProject | |
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:The termination date of the project. | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:The identifier of the credit terms object associated with the document. Defaults to the credit terms that are selected for the customer. Corresponds to the Terms.TermsID field. | ||||
TotalDueNonexistent in DB | decimal | Total Due | - | |
Description:No description available | ||||
TotalPendingNonexistent in DB | decimal | Total Pending | - | |
Description:No description available | ||||
TotalRecurringNonexistent in DB | decimal | Recurring Total | - | |
Description:No description available | ||||
TotalsCalculatedNonexistent in DB | int | - | ||
Description:No description available | ||||
TotalUsageNonexistent in DB | decimal | Extra Usage Total | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(1) | Contract Type | - | |
Description:No description available | ||||
VisibleInAP | bit | AP | - | |
Description:Specifies (if set to ) that the project is visible in the AP module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInAR | bit | AR | - | |
Description:Specifies (if set to ) that the project is visible in the AR module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInCA | bit | CA | - | |
Description:Specifies (if set to ) that the project is visible in the CA module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInCR | bit | CRM | - | |
Description:Specifies (if set to ) that the project is visible in the CR module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInEA | bit | Expenses | - | |
Description:Specifies (if set to ) that the project is visible in the EP Expense module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInGL | bit | GL | - | |
Description:Specifies (if set to ) that the project is visible in the GL module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInIN | bit | IN | - | |
Description:Specifies (if set to ) that the project is visible in the IN module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInPO | bit | PO | - | |
Description:Specifies (if set to ) that the project is visible in the PO module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInSO | bit | SO | - | |
Description:Specifies (if set to ) that the project is visible in the SO module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
VisibleInTA | bit | Time Entries | - | |
Description:Specifies (if set to ) that the project is visible in the EP Time module. If the project is invisible, it will not be displayed in the field selectors in this module. | ||||
WorkgroupIDNonexistent in DB | int | - | ||
Description:No description available | ||||