OPRIDBUSINESS_UNITTOP_ITEM_IDEXPL_LVL_ENGINV_ITEM_IDRTG_STATEEN=Engineering
PR=Manufacturing
RTG_TYPEPR=Production
RW=Rework
TD=Teardown
RTG_CODEOP_SEQUENCED=Decimal
W=Whole Nbr
EN_BOM_EXP_INQ4(SQL Table) |
Index Back |
|---|---|
Operation Start Quantity8/8/02 YBO Enhancement - Used for BOM/EBOM Summary to store and calculate the start quantity at each operation 09/04/2006: Resolved SQL Error with BOM Summarized page. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | TOP_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Top Level Assembly |
| 4 | EXPL_LVL_ENG |
Number(3,0) | SMALLINT NOT NULL | Level Code |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | RTG_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing |
| 7 | RTG_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 8 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 9 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 10 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 11 | OPERATION_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Operation Yield |
| 12 | EXPL_QTY | Number(13,4) | DECIMAL(12,4) NOT NULL | Required Qty |
| 13 | EXPL_QTY1 | Number(16,7) | DECIMAL(15,7) NOT NULL | Required Qty |
| 14 | OP_STARTS_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 8/8/02 YBO Enhancement |
| 15 | QTY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal W=Whole Nbr |
| 16 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 17 | EXPECTED_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production End Qty |
| 18 | SORTCODE | Character(254) | VARCHAR2(254) NOT NULL | BOM Sort Code |