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

Ver: