RPLN_RQST_INVMI (SQL Table)	Index Back
VMI Replenishment Requests

RPLN_RQST_INVMI

(SQL Table)

VMI Replenishment Requests

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

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

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

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

9 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

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

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

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

13 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

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

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

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

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

18 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 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	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
6	REPLENISH_CLASS	Character(4)	VARCHAR2(4) NOT NULL	Replenish Class
7	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: VMI_CUSTSLD2_VW
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
9	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
10	REORDER_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Reorder Qty
11	VMI_REPLEN_UOM	Character(3)	VARCHAR2(3) NOT NULL	Replenishment UOM Prompt Table: IN_SHP_UOM_VW1
12	REORDER_QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Reorder Qty
13	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
14	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
15	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
16	REVIEW_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Review Status D=Delete I=In Process P=Pending Review R=Reviewed U=Unreviewed Z=Processed
17	OPRID_REVIEWED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
18	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.