Table Name:	contr_schedule
Table Number:	5051
Group:	Sales Mgr
Description:	Contract or quote schedule object
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_contr_schedule

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bill_attn	CHAR	varchar		30			First name of the person billing will be directed to
bill_attn2	CHAR	varchar		40			Last name of the person billing will be directed to
bill_group	CHAR	varchar		30			Billing group. This is from a user-defined popup list with default name BILLING_GROUP	Search (1)
bill_option	LONG	tinyint				DIRECT, CHANGE_FIELD	Billing option; i.e., 0=in advance, 1=in arrears	Search (1)
close_crdt_ind	LONG	tinyint			0	DIRECT	Indicates whether or not to issue credit upon premature close; i.e., 0=no, 1=yes, default=0	Search (1)
close_eff_dt	CLK_TIME	datetime				CHANGE_FIELD	If the schedule is prematurely closed, the date when the close becomes effective	Search (2)
cycle_chg_ind	LONG	tinyint				DIRECT	Billing cycle change indicator; i.e., 0=not changed, 1=changed. Used to signal that the schedule needs to be re-amortized
cycle_start_dt	CLK_TIME	datetime				CHANGE_FIELD	The starting date of the billing cycle. Used with schedule frequency to calculate the periodic 'as of' billing dates
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
due_offset	LONG	int				DIRECT, CHANGE_FIELD	The number of days in advance of the expected payment date that determines the invoice date	Search (1)
fob	CHAR	varchar		40			Identifies the FOB for the schedule. This is a user-defined popup with default name FOB	Search (1)
frequency	LONG	tinyint				DIRECT, CHANGE_FIELD	Frequency of the billing: i.e., 0=annual, 1=semi-annual, 2=quarterly, 3=monthly, 4=one-time, default=0	Search (2)
fsvc_end_dt	CLK_TIME	datetime					The earliest service end date among all contr_itm related to the schedule
fsvc_start_dt	CLK_TIME	datetime					The earliest service start date among all contr_itm related to the schedule
gross_line_pr	DECIMAL	decimal (19,4)				CURRENCY	Sum of all related line item gross prices	Search (1)
handling_cost	DECIMAL	decimal (19,4)				CURRENCY	The sum of all handling costs for the schedule
invc_terms	CHAR	varchar		80			Billing terms to appear on the invoice	Search (1)
item_count	LONG	int				DIRECT	The number of lines in the schedule, parent and child included
itm_end_dt	CLK_TIME	datetime				CHANGE_FIELD	The latest contr_itm.chg_end_dt among all contr_itm related to the schedule	Search (1)
itm_start_dt	CLK_TIME	datetime				CHANGE_FIELD	The earliest contr_itm.chg_start_dt among all contr_itm related to the schedule	Search (1)
last_p_line_no	LONG	int				DIRECT	Value of p_line_no assigned to the last related contr_itm
last_update	CLK_TIME	datetime				CHANGE_DATE	Date time of last update to the schedule/quote	Search (1)
last_xfer	CLK_TIME	datetime					Date time of last transfer to trans_record	Search (1)
lsvc_end_dt	CLK_TIME	datetime					The latest service end date among all contr_itm related to the schedule
net_line_pr	DECIMAL	decimal (19,4)				CURRENCY	Sum of all related line item net prices	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (13)
sched_adj_amt	DECIMAL	decimal (19,4)				CURRENCY	Net of amount of schedule-level adjustments	Search (1)
sched_net_amt	DECIMAL	decimal (19,4)				CHANGE_FIELD, CURRENCY	Net_line_pr adjusted by Sched_adj_amt	Search (1)
sched_tax_amt	DECIMAL	decimal (19,4)				CURRENCY	Tax amount applied to the schedule	Search (1)
sched_tax_pct	DECIMAL	decimal (19,4)					Tax percentage applied to the schedule	Search (1)
schedule_id	CHAR	varchar	4	40			Unique-within contract/order/quote object identifier	Search (8)
schedule_title	CHAR	varchar		80			Contract schedule short description	Search (2)
ship_amt	DECIMAL	decimal (19,4)				CURRENCY	The sum of all shipping charges applied to the schedule
ship_attn	CHAR	varchar		30			First name of the person shipment will be directed to
ship_attn2	CHAR	varchar		40			Last name of the person shipment will be directed to
ship_via	CHAR	varchar		80			Requested means of shipment. This is from a Clarify-defined popup list with default name SHIP_VIA
start_dt	CLK_TIME	datetime					The start date of the billing	Search (1)
total_grand	DECIMAL	decimal (19,4)				CURRENCY	Sum of the sched_net_amt, sched_tax_amt, ship_amt, and handling_cost fields on the schedule. It represents the sum total of all charges, surcharges, and discounts of the contr_schedule. Used where contract.struct_type=2

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
bill_addr2address	MTO	address	bill_addr2contr_schedule	Identifies the billing address for the contract schedule
ship_addr2address	MTO	address	ship_addr2contr_schedule	Identifies the shipping address for the contract schedule
schedule2amort_dtl	OTM	amort_dtl	detail2contr_schedule	Identifies the default price schedule for the contract schedule
schedule2bill_itm	OTM	bill_itm	bill_itm2contr_schedule	Non-recurring billing instructions for the schedule
schedule2con_csc_role	OTM	con_csc_role	con_role2contr_schedule	Contact roles for the schedule
schedule2contr_itm	OTM	contr_itm	contr_itm2contr_schedule	Line items belonging to the schedule
schedule2contr_pr	OTM	contr_pr	contr_pr2contr_schedule	Schedule-level price adjustments for the contract
schedule2contract	MTO	contract	contract2contr_schedule	Contract/quote to which the schedule belongs	Search (9)
schedule2demand_hdr	OTOF	demand_hdr	reqst2contr_schedule	Related parts request. Available for custom use for eOrder fulfillment. Reserved
schedule2N_JobSummary	OTOF	N_JobSummary	N_JobSummary2schedule	Configurator version of the schedule
schedule2period_amt	OTM	period_amt	period2contr_schedule	Related billing period schedule-level amount
default_prog2price_prog	MTO	price_prog	price_prog2contr_schedule	Identifies the default price schedule for the contract schedule	Search (2)
schedule2purchase_ord	OTM	purchase_ord	payment2contr_schedule	Payment methods used by the schedule
schedule2sit_csc_role	OTM	sit_csc_role	sit_role2contr_schedule	Site roles for the schedule
ship_to2site	MTO	site	ship_site2contr_schedule	Identifies the ship-to site for the schedule
bill_to2site	MTO	site	bill_site2contr_schedule	Identifies the bill-to site for the schedule	Search (2)
sched2trans_record	OTM	trans_record	tr2contr_schedule	Reserved; not used

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
sched_index	schedule_id:schedule2contract	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_bill_to2site	bill_to2site	nonclustered located on PRIMARY
ind_fsvc_start_dt	fsvc_start_dt, lsvc_end_dt	nonclustered located on PRIMARY
ind_last_update	last_update	nonclustered located on PRIMARY
ind_schedule2contract	schedule2contract	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
sched_index	schedule_id, schedule2contract	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5063	contr_sp_chk	condition, contr_itm, contr_schedule, contract, mod_level, site, site_part
5064	sched_sit_rol	contr_schedule, sit_csc_role, site
5065	contract_itm_lst	contr_itm, contr_schedule, mod_level, part_num, price_inst, purchase_ord, site, site_part
5066	c_schedule_view	contr_schedule, contract, price_prog, site
5109	ccn_bill_view	bus_org, condition, contr_schedule, contract, currency, site, user
5182	site_svc_itm	condition, contr_itm, contr_schedule, contract, site
5183	prod_svc_itm	condition, contr_itm, contr_schedule, contract, site_part
5188	sched_con_rol	con_csc_role, contact, contr_schedule
5195	c_sched_pd_amt	contr_schedule, period_amt
5197	pd_amt_sched	contr_schedule, contract, period_amt
5201	rol_cntrct	con_csc_role, contact, contr_schedule, contract
5517	contr_itm_lst	contr_itm, contr_schedule, mod_level, part_num
6066	contr_itm_lst_vw	contr_itm, contr_schedule, contract, currency, mod_level, part_num, price_inst, purchase_ord, site, site_part

My Recent Objects

contr_schedule

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog