Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Id | id | 18 | null |
|
|
Label: Contract ID |
||||||||||
AccountId | reference | 18 | null |
|
|
Label: Account ID |
||||||||||
OwnerExpirationNotice | picklist | 40 | null |
|
|
Label: Owner Expiration Notice |
||||||||||
StartDate | date | 0 | null |
|
|
Label: Contract Start Date |
||||||||||
EndDate | date | 0 | null |
|
|
Label: Contract End Date |
||||||||||
BillingStreet | textarea | 255 | null |
|
|
Label: Billing Street |
||||||||||
BillingCity | string | 40 | null |
|
|
Label: Billing City |
||||||||||
BillingState | string | 80 | null |
|
|
Label: Billing State/Province |
||||||||||
BillingPostalCode | string | 20 | null |
|
|
Label: Billing Zip/Postal Code |
||||||||||
BillingCountry | string | 80 | null |
|
|
Label: Billing Country |
||||||||||
ShippingStreet | textarea | 255 | null |
|
|
Label: Shipping Street |
||||||||||
ShippingCity | string | 40 | null |
|
|
Label: Shipping City |
||||||||||
ShippingState | string | 80 | null |
|
|
Label: Shipping State/Province |
||||||||||
ShippingPostalCode | string | 20 | null |
|
|
Label: Shipping Zip/Postal Code |
||||||||||
ShippingCountry | string | 80 | null |
|
|
Label: Shipping Country |
||||||||||
ContractTerm | int | 4 | null |
|
|
Label: Contract Term |
||||||||||
OwnerId | reference | 18 | null |
|
|
Label: Owner ID |
||||||||||
Status | picklist | 40 | null |
|
|
Label: Status |
||||||||||
CompanySignedId | reference | 18 | null |
|
|
Label: Company Signed By ID |
||||||||||
CompanySignedDate | date | 0 | null |
|
|
Label: Company Signed Date |
||||||||||
CustomerSignedId | reference | 18 | null |
|
|
Label: Customer Signed By ID |
||||||||||
CustomerSignedTitle | string | 40 | null |
|
|
Label: Customer Signed Title |
||||||||||
CustomerSignedDate | date | 0 | null |
|
|
Label: Customer Signed Date |
||||||||||
SpecialTerms | textarea | 4000 | null |
|
|
Label: Special Terms |
||||||||||
ActivatedById | reference | 18 | null |
|
|
Label: Activated By ID |
||||||||||
ActivatedDate | datetime | 0 | null |
|
|
Label: Activated Date |
||||||||||
StatusCode | picklist | 40 | null |
|
|
Label: Status Category |
||||||||||
Description | textarea | 32000 | null |
|
|
Label: Description |
||||||||||
IsDeleted | boolean | 0 | null |
|
|
Label: Deleted |
||||||||||
ContractNumber | string | 30 | null |
|
|
Label: Contract Number |
||||||||||
LastApprovedDate | datetime | 0 | null |
|
|
Label: Last Approved Date |
||||||||||
CreatedDate | datetime | 0 | null |
|
|
Label: Created Date |
||||||||||
CreatedById | reference | 18 | null |
|
|
Label: Created By ID |
||||||||||
LastModifiedDate | datetime | 0 | null |
|
|
Label: Last Modified Date |
||||||||||
LastModifiedById | reference | 18 | null |
|
|
Label: Last Modified By ID |
||||||||||
SystemModstamp | datetime | 0 | null |
|
|
Label: System Modstamp |
||||||||||
LastActivityDate | date | 0 | null |
|
|
Label: Last Activity |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
FakeIndex65 | Must be unique | Asc | Id |