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

Description Contains tax rates, amounts, and rebates as it relates to the invoice item level. This includes who the tax should be paid to.
Key & Frequency One row per invoice per item per per tax rate.
Recommended Search Columns INVOICE, ITEM

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
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_AMOUNT Converted Rebate Amount Base currency rebate amount due to the institution for a specific tax rate. NUMBER  

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_TAX_AMOUNT Converted Tax Amount Base currency tax amount for each a specific tax rate. NUMBER  

FARINTX

FARINTX_CONVERT_TAX_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

PAY_TAX_TO Pay Tax To Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority. VARCHAR2(63)  

FARINTX

FARINTX_PAY_TAX_TO

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_AMOUNT Rebate Amount Contains the rebate amount due to the institution for a specific tax rate. NUMBER  

FARINTX

FARINTX_REBATE_AMT

REBATE_PERCENT Rebate Percent Percent of the tax to be rebated. NUMBER  

FARINTX

FARINTX_REBATE_PERCENT

RULE_CLASS Rule Class Accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)  

FARINTX

FARINTX_RUCL_CODE

RULE_CLASS_DESC Rule Class Description Unique title assigned to a rule class. VARCHAR2(255)  

FTVRUCL

FTVRUCL_CLASS_TITLE

SEQUENCE_NUMBER Sequence Number System-generated one-up number to support split accounting within a document. NUMBER  

FARINTX

FARINTX_SEQ_NUM

TAXABLE_AMOUNT Taxable Amount Amount that is multiplied by the tax rate to give tax amount. NUMBER  

FARINTX

FARINTX_TAXABLE_AMT

TAX_AMOUNT Tax Amount Amount of tax computed or entered for a document tax rate. NUMBER  

FARINTX

FARINTX_TAX_AMT

TAX_RATE Tax Rate Code representing the tax rate. VARCHAR2(63)  

FARINTX

FARINTX_TRAT_CODE

TAX_RATE_DESC Tax Rate Description Tax rate description or title. VARCHAR2(255)  

FTVTRAT

FTVTRAT_DESC



Ver: 9.0