BI_LINE_DTAX_VW

(SQL View)
 Index Back

Bill Line Tax Calculation View


SELECT line.business_unit , line.invoice , line.line_seq_num , line.tax_cd , taxauth.tax_pct , taxauth.tax_authority_cd FROM ps_bi_line line , PS_BI_HDR hdr , ps_tax_cd tax , ps_tax_authority taxauth WHERE line.business_unit = hdr.business_unit AND line.invoice = hdr.invoice AND tax.setid = ( SELECT DISTINCT setid FROM ps_set_cntrl_rec WHERE setcntrlvalue = line.business_unit AND recname = 'TAX_CD') AND taxauth.setid = tax.setid AND tax.tax_authority_cd = taxauth.tax_authority_cd AND line.tax_cd = tax.tax_cd AND taxauth.effdt = ( SELECT MAX(effdt) FROM ps_tax_authority WHERE setid = taxauth.setid AND tax_authority_cd = taxauth.tax_authority_cd AND effdt <= hdr.invoice_dt) AND taxauth.eff_status = 'A'

# 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 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
5 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent
6 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority