# |
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
|