What is Bills receivable ?
Bills Receivable (B/R) is a bill of exchange accepted by a debtor or is received in way of an endorsement from them. The amount which is due to be received on a specific date is mentioned in the bill.
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.
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
Bills Receivable (B/R) is a bill of exchange accepted by a debtor or is received in way of an endorsement from them. The amount which is due to be received on a specific date is mentioned in the bill.
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.
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
