Reporting View Target: INVOICE_TAX_RATE

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: INVOICE_TAX_RATE_SLOT

Description Uses data from the INVOICE_TAX_RATE reporting view. Displays the last 8 tax rates, amounts and rebates applied to each invoice item.
Key & Frequency One row per invoice per item listing up to 8 tax rates for each item.
Recommended Search Columns INVOICE, ITEM
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target

ACTIVITY_DATE Date record was inserted or updated. DATE
NA

SYSDATE

NO
NO

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

NO
NO

CONVERTED_REBATE_AMOUNT1 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

CONVERTED_REBATE_AMOUNT2 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

CONVERTED_REBATE_AMOUNT3 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

CONVERTED_REBATE_AMOUNT4 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

CONVERTED_REBATE_AMOUNT5 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

CONVERTED_REBATE_AMOUNT6 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

CONVERTED_REBATE_AMOUNT7 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

CONVERTED_REBATE_AMOUNT8 Base currency rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_CONVERT_REBATE_AMT

NO
NO

INVOICE Invoice document number. VARCHAR2(63)
FARINTX

FARINTX_INVH_CODE

NO
NO

ITEM Literal commodity or goods associated with an invoice processing record. NUMBER
FARINTX

FARINTX_ITEM

NO
NO

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

NO
NO

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NO
NO

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

NO
NO

REBATE_AMOUNT1 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

REBATE_AMOUNT2 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

REBATE_AMOUNT3 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

REBATE_AMOUNT4 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

REBATE_AMOUNT5 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

REBATE_AMOUNT6 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

REBATE_AMOUNT7 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

REBATE_AMOUNT8 Contains the rebate amount due to the institution for a specific tax rate. NUMBER
FARINTX

FARINTX_REBATE_AMT

NO
NO

TAX_RATE1 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE2 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE3 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE4 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE5 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE6 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE7 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE8 Code representing the tax rate. VARCHAR2(63)
FARINTX

FARINTX_TRAT_CODE

NO
NO

TAX_RATE_DESC1 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

TAX_RATE_DESC2 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

TAX_RATE_DESC3 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

TAX_RATE_DESC4 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

TAX_RATE_DESC5 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

TAX_RATE_DESC6 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

TAX_RATE_DESC7 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

TAX_RATE_DESC8 Tax rate description or title. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

Ver: 9.2

Description	Uses data from the INVOICE_TAX_RATE reporting view. Displays the last 8 tax rates, amounts and rebates applied to each invoice item.
Key & Frequency	One row per invoice per item listing up to 8 tax rates for each item.
Recommended Search Columns	INVOICE, ITEM ACTIVITY_DATE

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CONVERTED_REBATE_AMOUNT1	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
CONVERTED_REBATE_AMOUNT2	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
CONVERTED_REBATE_AMOUNT3	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
CONVERTED_REBATE_AMOUNT4	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
CONVERTED_REBATE_AMOUNT5	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
CONVERTED_REBATE_AMOUNT6	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
CONVERTED_REBATE_AMOUNT7	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
CONVERTED_REBATE_AMOUNT8	Base currency rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_CONVERT_REBATE_AMT	NO	NO
INVOICE	Invoice document number.	VARCHAR2(63)	FARINTX	FARINTX_INVH_CODE	NO	NO
ITEM	Literal commodity or goods associated with an invoice processing record.	NUMBER	FARINTX	FARINTX_ITEM	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REBATE_AMOUNT1	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
REBATE_AMOUNT2	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
REBATE_AMOUNT3	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
REBATE_AMOUNT4	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
REBATE_AMOUNT5	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
REBATE_AMOUNT6	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
REBATE_AMOUNT7	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
REBATE_AMOUNT8	Contains the rebate amount due to the institution for a specific tax rate.	NUMBER	FARINTX	FARINTX_REBATE_AMT	NO	NO
TAX_RATE1	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE2	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE3	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE4	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE5	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE6	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE7	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE8	Code representing the tax rate.	VARCHAR2(63)	FARINTX	FARINTX_TRAT_CODE	NO	NO
TAX_RATE_DESC1	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO
TAX_RATE_DESC2	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO
TAX_RATE_DESC3	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO
TAX_RATE_DESC4	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO
TAX_RATE_DESC5	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO
TAX_RATE_DESC6	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO
TAX_RATE_DESC7	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO
TAX_RATE_DESC8	Tax rate description or title.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO