Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MRP1011
Product: Manufacturing (346)
Series:
Display Name: PR_Short_Items_Work_Dup Group Display Name: Manufacturing PR
Physical Name: MRP1011
Technical Name: PR_Short_Items_Work_Dup
Group Technical Name: Manufacturing PR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | USERID  | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PR_Short_Items_Work_Dup'].USERID AS 'PR_Short_Items_Work_Dup-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PR_Short_Items_Work_Dup'].USERID = ['Users Master'].USERID | ||||||
| 2 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['PR_Short_Items_Work_Dup'].ITEMNMBR AS 'PR_Short_Items_Work_Dup-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
IV00101 AS ['Item Master']
ON
['PR_Short_Items_Work_Dup'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 3 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['PR_Short_Items_Work_Dup'].LOCNCODE AS 'PR_Short_Items_Work_Dup-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['PR_Short_Items_Work_Dup'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 4 | MRPISSUEDATE_I | MRP_Issue Date | Date | DATE | 6 | |
| 5 | SHORTAMOUNT_I_1 | Short Amount[1] | Currency | DLR_14_MRP | 14 | |
| 6 | SHORTAMOUNT_I | Short Amount | DLR_14_MRP | Currency | 14 | |
| 7 | SHORTAMOUNT_I_2 | Short Amount[2] | Currency | DLR_14_MRP | 14 | |
| 8 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PR_Short_Items_Work_Dup'].VENDORID AS 'PR_Short_Items_Work_Dup-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
MRP1011 AS ['PR_Short_Items_Work_Dup']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PR_Short_Items_Work_Dup'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 9 | ORD | Ord | Long Integer | LI_Sequence_Number | 10 | |
| 10 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 | |
| 11 | STR30 | STR30 | String | STR30 | 30 | |
| 12 | Buy_Total | Buy Total | Currency | DLR_14_MRP | 14 | |
| 13 | UOFM | U Of M | String | U_Of_M | 8 | |
| 14 | RELEASEDATE_I | Release Date | Date | DT | 8 | |
| 15 | RUNNUMBER | MRP_Run_Number | Long Integer | INT9 | 9 | |
| 16 | ITEMDESC | Item Description | String | STR100 | 100 | |