ui-dt-number.sql

国外的一套开源CRM

-- Insert UiDisplayType
INSERT INTO UI_DISPLAY_TYPE (
  DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'Number Field'
 ,'Number field<BR><BR>Translates to an < INPUT type=TEXT > HTML tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'ALIGN'
 ,'Text Alignment'
 ,'Text alignment<BR><BR>Translates to ALIGN attribute of HTML < INPUT > tag.<BR>Value can be TOP, MIDDLE, or BOTTOM.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'ANCHOR_HREF_DEF'
 ,'Anchor (Link) Reference Definition'
 ,'Anchor (Link) Reference Definition<BR><BR>If this parameter is set, the field will be displayed as an HTML < A > tag when in read only-mode.<BR><BR>Contents must be a semicolon-delimited list of attribute names from the listed entity.<BR>Literal strings may also be embedded with quotes around them.<BR>Values from the specified attributes will be concatentated along with any embedded quoted literals, and used as the HREF value for the < A > tag.<BR>"#currentField" can be used in place of an attribute name to use the current field value.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'ANCHOR_TARGET'
 ,'Anchor (Link) Target'
 ,'Anchor (Link) Target<BR><BR>If this parameter and the ANCHOR_HREF_DEF parameter are set, the field will be displayed as an HTML < A > tag when in read-only mode, and the value of this parameter will be used as the value for the TARGET attribute of the < A > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'CLASS'
 ,'Class'
 ,'Style class<BR><BR>Defines what style from the style sheet to assign to the CLASS attribute of the < INPUT > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'DISABLED'
 ,'Disabled'
 ,'Disabled<BR><BR>Translates to DISABLED attribute of HTML < INPUT > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'DISPLAY_MASK'
 ,'Display Mask'
 ,'Display mask<BR><BR>Determines how the number will be displayed.<BR><BR>Example:<BR>9,999,990.0000'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'MAXLENGTH'
 ,'Maximum Length'
 ,'Maximum data length<BR><BR>Translates to MAXLENGTH attribute of HTML < INPUT > tag'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'MAX_FRAC_DIGITS'
 ,'Maximum Fraction Digits'
 ,'Maximum Fraction Digits<BR><BR>Defines the maximum number of digits to be displayed in the fractional portion of the number.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'MAX_INT_DIGITS'
 ,'Maximum Integer Digits'
 ,'Maximum Integer Digits<BR><BR>Defines the maximum number of digits to be displayed in the integer portion of the number.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'MIN_FRAC_DIGITS'
 ,'Minimum Fraction Digits'
 ,'Minimum Fraction Digits<BR><BR>Defines the minimum number of digits to be displayed in the fractional portion of the number.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'MIN_INT_DIGITS'
 ,'Minimum Integer Digits'
 ,'Minimum Integer Digits<BR><BR>Defines the minimum number of digits to be displayed in the integer portion of the number.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'READONLY'
 ,'Read Only'
 ,'Read only<BR><BR>Translates to READONLY attribute of HTML < INPUT > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'NUMBER'
 ,'SIZE'
 ,'Field Size'
 ,'Field size<BR><BR>Translates to SIZE attribute of HTML < INPUT > tag'
);