OM_DEL_FRT_VW

(SQL View)
Index Back

Delivery freight data

IN_DELIVERY_FRT view for freight application = 'OM'

SELECT P.BUSINESS_UNIT , P.DELIVERY_ID , P.FREIGHT_APP , %subrec(IN_DEL_FRT_SBR, P) , 'N' , 'N' FROM PS_IN_DELIVERY_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 FREIGHT_APP Character(2) VARCHAR2(2) NOT NULL Identifier with regards to which product calculated freight for a delivery
IN=Inventory
OM=Order Management

Default Value: IN

4 COMM_ARRV_DTTM DateTime(26) TIMESTAMP Communicated Arrival Datetime
5 COMM_SHIP_DTTM DateTime(26) TIMESTAMP Communicated Ship Datetime
6 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag

Default Value: N

7 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
8 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 FRT_CHRG_AUDIT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
10 FRT_CHRG_OPEN Character(1) VARCHAR2(1) NOT NULL Freight can be modified

Y/N Table Edit

Default Value: Y

11 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override

Y/N Table Edit

Default Value: N

12 FRT_ROLLUP_IND Character(1) VARCHAR2(1) NOT NULL Freight Rollup Flag
1=Delivery
2=Rollup

Default Value: 1

13 FRT_REF_NO Character(30) VARCHAR2(30) NOT NULL Freight Reference Number
14 EXT_SHIP_ID Character(30) VARCHAR2(30) NOT NULL External Shipment Identifier
15 FRT_SRVC_DEFN Character(50) VARCHAR2(50) NOT NULL Freight Service Definition

Prompt Table: %EDITTABLE10

16 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code

Prompt Table: IN_FRT_DFLT

17 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
18 IN_FRT_USAGE Character(2) VARCHAR2(2) NOT NULL Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both
19 RATE_SHOPPED Character(1) VARCHAR2(1) NOT NULL Delivery is Rate Shopped

Y/N Table Edit

Default Value: N

20 FREIGHT_NET_PRC Signed Number(29,4) DECIMAL(27,4) NOT NULL Freight Net Value
21 FREIGHT_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Freight Net Value (base)
22 FREIGHT_QUANTITY Number(17,4) DECIMAL(16,4) NOT NULL Freight Quantity
23 FREIGHT_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Volume
24 FREIGHT_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Weight
25 OVERRIDE_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Override Volume
26 OVERRIDE_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Override Weight
27 TOTAL_NBR_PIECES Number(6,0) INTEGER NOT NULL Total Number of Pieces
28 NEW_RECORD Character(1) VARCHAR2(1) NOT NULL New Record Flag

Default Value: N

29 SQL_ACTION Character(1) VARCHAR2(1) NOT NULL SQL Action to Take
D=Delete
I=Insert
N=No Action
U=Update

Default Value: N