IN_DEL_PKFR_VW

(SQL View)
 Index Back

Delivery Package Freight

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

SELECT P.BUSINESS_UNIT , P.DELIVERY_ID , P.IN_PACKAGE_ID , P.FREIGHT_APP , %subrec(IN_DEL_PKFR_SBR, P) , 'N' , 'N' FROM PS_IN_DEL_PKG_FRT P

# 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
15 NEW_RECORD Character(1) VARCHAR2(1) NOT NULL New Record Flag
16 SQL_ACTION Character(1) VARCHAR2(1) NOT NULL SQL Action to Take
D=Delete
I=Insert
N=No Action
U=Update