RECEIVABLE_ACCOUNT_DETAIL - 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." |
|
TBRACCD |
TBRACCD_PIDM |
UNKNOWN |
| EXTERNAL_IND |
EXTERNAL INDICATOR |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| TRANSACTION_NUMBER |
IDENTIFIES THE ASSOCIATED TRANSACTION NUMBER. |
|
TBRACCD |
TBRACCD_TRAN_NUMBER |
UNKNOWN |
| LEDGER_DESIGNATOR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| OPERATING_DESIGNATOR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| OPERATING_DATE |
|
|
NA |
NOT AVAILABLE |
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. |
|
TBRACCD |
TBRACCD_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 |
| DETAIL_CODE |
DETAIL CODE USED FOR THE CHARGES OR PAYMENTS ENTERED. |
|
TBRACCD |
TBRACCD_DETAIL_CODE |
UNKNOWN |
| DETAIL_CODE_DESC |
DEFAULT TEXT DESCRIPTION TO BE USED FOR THE DETAIL CODE. |
|
TBBDETC |
TBBDETC_DESC |
UNKNOWN |
| DETAIL_CODE_TYPE |
DETAIL CODE IS A CHARGE OR A PAYMENT INDICATOR. VALUES ARE C FOR CHARGE OR P FOR PAYMENT. |
|
TBBDETC |
TBBDETC_TYPE_IND |
UNKNOWN |
| CATEGORY |
CATEGORY FOR MEETING TIME. |
|
TBBDETC |
TBBDETC_DCAT_CODE |
UNKNOWN |
| CATEGORY_DESC |
SPECIFIES THE CATEGORY. |
|
TTVDCAT |
TTVDCAT_DESC |
UNKNOWN |
| PRIORITY |
A NUMBER TO ESTABLISH THE ORDER IN WHICH TAXES ARE TO BE COMPOUNDED FOR A TAXED COMMODITY. |
|
TBBDETC |
TBBDETC_PRIORITY |
UNKNOWN |
| RETURNED_CHECK_IND |
|
|
TBRACCD |
? |
UNKNOWN |
| ENTRY_DATE |
DATE THE TRANSACTION WAS ENTERED ON THE ACCOUNT. |
|
TBRACCD |
TBRACCD_ENTRY_DATE |
UNKNOWN |
| AMOUNT |
AMOUNT RELATED TO A PURCHASE ORDER. |
|
TBRACCD |
TBRACCD_AMOUNT |
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 |
| BALANCE |
DISPLAYS THE VALUE OF THE OUTSTANDING BALANCE |
|
TBRACCD |
TBRACCD_BALANCE |
UNKNOWN |
| EFFECTIVE_DATE |
DATE ON WHICH THE BARGAINING UNIT BECAME EFFECTIVE FOR THIS PERSON. |
|
TBRACCD |
TBRACCD_EFFECTIVE_DATE |
UNKNOWN |
| BILL_DATE |
SPECIFIES THE BILLING DATE. |
|
TBRACCD |
TBRACCD_BILL_DATE |
UNKNOWN |
| DUE_DATE |
DUE DATE FOR PAYMENT OF THE TRANSACTION. |
|
TBRACCD |
TBRACCD_DUE_DATE |
UNKNOWN |
| TRANSACTION_DESC |
A BRIEF NAME OF THE PURPOSE OF THE TRANSACTION RECORD BEING CREATED. |
|
TBRACCD |
TBRACCD_DESC |
UNKNOWN |
| RECEIPT_NUMBER |
IDENTIFIES THE RECEIPT NUMBER ASSOCIATED WITH THE TRANSACTION IF A RECEIPT NUMBER WAS GENERATED WHEN THE TRANSACTION WAS ENTERED. |
|
TBRACCD |
TBRACCD_RECEIPT_NUMBER |
UNKNOWN |
| TRAN_NUMBER_PAID |
IDENTIFIES THE TRANSACTION NUMBER OF A SPECIFIC APPLICATION OF PAYMENT. THIS TRANSACTION WAS USED TO DIRECTLY APPLY TO THE TRANSACTION NUMBER SPECIFIED HERE. |
|
TBRACCD |
TBRACCD_TRAN_NUMBER_PAID |
UNKNOWN |
| CROSSREF_ENTITY_UID |
SYSTEM INTERNALLY GENERATED NUMBER TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
TBRACCD |
TBRACCD_CROSSREF_PIDM?? |
UNKNOWN |
| CROSSREF_NUMBER |
IDENTIFIES THE NUMBER OF THE CONTRACT OR EXEMPTION ASSOCIATED WITH THE TRANSACTION. |
|
TBRACCD |
TBRACCD_CROSSREF_NUMBER |
UNKNOWN |
| CROSSREF_DETAIL_CODE |
SPECIFIES A FREE-FORMAT NAME OF THE DETAIL CODE. |
|
TBRACCD |
TBRACCD_? |
UNKNOWN |
| CROSSREF_DETAIL_CODE_DESC |
DEFAULT TEXT DESCRIPTION TO BE USED FOR THE DETAIL CODE. |
|
TBBDETC |
TBBDETC_DESC |
UNKNOWN |
| CROSSREF_CATEGORY |
|
|
TBRACCD |
? |
UNKNOWN |
| CROSSREF_CATEGORY_DESC |
|
|
TBRACCD |
? |
UNKNOWN |
| CROSSREF_SOURCE |
|
|
TBRACCD |
NOT AVAILABLE |
UNKNOWN |
| CROSSREF_SOURCE_DESC |
|
|
TBRACCD |
NOT AVAILABLE |
UNKNOWN |
| SOURCE |
ENTRY SOURCE FOR THE TRANSACTION NUMBER. (E.G.. R FOR REGISTRATION, T FOR ACCOUNTS RECEIVABLE, ETC.). |
|
TBRACCD |
TBRACCD_SRCE_CODE |
UNKNOWN |
| SOURCE_DESC |
APPLICANT SOURCE DESCRIPTION. |
|
TTVSRCE |
TTVSRCE_DESC |
UNKNOWN |
| ACCOUNT_POSTING_STATUS |
INDICATES WHETHER OR NOT THIS TRANSACTION HAS BEEN POSTED IN THE FINANCE SYSTEM. |
|
TBRACCD |
TBRACCD_ACCT_FEED_IND |
UNKNOWN |
| ACCOUNT_POSTED_AMOUNT |
AMOUNT THAT HAS BEEN POSTED TO THE GENERAL LEDGER. |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
| DOCUMENT_NUMBER |
UNIQUE NUMBER THAT IDENTIFIES A SPECIFIC SET OF CHARGES OR PAYMENTS. |
|
TBRACCD |
TBRACCD_DOCUMENT_NUMBER |
UNKNOWN |
| TRANSACTION_DATE |
DATE THE TRANSACTION WAS PROCESSED. |
|
TBRACCD |
TBRACCD_TRANS_DATE |
UNKNOWN |
| INVOICE_NUMBER |
UNIQUE NUMBER THAT IDENTIFIES THE DOCUMENT BEING UPDATED. |
|
TBRACCD |
TBRACCD_INVOICE_NUMBER |
UNKNOWN |
| POSTING_DATE |
DATE TRANSACTION WAS PROCESSED AND POSTED IN FINANCE. |
|
TBRACCD |
TBRACCD_FEED_DATE |
UNKNOWN |
| POSTING_DOCUMENT |
DOCUMENT CODE GENERATED TO IDENTIFY AND FEED THIS TRANSACTION TO FINANCE. |
|
TBRACCD |
TBRACCD_FEED_DOC_CODE |
UNKNOWN |
| POST_CASHIER |
UNIQUE USER ID OF THE CASHIER WHO ENTERED THE TRANSACTION. |
|
TBRACCD |
TBRACCD_USER |
UNKNOWN |
| CASHIER_SESSION_NUMBER |
NUMBER ASSIGNED TO THIS CASHIER SESSION. |
|
TBRACCD |
TBRACCD_SESSION_NUMBER |
UNKNOWN |
| CASHIER_END_DATE |
LAST DATE TRANSACTIONS WERE PROCESSED BY THIS CASHIER IN THIS SESSION. |
|
TBRACCD |
TBRACCD_CSHR_END_DATE |
UNKNOWN |
| CASHIER_END_TIME |
END TIME TRANSACTIONS WERE PROCESSED BY THIS CASHIER IN THIS SESSION. |
|
TBBCSHR |
TBBCSHR_ACTIVITY_DATE |
UNKNOWN |
| PRE_BILL_FLAG |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| JOURNAL_SOURCE |
IDENTIFIES THE JOURNAL SOURCE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| JOURNAL_ENTRY |
IDENTIFIES THE JOURNAL ENTRY. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| TAX_YEAR |
IDENTIFIES THE TAX YEAR. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| TAX_DOCUMENT |
IDENTIFIES THE TAX DOCUMENT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| TAX_DOCUMENT_BOX_NUMBER |
IDENTIFIES THE TAX DOCUMENT BOX NUMBER. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| TAX_AMOUNT |
AMOUNT OF TAX COMPUTED OR ENTERED FOR A DOCUMENT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| TAX_FUTURE_ITEM |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| FINANCIAL_AID_UPLOAD_FIELD |
THIS FIELD IS USED TO LINK THE FINANCIAL AID FUND TO THE ACCOUNTS RECEIVABLE TRANSACTION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| BILL_SEQUENCE |
SPECIFIES THE BILL SEQUENCE. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| BILL_AMOUNT |
SPECIFIES THE BILL AMOUNT. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| CREDIT_CARD_NUMBER |
CREDIT CARD NUMBER USED IN THIS TRANSACTION. |
|
TBRACCD |
TBRACCD_CARD_AUTH_NUMBER_VR |
UNKNOWN |