PL_PO_PLAN_VW(SQL View) |
Index Back |
|---|---|
PL_PO_PLAN_VW08/03/99 EGS (CN#PL800-8) Added OVERRIDE_SUGG_VNDR and BUYER_ID. 2/5/01 jnw aprd R-RVASA-X39NC: changed approvaal flag from header to detail line |
| SELECT A.PLANNER_CD , A.SEQ_NBR , A.BUSINESS_UNIT_IN , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.RELEASE_DATE , A.DUE_DT , A.INV_ITEM_ID , A.CONFIG_CODE , A.QTY_PO , A.APPROVED_FLG , A.PROCESSED_FLG , A.TOLERANCE_FLG , A.SCHED_CHNG_FLG , A.CANCEL_CHNG_FLG , A.PLAN_FROZEN_FLG , A.PL_STATUS_CD , A.PL_PO_TYPE , A.VENDOR_ID , A.OVERRIDE_SUGG_VNDR , A.BUYER_ID , A.BUSINESS_UNIT , B.CHNG_DTTM , ' ' , ' ' , ' ' FROM PS_PL_PO_PLAN_ORD A , PS_PL_CHG_RQST_DTL B WHERE A.PO_ID = B.PO_ID AND A.BUSINESS_UNIT_IN = B.BUSINESS_UNIT_IN AND A.SEQ_NBR = B.SEQ_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 2 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 4 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 7 | RELEASE_DATE | Date(10) | DATE | Release Date |
| 8 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 10 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 11 | PLANNED_QUANTITY | Number(16,4) | DECIMAL(15,4) NOT NULL | Planned Quantity |
| 12 | APPROVED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Approved by Auditor
D=Denied N=Not Approved Y=Approved Y/N Table Edit |
| 13 | PROCESSED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Plan Processed Flag
C=Complete E=Errors N=Initialize P=In Process Y/N Table Edit |
| 14 | TOLERANCE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
jnw changed long description for planning phoenix - commit plan
10/18/02 JC (CN#PL880-1): Added TOLERANCE label
Y/N Table Edit |
| 15 | SCHED_CHNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Planning Schedule Change
Y/N Table Edit |
| 16 | CANCEL_CHNG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Planning Canceled
Y/N Table Edit |
| 17 | PLAN_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/01/01 PCL (CN#PL900-1): Updated
N=No Y=Yes Y/N Table Edit |
| 18 | PL_STATUS_CD | Character(2) | VARCHAR2(2) NOT NULL |
08/07/98 SCC CN#APRD-R-SCHEW-8L1TB: Change description for value 10 'Before Planning Time Fence' to 'Expedite'
10=Expedite 20=Accepted Horizon 30=After Cutoff Fence 40=No Time Fence Defined 99=Error/Exception |
| 19 | PL_PO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order Type
E=Existing Orders N=Planned Order |
| 20 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 21 | OVERRIDE_SUGG_VNDR | Character(1) | VARCHAR2(1) NOT NULL |
Override Suggested Vendor
Y/N Table Edit Default Value: N |
| 22 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 23 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 24 | CHNG_DTTM | DateTime(26) | TIMESTAMP | Change Request Date/Time |
| 25 | PL_PO_SCHED | Character(200) | VARCHAR2(200) NOT NULL | Purchase Order Sched |
| 26 | EP_GROUP_CODE | Character(6) | VARCHAR2(6) NOT NULL | Group Code |
| 27 | RESPONSE_AGENT | Character(3) | VARCHAR2(3) NOT NULL |
Planning System
ERA=Enterprise Planning PRA=Production Planning |