DESTIN_BUPrompt Table: SP_BUVM_NONVW
VMI_OM_BUIN_VMI_SHPBU_VW(SQL View) |
Index Back |
|---|---|
VMI Shipto BU ViewView used to select the VMI OM BU for customers who have storage locations defined |
| SELECT DISTINCT A.BUSINESS_UNIT , A.VMI_OM_BU FROM PS_IN_STOR_LOC_VMI A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL |
Destination Unit
Prompt Table: SP_BUVM_NONVW |
| 2 | VMI_OM_BU |
Character(5) | VARCHAR2(5) NOT NULL | OM Business Unit Related to VMI |