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

SGHE Banner Operational Data Store
Composite View Target: AF_INVOICE_TAX_RATE

Description Source composite view contains tax rate information for invoices.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
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

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

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
INVOICE Invoice document number.    

FARINTX

FARINTX_INVH_CODE

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

FARINTX

FARINTX_ITEM

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record 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

 
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

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

NA

NA

 


Ver: 8.3