Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WO010701
Product: Manufacturing (346)
Series:
Display Name: Manufacture Order Closing File Group Display Name: Manufacturing MOP
Physical Name: WO010701
Technical Name: MOP_Close
Group Technical Name: Manufacturing MOP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | MANUFACTUREORDER_I ![]() | Manufacture Order | String | STR30_UC | 30 | |
2 | ACTUALEMPHOURSSUM_I ![]() | Actual Employee Hours Sum | Currency | hr | 10 | |
3 | ACTUALMACHRSSUM_I ![]() | Actual Machine Hours Sum | Currency | hr | 10 | |
4 | ITEM_COSTS_ARRAY_I_1 ![]() | Item Costs Array[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
5 | ITEM_COSTS_ARRAY_I ![]() | Item Costs Array | DLR17_RBS0_UTR$ | Currency | 17 | |
6 | ITEM_COSTS_ARRAY_I_2 ![]() | Item Costs Array[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
7 | ITEM_COSTS_ARRAY_I_3 ![]() | Item Costs Array[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
8 | ITEM_COSTS_ARRAY_I_4 ![]() | Item Costs Array[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
9 | ITEM_COSTS_ARRAY_I_5 ![]() | Item Costs Array[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
10 | ITEM_COSTS_ARRAY_I_6 ![]() | Item Costs Array[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
11 | ITEM_COSTS_ARRAY_I_7 ![]() | Item Costs Array[7] | Currency | DLR17_RBS0_UTR$ | 17 | |
12 | ITEM_COSTS_ARRAY_I_8 ![]() | Item Costs Array[8] | Currency | DLR17_RBS0_UTR$ | 17 | |
13 | ITEM_COSTS_ARRAY_I_9 ![]() | Item Costs Array[9] | Currency | DLR17_RBS0_UTR$ | 17 | |
14 | ITEM_COSTS_ARRAY_I_10 ![]() | Item Costs Array[10] | Currency | DLR17_RBS0_UTR$ | 17 | |
15 | USERID ![]() | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Manufacture Order Closing File'].USERID AS 'Manufacture Order Closing File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WO010701 AS ['Manufacture Order Closing File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Manufacture Order Closing File'].USERID = ['Users Master'].USERID | ||||||
16 | CHANGEDATE_I ![]() | Change Date | Date | DT | 8 |