Reporting View Target: INVOICE_TAX

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

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