Reporting View Target: RECEIVABLE

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Accounts Receivable Reporting View Reports

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 Local Source Local Target

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

TBRACCT_ACCOUNT_A

NO
NO

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

TBRACCT_ACCOUNT_B

NO
NO

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

NA

NO
NO

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

TBRACCT_A_ACCT_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_A_ACTV_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_A_COAS_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_A_FUND_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_A_LOCN_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_A_ORGN_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_A_PROG_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_A_RUCL_CODE1

NO
NO

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

TBRACCT_A_RUCL_CODE2

NO
NO

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

TBRACCT_A_RUCL_CODE3

NO
NO

A_RULE_CLASS_DESC1 First rule class description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

A_RULE_CLASS_DESC2 Second rule class description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

A_RULE_CLASS_DESC3 Third rule class description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_ACCT_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_ACTV_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_COAS_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_FUND_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_LOCN_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_ORGN_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_PROG_CODE

NO
NO

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

GOKODSF.F_GET_DESC

NO
NO

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

TBRACCT_B_RUCL_CODE1

NO
NO

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

TBRACCT_B_RUCL_CODE2

NO
NO

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

TBRACCT_B_RUCL_CODE3

NO
NO

B_RULE_CLASS_DESC1 First rule class description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

B_RULE_CLASS_DESC2 Second rule class description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

B_RULE_CLASS_DESC3 Third rule class description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

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

CASE WHEN NVL(TBBEACT_TBDC_IND, 'N')

NO
NO

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

TTVABDS_DESC
TTVTBDS_DESC

NO
NO
NO

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

CASE WHEN TBBEACT_TBDC_IND

NO
NO

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 =

NO
NO

DESIGNATOR_TYPE_DESC Designator type description. VARCHAR2(255)
CALCULATION

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

NO
NO

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

TBRACCT_DETAIL_CODE

NO
NO

DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

NO
NO

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

TBBDETC_TYPE_IND

NO
NO

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

NO
NO

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

NA

NO
NO

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

NA

NO
NO

NEXT_CHANGE_DATE Date at which this information changes. DATE
TBBEACT

TBBEACT_NCHG_DATE

NO
NO

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

TBRACCT_PERCENT

NO
NO

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

NA

NO
NO

Ver: 9.2

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	Local Source	Local Target
ACCOUNT_A	Actual account number from a finance system associated with this detail code.	VARCHAR2(63)	TBRACCT	TBRACCT_ACCOUNT_A	NO	NO
ACCOUNT_B	Actual account number from a finance system associated with this detail code.	VARCHAR2(63)	TBRACCT	TBRACCT_ACCOUNT_B	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
A_ACCOUNT	Banner finance account code for account a.	VARCHAR2(63)	TBRACCT	TBRACCT_A_ACCT_CODE	NO	NO
A_ACCOUNT_DESC	Banner finance account description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
A_ACCOUNT_INDEX_DESC	Banner finance account index description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_ACTIVITY	Banner finance activity code for account a.	VARCHAR2(63)	TBRACCT	TBRACCT_A_ACTV_CODE	NO	NO
A_ACTIVITY_DESC	Banner finance activity description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_CHART_OF_ACCOUNTS	Banner finance chart of accounts code for account a.	VARCHAR2(63)	TBRACCT	TBRACCT_A_COAS_CODE	NO	NO
A_CHART_OF_ACCOUNTS_DESC	Banner finance chart of accounts description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_FUND	Banner finance fund code for account a.	VARCHAR2(63)	TBRACCT	TBRACCT_A_FUND_CODE	NO	NO
A_FUND_DESC	Banner finance fund description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_LOCATION	Banner finance location code for account a.	VARCHAR2(63)	TBRACCT	TBRACCT_A_LOCN_CODE	NO	NO
A_LOCATION_DESC	Banner finance location description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_ORGANIZATION	Banner finance organization code for account a.	VARCHAR2(63)	TBRACCT	TBRACCT_A_ORGN_CODE	NO	NO
A_ORGANIZATION_DESC	Banner finance organization description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_PROGRAM	Banner finance program code for account a.	VARCHAR2(63)	TBRACCT	TBRACCT_A_PROG_CODE	NO	NO
A_PROGRAM_DESC	Banner finance program description for account a.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_RULE_CLASS1	First accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT	TBRACCT_A_RUCL_CODE1	NO	NO
A_RULE_CLASS2	Second accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT	TBRACCT_A_RUCL_CODE2	NO	NO
A_RULE_CLASS3	Third accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT	TBRACCT_A_RUCL_CODE3	NO	NO
A_RULE_CLASS_DESC1	First rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_RULE_CLASS_DESC2	Second rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
A_RULE_CLASS_DESC3	Third rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_ACCOUNT	Banner finance account code for account b.	VARCHAR2(63)	TBRACCT	TBRACCT_B_ACCT_CODE	NO	NO
B_ACCOUNT_DESC	Banner finance account description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
B_ACCOUNT_INDEX_DESC	Banner finance account index description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_ACTIVITY	Banner finance activity code for account b.	VARCHAR2(63)	TBRACCT	TBRACCT_B_ACTV_CODE	NO	NO
B_ACTIVITY_DESC	Banner finance activity description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_CHART_OF_ACCOUNTS	Banner finance chart of accounts code for account b.	VARCHAR2(63)	TBRACCT	TBRACCT_B_COAS_CODE	NO	NO
B_CHART_OF_ACCOUNTS_DESC	Banner finance chart of accounts description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_FUND	Banner finance fund code for account b.	VARCHAR2(63)	TBRACCT	TBRACCT_B_FUND_CODE	NO	NO
B_FUND_DESC	Banner finance fund description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_LOCATION	Banner finance location code for account b.	VARCHAR2(63)	TBRACCT	TBRACCT_B_LOCN_CODE	NO	NO
B_LOCATION_DESC	Banner finance location description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_ORGANIZATION	Banner finance organization code for account b.	VARCHAR2(63)	TBRACCT	TBRACCT_B_ORGN_CODE	NO	NO
B_ORGANIZATION_DESC	Banner finance organization description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_PROGRAM	Banner finance program code for account b.	VARCHAR2(63)	TBRACCT	TBRACCT_B_PROG_CODE	NO	NO
B_PROGRAM_DESC	Banner finance program description for account b.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_RULE_CLASS1	First accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT	TBRACCT_B_RUCL_CODE1	NO	NO
B_RULE_CLASS2	Second accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT	TBRACCT_B_RUCL_CODE2	NO	NO
B_RULE_CLASS3	Third accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT	TBRACCT_B_RUCL_CODE3	NO	NO
B_RULE_CLASS_DESC1	First rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_RULE_CLASS_DESC2	Second rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
B_RULE_CLASS_DESC3	Third rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESIGNATOR	Academic period-based or financial aid year-based designator.	VARCHAR2(63)	CALCULATION	CASE WHEN NVL(TBBEACT_TBDC_IND, 'N')	NO	NO
DESIGNATOR_DESC	Academic period-based or financial aid year-based designator description.	VARCHAR2(255)	TTVABDS TTVTBDS	TTVABDS_DESC TTVTBDS_DESC	NO NO	NO
DESIGNATOR_IND	Indicates whether the academic period-based or finanical aid year-based designator is used.	VARCHAR2(1)	CALCULATION	CASE WHEN TBBEACT_TBDC_IND	NO	NO
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 =	NO	NO
DESIGNATOR_TYPE_DESC	Designator type description.	VARCHAR2(255)	CALCULATION	CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =	NO	NO
DETAIL_CODE	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBRACCT	TBRACCT_DETAIL_CODE	NO	NO
DETAIL_CODE_DESC	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC	NO	NO
DETAIL_CODE_TYPE	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)	TBBDETC	TBBDETC_TYPE_IND	NO	NO
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	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NEXT_CHANGE_DATE	Date at which this information changes.	DATE	TBBEACT	TBBEACT_NCHG_DATE	NO	NO
PERCENT	Percentage of the amount associated with the detail that would be posted with this accounting distribution.	NUMBER	TBRACCT	TBRACCT_PERCENT	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO