Table and Column Descriptions
Below is a description of the important tables and columns Receivables uses to store information for your dunning letters and dunning letter submissions. Each column has important detail information which indicates the column's function for dunning.
AR_DUNNING_LETTER_SETS
This table stores the parameter values that you specify for each dunning letter set, and the sequence in which each set's letters are sent to your customers and their sites.
Column Name
Value
DUNNING_LETTER_
SET_ID
DUNNING_LETTER_SET_ID is the primary key. This column is a foreign key in the AR_CUSTOMER_PROFILES and AR_CUSTOMER_PROFILE_CLASSES tables. This ID column in these two tables stores the ID of the dunning letter set that you have assigned to your customer profiles and standard credit profiles respectively.
NAME
This column contains the name of the dunning letter set.
AR_DUNNING_LETTERS
This table stores information about each dunning letter that you define such as the letter name, its review date, description, and status.
Column Name
Value
DUNNING_LETTER_
ID
This column is a foreign key to the AR_DUNNING_LETTER_SET_LINES table which identifies each letter that you assign to a dunning letter set.
LETTER_NAME
This column stores the name of each of your dunning letters. Oracle Receivables provides letters USER1 - 10 and STANDARD1 - 3 as default letters. You can create letters with new names using Oracle Reports.
AR_DUNNING_LETTER_SET_LINES
This table stores the individual lines of a dunning letter set, including the Days Past Due range, and Yes or No values for including current invoices and copies of invoices with each letter within a dunning letter set.
AR_CORRESPONDENCES
This table stores one record for each dunning letter that you send to a customer or site. Each row includes information about which letter was sent, what dunning letter set it belongs to, when it was sent, and the customer or customer site that was sent to.
Column Name
Value
CORRESPONDENCE_DATE
This column stores the date on which you created a specific dunning letter.
REFERENCE1
This column stores the ID of the dunning letter set to which this dunning letter belongs, and is a foreign key to the AR_DUNNING_LETTER_SETS table.
REFERENCE2
This column stores the ID of the dunning letter, and is a foreign key to the AR_DUNNING_LETTERS table.
AR_CORRESPONDENCE_PAY_SCHED
This table stores one record for each invoice selected for dunning. Each row includes invoice and correspondence information such as the invoice's payment schedule number and the amount of interest the invoice has accrued.
Column Name
Value
CORRESPONDENCE_PAY_SCHED_ID
This column is the primary key which uniquely identifies each invoice selected for dunning.
PAYMENT_
SCHEDULE_ID
This column stores the ID of the payment schedule of each invoice selected for dunning and is a foreign key to the AR_PAYMENT_SCHEDULES table.
CORRESPONDENCE_ID
This column stores the ID of the dunning letter you generated which includes this invoice. This column is a foreign key to the AR_CORRESPONDENCES table.
See Also
Dunning Letters