ui-e-leadassignmentcriteria.sql

国外的一套开源CRM

-- Insert UiEntity
INSERT INTO UI_ENTITY (
  ENTITY_ID
 ,ENTITY_NAME
 ,TABLE_NAME
 ,EXT_TABLE_NAME
 ,DESCRIPTION
) VALUES (
  '10010.10011'
 ,'LeadAssignmentCriteria'
 ,'LEAD_ASSIGNMENT_CRITERIA'
 ,''
 ,'Lead Assignment Criteria'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10043'
 ,'10010.10011'
 ,'leadAssignmentCriteriaId'
 ,'Lead Assignment Criteria ID'
 ,'LEAD_ASSIGNMENT_CRITERIA_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'10'
 ,'Lead Assignment Criteria ID'
 ,'20'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10044'
 ,'10010.10011'
 ,'leadAssignmentRuleId'
 ,'Lead Assignment Rule ID'
 ,'LEAD_ASSIGNMENT_RULE_ID'
 ,'1'
 ,'20'
 ,''
 ,''
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'20'
 ,'Lead Assignment Rule ID'
 ,'20'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10045'
 ,'10010.10011'
 ,'criteriaSequence'
 ,'Criteria Sequence'
 ,'CRITERIA_SEQUENCE'
 ,'26'
 ,'5'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'30'
 ,'Criteria Sequence'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10047'
 ,'10010.10011'
 ,'fieldName'
 ,'Criteria Field Name'
 ,'FIELD_NAME'
 ,'2'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'50'
 ,'Field Name'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10048'
 ,'10010.10011'
 ,'operator'
 ,'Criteria Operator'
 ,'OPERATOR'
 ,'2'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'60'
 ,'Operator'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10049'
 ,'10010.10011'
 ,'value'
 ,'Criteria Value'
 ,'VALUE'
 ,'2'
 ,'255'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'70'
 ,'Value'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10051'
 ,'10010.10011'
 ,'createdDate'
 ,'Created Date (Lead Assignment Criteria)'
 ,'CREATED_DATE'
 ,'17'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'320'
 ,'Created Date'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10052'
 ,'10010.10011'
 ,'modifiedBy'
 ,'Modified By (Lead Assignment Criteria)'
 ,'MODIFIED_BY'
 ,'21'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'330'
 ,'Modified By'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10053'
 ,'10010.10011'
 ,'createdBy'
 ,'Created By (Lead Assignment Criteria)'
 ,'CREATED_BY'
 ,'21'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'310'
 ,'Created By'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10054'
 ,'10010.10011'
 ,'modifiedDate'
 ,'Modified Date (Lead Assignment Criteria)'
 ,'MODIFIED_DATE'
 ,'17'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'340'
 ,'Modified Date'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
  ATTRIBUTE_ID
 ,ENTITY_ID
 ,ATTRIBUTE_NAME
 ,DESCRIPTION
 ,COLUMN_NAME
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,EDIT_MASK
 ,DISPLAY_LOGIC
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,IS_EXTENSION
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10060'
 ,'10010.10011'
 ,'name'
 ,'Criteria Name'
 ,'NAME'
 ,'2'
 ,'60'
 ,''
 ,''
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'40'
 ,'Name'
 ,'0'
 ,'1'
 ,'1'
);