Bill Of Materials Log File (BM010300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BM010300

Display Name: Bill Of Materials Log File
Physical Name: BM010300
Technical Name: BOM_Log

Group Display Name: Manufacturing BOM
Group Technical Name: Manufacturing BOM

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PPN_I	PPN	String	STR30_UC	30
2	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Bill Of Materials Log File'].ITEMNMBR AS 'Bill Of Materials Log File-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM BM010300 AS ['Bill Of Materials Log File'] INNER JOIN IV00101 AS ['Item Master'] ON ['Bill Of Materials Log File'].ITEMNMBR = ['Item Master'].ITEMNMBR
3	CHANGENUMBER_I	Change Number	Integer	INT5	4
4	DESCRIPTIN50	IC_Description	String	STR50	50
5	UNIT_I	Unit	String	STR10_U	10
6	ADDCHG_I	Add Chg	String	STR15	15
7	DATE1	Date	Date	DT6	6
8	TIME1	Time	Time	TM6	6
9	QUANTITY_I	Quantity	Currency	DLR12_RBN_UT2	12
10	OPTPERCENT_I	OPT Percent	Long Integer	INTXXX.X%	4
11	SCRAPPERCENT_I	Scrap Percent	Long Integer	INTXXX.X%	4
12	ALTERNATE_I	Alternate	Boolean	CB	0
13	ALTERNATEPARTFOR_I	Alternate Part For	String	STR30_Item_Number	30
14	LEADTIMEOFFSET_I	Lead Time Offset	Currency	DLR_10_3	18
15	BOMUSERDEF1_I	BOM User Def1	String	STR30	30
16	BOMUSERDEF2_I	BOM User Def2	String	STR_30	30
17	BOMSINGLELOT_I	BOM_Single_Lot	Boolean	CB	0
18	BOMENGAPPROVAL_I	BOM_Eng_Approval	Boolean	CB	0
19	WCID_I	WC ID	String	STR10_Location_Code	10