RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Operational Data Store
Reporting View Target: INVOICE_TAX_RATE_SLOT

Description Uses data from the INVOICE_TAX_RATE reporting view. Displays the last 8 tax rates, amounts and rebates applied to each invoice and item.
Key & Frequency One row per invoice per item listing up to 8 tax rates for each item.
Recommended Search Columns INVOICE, ITEM
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated DATE

NA

SYSDATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

CONVERTED_REBATE_AMOUNT1 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_REBATE_AMOUNT2 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_REBATE_AMOUNT3 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_REBATE_AMOUNT4 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_REBATE_AMOUNT5 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_REBATE_AMOUNT6 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_REBATE_AMOUNT7 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

CONVERTED_REBATE_AMOUNT8 Base currency rebate amount due to the institution for a specific tax rate. NUMBER

FARINTX

FARINTX_CONVERT_REBATE_AMT

INVOICE Invoice document number. VARCHAR2(63)

FARINTX

FARINTX_INVH_CODE

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

FARINTX

FARINTX_ITEM

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

NA

NA

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

NA

NA

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

NA

NA

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

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

FARINTX

FARINTX_REBATE_AMT

TAX_RATE1 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE2 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE3 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE4 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE5 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE6 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE7 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE8 Code representing the tax rate. VARCHAR2(63)

FARINTX

FARINTX_TRAT_CODE

TAX_RATE_DESC1 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC

TAX_RATE_DESC2 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC

TAX_RATE_DESC3 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC

TAX_RATE_DESC4 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC

TAX_RATE_DESC5 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC

TAX_RATE_DESC6 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC

TAX_RATE_DESC7 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC

TAX_RATE_DESC8 Tax rate description or title. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC



Ver: 3.1