IN_FL_DFCNT_AET

(SQL Table)
Index Back

Default container info AET

mmt 05/11/05 Created

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type
3 UCC_EAN_CD Character(1) VARCHAR2(1) NOT NULL UCC/EAN Packaging Type
0=Case/Carton
1=Pallet
2=Truckload
3=Undefined
4=Intra-Company
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 SHIP_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Height
6 SHIP_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Length
7 SHIP_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Width
8 MAX_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Max Weight Capacity
9 EMPTY_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Empty Weight
10 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM
11 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
12 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM