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

SGHE 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 Domain Value Source Name Source Column
ACTIVITY_DATE Activity Date Date record was inserted or updated DATE  

NA

SYSDATE

ADMINISTRATIVE_GROUP Administrative Group Organization-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.0