RECEIVABLE_ACCOUNT - 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 |
| ACCOUNT_ENTITY_IND |
IDENTIFIES WHETHER THIS IS A PERSON OR ORGANIZATION ENTITY RECORD. |
|
SPRIDEN |
SPRIDEN_ENTITY_IND |
UNKNOWN |
| EXTERNAL_IND |
EXTERNAL INDICATOR |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ID |
ORGANIZATION'S ID NUMBER USED TO ACCESS ASSOCIATED RECORDS. |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
| TAX_ID |
ORGANIZATION'S IDENTIFICATION ASSIGNED BY THEIR FEDERAL GOVERNMENT FOR TAX PURPOSES |
|
SPRIDEN |
SPBPERS_SSN |
UNKNOWN |
| LAST_NAME |
PERSON'S LAST NAME OR SURNAME. |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
| FIRST_NAME |
PERSON'S FIRST OR GIVEN NAME. |
|
SPRIDEN |
SPRIDEN_FIRST_NAME |
UNKNOWN |
| MIDDLE_NAME |
PERSON'S MIDDLE NAME |
|
SPRIDEN |
SPRIDEN_MI |
UNKNOWN |
| MIDDLE_INITIAL |
PERSON'S MIDDLE INITIAL. |
|
SPRIDEN |
SUBSTR(SPRIDEN_MI 1) |
UNKNOWN |
| NAME_PREFIX |
PREFIX OF THE PERSON'S NAME. |
|
SPBPERS |
SPBPERS_NAME_PREFIX |
UNKNOWN |
| NAME_SUFFIX |
SUFFIX OF THE PERSON'S NAME. |
|
SPBPERS |
SPBPERS_NAME_SUFFIX |
UNKNOWN |
| ACCOUNT_BALANCE |
DISPLAYS THE SUM OF THE ACCOUNT BALANCE. |
|
FUNCTION |
F_ACCOUNT_BALANCE |
UNKNOWN |
| CURRENT_AMOUNT_DUE |
DISPLAYS THE CURRENT AMOUNT DUE. |
|
FUNCTION |
F_AMOUNT_DUE |
UNKNOWN |
| MEMO_BALANCE |
DISPLAYS THE BALANCE ON UNEXPIRED MEMOS. |
|
FUNCTION |
F_MEMO_BALANCE |
UNKNOWN |
| DEPOSIT_BALANCE |
BALANCE FOR ALL DEPOSIT ENTRIES ON THE ACCOUNT. |
|
FUNCTION |
F_DEPOSIT_BALANCE |
UNKNOWN |
| OLDEST_EFFECTIVE_DATE |
DISPLAYS THE OLDEST EFFECTIVE DATE. |
|
FUNCTION |
F_OLDEST_EFFECTIVE_DATE |
UNKNOWN |
| ADDRESS_COUNT |
NUMBER OF ADDRESSES RECORDS FOR THIS PERSON OR ENTITY. |
|
FUNCTION |
F_COUNT_ADDRESSES |
UNKNOWN |
| TELEPHONE_COUNT |
NUMBER OF TELEPHONE NUMBERS RECORDED FOR THE ACCOUNT. |
|
FUNCTION |
? |
UNKNOWN |
| HOLD_COUNT |
IDENTIFIES HOW MANY HOLDS EXIST FOR THE ACCOUNT. |
|
FUNCTION |
F_COUNT_HOLDS |
UNKNOWN |
| DELINQUENCY |
IDENTIFIES THE DELINQUENCY CODE ASSOCIATED WITH THE PERSON'S ACCOUNT. |
|
TBBACCT |
TBBACCT_DELI_CODE |
UNKNOWN |
| DELINQUENCY_DESC |
IDENTIFIES THE DELINQUENCY DESCRIPTION ASSOCIATED WITH THE PERSON'S ACCOUNT. |
|
TTVDELI |
TTVDELI_DESC |
UNKNOWN |
| NSF_COUNTER |
NUMBER OF NON SUFFICIENT FUND CHEQUES RECORDED FOR THE ACCOUNT. |
|
FUNCTION |
? |
UNKNOWN |
| COLLECTION_COUNT |
|
|
FUNCTION |
F_COUNT_COLLECTIONS |
UNKNOWN |
| COLLECTION_AGENCY_ID |
IDENTIFIES THE COLLECTION AGENCY ID. |
|
TBRCOLL |
? |
UNKNOWN |
| COLLECTION_AGENCY_NAME |
IDENTIFIES THE COLLECTION AGENCY NAME. ( '') |
|
TBRCOLL |
F_FORMAT_NAME |
UNKNOWN |
| COLLECTION_DATE |
IDENTIFIES THE DATE THE ACCOUNT WAS ASSIGNED TO THE COLLECTION AGENCY. |
|
TBRCOLL |
TBRCOLC_COLC_AGENCY_DATE |
UNKNOWN |
| CREDIT_LIMIT_MAX |
IDENTIFIES THE CREDIT LIMIT MAX. |
|
TBBACCT |
? |
UNKNOWN |