| objid | contr_itm | objid | Contract line item internal record number | 3 (UNIQUE) |
| site_objid | site | objid | Site internal record number | |
| site_part_objid | site_part | objid | Site_part internal record number | |
| sp_dir_site_objid | site_part | dir_site_objid | Site at which the part is installed. Derived from all_site_part2site. Not applicable to parts installed at more than one site | |
| sched_objid | contr_schedule | objid | Contract schedule internal record number | |
| contr_objid | contract | objid | Contract internal record number | |
| mod_objid | mod_level | objid | Mod level internal record number | |
| cond_objid | condition | objid | Condition internal record number | |
| line_no | contr_itm | line_no | Contract line item line no | |
| parent_line_no | contr_itm | p_line_no | Line number of the parent contract item | |
| quote_sn | contr_itm | quote_sn | The serial number of the product to be installed under the contract line item | |
| cancel_dt | contr_itm | cancel_dt | If a line is canceled or closed, the date when the cancel or close becomes effective | |
| auto_inst_ind | contr_itm | auto_inst_ind | Indicates whether indicates whether a generic part is to be auto installed: 0=no, 1=yes, default=0 | |
| site_name | site | name | Contract line item site name | |
| site_id | site | site_id | Contract line item site ID | |
| warranty_dt | site_part | warranty_date | Contract line item warranty date | |
| serial_no | site_part | serial_no | Contract line item serial no | |
| sched_id | contr_schedule | schedule_id | Contract schedule ID number | |
| sched_cancel_dt | contr_schedule | close_eff_dt | If the schedule is prematurely closed, the date when the close becomes effective | |
| contr_id | contract | id | Contract ID number | |
| struct_type | contract | struct_type | Type of contract/quote structure of the object; i.e., 0=service contract, 1=sales item | |
| condition | condition | condition | Code number for condition type | |
| cond_title | condition | title | Title of condition | |