Total Pageviews

April 18, 2016

4/18/2016 02:36:00 AM
Bills Receivable Tables Oracle Accounts Receivable uses the following tables to store bills receivable information. • RA_CUSTOMER_TRX_ALL • RA_CUSTOMER_TRX_LINES_ALL • AR_TRANSACTION_HISTORY_ALL • AR_DISTRIBUTIONS_ALL • AR_PAYMENT_SCHEDULES_ALL
RA_CUSTOMER_TRX_ALL (Referenced in Customer Invoices section) Instructor Note:
Navigate to the Transaction window (responsibility: Receivables, Vision Operations):
 (N) Bills Receivable > Transactions
RA_CUSTOMER_TRX_LINES_ALL (Referenced in Customer Invoices section.
Navigate to the Transaction window (responsibility: Receivables, Vision Operations): (N) Bills Receivable > Transactions
RA_CUSTOMER_TRX_LINES_ALL (Referenced in Customer Invoices section) Instructor Note:  You must enable Bills Receivable in the System Options window to use this feature.
 (N) Bills Receivable > Transactions (B) Assignments
AR_PAYMENT_SCHEDULES_ALL (Referenced in Customer Invoices section
. Navigate to the Balances window (responsibility: Receivables, Vision Operations): (N) Transactions > Transactions (B) Balance
AR_TRANSACTION_HISTORY_ALL
• This table is a Bills Receivable-specific table containing the history of a transaction’s lifecycle. • A new row is created each time there is activity on the transaction or the status of the transaction has changed. • This table stores the header for the Receivables posting information.

Instructor Note Navigate to the Portfolio Management window (responsibility: Receivables, Vision Operations): (N) Bills Receivable > Portfolio Management (B) History

AR_DISTRIBUTIONS_ALL
• This table stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions.

Foreign Keys
Primary  Key Table                                     Primary Key Column                                Foreign Key Column 
AR_ADJUSTMENTS_ALL                                ADJUSTMENT_ID                           SOURCE_ID 
AR_CASH_RECEIPT_HISTORY_ALL          CASH_RECEIPT_HISTORY_ID      SOURCE_ID
AR_CASH_RECEIPT_HISTORY_ALL         CASH_RECEIPT_HISTORY_ID       SOURCE_ID 
AR_MISC_CASH_DISTRIBUTIONS_ALL   MISC_CASH_DISTRIBUTION_ID   SOURCE_ID 
AR_RECEIVABLE_APPLICATIONS_ALL    RECEIVABLE_APPLICATION_ID   SOURCE_ID 
AR_TAX_GROUP_CODES_ALL                    TAX_GROUP_CODE_ID                    SOURCE_ID 
AR_TRANSACTION_HISTORY_ALL           TRANSACTION_HISTORY_id         SOURCE_ID 
GL_CODE_COMBINATIONS                           CODE_COMBINATION_ID              CODE_COMBINATION_ID
Navigate to the View Accounting window (responsibility: Receivables, Vision Operations):
(N) Transactions > Transactions (B) Line Items OR Tools Menu > Choose View Accounting