ui-s-opportunities.sql

国外的一套开源CRM

-- Insert UiScreen
INSERT INTO UI_SCREEN (
  SCREEN_ID
 ,APPLICATION_ID
 ,SCREEN_NAME
 ,SCREEN_DESCRIPTION
) VALUES (
  '30'
 ,'1'
 ,'OPPORTUNITIES'
 ,'Opportunities'
);

-- 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
) VALUES (
  '10020'
 ,'30'
 ,'OpportunityHeader'
 ,'OpportunityHeader'
 ,'1'
 ,'2'
 ,'2'
 ,'0'
 ,'dealId:dealId'
 ,'"OPPORTUNITY: ";dealName'
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,'/sfa/control/dealDetail'
 ,'contentFrame'
 ,''
 ,''
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,'/sfa/control/dealList'
 ,'contentFrame'
 ,''
 ,'teamId:Team.teamId'
 ,''
 ,''
 ,''
 ,''
);

-- 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
) VALUES (
  '10021'
 ,'30'
 ,'OpportunityList'
 ,'OpportunityList'
 ,'2'
 ,'1'
 ,'0'
 ,'0'
 ,'dealId:dealId'
 ,'"OPPORTUNITIES"'
 ,''
 ,''
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/dealHeader'
 ,'headerFrame'
 ,'/sfa/control/dealList'
 ,'contentFrame'
 ,''
 ,''
 ,''
 ,'dealName'
 ,''
 ,''
);

-- 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
) VALUES (
  '10022'
 ,'30'
 ,'OpportunityActivityList'
 ,'Lists current activities for an Opportunity'
 ,'2'
 ,'4'
 ,'4'
 ,'0'
 ,'activityId:activityId'
 ,'"ACTIVITIES for Opportunity: ";Deal.dealName'
 ,''
 ,''
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/activityHeader'
 ,'headerFrame'
 ,'/sfa/control/activityList'
 ,'oMIframe'
 ,''
 ,'opportunityId:opportunityId'
 ,'opportunityId:opportunityId'
 ,'activityName'
 ,'queryPicker'
 ,''
);

-- 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
) VALUES (
  '10031'
 ,'30'
 ,'OpportunityContactSelect'
 ,'Opportunity Contact Select'
 ,'4'
 ,'3'
 ,'0'
 ,'0'
 ,'dealId:dealId;contactId:contactId'
 ,'"CONTACTS for Opportunity: ";Deal.dealName'
 ,'/sfa/control/opportunityContactSelect'
 ,'oMIframe'
 ,'/sfa/control/contactHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/opportunityContactSelect'
 ,'oMIframe'
 ,'/sfa/control/opportunityContactSelect'
 ,'oMIframe'
 ,'/sfa/control/opportunityContactSelectAvailable'
 ,''
 ,''
 ,'dealId:dealId'
 ,'dealId:dealId'
 ,'lastName;firstName'
 ,'queryPicker'
 ,'Contact.firstName;" ";Contact.lastName'
);

-- 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
) VALUES (
  '10061'
 ,'30'
 ,'OpportunityOverview'
 ,'Opportunity Overview'
 ,'1'
 ,'0'
 ,'1'
 ,'0'
 ,'dealId:dealId'
 ,'"OPPORTUNITY OVERVIEW"'
 ,'/sfa/control/opportunityOverview'
 ,'contentFrame'
 ,'/sfa/control/opportunityOverview'
 ,'contentFrame'
 ,''
 ,''
 ,'/sfa/control/opportunityOverview'
 ,'contentFrame'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,'New;Detail;Query;Edit;Delete;Copy;Print'
 ,''
);

-- 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
) VALUES (
  '10101'
 ,'30'
 ,'OpportunityUrlList'
 ,''
 ,'2'
 ,'8'
 ,'1'
 ,'0'
 ,'opportunityId:opportunityId'
 ,'"URL Listing"'
 ,'/sfa/control/opportunityUrlList'
 ,'contentFrame'
 ,'/sfa/control/accountUrlHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,''
 ,'/sfa/control/accountUrlHeader'
 ,'headerFrame'
 ,''
 ,''
 ,''
 ,'opportunityId:opportunityId;accountId:accountId'
 ,'opportunityId:opportunityId;accountId:accountId'
 ,''
 ,'queryPicker'
 ,''
);

-- 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
) VALUES (
  '11041'
 ,'30'
 ,'OpportunityTeamSelect'
 ,'Opportunity Team Select'
 ,'4'
 ,'5'
 ,'0'
 ,'0'
 ,'teamMemberId:teamMemberId'
 ,'"TEAM MEMBERS for Opportunity: ";Deal.dealName'
 ,'/sfa/control/opportunityTeamSelect'
 ,'oMIframe'
 ,'/sfa/control/contactHeader'
 ,'headerFrame'
 ,''
 ,''
 ,'/sfa/control/opportunityTeamSelect'
 ,'oMIframe'
 ,'/sfa/control/opportunityTeamSelect'
 ,'oMIframe'
 ,'/sfa/control/opportunityTeamSelectAvailable'
 ,''
 ,''
 ,'dealId:dealId;teamId:teamId'
 ,'dealId:dealId;teamId:teamId'
 ,'lastName;firstName'
 ,'queryPicker'
 ,'Contact.firstName;" ";Contact.lastName'
);

-- 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 (
  '10020'
 ,'10000'
 ,'N'
 ,''
 ,''
 ,''
 ,'2'
 ,'0'
 ,'0'
 ,'0'
 ,'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 (
  '10020'
 ,'10001'
 ,'N'
 ,''
 ,''
 ,''
 ,'3'
 ,'0'
 ,'0'
 ,'0'
 ,'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 (
  '10020'
 ,'14'
 ,'Y'
 ,''
 ,''
 ,''
 ,'1'
 ,'1'
 ,'1'
 ,'1'
 ,'N'
 ,'Y'
);

-- 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 (
  '10020'
 ,'-1'
 ,'200'
 ,'10'
 ,'0'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'99'
 ,'Entity Access ID'
 ,'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 (
  '10020'
 ,'-1'
 ,'300'
 ,'10'
 ,'0'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'99'
 ,'Team ID'
 ,'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 (
  '10020'
 ,'-1'
 ,'401'
 ,'10'
 ,'20'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'999'
 ,'Opportunity 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 (
  '10020'
 ,'-1'
 ,'402'
 ,'42'
 ,'30'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'11'
 ,'Account'
 ,'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 (
  '10020'
 ,'-1'
 ,'403'
 ,'21'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'70'
 ,'Owner'
 ,'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 (
  '10020'
 ,'-1'
 ,'405'
 ,'2'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'10'
 ,'Opportunity Name'
 ,'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 (
  '10020'
 ,'-1'
 ,'406'
 ,'43'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'30'
 ,'Lead Source'
 ,'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 (
  '10020'
 ,'-1'
 ,'407'
 ,'25'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'21'
 ,'Amount'
 ,'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 (
  '10020'
 ,'-1'
 ,'408'
 ,'18'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'31'
 ,'Projected Close Date'
 ,'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 (
  '10020'
 ,'-1'
 ,'409'
 ,'18'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'41'
 ,'Actual Close Date'
 ,'0'
 ,'1'
 ,'1'
);

-- Insert UiScreenSectionInfo
INSERT INTO UI_SCREEN_SECTION_INFO (
  SECTION_ID
 ,PARTY_ID
 ,ATTRIBUTE_ID