Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{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
width33%

CDR_FIELD_FORMAT_DEF

Col #Column NameData TypeField LengthNot 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
width33%

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).