Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1100
Product: Manufacturing (346)
Series: 3rd Party
Display Name: MOP_Receipt_MSTR 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.
Physical Name: MOP1100
Technical Name: MOP_Receipt_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MOPRCTNM 
MOP Receipt Number STR20_Document_Number_Receipt String 20 2 REVERSED_RECEIPT_I Reversed_Receipt Boolean Boolean 0 3 REVERSIBLE_RECEIPT_I Reversible Receipt Boolean Boolean 0 4 MANUFACTUREORDER_I Manufacture Order STR30_UC String 30 5 DATERECD Date Received DATE Date 6 6 QTYRECVD QTY Received DLR17_QTY_RBS0_UTR Currency 17 7 TO_SITE_I To Site STR10_Location_Code String 10 8 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['MOP_Receipt_MSTR'].NOTEINDX AS 'MOP_Receipt_MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
MOP1100 AS ['MOP_Receipt_MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['MOP_Receipt_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX9 POSTDATE Post Date DT_Date Date 6 10 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['MOP_Receipt_MSTR'].USERID AS 'MOP_Receipt_MSTR-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MOP1100 AS ['MOP_Receipt_MSTR']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MOP_Receipt_MSTR'].USERID = ['Users Master'].USERID11 RECEIPTCOSTSARRAY Receipt Costs Array DLR17_RBS0_UTR$ Currency 17 12 RECEIPTCOSTSARRAY_1 Receipt Costs Array[1] DLR17_RBS0_UTR$ Currency 17 13 RECEIPTCOSTSARRAY_2 Receipt Costs Array[2] DLR17_RBS0_UTR$ Currency 17 14 LABCOSTSINDCTR Labor Costs Indicator GB Integer 0 15 RECEIPTCOSTSARRAY_3 Receipt Costs Array[3] DLR17_RBS0_UTR$ Currency 17 16 MACHCOSTSINDCTR Machine Costs Indicator GB Integer 0 17 RECEIPTCOSTSARRAY_4 Receipt Costs Array[4] DLR17_RBS0_UTR$ Currency 17 18 LABORCOSTSPCT Labor Costs Percent INT4_%2 Integer 4 19 MACHINECOSTSPCT Machine Costs Percent INT4_%2 Integer 4 20 RECEIPTCOSTSARRAY_5 Receipt Costs Array[5] DLR17_RBS0_UTR$ Currency 17 21 RECEIPTCOSTSARRAY_6 Receipt Costs Array[6] DLR17_RBS0_UTR$ Currency 17 22 SETUP_COSTS_TO_USE_I Setup Costs To Use DLR17_RBSO_UTR$ Currency 17 23 RECEIPTCOSTSARRAY_7 Receipt Costs Array[7] DLR17_RBS0_UTR$ Currency 17 24 COSTS_TO_USE_I Costs To Use DLR17_RBS0_UTR$ Currency 17 25 RECEIPTCOSTSARRAY_8 Receipt Costs Array[8] DLR17_RBS0_UTR$ Currency 17 26 SETUP_COSTS_TO_BACKFLUSH Setup Costs To Backflush DLR17_RBSO_UTR$ Currency 17 27 RECEIPTCOSTSARRAY_9 Receipt Costs Array[9] DLR17_RBS0_UTR$ Currency 17 28 COSTS_TO_BACKFLUSH_I Costs To Backflush DLR17_RBSO_UTR$ Currency 17 29 POSTED Posted True/False Boolean 0 30 RECEIPTCOSTSARRAY_10 Receipt Costs Array[10] DLR17_RBS0_UTR$ Currency 17 31 COMPLETEMOATCOMPCLOSE Complete MO at Complete/Close Boolean Boolean 0 32 CLOSEMOATCOMPCLOSE Close MO at Complete/Close Boolean Boolean 0 33 JOBLINKSTATE Job Link State Job Link State Integer 0 34 SETUP_COSTS_TO_USE_I_1 Setup Costs To Use[1] DLR17_RBSO_UTR$ Currency 17 35 SETUP_COSTS_TO_USE_I_2 Setup Costs To Use[2] DLR17_RBSO_UTR$ Currency 17 36 SETUP_COSTS_TO_USE_I_3 Setup Costs To Use[3] DLR17_RBSO_UTR$ Currency 17 37 COSTS_TO_USE_I_1 Costs To Use[1] DLR17_RBS0_UTR$ Currency 17 38 COSTS_TO_USE_I_2 Costs To Use[2] DLR17_RBS0_UTR$ Currency 17 39 COSTS_TO_USE_I_3 Costs To Use[3] DLR17_RBS0_UTR$ Currency 17 40 COSTS_TO_USE_I_4 Costs To Use[4] DLR17_RBS0_UTR$ Currency 17 41 COSTS_TO_USE_I_5 Costs To Use[5] DLR17_RBS0_UTR$ Currency 17 42 COSTS_TO_USE_I_6 Costs To Use[6] DLR17_RBS0_UTR$ Currency 17 43 SETUP_COSTS_TO_BACKFLUSH_1 Setup Costs To Backflush[1] DLR17_RBSO_UTR$ Currency 17 44 SETUP_COSTS_TO_BACKFLUSH_2 Setup Costs To Backflush[2] DLR17_RBSO_UTR$ Currency 17 45 SETUP_COSTS_TO_BACKFLUSH_3 Setup Costs To Backflush[3] DLR17_RBSO_UTR$ Currency 17 46 COSTS_TO_BACKFLUSH_I_1 Costs To Backflush[1] DLR17_RBSO_UTR$ Currency 17 47 COSTS_TO_BACKFLUSH_I_2 Costs To Backflush[2] DLR17_RBSO_UTR$ Currency 17 48 COSTS_TO_BACKFLUSH_I_3 Costs To Backflush[3] DLR17_RBSO_UTR$ Currency 17 49 COSTS_TO_BACKFLUSH_I_4 Costs To Backflush[4] DLR17_RBSO_UTR$ Currency 17 50 COSTS_TO_BACKFLUSH_I_5 Costs To Backflush[5] DLR17_RBSO_UTR$ Currency 17 51 COSTS_TO_BACKFLUSH_I_6 Costs To Backflush[6] DLR17_RBSO_UTR$ Currency 17 52 DEX_ROW_ID int int 10