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 and 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date record was inserted or updated    

NA

SYSDATE

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_REBATE_AMT

 
INVOICE Invoice document number.    

FARINTX

FARINTX_INVH_CODE

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

FARINTX

FARINTX_ITEM

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

 
TAX_RATE1 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE2 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE3 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE4 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE5 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE6 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE7 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE8 Code representing the tax rate.    

FARINTX

FARINTX_TRAT_CODE

 
TAX_RATE_DESC1 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
TAX_RATE_DESC2 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
TAX_RATE_DESC3 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
TAX_RATE_DESC4 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
TAX_RATE_DESC5 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
TAX_RATE_DESC6 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
TAX_RATE_DESC7 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 
TAX_RATE_DESC8 Tax rate description or title.    

FTVTRAT

FTVTRAT_DESC

 


Ver: 8.3