RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE 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
CONVERTED_REBATE_AMOUNT Base currency rebate amount due to the institution for a specific tax rate. NUMBER(12, 2)

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_TAX_AMOUNT Base currency tax amount for each a specific tax rate. NUMBER(12, 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 Contains the rebate amount due to the institution for a specific tax rate. NUMBER(12, 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 Amount that is multiplied by the tax rate to give tax amount. NUMBER(12, 2)

FARINTX

FARINTX_TAXABLE_AMT

TAX_AMOUNT Amount of tax computed or entered for a document tax rate. NUMBER(12, 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: 3.1