📄 ui-s-activities.sql
字号:
,'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 (
'10011'
,'-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 (
'10011'
,'-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 (
'10011'
,'-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 (
'10011'
,'-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 (
'10011'
,'-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 (
'10011'
,'-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 (
'10011'
,'-1'
,'620'
,'10'
,'20'
,'N'
,'N'
,'N'
,'Y'
,'99'
,'Opportunity'
,'0'
,'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 (
'10092'
,'10006'
,'N'
,''
,''
,''
,'1'
,'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 (
'10092'
,'-1'
,'10034'
,'10'
,'20'
,'Y'
,'Y'
,'N'
,'N'
,'1'
,'Url ID'
,'20'
,'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 (
'10092'
,'-1'
,'10035'
,'70000'
,'255'
,'Y'
,'N'
,'Y'
,'Y'
,'2'
,'Url Name'
,'255'
,'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 (
'10092'
,'-1'
,'10036'
,'70000'
,'255'
,'Y'
,'N'
,'Y'
,'Y'
,'3'
,'URL Link'
,'255'
,'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 (
'10092'
,'-1'
,'10037'
,'10'
,'20'
,'N'
,'N'
,'N'
,'Y'
,'6'
,'Account'
,'20'
,'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 (
'10092'
,'-1'
,'10052'
,'10'
,'20'
,'N'
,'N'
,'N'
,'N'
,'7'
,'activityId'
,'20'
,'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 (
'10092'
,'-1'
,'10073'
,'34'
,'255'
,'N'
,'N'
,'Y'
,'Y'
,'4'
,'Url Description'
,'255'
,'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 (
'10113'
,'10006'
,'Y'
,''
,''
,''
,'1'
,'0'
,'0'
,'0'
,'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 (
'10113'
,'-1'
,'10034'
,'10'
,'20'
,'N'
,'N'
,'N'
,'N'
,'1'
,'Url ID'
,'20'
,'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 (
'10113'
,'-1'
,'10035'
,'34'
,'255'
,'Y'
,'N'
,'Y'
,'Y'
,'2'
,'Url Name'
,'255'
,'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 (
'10113'
,'-1'
,'10036'
,'34'
,'255'
,'Y'
,'N'
,'Y'
,'N'
,'3'
,'URL Link'
,'255'
,'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 (
'10113'
,'-1'
,'10037'
,'10'
,'20'
,'N'
,'N'
,'N'
,'N'
,'5'
,'Account'
,'20'
,'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 (
'10113'
,'-1'
,'10038'
,'10'
,'20'
,'N'
,'N'
,'N'
,'N'
,'6'
,'Contact'
,'20'
,'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 (
'10113'
,'-1'
,'10039'
,'10'
,'20'
,'N'
,'N'
,'N'
,'N'
,'8'
,'opportunityId'
,'20'
,'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 (
'10113'
,'-1'
,'10052'
,'10'
,'20'
,'N'
,'N'
,'N'
,'N'
,'7'
,'activityId'
,'20'
,'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 (
'10113'
,'-1'
,'10073'
,'34'
,'255'
,'Y'
,'N'
,'Y'
,'Y'
,'4'
,'Url Description'
,'255'
,'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 (
'10190'
,'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 (
'10190'
,'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 (
'10190'
,'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 (
'10190'
,'-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 (
'10190'
,'-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 (
'10190'
,'-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 (
'10190'
,'-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 (
'10190'
,'-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 (
'10190'
,'-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 (
'10190'
,'-1'
,'99'
,'1'
,'0'
,'N'
,'N'
,'Y'
,'N'
,'30'
,'Email Address'
,'200'
,'1'
,'1'
);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -