RETURN TO COMPOSITE VIEW REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Operational Data Store
Composite View Target: AT_LEDGER_ACCOUNTING

Description Source composite view contains accounting rules relative to each detail code.

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(60)

TBRACCT

TBRACCT_ACCOUNT_A

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

TBRACCT

TBRACCT_ACCOUNT_B

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

TBRACCT

TBRACCT_A_ACCT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_ACTV_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_COAS_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_LOCN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_ORGN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_PROG_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_A_RUCL_CODE1

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

TBRACCT

TBRACCT_A_RUCL_CODE2

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

TBRACCT

TBRACCT_A_RUCL_CODE3

A_RULE_CLASS_DESC1 First rule class description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

A_RULE_CLASS_DESC2 Second rule class description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

A_RULE_CLASS_DESC3 Third rule class description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_ACCT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_ACTV_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_COAS_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_FUND_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_LOCN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_ORGN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_PROG_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCT

TBRACCT_B_RUCL_CODE1

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

TBRACCT

TBRACCT_B_RUCL_CODE2

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

TBRACCT

TBRACCT_B_RUCL_CODE3

B_RULE_CLASS_DESC1 First rule class description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

B_RULE_CLASS_DESC2 Second rule class description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

B_RULE_CLASS_DESC3 Third rule class description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DESIGNATOR Academic period-based designator. VARCHAR2(2)

TBRACCT

TBRACCT_TBDS_CODE

DESIGNATOR_IND Indicates whether the academic period-based designator is to be used. VARCHAR2(1)

TBBEACT

TBBEACT_TBDC_IND

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

TBBDETC

TBBDETC_DETAIL_CODE

DETAIL_CODE_DESC Transaction type description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

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

TBBDETC

TBBDETC_DESC

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

EFFECTIVE_DATE Record effective date. DATE

TBBEACT

TBBEACT_EFF_DATE

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

NA

NA

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

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(8, 5)

TBRACCT

TBRACCT_PERCENT

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

NA

NA



Ver: 3.1