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

SGHE Banner Operational Data Store
Reporting View Target: INVOICE_ACCOUNTING_TAX_RATE

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

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