CT
ContractTemplate
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AIALevel | char(1) | AIA Level | - | |
Description:No description available | ||||
AccountingMode | nvarchar(1) | - | ||
Description:No description available | ||||
ActivationDate | datetime | Activation Date | - | |
Description:No description available | ||||
AllocationID | nvarchar(15) | - | ||
Description:No description available | ||||
AllowNonProjectAccountGroups | bit | Allow Adding New Items on the Fly | - | |
Description:No description available | ||||
AllowOverride | bit | Enable Template Item Override | - | |
Description:No description available | ||||
AllowOverrideCury | bit | Enable Currency Override | - | |
Description:No description available | ||||
AllowOverrideFormulaDescription | bit | Enable Overriding Formulas in Contracts | - | |
Description:No description available | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:No description available | ||||
Approved | bit | Approved | - | |
Description:No description available | ||||
ApproverID | int | Contract Activity Approver | EPEmployee | |
Description:No description available | ||||
AttributesNonexistent in DB | string | - | ||
Description:No description available | ||||
AutoAllocate | bit | - | ||
Description:No description available | ||||
AutoRenew | bit | Mass Renewal | - | |
Description:No description available | ||||
AutoRenewDays | int | Renewal Point | - | |
Description:No description available | ||||
AutomaticReleaseAR | bit | Automatically Release AR Documents | - | |
Description:No description available | ||||
BalanceNonexistent in DB | decimal? | Balance | - | |
Description:No description available | ||||
BaseType | char(1) | Entity Type | - | |
Description:No description available | ||||
BillingID | nvarchar(15) | - | ||
Description:No description available | ||||
BillingLineCntr | int | - | ||
Description:No description available | ||||
BudgetMetricsEnabled | bit | Track Production Data | - | |
Description:No description available | ||||
CalendarID | nvarchar(10) | Calendar | CSCalendar | |
Description:No description available | ||||
CaseItemID | int | Case Count Item | InventoryItem | |
Description:No description available | ||||
CertifiedJob | bit | Certified Job | - | |
Description:This field is used in the PMProject class. Specifies (if set to true) that the job performed in the scope of the project is a certified job performed for the government, such as a hospital construction project. | ||||
ChangeOrderWorkflow | bit | Change Order Workflow | - | |
Description:No description available | ||||
ClassIDNonexistent in DB | string | ContractTemplate | ||
Description:The string size is not restricted because the field is mapped to an unrestricted field with PXDimensionSelectorAttribute. | ||||
ClassType | char(1) | - | ||
Description:No description available | ||||
ContractAccountGroup | int | Account Group | PMAccountGroup | |
Description:No description available | ||||
ContractCD | nvarchar | Contract Template | - | |
Description:No description available | ||||
ContractID | int | Template ID | - | |
Description:No description available | ||||
ContractInfoNonexistent in DB | string | - | ||
Description:No description available | ||||
ContractStrIDNonexistent in DB | string | - | ||
Description:No description available | ||||
CostTaxZoneID | nvarchar(10) | - | ||
Description:No description available | ||||
CreateProforma | bit | Create Pro Forma Invoice on Billing | - | |
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 | ||||
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 | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
DaysNonexistent in DB | string | - | ||
Description:No description available | ||||
DaysBeforeExpirationNonexistent in DB | string | - | ||
Description:No description available | ||||
DefaultAccrualAccountID | int | Accrual Account | Account | |
Description:The identifier of the default accrual account. The value of this field corresponds to the value of the Account.AccountID field. | ||||
DefaultAccrualSubID | int | Accrual Sub. | Sub | |
Description:No description available | ||||
DefaultBranchID | int | Branch | Branch | |
Description:This field is used in the PMProject class. The identifier of the Branch associated with the project. The value of this field corresponds to the value of the Branch.BranchID field. | ||||
DefaultExpenseAccountID | int | Default Cost Account | Account | |
Description:The identifier of the default cost account. The value of this field corresponds to the value of the Account.AccountID field. | ||||
DefaultExpenseSubID | int | Default Cost Subaccount | Sub | |
Description:No description available | ||||
DefaultOverbillingAccountID | int | Overbilling Account | Account | |
Description:The default overbilling account of the project. | ||||
DefaultOverbillingSubID | int | Overbilling Subaccount | Sub | |
Description:The default overbilling subaccount of the project. | ||||
DefaultSalesAccountID | int | Default Sales Account | Account | |
Description:The identifier of the default sales account. The value of this field corresponds to the value of the Account.AccountID field. | ||||
DefaultSalesSubID | int | Default Sales Subaccount | Sub | |
Description:No description available | ||||
DefaultUnderbillingAccountID | int | Underbilling Account | Account | |
Description:The default underbilling account of the project. | ||||
DefaultUnderbillingSubID | int | Underbilling Subaccount | Sub | |
Description:The default underbilling subaccount of the project. | ||||
Description | nvarchar(255) | Description | - | |
Description:No description available | ||||
DetailedBilling | int | Billing Format | - | |
Description:No description available | ||||
DiscontinueAfter | datetime | Discontinue After | - | |
Description:No description available | ||||
DiscountID | nvarchar(10) | Promo Code | ARDiscount | |
Description:No description available | ||||
DropshipExpenseAccountSource | char(1) | - | ||
Description:No description available | ||||
DropshipExpenseRecording | nvarchar(1) | - | ||
Description:No description available | ||||
DropshipExpenseSubMask | nvarchar(30) | Combine Drop-Ship Expense Sub. From | - | |
Description:No description available | ||||
DropshipReceiptProcessing | nvarchar(1) | - | ||
Description:No description available | ||||
Duration | int | Duration | - | |
Description:No description available | ||||
DurationType | char(1) | Duration Unit | - | |
Description:No description available | ||||
EffectiveFrom | datetime | Effective From | - | |
Description:No description available | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
FinanceVisibleNonexistent in DB | int? | Finance Visible | - | |
Description:No description available | ||||
GraceDateNonexistent in DB | DateTime? | - | ||
Description:End Date of Grace Period. | ||||
GracePeriod | int | Grace Period | - | |
Description:Period in days Contract is serviced even after it has expired. Warning is shown whenever user selects the contract that falls in this period. | ||||
GroupMask | varbinary | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
IncludeCO | bit | Include CO | - | |
Description:Include Change Orders in Contract Total | ||||
IncludeQtyInAIA | bit | Show Quantity in AIA Report | - | |
Description:No description available | ||||
IsActive | bit | - | ||
Description:No description available | ||||
IsCancelled | bit | - | ||
Description:No description available | ||||
IsCompleted | bit | - | ||
Description:No description available | ||||
IsContinuous | bit | Shift Expiration Date on Renewal | - | |
Description:No description available | ||||
IsLastActionUndoable | bit | - | ||
Description:No description available | ||||
IsPendingUpdate | bit | - | ||
Description:No description available | ||||
IsTemplateNonexistent in DBObsolete | bool? | - | ||
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 | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LastProformaNumber | nvarchar(15) | Last Application Nbr. | - | |
Description:This field is used in the PMProject class. The application number that has been assigned to the last pro forma invoice with progress billing lines prepared for the current project. | ||||
LimitsEnabled | bit | Use T&M Revenue Budget Limits | - | |
Description:No description available | ||||
LineCtr | int | - | ||
Description:No description available | ||||
LocationID | int | Location | Location | |
Description:No description available | ||||
LockCommitments | bit | - | ||
Description:No description available | ||||
MasterContractID | int | Master Contract | Contract | |
Description:No description available | ||||
MinNonexistent in DB | string | - | ||
Description:No description available | ||||
NonProject | bit | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OriginalContractID | int | Contract | Contract | |
Description:No description available | ||||
OwnerID | int | Owner | 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 | ||||
QuoteNbr | nvarchar(15) | Quote Ref. Nbr. | PMQuote | |
Description:No description available | ||||
RateTableID | nvarchar(15) | - | ||
Description:No description available | ||||
RateTypeID | nvarchar(6) | Rate Type | CurrencyRateType | |
Description:No description available | ||||
RefreshOnRenewal | bit | Refresh Items from Template on Renewal | - | |
Description:No description available | ||||
RefundPeriod | int | Refund Period | - | |
Description:No description available | ||||
Refundable | bit | Refundable | - | |
Description:No description available | ||||
Rejected | bit | Reject | - | |
Description:No description available | ||||
RenewalBillingStartDate | datetime | - | ||
Description:No description available | ||||
RestrictToEmployeeList | bit | Restrict Employees | - | |
Description:This field is used in the PMProject class. Specifies (if set to true) that only the employees associated with the current project can create activities and documents that is associated with the current project. | ||||
RestrictToResourceList | bit | Restrict Equipment | - | |
Description:This field is used in the PMProject class. Specifies (if set to true) that equipment time cards can be associated with the current project for only the equipment that is associated with the current project. | ||||
RetainageMaxPct | decimal | Cap (%) | - | |
Description:Retainage Cap % | ||||
RetainageMode | char(1) | Retainage Mode | - | |
Description:Retainage Mode | ||||
RetainagePct | decimal | - | ||
Description:No description available | ||||
RevID | int | - | ||
Description:No description available | ||||
RevenueTaxZoneID | nvarchar(10) | - | ||
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 | bool? | Selected | - | |
Description:No description available | ||||
ServiceActivate | bit | - | ||
Description:No description available | ||||
SiteAddressObsolete | nvarchar(255) | Site Address | - | |
Description:No description available | ||||
StartDate | datetime | Setup Date | - | |
Description:No description available | ||||
Status | char(1) | Active | - | |
Description:No description available | ||||
SteppedRetainage | bit | Use Steps | - | |
Description:Stepped Retainage | ||||
StrIsTemplateNonexistent in DB | string | Type | - | |
Description:No description available | ||||
TemplateID | int | Contract Template | ContractTemplate | |
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:No description available | ||||
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 | ||||
TotalUsageNonexistent in DB | decimal? | Extra Usage Total | - | |
Description:No description available | ||||
TotalsCalculatedNonexistent in DB | int? | - | ||
Description:No description available | ||||
Type | char(1) | Contract Type | - | |
Description:No description available | ||||
VisibleInAP | bit | - | ||
Description:No description available | ||||
VisibleInAR | bit | - | ||
Description:No description available | ||||
VisibleInCA | bit | CA | - | |
Description:No description available | ||||
VisibleInCR | bit | CRM | - | |
Description:No description available | ||||
VisibleInEA | bit | - | ||
Description:No description available | ||||
VisibleInGL | bit | - | ||
Description:No description available | ||||
VisibleInIN | bit | - | ||
Description:No description available | ||||
VisibleInPO | bit | - | ||
Description:No description available | ||||
VisibleInSO | bit | - | ||
Description:No description available | ||||
VisibleInTA | bit | - | ||
Description:No description available | ||||
WorkgroupIDNonexistent in DB | int? | - | ||
Description:The workgroup that is responsible for the document. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||