Reporting View Target: REIMBURSEMENT_ITEM

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

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 Local Source Local Target

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

ACTUAL_TAX_AMOUNT

NO
NO

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

NA

NO
NO

CALCULATED_TAX_AMOUNT Tax amount calculated in base currency. NUMBER
FTPRETAX

CALCULATED_TAX_AMOUNT

NO
NO

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

FTPREXPS_ID

NO
NO

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

ID

NO
NO

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

NA

NO
NO

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

NA

NO
NO

PAY_TAX_AMOUNT Tax amount calculated in pay currency. NUMBER
FTPRETAX

PAY_TAX_AMOUNT

NO
NO

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

NA

NO
NO

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

FTVTRAT_RATE

NO
NO

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

TGRP_CODE

NO
NO

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

FTVTGRP_DESC

NO
NO

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

ACTIVITY_DATE

NO
NO

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

DATA_ORIGIN

NO
NO

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

USER_ID

NO
NO

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

TAX_RATE_CODE

NO
NO

TAX_RATE_DESC Tax rate description. VARCHAR2(255)
FTVTRAT

FTVTRAT_DESC

NO
NO

Ver: 9.2

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	Local Source	Local Target
ACTUAL_TAX_AMOUNT	Receipt tax portion of the entered receipt amount.	NUMBER	FTPRETAX	ACTUAL_TAX_AMOUNT	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CALCULATED_TAX_AMOUNT	Tax amount calculated in base currency.	NUMBER	FTPRETAX	CALCULATED_TAX_AMOUNT	NO	NO
EXPENSE_ITEM_KEY	Unique internal identification number of the expense tax item record.	NUMBER	FTPRETAX	FTPREXPS_ID	NO	NO
EXPENSE_TAX_ITEM_KEY	Unique internal identification number of the expense tax item record.	NUMBER	FTPRETAX	ID	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PAY_TAX_AMOUNT	Tax amount calculated in pay currency.	NUMBER	FTPRETAX	PAY_TAX_AMOUNT	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
RATE	Sales or or use tax withholding rate expressed as a percentage.	VARCHAR2(63)	FTVTRAT	FTVTRAT_RATE	NO	NO
TAX_GROUP	Tax group associated with the expense type and tax locale.	VARCHAR2(63)	FTPREXPS	TGRP_CODE	NO	NO
TAX_GROUP_DESC	Tax group associated with the tax locale.	VARCHAR2(255)	FTVTGRP	FTVTGRP_DESC	NO	NO
TAX_ITEM_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTPRETAX	ACTIVITY_DATE	NO	NO
TAX_ITEM_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	FTPRETAX	DATA_ORIGIN	NO	NO
TAX_ITEM_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FTPRETAX	USER_ID	NO	NO
TAX_RATE	Tax rate code used to caluclate the tax amount.	VARCHAR2(63)	FTPRETAX	TAX_RATE_CODE	NO	NO
TAX_RATE_DESC	Tax rate description.	VARCHAR2(255)	FTVTRAT	FTVTRAT_DESC	NO	NO