Table Name:	demand_hdr
Table Number:	48
Group:	Logistics
Description:	Part request; contains basic request information
Flags:
Baseline/Custom:	Baseline

select * from table_demand_hdr

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
attn_phone	CHAR	varchar		40			Phone number of the person the header is created for
demand_type	LONG	int			0	DIRECT	Type of part request; i.e., 0=standard part request, 1=literature part request, 2=vendor part request	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dist	LONG	int				DIRECT	Reserved; not used
header_case_no	CHAR	varchar		255			The ID of the object which originated the header; i.e., the case, subcase, or opportunity ID	Search (3)
header_date	CLK_TIME	datetime					The create date for the request header	Search (3)
header_number	CHAR	varchar	4	20			The request ID for the part request header	Search (2)
modify_stmp	CLK_TIME	datetime	48				The date and time when object is saved
notes	CHAR	varchar		255			Notes about the part request
objid	LONG	int	3			DIRECT	Internal record number	Search (7)
order_acknowl	LONG	int			0	DIRECT	Reserved; future
originator	CHAR	varchar		30			The user originator for the request
ownership_stmp	CLK_TIME	datetime	47				The date and time when ownership changes
partials	LONG	int			1	DIRECT	Reserved; future
pay_method	CHAR	varchar		40			Payment method. This is from a user-defined popup with default name PAYMENT_METHOD
pay_terms	CHAR	varchar		40			Payment terms. This is from a user-defined popup with default name PAYMENT_TERMS
priority	CHAR	varchar		40			Request priority This is from a user-defined popup with default name REQUEST_PRIORITY	Search (1)
removed	LONG	int			0	DIRECT	Indicates the logical removal of the object; i.e., 0=present, 1=removed, default=0
request_auth	LONG	int			0	DIRECT	Reserved; future
request_notes	CHAR	varchar		255			Comments about the request
request_status	CHAR	varchar		20			Status of the request	Search (3)
sequence_num	LONG	int				DIRECT	Represents the number of detail records for the demand header
ship_address	CHAR	varchar		200			Local copy of the site address; line 1
ship_address2	CHAR	varchar		200			Local copy of the site address; line 2
ship_attn	CHAR	varchar		30			First name of the person the header is created for	Search (1)
ship_attn2	CHAR	varchar		40			Last name of the person the header is created for	Search (1)
ship_city	CHAR	varchar		30			Local copy of the site city	Search (1)
ship_country	CHAR	varchar		40			Local copy of the request country
ship_site_id	CHAR	varchar		80			Site ID of the ship to site selected for the header
ship_state	CHAR	varchar		40			Local copy of the site state
ship_zip	CHAR	varchar		20			Local copy of the site zip or other postal code
site_name	CHAR	varchar		80			Local copy of the site name	Search (3)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views
caseinfo2case	MTO	case	caseinfo2demand_hdr	The case the request is related to
attention2contact	MTO	contact	contact2demand_hdr	The contact for the request
reqst2contr_schedule	OTOP	contr_schedule	schedule2demand_hdr	The contract/quote schedule the request is related to. Reserved; future
ship_info2country	MTO	country	country2demand_hdr	Country to which the part request header is addressed
demand_hdr2demand_dtl	OTM	demand_dtl	demand_dtl2demand_hdr	Detail items for the part request header
hdr_attach2doc_inst	OTM	doc_inst	doc_inst2demand_hdr	Attachments to the part request header
autorepl2part_auth	MTM	part_auth	part_auth2demand_hdr	Part authorizations having outstanding auto-replenishment orders under the header	mtm_demand_hdr9_ part_auth2
open_reqst2site	MTO	site	site2demand_hdr	Site to which the request will be shipped		Search (2)
bill_reqst2site	MTO	site	bill_site2demand_hdr	Site to which the request will be billed
ship_info2state_prov	MTO	state_prov	state_code2demand_hdr	State or province to which the part request header is addressed
subcaseinfo2case	MTO	subcase	subcaseinfo2demand_hdr	Reserved; not used. Use relation from parent case to demand_hdr instead
current_owner2owner	MTO	user	curr_owner2demand_hdr	Owner of the part request header

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_demand_hdr_header_number	header_number	nonclustered located on PRIMARY
ind_demand_hdr_originator	originator	nonclustered located on PRIMARY
ind_demand_hdr_pay_method	pay_method	nonclustered located on PRIMARY
ind_demand_hdr_pay_terms	pay_terms	nonclustered located on PRIMARY
ind_demand_hdr_ship_address	ship_address	nonclustered located on PRIMARY
ind_demand_hdr_ship_attn	ship_attn	nonclustered located on PRIMARY
ind_demand_hdr_ship_attn2	ship_attn2	nonclustered located on PRIMARY
ind_demand_hdr_ship_city	ship_city	nonclustered located on PRIMARY
ind_demand_hdr_ship_site_id	ship_site_id	nonclustered located on PRIMARY
ind_demand_hdr_site_name	site_name	nonclustered located on PRIMARY
ind_open_reqst2site	open_reqst2site	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
23	recv_sum	demand_dtl, demand_hdr, inv_bin, inv_locatn, mod_level, part_inst, part_num, part_trans, recv_parts
50	demand_vue	demand_dtl, demand_hdr, mod_level, part_num
221	repair_sum	demand_dtl, demand_hdr, mod_level, part_inst, part_num
238	req_sum	condition, demand_dtl, demand_hdr, gbst_elm, mod_level, part_num, user
4612	pr_hdr_site	demand_hdr, site
5194	demand_site	demand_dtl, demand_hdr, gbst_elm, mod_level, part_num, site
5332	req_demand	condition, demand_dtl, demand_hdr, gbst_elm, mod_level, user

My Recent Objects

demand_hdr

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