IN_VMI_RPLN_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 PROCESS_CNTRL Character(1) VARCHAR2(1) NOT NULL Process Control
1=Create Replenishment Requests
2=Process Reviewed Requests
3=Create and Process Requests
5 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUVM_NONVW

6 TO_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field

Prompt Table: SP_BUVM_NONVW

7 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
N=Specific Business Unit
Y=All Business Units

Y/N Table Edit

Default Value: N

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

Prompt Table: OM_BU_NONVW

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

Y/N Table Edit

Default Value: N

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

Prompt Table: %EDITTABLE6
Set Control Field: VMI_OM_BU

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

Prompt Table: %EDITTABLE6
Set Control Field: VMI_OM_BU

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

Prompt Table: %EDITTABLE7
Set Control Field: VMI_OM_BU

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

Prompt Table: %EDITTABLE7
Set Control Field: VMI_OM_BU

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

Prompt Table: %EDITTABLE8
Set Control Field: BUSINESS_UNIT_IN

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

Prompt Table: %EDITTABLE8
Set Control Field: BUSINESS_UNIT_IN

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

Prompt Table: REPLEN_CLS_INV
Set Control Field: BUSINESS_UNIT_IN

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

Y/N Table Edit

Default Value: Y

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

Default Value: N

20 PROCESS_DATE Date(10) DATE Process Date

Prompt Table: INV_REPLN_VW

21 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

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

Default Value: N

23 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
24 UPDATE_STATISTICS Character(1) VARCHAR2(1) NOT NULL Update Statistic

Y/N Table Edit

Default Value: Y

25 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.
26 DESCR Character(30) VARCHAR2(30) NOT NULL Description
27 SELECT_CUST Character(1) VARCHAR2(1) NOT NULL Select Customer
H=Select Ship to Cust range
O=Select Sold to Cust range