BUSINESS_UNITPRDN_AREA_CODEINV_ITEM_IDPrompt Table: MG_ITEM_OWN1_VW
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
SF_PRDNAREA_VW1(SQL View) |
Index Back |
|---|---|
Production Area/Item12/29/98, eyz, CN#EN800-4.0, Recipe Management. |
| SELECT DISTINCT BUSINESS_UNIT, PRDN_AREA_CODE, INV_ITEM_ID, ISSUE_METHOD FROM PS_SF_PRDN_AREA_IT |
| # | 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
Prompt Table: MG_ITEM_OWN1_VW |
| 4 | ISSUE_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Component Issue Method
COM=Use Comp. ISS=Issue KIT=Kit REPL=Replenish |