Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT_POSTING_STATUS		Status of the transaction in the accounting feed process as ready to feed or transaction has been fed.	VARCHAR2(1)		TBRMISD	TBRMISD_ACCT_FEED_IND
AMOUNT		Transaction amount.	NUMBER(12, 2)		TBRMISD	TBRMISD_AMOUNT
CASHIER_END_DATE		Ending date of the cashiering session for the transaction.	DATE		TBRMISD	TBRMISD_CSHR_END_DATE
CASHIER_END_TIME		Ending time of the cashiering session for the transaction.	VARCHAR2(8)		CALCULATION	TO_CHAR(TBRACCD_CSHR_END_DATE)
CASHIER_SESSION_NUMBER		Session number assigned to each cashier session.	NUMBER(5)		TBRMISD	TBRMISD_SESSION_NUMBER
CHARGE_ACCOUNT		Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)		TBRMISD	TBRMISD_CHARGE_ACCT
CHARGE_ACCOUNT_DESC		Account code description or title.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_ACCOUNT_INDEX		Short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)		TBRMISD	TBRMISD_CHARGE_ACCI
CHARGE_ACCOUNT_INDEX_DESC		Account index description.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_ACCOUNT_INDEX_STATUS		Current status of the associated account index.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_ACCOUNT_STATUS		Current status of the associated account.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_ACTIVITY		Identifies accounting data by activity.	VARCHAR2(6)		TBRMISD	TBRMISD_CHARGE_ACTV
CHARGE_ACTIVITY_DESC		Activity code title or description.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_ACTIVITY_STATUS		Extracted current status of the associated activity.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_CATEGORY		Identities category for a receivable transaction type. For example, registration, housing, meal, and contract.	VARCHAR2(3)		TBBDETC	TBBDETC_DCAT_CODE
CHARGE_CATEGORY_DESC		Receivable category description.	VARCHAR2(30)		TTVDCAT	TTVDCAT_DESC
CHARGE_CHART_OF_ACCOUNTS		Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment.	VARCHAR2(1)		TBRMISD	TBRMISD_CHARGE_COAS
CHARGE_CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_CHART_STATUS		Extracted current status of the associated chart of accounts.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_DETAIL_CODE		Detail code identifying type of charge used on this receipt.	VARCHAR2(4)		TBRMISD	TBRMISD_CHARGE_DETAIL_CODE
CHARGE_DETAIL_CODE_DESC		Detail code description.	VARCHAR2(30)		TBBDETC	TBBDETC_DESC
CHARGE_DETAIL_CODE_TYPE		Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)		TBBDETC	TBBDETC_TYPE_IND
CHARGE_EXTERNAL_ACCOUNT		Free form account number used to interface to finance systems when Banner Finance is not present.	VARCHAR2(60)		TBRMISD	TBRMISD_CHARGE_ACCOUNT
CHARGE_FUND		The funding source code used with this accounting transaction.	VARCHAR2(6)		TBRMISD	TBRMISD_CHARGE_FUND
CHARGE_FUND_DESC		Associated fund description or title.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_FUND_STATUS		Extracted current status of the associated fund.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_LOCATION		Accounting identification code of a physical location.	VARCHAR2(6)		TBRMISD	TBRMISD_CHARGE_LOCN
CHARGE_LOCATION_DESC		Extracted description or title of the associated location.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_LOCATION_STATUS		Extracted current status of the associated location.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_ORGANIZATION		Identification accounting code used for the department.	VARCHAR2(6)		TBRMISD	TBRMISD_CHARGE_ORGN
CHARGE_ORGANIZATION_DESC		Extracted description or title associated with the organization code.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_ORGANIZATION_STATUS		Extracted current status of the associated organization.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_PRIORITY		Detail code priority for use in the application of payments process.	VARCHAR2(3)		TBBDETC	TBBDETC_PRIORITY
CHARGE_PROGRAM		Accounting identification code. Program classification structure, or a subset or that structure, as defined by the national council of higher education management systems.	VARCHAR2(6)		TBRMISD	TBRMISD_CHARGE_PROG
CHARGE_PROGRAM_DESC		Extracted description or title of the associated program.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
CHARGE_PROGRAM_STATUS		Extracted current status of the associated program.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
CHARGE_RULE_CLASS		Accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRMISD	TBRMISD_CHARGE_RUCL_CODE
CHARGE_RULE_CLASS_DESC		Unique title assigned to a rule class.	VARCHAR2(35)		FTVRUCL	FTVRUCL_CLASS_TITLE
CITY	City	City associated with the address.	VARCHAR2(50)		TBBMISC	TBBMISC_CITY
COUNTY		County associated with the address.	VARCHAR2(63)		NA	NA
COUNTY_DESC		County address name.	VARCHAR2(255)		NA	NA
CREDIT_CARD_NUMBER		Credit card number or payment identification.	VARCHAR2(20)		TBRMISD	TBRMISD_PAYMENT_ID
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEBIT_CREDIT_IND		Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.	VARCHAR2(1)		TBRMISD	TBRMISD_DR_CR_IND
DOCUMENT_NUMBER		Unique transaction id assigned from posting.	VARCHAR2(8)		TBRMISD	TBRMISD_DOCUMENT_NUMBER
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENTITY_UID		System internally generated ID to uniquely identify the person or oragnization for this transaction.	NUMBER(8)		TBRMISD	TBRMISD_PIDM
FOREIGN_CURRENCY		Foreign currency code description.	VARCHAR2(4)		TBRMISD	TBRMISD_CURR_CODE
FOREIGN_CURRENCY_AMOUNT		Amount of the transaction as stated in foreign currency.	NUMBER(12, 2)		TBRMISD	TBRMISD_FOREIGN_AMOUNT
FOREIGN_CURRENCY_DESC		Transaction amount as stated in foreign currency.	VARCHAR2(35)		GTVCURR	GTVCURR_TITLE
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
NAME		Current name of the person or organization for this transaction.	VARCHAR2(30)		TBBMISC	TBBMISC_NAME
NATION		Nation code associated with the address.	VARCHAR2(5)		TBBMISC	TBBMISC_NATN_CODE
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(30)		STVNATN	STVNATN_NATION
PAYMENT_ACCOUNT		Represents an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)		TBRMISD	TBRMISD_PAY_ACCT
PAYMENT_ACCOUNT_DESC		Account code description or title.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_ACCOUNT_INDEX		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)		TBRMISD	TBRMISD_PAY_ACCI
PAYMENT_ACCOUNT_INDEX_DESC		Account index description.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_ACCOUNT_INDEX_STATUS		Current status of the associated account index.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_ACCOUNT_STATUS		Current status of the associated account.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_ACTIVITY		Identifies accounting data by activity.	VARCHAR2(6)		TBRMISD	TBRMISD_PAY_ACTV
PAYMENT_ACTIVITY_DESC		Activity code title or description.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_ACTIVITY_STATUS		Extracted current status of the associated activity.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_CATEGORY		Identities category for a receivable transaction type. For example, registration, housing, meal, and contract.	VARCHAR2(3)		TBBDETC	TBBDETC_DCAT_CODE
PAYMENT_CATEGORY_DESC		Receivable category description.	VARCHAR2(30)		TTVDCAT	TTVDCAT_DESC
PAYMENT_CHART_OF_ACCOUNTS		Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment.	VARCHAR2(1)		TBRMISD	TBRMISD_PAY_COAS
PAYMENT_CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_CHART_STATUS		Extracted current status of the associated chart of accounts.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_DETAIL_CODE		Detail code identifying type of payment used on this receipt.	VARCHAR2(4)		TBRMISD	TBRMISD_PAY_DETAIL_CODE
PAYMENT_DETAIL_CODE_DESC		Detail code description.	VARCHAR2(30)		TBBDETC	TBBDETC_DESC
PAYMENT_DETAIL_CODE_TYPE		Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)		TBBDETC	TBBDETC_TYPE_IND
PAYMENT_EXTERNAL_ACCOUNT		Free form account number used to interface to finance systems when Banner Finance is not present.	VARCHAR2(60)		TBRMISD	TBRMISD_PAY_ACCOUNT
PAYMENT_FUND		Funding source code used with this accounting transaction.	VARCHAR2(6)		TBRMISD	TBRMISD_PAY_FUND
PAYMENT_FUND_DESC		Associated fund description or title.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_FUND_STATUS		Extracted current status of the associated fund.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_LOCATION		Accounting identification code of a physical location.	VARCHAR2(6)		TBRMISD	TBRMISD_PAY_LOCN
PAYMENT_LOCATION_DESC		Extracted description or title of the associated location.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_LOCATION_STATUS		Extracted current status of the associated location.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_ORGANIZATION		Identification accounting code used for the department.	VARCHAR2(6)		TBRMISD	TBRMISD_PAY_ORGN
PAYMENT_ORGANIZATION_DESC		Extracted description or title associated with the organization code.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_ORGANIZATION_STATUS		Extracted current status of the associated organization.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_PRIORITY		Priority of the detail code for use in the application of payments process.	VARCHAR2(3)		TBBDETC	TBBDETC_PRIORITY
PAYMENT_PROGRAM		Accounting identification code. Identifies the program classification structure, or a subset or that structure, as defined by the national council of higher education management systems.	VARCHAR2(6)		TBRMISD	TBRMISD_PAY_PROG
PAYMENT_PROGRAM_DESC		Extracted description or title of the associated program.	VARCHAR2(35)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC
PAYMENT_PROGRAM_STATUS		Extracted current status of the associated program.	VARCHAR2(1)		FUNCTION	TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS
PAYMENT_RULE_CLASS		Accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRMISD	TBRMISD_PAY_RUCL_CODE
PAYMENT_RULE_CLASS_DESC		Unique title assigned to a rule class.	VARCHAR2(35)		FTVRUCL	FTVRUCL_CLASS_TITLE
POSTAL_CODE	Postal Code	Address postal code.	VARCHAR2(30)		TBBMISC	TBBMISC_ZIP
POSTING_DATE		Date the transaction was posted into the ledgers.	DATE		TBRMISD	TBRMISD_FEED_DATE
POSTING_DOCUMENT		Document code generated to identify and feed this transaction to finance.	VARCHAR2(8)		TBRMISD	TBRMISD_FEED_DOC_CODE
POST_CASHIER		Identification code of the cashier who entered the transaction.	VARCHAR2(30)		TBRMISD	TBRMISD_USER
RECEIPT_NUMBER		Receipt number associated with the transaction if a receipt number was generated when the transaction was entered.	NUMBER(8)		TBRMISD	TBRMISD_RECEIPT_NUMBER
STATE_PROVINCE		State/Province code for the address.	VARCHAR2(3)		TBBMISC	TBBMISC_STAT_CODE
STATE_PROVINCE_DESC	State Province Description	State/Province name.	VARCHAR2(30)		STVSTAT	STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(75)		TBBMISC	TBBMISC_STREET_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(75)		TBBMISC	TBBMISC_STREET_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(75)		TBBMISC	TBBMISC_STREET_LINE3
STREET_LINE4		Fourth line of the address.	VARCHAR2(63)		NA	NA
TRANSACTION_ACTIVITY_DATE		Date record was inserted or updated	DATE		TBRMISD	TBRMISD_ACTIVITY_DATE
TRANSACTION_DATE		The date the transaction was posted into the ledgers.	DATE		TBRMISD	TBRMISD_TRANS_DATE
TRANSACTION_DESC		Accounting transaction description.	VARCHAR2(30)		TBRMISD	TBRMISD_DESC
TRANSACTION_NUMBER		A unique one-up number assigned to each transaction on the receipt.	NUMBER(8)		TBRMISD	TBRMISD_TRAN_NUMBER
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: