IN_FRT_PACK

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
3 PKG_SEQ_NBR Character(1) VARCHAR2(1) NOT NULL Package Sequence Number
4 PKG_TYPE Character(10) VARCHAR2(10) NOT NULL Package Type
5 REVIEW Character(1) VARCHAR2(1) NOT NULL Review
6 RESULTS_FLG Character(1) VARCHAR2(1) NOT NULL Results
7 PRIOR_TO_UPD_FLG Character(1) VARCHAR2(1) NOT NULL Prior to Update
8 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
9 UOM_WEIGHT Character(3) VARCHAR2(3) NOT NULL Weight UOM
10 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
11 IN_FRT_EST_AMT Number(27,3) DECIMAL(26,3) NOT NULL Estimate Freight
12 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
13 HEIGHT Number(2,0) SMALLINT NOT NULL Height
14 LENGTH Number(5,0) INTEGER NOT NULL Length
15 WIDTH Number(2,0) SMALLINT NOT NULL Width
16 DIM_UOM Character(1) VARCHAR2(1) NOT NULL Dim UOM