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 TypeLength
1MOPRCTNM SearchMOP Receipt NumberSTR20_Document_Number_ReceiptString20
2REVERSED_RECEIPT_I SearchReversed_ReceiptBooleanBoolean0
3REVERSIBLE_RECEIPT_I SearchReversible ReceiptBooleanBoolean0
4MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString30
5DATERECD SearchDate ReceivedDATEDate6
6QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency17
7TO_SITE_I SearchTo SiteSTR10_Location_CodeString10
8NOTEINDX SearchNote IndexDLR14Currency14
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_DateDate6
10USERID SearchUser IDSTR15_User_IDString15
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$Currency17
12RECEIPTCOSTSARRAY_1 SearchReceipt Costs Array[1]DLR17_RBS0_UTR$Currency17
13RECEIPTCOSTSARRAY_2 SearchReceipt Costs Array[2]DLR17_RBS0_UTR$Currency17
14LABCOSTSINDCTR SearchLabor Costs IndicatorGBInteger0
15RECEIPTCOSTSARRAY_3 SearchReceipt Costs Array[3]DLR17_RBS0_UTR$Currency17
16MACHCOSTSINDCTR SearchMachine Costs IndicatorGBInteger0
17RECEIPTCOSTSARRAY_4 SearchReceipt Costs Array[4]DLR17_RBS0_UTR$Currency17
18LABORCOSTSPCT SearchLabor Costs PercentINT4_%2Integer4
19MACHINECOSTSPCT SearchMachine Costs PercentINT4_%2Integer4
20RECEIPTCOSTSARRAY_5 SearchReceipt Costs Array[5]DLR17_RBS0_UTR$Currency17
21RECEIPTCOSTSARRAY_6 SearchReceipt Costs Array[6]DLR17_RBS0_UTR$Currency17
22SETUP_COSTS_TO_USE_I SearchSetup Costs To UseDLR17_RBSO_UTR$Currency17
23RECEIPTCOSTSARRAY_7 SearchReceipt Costs Array[7]DLR17_RBS0_UTR$Currency17
24COSTS_TO_USE_I SearchCosts To UseDLR17_RBS0_UTR$Currency17
25RECEIPTCOSTSARRAY_8 SearchReceipt Costs Array[8]DLR17_RBS0_UTR$Currency17
26SETUP_COSTS_TO_BACKFLUSH SearchSetup Costs To BackflushDLR17_RBSO_UTR$Currency17
27RECEIPTCOSTSARRAY_9 SearchReceipt Costs Array[9]DLR17_RBS0_UTR$Currency17
28COSTS_TO_BACKFLUSH_I SearchCosts To BackflushDLR17_RBSO_UTR$Currency17
29RECEIPTCOSTSARRAY_10 SearchReceipt Costs Array[10]DLR17_RBS0_UTR$Currency17
30POSTED SearchPostedTrue/FalseBoolean0
31COMPLETEMOATCOMPCLOSE SearchComplete MO at Complete/CloseBooleanBoolean0
32CLOSEMOATCOMPCLOSE SearchClose MO at Complete/CloseBooleanBoolean0
33JOBLINKSTATE SearchJob Link StateJob Link StateInteger0
34SETUP_COSTS_TO_USE_I_1 SearchSetup Costs To Use[1]DLR17_RBSO_UTR$Currency17
35SETUP_COSTS_TO_USE_I_2 SearchSetup Costs To Use[2]DLR17_RBSO_UTR$Currency17
36SETUP_COSTS_TO_USE_I_3 SearchSetup Costs To Use[3]DLR17_RBSO_UTR$Currency17
37COSTS_TO_USE_I_1 SearchCosts To Use[1]DLR17_RBS0_UTR$Currency17
38COSTS_TO_USE_I_2 SearchCosts To Use[2]DLR17_RBS0_UTR$Currency17
39COSTS_TO_USE_I_3 SearchCosts To Use[3]DLR17_RBS0_UTR$Currency17
40COSTS_TO_USE_I_4 SearchCosts To Use[4]DLR17_RBS0_UTR$Currency17
41COSTS_TO_USE_I_5 SearchCosts To Use[5]DLR17_RBS0_UTR$Currency17
42COSTS_TO_USE_I_6 SearchCosts To Use[6]DLR17_RBS0_UTR$Currency17
43SETUP_COSTS_TO_BACKFLUSH_1 SearchSetup Costs To Backflush[1]DLR17_RBSO_UTR$Currency17
44SETUP_COSTS_TO_BACKFLUSH_2 SearchSetup Costs To Backflush[2]DLR17_RBSO_UTR$Currency17
45SETUP_COSTS_TO_BACKFLUSH_3 SearchSetup Costs To Backflush[3]DLR17_RBSO_UTR$Currency17
46COSTS_TO_BACKFLUSH_I_1 SearchCosts To Backflush[1]DLR17_RBSO_UTR$Currency17
47COSTS_TO_BACKFLUSH_I_2 SearchCosts To Backflush[2]DLR17_RBSO_UTR$Currency17
48COSTS_TO_BACKFLUSH_I_3 SearchCosts To Backflush[3]DLR17_RBSO_UTR$Currency17
49COSTS_TO_BACKFLUSH_I_4 SearchCosts To Backflush[4]DLR17_RBSO_UTR$Currency17
50COSTS_TO_BACKFLUSH_I_5 SearchCosts To Backflush[5]DLR17_RBSO_UTR$Currency17
51COSTS_TO_BACKFLUSH_I_6 SearchCosts To Backflush[6]DLR17_RBSO_UTR$Currency17
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 *