BUSINESS_UNITPRDN_AREA_CODEPRDN_DUE_SHIFTINV_ITEM_IDPRDN_DUE_DATESF_PA_SCH_VW(SQL View) |
Index Back |
|---|---|
Prdn Sch sum by Prdn AreaSCC 9/17/97 CN# PL750-DI-SCHEW-109: Add view. This view sums all production schedules by production area. |
| SELECT BUSINESS_UNIT , PRDN_AREA_CODE , PRDN_DUE_SHIFT , INV_ITEM_ID , PRDN_DUE_DATE , SUM(EXPECTED_PRDN_QTY) FROM PS_SF_PRDNID_HEADR WHERE PROD_STATUS <> '90' GROUP BY BUSINESS_UNIT, PRDN_AREA_CODE, PRDN_DUE_SHIFT, INV_ITEM_ID, PRDN_DUE_DATE |
| # | 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 | EXPECTED_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production End Qty |