| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| TBRACCD_ACCT_FEED_IND |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
ACCOUNT_POSTING_STATUS |
NO |
NA |
| TBRACCD_ACTIVITY_DATE |
TBD |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
ACCOUNT_DETAIL_ACTIVITY_DATE |
NO |
|
| TBRACCD_AIDY_CODE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
AID_YEAR |
NO |
|
| TBRACCD_AMOUNT |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
AMOUNT |
NO |
NA |
| TBRACCD_BALANCE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
BALANCE |
NO |
NA |
| TBRACCD_BILL_DATE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
BILL_DATE |
NO |
NA |
| TBRACCD_CPDT_IND |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
CONTRACT_PYMT_TRANSACTION_IND |
NO |
|
| TBRACCD_CRN |
TBD |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
COURSE_REFERENCE_NUMBER |
NO |
|
| TBRACCD_CROSSREF_DCAT_CODE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
CROSSREF_CATEGORY |
NO |
NA |
| TBRACCD_CROSSREF_DETAIL_CODE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
CROSSREF_DETAIL_CODE |
NO |
NA |
| TBRACCD_CROSSREF_NUMBER |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
CROSSREF_NUMBER |
NO |
NA |
| TBRACCD_CROSSREF_PIDM |
NA |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
CROSSREF_ENTITY_UID |
NO |
NA |
| TBRACCD_CROSSREF_SRCE_CODE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
CROSSREF_SOURCE |
NO |
NA |
| TBRACCD_CSHR_END_DATE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL APPLICATION_OF_PAYMENT |
CASHIER_END_DATE CASHIER_END_DATE |
NO NO |
NA |
| TBRACCD_CURR_CODE |
TSADETF |
NO |
|
|
|
|
NA |
| TBRACCD_DATA_ORIGIN |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
ACCOUNT_DETAIL_DATA_ORIGIN |
NO |
|
| TBRACCD_DESC |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TRANSACTION_DESC |
NO |
NA |
| TBRACCD_DETAIL_CODE |
TSADETL |
NO |
REPORTING VIEW |
APPL_OF_PAY_DETAIL_ACCOUNTING APPLICATION_OF_PAYMENT APPL_OF_PAY_DETAIL_ACCOUNTING RECEIVABLE_SUMMARY APPLICATION_OF_PAYMENT RECEIVABLE_ACCOUNT_DETAIL |
CHARGE_DETAIL_CODE CHARGE_DETAIL_CODE PAY_DETAIL_CODE DETAIL_CODE PAY_DETAIL_CODE DETAIL_CODE |
NO NO NO NO NO NO |
NA |
| TBRACCD_DOCUMENT_NUMBER |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
DOCUMENT_NUMBER |
NO |
NA |
| TBRACCD_DUE_DATE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
DUE_DATE |
NO |
NA |
| TBRACCD_EFFECTIVE_DATE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
EFFECTIVE_DATE |
NO |
NA |
| TBRACCD_ENTRY_DATE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
ENTRY_DATE |
NO |
NA |
| TBRACCD_FEED_DATE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
POSTING_DATE |
NO |
NA |
| TBRACCD_FEED_DOC_CODE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
POSTING_DOCUMENT |
NO |
NA |
| TBRACCD_FOREIGN_AMOUNT |
TSADETF |
NO |
|
|
|
|
NA |
| TBRACCD_INVOICE_NUMBER |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
INVOICE_NUMBER |
NO |
NA |
| TBRACCD_PAYMENT_ID |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
CREDIT_CARD_NUMBER |
NO |
NA |
| TBRACCD_PERIOD |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
AID_ENROLLMENT_PERIOD |
NO |
|
| TBRACCD_PIDM |
NA |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT RECEIVABLE_ACCOUNT_DETAIL |
ACCOUNT_UID ACCOUNT_UID |
NO NO |
NA |
| TBRACCD_RECEIPT_NUMBER |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
RECEIPT_NUMBER |
NO |
NA |
| TBRACCD_REFUND_IND |
TSADETC |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
REFUND |
NO |
|
| TBRACCD_SESSION_NUMBER |
TSADETL |
NO |
REPORTING VIEW |
APPLICATION_OF_PAYMENT RECEIVABLE_ACCOUNT_DETAIL |
CASHIER_SESSION_NUMBER CASHIER_SESSION_NUMBER |
NO NO |
NA |
| TBRACCD_SRCE_CODE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
SOURCE |
NO |
NA |
| TBRACCD_STATEMENT_DATE |
TBD |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
STATEMENT_DATE |
NO |
|
| TBRACCD_STSP_KEY_SEQUENCE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
STUDY_PATH |
NO |
|
| TBRACCD_TAX_AMOUNT |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_AMOUNT |
NO |
NA |
| TBRACCD_TAX_FUTURE_IND |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_FUTURE_ITEM |
NO |
NA |
| TBRACCD_TAX_FUTURE_IND_PR |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_FUTURE_ITEM_PR |
NO |
NA |
| TBRACCD_TAX_FUTURE_IND_SG |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_FUTURE_ITEM_SG |
NO |
NA |
| TBRACCD_TAX_REPT_BOX |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_DOCUMENT_BOX_NUMBER |
NO |
NA |
| TBRACCD_TAX_REPT_BOX_PR |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_DOCUMENT_BOX_NUMBER_PR |
NO |
NA |
| TBRACCD_TAX_REPT_BOX_SG |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_DOCUMENT_BOX_NUMBER_SG |
NO |
NA |
| TBRACCD_TAX_REPT_YEAR |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TAX_YEAR |
NO |
NA |
| TBRACCD_TERM_CODE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_SUMMARY RECEIVABLE_ACCOUNT_DETAIL |
ACADEMIC_PERIOD ACADEMIC_PERIOD |
NO NO |
NA |
| TBRACCD_TRANS_DATE |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TRANSACTION_DATE |
NO |
NA |
| TBRACCD_TRAN_NUMBER |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TRANSACTION_NUMBER |
NO |
NA |
| TBRACCD_TRAN_NUMBER_PAID |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL |
TRAN_NUMBER_PAID |
NO |
NA |
| TBRACCD_USER |
TSADETL |
NO |
REPORTING VIEW |
RECEIVABLE_ACCOUNT_DETAIL RECEIVABLE_ACCOUNT_DETAIL APPLICATION_OF_PAYMENT |
ACCOUNT_DETAIL_USER_ID POST_CASHIER POST_CASHIER |
NO NO NO |
NA |