IN_VMI_LOC_VW

(SQL View)
 Index Back

Inventory Locations

Inventory Locations

SELECT A.BUSINESS_UNIT , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_TYPE , A.ASRS_ID , A.STOR_LOC_TYPE , A.LOC_HEIGHT , A.LOC_LENGTH , A.LOC_WIDTH , A.CUR_LOC_VOLUME , A.CUBIC_CHK_FLG , A.SUSPEND_FLG , A.PHYS_CYC_INV_FLG , A.WT_CAPACITY , A.CUR_LOC_WEIGHT , A.WEIGHT_CHK_FLG , A.ITEM_SELECTION , A.INV_ITEM_ID , A.NETTABLE_FLG , A.NON_OWN_FLAG , A.WIP_LOC_FLG , A.AVAIL_STATUS , A.AVAIL_STATUS_TYPE , A.REASON_CD , A.RETEST_DATE , A.INSPECT_FLG , A.DELETE_STORLOC_FLG , B.VMI_OM_BU , B.SHIP_TO_CUST_ID , B.SOLD_TO_CUST_ID , B.REORD_QTY_OPTION , B.STOCKOUT_RATE FROM PS_STOR_LOC_INV A , PS_IN_STOR_LOC_VMI B WHERE %Join(COMMON_KEYS, STOR_LOC_INV A, IN_STOR_LOC_VMI B) AND A.DELETE_STORLOC_FLG <> 'Y'

# 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 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type

Prompt Table: CNTR_TYPE_INV

8 ASRS_ID Number(15,0) DECIMAL(15) NOT NULL ASRS Identifier
9 STOR_LOC_TYPE Character(4) VARCHAR2(4) NOT NULL Storage Location Type

Prompt Table: ST_LOC_TYPE_INV

10 LOC_HEIGHT Number(16,4) DECIMAL(15,4) NOT NULL Location Height
11 LOC_LENGTH Number(16,4) DECIMAL(15,4) NOT NULL Location Length
12 LOC_WIDTH Number(16,4) DECIMAL(15,4) NOT NULL Location Width
13 CUR_LOC_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/1/1999 whs - added
14 CUBIC_CHK_FLG Character(1) VARCHAR2(1) NOT NULL 11/10/1999 whs - added

Y/N Table Edit

Default Value: N

15 SUSPEND_FLG Character(1) VARCHAR2(1) NOT NULL Location Suspend Flag

Y/N Table Edit

Default Value: N

16 PHYS_CYC_INV_FLG Character(1) VARCHAR2(1) NOT NULL In Physical/Cyclic Inventory

Y/N Table Edit

Default Value: N

17 WT_CAPACITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Weight Capacity
18 CUR_LOC_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/10/1999 whs - added
19 WEIGHT_CHK_FLG Character(1) VARCHAR2(1) NOT NULL 11/10/1999 whs - added

Y/N Table Edit

Default Value: N

20 ITEM_SELECTION Character(1) VARCHAR2(1) NOT NULL Item Selection
M=Multiple Items
S=Single Item

Default Value: M

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

Prompt Table: BU_ITM_INV_VW10

22 NETTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Nettable

Y/N Table Edit

Default Value: Y

23 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

Y/N Table Edit

Default Value: N

24 WIP_LOC_FLG Character(1) VARCHAR2(1) NOT NULL WIP Location Flag

Y/N Table Edit

Default Value: N

25 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected

Default Value: 1

26 AVAIL_STATUS_TYPE Character(4) VARCHAR2(4) NOT NULL Status Type

Prompt Table: QUARANTINE_INV

27 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: INV_STAT_RSN_VW

28 RETEST_DATE Date(10) DATE Retest Date
29 INSPECT_FLG Character(1) VARCHAR2(1) NOT NULL Inspection Location

Y/N Table Edit

Default Value: N

30 DELETE_STORLOC_FLG Character(1) VARCHAR2(1) NOT NULL The Storage Location Delete Flag, if checked, indicates that the storage location is no longer active and ready for permanent deletion.

Default Value: N

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

Prompt Table: OM_BU_NONVW

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

Prompt Table: VMI_CUSTSHP2_VW

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

Prompt Table: VMI_CUSTSLD2_VW

34 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
35 STOCKOUT_RATE Number(4,1) DECIMAL(3,1) NOT NULL Desired Stock-In Probability