Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IVR10015
Product: Manufacturing (346)
Series:
Display Name: Item Engineering File Group Display Name: Manufacturing Inventory
Physical Name: IVR10015
Technical Name: IV_Item_ENG
Group Technical Name: Manufacturing Inventory
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ITEMNMBR  | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Item Engineering File'].ITEMNMBR AS 'Item Engineering File-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
IVR10015 AS ['Item Engineering File']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Item Engineering File'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 2 | ITEMSTATUS_I | Item Status | Integer | DDL_Item_Status | 0 | |
| 3 | BOMTYPE_I | BOM Type | Integer | DDL_BOM_Type | 0 | |
| 4 | MAKEBUYCODE_I | Make/Buy_Code | Integer | DDL_Make_Buy_Code | 0 | |
| 5 | ITEMDESIGNAUTHORIT_I | Item Design Authority | String | STR100 | 100 | |
| 6 | EFFECTIVEDATE_I | Effective Date0 | Date | DT | 8 | |
| 7 | REVISIONLEVEL_I | Revision Level | String | STR50 | 50 | |
| 8 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
| 9 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Item Engineering File'].USERID AS 'Item Engineering File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
IVR10015 AS ['Item Engineering File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Item Engineering File'].USERID = ['Users Master'].USERID | ||||||
| 10 | DWGNUM_I | DWG # | String | STR30_Item_Number | 30 | |
| 11 | DWGSIZE_I | DWG Size | String | STR2_U | 2 | |
| 12 | ABCCODE_I | ABC_Code | Integer | DDL_ABC_Code | 0 | |
| 13 | FLOORSTOCK_I | Floor Stock | Boolean | CB | 0 | |
| 14 | ITEMUSEUP_I | Item Use Up? | Boolean | CB_Use_Up_Item | 0 | |
| 15 | CALCMRP_I | Calc MRP | Boolean | CB | 0 | |
| 16 | QAQCNEEDED_I | QA/QC Needed | Boolean | CB_QA_Sequence | 0 | |
| 17 | MINIMUMISSUE_I | Minimum Issue | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 18 | IVCARRYINGCOST_I | IV Carrying Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | IVSETUPCOST_I | IV Setup Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 20 | AVERAGEORDQTY_I | Average ORD QTY | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 21 | SHRINKAGEPERCENT_I | Shrinkage% | Long Integer | INTXXX.X% | 4 | |
| 22 | DESTTESTINGREQD_I | Destructive Testing Required | Boolean | CB_Destructive_Testing | 0 | |
| 23 | ALTERNATE_I | Alternate | Boolean | CB | 0 | |
| 24 | SHIPPINGUOFM_I | Shipping U Of M | Integer | DDL_Shipping_UofM | 0 | |
| 25 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Item Engineering File'].LOCNCODE AS 'Item Engineering File-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IVR10015 AS ['Item Engineering File']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Item Engineering File'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 26 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
| 27 | ITEMFULFILLMETHOD | Item Fulfillment Method | Integer | Item Fulfillment Method | 0 | |
| 28 | LLC | LLC | Long Integer | INT9 | 9 | |
| 29 | RUNNUMBER | MRP_Run_Number | Long Integer | INT9 | 9 | |
| 30 | FG_STD_QTY_I | FG Standard Quantity | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 31 | QASTDATE | QA Start Date | Date | DT | 8 | |
| 32 | QAENDDATE | QA End Date | Date | DT | 8 | |
| 33 | DAYTOEXP | Days To Expire | Integer | INT4_Days_To_Expire | 4 | |
| 34 | INCL_EXP_TO_ENG | Include In Export To Engineering | Boolean | CB Include in Export to Engineering | 0 | |
| 35 | ISCHANGD | IsChanged | Boolean | CB | 0 | |