PM
PMProjectSearch
PX.Objects.PM166 of 166 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseType | char(1) | Base Type | - | |
Description:No description available | ||||
ContractCD | nvarchar(30) | Template ID | - | |
Description:No description available | ||||
AccountingMode | varchar(1) | Inventory Tracking | - | |
Description:No description available | ||||
ActivationDate | datetime2 | Activation Date | - | |
Description:No description available | ||||
AIALevel | char(1) | AIA Level | - | |
Description:No description available | ||||
AllocationID | nvarchar(15) | Allocation Rule | PMAllocation | |
Description:No description available | ||||
AllowIssueFromFreeStock | bit | Allow Issue from Free Stock | - | |
Description:No description available | ||||
AllowOverride | bit | - | ||
Description:No description available | ||||
AllowOverrideCury | bit | Enable Currency Override | - | |
Description:No description available | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:No description available | ||||
Approved | bit | - | ||
Description:No description available | ||||
ApproverID | int | Time Activity Approver | EPEmployee | |
Description:No description available | ||||
AssistantID | int | Project Manager Assistant | EPEmployee | |
Description:No description available | ||||
AttributesNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
AutoAllocate | bit | Run Allocation on Release of Project Transactions | - | |
Description:No description available | ||||
AutomaticReleaseAR | bit | Automatically Release AR Documents | - | |
Description:No description available | ||||
AutoRenew | bit | - | ||
Description:No description available | ||||
AutoRenewDays | int | - | ||
Description:No description available | ||||
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:No description available | ||||
BillingLineCntr | int | - | ||
Description:No description available | ||||
BudgetFinalized | bit | - | ||
Description:No description available | ||||
BudgetLevel | char(1) | Revenue Budget Level | - | |
Description:No description available | ||||
BudgetMetricsEnabled | bit | Track Production Data | - | |
Description:No description available | ||||
CalendarID | nvarchar(10) | Calendar | CSCalendar | |
Description:No description available | ||||
CapAmountNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CaseItemID | int | - | ||
Description:No description available | ||||
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:No description available | ||||
ClassIDNonexistent in DB | nvarchar(20) | - | ||
Description:No description available | ||||
ClassType | char(1) | - | ||
Description:No description available | ||||
ContractAccountGroup | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
ContractID | int | Project ID | - | |
Description:No description available | ||||
ContractInfoNonexistent in DB | nvarchar(MAX) | ContractInfo | - | |
Description:No description available | ||||
CostBudgetLevel | char(1) | Cost Budget Level | - | |
Description:No description available | ||||
CostTaxZoneID | nvarchar(10) | Cost Tax Zone | TaxZone | |
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 | ||||
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:No description available | ||||
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:No description available | ||||
CuryRateNonexistent in DB | decimal | - | ||
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
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:No description available | ||||
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:No description available | ||||
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 | nvarchar(255) | Description | - | |
Description:No description available | ||||
DetailedBilling | int | - | ||
Description:No description available | ||||
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:No description available | ||||
DropshipExpenseRecording | varchar(1) | Record Drop-Ship Expenses | - | |
Description:No description available | ||||
DropshipExpenseSubMask | nvarchar(30) | Combine Expense Sub. From | - | |
Description:No description available | ||||
DropshipReceiptProcessing | varchar(1) | Drop-Ship Receipt Processing | - | |
Description:No description available | ||||
Duration | int | - | ||
Description:No description available | ||||
DurationType | char(1) | - | ||
Description:No description available | ||||
EffectiveFrom | datetime2 | Effective From | - | |
Description:No description available | ||||
ExpireDate | datetime2 | End Date | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(30) | External Ref. Nbr | - | |
Description:No description available | ||||
GraceDate | datetime | - | ||
Description:No description available | ||||
GracePeriod | int | - | ||
Description:No description available | ||||
GroupMask | varbinary | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
IncludeCO | bit | Include CO | - | |
Description:No description available | ||||
IncludedNonexistent in DB | bit | Included | - | |
Description:No description available | ||||
IncludeQtyInAIA | bit | Show Quantity in AIA Report | - | |
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsCancelled | bit | - | ||
Description:No description available | ||||
IsCompleted | bit | Completed | - | |
Description:No description available | ||||
IsContinuous | bit | - | ||
Description:No description available | ||||
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 | 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:No description available | ||||
LockCommitments | bit | - | ||
Description:No description available | ||||
MasterContractID | int | - | ||
Description:No description available | ||||
MinNonexistent in DB | nvarchar(MAX) | Min | - | |
Description:No description available | ||||
NonProject | bit | Is Global | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OriginalContractID | int | - | ||
Description:No description available | ||||
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:No description available | ||||
QuoteNbr | nvarchar(15) | Quote Ref. Nbr. | PMQuote | |
Description:No description available | ||||
RateTableID | nvarchar(15) | Rate Table Code | PMRateTable | |
Description:No description available | ||||
RateTypeID | nvarchar(6) | Currency Rate Type | CurrencyRateType | |
Description:No description available | ||||
RefreshOnRenewal | bit | - | ||
Description:No description available | ||||
Refundable | bit | Refundable | - | |
Description:No description available | ||||
RefundPeriod | int | Refund Period | - | |
Description:No description available | ||||
Rejected | bit | - | ||
Description:No description available | ||||
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 | Retainage (%) | - | |
Description:No description available | ||||
RevenueTaxZoneID | nvarchar(10) | Revenue Tax Zone | TaxZone | |
Description:No description available | ||||
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:No description available | ||||
SiteAddressObsolete | nvarchar(255) | Site Address | - | |
Description:No description available | ||||
SiteAddressID | int | - | ||
Description:No description available | ||||
StartDate | datetime | Start Date | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
StatusCode | int | - | ||
Description:No description available | ||||
SteppedRetainage | bit | Use Steps | - | |
Description:No description available | ||||
SteppedRetainageOptionNonexistent in DB | nvarchar(MAX) | Retainage Type | - | |
Description:No description available | ||||
StrIsTemplateNonexistent in DB | nvarchar(MAX) | Type | - | |
Description:No description available | ||||
TemplateID | int | Template | PMProject | |
Description:No description available | ||||
TerminationDate | datetime2 | Termination Date | - | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
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:No description available | ||||
VisibleInAR | bit | AR | - | |
Description:No description available | ||||
VisibleInCA | bit | CA | - | |
Description:No description available | ||||
VisibleInCR | bit | CRM | - | |
Description:No description available | ||||
VisibleInEA | bit | Expenses | - | |
Description:No description available | ||||
VisibleInGL | bit | GL | - | |
Description:No description available | ||||
VisibleInIN | bit | IN | - | |
Description:No description available | ||||
VisibleInPO | bit | PO | - | |
Description:No description available | ||||
VisibleInSO | bit | SO | - | |
Description:No description available | ||||
VisibleInTA | bit | Time Entries | - | |
Description:No description available | ||||
WorkgroupIDNonexistent in DB | int | - | ||
Description:No description available | ||||