CT
ContractTemplate
PX.Objects.CT145 of 145 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseType | char(1) | Entity Type | - | |
Description:No description available | ||||
ContractCD | nvarchar(30) | Contract Template | - | |
Description:No description available | ||||
AccountingMode | varchar(1) | - | ||
Description:No description available | ||||
ActivationDate | datetime2 | Activation Date | - | |
Description:No description available | ||||
AIALevel | char(1) | AIA Level | - | |
Description:No description available | ||||
AllocationID | nvarchar(15) | - | ||
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 | - | |
Description:No description available | ||||
AttributesNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
AutoAllocate | bit | - | ||
Description:No description available | ||||
AutomaticReleaseAR | bit | Automatically Release AR Documents | - | |
Description:No description available | ||||
AutoRenew | bit | Mass Renewal | - | |
Description:No description available | ||||
AutoRenewDays | int | Renewal Point | - | |
Description:No description available | ||||
BalanceNonexistent in DB | decimal | Balance | - | |
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 | - | |
Description:No description available | ||||
CaseItemID | int | Case Count Item | - | |
Description:No description available | ||||
CertifiedJob | bit | Certified Job | - | |
Description:No description available | ||||
ChangeOrderWorkflow | bit | Change Order Workflow | - | |
Description:No description available | ||||
ClassIDNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
ClassType | char(1) | - | ||
Description:No description available | ||||
ContractAccountGroup | int | Account Group | - | |
Description:No description available | ||||
ContractID | int | Template ID | - | |
Description:No description available | ||||
ContractInfoNonexistent in DB | nvarchar(MAX) | ContractInfo | - | |
Description:No description available | ||||
ContractStrIDNonexistent in DB | nvarchar(MAX) | ContractStrID | - | |
Description:No description available | ||||
CostTaxZoneID | nvarchar(10) | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
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 | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CustomerID | int | - | ||
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 | - | |
Description:No description available | ||||
DefaultAccrualSubID | int | Accrual Sub. | - | |
Description:No description available | ||||
DefaultBranchID | int | Branch | - | |
Description:No description available | ||||
DefaultExpenseAccountID | int | Default Cost Account | - | |
Description:No description available | ||||
DefaultExpenseSubID | int | Default Cost Subaccount | - | |
Description:No description available | ||||
DefaultOverbillingAccountID | int | Overbilling Account | - | |
Description:No description available | ||||
DefaultOverbillingSubID | int | Overbilling Subaccount | - | |
Description:No description available | ||||
DefaultSalesAccountID | int | Default Sales Account | - | |
Description:No description available | ||||
DefaultSalesSubID | int | Default Sales Subaccount | - | |
Description:No description available | ||||
DefaultUnderbillingAccountID | int | Underbilling Account | - | |
Description:No description available | ||||
DefaultUnderbillingSubID | int | Underbilling Subaccount | - | |
Description:No description available | ||||
Description | nvarchar(255) | Description | - | |
Description:No description available | ||||
DetailedBilling | int | Billing Format | - | |
Description:No description available | ||||
DiscontinueAfter | datetime2 | Discontinue After | - | |
Description:No description available | ||||
DiscountID | nvarchar(20) | Promo Code | - | |
Description:No description available | ||||
DropshipExpenseAccountSource | char(1) | - | ||
Description:No description available | ||||
DropshipExpenseRecording | varchar(1) | - | ||
Description:No description available | ||||
DropshipExpenseSubMask | nvarchar(30) | Combine Drop-Ship Expense Sub. From | - | |
Description:No description available | ||||
DropshipReceiptProcessing | varchar(1) | - | ||
Description:No description available | ||||
Duration | int | Duration | - | |
Description:No description available | ||||
DurationType | char(1) | Duration Unit | - | |
Description:No description available | ||||
EffectiveFrom | datetime2 | Effective From | - | |
Description:No description available | ||||
ExpireDate | datetime | - | ||
Description:No description available | ||||
GraceDate | datetime | - | ||
Description:End Date of Grace Period. | ||||
GracePeriod | int | Grace Period | - | |
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 | ||||
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 | ||||
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 | - | |
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 | - | ||
Description:No description available | ||||
LockCommitments | bit | - | ||
Description:No description available | ||||
MasterContractID | int | Master Contract | - | |
Description:No description available | ||||
MinNonexistent in DB | nvarchar(MAX) | Min | - | |
Description:No description available | ||||
NonProject | bit | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OriginalContractID | int | Contract | - | |
Description:No description available | ||||
OwnerID | int | Owner | - | |
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 | - | |
Description:No description available | ||||
PrepaymentEnabled | bit | Use Prepaid Amount | - | |
Description:No description available | ||||
QuoteNbr | nvarchar(15) | Quote Ref. Nbr. | - | |
Description:No description available | ||||
RateTableID | nvarchar(15) | - | ||
Description:No description available | ||||
RateTypeID | nvarchar(6) | Rate Type | - | |
Description:No description available | ||||
RefreshOnRenewal | bit | Refresh Items from Template on Renewal | - | |
Description:No description available | ||||
Refundable | bit | Refundable | - | |
Description:No description available | ||||
RefundPeriod | int | Refund Period | - | |
Description:No description available | ||||
Rejected | bit | Reject | - | |
Description:No description available | ||||
RenewalBillingStartDate | datetime2 | - | ||
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 | - | ||
Description:No description available | ||||
RevenueTaxZoneID | nvarchar(10) | - | ||
Description:No description available | ||||
RevID | int | - | ||
Description:No description available | ||||
SalesPersonID | int | Sales Person | - | |
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 | ||||
StartDate | datetime | - | ||
Description:No description available | ||||
Status | char(1) | Active | - | |
Description:No description available | ||||
SteppedRetainage | bit | Use Steps | - | |
Description:No description available | ||||
StrIsTemplateNonexistent in DB | nvarchar(MAX) | Type | - | |
Description:No description available | ||||
TemplateID | int | - | ||
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:No description available | ||||
TermsID | nvarchar(10) | 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 | - | ||
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:No description available | ||||