The product supplies a base collection letter extract algorithm C1-LTR-CLLDC. It includes the common record types as described above as well as additional records with new record types. These records are described below.
The following table lists the record types used for the collection letter.
Record Type |
Description |
Notes |
1600 | Overdue Process record | Required. 1 per letter. |
Note | The subsequent record types depend on the 'collecting on' object for the overdue process. The algorithm supports 'collecting on' object of obligation or assessment. If it's obligation, then record types 1620 and 1622 are populated. If it's assessment, then record types 1650 and 1652 are populated. | |
1620 | Overdue Process Obligation record | A record will exist for each obligation linked as a 'collecting on' object to the overdue process. |
1622 | Overdue Process Obligation Debt Category record | A record will exist for each combination of obligation and debt category for outstanding debt. |
1650 | Overdue Process Assessment record | A record will exist for each assessment linked as a 'collecting on' object to the overdue process. |
1652 | Overdue Process Assessment Debt Category record | A record will exist for each combination of assessment and debt category for outstanding debt. |
The following table describes the structure of the sort key and the values for the collection letter record types.
Field Name |
Format |
Source / Value / Description |
LTR_TMPL_CD | A12 | |
CC_ID | A10 | |
CC Record Group | A2 | 30 - Collection type letters |
Sub Record Group | A2 |
This field forces the subordinate records into the correct order. Values: 10 – Overdue Process record 20 – Overdue Process Obligation record 30 – Overdue Process Obligation Debt Category record 40 – Overdue Process Assessment record 50 – Overdue Process Assessment Debt Category record |
Mailing key contains the postal code.
The following shows the letter information for the collection letter record types together with their associated record type, sort and mailing key.
Overdue Process Record
This record contains information about the overdue process and event that triggered the letter.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "1600" |
Sort Key | A26 | |
Mailing Key | A15 | |
OD_PROC_ID | A12 | CI_OD_PROC_LOG / Overdue process that triggered the letter. |
OD_EVT_SEQ | N3 | CI_OD_PROC_LOG / Overdue event that triggered the letter. |
ACCT_ID | A10 | CI_OD_PROC / Account being collected on. |
OD_PROC_TEMPL_CD | A12 | CI_OD_PROC / Overdue process template. |
DESCR | A60 | CI_OD_PROC_TMP / Description of the overdue process template (using the language of the customer contact's Person). |
CRE_DTTM | DT25 | CI_OD_PROC / Date/time that the overdue process was created. |
CURRENCY_CD | C3 | CI_OD_PROC / Currency for the amount. |
CHAR_TYPE_CD | C8 | CI_OD_PROC_TMP/Char Type of Objects Collecting On |
Overdue Process Obligation Record
If the Overdue Process is 'Collecting On' Obligations, this record contains the obligation details. There will be 1 record for each obligation in the collection.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "1620" |
Sort Key | A26 | |
Mailing Key | A15 | |
SA_ID | A10 | CI_SA / Id of the Obligation |
START_DT | N10 | CI_SA / Start Date of the Obligation |
END_DT | N10 | CI_SA / End Date of the Obligation |
DESCR | A60 | CI_SA_TYPE_L / Description of the Obligation Type (using the language of the customer contact's Person) |
Overdue Process Obligation Debt Category Record
If the Overdue Process is 'Collecting On' Obligations, this record contains the breakdown of the credit allocation by debt category for the given obligation. This is done by calling the "determine balance details" business service (BS). A record exists for every debt category for the obligation's FTs that have outstanding debt.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "1622" |
Sort Key | A26 | |
Mailing Key | A15 | |
SA_ID | A10 | CI_SA / Id of the Obligation |
DEBT_CAT_CD | A8 | From Determine Balance Details BS / Debt category |
DESCR | A60 | From Determine Balance Details BS / Description of Debt Category. (using the language of the Customer Contact's Person) |
C1_DEBIT_AMT | N13.2 | From Determine Balance Details BS / Assessed Amount |
C1-PAY_AMT | N13.2 | From Determine Balance Details BS / Payment Amount |
C1_WV_AMT | N13.2 | From Determine Balance Details BS / Waive Amount |
C1_WO_AMT | N13.2 | From Determine Balance Details BS / Write Off Amount |
C1_OC_AMT | N13.2 | From Determine Balance Details BS / Other Credit Amount |
C1_BAL_AMT | N13.2 | From Determine Balance Details BS / Balance Amount |
DEBT_TYPE_FLG | A4 | From Determine Balance Details BS / Debt Type |
Overdue Process Assessment Record
If the Overdue Process is 'Collecting On' Assessments, this record contains the assessment details. There will be 1 record for each assessment in the collection.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "1650" |
Sort Key | A26 | |
Mailing Key | A15 | |
FT_ID | A12 | CI_FT / FT Id of the Assessment |
FREEZE_DTTM | N26 | CI_FT / Freeze Date Time of Assessment |
SA_ID | A10 | CI_SA / Id of the Assessment’s obligation |
START_DT | N10 | CI_SA / Start Date of the Assessment’s obligation |
END_DT | N10 | CI_SA / End Date of the Assessment’s obligation |
DESCR | A60 | CI_SA_TYPE_L / Description of the Assessment’s Obligation Type (using the language of the customer contact's Person) |
Overdue Process Obligation Debt Category Record
If the Overdue Process is 'Collecting On' Assessments, this record contains the breakdown of the credit allocation by debt category for the given assessment. This is done by calling the "determine balance details" business service (BS) for the assessment's obligation and then retrieving the detail specific for this assessment. A record exists for every debt category for the assessment's related FTs that have outstanding debt.
Field Name |
Format |
Source / Value / Description |
Record Type | A4 | "1652" |
Sort Key | A26 | |
Mailing Key | A15 | |
FT_ID | A12 | CI_FT / Id of the Assessment |
DEBT_CAT_CD | A8 | From Determine Balance Details BS / Debt category |
DESCR | A60 | From Determine Balance Details BS / Description of Debt Category. (using the language of the Customer Contact's Person) |
C1_DEBIT_AMT | N13.2 | From Determine Balance Details BS / Assessed Amount |
C1-PAY_AMT | N13.2 | From Determine Balance Details BS / Payment Amount |
C1_WV_AMT | N13.2 | From Determine Balance Details BS / Waive Amount |
C1_WO_AMT | N13.2 | From Determine Balance Details BS / Write Off Amount |
C1_OC_AMT | N13.2 | From Determine Balance Details BS / Other Credit Amount |
C1_BAL_AMT | N13.2 | From Determine Balance Details BS / Balance Amount |
DEBT_TYPE_FLG | A4 | From Determine Balance Details BS / Debt Type |
The following points describe the source of the collection letter’s address:
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.