Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WC010714
Product: Manufacturing (346)
Series:
Display Name: WC Operation Codes Group Display Name: Manufacturing Work Centers
Physical Name: WC010714
Technical Name: WC_Operations
Group Technical Name: Manufacturing WC
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | WCID_I | WC ID | String | STR10_Location_Code | 10 | |
2 | OPCODE_I | Opcode | String | STR6 | 6 | |
3 | OPDESC_I | Opdesc | String | STR_30 | 30 | |
4 | SETUPTIME_I | SetupTime | Currency | hr | 10 | |
5 | MOVETIME_I | MoveTime | Currency | hr | 10 | |
6 | MACHINETIME_I | MachineTime | Currency | hr | 10 | |
7 | CYCLETIME_I | CycleTime | Currency | hr | 10 | |
8 | LABORTIME_I | LaborTime | Currency | hr | 10 | |
9 | QUEUETIME_I | QueueTime | Currency | hr | 10 | |
10 | LABORCODE_I | Labor Code | String | STR10 | 10 | |
11 | LABORCODE2_I | Labor Code2 | String | STR10 | 10 | |
12 | MACHINEID_I | Machine ID IC | String | STR10_Location_Code | 10 | |
13 | DWGNUM_I | DWG # | String | STR30_Item_Number | 30 | |
14 | TAPENUMBER_I | Tape Number | String | STR15_LBAU | 15 | |
15 | TOOLID_I | toolid | String | STR15 | 15 | |
16 | NUMOFEMP | Number of Employees | Integer | INT5_U0 | 5 | |
17 | MULTIPLEEMPLOYEEOP_I | Multiple Employee Operation | Boolean | CB | 0 | |
18 | LASTSEQUENCETODAY_I | LastSequenceToday | Boolean | CB | 0 | |
19 | USERDEF1 | User Defined 1 | String | STR20 | 20 | |
20 | USERDEF2 | User Defined 2 | String | STR20 | 20 | |
21 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
22 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['WC Operation Codes'].USERID AS 'WC Operation Codes-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WC010714 AS ['WC Operation Codes']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['WC Operation Codes'].USERID = ['Users Master'].USERID | ||||||
23 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
24 | AUTOBACKFLUSHLABOR_I | Auto Backflush Labor | Boolean | CB_Auto_Backflush_Labor | 0 | |
25 | AUTOBACKMACHINE_I | Auto Backflush Machine | Boolean | CB_Auto_Backflush_Machine | 0 |