View Name:c_schedule_view
View Number:5066
Group:Sales Mgr
Description:Used by forms Contract (9133), Contract <ID> (9134), Line Items (9136, 9675), Schedules (9137, 9676), Payment Options (9141, 9677), Quote (9162, 9673) and others
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcontr_scheduleobjidContr_schedule internal record number 3 (UNIQUE)
schedule_idcontr_scheduleschedule_idContract ID number 
schedule_titlecontr_scheduleschedule_titleContract schedule short description 
gross_line_prcontr_schedulegross_line_prSum of all related line item gross prices for the schedule 
net_line_prcontr_schedulenet_line_prSum of all related line item adjusted prices for the schedule 
sched_adj_amtcontr_schedulesched_adj_amtNet of related line item price adjustments. Reserved; not used 
sched_tax_pctcontr_schedulesched_tax_pctTotal tax percentage applied to the schedule 
sched_tax_amtcontr_schedulesched_tax_amtPlaceholder for any tax amount applied to the schedule 
sched_net_amtcontr_schedulesched_net_amtNet of all price adjustments applied directly to the schedule 
fobcontr_schedulefobIdentifies the FOB for the schedule 
close_eff_dtcontr_scheduleclose_eff_dtIf the schedule is prematurely closed, the date when the close becomes effective 
close_crdt_indcontr_scheduleclose_crdt_indIndicates whether or not to issue credit upon premature close; i.e., 0=no, 1=yes, default=0 
last_updatecontr_schedulelast_updateDate time of last update to the schedule/quote 
last_xfercontr_schedulelast_xferDate time of last transfer to trans_record 
start_dtcontr_schedulestart_dtThe start date of the billing 
due_offsetcontr_scheduledue_offsetThe number of days in advance of the expected payment date that determines the invoice date 
frequencycontr_schedulefrequencyFrequency of the billing: i.e., 0=annual, 1=semi-annual,2=quarterly,3=monthly,4=one-time, default=0 
invc_termscontr_scheduleinvc_termsBilling terms to appear on the invoice 
bill_groupcontr_schedulebill_groupBilling group. This is from a user-defined popup list with default name BILLING_GROUP 
bill_optioncontr_schedulebill_optionBilling option; i.e., 1=in advance, 2=in arrears 
price_prog_nameprice_prognameName for the pricing program 
price_prog_descprice_progdescriptionDescription of the pricing program 
price_prog_typeprice_progtypePrice type; i.e., 0=Standard Cost, Transfer Price, List Price, Repair Price, or Exchange Price 
price_prog_eff_dtprice_progeffective_dateDate the price program becomes effective 
price_prog_exp_dtprice_progexpire_dateLast date the price program is effective 
price_prog_activeprice_progactiveIndicates whether the price program is active; i.e., 0=inactive, 1=active, default=1 
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
site_namesitenameSite name 
contract_objidcontractobjidContract internal record number 
chg_start_dtcontr_scheduleitm_start_dtThe earliest contr_itm.chg_start_dt among all contr_itm related to the schedule 
chg_end_dtcontr_scheduleitm_end_dtThe latest contr_itm.chg_end_dt among all contr_itm related to the schedule 

Joins:

Join FromJoin To
(contr_schedule).bill_to2siteOUTER (site).bill_site2contr_schedule
(contr_schedule).default_prog2price_progOUTER (price_prog).price_prog2contr_schedule
(contr_schedule).schedule2contract(contract).contract2contr_schedule
My Recent Objects
c_schedule_view