RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: TBRACCD Accounts Receivable Composite View Reports
SGHE Operational Data Store Composite View Source: TBRACCD

Source Column Source Form Target Type Target Target Column Calculation Formula
TBRACCD_ACCT_FEED_IND TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

ACCOUNT_POSTING_STATUS

NA
TBRACCD_AMOUNT TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

AMOUNT

NA
TBRACCD_BALANCE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

BALANCE

NA
TBRACCD_BILL_DATE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

BILL_DATE

NA
TBRACCD_CROSSREF_DCAT_CODE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

CROSSREF_CATEGORY

NA
TBRACCD_CROSSREF_DETAIL_CODE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

CROSSREF_DETAIL_CODE

NA
TBRACCD_CROSSREF_NUMBER TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

CROSSREF_NUMBER

NA
TBRACCD_CROSSREF_PIDM NA COMPOSITE VIEW

AT_ACCOUNT_DETAIL

CROSSREF_ENTITY_UID

NA
TBRACCD_CROSSREF_SRCE_CODE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

CROSSREF_SOURCE

NA
TBRACCD_CSHR_END_DATE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

AT_ACCOUNT_DETAIL

CASHIER_END_DATE

CASHIER_END_TIME

NA
TBRACCD_CURR_CODE TSADETF COMPOSITE VIEW

AT_ACCOUNT_DETAIL

FOREIGN_CURRENCY

NA
TBRACCD_DESC TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TRANSACTION_DESC

NA
TBRACCD_DETAIL_CODE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

DETAIL_CODE

NA
TBRACCD_DOCUMENT_NUMBER TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

DETAIL_CODE_TYPE

NA
TBRACCD_DUE_DATE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

DOCUMENT_NUMBER

NA
TBRACCD_EFFECTIVE_DATE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

DUE_DATE

NA
TBRACCD_ENTRY_DATE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

EFFECTIVE_DATE

NA
TBRACCD_FEED_DATE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

POSTING_DATE

NA
TBRACCD_FEED_DOC_CODE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

POSTING_DOCUMENT

NA
TBRACCD_FOREIGN_AMOUNT TSADETF COMPOSITE VIEW

AT_ACCOUNT_DETAIL

FOREIGN_CURRENCY_AMOUNT

NA
TBRACCD_INVOICE_NUMBER TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

INVOICE_NUMBER

NA
TBRACCD_PAYMENT_ID TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

CREDIT_CARD_NUMBER

NA
TBRACCD_PIDM NA COMPOSITE VIEW

AT_ACCOUNT_DETAIL

ACCOUNT_UID

NA
TBRACCD_RECEIPT_NUMBER TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

RECEIPT_NUMBER

NA
TBRACCD_SESSION_NUMBER TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

CASHIER_SESSION_NUMBER

NA
TBRACCD_SRCE_CODE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

SOURCE

NA
TBRACCD_TAX_AMOUNT TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TAX_AMOUNT

NA
TBRACCD_TAX_FUTURE_IND TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TAX_FUTURE_ITEM

NA
TBRACCD_TAX_REPT_BOX TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TAX_DOCUMENT_BOX_NUMBER

NA
TBRACCD_TAX_REPT_YEAR TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TAX_YEAR

NA
TBRACCD_TERM_CODE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

ACADEMIC_PERIOD

NA
TBRACCD_TRANS_DATE TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TRANSACTION_DATE

NA
TBRACCD_TRAN_NUMBER TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TRANSACTION_NUMBER

NA
TBRACCD_TRAN_NUMBER_PAID TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

TRAN_NUMBER_PAID

NA
TBRACCD_USER TSADETL COMPOSITE VIEW

AT_ACCOUNT_DETAIL

POST_CASHIER

NA


Ver: 3.1