Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_INVOICE_TAX_RATE

Description Source composite view contains tax rate information for invoices.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
CONVERTED_REBATE_AMOUNT Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

NO

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

FARINTX

FARINTX_CONVERT_TAX_AMT

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
INVOICE Invoice document number. VARCHAR2(8)

FARINTX

FARINTX_INVH_CODE

NO

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

FARINTX

FARINTX_ITEM

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
PAY_TAX_TO Indicates who should be paid taxes, always the vendor, vendor if they collect taxes or taxing authority. VARCHAR2(1)

FARINTX

FARINTX_PAY_TAX_TO

NO

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

FARINTX

FARINTX_REBATE_AMT

NO

NO
REBATE_PERCENT Percent of the tax to be rebated. NUMBER

FARINTX

FARINTX_REBATE_PERCENT

NO

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

FARINTX

FARINTX_RUCL_CODE

NO

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

FTVRUCL

FTVRUCL_CLASS_TITLE

NO

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

FARINTX

FARINTX_SEQ_NUM

NO

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

FARINTX

FARINTX_TAXABLE_AMT

NO

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

FARINTX

FARINTX_TAX_AMT

NO

NO
TAX_RATE Code representing the tax rate. VARCHAR2(4)

FARINTX

FARINTX_TRAT_CODE

NO

NO
TAX_RATE_DESC Tax rate description or title. VARCHAR2(35)

FTVTRAT

FTVTRAT_DESC

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: