This post will list the tables needed to verify data and building reports for Oracle cloud Receivables.
| Table Name | Purpose | Primary Key | Important columns | Important Joins |
|---|---|---|---|---|
| RA_CUSTOMER_TRX_ALL | This table consists of header information for receivable invoices, debit memo and credit memo | CUSTOMER_TRX_ID | TRX_NUMBER TRX_DATE COMPLETE_FLAG | |
| RA_CUSTOMER_TRX_LINES_ALL | This table consists of line information for receivable invoices, debit memo and credit memo | CUSTOMER_TRX_LINE_ID | LINE_NUMBER DESCRIPTION | CUSTOMER_TRX_ID= RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID |
| RA_CUST_TRX_TYPES_ALL | This table consists of information on the transaction types used for Receivable invoices, Debit Memos and Credit memos | CUST_TRX_TYPE_ID | NAME DESCRIPTION | CUST_TRX_TYPE_SEQ_ID = RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_SEQ_ID |
| AR_RECEIVABLE_APPLICATIONS_ALL | This table consists of the Accounting entries of cash and credit memo applications. Possible statuses of your applications include APP, UNAPP, ACC, and UNID | RECEIVABLE_APPLICATION_ID | CASH_RECEIPT_ID ORG_ID AMOUNT_APPLIED PAYMENT_SCHEDULE_ID | CASH_RECEIPT_ID = AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID CUSTOMER_TRX_ID= RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID APPLIED_CUSTOMER_TRX_ID= RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID |
| AR_CASH_RECEIPTS_ALL | This table consists of one record for each receipt you enter in Oracle. | CASH_RECEIPT_ID | RECEIPT_NUMBER RECEIPT_DATE RECEIPT_METHOD_ID STATUS RECEIVABLES_TRX_ID | CUSTOMER_BANK_ACCOUNT_ID=IBY_EXT_BANK_ACCOUNTS.EXT_BANK_ACCOUNT_ID RECEIPT_METHOD_ID=AR_RECEIPT_METHODS.RECEIPT_METHOD_ID RECEIVABLES_TRX_ID=AR_RECEIVABLES_TRX_ALL.RECEIVABLES_TRX_ID ORG_ID=AR_RECEIVABLES_TRX_ALL.ORG_ID |
| AR_PAYMENT_SCHEDULES_ALL | The table consists all transactions except adjustments and miscellaneous cash receipts. | PAYMENT_SCHEDULE_ID | AMOUNT_DUE_ORIGINAL AMOUNT_DUE_REMAINING INVOICE_CURRENCY_CODE CUSTOMER_TRX_ID TRX_NUMBER TRX_DATE | CUSTOMER_ID=HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID CUSTOMER_TRX_ID= RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID CASH_RECEIPT_ID = AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID PAYMENT_SCHEDULE_ID=AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_PAYMENT_SCHEDULE_ID |
| HZ_PARTIES | The table consists of links between distribution information with your receivables activities. Possible activity types include Adjustment, Miscellaneous Cash, and Finance Charge. | RECEIVABLES_TRX_ID, ORG_ID | NAME CODE_COMBINATION_ID SET_OF_BOOKS_ID DESCRIPTION STATUS | CODE_COMBINATION_ID=GL_CODE_COMBINATIONS.CODE_COMBINATION_ID |
| HZ_CUST_ACCOUNTS | ||||
| HZ_CUST_ACCT_SITES_ALL | ||||
| HZ_CUST_SITE_USES_ALL | ||||