CP_ORD1_VW(SQL View) |
Index Back |
|---|---|
CP Order Inq Production ViewCP Order Inq Production View |
| SELECT A.BUSINESS_UNIT , A.ORDER_NO , A.CP_MODE , A.CP_COMP_SEQ , B.BUSINESS_UNIT , A.ORDER_INT_LINE_NO , B.PRODUCTION_ID , B.PROD_STATUS , B.PRDN_AREA_CODE , B.INV_ITEM_ID , B.PRODUCTION_TYPE , B.ORIG_PRDN_QTY , B.EXPECTED_PRDN_QTY , B.PRDN_START_DATE , B.PRDN_START_TIME , B.PRDN_START_SHIFT , B.PRDN_DUE_DATE , B.PRDN_DUE_TIME , B.PRDN_DUE_SHIFT , B.COMPLETED_QTY , B.PERCENT_COMP , B.COMP_CLOSE_DT , B.COMP_CLOSE_TIME , B.PRDN_CREATED_DTTM , B.CONFIG_CODE FROM PS_CP_OPT_HDR A , PS_SF_PRDNID_HEADR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_OM AND A.PRODUCTION_ID = B.PRODUCTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_OM |
Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | CP_MODE |
Character(1) | VARCHAR2(1) NOT NULL |
Rule Processing Modes Field
A=CRM Internal C=Model Tester M=Direct Production Order R=Direct Requisition Order S=Sales Order W=CRM External |
| 4 | CP_COMP_SEQ |
Number(3,0) | SMALLINT NOT NULL | Component Sequence Field |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 7 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 8 | PROD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Production Status
10=Entered 15=Firmed 20=Released 30=In Process 40=Pend Cmpl 50=Completed 60=Clsd/Labor 70=Clsd/Acctg 90=Canceled |
| 9 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 10 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 11 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 12 | ORIG_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Original Production Qty |
| 13 | EXPECTED_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production End Qty |
| 14 | PRDN_START_DATE | Date(10) | DATE | Prdn Start Date |
| 15 | PRDN_START_TIME | Time(15) | TIMESTAMP | Prdn Start Time |
| 16 | PRDN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 17 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
| 18 | PRDN_DUE_TIME | Time(15) | TIMESTAMP | Prdn Due Time |
| 19 | PRDN_DUE_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 20 | COMPLETED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
| 21 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 22 | COMP_CLOSE_DT | Date(10) | DATE | Date of Completion |
| 23 | COMP_CLOSE_TIME | Time(15) | TIMESTAMP | Time of Completion |
| 24 | PRDN_CREATED_DTTM | DateTime(26) | TIMESTAMP | Production Created DateTime |
| 25 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |