CE_OP_HISTB_VW(SQL View) |
Index Back |
|---|---|
Operation History ViewMFG operation transaction history view; tracks details at the operation level |
| SELECT BUSINESS_UNIT , CM_BOOK , PRODUCTION_ID , MIN(DT_TIMESTAMP) , OP_SEQUENCE , SEQ_NBR , CE_COST_TYPE , COST_VERSION , COST_SEQ , PRDN_AREA_CODE , INV_ITEM_ID , CE_POSTED_FLAG FROM PS_CE_OP_HISTB GROUP BY BUSINESS_UNIT , CM_BOOK , PRODUCTION_ID , OP_SEQUENCE , SEQ_NBR , CE_COST_TYPE , COST_VERSION , COST_SEQ , PRDN_AREA_CODE , INV_ITEM_ID , CE_POSTED_FLAG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Book
Prompt Table: CM_BU_BOOK_TBL |
| 3 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: %EDITTABLE |
| 4 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 5 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | CE_COST_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Cost Type |
| 8 | COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION5_VW |
| 9 | COST_SEQ |
Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number |
| 10 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 12 | CE_POSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Posted
6=Cost for 661 N=Cost Pending Calculation Y=Cost Calculated |