CM_WC_PCPC_CVW(SQL View) |
Index Back |
|---|---|
Pending Calculation ProductionPending Calculation Production Cost in Cost WorkCenter |
| SELECT A.BUSINESS_UNIT , CM_BOOK , TRANSACTION_DATE , PRODUCTION_ID , DT_TIMESTAMP , OP_SEQUENCE , SEQ_NBR , CE_COST_TYPE , COST_VERSION , COST_SEQ , DESCR50 , PRDN_AREA_CODE , INV_ITEM_ID , PRDN_DUE_DATE , PRDN_DUE_SHIFT , COMPL_QTY , SCRAPPED_QTY , CE_POSTED_FLAG , MG_PROC_INSTANCE , COST_ELEMENT , TRANS_DATE , TRANS_TIME , CONVERSION_TYPE , REVALUE_FLAG , B.OPRCLASS FROM PS_CM_WC_PCPC_VW A , PS_SEC_BU_CLS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | 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 | TRANSACTION_DATE | Date(10) | DATE | Transaction Date |
| 4 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: %EDITTABLE |
| 5 | DT_TIMESTAMP |
DateTime(26) | TIMESTAMP | Date Timestamp |
| 6 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 7 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 8 | CE_COST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Cost Type |
| 9 | COST_VERSION | Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION5_VW |
| 10 | COST_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number |
| 11 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 12 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 13 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 14 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
| 15 | PRDN_DUE_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 16 | COMPL_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
| 17 | SCRAPPED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 18 | CE_POSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Posted
6=Cost for 661 N=Cost Pending Calculation Y=Cost Calculated Default Value: N |
| 19 | MG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 20 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 21 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 22 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 23 | CONVERSION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Conversion Type
1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4 |
| 24 | REVALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. |
| 25 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |