CT
Contract
PX.Objects.CTView API Entity: Contract
/entity/Default/24.200.001/Contract143 of 143 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseType | char(1) | Entity Type | - | |
Description:No description available | ||||
ContractCD | nvarchar(30) | Contract ID | Contract | |
Description:No description available | ||||
AccountingMode | char(1) | - | ||
Description:No description available | ||||
ActivationDate | datetime | 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 | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:No description available | ||||
Approved | bit | Approved | - | |
Description:No description available | ||||
ApproverID | int | Project Manager | EPEmployee | |
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 | 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 ) 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 | nvarchar(MAX) | - | ||
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 | ||||
ContractID | int | Contract ID | - | |
Description:No description available | ||||
ContractInfoNonexistent in DB | nvarchar(MAX) | ContractInfo | - | |
Description:No description available | ||||
CostTaxZoneID | nvarchar(10) | - | ||
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 | ||||
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 | Currency | |
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: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:No description available | ||||
DefaultOverbillingSubID | int | Overbilling Subaccount | Sub | |
Description:No description available | ||||
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:No description available | ||||
DefaultUnderbillingSubID | int | Underbilling Subaccount | Sub | |
Description:No description available | ||||
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(20) | Promo Code | ARDiscount | |
Description:No description available | ||||
DropshipExpenseAccountSource | char(1) | - | ||
Description:No description available | ||||
DropshipExpenseRecording | char(1) | - | ||
Description:No description available | ||||
DropshipExpenseSubMask | varchar(30) | Combine Drop-Ship Expense Sub. From | - | |
Description:No description available | ||||
DropshipReceiptProcessing | char(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 | ||||
GraceDate | 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(32) | - | ||
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 Expire Date on Renew | - | |
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 | 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 | nvarchar(MAX) | Min | - | |
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 | ||||
Refundable | bit | Refundable | - | |
Description:No description available | ||||
RefundPeriod | int | Refund Period | - | |
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 ) 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 ) that equipment time cards can be associated with the current project for only the equipment that is associated with the current project. | ||||
RetainageMaxPct | decimal(19, 6) | Cap (%) | - | |
Description:Retainage Cap % | ||||
RetainageMode | nvarchar(1) | Retainage Mode | - | |
Description:Retainage Mode | ||||
RetainagePct | decimal(19, 6) | - | ||
Description:No description available | ||||
RevenueTaxZoneID | nvarchar(10) | - | ||
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 | ||||
StartDate | datetime | Setup Date | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SteppedRetainage | bit | Use Steps | - | |
Description:Stepped Retainage | ||||
StrIsTemplateNonexistent in DB | nvarchar(MAX) | Type | - | |
Description:No description available | ||||
TemplateID | int | Contract Template | Contract | |
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 | ||||
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:The workgroup that is responsible for the document. | ||||