Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ACCOUNT_A Account A Actual account number from a finance system associated with this detail code. VARCHAR2(63)  

TBRACCT

TBRACCT_ACCOUNT_A

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

TBRACCT

TBRACCT_ACCOUNT_B

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

NA

NA

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

TBRACCT

TBRACCT_A_ACCT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

A_ACCOUNT_INDEX 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 A Account Index Description. Banner finance account index description for account a. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_ACTV_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

A_CHART_OF_ACCOUNTS 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 A Chart Of Accounts Description Banner finance chart of accounts description for account a. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_LOCN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_ORGN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_PROG_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_RUCL_CODE1

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

TBRACCT

TBRACCT_A_RUCL_CODE2

A_RULE_CLASS3 A Rule Class 3 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 A Rule Class Description 1 First rule class description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

A_RULE_CLASS_DESC2 A Rule Class Description 2 Second rule class description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

A_RULE_CLASS_DESC3 A Rule Class Description 3 Third rule class description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_ACCT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

B_ACCOUNT_INDEX 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 B Account Index Description Banner finance account index description for account b. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_ACTV_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

B_CHART_OF_ACCOUNTS 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 B Chart Of Accounts Description Banner finance chart of accounts description for account b. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_LOCN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_ORGN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_PROG_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_RUCL_CODE1

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

TBRACCT

TBRACCT_B_RUCL_CODE2

B_RULE_CLASS3 B Rule Class 3 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 B Rule Class Description 1 First rule class description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

B_RULE_CLASS_DESC2 B Rule Class Description 2 Second rule class description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

B_RULE_CLASS_DESC3 B Rule Class Description 3 Third rule class description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

CASE WHEN NVL(TBBEACT_TBDC_IND, 'N')

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

TTVABDS

TTVTBDS

TTVABDS_DESC

TTVTBDS_DESC

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

CALCULATION

CASE WHEN TBBEACT_TBDC_IND

DESIGNATOR_TYPE 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

CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE =

DESIGNATOR_TYPE_DESC Designator Type Description Designator type description. VARCHAR2(255)  

CALCULATION

CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =

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

TBRACCT

TBRACCT_DETAIL_CODE

DETAIL_CODE_DESC Detail Code Description Transaction type description. VARCHAR2(255)  

TBBDETC

TBBDETC_DESC

DETAIL_CODE_TYPE 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 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 Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

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

NA

NA

NEXT_CHANGE_DATE Next Change Date Date at which this information changes. DATE  

TBBEACT

TBBEACT_NCHG_DATE

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

TBRACCT

TBRACCT_PERCENT

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

NA

NA



Ver: 9.0