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
|
12 | TO_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_VMI_ITEM_VW2
|
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 |