MOP_Receipt_MSTR (MOP1100)

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_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MOPRCTNM SearchMOP Receipt NumberStringSTR20_Document_Number_Receipt20
2REVERSED_RECEIPT_I SearchReversed_ReceiptBooleanBoolean0
3REVERSIBLE_RECEIPT_I SearchReversible ReceiptBooleanBoolean0
4MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
5DATERECD SearchDate ReceivedDateDATE6
6QTYRECVD SearchQTY ReceivedCurrencyDLR17_QTY_RBS0_UTR17
7TO_SITE_I SearchTo SiteStringSTR10_Location_Code10
8NOTEINDX SearchNote IndexCurrencyDLR1414
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 DateDateDT_Date6
10USERID SearchUser IDStringSTR15_User_ID15
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]CurrencyDLR17_RBS0_UTR$17
13RECEIPTCOSTSARRAY_2 SearchReceipt Costs Array[2]CurrencyDLR17_RBS0_UTR$17
14RECEIPTCOSTSARRAY_3 SearchReceipt Costs Array[3]CurrencyDLR17_RBS0_UTR$17
15RECEIPTCOSTSARRAY_4 SearchReceipt Costs Array[4]CurrencyDLR17_RBS0_UTR$17
16RECEIPTCOSTSARRAY_5 SearchReceipt Costs Array[5]CurrencyDLR17_RBS0_UTR$17
17SETUP_COSTS_TO_USE_I SearchSetup Costs To UseDLR17_RBSO_UTR$Currency17
18RECEIPTCOSTSARRAY_6 SearchReceipt Costs Array[6]CurrencyDLR17_RBS0_UTR$17
19COSTS_TO_USE_I SearchCosts To UseDLR17_RBS0_UTR$Currency17
20RECEIPTCOSTSARRAY_7 SearchReceipt Costs Array[7]CurrencyDLR17_RBS0_UTR$17
21SETUP_COSTS_TO_BACKFLUSH SearchSetup Costs To BackflushDLR17_RBSO_UTR$Currency17
22RECEIPTCOSTSARRAY_8 SearchReceipt Costs Array[8]CurrencyDLR17_RBS0_UTR$17
23COSTS_TO_BACKFLUSH_I SearchCosts To BackflushDLR17_RBSO_UTR$Currency17
24RECEIPTCOSTSARRAY_9 SearchReceipt Costs Array[9]CurrencyDLR17_RBS0_UTR$17
25RECEIPTCOSTSARRAY_10 SearchReceipt Costs Array[10]CurrencyDLR17_RBS0_UTR$17
26LABCOSTSINDCTR SearchLabor Costs IndicatorIntegerGB0
27MACHCOSTSINDCTR SearchMachine Costs IndicatorIntegerGB0
28LABORCOSTSPCT SearchLabor Costs PercentIntegerINT4_%24
29MACHINECOSTSPCT SearchMachine Costs PercentIntegerINT4_%24
30SETUP_COSTS_TO_USE_I_1 SearchSetup Costs To Use[1]CurrencyDLR17_RBSO_UTR$17
31SETUP_COSTS_TO_USE_I_2 SearchSetup Costs To Use[2]CurrencyDLR17_RBSO_UTR$17
32SETUP_COSTS_TO_USE_I_3 SearchSetup Costs To Use[3]CurrencyDLR17_RBSO_UTR$17
33COSTS_TO_USE_I_1 SearchCosts To Use[1]CurrencyDLR17_RBS0_UTR$17
34COSTS_TO_USE_I_2 SearchCosts To Use[2]CurrencyDLR17_RBS0_UTR$17
35COSTS_TO_USE_I_3 SearchCosts To Use[3]CurrencyDLR17_RBS0_UTR$17
36COSTS_TO_USE_I_4 SearchCosts To Use[4]CurrencyDLR17_RBS0_UTR$17
37COSTS_TO_USE_I_5 SearchCosts To Use[5]CurrencyDLR17_RBS0_UTR$17
38COSTS_TO_USE_I_6 SearchCosts To Use[6]CurrencyDLR17_RBS0_UTR$17
39SETUP_COSTS_TO_BACKFLUSH_1 SearchSetup Costs To Backflush[1]CurrencyDLR17_RBSO_UTR$17
40SETUP_COSTS_TO_BACKFLUSH_2 SearchSetup Costs To Backflush[2]CurrencyDLR17_RBSO_UTR$17
41SETUP_COSTS_TO_BACKFLUSH_3 SearchSetup Costs To Backflush[3]CurrencyDLR17_RBSO_UTR$17
42COSTS_TO_BACKFLUSH_I_1 SearchCosts To Backflush[1]CurrencyDLR17_RBSO_UTR$17
43COSTS_TO_BACKFLUSH_I_2 SearchCosts To Backflush[2]CurrencyDLR17_RBSO_UTR$17
44COSTS_TO_BACKFLUSH_I_3 SearchCosts To Backflush[3]CurrencyDLR17_RBSO_UTR$17
45COSTS_TO_BACKFLUSH_I_4 SearchCosts To Backflush[4]CurrencyDLR17_RBSO_UTR$17
46COSTS_TO_BACKFLUSH_I_5 SearchCosts To Backflush[5]CurrencyDLR17_RBSO_UTR$17
47COSTS_TO_BACKFLUSH_I_6 SearchCosts To Backflush[6]CurrencyDLR17_RBSO_UTR$17
48POSTED SearchPostedBooleanTrue/False0
49COMPLETEMOATCOMPCLOSE SearchComplete MO at Complete/CloseBooleanBoolean0
50CLOSEMOATCOMPCLOSE SearchClose MO at Complete/CloseBooleanBoolean0
51JOBLINKSTATE SearchJob Link StateIntegerJob Link State0

Leave a Reply

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