INV_CAP_TMP

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
4 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
5 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
6 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
7 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
8 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
9 VOL_CAPACITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Volume Capacity
10 CUR_LOC_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/1/1999 whs - added
11 CUR_LOC_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/10/1999 whs - added
12 WT_CAPACITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Maximum Weight Capacity