HASH_KEYCP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
ASY=Assembly
ORD=Order
10=Open
20=Completed
30=Canceled
40=Not Pegged
Default Value: 10
IN_PRO_MPEG_VW(SQL View) |
Index Back |
|---|---|
Pegging Table06/16/04 EGS: Created. |
| SELECT C.HASH_KEY , C.BUSINESS_UNIT , C.PRODUCTION_ID , C.MG_OUTPUT_TYPE , C.MG_OUTPUT_ITEM , C.OP_SEQUENCE , C.MG_OUTPUT_QTY_CODE , MIN(B.PEG_STATUS) FROM PS_IN_PEGGING B , PS_SF_OUTPUT_HASH C WHERE B.SUPPLY_HASH = C.HASH_KEY AND B.SUP_ORDER_TYPE = '020' GROUP BY C.HASH_KEY, C.BUSINESS_UNIT, C.PRODUCTION_ID, C.MG_OUTPUT_TYPE, C.MG_OUTPUT_ITEM, C.OP_SEQUENCE, C.MG_OUTPUT_QTY_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HASH_KEY |
Character(28) | VARCHAR2(28) NOT NULL | 08/11/04 EGS: Created |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | MG_OUTPUT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle).
11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 7 | MG_OUTPUT_QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
01/28/98 (CN#EN800-6.0) LAJ...Created
Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly ORD=Order |
| 8 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged Default Value: 10 |