====== pears.WPKViewItemView ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create view "pears"."WPKViewItemView"( "WPKViewItemID",
  "WPKViewID","WPKFormID","Name","ItemType","Notes","SortOrder","CanView","CanEdit","Required","DefaultValue","Mask",
  "ComplexDataUpdateCommand","PickList","CheckValues","Sortable","BackColour","FontColour","Indent","DisplaySize","Descriptor",
  "DataType","DataLength","DisplayFormat","SortExpression","IDforVideoRecordType","Image","Expanded","CaptionBackColour",
  "CaptionFontColour","ComboScript","ButtonGroup","DivisionID","Position","Custom" ) as
  select "WPKViewItem"."WPKViewItemID","WPKViewItem"."WPKViewID","WPKViewItem"."WPKFormID","WPKViewItem"."Name","WPKViewItem"."ItemType","WPKViewItem"."Notes","WPKViewItem"."SortOrder","WPKViewItem"."CanView","WPKViewItem"."CanEdit","WPKViewItem"."Required","WPKViewItem"."DefaultValue","WPKViewItem"."Mask",
    "WPKViewItem"."ComplexDataUpdateCommand","WPKViewItem"."PickList","WPKViewItem"."CheckValues","WPKViewItem"."Sortable","WPKViewItem"."BackColour","WPKViewItem"."FontColour","WPKViewItem"."Indent","WPKViewItem"."DisplaySize","WPKViewItem"."Descriptor",
    "WPKViewItem"."DataType","WPKViewItem"."DataLength","WPKViewItem"."DisplayFormat","WPKViewItem"."SortExpression","WPKViewItem"."IDforVideoRecordType","WPKViewItem"."Image","WPKViewItem"."Expanded","WPKViewItem"."CaptionBackColour",
    "WPKViewItem"."CaptionFontColour","WPKViewItem"."ComboScript","WPKViewItem"."ButtonGroup",null as "DivisionID",-1 as "Position",0 as "Custom" from "pears"."WPKViewItem" union all
  select "WPKCustomGridColumn"."WPKCustomGridColumnID","WPKCustomGridColumn"."WPKViewID","WPKCustomGridColumn"."WPKFormID","WPKCustomGridColumn"."Name","WPKCustomGridColumn"."ItemType","WPKCustomGridColumn"."Notes",0 as "SortOrder",null as "CanView",null as "CanEdit",null as "Required",null as "DefaultValue",null as "Mask",
    null as "ComplexDataUpdateCommand","WPKCustomGridColumn"."PickList","WPKCustomGridColumn"."CheckValues","WPKCustomGridColumn"."Sortable",null as "BackColour",null as "FontColour",0 as "Indent","WPKCustomGridColumn"."DisplaySize","WPKCustomGridColumn"."Descriptor",
    "WPKCustomGridColumn"."DataType","WPKCustomGridColumn"."DataLength","WPKCustomGridColumn"."DisplayFormat","WPKCustomGridColumn"."SortExpression",null as "IDforVideoRecordType",null as "Image",null as "Expanded",null as "CaptionBackColour",
    null as "CaptionFontColour",null as "ComboScript",0 as "ButtonGroup","WPKCustomGridColumn"."DivisionID","isnull"("WPKCustomGridColumn"."Position",-1),1 as "Custom" from "pears"."WPKCustomGridColumn"
go

COMMENT TO PRESERVE FORMAT ON VIEW "pears"."WPKViewItemView" IS 
{create view WPKViewItemView 
(WPKViewItemID,WPKViewID,WPKFormID,Name,ItemType,Notes,SortOrder,CanView,CanEdit,Required,DefaultValue,Mask,
ComplexDataUpdateCommand,PickList,CheckValues,Sortable,BackColour,FontColour,Indent,DisplaySize,Descriptor,
DataType,DataLength,DisplayFormat,SortExpression,IDforVideoRecordType,Image,Expanded,CaptionBackColour,
CaptionFontColour,ComboScript,ButtonGroup,DivisionID,Position,Custom) 
as select WPKViewItemID,WPKViewID,WPKFormID,Name,ItemType,Notes,SortOrder,CanView,CanEdit,Required,DefaultValue,Mask,
ComplexDataUpdateCommand,PickList,CheckValues,Sortable,BackColour,FontColour,Indent,DisplaySize,Descriptor,
DataType,DataLength,DisplayFormat,SortExpression,IDforVideoRecordType,Image,Expanded,CaptionBackColour,
CaptionFontColour,ComboScript,ButtonGroup,null as DivisionID,-1 as Position,0 as Custom from WPKViewItem 
 union all 
select WPKCustomGridColumnID,WPKViewID,WPKFormID,Name,ItemType,Notes,0 as SortOrder,null as CanView,null as CanEdit,null as Required,null as DefaultValue,null as Mask,
null as ComplexDataUpdateCommand,PickList,CheckValues,Sortable,null as BackColour,null as FontColour,0 as Indent,DisplaySize,Descriptor,
DataType,DataLength,DisplayFormat,SortExpression,null as IDforVideoRecordType,null as Image,null as Expanded,null as CaptionBackColour,
null as CaptionFontColour,null as ComboScript,0 as ButtonGroup, DivisionID, isnull(Position,-1),1 as Custom from WPKCustomGridColumn
}
</code>