| ccn_objid | contract | objid | Contract internal record number | 3 (UNIQUE) |
| id_number | contract | id | Contract number; generated via auto-numbering | 4 |
| owner | owner(user) | login_name | Owner login name | |
| condition | condition | title | Title of contract condition | 7 |
| status | gbst_elm | title | Contract status | 8 |
| type | contract | type | Contract type | |
| cont_start_date | contract | start_date | Contract start date | |
| cont_exp_date | contract | expire_date | Contract expiration date | |
| q_start_date | contract | q_start_date | Quote start date | |
| q_end_date | contract | q_end_date | Quote end date | |
| org_name | bus_org | name | Organization name | |
| contact_fname | contact | first_name | Contact first name | 14 |
| contact_lname | contact | last_name | Contacat last name | 15 |
| title | contract | title | Title of the contract | |
| administrator | admin(user) | login_name | Administrator login name | |
| fsvc_end_date | contract | fsvc_end_date | The end date of earliest ending service under the contract. Used for renewal of non-coterminous contracts | |
| struct_type | contract | struct_type | Type of contract/quote structure of the object; i.e., 0=service contract, 1=sales item | |
| contact_objid | contact | objid | Contact internal record number | |
| owner_objid | owner(user) | objid | Owner user internal record number | |
| admin_objid | admin(user) | objid | Administrator user internal record number | |
| status_objid | gbst_elm | objid | Status gbst_elm internal record number | |
| bus_org_objid | bus_org | objid | Bus_org internal record number | |
| cndtn_objid | condition | objid | Condition internal record number | |
| ord_submit_dt | contract | ord_submit_dt | Date the order was submitted | |
| order_status | contract | order_status | MACD order status field | |