Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Accounts Receivable Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: RECEIVABLE_ACCOUNTING

Description Contains detail code ledger accounting distribution information by effective date for debits and credits to be sent to post into the ledgers. This includes the percentage each accounting transaction is applied to on each transaction amount. Use this view joining to the detail codes by effective date in other views to determine actual accounting for reconciliation.
Key & Frequency One row per detail code per effective date.
Recommended Search Columns DETAIL_CODE
A_CHART_OF_ACCOUNTS, A_FUND, A_ACCOUNT
B_CHART_OF_ACCOUNTS, B_FUND, B_ACCOUNT

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_A Actual account number from a finance system associated with this detail code. VARCHAR2(63)

TBRACCT

TBRACCT_ACCOUNT_A

ACCOUNT_B Actual account number from a finance system associated with this detail code. VARCHAR2(63)

TBRACCT

TBRACCT_ACCOUNT_B

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

A_ACCOUNT Banner finance account code for account a. VARCHAR2(63)

TBRACCT

TBRACCT_A_ACCT_CODE

A_ACCOUNT_DESC Banner finance account description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_ACCOUNT_INDEX Banner finance account index for account a is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(63)

TBRACCT

TBRACCT_A_ACCI_CODE

A_ACCOUNT_INDEX_DESC Banner finance account index description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_ACTIVITY Banner finance activity code for account a. VARCHAR2(63)

TBRACCT

TBRACCT_A_ACTV_CODE

A_ACTIVITY_DESC Banner finance activity description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_CHART_OF_ACCOUNTS Banner finance chart of accounts code for account a. VARCHAR2(63)

TBRACCT

TBRACCT_A_COAS_CODE

A_CHART_OF_ACCOUNTS_DESC Banner finance chart of accounts description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_FUND Banner finance fund code for account a. VARCHAR2(63)

TBRACCT

TBRACCT_A_FUND_CODE

A_FUND_DESC Banner finance fund description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_LOCATION Banner finance location code for account a. VARCHAR2(63)

TBRACCT

TBRACCT_A_LOCN_CODE

A_LOCATION_DESC Banner finance location description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_ORGANIZATION Banner finance organization code for account a. VARCHAR2(63)

TBRACCT

TBRACCT_A_ORGN_CODE

A_ORGANIZATION_DESC Banner finance organization description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_PROGRAM Banner finance program code for account a. VARCHAR2(63)

TBRACCT

TBRACCT_A_PROG_CODE

A_PROGRAM_DESC Banner finance program description for account a. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_RULE_CLASS1 First accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT_A_RUCL_CODE1

A_RULE_CLASS2 Second accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT_A_RUCL_CODE2

A_RULE_CLASS3 Third accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT_A_RUCL_CODE3

A_RULE_CLASS_DESC1 First rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_RULE_CLASS_DESC2 Second rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

A_RULE_CLASS_DESC3 Third rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_ACCOUNT Banner finance account code for account b. VARCHAR2(63)

TBRACCT

TBRACCT_B_ACCT_CODE

B_ACCOUNT_DESC Banner finance account description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_ACCOUNT_INDEX Banner finance account index for account b is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(63)

TBRACCT

TBRACCT_B_ACCI_CODE

B_ACCOUNT_INDEX_DESC Banner finance account index description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_ACTIVITY Banner finance activity code for account b. VARCHAR2(63)

TBRACCT

TBRACCT_B_ACTV_CODE

B_ACTIVITY_DESC Banner finance activity description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_CHART_OF_ACCOUNTS Banner finance chart of accounts code for account b. VARCHAR2(63)

TBRACCT

TBRACCT_B_COAS_CODE

B_CHART_OF_ACCOUNTS_DESC Banner finance chart of accounts description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_FUND Banner finance fund code for account b. VARCHAR2(63)

TBRACCT

TBRACCT_B_FUND_CODE

B_FUND_DESC Banner finance fund description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_LOCATION Banner finance location code for account b. VARCHAR2(63)

TBRACCT

TBRACCT_B_LOCN_CODE

B_LOCATION_DESC Banner finance location description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_ORGANIZATION Banner finance organization code for account b. VARCHAR2(63)

TBRACCT

TBRACCT_B_ORGN_CODE

B_ORGANIZATION_DESC Banner finance organization description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_PROGRAM Banner finance program code for account b. VARCHAR2(63)

TBRACCT

TBRACCT_B_PROG_CODE

B_PROGRAM_DESC Banner finance program description for account b. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_RULE_CLASS1 First accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT_B_RUCL_CODE1

B_RULE_CLASS2 Second accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT_B_RUCL_CODE2

B_RULE_CLASS3 Third accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT_B_RUCL_CODE3

B_RULE_CLASS_DESC1 First rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_RULE_CLASS_DESC2 Second rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

B_RULE_CLASS_DESC3 Third rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESIGNATOR Academic period-based or financial aid year-based designator. VARCHAR2(63)

FUNCTION

CASE WHEN TBBDETC_TBDC_IND

DESIGNATOR_DESC Academic period-based or financial aid year-based designator description. VARCHAR2(255)

CALCULATION

FUNCTION

CASE WHEN DESIGNATOR_TYPE = 'T' THEN DESIGNATOR_DESC = SUBSTR ( (SELECT VALUE_DESCRIPTION FROM MGT_VALIDATION WHERE TABLE_NAME = 'TTVTBDS' AND VALUE = A.DESIGNATOR), 1, 255) ELSE WHEN DESIGNATOR_TYPE = 'Y THEN DESIGNATOR_DESC = SUBSTR ( (SELECT VALUE_DES

CASE WHEN TBBDETC_TBDC_IND

DESIGNATOR_IND Indicates whether the academic period-based or finanical aid year-based designator is used. VARCHAR2(1)

FUNCTION

CASE WHEN TBBDETC_TBDC_IND

DESIGNATOR_TYPE Indicates if the designator used to extract the finance accounting line was an academic period-based designator or a financial aid year-based designator. VARCHAR2(1)

CALCULATION

FUNCTION

CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE;

CASE WHEN TBBDETC_TBDC_IND

DESIGNATOR_TYPE_DESC Designator type description. VARCHAR2(255)

CALCULATION

FUNCTION

CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE_DESC = 'ACADEMIC PERIOD-BASED' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE_DESC = 'AID YEAR-BASED' ELSE DESIGNATOR_TYPE_DESC = 'NO DESIGNATOR' END CASE;

CASE WHEN TBBDETC_TBDC_IND

DETAIL_CODE Code defining type of transaction in accounts receivable. VARCHAR2(63)

TBRACCT

TBRACCT_DETAIL_CODE

DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

DETAIL_CODE_TYPE Determines if the detail code is being used as a charge or a payment. VARCHAR2(1)

TBBDETC

TBBDETC_TYPE_IND

EFFECTIVE_DATE Date the transaction becomes effective. As of this date, the transaction is calculated into amount due and is eligible to be fed to accounting. DATE

TBBEACT

TBBEACT_EFF_DATE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NEXT_CHANGE_DATE Date at which this information changes. DATE

TBBEACT

TBBEACT_NCHG_DATE

PERCENT Percentage of the amount associated with the detail that would be posted with this accounting distribution. NUMBER

TBRACCT

TBRACCT_PERCENT

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA



Ver: 8.4.1