Reporting View Target: INVOICE_TAX

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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name

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

NA

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

FARINTX_CONVERT_REBATE_AMT

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

FARINTX_CONVERT_TAX_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

PAY_TAX_TO Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority.
FARINTX

FARINTX_PAY_TAX_TO

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

NA

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

FARINTX_REBATE_AMT

REBATE_PERCENT Percent of the tax to be rebated.
FARINTX

FARINTX_REBATE_PERCENT

RULE_CLASS Accounting transaction code defining rules used to control transaction updates to the ledgers.
FARINTX

FARINTX_RUCL_CODE

RULE_CLASS_DESC Unique title assigned to a rule class.
FTVRUCL

FTVRUCL_CLASS_TITLE

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

FARINTX_SEQ_NUM

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

FARINTX_TAXABLE_AMT

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

FARINTX_TAX_AMT

TAX_RATE Code representing the tax rate.
FARINTX

FARINTX_TRAT_CODE

TAX_RATE_DESC Tax rate description or title.
FTVTRAT

FTVTRAT_DESC

Ver: 8.3

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

ODS Column	ODS Business Definition	Banner Source Name	Banner Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	NA	NA
CONVERTED_REBATE_AMOUNT	Base currency rebate amount due to the institution for a specific tax rate.	FARINTX	FARINTX_CONVERT_REBATE_AMT
CONVERTED_TAX_AMOUNT	Base currency tax amount for each a specific tax rate.	FARINTX	FARINTX_CONVERT_TAX_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
PAY_TAX_TO	Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority.	FARINTX	FARINTX_PAY_TAX_TO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	NA	NA
REBATE_AMOUNT	Contains the rebate amount due to the institution for a specific tax rate.	FARINTX	FARINTX_REBATE_AMT
REBATE_PERCENT	Percent of the tax to be rebated.	FARINTX	FARINTX_REBATE_PERCENT
RULE_CLASS	Accounting transaction code defining rules used to control transaction updates to the ledgers.	FARINTX	FARINTX_RUCL_CODE
RULE_CLASS_DESC	Unique title assigned to a rule class.	FTVRUCL	FTVRUCL_CLASS_TITLE
SEQUENCE_NUMBER	System-generated one-up number to support split accounting within a document.	FARINTX	FARINTX_SEQ_NUM
TAXABLE_AMOUNT	Amount that is multiplied by the tax rate to give tax amount.	FARINTX	FARINTX_TAXABLE_AMT
TAX_AMOUNT	Amount of tax computed or entered for a document tax rate.	FARINTX	FARINTX_TAX_AMT
TAX_RATE	Code representing the tax rate.	FARINTX	FARINTX_TRAT_CODE
TAX_RATE_DESC	Tax rate description or title.	FTVTRAT	FTVTRAT_DESC