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

AR_TRANSACTION Table

Explanation
Contains receivables transaction header details.

Common Uses

• Reporting on receivables transaction details at the award or transaction header level.
• Reporting on receivables balances at the award or transaction header level.
  
  

TRX_ID 

      

BBR_CUSTOMER_REGISTRY_ID 
BBR_AWARD_NUMBER 
BBR_AWARD_ORGANIZATION 
TRX_ID 
TRX_NUMBER 
TRX_DATE 
TRX_DATE_ACCT_PERIOD 
TRX_DATE_FISCAL_MONTH_SEQ 
TRX_DATE_FISCAL_YEAR 
INV_GL_DATE 
INV_GL_DATE_ACCT_PERIOD 
INV_GL_DATE_FISCAL_MONTH_SEQ 
INV_GL_DATE_FISCAL_YEAR 
PENNERA_SPONSOR_CODE 
INITIAL_CUSTOMER_TRX_ID 
CREDITED_TRX_ID 
RELATED_TRX_ID 
EXTRACT_DATE 
EXTRACT_DATE_PAY_SCHED 

AR_TRANSACTION_LINE
AR_APPLICATION
AR_ADJUSTMENT

• Transaction "balances" such as BALANCE_DUE_TOTAL in the AR_TRANSACTION table always contain the current balance for the transaction. Historical balances for a transaction may be obtained by querying the AR_TRANSACTION_LINE, AR_APPLICATION and AR_ADJUSTMENT tables.
• A single transaction may span multiple funds. As a reult, fund level balances can only be obtained by querying the AR_TRANSACTION_LINE, AR_APPLICATION and AR_ADJUSTMENT tables.
• EXTRACT_DATE is the date when the transaction header attributes were extracted from BEN Billing and Receivables and loaded into the Data Warehouse.
• EXTRACT_DATE_PAY_SCHEDULE is the date when the transaction header balances were extracted from BEN Billing and Receivables and loaded into the Data Warehouse. The EXTRACT_DATE and the EXTRACT_DATE_PAY_SCHEDULE may be different.
• Users with University-wide access may see all the AR_TRANSACTION records. Users with Organization-based access may see only those records which they are authorized to access based on the BBR_AWARD_ORGANIZATION.

Source

From the AR.RA_CUSTOMER_TRX_ALL and AR.AR_PAYMENT_SCHEDULES_ALL 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_TRANSACTION Table - Data Element Index   Tables and Data Elements   BEN Billing and Receivables Home   Data Warehouse Home