BUSINESS_UNITPRDN_AREA_CODEINV_ITEM_IDDATE_IN_EFFECTPRDN_RATE_QTYSF_PA_AREA_QTY(SQL View) |
Index Back |
|---|---|
Default Prdn Area Qty11/02/98 EWB CN#EN800-4.0: Add date in effect. There are now multiple rows for same item in one area. 10/31/97 SCC CN# PL750-DI-SCHEW109: View is used as a prompt table on Production Schedule by Area Maintenance to provide a default quantity from production area item table. |
| select a.business_unit, a.prdn_area_code, a.inv_item_id, a.date_in_effect, a.prdn_rate_qty from PS_SF_PRDN_AREA_IT a |
| # | 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 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | DATE_IN_EFFECT |
Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 5 | PRDN_RATE_QTY |
Number(12,4) | DECIMAL(11,4) NOT NULL | 10/18/99 SCC CN#IC800: Add label RATE_QTY_PER_SHIFT |