PO_REPLEN_IN_VW (SQL View)	Index Back
PO View For INV Repenishment

PO_REPLEN_IN_VW

(SQL View)

PO View For INV Repenishment

SELECT DISTINCT business_unit , 'BIN' , replenish_id , replen_status FROM PS_REPLEN_RQST_INV WHERE replen_status = '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LOADER_BU Character(5) VARCHAR2(5) NOT NULL Requesting Loader Bus Unit

2 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.

3 REPLENISH_ID Number(10,0) DECIMAL(10) NOT NULL Replenish ID

4 REPLEN_STATUS Character(1) VARCHAR2(1) NOT NULL Replenish Status
1=Ready
2=Error
3=In Process
4=Processed
5=Canceled

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LOADER_BU	Character(5)	VARCHAR2(5) NOT NULL	Requesting Loader Bus Unit
2	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.
3	REPLENISH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Replenish ID
4	REPLEN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Replenish Status 1=Ready 2=Error 3=In Process 4=Processed 5=Canceled