| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FRT_SRVC_DEFN |
Character(50) |
VARCHAR2(50) NOT NULL |
Freight Service Definition
|
| 2 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 3 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 4 |
SERVICE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Description
|
| 5 |
FREIGHT_AMT_TOT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 7 |
SHIPPING_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Weight
|
| 8 |
SHIPPING_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Volume
|
| 9 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
|
| 10 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
|
| 11 |
TOTAL_NBR_PIECES |
Number(6,0) |
INTEGER NOT NULL |
Total Number of Pieces
|
| 12 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 13 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 14 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 15 |
EXT_SHIP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
External Shipment Identifier
|
| 16 |
ERROR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Error Code
|
| 17 |
ERRORMSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Error Message field
|
| 18 |
EIP_TRANS_SRC_SEQ |
Number(15,0) |
DECIMAL(15) NOT NULL |
Source Transaction Sequence
|
| 19 |
DEVICE_DTTIME |
DateTime(26) |
TIMESTAMP |
Device Date Time
|