/**  AlternateEANNumbers surface and fields creation **/


SET IDENTITY_INSERT [dbo].[pal_Surface] ON 
INSERT [dbo].[pal_Surface] ([recId], [name], [surface], [dateCreated], [isActive], [isModal], [isPublished], [isDefaultToForm], [isWizzard], [isComparable], [linkUser], [surfaceActionId], [columnCount], [isCapitalizeInput], [isLinkedSurface], [isDisableRequired]) VALUES (4114, N'ProductAlternateEAN', N'Product Alternate EAN', CAST(N'2020-05-09T11:23:00.000' AS DateTime), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)
SET IDENTITY_INSERT [dbo].[pal_Surface] OFF

SET IDENTITY_INSERT [dbo].[pal_SurfaceGridOptions] ON 
INSERT [dbo].[pal_SurfaceGridOptions] ([recId], [surfaceId], [allowAdd], [allowEdit], [allowRemove], [allowView], [allowSort], [allowFilter], [pagingCount], [surfaceGridEditTypeId], [isTabbed], [viewIcon], [allowExport], [allowColVis], [defaultSort], [allowClone], [editIcon], [showWizardStatus], [addAccessType], [editAccessType], [viewAccessType], [removeAccessType], [cloneAccessType], [showAggregate], [aggregateTitle], [allowBulkUpdate], [allowScroll], [fixedColumns], [useFooTable], [noBorders], [freezeHeader], [iconsAsText], [allowImport]) VALUES (1077, 4114, 1, 1, 1, 0, 0, 0, -1, 1, 0, N'eye', 0, 0, N'', 0, N'edit', 0, 2, 2, 0, 3, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0)
SET IDENTITY_INSERT [dbo].[pal_SurfaceGridOptions] OFF

SET IDENTITY_INSERT [dbo].[pal_SurfaceField] ON 
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3262, 4114, N'ProductAlternateEAN', N'Product Alternate EAN', 1, 0, 0, 0, N'', N'', N'', N'', N'', 0, 1, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 6, 0, 0, 4, 0, 1, 0, 0, N'', 0, 0, 0, 0, 1, 0, 0, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3263, 4114, N'ProductAlternateEAN_AlternateEANDetails', N'Alternate EAN Details', 2, 0, 0, 0, N'', N'', N'', N'', N'', 3262, 1, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 6, 0, 0, 4, 0, 1, 0, 0, N'', 0, 0, 0, 0, 1, 0, 0, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3264, 4114, N'ProductAlternateEAN_AlternateEANDetails_UniqueName', N'Unique Name', 29, 0, 0, 0, N'1753', N'', N'', N'3040', N'', 3263, 1, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 6, 0, 0, 12, 0, 1, 0, 0, N'', 0, 0, 0, 0, 1, 0, 0, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3265, 4114, N'ProductAlternateEAN_AlternateEANDetails_PrimaryEAN', N'Primary EAN', 29, 0, 0, 0, N'54', N'', N'', N'3040', N'', 3263, 2, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 3, 0, 1, 12, 0, 1, 0, 0, N'', 0, 0, 0, 0, 2, 0, 0, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3266, 4114, N'ProductAlternateEAN_AlternateEANDetails_AlternateEAN', N'Alternate EAN', 3, 0, 1, 0, N'', N'', N'', N'', N'', 3263, 3, 1, 1, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 1, 0, 0, 0, 0, 0, 0, 0, 0, N'', 3, 0, 0, 12, 0, 1, 0, 0, N'', 0, 0, 0, 0, 3, 0, 1, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3267, 3040, N'Products_AlternateEANNumbers', N'Alternate EAN Numbers', 2, 0, 0, 0, N'', N'', N'', N'', N'', 20, 2, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 6, 0, 0, 4, 0, 2, 0, 0, N'', 0, 0, 0, 0, 8, 0, 0, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3268, 4114, N'ParentSurfaceItemId', N'ParentSurfaceItemId', 4, 0, 0, 0, N'', N'', N'', N'Products', N'', 3263, 0, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 1, 1, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, N'', 0)
INSERT [dbo].[pal_SurfaceField] ([recId], [surfaceId], [surfaceFieldName], [surfaceFieldDisplay], [surfaceFieldTypeId], [length], [required], [lookupCategory], [relationalFields], [relationalValues], [relationalOrderBy], [relationalSurface], [relationalObject], [parentId], [sequence], [isActive], [isGrid], [isFilter], [colSequence], [contentId], [defaultToCurrent], [isControlled], [controlledValue], [controlText], [isAutoPostback], [isHidden], [isReadOnly], [placeholder], [isUnique], [actionType], [action], [actionSource], [isComparable], [alternateView], [isHiddenFromWizzard], [surfaceDateTypeId], [isHiddenFromView], [actionValue], [surfaceFieldSize], [isLabelHidden], [isOnNewLine], [labelSize], [isHiddenFromForm], [accessLevel], [hasBottomBorder], [hasFullBorder], [defaultValue], [validationType], [enableBulkUpdate], [isCurrency], [isVerticalHeader], [gridSequence], [isGrouped], [isCloneable], [isCustomSource], [relationalWhere], [groupedDisplayCount]) VALUES (3269, 3040, N'Products_AlternateEANNumbers_AlternateEANNumbers', N'Alternate EAN Numbers', 11, 0, 0, 0, N'', N'', N'', N'ProductAlternateEAN', N'', 3267, 1, 1, 0, 0, 0, 0, 0, 0, N'', N'', 0, 0, 0, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', 3, 1, 1, 12, 0, 1, 0, 0, N'', 0, 0, 0, 0, 8, 0, 0, 0, N'', 0)
SET IDENTITY_INSERT [dbo].[pal_SurfaceField] OFF
