ui-s-lead.sql

国外的一套开源CRM

-- Insert UiScreen
INSERT INTO UI_SCREEN (
  SCREEN_ID
 ,APPLICATION_ID
 ,SCREEN_NAME
 ,SCREEN_DESCRIPTION
) VALUES (
  '10010.10000'
 ,'1'
 ,'LEAD'
 ,'Leads'
);

-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
  SECTION_ID
 ,SCREEN_ID
 ,SECTION_NAME
 ,SECTION_DESCRIPTION
 ,LAYOUT_TYPE_ID
 ,DISPLAY_ORDER
 ,COLUMN_COUNT
 ,ROW_COUNT
 ,BUTTON_KEYS
 ,TITLE_DEF
 ,BUTTON_ACTION
 ,BUTTON_TARGET
 ,DETAIL_BUTTON_ACTION
 ,DETAIL_BUTTON_TARGET
 ,POPUP_ACTION
 ,POPUP_TARGET
 ,EDIT_BUTTON_ACTION
 ,EDIT_BUTTON_TARGET
 ,NEW_BUTTON_ACTION
 ,NEW_BUTTON_TARGET
 ,SEARCH_ACTION
 ,SEARCH_TARGET
 ,SEARCH_ATTRIBUTE_ID
 ,SEND_QUERY_PARAMETER_LIST
 ,USE_QUERY_PARAMETER_LIST
 ,SORT_DEF
 ,HIDE_BUTTONS
 ,SELECT_NAME_DEF
 ,ROWS_PER_PAGE
) VALUES (
  '10010.10000'
 ,'10010.10000'
 ,'LeadHeader'
 ,'Lead Header'
 ,'1'
 ,'1'
 ,'3'
 ,'0'
 ,'leadId:leadId'
 ,'firstName;" ";lastName'
 ,'/sfa/control/leadHeader'
 ,'headerFrame'
 ,'/sfa/control/leadTabs'
 ,'contentFrame'
 ,''
 ,''
 ,'/sfa/control/leadHeader'
 ,'headerFrame'
 ,'/sfa/control/leadHeader'
 ,'headerFrame'
 ,'/sfa/control/leadHome'
 ,'content'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,'0'
);

-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
  SECTION_ID
 ,SCREEN_ID
 ,SECTION_NAME
 ,SECTION_DESCRIPTION
 ,LAYOUT_TYPE_ID
 ,DISPLAY_ORDER
 ,COLUMN_COUNT
 ,ROW_COUNT
 ,BUTTON_KEYS
 ,TITLE_DEF
 ,BUTTON_ACTION
 ,BUTTON_TARGET
 ,DETAIL_BUTTON_ACTION
 ,DETAIL_BUTTON_TARGET
 ,POPUP_ACTION
 ,POPUP_TARGET
 ,EDIT_BUTTON_ACTION
 ,EDIT_BUTTON_TARGET
 ,NEW_BUTTON_ACTION
 ,NEW_BUTTON_TARGET
 ,SEARCH_ACTION
 ,SEARCH_TARGET
 ,SEARCH_ATTRIBUTE_ID
 ,SEND_QUERY_PARAMETER_LIST
 ,USE_QUERY_PARAMETER_LIST
 ,SORT_DEF
 ,HIDE_BUTTONS
 ,SELECT_NAME_DEF
 ,ROWS_PER_PAGE
) VALUES (
  '10010.10010'
 ,'10010.10000'
 ,'LeadList'
 ,'Lead List'
 ,'2'
 ,'2'
 ,'8'
 ,'0'
 ,'leadId:leadId'
 ,'"Lead List"'
 ,''
 ,''
 ,'/sfa/control/leads'
 ,'content'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/leadDetail'
 ,'content'
 ,'/sfa/control/leadHome'
 ,'content'
 ,'10010.10013'
 ,''
 ,''
 ,'lastName;firstName'
 ,'Edit'
 ,''
 ,'0'
);

-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
  SECTION_ID
 ,SCREEN_ID
 ,SECTION_NAME
 ,SECTION_DESCRIPTION
 ,LAYOUT_TYPE_ID
 ,DISPLAY_ORDER
 ,COLUMN_COUNT
 ,ROW_COUNT
 ,BUTTON_KEYS
 ,TITLE_DEF
 ,BUTTON_ACTION
 ,BUTTON_TARGET
 ,DETAIL_BUTTON_ACTION
 ,DETAIL_BUTTON_TARGET
 ,POPUP_ACTION
 ,POPUP_TARGET
 ,EDIT_BUTTON_ACTION
 ,EDIT_BUTTON_TARGET
 ,NEW_BUTTON_ACTION
 ,NEW_BUTTON_TARGET
 ,SEARCH_ACTION
 ,SEARCH_TARGET
 ,SEARCH_ATTRIBUTE_ID
 ,SEND_QUERY_PARAMETER_LIST
 ,USE_QUERY_PARAMETER_LIST
 ,SORT_DEF
 ,HIDE_BUTTONS
 ,SELECT_NAME_DEF
 ,ROWS_PER_PAGE
) VALUES (
  '10010.10050'
 ,'10010.10000'
 ,'LeadActivityList'
 ,'Lead Activity List'
 ,'2'
 ,'5'
 ,'0'
 ,'0'
 ,'activityId:activityId'
 ,'"ACTIVITIES for Lead: ";Lead.firstName;" ";Lead.lastName'
 ,''
 ,''
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,'/sfa/control/leadActivityList'
 ,'oMIframe'
 ,''
 ,'leadId:leadId;accountId:accountId'
 ,'leadId:leadId;accountId:accountId'
 ,'openDate;openStartTime;activityName'
 ,'queryPicker'
 ,''
 ,'0'
);

