Go To View:  RETURN TO REPORTING VIEW 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 at an item or 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 Definition Database Data Type Source Name Source Column
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 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

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

FARINTX

FARINTX_CONVERT_TAX_AMT

INVOICE Invoice document number. VARCHAR2(63)

FARINTX

FARINTX_INVH_CODE

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

FARINTX

FARINTX_ITEM

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

NA

NA

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

NA

NA

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-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

FARINTX

FARINTX_REBATE_AMT

REBATE_PERCENT Percent of the tax to be rebated. NUMBER

FARINTX

FARINTX_REBATE_PERCENT

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

FARINTX

FARINTX_RUCL_CODE

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

FTVRUCL

FTVRUCL_CLASS_TITLE

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

FARINTX

FARINTX_SEQ_NUM

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

FARINTX

FARINTX_TAXABLE_AMT

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

FARINTX

FARINTX_TAX_AMT

TAX_RATE Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE_DESC Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC



Ver: 8.1