MOP_Receipt_MSTR (MOP1100)

azurecurve Products Manufacturing (346)3rd PartyMOP_Receipt_MSTR (MOP1100)

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

Display Name: MOP_Receipt_MSTR
Physical Name: MOP1100
Technical Name: MOP_Receipt_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MOPRCTNM	MOP Receipt Number	String	STR20_Document_Number_Receipt	20
2	REVERSED_RECEIPT_I	Reversed_Receipt	Boolean	Boolean	0
3	REVERSIBLE_RECEIPT_I	Reversible Receipt	Boolean	Boolean	0
4	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
5	DATERECD	Date Received	Date	DATE	6
6	QTYRECVD	QTY Received	Currency	DLR17_QTY_RBS0_UTR	17
7	TO_SITE_I	To Site	String	STR10_Location_Code	10
8	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['MOP_Receipt_MSTR'].NOTEINDX AS 'MOP_Receipt_MSTR-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM MOP1100 AS ['MOP_Receipt_MSTR'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['MOP_Receipt_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
9	POSTDATE	Post Date	Date	DT_Date	6
10	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['MOP_Receipt_MSTR'].USERID AS 'MOP_Receipt_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM MOP1100 AS ['MOP_Receipt_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['MOP_Receipt_MSTR'].USERID = ['Users Master'].USERID
11	RECEIPTCOSTSARRAY	Receipt Costs Array	DLR17_RBS0_UTR$	Currency	17
12	RECEIPTCOSTSARRAY_1	Receipt Costs Array[1]	Currency	DLR17_RBS0_UTR$	17
13	RECEIPTCOSTSARRAY_2	Receipt Costs Array[2]	Currency	DLR17_RBS0_UTR$	17
14	RECEIPTCOSTSARRAY_3	Receipt Costs Array[3]	Currency	DLR17_RBS0_UTR$	17
15	RECEIPTCOSTSARRAY_4	Receipt Costs Array[4]	Currency	DLR17_RBS0_UTR$	17
16	RECEIPTCOSTSARRAY_5	Receipt Costs Array[5]	Currency	DLR17_RBS0_UTR$	17
17	SETUP_COSTS_TO_USE_I	Setup Costs To Use	DLR17_RBSO_UTR$	Currency	17
18	RECEIPTCOSTSARRAY_6	Receipt Costs Array[6]	Currency	DLR17_RBS0_UTR$	17
19	COSTS_TO_USE_I	Costs To Use	DLR17_RBS0_UTR$	Currency	17
20	RECEIPTCOSTSARRAY_7	Receipt Costs Array[7]	Currency	DLR17_RBS0_UTR$	17
21	SETUP_COSTS_TO_BACKFLUSH	Setup Costs To Backflush	DLR17_RBSO_UTR$	Currency	17
22	RECEIPTCOSTSARRAY_8	Receipt Costs Array[8]	Currency	DLR17_RBS0_UTR$	17
23	RECEIPTCOSTSARRAY_9	Receipt Costs Array[9]	Currency	DLR17_RBS0_UTR$	17
24	COSTS_TO_BACKFLUSH_I	Costs To Backflush	DLR17_RBSO_UTR$	Currency	17
25	RECEIPTCOSTSARRAY_10	Receipt Costs Array[10]	Currency	DLR17_RBS0_UTR$	17
26	LABCOSTSINDCTR	Labor Costs Indicator	Integer	GB	0
27	MACHCOSTSINDCTR	Machine Costs Indicator	Integer	GB	0
28	LABORCOSTSPCT	Labor Costs Percent	Integer	INT4_%2	4
29	MACHINECOSTSPCT	Machine Costs Percent	Integer	INT4_%2	4
30	SETUP_COSTS_TO_USE_I_1	Setup Costs To Use[1]	Currency	DLR17_RBSO_UTR$	17
31	SETUP_COSTS_TO_USE_I_2	Setup Costs To Use[2]	Currency	DLR17_RBSO_UTR$	17
32	SETUP_COSTS_TO_USE_I_3	Setup Costs To Use[3]	Currency	DLR17_RBSO_UTR$	17
33	COSTS_TO_USE_I_1	Costs To Use[1]	Currency	DLR17_RBS0_UTR$	17
34	COSTS_TO_USE_I_2	Costs To Use[2]	Currency	DLR17_RBS0_UTR$	17
35	COSTS_TO_USE_I_3	Costs To Use[3]	Currency	DLR17_RBS0_UTR$	17
36	COSTS_TO_USE_I_4	Costs To Use[4]	Currency	DLR17_RBS0_UTR$	17
37	COSTS_TO_USE_I_5	Costs To Use[5]	Currency	DLR17_RBS0_UTR$	17
38	COSTS_TO_USE_I_6	Costs To Use[6]	Currency	DLR17_RBS0_UTR$	17
39	SETUP_COSTS_TO_BACKFLUSH_1	Setup Costs To Backflush[1]	Currency	DLR17_RBSO_UTR$	17
40	SETUP_COSTS_TO_BACKFLUSH_2	Setup Costs To Backflush[2]	Currency	DLR17_RBSO_UTR$	17
41	SETUP_COSTS_TO_BACKFLUSH_3	Setup Costs To Backflush[3]	Currency	DLR17_RBSO_UTR$	17
42	COSTS_TO_BACKFLUSH_I_1	Costs To Backflush[1]	Currency	DLR17_RBSO_UTR$	17
43	COSTS_TO_BACKFLUSH_I_2	Costs To Backflush[2]	Currency	DLR17_RBSO_UTR$	17
44	COSTS_TO_BACKFLUSH_I_3	Costs To Backflush[3]	Currency	DLR17_RBSO_UTR$	17
45	COSTS_TO_BACKFLUSH_I_4	Costs To Backflush[4]	Currency	DLR17_RBSO_UTR$	17
46	COSTS_TO_BACKFLUSH_I_5	Costs To Backflush[5]	Currency	DLR17_RBSO_UTR$	17
47	COSTS_TO_BACKFLUSH_I_6	Costs To Backflush[6]	Currency	DLR17_RBSO_UTR$	17
48	POSTED	Posted	Boolean	True/False	0
49	COMPLETEMOATCOMPCLOSE	Complete MO at Complete/Close	Boolean	Boolean	0
50	CLOSEMOATCOMPCLOSE	Close MO at Complete/Close	Boolean	Boolean	0
51	JOBLINKSTATE	Job Link State	Integer	Job Link State	0

azurecurve Products Manufacturing (346)3rd PartyMOP_Receipt_MSTR (MOP1100)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply