BI_HD_GST_TX_VW

(SQL View)
 Index Back

BIlling Header GST View


SELECT BUSINESS_UNIT , INVOICE , SUM(CASE WHEN EXS_TAX_CMPNT_CD = 'IGST' THEN EXS_TAX_AMT_BSE ELSE 0 END) , SUM(CASE WHEN EXS_TAX_CMPNT_CD = 'CGST' THEN EXS_TAX_AMT_BSE ELSE 0 END) , SUM(CASE WHEN EXS_TAX_CMPNT_CD = 'SGST' THEN EXS_TAX_AMT_BSE ELSE 0 END) FROM PS_BI_LINE_EXS_DTL GROUP BY BUSINESS_UNIT , INVOICE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 IGST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL IGST Tax Amount
4 CGST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL CGST Tax Amount
5 SGST_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL SGST Tax Amount