RPLN_RQST_VMIVW (SQL View)	Index Back
VMI Replenishment Requests

RPLN_RQST_VMIVW

(SQL View)

VMI Replenishment Requests

SELECT BUSINESS_UNIT , VMI_OM_BU , SHIP_TO_CUST_ID , INV_ITEM_ID , REPLENISH_CLASS , DEMAND_SOURCE , SOURCE_BUS_UNIT , SOLD_TO_CUST_ID , REORDER_QTY , VMI_REPLEN_UOM , REORDER_QTY_BASE , UNIT_OF_MEASURE , REVIEW_ACTION , PROCESS_INSTANCE , ORIG_OPRID , OPRID_REVIEWED_BY , LAST_UPDATE_DTTM FROM PS_RPLN_RQST_INVMI

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUVM_NONVW

2 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI
Prompt Table: OM_BU_NONVW

3 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
Prompt Table: VMI_CUSTSHP2_VW

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: IN_VMI_ITEMS

5 REPLENISH_CLASS Character(4) VARCHAR2(4) NOT NULL Replenish Class

6 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

7 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

8 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
Prompt Table: VMI_CUSTSLD2_VW

9 REORDER_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Reorder Qty

10 VMI_REPLEN_UOM Character(3) VARCHAR2(3) NOT NULL Replenishment UOM
Prompt Table: IN_SHP_UOM_VW1

11 REORDER_QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Reorder Qty

12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: UNITS_TBL

13 REVIEW_ACTION Character(1) VARCHAR2(1) NOT NULL Review Status
D=Delete
I=In Process
P=Pending Review
R=Reviewed
U=Unreviewed
Z=Processed

14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

15 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

16 OPRID_REVIEWED_BY Character(30) VARCHAR2(30) NOT NULL Approved By

17 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUVM_NONVW
2	VMI_OM_BU	Character(5)	VARCHAR2(5) NOT NULL	OM Business Unit Related to VMI Prompt Table: OM_BU_NONVW
3	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: VMI_CUSTSHP2_VW
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: IN_VMI_ITEMS
5	REPLENISH_CLASS	Character(4)	VARCHAR2(4) NOT NULL	Replenish Class
6	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
7	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
8	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: VMI_CUSTSLD2_VW
9	REORDER_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Reorder Qty
10	VMI_REPLEN_UOM	Character(3)	VARCHAR2(3) NOT NULL	Replenishment UOM Prompt Table: IN_SHP_UOM_VW1
11	REORDER_QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Reorder Qty
12	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL
13	REVIEW_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Review Status D=Delete I=In Process P=Pending Review R=Reviewed U=Unreviewed Z=Processed
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
16	OPRID_REVIEWED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
17	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.