DEPOSIT - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
ACCOUNT_UID |
"SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY." |
|
TBRDEPO |
TBRDEPO_PIDM |
UNKNOWN |
TRANSACTION_NUMBER |
IDENTIFIES THE ASSOCIATED TRANSACTION NUMBER. |
|
TBRDEPO |
TBRDEPO_TRAN_NUMBER |
UNKNOWN |
LEDGER_DESIGNATOR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPERATING_DESIGNATOR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
OPERATING_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
DETAIL_CODE |
DETAIL CODE USED FOR THE CHARGES OR PAYMENTS ENTERED. |
|
TBRDEPO |
TBRDEPO_DETAIL_CODE_DEPOSIT |
UNKNOWN |
DETAIL_CODE_DESC |
DEFAULT TEXT DESCRIPTION TO BE USED FOR THE DETAIL CODE. |
|
TBRDEPO |
TBRDEPO_DESC |
UNKNOWN |
ACADEMIC_YEAR |
ACADEMIC YEAR ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_ACYR_CODE |
UNKNOWN |
ACADEMIC_YEAR_DESC |
DESCRIPTION OF THE ACADEMIC YEAR ASSOCIATED WITH THIS RECORD. |
|
STVACYR |
STVACYR_DESC |
UNKNOWN |
ACADEMIC_PERIOD |
IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. |
|
TBRDEPO |
TBRDEPO_TERM_CODE |
UNKNOWN |
ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
SUB_ACADEMIC_PERIOD |
IDENTIFIES THE SUB ACADEMIC PERIOD OR PART OF TERM ASSOCIATED WITH THE INFORMATION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
SUB_ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE SUB ACADEMIC PERIOD OR SESSION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
ORIGINAL_AMOUNT |
IDENTIFIES THE AMOUNT OF THE DEPOSIT. |
|
TBRDEPO |
TBRDEPO_AMOUNT |
UNKNOWN |
BALANCE_AMOUNT |
IDENTIFIES THE AMOUNT OF THE BALANCE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
PAYMENT_DETAIL_CODE |
IDENTIFIES THE DETAIL CODE USED FOR EVERY PAYMENT THAT ARE ENTERED ON AN ACCOUNT. |
|
TBRDEPO |
TBRDEPO_DETAIL_CODE_PAYMENT |
UNKNOWN |
PAYMENT_DETAIL_CODE_DESC |
DEFAULT TEXT DESCRIPTION TO BE USED FOR THE DETAIL CODE. |
|
TBBDETC |
TBBDETC_DESC |
UNKNOWN |
AUTO_RELEASE_IND |
SPECIFIES IF THE DEPOSIT SHOULD BE AUTOMATICALLY RELEASED ON THE ACCOUNT AFTER THE RELEASE DATE. |
|
TBRDEPO |
TBRDEPO_AUTO_RELEASE_IND |
UNKNOWN |
POST_CASHIER |
UNIQUE USER ID OF THE CASHIER WHO ENTERED THE TRANSACTION. |
|
TBRDEPO |
TBRDEPO_USER |
UNKNOWN |
DEPOSIT_ENTRY_DATE |
SPECIFIES THE DATE THE DEPOSIT WAS ENTERED AS A DEPOSIT ON THE ACCOUNT |
|
TBRDEPO |
TBRDEPO_ENTRY_DATE |
UNKNOWN |
DEPOSIT_RECEIPT_NUMBER |
SPECIFIES THE RECEIPT NUMBER ASSOCIATED WITH THE DEPOSIT IF A RECEIPT NUMBER WAS SYSTEM GENERATED WHEN THE DEPOSIT WAS ENTERED |
|
TBRDEPO |
TBRDEPO_RECEIPT_NUMBER |
UNKNOWN |
MIN_REMAIN_DEPOSIT_AMT |
SPECIFIES THE MINIMUM AMOUNT THAT MUST REMAIN AS A DEPOSIT AND NOT BE RELEASED UNTIL THE EXPIRATION DATE OF THE DEPOSIT |
|
TBRDEPO |
TBRDEPO_MIN_AMOUNT |
UNKNOWN |
DEPOSIT_EXPIRATION_DATE |
SPECIFIES THE EXPIRATION DATE OF THE DEPOSIT |
|
TBRDEPO |
TBRDEPO_EXPIRATION_DATE |
UNKNOWN |
DEPOSIT_RELEASE_DATE |
SPECIFIES THE DATE THE DEPOSIT MAY BE RELEASE. DEPOSIT MAY NOT BE RELEASED AUTOMATICALLY OR MANUALLY BEFORE THIS DATE. IF THIS FIELD IS BLANK THE DEPOSIT MAY BE RELEASED AT ANY TIME |
|
TBRDEPO |
TBRDEPO_RELEASE_DATE |
UNKNOWN |
DEPOSIT_EFFECTIVE_DATE |
SPECIFIES THE EFFECTIVE DATE OF THE DEPOSIT. THIS DATE DEFAULTS TO THE DATE THE DEPOSIT WAS ENTERED |
|
TBRDEPO |
TBRDEPO_EFFECTIVE_DATE |
UNKNOWN |
DEPOSIT_ACTIVITY_DATE |
SPECIFIES THE MOST CURRENT DATE RECORD WAS CREATED OR UPDATED |
|
TBRDEPO |
TBRDEPO_ACTIVITY_DATE |
UNKNOWN |
CASHIER_SESSION_NUMBER |
NUMBER ASSIGNED TO THIS CASHIER SESSION. |
|
TBRDEPO |
TBRDEPO_SESSION_NUMBER |
UNKNOWN |
CASHIER_END_DATE |
LAST DATE TRANSACTIONS WERE PROCESSED BY THIS CASHIER IN THIS SESSION. |
|
TBRDEPO |
TBRDEPO_CSHR_END_DATE |
UNKNOWN |
CASHIER_END_TIME |
END TIME TRANSACTIONS WERE PROCESSED BY THIS CASHIER IN THIS SESSION. |
|
TBBCSHR |
TBBCSHR_ACTIVITY_DATE |
UNKNOWN |
FOREIGN_CURRENCY |
CONTAINS THE FOREIGN CURRENCY CODE USED WHEN MAKING A PAYMENT |
|
TBRDEPO |
TBRDEPO_CURR_CODE |
UNKNOWN |
FOREIGN_CURRENCY_DESC |
SPECIFIES THE FOREIGN CURRENCY CODE DESCRIPTION. |
|
GTVCURR |
GTVCURR_TITLE |
UNKNOWN |
FOREIGN_CURRENCY_AMOUNT |
AMOUNT OF THE TRANSACTION AS STATED IN FOREIGN CURRENCY |
|
TBRDEPO |
TBRDEPO_FOREIGN_AMOUNT |
UNKNOWN |
DEPOSIT_TRANS_DATE |
DATE USED BY THE FINANCE SYSTEM TO CONTROL POSTING TO THE LEDGERS |
|
TBRDEPO |
TBRDEPO_TRANS_DATE |
UNKNOWN |
ACCOUNT_POSTING_STATUS |
INDICATES WHETHER OR NOT THIS TRANSACTION HAS BEEN POSTED IN THE FINANCE SYSTEM. |
|
TBRDEPO |
TBRDEPO_ACCT_FEED_IND |
UNKNOWN |
ACCOUNT_POSTED_AMOUNT |
AMOUNT THAT HAS BEEN POSTED TO THE GENERAL LEDGER. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
POSTING_DATE |
DATE TRANSACTION WAS PROCESSED AND POSTED IN FINANCE. |
|
TBRDEPO |
TBRDEPO_FEED_DATE |
UNKNOWN |
POSTING_DOCUMENT |
DOCUMENT CODE GENERATED TO IDENTIFY AND FEED THIS TRANSACTION TO FINANCE. |
|
TBRDEPO |
TBRDEPO_FEED_DOC_CODE |
UNKNOWN |