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 | |