Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXPV1001
Product: Manufacturing (346)
Series:
Display Name: EXP_BillOfMaterials
Physical Name: EXPV1001
Technical Name: EXP_BillOfMaterials
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PPN_I  | PPN | String | STR30_UC | 30 | |
| 2 | BOMCAT_I | BOM Cat | Integer | DDL_BOM_Cat | 0 | |
| 3 | BOMTYPE_I | BOM Type | Integer | DDL_BOM_Type | 0 | |
| 4 | BOMNAME_I | BOM Name | String | STR15_LBU | 15 | |
| 5 | BOM_REVISION_LEVEL | BOM Revision Level | String | STR50 | 50 | |
| 6 | CPN_I | CPN | String | STR30_Item_Number | 30 | |
| 7 | SUBCAT_I | Sub Cat | Integer | DDL_BOM_Cat | 0 | |
| 8 | SUBNAME_I | Sub Name | String | STR15_LBU | 15 | |
| 9 | QUANTITY_I | Quantity | Currency | DLR12_RBN_UT2 | 12 | |
| 10 | UOFM | U Of M | String | U_Of_M | 8 | |
| 11 | FIXED_QTY_I | Fixed Quantity | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 12 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 13 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hide | ||||||
| 14 | WCID_I | WC ID | String | STR10_Location_Code | 10 | |
| 15 | FLOORSTOCK_I | Floor Stock | Boolean | CB | 0 | |
| 16 | BACKFLUSHITEM_I | Backflush Item | Boolean | CB_Backflush Item | 0 | |
| 17 | ALTERNATE_I | Alternate | Boolean | CB | 0 | |
| 18 | ALTERNATEPARTFOR_I | Alternate Part For | String | STR30_Item_Number | 30 | |
| 19 | EFFECTIVEDATE_I | Effective Date0 | Date | DT | 8 | |
| 20 | OPTPERCENT_I | OPT Percent | Long Integer | INTXXX.X% | 4 | |
| 21 | SCRAPPERCENT_I | Scrap Percent | Long Integer | INTXXX.X% | 4 | |
| 22 | EFFECTIVEINDATE_I | Effective In Date | Date | DT | 8 | |
| 23 | EFFECTIVEOUTDATE_I | Effective Out Date | Date | DT | 8 | |
| 24 | LEADTIMEOFFSET_I | Lead Time Offset | Currency | DLR_10_3 | 18 | |
| 25 | OFFSET_FROM_I | Offset From | Integer | DDL_Offset_From | 0 | |
| 26 | USERDEF1 | User Defined 1 | String | STR20 | 20 | |
| 27 | USERDEF2 | User Defined 2 | String | STR20 | 20 | |
| 28 | BOMSINGLELOT_I | BOM_Single_Lot | Boolean | CB | 0 | |
| 29 | BOMENGAPPROVAL_I | BOM_Eng_Approval | Boolean | CB | 0 | |
| 30 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
| 31 | CHANGEBY_I | Change By | String | STR15_User_ID | 15 | |
| 32 | ACTUAL_CONSUMED_CHECK_I | Actual Consumed Check | Boolean | CB | 0 | |
| 33 | MODIFDT | Modified Date | Date | DT | 8 | |
| 34 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hide | ||||||
| 35 | BOMSEQ_I | BOM Seq | Long Integer | LINT_10 | 10 | |