Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MF010430
Product: Manufacturing (346)
Series:
Display Name: MPS Transaction Log Group Display Name: Manufacturing MPS
Physical Name: MF010430
Technical Name: MF_TRX_Log
Group Technical Name: Manufacturing MPS
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PLANNAME_I | Plan Name | String | STR15 | 15 | |
2 | MFLINEITEM_I | MF Line Item | Integer | INT3 | 3 | |
3 | DATE1 | Date | Date | DT6 | 6 | |
4 | POSTEDDT | Posted Date | Date | DATE | 6 | |
5 | TIME1 | Time | Time | TM6 | 6 | |
6 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['MPS Transaction Log'].USERID AS 'MPS Transaction Log-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MF010430 AS ['MPS Transaction Log']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MPS Transaction Log'].USERID = ['Users Master'].USERID | ||||||
7 | SUCCESSFULTRX_I | SuccessfulTrx | Boolean | CB | 0 | |
8 | TRANSACTIONRESULT_I | Transaction Result | Integer | Transaction Result | 0 | |
9 | STARTQTY_I | Start QTY | Currency | DLR_14_MRP | 14 | |
10 | MANUFACTUREORDER_I | Manufacture Order | String | STR30_UC | 30 | |
11 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['MPS Transaction Log'].ITEMNMBR AS 'MPS Transaction Log-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MF010430 AS ['MPS Transaction Log']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MPS Transaction Log'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
12 | ROUTINGNAME_I | RoutingName | String | STR30_Item_Number | 30 | |
13 | SCHEDULINGPREFEREN_I | Scheduling Preference | String | STR20 | 20 | |
14 | DRAWFROMSITE_I | Draw From Site | String | STR10_Location_Code | 10 | |
15 | POSTTOSITE_I | Post To Site | String | STR10_Location_Code | 10 | |
16 | BOMCAT_I | BOM Cat | Integer | DDL_BOM_Cat | 0 | |
17 | BOMNAME_I | BOM Name | String | STR15_LBU | 15 | |
18 | COMMENTS1000_I | Comments1000 | Text | TXT1000 | 1000 |