Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Travel And Expense Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: REIMBURSEMENT_ITEM_TAX

Description Contains a breakdown of the taxes used on the expense report item. The tax rate code, tax rate, receipt tax portion, tax amount in base currency, and tax amount in pay currency.
Key & Frequency One row per reimbursement per reimbursement item per tax_rate.
Recommended Search Columns EXPENSE_ITEM_KEY
EXPENSE_TAX_ITEM_KEY
RATE

Target Column Business Definition Database Data Type Source Name Source Column
ACTUAL_TAX_AMOUNT Receipt tax portion of the entered receipt amount. NUMBER

FTPRETAX

ACTUAL_TAX_AMOUNT

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

NA

NA

CALCULATED_TAX_AMOUNT Tax amount calculated in base currency. NUMBER

FTPRETAX

CALCULATED_TAX_AMOUNT

EXPENSE_ITEM_KEY Unique internal identification number of the expense tax item record. NUMBER

FTPRETAX

FTPREXPS_ID

EXPENSE_TAX_ITEM_KEY Unique internal identification number of the expense tax item record. NUMBER

FTPRETAX

ID

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

PAY_TAX_AMOUNT Tax amount calculated in pay currency. NUMBER

FTPRETAX

PAY_TAX_AMOUNT

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

NA

NA

RATE Sales or or use tax withholding rate expressed as a percentage. VARCHAR2(63)

FTVTRAT

FTVTRAT_RATE

TAX_GROUP Tax group associated with the expense type and tax locale. VARCHAR2(63)

FTPREXPS

TGRP_CODE

TAX_GROUP_DESC Tax group associated with the tax locale. VARCHAR2(255)

FTVTGRP

FTVTGRP_DESC

TAX_ITEM_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FTPRETAX

ACTIVITY_DATE

TAX_ITEM_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(63)

FTPRETAX

DATA_ORIGIN

TAX_ITEM_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FTPRETAX

USER_ID

TAX_RATE Tax rate code used to caluclate the tax amount. VARCHAR2(63)

FTPRETAX

TAX_RATE_CODE

TAX_RATE_DESC Tax rate description. VARCHAR2(255)

FTVTRAT

FTVTRAT_DESC



Ver: 8.5