BI_GTA_TX_RT_VW (SQL View)	Index Back
BI_GTA_TX_VW VAT tax view for Golden Tax Adapter

BI_GTA_TX_RT_VW

(SQL View)

BI_GTA_TX_VW

VAT tax view for Golden Tax Adapter

SELECT A.SETID , A.TAX_CD , SUM(B.TAX_PCT)/100 AS TAX_RT_SUM FROM %Table(TAX_CD) A , %Table(TAX_AUTHORITY) B WHERE A.SETID = B.SETID AND A.TAX_AUTHORITY_CD = B.TAX_AUTHORITY_CD AND %EffdtCheck(TAX_AUTHORITY, B ,%currentdatein) AND B.EFF_STATUS = 'A' GROUP BY A.SETID, A.TAX_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

3 TAX_RT_SUM Number(10,4) DECIMAL(9,4) NOT NULL Tax Rate Summation

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
3	TAX_RT_SUM	Number(10,4)	DECIMAL(9,4) NOT NULL	Tax Rate Summation