MOP_Receipt_MSTR (MOP1100)

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
Physical Name: MOP1100
Technical Name: MOP_Receipt_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1MOPRCTNM SearchMOP Receipt NumberSTR20_Document_Number_ReceiptString2220
2REVERSED_RECEIPT_I SearchReversed_ReceiptBooleanBoolean20
3REVERSIBLE_RECEIPT_I SearchReversible ReceiptBooleanBoolean20
4MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString3230
5DATERECD SearchDate ReceivedDATEDate46
6QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency1017
7TO_SITE_I SearchTo SiteSTR10_Location_CodeString1210
8NOTEINDX SearchNote IndexDLR14Currency1014
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
9POSTDATE SearchPost DateDT_DateDate46
10USERID SearchUser IDSTR15_User_IDString1615
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
11RECEIPTCOSTSARRAY SearchReceipt Costs ArrayDLR17_RBS0_UTR$Currency1017
12RECEIPTCOSTSARRAY_1 SearchReceipt Costs Array[1]DLR17_RBS0_UTR$Currency1017
13RECEIPTCOSTSARRAY_2 SearchReceipt Costs Array[2]DLR17_RBS0_UTR$Currency1017
14LABCOSTSINDCTR SearchLabor Costs IndicatorGBInteger20
15RECEIPTCOSTSARRAY_3 SearchReceipt Costs Array[3]DLR17_RBS0_UTR$Currency1017
16MACHCOSTSINDCTR SearchMachine Costs IndicatorGBInteger20
17RECEIPTCOSTSARRAY_4 SearchReceipt Costs Array[4]DLR17_RBS0_UTR$Currency1017
18LABORCOSTSPCT SearchLabor Costs PercentINT4_%2Integer24
19MACHINECOSTSPCT SearchMachine Costs PercentINT4_%2Integer24
20RECEIPTCOSTSARRAY_5 SearchReceipt Costs Array[5]DLR17_RBS0_UTR$Currency1017
21RECEIPTCOSTSARRAY_6 SearchReceipt Costs Array[6]DLR17_RBS0_UTR$Currency1017
22SETUP_COSTS_TO_USE_I SearchSetup Costs To UseDLR17_RBSO_UTR$Currency1017
23RECEIPTCOSTSARRAY_7 SearchReceipt Costs Array[7]DLR17_RBS0_UTR$Currency1017
24COSTS_TO_USE_I SearchCosts To UseDLR17_RBS0_UTR$Currency1017
25RECEIPTCOSTSARRAY_8 SearchReceipt Costs Array[8]DLR17_RBS0_UTR$Currency1017
26SETUP_COSTS_TO_BACKFLUSH SearchSetup Costs To BackflushDLR17_RBSO_UTR$Currency1017
27RECEIPTCOSTSARRAY_9 SearchReceipt Costs Array[9]DLR17_RBS0_UTR$Currency1017
28COSTS_TO_BACKFLUSH_I SearchCosts To BackflushDLR17_RBSO_UTR$Currency1017
29RECEIPTCOSTSARRAY_10 SearchReceipt Costs Array[10]DLR17_RBS0_UTR$Currency1017
30POSTED SearchPostedTrue/FalseBoolean20
31COMPLETEMOATCOMPCLOSE SearchComplete MO at Complete/CloseBooleanBoolean20
32CLOSEMOATCOMPCLOSE SearchClose MO at Complete/CloseBooleanBoolean20
33JOBLINKSTATE SearchJob Link StateJob Link StateInteger20
34SETUP_COSTS_TO_USE_I_1 SearchSetup Costs To Use[1]DLR17_RBSO_UTR$Currency1017
35SETUP_COSTS_TO_USE_I_2 SearchSetup Costs To Use[2]DLR17_RBSO_UTR$Currency1017
36SETUP_COSTS_TO_USE_I_3 SearchSetup Costs To Use[3]DLR17_RBSO_UTR$Currency1017
37COSTS_TO_USE_I_1 SearchCosts To Use[1]DLR17_RBS0_UTR$Currency1017
38COSTS_TO_USE_I_2 SearchCosts To Use[2]DLR17_RBS0_UTR$Currency1017
39COSTS_TO_USE_I_3 SearchCosts To Use[3]DLR17_RBS0_UTR$Currency1017
40COSTS_TO_USE_I_4 SearchCosts To Use[4]DLR17_RBS0_UTR$Currency1017
41COSTS_TO_USE_I_5 SearchCosts To Use[5]DLR17_RBS0_UTR$Currency1017
42COSTS_TO_USE_I_6 SearchCosts To Use[6]DLR17_RBS0_UTR$Currency1017
43SETUP_COSTS_TO_BACKFLUSH_1 SearchSetup Costs To Backflush[1]DLR17_RBSO_UTR$Currency1017
44SETUP_COSTS_TO_BACKFLUSH_2 SearchSetup Costs To Backflush[2]DLR17_RBSO_UTR$Currency1017
45SETUP_COSTS_TO_BACKFLUSH_3 SearchSetup Costs To Backflush[3]DLR17_RBSO_UTR$Currency1017
46COSTS_TO_BACKFLUSH_I_1 SearchCosts To Backflush[1]DLR17_RBSO_UTR$Currency1017
47COSTS_TO_BACKFLUSH_I_2 SearchCosts To Backflush[2]DLR17_RBSO_UTR$Currency1017
48COSTS_TO_BACKFLUSH_I_3 SearchCosts To Backflush[3]DLR17_RBSO_UTR$Currency1017
49COSTS_TO_BACKFLUSH_I_4 SearchCosts To Backflush[4]DLR17_RBSO_UTR$Currency1017
50COSTS_TO_BACKFLUSH_I_5 SearchCosts To Backflush[5]DLR17_RBSO_UTR$Currency1017
51COSTS_TO_BACKFLUSH_I_6 SearchCosts To Backflush[6]DLR17_RBSO_UTR$Currency1017
52DEX_ROW_ID Searchintint1010

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 *