BUSINESS_UNITPRDN_AREA_CODEPRDN_DUE_SHIFTINV_ITEM_IDPRDN_DUE_DATENEW_END_TIMEPRODUCTION_ID10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
SF_SCH_D_OUT_VW(SQL View) |
Index Back |
|---|---|
Production Schedule/Output Det/* 3/3/99 ddp, This view is copied from SF_PA_SCH_DT_VW, so I can add PRODUCTION_ID field for Output List. */ |
| SELECT BUSINESS_UNIT , PRDN_AREA_CODE , PRDN_DUE_SHIFT , INV_ITEM_ID , PRDN_DUE_DATE , NEW_END_TIME , PRODUCTION_ID , BOM_CODE , RTG_CODE , REF_ROUTING_ITEM , PROD_STATUS , NEW_PRDN_QTY , NEW_UOM , REVISION , PRDN_START_DATE , PRDN_START_SHIFT , NEW_START_TIME , SCRAP_QTY , COMPLETED_QTY , EXPECTED_PRDN_QTY FROM PS_SF_PRDNID_HEADR WHERE PROD_STATUS <> '90' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 3 | PRDN_DUE_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | PRDN_DUE_DATE |
Date(10) | DATE | Prdn Due Date |
| 6 | NEW_END_TIME |
Time(15) | TIMESTAMP | Due Time |
| 7 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 8 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 9 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 10 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
| 11 | 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 |
| 12 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |
| 13 | NEW_UOM | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 14 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 15 | PRDN_START_DATE | Date(10) | DATE | Prdn Start Date |
| 16 | PRDN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 17 | NEW_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 18 | SCRAP_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 19 | COMPLETED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
| 20 | EXPECTED_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production End Qty |