BM010117 - BOM_Mass_Changes_Line_Defaults
Query Builder
| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CPN_I | CPN |
String | 32 | View | |
| USERID | User ID |
String | 16 | View | |
| BOM_Quantity_RadioGroup | BOM_Quantity_RadioGroup |
Integer | 2 | View | |
| QUANTITY_I | Quantity |
Currency | 10 | View | |
| BOM_UOFM_RadioGroup | BOM_UOFM_RadioGroup |
Integer | 2 | View | |
| UOFM | U Of M |
String | 10 | View | |
| BOM_IssueFrom_RadioGroup | BOM_IssueFrom_RadioGroup |
Integer | 2 | View | |
| FROM_SITE_I | From Site |
String | 12 | View | |
| BOM_IssueTo_RadioGroup | BOM_IssueTo_RadioGroup |
Integer | 2 | View | |
| TO_SITE_I | To Site |
String | 12 | View | |
| BOM_InDate_RadioGroup | BOM_InDate_RadioGroup |
Integer | 2 | View | |
| EFFECTIVEINDATE_I | Effective In Date |
Date | 4 | View | |
| BOM_OutDate_RadioGroup | BOM_OutDate_RadioGroup |
Integer | 2 | View | |
| EFFECTIVEOUTDATE_I | Effective Out Date |
Date | 4 | View | |
| BOM_Shrinkage_RadioGroup | BOM_Shrinkage_RadioGroup |
Integer | 2 | View | |
| SHRINKAGEPERCENT_I | Shrinkage% |
Long Integer | 4 | View | |
| BOM_FixedQty_RadioGroup | BOM_FixedQty_RadioGroup |
Integer | 2 | View | |
| FIXED_QTY_I | Fixed Quantity |
Currency | 10 | View | |
| BOM_FixedQtyUofM_RadioGr | BOM_FixedQtyUofM_RadioGroup |
Integer | 2 | View | |
| U_Of_M_2 | U Of M 2 |
String | 10 | View | |
| BOM_LeadTime_RadioGroup | BOM_LeadTime_RadioGroup |
Integer | 2 | View | |
| LEADTIMEOFFSET_I | Lead Time Offset |
Currency | 10 | View | |
| LEADTIMEOFFSETINC_I | Lead Time Offset Inc |
Integer | 2 | View | |
| BOM_OffsetFrom_RadioGrou | BOM_OffsetFrom_RadioGroup |
Integer | 2 | View | |
| OFFSET_FROM_I | Offset From |
Integer | 2 | View | |
| BOM_RefDesignators_Radio | BOM_RefDesignators_RadioGroup |
Integer | 2 | View | |
| BOM_Backflush_RadioGroup | BOM_Backflush_RadioGroup |
Integer | 2 | View | |
| BACKFLUSHITEM_I | Backflush Item |
Boolean | 2 | View | |
| BOM_FloorStock_RadioGrou | BOM_FloorStock_RadioGroup |
Integer | 2 | View | |
| FLOORSTOCK_I | Floor Stock |
Boolean | 2 | View | |
| BOM_Alternate_RadioGroup | BOM_Alternate_RadioGroup |
Integer | 2 | View | |
| ALTERNATE_I | Alternate |
Boolean | 2 | View | |
| BOM_SingleLot_RadioGroup | BOM_SingleLot_RadioGroup |
Integer | 2 | View | |
| BOMSINGLELOT_I | BOM_Single_Lot |
Boolean | 2 | View | |
| BOM_EngApproval_RadioGro | BOM_EngApproval_RadioGroup |
Integer | 2 | View | |
| BOMENGAPPROVAL_I | BOM_Eng_Approval |
Boolean | 2 | View | |
| BOM_ActConsumed_RadioGro | BOM_ActConsumed_RadioGroup |
Integer | 2 | View | |
| ACTUAL_CONSUMED_CHECK_I | Actual Consumed Check |
Boolean | 2 | View | |
| QTYBSUOM | QTY In Base U Of M |
Currency | 10 | View | |
| QTY_In_Variable_U_Of_M | QTY In Variable U Of M |
Currency | 10 | View |