objid | contr_schedule | objid | Contr_schedule internal record number | 3 (UNIQUE) |
schedule_id | contr_schedule | schedule_id | Contract ID number | |
schedule_title | contr_schedule | schedule_title | Contract schedule short description | |
gross_line_pr | contr_schedule | gross_line_pr | Sum of all related line item gross prices for the schedule | |
net_line_pr | contr_schedule | net_line_pr | Sum of all related line item adjusted prices for the schedule | |
sched_adj_amt | contr_schedule | sched_adj_amt | Net of related line item price adjustments. Reserved; not used | |
sched_tax_pct | contr_schedule | sched_tax_pct | Total tax percentage applied to the schedule | |
sched_tax_amt | contr_schedule | sched_tax_amt | Placeholder for any tax amount applied to the schedule | |
sched_net_amt | contr_schedule | sched_net_amt | Net of all price adjustments applied directly to the schedule | |
fob | contr_schedule | fob | Identifies the FOB for the schedule | |
close_eff_dt | contr_schedule | close_eff_dt | If the schedule is prematurely closed, the date when the close becomes effective | |
close_crdt_ind | contr_schedule | close_crdt_ind | Indicates whether or not to issue credit upon premature close; i.e., 0=no, 1=yes, default=0 | |
last_update | contr_schedule | last_update | Date time of last update to the schedule/quote | |
last_xfer | contr_schedule | last_xfer | Date time of last transfer to trans_record | |
start_dt | contr_schedule | start_dt | The start date of the billing | |
due_offset | contr_schedule | due_offset | The number of days in advance of the expected payment date that determines the invoice date | |
frequency | contr_schedule | frequency | Frequency of the billing: i.e., 0=annual, 1=semi-annual,2=quarterly,3=monthly,4=one-time, default=0 | |
invc_terms | contr_schedule | invc_terms | Billing terms to appear on the invoice | |
bill_group | contr_schedule | bill_group | Billing group. This is from a user-defined popup list with default name BILLING_GROUP | |
bill_option | contr_schedule | bill_option | Billing option; i.e., 1=in advance, 2=in arrears | |
price_prog_name | price_prog | name | Name for the pricing program | |
price_prog_desc | price_prog | description | Description of the pricing program | |
price_prog_type | price_prog | type | Price type; i.e., 0=Standard Cost, Transfer Price, List Price, Repair Price, or Exchange Price | |
price_prog_eff_dt | price_prog | effective_date | Date the price program becomes effective | |
price_prog_exp_dt | price_prog | expire_date | Last date the price program is effective | |
price_prog_active | price_prog | active | Indicates whether the price program is active; i.e., 0=inactive, 1=active, default=1 | |
site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
site_name | site | name | Site name | |
contract_objid | contract | objid | Contract internal record number | |
chg_start_dt | contr_schedule | itm_start_dt | The earliest contr_itm.chg_start_dt among all contr_itm related to the schedule | |
chg_end_dt | contr_schedule | itm_end_dt | The latest contr_itm.chg_end_dt among all contr_itm related to the schedule | |