VCHR_NONWTHD_VW

(SQL View)
 Index Back

Non WTHD Distribution Amounts


SELECT V.BUSINESS_UNIT , V.VOUCHER_ID , V.TXN_CURRENCY_CD , SUM(CASE WHEN V.WTHD_SW = 'N' THEN D.EXD_TAX_AMT ELSE 0 END) , SUM(CASE WHEN V.WTHD_SW = 'N' THEN D.FREIGHT_AMT + D.FREIGHT_AMT_NP ELSE 0 END) , SUM(CASE WHEN V.WTHD_SW = 'N' THEN D.MISC_AMT + D.MISC_AMT_NP ELSE 0 END) , SUM(CASE WHEN V.WTHD_SW = 'N' THEN D.DSCNT_AMT + D.DSCNT_AMT_NP ELSE 0 END) , SUM(CASE WHEN V.WTHD_SW = 'N' THEN D.SALETX_AMT + D.SALETX_AMT_NP + D.STX_TAX_AMT ELSE 0 END) , SUM(CASE WHEN V.WTHD_SW = 'N' THEN D.VAT_INV_AMT ELSE 0 END) FROM PS_VOUCHER_LINE V , PS_DISTRIB_LINE D WHERE D.BUSINESS_UNIT = V.BUSINESS_UNIT AND D.VOUCHER_ID = V.VOUCHER_ID AND D.VOUCHER_LINE_NUM = V.VOUCHER_LINE_NUM GROUP BY V.BUSINESS_UNIT , V.VOUCHER_ID , V.TXN_CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
4 EXS_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Sales Tax Amount
5 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
6 MISC_CHG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL 11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement
7 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
8 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
9 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.