Machine Master (MM010032)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: Machine Master
Physical Name: MM010032
Technical Name: Machine_MSTR

Group Display Name: Manufacturing Work Centers
Group Technical Name: Manufacturing WC

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MACHINEID_I SearchMachine ID ICSTR10_Location_CodeString10
2MACHINEDESC_I SearchMachine DescSTR30String30
3SERLNMBR SearchSerial NumberSTR20_LBAUString20
4VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['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
5DATEMACHINEINSTALL_I SearchDate, Machine InstallationDT6Date6
6YEAR1 SearchYearYearInteger4
7WARRANTY_I SearchWarrantyCB_Available_WarrantyBoolean0
8WARRANTYTIME_I SearchWarranty TimeSTR8String8
9LENGTHOFWARRANTY_I SearchLength of WarrantyINT4Integer4
10DEPRECIATIONCOST_I SearchDepreciation CostDLR14_SalaryCurrency14
11DEPRECIATIONCOSTUN_I SearchDepreciation Cost UnitDDL_Depreciation_Cost_UnitInteger0
12LOCATNID SearchLocation IDSTR15_Location_IDString15
13MAINTENANCEDATE_I SearchMaintenance DateDTDate8
14Maintenance_Procedure_Na SearchMaintenance Procedure NameSTR20_Procedure_NameString20
15OPERATIONCOUNT_I SearchOperation CountLINT_10Long Integer10
16TOTALOPERATIONCOUN_I SearchTotal Operation CountLINT_10Long Integer10
17CHANGEDATE_I SearchChange DateDTDate8
18USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['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
19MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency14
20MFGNOTEINDEX2_I SearchMFG Note Index2DLR14Currency14
21Mach_Mach_Applied_Acct SearchMach Mach Applied AccountLI_14Long Integer14
22Mach_Fixed_Ohd_Acct SearchMach Fixed Overhead AccountLI_14Long Integer14
23Mach_Variable_Ohd_Acct SearchMach Variable Overhead AccountLI_14Long Integer14
24COST_I SearchCostDLR17_RBSO_UTR$Currency17
25EFFECTIVEDATE_I SearchEffective Date0DTDate8
26COSTPERPIECE_I SearchCost Per PieceDLR17_RBSO_UTR$Currency17
27EFFECTIVEDATE2_I SearchEffective Date2DTDate8
28FIXAMTORPCT_I SearchFixed Amount or PercentGBInteger0
29Fixed_Overhead_Amount SearchFixed Overhead AmountDLR17_RBS0_UTR$Currency17
30FIXOHDPCT_I SearchFixed Overhead PercentINTXXX.XXXXX%Long Integer8
31FIXHRPC_I SearchFixed Hour PieceDDL_Hour_PieceInteger0
32FIXOHDEFFDATE_I SearchFixed Overhead Effective DateDTDate8
33VARAMTORPCT_I SearchVariable Amount or PercentGBInteger0
34Variable_Overhead_Amount SearchVariable Overhead AmountDLR17_RBS0_UTR$Currency17
35VAROHDPCT_I SearchVariable Overhead PercentINTXXX.XXXXX%Long Integer8
36VARHRPC_I SearchVariable Hour PieceDDL_Hour_PieceInteger0
37VAROHDEFFDATE_I SearchVariable Overhead Effective DateDTDate8
38PENDINGCOST_I SearchPending CostDLR17_RBSO_UTR$Currency17
39PENDEFFDATE_I SearchPending Effective DateDTDate8
40PENDCOSTPERPIECE_I SearchPending Cost Per PieceDLR17_RBSO_UTR$Currency17
41PENDEFFDATE2_I SearchPending Effective Date2DTDate8
42PENDFIXAMTORPCT_I SearchPending Fixed Amount or PercentGBInteger0
43PENDFIXOHDAMT_I SearchPending Fixed Overhead AmountDLR17_RBSO_UTR$Currency17
44PENDFIXOHDPCT_I SearchPending Fixed Overhead PercentINTXXX.XXXXX%Long Integer8
45PENDFIXHRPC_I SearchPending Fixed Hour PieceDDL_Hour_PieceInteger0
46PENDFIXOHDEFFDATE_I SearchPending Fixed Overhead Effective DateDTDate8
47PENDVARAMTORPCT_I SearchPending Variable Amount or PercentGBInteger0
48PENDVAROHDAMT_I SearchPending Variable Overhead AmountDLR17_RBSO_UTR$Currency17
49PENDVAROHDPCT_I SearchPending Variable Overhead PercentINTXXX.XXXXX%Long Integer8
50PENDVARHRPC_I SearchPending Variable Hour PieceDDL_Hour_PieceInteger0
51PENDVAROHDEFFDATE_I SearchPending Variable Overhead Effective DateDTDate8
52DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *