IN_VMI_RPRM_REQ

(SQL Table)
Index Back

VMI Replenish Parm Calc Requ.

VMI Replenish Parameters Calc Request

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUVM_NONVW

5 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI

Prompt Table: OM_BU_NONVW

6 ALL_OM_BU Character(1) VARCHAR2(1) NOT NULL All OM Business Units

Y/N Table Edit

Default Value: N

7 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: %EDITTABLE6

8 TO_SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: %EDITTABLE6

9 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: %EDITTABLE7

10 TO_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: %EDITTABLE7

11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_VMI_ITEM_VW2
Set Control Field: BUSINESS_UNIT

12 TO_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_VMI_ITEM_VW2
Set Control Field: BUSINESS_UNIT

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

Prompt Table: REPLEN_CLS_INV

14 REORD_POINT_CALC Character(1) VARCHAR2(1) NOT NULL Reorder Point

Y/N Table Edit

Default Value: N

15 MAX_QTY_CALC Character(1) VARCHAR2(1) NOT NULL Maximum Stock Qty

Y/N Table Edit

Default Value: N

16 SAFETY_STOCK_CALC Character(1) VARCHAR2(1) NOT NULL Safety Stock

Y/N Table Edit

Default Value: N

17 EOQ_CALC Character(1) VARCHAR2(1) NOT NULL EOQ

Y/N Table Edit

Default Value: N

18 ANNUAL_DEMAND_CALC Character(1) VARCHAR2(1) NOT NULL Annual Demand

Y/N Table Edit

Default Value: N

19 REPLEN_LEAD_CALC Character(1) VARCHAR2(1) NOT NULL Replenish Lead

Y/N Table Edit

Default Value: N

20 INCL_CANCELLED Character(1) VARCHAR2(1) NOT NULL Include Cancelled Orders

Y/N Table Edit

Default Value: Y

21 COMMIT_BATCH Number(6,0) INTEGER NOT NULL Commit Batch
22 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

23 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

24 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

Default Value: N

25 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
26 DTTM_STAMP_SEC 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.
27 DESCR Character(30) VARCHAR2(30) NOT NULL Description
28 SELECT_CUST Character(1) VARCHAR2(1) NOT NULL Select Customer
H=Select Ship to Cust range
O=Select Sold to Cust range