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