📄 ui-s-account.sql

📁 国外的一套开源CRM
💻 SQL
📖 第 1 页 / 共 4 页
字号:
上一页 1 2 34
 ,'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 (
  '10072'
 ,'-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 (
  '10072'
 ,'-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 (
  '10072'
 ,'-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 (
  '10072'
 ,'-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 (
  '10072'
 ,'-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 (
  '10072'
 ,'-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 (
  '10072'
 ,'-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 (
  '10072'
 ,'-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 (
  '10140'
 ,'1'
 ,'Y'
 ,''
 ,''
 ,''
 ,'1'
 ,'1'
 ,'1'
 ,'1'
 ,'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 (
  '10140'
 ,'-1'
 ,'1'
 ,'10'
 ,'0'
 ,'Y'
 ,'N'
 ,'N'
 ,'N'
 ,'10'
 ,'Account 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 (
  '10140'
 ,'-1'
 ,'11'
 ,'42'
 ,'20'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'30'
 ,'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 (
  '10140'
 ,'-1'
 ,'13'
 ,'26'
 ,'5'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'70'
 ,'Rating'
 ,'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 (
  '10140'
 ,'-1'
 ,'15'
 ,'34'
 ,'255'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'20'
 ,'Site'
 ,'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 (
  '10140'
 ,'-1'
 ,'19'
 ,'21'
 ,'20'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'120'
 ,'Modified By'
 ,'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 (
  '10140'
 ,'-1'
 ,'2'
 ,'10'
 ,'0'
 ,'N'
 ,'N'
 ,'N'
 ,'N'
 ,'999'
 ,'Account Name'
 ,'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 (
  '10140'
 ,'-1'
 ,'20'
 ,'21'
 ,'20'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'110'
 ,'Created By'
 ,'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 (
  '10140'
 ,'-1'
 ,'23'
 ,'4'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'80'
 ,'SIC'
 ,'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 (
  '10140'
 ,'-1'
 ,'24'
 ,'6'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'60'
 ,'Ownership 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 (
  '10140'
 ,'-1'
 ,'5'
 ,'25'
 ,'12'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'0'
 ,'Annual Revenue'
 ,'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 (
  '10140'
 ,'-1'
 ,'7'
 ,'9'
 ,'0'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'40'
 ,'Industry'
 ,'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 (
  '10140'
 ,'-1'
 ,'8'
 ,'3'
 ,'255'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'100'
 ,'Notes'
 ,'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 (
  '10140'
 ,'-1'
 ,'9'
 ,'26'
 ,'5'
 ,'N'
 ,'N'
 ,'Y'
 ,'N'
 ,'50'
 ,'Employees'
 ,'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 (
  '2'
 ,'1'
 ,'N'
 ,''
 ,''
 ,''
 ,'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 (
  '2'
 ,'5'
 ,'N'
 ,''
 ,''
 ,''
 ,'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 (
  '2'
 ,'-1'
 ,'1'
 ,'44'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'1'
 ,'Account ID'
 ,'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 (
  '2'
 ,'-1'
 ,'12'
 ,'1'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'3'
 ,'Phone'
 ,'150'
 ,'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 (
  '2'
 ,'-1'
 ,'2'
 ,'44'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'2'
 ,'Name'
 ,'200'
 ,'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 (
  '2'
 ,'-1'
 ,'52'
 ,'1'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'4'
 ,'City'
 ,'150'
 ,'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 (
  '2'
 ,'-1'
 ,'53'
 ,'12'
 ,'60'
 ,'N'
 ,'Y'
 ,'Y'
 ,'N'
 ,'5'
 ,'State'
 ,'150'
 ,'1'
 ,'1'
);
上一页 1 2 34
⌨️ 快捷键说明

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