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.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
CONVERTED_REBATE_AMOUNT Converted Rebate Amount Base currency rebate amount due to the institution for a specific tax rate. NUMBER(17,2)  

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_TAX_AMOUNT Converted Tax Amount Base currency tax amount for each a specific tax rate. NUMBER(17,2)  

FARINTX

FARINTX_CONVERT_TAX_AMT

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

NA

SYSDATE

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

NA

NA

INVOICE   Invoice document number. VARCHAR2(8)  

FARINTX

FARINTX_INVH_CODE

ITEM   Literal commodity or goods associated with an invoice processing record. NUMBER(4)  

FARINTX

FARINTX_ITEM

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

NA

NA

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

NA

NA

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

REBATE_AMOUNT Rebate Amount Contains the rebate amount due to the institution for a specific tax rate. NUMBER(17,2)  

FARINTX

FARINTX_REBATE_AMT

REBATE_PERCENT   Percent of the tax to be rebated. NUMBER(6, 3)  

FARINTX

FARINTX_REBATE_PERCENT

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

FARINTX

FARINTX_RUCL_CODE

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

FTVRUCL

FTVRUCL_CLASS_TITLE

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

FARINTX

FARINTX_SEQ_NUM

TAXABLE_AMOUNT Taxable Amount Amount that is multiplied by the tax rate to give tax amount. NUMBER(17,2)  

FARINTX

FARINTX_TAXABLE_AMT

TAX_AMOUNT Tax Amount Amount of tax computed or entered for a document tax rate. NUMBER(17,2)  

FARINTX

FARINTX_TAX_AMT

TAX_RATE   Code representing the tax rate. VARCHAR2(4)  

FARINTX

FARINTX_TRAT_CODE

TAX_RATE_DESC   Tax rate description or title. VARCHAR2(35)  

FTVTRAT

FTVTRAT_DESC

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

NA

NA



Ver: