Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MM010032
Product: Manufacturing (346)
Series:
Display Name: Machine Master Group Display Name: Manufacturing Work Centers
Physical Name: MM010032
Technical Name: Machine_MSTR
Group Technical Name: Manufacturing WC
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | MACHINEID_I | Machine ID IC | String | STR10_Location_Code | 10 | |
2 | MACHINEDESC_I | Machine Desc | String | STR30 | 30 | |
3 | SERLNMBR | Serial Number | String | STR20_LBAU | 20 | |
4 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['Machine Master '].VENDORID AS 'Machine Master -Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
MM010032 AS ['Machine Master ']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Machine Master '].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
5 | DATEMACHINEINSTALL_I | Date, Machine Installation | Date | DT6 | 6 | |
6 | YEAR1 | Year | Integer | Year | 4 | |
7 | WARRANTY_I | Warranty | Boolean | CB_Available_Warranty | 0 | |
8 | WARRANTYTIME_I | Warranty Time | String | STR8 | 8 | |
9 | LENGTHOFWARRANTY_I | Length of Warranty | Integer | INT4 | 4 | |
10 | DEPRECIATIONCOST_I | Depreciation Cost | Currency | DLR14_Salary | 14 | |
11 | DEPRECIATIONCOSTUN_I | Depreciation Cost Unit | Integer | DDL_Depreciation_Cost_Unit | 0 | |
12 | LOCATNID | Location ID | String | STR15_Location_ID | 15 | |
13 | MAINTENANCEDATE_I | Maintenance Date | Date | DT | 8 | |
14 | Maintenance_Procedure_Na | Maintenance Procedure Name | String | STR20_Procedure_Name | 20 | |
15 | OPERATIONCOUNT_I | Operation Count | Long Integer | LINT_10 | 10 | |
16 | TOTALOPERATIONCOUN_I | Total Operation Count | Long Integer | LINT_10 | 10 | |
17 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
18 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Machine Master '].USERID AS 'Machine Master -User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MM010032 AS ['Machine Master ']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Machine Master '].USERID = ['Users Master'].USERID | ||||||
19 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
20 | MFGNOTEINDEX2_I | MFG Note Index2 | Currency | DLR14 | 14 | |
21 | Mach_Mach_Applied_Acct | Mach Mach Applied Account | Long Integer | LI_14 | 14 | |
22 | Mach_Fixed_Ohd_Acct | Mach Fixed Overhead Account | Long Integer | LI_14 | 14 | |
23 | Mach_Variable_Ohd_Acct | Mach Variable Overhead Account | Long Integer | LI_14 | 14 | |
24 | COST_I | Cost | Currency | DLR17_RBSO_UTR$ | 17 | |
25 | EFFECTIVEDATE_I | Effective Date0 | Date | DT | 8 | |
26 | COSTPERPIECE_I | Cost Per Piece | Currency | DLR17_RBSO_UTR$ | 17 | |
27 | EFFECTIVEDATE2_I | Effective Date2 | Date | DT | 8 | |
28 | FIXAMTORPCT_I | Fixed Amount or Percent | Integer | GB | 0 | |
29 | Fixed_Overhead_Amount | Fixed Overhead Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
30 | FIXOHDPCT_I | Fixed Overhead Percent | Long Integer | INTXXX.XXXXX% | 8 | |
31 | FIXHRPC_I | Fixed Hour Piece | Integer | DDL_Hour_Piece | 0 | |
32 | FIXOHDEFFDATE_I | Fixed Overhead Effective Date | Date | DT | 8 | |
33 | VARAMTORPCT_I | Variable Amount or Percent | Integer | GB | 0 | |
34 | Variable_Overhead_Amount | Variable Overhead Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
35 | VAROHDPCT_I | Variable Overhead Percent | Long Integer | INTXXX.XXXXX% | 8 | |
36 | VARHRPC_I | Variable Hour Piece | Integer | DDL_Hour_Piece | 0 | |
37 | VAROHDEFFDATE_I | Variable Overhead Effective Date | Date | DT | 8 | |
38 | PENDINGCOST_I | Pending Cost | Currency | DLR17_RBSO_UTR$ | 17 | |
39 | PENDEFFDATE_I | Pending Effective Date | Date | DT | 8 | |
40 | PENDCOSTPERPIECE_I | Pending Cost Per Piece | Currency | DLR17_RBSO_UTR$ | 17 | |
41 | PENDEFFDATE2_I | Pending Effective Date2 | Date | DT | 8 | |
42 | PENDFIXAMTORPCT_I | Pending Fixed Amount or Percent | Integer | GB | 0 | |
43 | PENDFIXOHDAMT_I | Pending Fixed Overhead Amount | Currency | DLR17_RBSO_UTR$ | 17 | |
44 | PENDFIXOHDPCT_I | Pending Fixed Overhead Percent | Long Integer | INTXXX.XXXXX% | 8 | |
45 | PENDFIXHRPC_I | Pending Fixed Hour Piece | Integer | DDL_Hour_Piece | 0 | |
46 | PENDFIXOHDEFFDATE_I | Pending Fixed Overhead Effective Date | Date | DT | 8 | |
47 | PENDVARAMTORPCT_I | Pending Variable Amount or Percent | Integer | GB | 0 | |
48 | PENDVAROHDAMT_I | Pending Variable Overhead Amount | Currency | DLR17_RBSO_UTR$ | 17 | |
49 | PENDVAROHDPCT_I | Pending Variable Overhead Percent | Long Integer | INTXXX.XXXXX% | 8 | |
50 | PENDVARHRPC_I | Pending Variable Hour Piece | Integer | DDL_Hour_Piece | 0 | |
51 | PENDVAROHDEFFDATE_I | Pending Variable Overhead Effective Date | Date | DT | 8 |