Table Name:	mtl_log
Table Number:	5029
Group:	Workflow Mgr
Description:	Used by ClearLogistics Depot Repair to capture material consumed in the repair, removed from the repair unit, or to reference an item in order to capture failure or repair notes
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_mtl_log

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bill_to	CHAR	varchar		40			Organization, department, group to which the line item is to be billed. This is a user-defined popup with default name BILL_TO_MATERIAL	Search (1)
billable	LONG	int				DIRECT	Indicates whether the line item is considered billable; i.e., 0=non-billable, 1=billable	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
disposition	LONG	smallint			0	DIRECT	Repair part's disposition; i.e., 0=Used in the repair, 1=Removed in the repair, 2=Referenced but not used or removed in the repair. Default=0	Search (1)
failure_code	CHAR	varchar		40			Code describing the failure. This is a user-defined popup with default name FAILURE_CODE	Search (1)
notes	CHAR	varchar		255			Notes about the part replacement	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
ref_designator	CHAR	varchar		20			Where the replacement part was put in the item being repaired	Search (1)
removed	LONG	int			0	DIRECT	Indicates the logical removal of the log object; i.e., 0=present, 1=removed, default=0. Reserved; future
repair_code	CHAR	varchar		40			Code describing the repair executed. This is a user-defined popup with default nmae REPAIR_TYPE	Search (1)
standard_cost	DECIMAL	decimal (19,4)				CURRENCY	Standard cost of the material part used in the repair	Search (1)
transaction_id	CHAR	varchar	2	20			Reference part_trans.transaction_id. This is the transaction used for the transacted part	Search (1)
wrk_center	CHAR	varchar		40			Work Center where time activity took place	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
mtl_log2mod_level	MTO	mod_level	mod_level2mtl_log	Version of the repair part used			Search (1)
mtl_log2onsite_log	MTO	onsite_log	onsite_log2mtl_log	Related summary information			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_mtl_log2mod_level	mtl_log2mod_level, mtl_log2onsite_log	nonclustered located on PRIMARY
ind_mtl_log2onsite_log	mtl_log2onsite_log, mtl_log2mod_level	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5173	list_drmatl	demand_dtl, mod_level, mtl_log, onsite_log, part_num

My Recent Objects

mtl_log

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user