Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

Banner Operational Data Store
Composite View Target: AE_EXPENSE_ITEM_TAX

Description Contains a breakdown of the taxes used on the authorization or expense report item. The tax rate code, tax rate, receipt tax portion, tax amount in base currency, and tax amount in pay currency.

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

FTPRETAX

ACTUAL_TAX_AMOUNT

CALCULATED_TAX_AMOUNT Tax amount calculated in base currency. NUMBER(17,2)

FTPRETAX

CALCULATED_TAX_AMOUNT

CURRENT_DATE This is a the system current date (sysdate). DATE

NA

SYSDATE

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

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

FTPRETAX

FTPREXPS_ID

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

FTPRETAX

ID

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_AMOUNT Tax amount calculated in pay currency. NUMBER(17,2)

FTPRETAX

PAY_TAX_AMOUNT

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

FTVTRAT

FTVTRAT_RATE

TAX_ITEM_ACTIVITY_DATE Date information for this record in the table was entered or last updated. TIMESTAMP(6)

FTPRETAX

ACTIVITY_DATE

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

FTPRETAX

DATA_ORIGIN

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

FTPRETAX

USER_ID

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

FTPRETAX

TAX_RATE_CODE

TAX_RATE_DESC Tax rate description. VARCHAR2(35)

FTVTRAT

FTVTRAT_DESC

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: