Reporting View Target: INVOICE_ACCOUNTING_TAX

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

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

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