IN_DEL_PKG_FRT

(SQL Table)
Index Back

Delivery Package Freight

Delivery Package Freight stores freight information at the package level by freighting application.

# 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 IN_PACKAGE_ID Character(20) VARCHAR2(20) NOT NULL Package ID
4 FREIGHT_APP Character(2) VARCHAR2(2) NOT NULL Identifier with regards to which product calculated freight for a delivery
IN=Inventory
OM=Order Management
5 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
6 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 FRT_CHRG_AUDIT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
8 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override

Y/N Table Edit

Default Value: N

9 FRT_CHRG_OPEN Character(1) VARCHAR2(1) NOT NULL Freight can be modified

Default Value: Y

10 COMM_ARRV_DTTM DateTime(26) TIMESTAMP Communicated Arrival Datetime
11 COMM_SHIP_DTTM DateTime(26) TIMESTAMP Communicated Ship Datetime
12 FRT_REF_NO Character(30) VARCHAR2(30) NOT NULL Freight Reference Number
13 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
14 EXT_PKG_ID Character(30) VARCHAR2(30) NOT NULL External Packaging ID