BUSINESS_UNITPRDN_AREA_CODEPRDN_DUE_SHIFTINV_ITEM_IDPRDN_DUE_DATENEW_END_TIME10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
SF_PA_SCH_DT_VW(SQL View) |
Index Back |
|---|---|
Prdn Sch detail by Prdn Area02/18/98 SCC CN#SCHEW-6547M: Added prdn start date/shift, new start time 01/30/98 SCC CN#SCHEW-XZ6L8: Add revision, scrap, completed qty 09/17/97 SCC CN# PL750-DI-SCHEW-109: Add view. This view provides the details of production schedule for a date. CN# EN800-3.0, Sep 21 98, Anna Added field BomCode Fields bomcode and rtgcode have not been made keys, as part of bomcode changes. |
| SELECT BUSINESS_UNIT, PRDN_AREA_CODE, PRDN_DUE_SHIFT, INV_ITEM_ID, PRDN_DUE_DATE, NEW_END_TIME, 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 FROM PS_SF_PRDNID_HEADR WHERE MA_PRDN_ID_FLG = 'N' AND 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 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 8 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 9 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
| 10 | 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 |
| 11 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |
| 12 | NEW_UOM | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 13 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 14 | PRDN_START_DATE | Date(10) | DATE | Prdn Start Date |
| 15 | PRDN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 16 | NEW_START_TIME | Time(15) | TIMESTAMP | Start Time |
| 17 | SCRAP_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 18 | COMPLETED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |