| alert_ind | LONG | tinyint | | | | DIRECT | When set to 1, indicates there is an alert related to the site | |
| arch_ind | LONG | int | | | | DIRECT, ALLOW_NULL | When set to 1, indicates the object is ready for purge/archive | |
| close_crdt_ind | LONG | tinyint | | | 0 | DIRECT | Indicates whether or not to issue credit upon premature close; i.e., 0=no, 1=yes, default=0 | |
| close_eff_dt | CLK_TIME | datetime | | | | CHANGE_FIELD | The date the object was closed | |
| contr_dur | CHAR | varchar | | 40 | | | The user defined duration for the object. This is from a user-defined popup | |
| create_dt | CLK_TIME | datetime | | | | | The create date of the object | Search (4) |
| dev | LONG | int | 151 | | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | |
| dflt_end_dt | CLK_TIME | datetime | | | | | The default last day of contracted service for all line items | |
| dflt_start_dt | CLK_TIME | datetime | | | | | The default start date of contracted service for all line items | |
| evergreen_ind | LONG | tinyint | | | 0 | DIRECT | Indicates whether the object is to be auto-renewed; i.e., 0=no, 1=yes, default=0 | |
| expire_date | CLK_TIME | datetime | | | | | The date the object ends. Where line items are involved, this is the ending service date of the latest line item | Search (7) |
| fsvc_end_date | CLK_TIME | datetime | | | | | The end date of earliest ending renewable service under the contract. Used for renewal of contracts. Accommodates non-coterminous contracts | Search (1) |
| handling_cost | DECIMAL | decimal (19,4) | | | | CURRENCY | The sum of all handling costs for the object | |
| hours_for_pm | CHAR | varchar | | 30 | | | Specific hours that preventative maintenance procedures may be performed | |
| id | CHAR | varchar | 4 | 40 | | | Unique Identifier of the contract/quote/order/shipping list | Search (23) |
| last_save_dt | CLK_TIME | datetime | | | | | Date the object was last saved | |
| last_update | CLK_TIME | datetime | | | | CHANGE_DATE | Date time of last update to the object | |
| last_xfer | CLK_TIME | datetime | | | | | Date time of last transfer to trans_record. Reserved; obsolete | |
| notes | CHAR | varchar | | 255 | | | Notes that pertain to the object; used with special considerations flag | |
| objid | LONG | int | 3 | | | DIRECT | Internal record number | Search (39) |
| onsite_resp | LONG | int | | | | DIRECT | The elapsed time within which a field engineer is required by the object to arrive at the customer site in seconds | |
| ord_submit_dt | CLK_TIME | datetime | | | | | Date the order was submitted | Search (4) |
| order_status | CHAR | varchar | | 30 | | ALLOW_NULL | Quote/Order status | Search (2) |
| pay_options | CHAR | varchar | | 30 | | | Specifies the method of payment for the object | |
| phone_resp | LONG | int | | | | DIRECT | The elapsed time within which a service rep is required by the object to contact the customer via phone in seconds | Search (2) |
| po_number | CHAR | varchar | | 40 | | | The purchase order number that was used to originally start the contract coverage | Search (1) |
| q_end_date | CLK_TIME | datetime | | | | | The end date for the object. This is the last date the offer or agreement is effective | Search (6) |
| q_issue_dt | CLK_TIME | datetime | | | | | The date the object was issued to the prospect | Search (6) |
| q_start_date | CLK_TIME | datetime | | | | | The start date for the object. This is the date the offer becomes effective | Search (6) |
| quote_dur | LONG | smallint | | | | DIRECT | The length of time from the start_date in seconds that the object prices are effective | |
| ready_to_bill | LONG | tinyint | | | 0 | DIRECT | If the contract is ready for new billing record generation it will be set to 1 | |
| renew_notf_ind | LONG | tinyint | | | 1 | DIRECT | Indicates whether the object needs renewal notification; i.e., 0=no, 1=yes, default=1 | |
| renew_ntfy_dt | CLK_TIME | datetime | | | | | Date on which renewal notification is to be sent. Calculated from renew_cycle and fsvc_end_date | |
| renew_prior | LONG | smallint | | | 0 | DIRECT | Number of days to be subtracted from fsvc_end_date to yield renew_ntfy_dt | |
| sched_ind | LONG | tinyint | | | 1 | DIRECT | Indicates whether the object has exactly one schedule; i.e., 0=no, 1=yes, default=1. Reserved; not used | |
| spec_consid | LONG | int | | | | DIRECT | Flag that indicates special circumstances; causes contract form to be automatically posted when contract is selected for a new case | |
| start_date | CLK_TIME | datetime | | | | | The date the object becames/became effective. Where line items are involved, this is the begin effective date of the earliest line item | Search (7) |
| status | CHAR | varchar | | 40 | | | The current status of the object. This is a user-defined pop up with name depending on struct_type | Search (4) |
| struct_type | LONG | tinyint | | | 0 | DIRECT | The record type of the object; i.e., 0=service contract, 1=sales item, 2=eOrder, 3=shopping list | Search (11) |
| terms_cond | CHAR | varchar | | 40 | | | User-defined terms and conditions. This is a user-defined popup with default name Terms and Conditions | |
| title | CHAR | varchar | 2 | 80 | | | Title of the object | Search (10) |
| tot_ship_amt | DECIMAL | decimal (19,4) | | | | CURRENCY | The sum of all shipping charges for the object | |
| total_gross | DECIMAL | decimal (19,4) | | | | CURRENCY | Total gross price for the object | |
| total_net | DECIMAL | decimal (19,4) | | | | CURRENCY | Total net price for the object (see struct_type) | Search (5) |
| total_tax_amt | DECIMAL | decimal (19,4) | | | | CURRENCY | The sum of all taxes applied to the object | |
| type | CHAR | varchar | | 40 | | | The specific nature of the contract-standard. This is a user-defined pop up list with default name of CONTRACT_TYPE | Search (5) |
| unit_type | CHAR | varchar | | 30 | | | The type of units the object is delivered in; e.g., days, calls, hours, visits, etc | Search (1) |
| units_avail | FLOAT | real | | | | | The number of units that are currently available for use | Search (1) |
| units_purch | FLOAT | real | | | | | The number of units that were purchased in the object | Search (1) |
| units_used | FLOAT | real | | | | | The number of units that have been used by the object | Search (1) |
| version | CHAR | varchar | | 10 | | | Version number of the object | |
| warr_set_ind | LONG | tinyint | | | 0 | DIRECT | Indicates whether or not te set line item start dates to end of part warranty date; i.e., 0=no, 1=yes, default=0 | |