MOP_MO_Variance_Material_Hist (MOP1004)

azurecurve Products Manufacturing (346)3rd PartyMOP_MO_Variance_Material_Hist (MOP1004)

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

Display Name: MOP_MO_Variance_Material_Hist
Physical Name: MOP1004
Technical Name: MOP_MO_Variance_Material_Hist

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	MANUFACTUREORDER_I	Manufacture Order	String	STR30_UC	30
2	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['MOP_MO_Variance_Material_Hist'].ITEMNMBR AS 'MOP_MO_Variance_Material_Hist-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM MOP1004 AS ['MOP_MO_Variance_Material_Hist'] INNER JOIN IV00101 AS ['Item Master'] ON ['MOP_MO_Variance_Material_Hist'].ITEMNMBR = ['Item Master'].ITEMNMBR
3	ITEMDESC	Item Description	String	STR100	100
4	MRPAMOUNT_I	MRP_Amount	Currency	DLR_14_MRP	14
5	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
6	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
7	MRPAMOUNT2_I	MRP_Amount2	Currency	DLR_14_MRP	14
8	ORIGQTYALLOW	Original QTY Allowed	Currency	DLR_14_MRP	14
9	QTYRECVD	QTY Received	Currency	DLR17_QTY_RBS0_UTR	17
10	QTY_ISSUED_I	QTY Issued	Currency	DLR17_QTY_RBS0_UTR	17
11	QTYCONSUMED	QTY Consumed	Currency	DLR17_QTY_RBS0_UTR	17
12	VARPRODMOCOSTS_1	varProdMOCosts[1]	Currency	DLR17_QTY_RBS0_STR	17
13	VARPRODMOCOSTS	varProdMOCosts	DLR17_QTY_RBS0_STR	Currency	17
14	VARPRODRECDCOSTS	varProdRecdCosts	DLR17_QTY_RBS0_STR	Currency	17
15	VARPRODMOCOSTS_2	varProdMOCosts[2]	Currency	DLR17_QTY_RBS0_STR	17
16	VARCOSTSCLLCTD	varCostCollected	DLR17_QTY_RBS0_STR	Currency	17
17	VARPRODMOCOSTS_3	varProdMOCosts[3]	Currency	DLR17_QTY_RBS0_STR	17
18	VARCOSTSUSED	varCostsUsed	DLR17_QTY_RBS0_STR	Currency	17
19	VARPRODMOCOSTS_4	varProdMOCosts[4]	Currency	DLR17_QTY_RBS0_STR	17
20	VARSTDCOSTS1	varStandCosts1	DLR17_QTY_RBS0_STR	Currency	17
21	VARPRODMOCOSTS_5	varProdMOCosts[5]	Currency	DLR17_QTY_RBS0_STR	17
22	VARPRODMOCOSTS_6	varProdMOCosts[6]	Currency	DLR17_QTY_RBS0_STR	17
23	VARSTDCOSTS2	varStandCosts2	DLR17_QTY_RBS0_STR	Currency	17
24	VARPRODMOCOSTS_7	varProdMOCosts[7]	Currency	DLR17_QTY_RBS0_STR	17
25	VARPRODMOCOSTS_8	varProdMOCosts[8]	Currency	DLR17_QTY_RBS0_STR	17
26	VARPRODMOCOSTS_9	varProdMOCosts[9]	Currency	DLR17_QTY_RBS0_STR	17
27	VARPRODMOCOSTS_10	varProdMOCosts[10]	Currency	DLR17_QTY_RBS0_STR	17
28	VARPRODMOCOSTS_11	varProdMOCosts[11]	Currency	DLR17_QTY_RBS0_STR	17
29	VARPRODMOCOSTS_12	varProdMOCosts[12]	Currency	DLR17_QTY_RBS0_STR	17
30	VARPRODMOCOSTS_13	varProdMOCosts[13]	Currency	DLR17_QTY_RBS0_STR	17
31	VARPRODRECDCOSTS_1	varProdRecdCosts[1]	Currency	DLR17_QTY_RBS0_STR	17
32	VARPRODRECDCOSTS_2	varProdRecdCosts[2]	Currency	DLR17_QTY_RBS0_STR	17
33	VARPRODRECDCOSTS_3	varProdRecdCosts[3]	Currency	DLR17_QTY_RBS0_STR	17
34	VARPRODRECDCOSTS_4	varProdRecdCosts[4]	Currency	DLR17_QTY_RBS0_STR	17
35	VARPRODRECDCOSTS_5	varProdRecdCosts[5]	Currency	DLR17_QTY_RBS0_STR	17
36	VARPRODRECDCOSTS_6	varProdRecdCosts[6]	Currency	DLR17_QTY_RBS0_STR	17
37	VARPRODRECDCOSTS_7	varProdRecdCosts[7]	Currency	DLR17_QTY_RBS0_STR	17
38	VARPRODRECDCOSTS_8	varProdRecdCosts[8]	Currency	DLR17_QTY_RBS0_STR	17
39	VARPRODRECDCOSTS_9	varProdRecdCosts[9]	Currency	DLR17_QTY_RBS0_STR	17
40	VARPRODRECDCOSTS_10	varProdRecdCosts[10]	Currency	DLR17_QTY_RBS0_STR	17
41	VARPRODRECDCOSTS_11	varProdRecdCosts[11]	Currency	DLR17_QTY_RBS0_STR	17
42	VARPRODRECDCOSTS_12	varProdRecdCosts[12]	Currency	DLR17_QTY_RBS0_STR	17
43	VARPRODRECDCOSTS_13	varProdRecdCosts[13]	Currency	DLR17_QTY_RBS0_STR	17
44	VARCOSTSCLLCTD_1	varCostCollected[1]	Currency	DLR17_QTY_RBS0_STR	17
45	VARCOSTSCLLCTD_2	varCostCollected[2]	Currency	DLR17_QTY_RBS0_STR	17
46	VARCOSTSCLLCTD_3	varCostCollected[3]	Currency	DLR17_QTY_RBS0_STR	17
47	VARCOSTSCLLCTD_4	varCostCollected[4]	Currency	DLR17_QTY_RBS0_STR	17
48	VARCOSTSCLLCTD_5	varCostCollected[5]	Currency	DLR17_QTY_RBS0_STR	17
49	VARCOSTSCLLCTD_6	varCostCollected[6]	Currency	DLR17_QTY_RBS0_STR	17
50	VARCOSTSCLLCTD_7	varCostCollected[7]	Currency	DLR17_QTY_RBS0_STR	17
51	VARCOSTSCLLCTD_8	varCostCollected[8]	Currency	DLR17_QTY_RBS0_STR	17
52	VARCOSTSCLLCTD_9	varCostCollected[9]	Currency	DLR17_QTY_RBS0_STR	17
53	VARCOSTSCLLCTD_10	varCostCollected[10]	Currency	DLR17_QTY_RBS0_STR	17
54	VARCOSTSCLLCTD_11	varCostCollected[11]	Currency	DLR17_QTY_RBS0_STR	17
55	VARCOSTSCLLCTD_12	varCostCollected[12]	Currency	DLR17_QTY_RBS0_STR	17
56	VARCOSTSCLLCTD_13	varCostCollected[13]	Currency	DLR17_QTY_RBS0_STR	17
57	VARCOSTSUSED_1	varCostsUsed[1]	Currency	DLR17_QTY_RBS0_STR	17
58	VARCOSTSUSED_2	varCostsUsed[2]	Currency	DLR17_QTY_RBS0_STR	17
59	VARCOSTSUSED_3	varCostsUsed[3]	Currency	DLR17_QTY_RBS0_STR	17
60	VARCOSTSUSED_4	varCostsUsed[4]	Currency	DLR17_QTY_RBS0_STR	17
61	VARCOSTSUSED_5	varCostsUsed[5]	Currency	DLR17_QTY_RBS0_STR	17
62	VARCOSTSUSED_6	varCostsUsed[6]	Currency	DLR17_QTY_RBS0_STR	17
63	VARCOSTSUSED_7	varCostsUsed[7]	Currency	DLR17_QTY_RBS0_STR	17
64	VARCOSTSUSED_8	varCostsUsed[8]	Currency	DLR17_QTY_RBS0_STR	17
65	VARCOSTSUSED_9	varCostsUsed[9]	Currency	DLR17_QTY_RBS0_STR	17
66	VARCOSTSUSED_10	varCostsUsed[10]	Currency	DLR17_QTY_RBS0_STR	17
67	VARCOSTSUSED_11	varCostsUsed[11]	Currency	DLR17_QTY_RBS0_STR	17
68	VARCOSTSUSED_12	varCostsUsed[12]	Currency	DLR17_QTY_RBS0_STR	17
69	VARCOSTSUSED_13	varCostsUsed[13]	Currency	DLR17_QTY_RBS0_STR	17
70	VARSTDCOSTS1_1	varStandCosts1[1]	Currency	DLR17_QTY_RBS0_STR	17
71	VARSTDCOSTS1_2	varStandCosts1[2]	Currency	DLR17_QTY_RBS0_STR	17
72	VARSTDCOSTS1_3	varStandCosts1[3]	Currency	DLR17_QTY_RBS0_STR	17
73	VARSTDCOSTS1_4	varStandCosts1[4]	Currency	DLR17_QTY_RBS0_STR	17
74	VARSTDCOSTS1_5	varStandCosts1[5]	Currency	DLR17_QTY_RBS0_STR	17
75	VARSTDCOSTS1_6	varStandCosts1[6]	Currency	DLR17_QTY_RBS0_STR	17
76	VARSTDCOSTS1_7	varStandCosts1[7]	Currency	DLR17_QTY_RBS0_STR	17
77	VARSTDCOSTS1_8	varStandCosts1[8]	Currency	DLR17_QTY_RBS0_STR	17
78	VARSTDCOSTS1_9	varStandCosts1[9]	Currency	DLR17_QTY_RBS0_STR	17
79	VARSTDCOSTS1_10	varStandCosts1[10]	Currency	DLR17_QTY_RBS0_STR	17
80	VARSTDCOSTS1_11	varStandCosts1[11]	Currency	DLR17_QTY_RBS0_STR	17
81	VARSTDCOSTS1_12	varStandCosts1[12]	Currency	DLR17_QTY_RBS0_STR	17
82	VARSTDCOSTS1_13	varStandCosts1[13]	Currency	DLR17_QTY_RBS0_STR	17
83	VARSTDCOSTS2_1	varStandCosts2[1]	Currency	DLR17_QTY_RBS0_STR	17
84	VARSTDCOSTS2_2	varStandCosts2[2]	Currency	DLR17_QTY_RBS0_STR	17
85	VARSTDCOSTS2_3	varStandCosts2[3]	Currency	DLR17_QTY_RBS0_STR	17
86	VARSTDCOSTS2_4	varStandCosts2[4]	Currency	DLR17_QTY_RBS0_STR	17
87	VARSTDCOSTS2_5	varStandCosts2[5]	Currency	DLR17_QTY_RBS0_STR	17
88	VARSTDCOSTS2_6	varStandCosts2[6]	Currency	DLR17_QTY_RBS0_STR	17
89	VARSTDCOSTS2_7	varStandCosts2[7]	Currency	DLR17_QTY_RBS0_STR	17
90	VARSTDCOSTS2_8	varStandCosts2[8]	Currency	DLR17_QTY_RBS0_STR	17
91	VARSTDCOSTS2_9	varStandCosts2[9]	Currency	DLR17_QTY_RBS0_STR	17
92	VARSTDCOSTS2_10	varStandCosts2[10]	Currency	DLR17_QTY_RBS0_STR	17
93	VARSTDCOSTS2_11	varStandCosts2[11]	Currency	DLR17_QTY_RBS0_STR	17
94	VARSTDCOSTS2_12	varStandCosts2[12]	Currency	DLR17_QTY_RBS0_STR	17
95	VARSTDCOSTS2_13	varStandCosts2[13]	Currency	DLR17_QTY_RBS0_STR	17

azurecurve Products Manufacturing (346)3rd PartyMOP_MO_Variance_Material_Hist (MOP1004)

Click to show/hide

Leave a Reply Cancel reply