-- Insert UiScreenSection
INSERT INTO UI_SCREEN_SECTION (
  SECTION_ID
 ,SCREEN_ID
 ,SECTION_NAME
 ,SECTION_DESCRIPTION
 ,LAYOUT_TYPE_ID
 ,DISPLAY_ORDER
 ,COLUMN_COUNT
 ,ROW_COUNT
 ,BUTTON_KEYS
 ,TITLE_DEF
 ,BUTTON_ACTION
 ,BUTTON_TARGET
 ,DETAIL_BUTTON_ACTION
 ,DETAIL_BUTTON_TARGET
 ,POPUP_ACTION
 ,POPUP_TARGET
 ,EDIT_BUTTON_ACTION
 ,EDIT_BUTTON_TARGET
 ,NEW_BUTTON_ACTION
 ,NEW_BUTTON_TARGET
 ,SEARCH_ACTION
 ,SEARCH_TARGET
 ,SEARCH_ATTRIBUTE_ID
 ,SEND_QUERY_PARAMETER_LIST
 ,USE_QUERY_PARAMETER_LIST
 ,SORT_DEF
 ,HIDE_BUTTONS
 ,SELECT_NAME_DEF
 ,ROWS_PER_PAGE
) VALUES (
  '10010.10060'
 ,'10010.10000'
 ,'LeadNotes'
 ,'Lead Notes'
 ,'1'
 ,'6'
 ,'1'
 ,'0'
 ,'leadId:leadId'
 ,'"NOTES for Lead: ";Lead.firstName;" ";Lead.lastName'
 ,'/sfa/control/leadNotes'
 ,'oMIframe'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/leadNotes'
 ,'oMIframe'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,'Query;New;Copy;Delete;Detail;Cancel'
 ,''
 ,'0'
);

-- Insert UiScreenSectionEntity
INSERT INTO UI_SCREEN_SECTION_ENTITY (
  SECTION_ID
 ,ENTITY_ID
 ,IS_UPDATEABLE
 ,RELATION_TITLE
 ,RELATION_BY_AND_FIELDS
 ,RELATION_ORDER_BY_FIELDS
 ,RETRIEVE_ORDER
 ,INSERT_ORDER
 ,UPDATE_ORDER
 ,DELETE_ORDER
 ,IS_OUTER_JOINED
 ,HAS_SEQUENCE_KEY
) VALUES (
  '10010.10000'
 ,'10010.10000'
 ,'Y'
 ,''
 ,''
 ,''
 ,'1'
 ,'1'
 ,'1'
 ,'11'
 ,'N'
 ,'Y'
);

-- Insert UiScreenSectionEntity
INSERT INTO UI_SCREEN_SECTION_ENTITY (
  SECTION_ID
 ,ENTITY_ID
 ,IS_UPDATEABLE
 ,RELATION_TITLE
 ,RELATION_BY_AND_FIELDS
 ,RELATION_ORDER_BY_FIELDS
 ,RETRIEVE_ORDER
 ,INSERT_ORDER
 ,UPDATE_ORDER
 ,DELETE_ORDER
 ,IS_OUTER_JOINED
 ,HAS_SEQUENCE_KEY
) VALUES (
  '10010.10000'
 ,'12'
 ,'Y'
 ,''
 ,''
 ,''
 ,'3'
 ,'3'
 ,'3'
 ,'3'
 ,'N'
 ,'N'
);

-- Insert UiScreenSectionEntity
INSERT INTO UI_SCREEN_SECTION_ENTITY (
  SECTION_ID
 ,ENTITY_ID
 ,IS_UPDATEABLE
 ,RELATION_TITLE
 ,RELATION_BY_AND_FIELDS
 ,RELATION_ORDER_BY_FIELDS
 ,RETRIEVE_ORDER
 ,INSERT_ORDER
 ,UPDATE_ORDER
 ,DELETE_ORDER
 ,IS_OUTER_JOINED
 ,HAS_SEQUENCE_KEY
) VALUES (
  '10010.10000'
 ,'5'
 ,'Y'
 ,''
 ,''
 ,''
 ,'2'
 ,'2'
 ,'2'
 ,'2'
 ,'N'
 ,'N'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10000'
 ,'10'
 ,'20'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'5'
 ,'Lead ID'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10010'
 ,'10'
 ,'0'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'999'
 ,'Account'
 ,'0'
 ,'0'
 ,'0'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10011'
 ,'10010.10030'
 ,'20'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'62'
 ,'Owner'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10012'
 ,'1'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'10'
 ,'First'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10013'
 ,'1'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'11'
 ,'Last'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10014'
 ,'2'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'30'
 ,'Company'
 ,'60'
 ,'2'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10015'
 ,'2'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'20'
 ,'Title'
 ,'0'
 ,'2'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10016'
 ,'1'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'12'
 ,'Business Phone'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10017'
 ,'1'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'42'
 ,'Mobile Phone'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10018'
 ,'1'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'32'
 ,'Fax'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10019'
 ,'1'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'52'
 ,'Pager'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10020'
 ,'1'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'22'
 ,'Home Phone'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10021'
 ,'2'
 ,'255'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'80'
 ,'Email'
 ,'0'
 ,'2'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID
 ,DISPLAY_OBJECT_ID
 ,MAX_LENGTH
 ,IS_MANDATORY
 ,IS_READ_ONLY
 ,IS_VISIBLE
 ,IS_SEARCHABLE
 ,DISPLAY_ORDER
 ,DISPLAY_LABEL
 ,DISPLAY_LENGTH
 ,COL_SPAN
 ,ROW_SPAN
) VALUES (
  '10010.10000'
 ,'-1'
 ,'10010.10022'
 ,'10010.10060'
 ,'20'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'122'
 ,'Lead Source'
 ,'80'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo