AR_APPLICATION Table - Data Element Index   Tables and Data Elements   BEN Billing and Receivables Home   Data Warehouse Home

AR_APPLICATION Table

Explanation
Contains line level receipt application details for receivables transactions.

Common Uses

• Reporting on receipt application details at the award, fund, transaction or transaction line level.
• Reporting on receivables balances at the award, fund, transaction or transaction line level.
  
  

TRX_LINE_ID 
RECEIVABLE_APPLICATION_ID 

      

BBR_CUSTOMER_REGISTRY_ID 
BBR_AWARD_NUMBER 
BBR_INSTALLMENT_NUMBER 
BBR_PROJECT_NUMBER 
BBR_EVENT_NUMBER 
BBR_TASK_NUMBER 
BBR_RECEIPT_NUMBER 
BBR_AWARD_ORG 
BBR_PROJECT_ORG_CODE 
COA_RESPONSIBLE_ORG 
TRX_NUMBER 
TRX_LINE_NUMBER 
TRX_ID TRX_LINE_ID 
CASH_RECEIPT_ID 
RECEIVABLE_APPLICATION_ID 
APPLY_DATE 
APPLY_DATE_ACCT_PERIOD 
APPLY_DATE_FISCAL_MONTH_SEQ 
APPLY_DATE_FISCAL_YEAR 
APPLICATION_GL_DATE 
APP_GL_DATE_ACCT_PERIOD 
APP_GL_DATE_FISCAL_MONTH_SEQ 
APP_GL_DATE_FISCAL_YEAR 
APPLICATION_GL_POSTED_DATE 
PENNERA_SPONSOR_CODE 
COA_CNAC 
COA_ORG 
COA_BC 
COA_FUND 
COA_OBJECT 
COA_PROGRAM 
COA_CREF 
EXTRACT_DATE 

AR_TRANSACTION
AR_TRANSACTION_LINE
AR_ADJUSTMENT

• The AR_APPLICATION table may contain "header level" receipt applications. These receipt applications are not applied to a specific transaction line but to the transaction as whole. Header level application records cannot be related to a specfic line and the TRX_LINE_ID field will be null for these records.
• EXTRACT_DATE is the date when the record was extracted from BEN Billing and Receivables and loaded into the Data Warehouse.
• Users with University-wide access may see all the AR_APPLICATION records. Users with Organization-based access may see only those records which they are authorized to access based on the BBR_AWARD_ORG, BBR_PROJECT_ORG_CODE, COA_RESPONSIBLE_ORG or COA_ORG.

Source

Primarily from the AR.AR_RECEIVABLE_APPLICATIONS_ALL and AR.AR_ACTIVITY_DETAILS tables in the BEN Billing and Receivables (BBR) system used by the Office of Research Services.

BEN Billing and Receivables is used to track award payments due and received for sponsored project funds where the sponsors either send payments as they are billed for project expenses, or send payments based on a schedule.

AR_APPLICATION Table - Data Element Index   Tables and Data Elements   BEN Billing and Receivables Home   Data Warehouse Home