| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|
| 1 | ID | NUMBER | 22 | N | | |
| 2 | NAME | VARCHAR2 | 250 | Y | | Name of the Cdr File Definition |
| 3 | DESCRIPTION | VARCHAR2 | 250 | Y | | Description of Cdr File Definition |
| 4 | KEY | VARCHAR2 | 100 | Y | | Unique key of a file defintion |
| 5 | CODE | VARCHAR2 | 250 | Y | | Code, in-case sub classing is needed in the future |
| 6 | MAX_RECORDS | NUMBER | 22 | Y | | Maximum number of records in a file (Default value -1 (no maximum number of records)) |
| 7 | CDR_PARSER_ID | NUMBER | 22 | Y | | Parser used for parsing a file into records (CDR_PARSER_ID = CDR_PARSER.ID) |
| 8 | BILLING_SOURCE_TABLE_NAME | VARCHAR2 | 250 | N | | Table name for storing file information source |
| 9 | RECORD_SEPARATOR_ID | NUMBER | 22 | Y | | Type of separator used for separating one record from another (RECORD_SEPARATOR_ID = ITEM_SEPARATOR.ID). The default is a carriage return line feed |
| 10 | FILENAME_FORMAT | VARCHAR2 | 250 | Y | | Format of filename to be loaded (Perl regular expression format). If set only filenames that match the format will be processed otherwise all files are processed |
| 11 | EXPORT_TYPE | VARCHAR2 | 100 | Y | | The type of file records to be exported. Used when generating export files. The source table (for export) must have a column with name 'EXPORT_TYPE' whose value must match this value |
| 12 | PRE_EXPORT_PROCEDURE | VARCHAR2 | 250 | Y | | Used when exporting files. Called before any final generation processing commences. Used to add extra export values that can only be added at time of export |
| 13 | XML_DOCUMENT_DEF_ID | NUMBER | 22 | Y | | Used when exporting XML files. (XML_DOCUMENT_DEF_ID = XML_DOCUMENT_DEF.ID) |
| 14 | BILLING_SOURCE_CLASS | VARCHAR2 | 800 | Y | | Class used to model the table defined in the column 'BILLING_SOURCE_TABLE_NAME'. |
| 15 | FILE_NAME_SUFFIX | VARCHAR2 | 40 | Y | | Suffix (extension) to be added to the export filename. |
| 16 | FILE_NAME_GENERATOR_METHOD | VARCHAR2 | 400 | Y | | Method on the BILLING_SOURCE_CLASS used to generate a filename during export. This method must take the ID of the record in the 'BILLING_SOURCE_TABLE_NAME' table, and the CDR_FILE_DEF ID as parameters. For example for exporting a CDR file, the ID will be the ID of the appropriate SP_FILE_HEADER record linked to the rated BILLING_RECORDs (BILLING_RECORD.SP_FILE_ID = SP_FILE_HEADER.ID) being exported. |
| 17 | PRE_PROCESSOR_METHOD | VARCHAR2 | 800 | Y | | Specifies Can specify e.g. method to be used for file validation before processing of files. |
| 18 | POST_PROCESSOR_METHOD | VARCHAR2 | 800 | Y | | Specifies method Can specify e.g. method to be used for file validation after processing of files. |
| 19 | ERROR_PROCESSOR_METHOD | VARCHAR2 | 800 | Y | | Method in the BILLING_SOURCE_CLASS called after processing a file. The method must take CdrFileDef object as parameter. Could be used for validating contents of the detail against information on the trailer. |
| 20 | RECORD_FOR_HEADER | VARCHAR2 | 1 | Y | | Possible values are Y and N. This column is solely taken into an account if the PERSIST column has the value Y. In case the first line in the loaded file must be stored in the BATCH_FILE_LINE table, the RECORD_FOR_HEADER column must be set to Y. |
| 21 | STATUS_COLUMN_NAME | VARCHAR2 | 400 | Y | | String value. Defines the column name for status of billing source table. If left empty a default name of STATUS is used. |
| 22 | NUMBER_OF_RECS_COLUMN_NAME | VARCHAR2 | 400 | Y | | String with default value 'NUMBER_OF_RECS'. Defines the column name, where the number of the content lines in a loaded file must be stored. |
| 23 | DATE_LOADED_COLUMN_NAME | VARCHAR2 | 400 | Y | | String with default value 'DATE_LOADED'. Defines the column name, where the time of the loading must be stored. The column is mandatory in the billing source table. |
| 24 | SAVE_RECORD_ORDER | VARCHAR2 | 1 | Y | | Char with possible values 'Y'/'N' and default value 'N'. Defines whether line number of a loaded record must be stored in the db. |
| 25 | RECORD_ORDER_COLUMN_NAME | VARCHAR2 | 400 | Y | | String with default value 'LINE_IN_FILE'. Defines the column name, where the line-number of the loaded record must be stored. |
| 26 | STATUS_VALUE | VARCHAR2 | 40 | Y | | String with default value '0'. Defines the status of the loaded file. |