OM_DEL_HDFRT_VW

(SQL View)
 Index Back

Summed freight for ord header


SELECT H.BUSINESS_UNIT , H.ORDER_NO , SUM(CASE WHEN D.FREIGHT_CHARGE_CNV IS NULL THEN 0 ELSE D.FREIGHT_CHARGE_CNV END) , SUM(CASE WHEN D.FREIGHT_CHARGE_BSE IS NULL THEN 0 ELSE D.FREIGHT_CHARGE_BSE END) , SUM(CASE WHEN D.FREIGHT_TAX_AMT IS NULL THEN 0 ELSE D.FREIGHT_TAX_AMT END) , SUM(CASE WHEN D.FREIGHT_TAX_BASE IS NULL THEN 0 ELSE D.FREIGHT_TAX_BASE END) , MAX(CASE WHEN D.FREIGHT_TAX_PCT IS NULL THEN 0 ELSE D.FREIGHT_TAX_PCT END) FROM PS_ORD_HEADER H LEFT OUTER JOIN PS_IN_DELIVERY_ORD D ON D.SOURCE_BUS_UNIT = H.BUSINESS_UNIT AND D.ORDER_NO = H.ORDER_NO AND D.DEMAND_SOURCE = 'OM' AND D.CHARGE_TYPE = 'F' AND D.FREIGHT_APP = 'OM' AND D.SHIP_ID = ' ' GROUP BY H.BUSINESS_UNIT , H.ORDER_NO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
4 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)
5 FREIGHT_TAX_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Freight Tax Amount
6 FREIGHT_TAX_BASE Signed Number(17,2) DECIMAL(15,2) NOT NULL Freight Tax Amount Base
7 FREIGHT_TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Freight Tax Percent