📄 ui-s-account.sql
字号:
-- Insert UiScreen
INSERT INTO UI_SCREEN (
SCREEN_ID
,APPLICATION_ID
,SCREEN_NAME
,SCREEN_DESCRIPTION
) VALUES (
'1'
,'1'
,'ACCOUNT'
,'Accounts'
);
-- 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 (
'1'
,'1'
,'AccountHeader'
,'Account Header'
,'1'
,'1'
,'3'
,'0'
,'accountId:accountId'
,'"ACCOUNT: ";accountName'
,'/sfa/control/accountHeader'
,'headerFrame'
,'/sfa/control/accountTabs'
,'contentFrame'
,''
,''
,'/sfa/control/accountHeader'
,'headerFrame'
,'/sfa/control/accountHeader'
,'headerFrame'
,'/sfa/control/accountList'
,'contentFrame'
,''
,''
,''
,''
,''
,''
);
-- 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 (
'10030'
,'1'
,'AccountOpportunityList'
,'Account Opportunity List'
,'2'
,'4'
,'0'
,'0'
,'dealId:dealId'
,'"OPPORTUNITIES for Account: ";Account.accountName'
,''
,''
,'/sfa/control/dealHeader'
,'headerFrame'
,''
,''
,'/sfa/control/dealHeader'
,'headerFrame'
,'/sfa/control/dealHeader'
,'headerFrame'
,'/sfa/control/accountDealList'
,'oMIframe'
,''
,'accountId:accountId'
,'accountId:accountId'
,'dealName'
,'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 (
'10043'
,'1'
,'AccountActivityList'
,'Account Activity List'
,'2'
,'5'
,'0'
,'0'
,'activityId:activityId'
,'"ACTIVITIES for Account: ";Account.accountName'
,''
,''
,'/sfa/control/activityHeader'
,'headerFrame'
,''
,''
,'/sfa/control/activityHeader'
,'headerFrame'
,'/sfa/control/activityHeader'
,'headerFrame'
,'/sfa/control/accountActivityList'
,'oMIframe'
,''
,'accountId:accountId'
,'accountId:accountId'
,'openDate;openStartTime;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 (
'10060'
,'1'
,'AccountContactList'
,'Account Contact List'
,'2'
,'3'
,'0'
,'0'
,'contactId:contactId'
,'"CONTACTS for Account: ";Account.accountName'
,''
,''
,'/sfa/control/contactHeader'
,'headerFrame'
,''
,''
,'/sfa/control/contactHeader'
,'headerFrame'
,'/sfa/control/contactHeader'
,'headerFrame'
,'/sfa/control/accountContactList'
,'oMIframe'
,''
,'accountId:accountId'
,'accountId:accountId'
,'lastName;firstName'
,'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 (
'10071'
,'1'
,'accountUrlList'
,''
,'2'
,'8'
,'1'
,'0'
,'urlId:urlId'
,'"URL Listing"'
,'/sfa/control/accountUrlList'
,'contentFrame'
,'/sfa/control/accountUrlHeader'
,'headerFrame'
,''
,''
,''
,''
,'/sfa/control/accountUrlHeader'
,'headerFrame'
,''
,''
,''
,'accountId:accountId;contactId:contactId'
,'accountId:accountId;contactId:contactId'
,''
,'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 (
'10072'
,'1'
,'accountUrlHeader'
,''
,'1'
,'7'
,'1'
,'0'
,'urlId:urlId'
,'"URL"'
,'/sfa/control/accountUrlHeader'
,'headerFrame'
,'/sfa/control/accountUrlList'
,'contentFrame'
,''
,''
,'/sfa/control/accountUrlHeader'
,'headerFrame'
,'/sfa/control/accountUrlHeader'
,'headerFrame'
,''
,''
,''
,''
,''
,''
,''
,''
);
-- 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 (
'10140'
,'1'
,'AccountOther'
,'Account Other Information'
,'1'
,'6'
,'2'
,'0'
,'accountId:accountId'
,'"OTHER INFO for Account: ";Account.accountName'
,'/sfa/control/accountOther'
,'oMIframe'
,''
,''
,''
,''
,'/sfa/control/accountOther'
,'oMIframe'
,''
,''
,''
,''
,''
,''
,''
,''
,'Query;New;Copy;Delete;Detail;Cancel'
,''
);
-- 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 (
'2'
,'1'
,'AccountList'
,'Account List'
,'2'
,'2'
,'4'
,'0'
,'accountId:accountId'
,'"ACCOUNTS"'
,''
,''
,'/sfa/control/accountHeader'
,'headerFrame'
,''
,''
,''
,''
,''
,''
,'/sfa/control/accountList'
,'contentFrame'
,'2'
,''
,''
,'accountName'
,''
,''
);
-- 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 (
'1'
,'1'
,'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 (
'1'
,'12'
,'Y'
,''
,''
,''
,'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 (
'1'
,'5'
,'Y'
,''
,''
,''
,'2'
,'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 (
'1'
,'-1'
,'1'
,'1'
,'60'
,'N'
,'Y'
,'Y'
,'Y'
,'1'
,'Account 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 (
'1'
,'-1'
,'11'
,'42'
,'60'
,'N'
,'N'
,'Y'
,'Y'
,'0'
,'Parent 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 (
'1'
,'-1'
,'116'
,'10'
,'20'
,'N'
,'Y'
,'N'
,'N'
,'999'
,'Party 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 (
'1'
,'-1'
,'12'
,'1'
,'60'
,'N'
,'N'
,'Y'
,'Y'
,'140'
,'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 (
'1'
,'-1'
,'16'
,'29'
,'60'
,'N'
,'N'
,'Y'
,'Y'
,'100'
,'Stock Symbol'
,'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 (
'1'
,'-1'
,'17'
,'28'
,'60'
,'N'
,'N'
,'Y'
,'Y'
,'260'
,'URL'
,'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 (
'1'
,'-1'
,'18'
,'17'
,'60'
,'N'
,'Y'
,'Y'
,'Y'
,'250'
,'Created'
,'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 (
'1'
,'-1'
,'19'
,'21'
,'60'
,'N'
,'Y'
,'Y'
,'Y'
,'999'
,'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 (
'1'
,'-1'
,'2'
,'2'
,'60'
,'Y'
,'N'
,'Y'
,'Y'
,'150'
,'Name'
,'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 (
'1'
,'-1'
,'20'
,'21'
,'60'
,'N'
,'Y'
,'Y'
,'Y'
,'999'
,'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 (
'1'
,'-1'
,'201'
,'62'
,'0'
,'Y'
,'N'
,'Y'
,'Y'
,'410'
,'Status'
,'0'
,'1'
,'1'
);
-- Insert UiScreenSectionInfo
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -