BOM_Mass_Changes_WORK (BMMU0001)

azurecurve Products Manufacturing (346)3rd PartyBOM_Mass_Changes_WORK (BMMU0001)

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

Display Name: BOM_Mass_Changes_WORK
Physical Name: BMMU0001
Technical Name: BOM_Mass_Changes_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['BOM_Mass_Changes_WORK'].USERID AS 'BOM_Mass_Changes_WORK-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM BMMU0001 AS ['BOM_Mass_Changes_WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['BOM_Mass_Changes_WORK'].USERID = ['Users Master'].USERID
2	PPN_I	PPN	String	STR30_UC	30
3	CPN_I	CPN	String	STR30_Item_Number	30
4	BOMCAT_I	BOM Cat	Integer	DDL_BOM_Cat	0
5	BOMNAME_I	BOM Name	String	STR15_LBU	15
6	BOMSEQ_I	BOM Seq	Long Integer	LINT_10	10
7	POSITION_NUMBER	Position Number	Integer	INT4_RB_U0	4
8	REVISIONLEVEL_I	Revision Level	String	STR50	50
9	CB_I	CB	Boolean	CB	0
10	OLDITMNM	Old Item Number	String	STR30_Item_Number	30
11	BOMTYPE_I	BOM Type	Integer	DDL_BOM_Type	0
12	SUBCAT_I	Sub Cat	Integer	DDL_BOM_Cat	0
13	SUBNAME_I	Sub Name	String	STR15_LBU	15
14	QUANTITY_I	Quantity	Currency	DLR12_RBN_UT2	12
15	OPTPERCENT_I	OPT Percent	Long Integer	INTXXX.X%	4
16	SCRAPPERCENT_I	Scrap Percent	Long Integer	INTXXX.X%	4
17	FLOORSTOCK_I	Floor Stock	Boolean	CB	0
18	EFFECTIVEINDATE_I	Effective In Date	Date	DT	8
19	EFFECTIVEOUTDATE_I	Effective Out Date	Date	DT	8
20	ALTERNATE_I	Alternate	Boolean	CB	0
21	ALTERNATEPARTFOR_I	Alternate Part For	String	STR30_Item_Number	30
22	ALT_FOR_BOM_SEQ_I	Alt For BOM Seq	Long Integer	LINT_10	10
23	LEADTIMEOFFSET_I	Lead Time Offset	Currency	DLR_10_3	18
24	LEADTIMEOFFSETINC_I	Lead Time Offset Inc	Integer	DDL_Increment	0
25	BOMUSERDEF1_I	BOM User Def1	String	STR30	30
26	BOMUSERDEF2_I	BOM User Def2	String	STR_30	30
27	BOMSINGLELOT_I	BOM_Single_Lot	Boolean	CB	0
28	BOMENGAPPROVAL_I	BOM_Eng_Approval	Boolean	CB	0
29	WCID_I	WC ID	String	STR10_Location_Code	10
30	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['BOM_Mass_Changes_WORK'].LOCNCODE AS 'BOM_Mass_Changes_WORK-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM BMMU0001 AS ['BOM_Mass_Changes_WORK'] INNER JOIN IV40700 AS ['Site Setup'] ON ['BOM_Mass_Changes_WORK'].LOCNCODE = ['Site Setup'].LOCNCODE
31	BACKFLUSHITEM_I	Backflush Item	Boolean	CB_Backflush Item	0
32	CHANGEDATE_I	Change Date	Date	DT	8
33	CHANGEBY_I	Change By	String	STR15_User_ID	15
34	OPTIONED_ITEM_I	Optioned Item	Boolean	CB	0
35	ACTUAL_CONSUMED_CHECK_I	Actual Consumed Check	Boolean	CB	0
36	FIXED_QTY_I	Fixed Quantity	Currency	DLR17_QTY_RBS0_UTR	17
37	UOFM	U Of M	String	U_Of_M	8
38	U_Of_M_2	U Of M 2	String	U_Of_M	8
39	QTYBSUOM	QTY In Base U Of M	Currency	DLR17_QTY_RBS0_STR	17
40	OFFSET_FROM_I	Offset From	Integer	DDL_Offset_From	0
41	MFGNOTEINDEX_I	MFG Note Index	Currency	DLR14	14
42	MFGNOTEINDEX2_I	MFG Note Index2	Currency	DLR14	14
43	REVISION_LEVEL_CHANGED_I	Revision Level Changed	Boolean	Boolean	0
44	ROUTINGLINK_I	Routing Link	Boolean	Boolean	0
45	ALTERNATEUSED_I	Alternate Used	Boolean	Boolean	0
46	ALTERNATE_ACTION_I	Alternate Action	Integer	INT	0
47	ROUTING_LINK_DISSOLVED_I	Routing Link Dissolved	Boolean	boolean	0
48	MFGNOTEINDEX3_I	MFG Note Index3	Currency	DLR14	14

azurecurve Products Manufacturing (346)3rd PartyBOM_Mass_Changes_WORK (BMMU0001)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply