Reporting View Target: REIMBURSEMENT_ITEM

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Neu Schedule Data 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 Name Business Definition Database Data Type Domain Value Source Name Source Column

ACTUAL_TAX_AMOUNT Actual Tax Amount Receipt tax portion of the entered receipt amount. NUMBER
FTPRETAX

ACTUAL_TAX_AMOUNT

ADMINISTRATIVE_GROUP 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 Calculated Tax Amount Tax amount calculated in base currency. NUMBER
FTPRETAX

CALCULATED_TAX_AMOUNT

EXPENSE_ITEM_KEY Expense Item KEY Unique internal identification number of the expense tax item record. NUMBER
FTPRETAX

FTPREXPS_ID

EXPENSE_TAX_ITEM_KEY Expense Tax Item KEY Unique internal identification number of the expense tax item record. NUMBER
FTPRETAX

ID

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

NA

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

NA

PAY_TAX_AMOUNT Pay Tax Amount Tax amount calculated in pay currency. NUMBER
FTPRETAX

PAY_TAX_AMOUNT

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

NA

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

FTVTRAT_RATE

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

TGRP_CODE

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

FTVTGRP_DESC

TAX_ITEM_ACTIVITY_DATE 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 Tax Item Data Origin Source system that created or updated the data. VARCHAR2(63)
FTPRETAX

DATA_ORIGIN

TAX_ITEM_USER_ID 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 Tax rate code used to caluclate the tax amount. VARCHAR2(63)
FTPRETAX

TAX_RATE_CODE

TAX_RATE_DESC Tax Rate Description Tax rate description. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

Ver: 9.0

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 Name	Business Definition	Database Data Type	Source Name	Source Column
ACTUAL_TAX_AMOUNT	Actual Tax Amount	Receipt tax portion of the entered receipt amount.	NUMBER	FTPRETAX	ACTUAL_TAX_AMOUNT
ADMINISTRATIVE_GROUP	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	Calculated Tax Amount	Tax amount calculated in base currency.	NUMBER	FTPRETAX	CALCULATED_TAX_AMOUNT
EXPENSE_ITEM_KEY	Expense Item KEY	Unique internal identification number of the expense tax item record.	NUMBER	FTPRETAX	FTPREXPS_ID
EXPENSE_TAX_ITEM_KEY	Expense Tax Item KEY	Unique internal identification number of the expense tax item record.	NUMBER	FTPRETAX	ID
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PAY_TAX_AMOUNT	Pay Tax Amount	Tax amount calculated in pay currency.	NUMBER	FTPRETAX	PAY_TAX_AMOUNT
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RATE	Rate	Sales or or use tax withholding rate expressed as a percentage.	VARCHAR2(63)	FTVTRAT	FTVTRAT_RATE
TAX_GROUP	Tax Group	Tax group associated with the expense type and tax locale.	VARCHAR2(63)	FTPREXPS	TGRP_CODE
TAX_GROUP_DESC	Tax Group Description	Tax group associated with the tax locale.	VARCHAR2(255)	FTVTGRP	FTVTGRP_DESC
TAX_ITEM_ACTIVITY_DATE	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	Tax Item Data Origin	Source system that created or updated the data.	VARCHAR2(63)	FTPRETAX	DATA_ORIGIN
TAX_ITEM_USER_ID	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	Tax rate code used to caluclate the tax amount.	VARCHAR2(63)	FTPRETAX	TAX_RATE_CODE
TAX_RATE_DESC	Tax Rate Description	Tax rate description.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC