Table Name:	demand_dtl
Table Number:	49
Group:	Logistics
Description:	Part request detail; contains line item information for part requests including part information
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_demand_dtl

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
activity	LONG	int				DIRECT	Reserved; future	Search (4)
backorder_qty	LONG	int			0	DIRECT	Quantity put on backorder	Search (2)
carrier	CHAR	varchar		40			The user-defined carrier the request was shipped by; from a user-defined pop up with default name CARRIER
closed	LONG	int				DIRECT	Indicates whether the request is closed
demand_qty	LONG	int			0	DIRECT	The quantity ordered	Search (10)
demand_subtype	LONG	int			0	DIRECT	Reserved; future	Search (2)
demand_type	LONG	int			0	DIRECT	Reserved; future
det_type	LONG	int			2	DIRECT	Reserved; future
detail_notes	CHAR	varchar		255			Order notes for the detail
detail_number	CHAR	varchar	4	20			The part request number for the request	Search (13)
details_date	CLK_TIME	datetime					The create date for the part request	Search (9)
details_status	CHAR	varchar		40			Reserved; not used	Search (4)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dist	LONG	int				DIRECT	Reserved; not used
doa	LONG	int				DIRECT	Indicates whether the item was dead on arrival
est_rtn_date	CLK_TIME	datetime					The estimated return date for the part
failure_code	CHAR	varchar		40			The failure code for the part. This is from a user-defined popup with default name FAILURE_CODE
fulfilled_qty	LONG	int			0	DIRECT	The fulfilled (moved) quantity	Search (2)
in_repair_qty	LONG	int				DIRECT	This is always the same qty as the order qty
labor_cost	DECIMAL	decimal (19,4)				CURRENCY	Total labor cost calculated from data within depot repair
last_fulf_sn	CHAR	varchar		40			Last fulfill Serial number for the request	Search (1)
last_rcv_sn	CHAR	varchar		40			Last received Serial number for the request
modify_stmp	CLK_TIME	datetime	48				Date and time when object was last saved. Reserved; future
movement_type	LONG	int				DIRECT	Reserved; future	Search (2)
mtl_cost	DECIMAL	decimal (19,4)				CURRENCY	Total material cost recorded within depot repair
next_date	CLK_TIME	datetime					The date required	Search (3)
ntf	LONG	int				DIRECT	Indicates whether no trouble was found in the detail
objid	LONG	int	3			DIRECT	Internal record number	Search (17)
orig_id	CHAR	varchar		20			If originated from another demand_dtl, the originating part request's detail_number (see relation demand_dtl.child_dtl2demand_dtl)	Search (1)
originator	CHAR	varchar		30			The originator for the detail
ownership_stmp	CLK_TIME	datetime	47				The date and time when ownership last changed
part_price	DECIMAL	decimal (19,4)				CURRENCY	The price for the request
part_used_qty	LONG	int				DIRECT	Calculated from the addition of removed, installed or exchanged parts from the log parts used process
picked_qty	LONG	int			0	DIRECT	The picked (reserved for fulfill) quantity	Search (2)
po_number	CHAR	varchar		30			The purchase order for the request
price_program	CHAR	varchar		40			Reserved; future
priority	CHAR	varchar		40			Priority displayed in WIP and Queue forms (275 & 728)	Search (4)
qa_time	LONG	int				DIRECT	Labor invested in the quality assurance of part on this request
receipt_date	CLK_TIME	datetime					The date the request was received
received_qty	LONG	int			0	DIRECT	The received (from a fulfill) quantity	Search (2)
removed	LONG	int			0	DIRECT	Indicates the logical removal of the log object; i.e., 0=present, 1=removed, default=0
rep_warranty	CLK_TIME	datetime					Reserved; future
repair_comment	CHAR	varchar		255			The repair comments for the request
repair_cost	DECIMAL	decimal (19,4)				CURRENCY	The cost to repair the request
repair_status	CHAR	varchar		40			The status of repair for the request. This is a user-defined popup with default name REPAIR_STATUS
repair_type	CHAR	varchar		40			The type of repair for the request. This is a user-defined popup with default name REPAIR_TYPE
reported_prob	CHAR	varchar		255			The reported problem for the request
request_status	CHAR	varchar		40			Reserved; not used	Search (2)
request_type	CHAR	varchar		40	Order		Type of request. This is a user-defined popup with default name RMA_TYPE	Search (4)
requested_mod	CHAR	varchar		10			The part revision requested for the request
rma_history	CHAR	text	23			ALLOW_NULL	Reserved; not used
rpr_time	LONG	int				DIRECT	Labor invested in the repair of the part on this request
serial_no	CHAR	varchar		40			Serial number for the request	Search (4)
ship_date	CLK_TIME	datetime					The date the request was shipped
ship_to_flag	LONG	int			1	DIRECT	Reserved; future
ship_via	CHAR	varchar		80			Means/priority of shipment; e.g., overnight delivery; from user-defined pop up with default name SHIP_VIA
shipped_qty	LONG	int			0	DIRECT	The quantity shipped	Search (6)
test_time	LONG	int				DIRECT	Labor invested in the testing of part on this request
title	CHAR	varchar	2	80			Part request title, composed from the part number and part revision	Search (6)
update_inv_qty	LONG	int				DIRECT	Always the same qty as the part_used_qty if the update inventory action is completed successfully
vendor_rma	CHAR	varchar		20			Reserved; future
warranty	LONG	int				DIRECT	Warranty checkbox
waybill	CHAR	varchar		40			The waybill for the request

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
demand_dtl2act_entry	OTM	act_entry	act_entry2demand_dtl	Activity log entries for the part request detail object
demand_dtl2backorder	OTM	backorder	backorder2demand_dtl	Reserved; future
demand_dtl2condition	OTOP	condition	condition2demand_dtl	Condition of the part request detail object			Search (10)
orig_dtl2demand_dtl	OTM	demand_dtl	child_dtl2demand_dtl	Child part requests spawned from the part request
child_dtl2demand_dtl	MTO	demand_dtl	orig_dtl2demand_dtl	Parent part request from which the part request was spawned
demand_dtl2demand_hdr	MTO	demand_hdr	demand_hdr2demand_dtl	Part request header to which the detail belongs			Search (7)
demand_dtl2doc_inst	OTM	doc_inst	doc_inst2demand_dtl		USER_DEFINED
demand_dtl2eco_hdr	MTM	eco_hdr	eco2demand_dtl	ECOs applied to the demand detail		mtm_demand_dtl27_ eco_hdr3
dmnd_dtl_sts2gbst_elm	MTO	gbst_elm	status2demand_dtl	Status of the part request detail object			Search (8)
demand_dtl2inv_bin	MTO	inv_bin	inv_bin2demand_dtl	The desired destination inventory bin. Note: the actual destination inventory bin is that of the related fulfull part_trans
orig_part2part_info	MTO	mod_level	orig_part2demand_dtl	Part revision which was originally requested
demand_dtl2part_info	MTO	mod_level	part_info2demand_dtl	Supplied part revision for the part request detail object			Search (9)
demand_dtl2monitor	MTM	monitor	monitor2demand_dtl	Reserved; obsolete		mtm_demand_dtl14_ monitor10
detail2onsite_log	OTM	onsite_log	detail_onsite2demand_dtl	Part request expenditure logs
fulfill_dtl2part_inst	OTM	part_inst	fulfill2demand_dtl	Part_inst used to fulfill the demand. Can be more than one for quantity-tracked parts. Reserved; obsolete. Replaced by fulflld_dtl2part_inst
recd_dtl2part_inst	MTM	part_inst	recd2demand_dtl	Part requests which have received the part instance		mtm_demand_dtl31_ part_inst11
pickd_dtl2part_inst	MTM	part_inst	pickd2demand_dtl	Part requests which have picked (saved) the instance. Note: this relation holds only until the demand_dtl has been fulfilled, at which time it is nulled		mtm_demand_dtl32_ part_inst12
fulflld_dtl2part_inst	MTM	part_inst	fulflld2demand_dtl	Part requests which have been fulfilled by the part instance		mtm_demand_dtl33_ part_inst13
demand_dtl2part_inst	MTO	part_inst	part_inst2demand_dtl	Part instance received against the part request. Replaced by recd_dtl2part_inst for all operations except for ECO upgrades, which sets this relation to the upgraded part_inst
demand_dtl2pick_part	MTO	part_inst	pick_part2demand_dtl	Related picked part. Reserved; obsolete. Replaced by pickd_dtl2part_inst
demand_dtl2part_trans	OTM	part_trans	part_trans2demand_dtl	Related fulfill parts transactions. These are the fulfill part_trans
rem_dtl2part_trans	OTM	part_trans	rem_trans2demand_dtl	Part transactions related to a remove part action
remove_dtl2part_trans	OTOP	part_trans	remove_trans2demand_dtl	Reserved; obsolete. Replaced by rem_dtl2part_trans
install_dtl2part_trans	OTM	part_trans	install_trans2demand_dtl	Install part transactions related to the part request detail
demand_dtl2part_used	OTM	part_used	part_used2demand_dtl	Part used action staged against the part request. Removed once the inventory has been updated
demand_dtl_prvq2queue	MTO	queue	prevq2demand_dtl	Used to record which queue demand_dtl was accepted from; for temporary accept
demand_dtl_curq2queue	MTO	queue	currq2demand_dtl	Queue to which the part request detail object is currently dispatched			Search (2)
demand_dtl2reject_msg	OTM	reject_msg	reject_msg2demand_dtl	Reason that part request was rejected from the queue to which it was dispatched
demand_dtl2retrn_info	OTOP	retrn_info	retrn_info2demand_dtl	Reserved; future
orig_dtl2rpr_inst_qty	OTM	rpr_inst_qty	orig_qty2demand_dtl	As is repair BOMs originated from the part request
demand_dtl2scr_run	OTM	scr_run	scr_run2demand_dtl	Script runs initiated by the part request
demand_dtl2ship_dtl	OTM	ship_dtl	ship_dtl2demand_dtl	Parts shipped for this demand detail
demand_dtl2shipper	MTM	ship_parts	shipper2demand_dtl	Shipments of the part request		mtm_demand_dtl24_ ship_parts4
demand_dtl2ship_parts	OTM	ship_parts	shipment2demand_dtl	Reserved; not used
demand_dtl2site_part	MTO	site_part	sitprt2demand_dtl	The installed part related to the request
demand_dtl2status_chg	OTM	status_chg	status_chg2demand_dtl	Status change events for the part request detail object
demand_dtl2tag	MTM	tag	tag2demand_dtl		USER_DEFINED	mtm_demand_dtl38_ tag4
demand_dtl_orig2user	MTO	user	originator2demand_dtl	User that originated the part request detail object
demand_dtl_owner2user	MTO	user	curr_owner2demand_dtl	User that owns the part request detail object			Search (5)
demand_dtl_wip2wipbin	MTO	wipbin	wipbin2demand_dtl	WIPbin where the part request detail object currently resides			Search (2)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ddo2u0049	demand_dtl_owner2user	nonclustered located on PRIMARY
dq2q0049	demand_dtl_curq2queue, objid	nonclustered, unique located on PRIMARY
dw2w0049	demand_dtl_wip2wipbin, objid	nonclustered, unique located on PRIMARY
ind_demand_dtl2condition	demand_dtl2condition	nonclustered located on PRIMARY
ind_demand_dtl2demand_hdr	demand_dtl2demand_hdr	nonclustered located on PRIMARY
ind_demand_dtl2inv_bin	demand_dtl2inv_bin	nonclustered located on PRIMARY
ind_demand_dtl2part_info	demand_dtl2part_info	nonclustered located on PRIMARY
ind_demand_dtl2site_part	demand_dtl2site_part	nonclustered located on PRIMARY
ind_dmnd_dtl_sts2gbst_elm	dmnd_dtl_sts2gbst_elm	nonclustered located on PRIMARY
ind_dtl_demand_dtl2pick_part	demand_dtl2pick_part	nonclustered located on PRIMARY
ind_dtl_remove_dtl2part_trans	remove_dtl2part_trans	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
3	ship_sum	condition, demand_dtl, gbst_elm, ship_dtl, ship_parts, site
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
58	wipelm_dtl	condition, demand_dtl, gbst_elm, mod_level, part_num, user, wipbin
61	queelm_dtl	condition, demand_dtl, gbst_elm, mod_level, part_num, queue, user
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
262	dem_part_v	demand_dtl, mod_level, part_num
355	dtl_alst	act_entry, demand_dtl, gbst_elm, user
381	wip_element	case, condition, demand_dtl, gbst_elm, mod_level, part_num, wipbin
382	que_element	case, condition, demand_dtl, gbst_elm, mod_level, part_num, queue
4666	tagged_part_requests	condition, demand_dtl, tag, user
5172	list_drtime	demand_dtl, onsite_log, time_log
5173	list_drmatl	demand_dtl, mod_level, mtl_log, onsite_log, part_num
5194	demand_site	demand_dtl, demand_hdr, gbst_elm, mod_level, part_num, site
5217	ccc_rundsply	bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5332	req_demand	condition, demand_dtl, demand_hdr, gbst_elm, mod_level, user
6025	wipelm_demanddtl	condition, demand_dtl, gbst_elm, wipbin
6026	queueelm_demanddtl	condition, demand_dtl, gbst_elm, queue

My Recent Objects

demand_dtl

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