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 |