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 Name Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE
NA

SYSDATE

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

NA

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_REBATE_AMT

INVOICE Invoice Invoice document number. VARCHAR2(63)
FARINTX

FARINTX_INVH_CODE

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

FARINTX_ITEM

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

NA

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

NA

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

NA

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

FARINTX_REBATE_AMT

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

FARINTX_REBATE_AMT

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

FARINTX_REBATE_AMT

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

FARINTX_REBATE_AMT

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

FARINTX_REBATE_AMT

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

FARINTX_REBATE_AMT

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

FARINTX_REBATE_AMT

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

FARINTX_REBATE_AMT

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

FARINTX_TRAT_CODE

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

FARINTX_TRAT_CODE

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

FARINTX_TRAT_CODE

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

FARINTX_TRAT_CODE

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

FARINTX_TRAT_CODE

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

FARINTX_TRAT_CODE

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

FARINTX_TRAT_CODE

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

FARINTX_TRAT_CODE

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

FTVTRAT_DESC

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

FTVTRAT_DESC

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

FTVTRAT_DESC

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

FTVTRAT_DESC

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

FTVTRAT_DESC

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

FTVTRAT_DESC

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

FTVTRAT_DESC

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

FTVTRAT_DESC

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