📄 ui-s-activity_popup.sql

📁 国外的一套开源CRM
💻 SQL
字号:
-- Insert UiScreen
INSERT INTO UI_SCREEN (
  SCREEN_ID
 ,APPLICATION_ID
 ,SCREEN_NAME
 ,SCREEN_DESCRIPTION
) VALUES (
  '10100'
 ,'1'
 ,'ACTIVITY_POPUP'
 ,'Activity Popup Window'
);

-- 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 (
  '11030'
 ,'10100'
 ,'ActivityPopupContactSelect'
 ,'Activity Contact Select Popup'
 ,'4'
 ,'3'
 ,'0'
 ,'0'
 ,'activityId:activityId;contactId:contactId'
 ,'"PARTICIPANTS: ";Activity.activityName'
 ,'/sfa/control/activityPopupContactSelect'
 ,'oMIframe'
 ,'/sfa/control/contactHeader'
 ,'activityPopupHeaderFrame'
 ,''
 ,''
 ,'/sfa/control/activityPopupContactSelect'
 ,'oMIframe'
 ,'/sfa/control/activityPopupContactSelect'
 ,'oMIframe'
 ,'/sfa/control/activityPopupContactAvailable'
 ,''
 ,''
 ,'activityId:activityId'
 ,'activityId:activityId'
 ,'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 (
  '11031'
 ,'10100'
 ,'ActivityPopupHeader'
 ,'Popup Activity Section'
 ,'1'
 ,'1'
 ,'3'
 ,'0'
 ,'activityId:activityId'
 ,'"ACTIVITY: ";activityName'
 ,'/sfa/control/activityPopupHeader'
 ,'activityPopupHeaderFrame'
 ,'/sfa/control/activityPopupTabs'
 ,'activityPopupContentFrame'
 ,''
 ,''
 ,'/sfa/control/activityPopupHeader'
 ,'activityPopupHeaderFrame'
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,''
 ,'New;Query'
 ,''
);

-- 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 (
  '11030'
 ,'10003'
 ,'Y'
 ,''
 ,''
 ,''
 ,'1'
 ,'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 (
  '11030'
 ,'11'
 ,'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 (
  '11030'
 ,'15'
 ,'N'
 ,''
 ,''
 ,''
 ,'3'
 ,'0'
 ,'0'
 ,'0'
 ,'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 (
  '11030'
 ,'-1'
 ,'10020'
 ,'10'
 ,'0'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'999'
 ,'Activity ID (Activity Contact)'
 ,'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 (
  '11030'
 ,'-1'
 ,'10021'
 ,'10'
 ,'0'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'999'
 ,'Contact ID (Activity Contact)'
 ,'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 (
  '11030'
 ,'-1'
 ,'607'
 ,'10'
 ,'60'
 ,'N'
 ,'Y'
 ,'N'
 ,'N'
 ,'999'
 ,'Activity Name'
 ,'100'
 ,'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 (
  '11030'
 ,'-1'
 ,'90'
 ,'2'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'10'
 ,'First Name'
 ,'100'
 ,'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 (
  '11030'
 ,'-1'
 ,'91'
 ,'2'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'20'
 ,'Last Name'
 ,'100'
 ,'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 (
  '11030'
 ,'-1'
 ,'93'
 ,'1'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'30'
 ,'Bus Phone'
 ,'100'
 ,'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 (
  '11030'
 ,'-1'
 ,'99'
 ,'1'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'30'
 ,'Email Address'
 ,'200'
 ,'1'
 ,'1'
);

-- 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 (
  '11031'
 ,'15'
 ,'Y'
 ,''
 ,''
 ,''
 ,'1'
 ,'1'
 ,'0'
 ,'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 (
  '11031'
 ,'-1'
 ,'600'
 ,'10'
 ,'20'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'1'
 ,'Activity 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 (
  '11031'
 ,'-1'
 ,'601'
 ,'42'
 ,'20'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'41'
 ,'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 (
  '11031'
 ,'-1'
 ,'604'
 ,'40'
 ,'20'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'11'
 ,'Activity Type'
 ,'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 (
  '11031'
 ,'-1'
 ,'606'
 ,'21'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'31'
 ,'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 (
  '11031'
 ,'-1'
 ,'607'
 ,'2'
 ,'60'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'10'
 ,'Activity 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 (
  '11031'
 ,'-1'
 ,'608'
 ,'34'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'60'
 ,'Activity Reason'
 ,'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 (
  '11031'
 ,'-1'
 ,'609'
 ,'18'
 ,'20'
 ,'Y'
 ,'N'
 ,'Y'
 ,'Y'
 ,'12'
 ,'Activity 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 (
  '11031'
 ,'-1'
 ,'610'
 ,'64'
 ,'20'
 ,'Y'
 ,'N'
 ,'Y'
 ,'N'
 ,'21'
 ,'Status'
 ,'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 (
  '11031'
 ,'-1'
 ,'612'
 ,'2'
 ,'5'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'70'
 ,'Source'
 ,'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 (
  '11031'
 ,'-1'
 ,'613'
 ,'56'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'20'
 ,'Description'
 ,'0'
 ,'1'
 ,'4'
);

-- 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 (
  '11031'
 ,'-1'
 ,'614'
 ,'21'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'42'
 ,'Created By'
 ,'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 (
  '11031'
 ,'-1'
 ,'615'
 ,'17'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'52'
 ,'Created 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 (
  '11031'
 ,'-1'
 ,'616'
 ,'21'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'62'
 ,'Modified By'
 ,'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 (
  '11031'
 ,'-1'
 ,'617'
 ,'17'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'Y'
 ,'72'
 ,'Modified 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 (
  '11031'
 ,'-1'
 ,'618'
 ,'19'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'22'
 ,'Start Time'
 ,'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 (
  '11031'
 ,'-1'
 ,'619'
 ,'19'
 ,'60'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'32'
 ,'End Time'
 ,'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 (
  '11031'
 ,'-1'
 ,'620'
 ,'52'
 ,'20'
 ,'N'
 ,'N'
 ,'Y'
 ,'Y'
 ,'51'
 ,'Opportunity'
 ,'0'
 ,'1'
 ,'1'
);
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -