IN_STOR_LOC_VMI(SQL Table) |
Index Back |
|---|---|
Inventory LocationsInventory Locations |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | STORAGE_AREA |
Character(5) | VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table: STOR_AREA_INV |
| 3 | STOR_LEVEL_1 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 4 | STOR_LEVEL_2 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 5 | STOR_LEVEL_3 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 6 | STOR_LEVEL_4 |
Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 7 | VMI_OM_BU | Character(5) | VARCHAR2(5) NOT NULL |
OM Business Unit Related to VMI
Prompt Table: OM_BU_NONVW |
| 8 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: VMI_CUSTSHP2_VW |
| 9 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table: VMI_CUSTSLD2_VW |
| 10 | REORD_QTY_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Reorder Point Order Quantities
1=EOQ 2=Min/Max 3=AOQ 4=Static Reorder Qty 5=Demand Quantity 99=Use Business Unit Default |
| 11 | STOCKOUT_RATE | Number(4,1) | DECIMAL(3,1) NOT NULL |
Desired Stock-In Probability
Prompt Table: STKOUT_RATE_INV |