PL_PO_DISTRBCVW(SQL View) |
Index Back |
|---|---|
PL_PO_DISTRB_VWPL_PO_DISTRB_VW |
| SELECT %subrec(PL_PO_DIST_SBR, B) , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC FROM PS_PL_PO_HDR_C A , PS_PL_PO_DISTRIB_C B WHERE A.PROBINST = B.PROBINST AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROBINST |
Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 6 | DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 7 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 8 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 9 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 10 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 11 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 12 | DUE_DTTM | DateTime(26) | TIMESTAMP | Due Datetime |
| 13 | PLAN_DUE_DTTM | DateTime(26) | TIMESTAMP NOT NULL | Planning Due Date/Time |
| 14 | PL_PO_LEAD_TIME | Number(10,0) | DECIMAL(10) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 15 | PLAN_RELEASE_DTTM | DateTime(26) | TIMESTAMP | Plan Release Date Time |
| 16 | ORIG_FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
03/14/02 EGS (CN#PL900-1): Added.
Y/N Table Edit |
| 17 | FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both N=No Y=Yes Y/N Table Edit |
| 18 | ORIG_CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Original Cancel Status |
| 19 | CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Status
A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled |
| 20 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 21 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 22 | QTY_PO_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | PO Quantity Standard |
| 23 | PLAN_QTY_PO_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | 11/01/01 PCL (CN#PL900-1): Added |
| 24 | PURCHASE_YIELD | Number(5,1) | DECIMAL(4,1) NOT NULL | Purchase Yield |
| 25 | ORIG_QTY_MOVED_INV | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Received |
| 26 | QTY_MOVED_INV | Number(16,4) | DECIMAL(15,4) NOT NULL | Received Base |
| 27 | ORIG_QTYAMSHIPSUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Returned |
| 28 | QTY_AM_SHIP_SUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Returned Base |
| 29 | REMAINING_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 JNW (CN#PL900-1.0): Added |
| 30 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 31 | INCL_QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Quantity
B=Both N=No Y=Yes Y/N Table Edit |
| 32 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 33 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 34 | APPROVED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Approved by Auditor
D=Denied N=Not Approved Y=Approved Y/N Table Edit Default Value: N |
| 35 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged Default Value: 40 |
| 36 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 37 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 38 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 39 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 40 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |