Groups
CDR_FILE_DEF
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | ||
| 2 | NAME | VARCHAR2 | 250 | Y | ||
| 3 | DESCRIPTION | VARCHAR2 | 250 | Y | ||
| 4 | KEY | VARCHAR2 | 100 | Y | ||
| 5 | CODE | VARCHAR2 | 250 | Y | ||
| 6 | MAX_RECORDS | NUMBER | 22 | Y | ||
| 7 | CDR_PARSER_ID | NUMBER | 22 | Y | ||
| 8 | BILLING_SOURCE_TABLE_NAME | VARCHAR2 | 250 | N | ||
| 9 | RECORD_SEPARATOR_ID | NUMBER | 22 | Y | ||
| 10 | FILENAME_FORMAT | VARCHAR2 | 250 | Y | ||
| 11 | EXPORT_TYPE | VARCHAR2 | 100 | Y | ||
| 12 | PRE_EXPORT_PROCEDURE | VARCHAR2 | 250 | Y | ||
| 13 | XML_DOCUMENT_DEF_ID | NUMBER | 22 | Y | ||
| 14 | BILLING_SOURCE_CLASS | VARCHAR2 | 800 | Y | ||
| 15 | FILE_NAME_SUFFIX | VARCHAR2 | 40 | Y | ||
| 16 | FILE_NAME_GENERATOR_METHOD | VARCHAR2 | 400 | Y | ||
| 17 | PRE_PROCESSOR_METHOD | VARCHAR2 | 800 | Y | Can specify e.g. method to be used for file validation before processing of files | |
| 18 | POST_PROCESSOR_METHOD | VARCHAR2 | 800 | Y | Can specify e.g. method to be used for file validation after processing of files | |
| 19 | ERROR_PROCESSOR_METHOD | VARCHAR2 | 800 | Y | ||
| 20 | RECORD_FOR_HEADER | VARCHAR2 | 1 | Y | ||
| 21 | STATUS_COLUMN_NAME | VARCHAR2 | 400 | Y | ||
| 22 | NUMBER_OF_RECS_COLUMN_NAME | VARCHAR2 | 400 | Y | ||
| 23 | DATE_LOADED_COLUMN_NAME | VARCHAR2 | 400 | Y | ||
| 24 | SAVE_RECORD_ORDER | VARCHAR2 | 1 | Y | ||
| 25 | RECORD_ORDER_COLUMN_NAME | VARCHAR2 | 400 | Y | ||
| 26 | STATUS_VALUE | VARCHAR2 | 40 | Y |