-- Insert UiEntity
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'9100'
,'FileAttachment'
,'FILE_ATTACHMENT'
,''
,'A File that can be attached to an account, contact, activity, opportunity, or product'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9100'
,'9100'
,'fileId'
,'File Id'
,'FILE_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'1'
,'Document Id'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9101'
,'9100'
,'fileName'
,'File Name'
,'FILE_NAME'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'7'
,'File Name'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9102'
,'9100'
,'fileLocation'
,'File Location'
,'FILE_LOCATION'
,'1'
,'255'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'8'
,'File LOCATION'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9103'
,'9100'
,'desccription'
,'File Description'
,'DESCRIPTION'
,'1'
,'255'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'9'
,'Description'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9108'
,'9100'
,'createdDate'
,'Created Date'
,'CREATED_DATE'
,'1'
,'60'
,''
,''
,'N'
,'N'
,'Y'
,''
,''
,'18'
,'Created Date'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9109'
,'9100'
,'modifiedDate'
,'Modified Date'
,'MODIFIED_DATE'
,'1'
,'60'
,''
,''
,'N'
,'N'
,'Y'
,''
,''
,'19'
,'Modified Date'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9110'
,'9100'
,'createdBy'
,'Created By'
,'CREATED_BY'
,'1'
,'60'
,''
,''
,'N'
,'N'
,'Y'
,''
,''
,'20'
,'Created By'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9111'
,'9100'
,'modifiedBy'
,'Modified By'
,'MODIFIED_BY'
,'1'
,'60'
,''
,''
,'N'
,'N'
,'Y'
,''
,''
,'21'
,'Modified By'
,'0'
,'1'
,'1'
);
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'9101'
,'AccountFile'
,'ACCOUNT_FILE'
,''
,'A File attached to an account'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9201'
,'9101'
,'fileId'
,'File Id'
,'FILE_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'2'
,'File Id'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9202'
,'9101'
,'accountId'
,'Account Id'
,'ACCOUNT_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'2'
,'Account Id'
,'0'
,'1'
,'1'
);
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'9102'
,'ContactFile'
,'CONTACT_FILE'
,''
,'A File attached to a contact'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9211'
,'9102'
,'fileId'
,'File Id'
,'FILE_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'2'
,'File Id'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9212'
,'9102'
,'contactId'
,'Contact Id'
,'CONTACT_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'3'
,'Contact Id'
,'0'
,'1'
,'1'
);
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'9103'
,'ActivityFile'
,'ACTIVITY_FILE'
,''
,'A File attached to an activity'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9221'
,'9103'
,'fileId'
,'File Id'
,'FILE_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'2'
,'File Id'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9222'
,'9103'
,'activityId'
,'Activity Id'
,'ACTIVITY_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'4'
,'Activity Id'
,'0'
,'1'
,'1'
);
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'9104'
,'DealFile'
,'DEAL_FILE'
,''
,'A File attached to a deal'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9231'
,'9104'
,'fileId'
,'File Id'
,'FILE_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'2'
,'File Id'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9232'
,'9104'
,'dealId'
,'Deal Id'
,'DEAL_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'5'
,'Opportunity Id'
,'0'
,'1'
,'1'
);
INSERT INTO UI_ENTITY (
ENTITY_ID
,ENTITY_NAME
,TABLE_NAME
,EXT_TABLE_NAME
,DESCRIPTION
) VALUES (
'9105'
,'ProductFile'
,'PRODUCT_FILE'
,''
,'A File attached to a product'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9251'
,'9105'
,'fileId'
,'File Id'
,'FILE_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'2'
,'File Id'
,'0'
,'1'
,'1'
);
-- Insert UiAttribute
INSERT INTO UI_ATTRIBUTE (
ATTRIBUTE_ID
,ENTITY_ID
,ATTRIBUTE_NAME
,DESCRIPTION
,COLUMN_NAME
,DISPLAY_OBJECT_ID
,MAX_LENGTH
,EDIT_MASK
,DISPLAY_LOGIC
,IS_MANDATORY
,IS_READ_ONLY
,IS_VISIBLE
,IS_SEARCHABLE
,IS_EXTENSION
,DISPLAY_ORDER
,DISPLAY_LABEL
,DISPLAY_LENGTH
,COL_SPAN
,ROW_SPAN
) VALUES (
'9252'
,'9105'
,'productId'
,'product Id'
,'PRODUCT_ID'
,'1'
,'20'
,''
,''
,'Y'
,'N'
,'Y'
,''
,''
,'6'
,'Product Id'
,'0'
,'1'
,'1'
);
