| objid | contr_schedule | objid | Contract schedule internal record number | 3 (UNIQUE) |
| contr_objid | contract | objid | Contract internal record number | |
| currency_objid | currency | objid | Currency internal record number | |
| site_objid | site | objid | Site internal record number | |
| cond_objid | condition | objid | Condition internal record number | |
| condition | condition | condition | Code number for condition type | |
| id_number | contract | id | Contract number; generated via auto-numbering | |
| start_date | contract | start_date | Contract start date | |
| end_date | contract | expire_date | Title of contract condition | |
| adm_name | user | login_name | Administrator login name | |
| org_name | bus_org | name | Sell to organization. name | |
| sched_id | contr_schedule | schedule_id | Unique identifier of the contract schedule | |
| sched_title | contr_schedule | schedule_title | Contract schedule name | |
| struct_type | contract | struct_type | Type of contract/quote structure of the object; i.e., 0=service contract, 1=sales item | |
| frequency | contr_schedule | frequency | Frequency of the billing: i.e., 0=annual, 1=semi-annual, 2=quarterly, 3=monthly, 4=one-time, default=0 | |
| site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
| site_name | site | name | Site name | |
| contract_title | contract | title | Title of the contract or quote | |
| svc_start_dt | contract | start_date | The date the contract became active. Where line items are involved, this is the begin service date of the earliest line item | |
| svc_expire_dt | contract | expire_date | The date the contract ends. Where contract line items are involved, this is the ending service date of the latest line item | |
| sub_scale | currency | sub_scale | Gives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 | |