| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Shipping Container ID
Default Value: NEXT
Prompt Table:
SHIP_CNTR_HDR
|
| 3 |
CONTAINER_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Container Type
Prompt Table:
CNTR_TYPE_INV
|
| 4 |
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
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 7 |
STOCK_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stock Type
F=Finished
R=Raw Mtrl
W=WIP
|
| 8 |
SHIP_HEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Ship Height
|
| 9 |
SHIP_LENGTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Ship Length
|
| 10 |
SHIP_WIDTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Ship Width
|
| 11 |
MAX_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Max Weight Capacity
|
| 12 |
EMPTY_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Empty Weight
|
| 13 |
UNIT_MEASURE_DIM |
Character(3) |
VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table:
UNITS_TBL
|
| 14 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 15 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 16 |
OWNER |
Character(20) |
VARCHAR2(20) NOT NULL |
Asset Owner
|
| 17 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 18 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 19 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 20 |
FREIGHT_CURRNCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 21 |
FRT_CHRG_AUDIT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Freight Charge
|
| 22 |
FRT_CHRG_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Charge Override
Y/N Table Edit
Default Value: N
|
| 23 |
NET_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Net Weight
|
| 24 |
GROSS_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Weight
|
| 25 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 26 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 27 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 28 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 29 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 30 |
PARENT_SHIP_CNTR |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Shipping Container ID
|
| 31 |
OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Method
A=Append
O=Override
Y/N Table Edit
Default Value: N
|
| 32 |
GROSS_WEIGHT_USER |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Weight
|
| 33 |
UNIT_MEASR_WT_USER |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 34 |
ARRIVAL_DATE |
Date(10) |
DATE |
Arrival Date
|
| 35 |
FRT_REF_NO |
Character(30) |
VARCHAR2(30) NOT NULL |
Freight Reference Number
|
| 36 |
EXT_PKG_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
External Packaging ID
|
| 37 |
OVERSIZED |
Character(1) |
VARCHAR2(1) NOT NULL |
Oversized Item
Y/N Table Edit
Default Value: N
|
| 38 |
ADD_HANDLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Handling
Y/N Table Edit
Default Value: N
|
| 39 |
OUTER_MOST_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Shipping Container ID
|