{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
CDR_FIELD_FORMAT_DEF
Col #
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
NAME
VARCHAR2
250
Y
Name of Field format definition.
3
CODE
VARCHAR2
100
Y
Code used for sub-classing.
4
DESCRIPTION
VARCHAR2
250
Y
Description of field format definition.
5
FILLER
VARCHAR2
10
Y
Filler used to format field before export. If present in the corresponding CDR_FIELD_DEF, the filler from CDR_FIELD_DEF is used.
6
PADDING
VARCHAR2
100
Y
Padding used to format field before export. If present in the corresponding CDR_FIELD_DEF, the padding from CDR_FIELD_DEF is used.
7
DECIMAL_PLACES
NUMBER
22
Y
Number of decimal places to use. If decimal format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
8
DECIMAL_SEPARATOR
CHAR
1
Y
No longer used. The COUNTRY_LOCALE now defines the decimal separator.
9
DATE_FORMAT
VARCHAR2
100
Y
Format of date, if this is a date format definition (CODE = 'DATE'). If format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
10
DATA_FORMAT
VARCHAR2
100
Y
Format of field data (regular expression), if this is a data format definition (CODE = 'DATA'). If format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
11
TIME_FORMAT
VARCHAR2
100
Y
Format of time, if this is a time format definition (CODE = 'TIME'. If format is present in the corresponding CDR_FIELD_DEF, the format from CDR_FIELD_DEF is used.
12
COUNTRY_LOCALE
VARCHAR2
12
Y
Locale used to define the decimal separator, Used for Decimal (CODE = 'DECIMAL'), signed-decimal (CODE = 'SIGNED-DECIMAL') format definitions. Examples are such as "NL" and "GB".
Column
width
33%
A CDR field format definition (Class:CdrFieldFormatDef, Table: CDR_FIELD_FORMAT_DEF) defines the format of a field defitnion (CDR_FIELD_DEF) (see /wiki/spaces/Integration/pages/119155850).