INSERT INTO SP$WDICTS (ID, PARENT_ID, CAPTION, DESCRIPTION, SID, STATUS, INSERTDT, INI, SORTING, FRAMECLASS)
               VALUES (47, 0, 'Интернет заказы', 'Интернет заказы', 'I$ORDERS_DICT                  ', 0, '2021-08-25 15:47:01', '[insertsql]

[deletesql_selected]

[deletesql]

[refreshsql]
select * from vw_i_orders where d$uuid=:d$uuid

[selectsqlwithdeleted]

[selectsql]
select * from vw_i_orders order by id

[main]
sourcetablename=I_ORDERS
returnfieldname=D$UUID
captionfieldname=CLIENT_NAME
keyfieldname=D$UUID
ViewID=I_ORDERS
RootGroupTableName=
ShowCaption=
GetCaption=
GroupSelect=0
foldergroup=
initfolder_id=
dataset=0
InitTMSGroup_id=1000101
folders_visible=0
Canfloating=0
hidetoppanel=0
ActivateDictAction=0

[cfSelect]
selectfieldexpression=VNUM||ORDER_DATE||CLIENT_NAME||CLIENT_EMAIL||CLIENT_PHONE
AllwaysPartial=1

[form_show]
position=1
left=0
Top=0
Width=0
Height=0
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[form_get]
position=1
left=0
Top=0
Width=0
Height=0
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[childs]
bottomdock_units=0
bottomdock_size=0
rightdock_units=0
rightdock_size=0

', NULL, NULL);
INSERT INTO SP$WDICTS (ID, PARENT_ID, CAPTION, DESCRIPTION, SID, STATUS, INSERTDT, INI, SORTING, FRAMECLASS)
               VALUES (48, 0, 'Детализация интернет заказа', 'Детализация интернет заказа', 'I$ORDER_DETAIL_DICT            ', 0, '2021-08-25 15:47:01', '[insertsql]

[deletesql_selected]

[deletesql]

[refreshsql]
select * from I_ORDER_DETAIL where d$uuid=:d$uuid

[selectsqlwithdeleted]

[selectsql]
select * from I_ORDER_DETAIL

[main]
sourcetablename=I_ORDER_DETAIL
returnfieldname=D$UUID
captionfieldname=SNAME
keyfieldname=PART_ID
ViewID=I_ORDER_DETAIL
RootGroupTableName=
ShowCaption=
GetCaption=
GroupSelect=0
foldergroup=
initfolder_id=
dataset=1
InitTMSGroup_id=0
folders_visible=0
Canfloating=0
hidetoppanel=1
ActivateDictAction=0

[cfSelect]
selectfieldexpression=
AllwaysPartial=1

[form_show]
position=1
left=0
Top=0
Width=0
Height=0
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[form_get]
position=1
left=0
Top=0
Width=0
Height=0
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[childs]
bottomdock_units=0
bottomdock_size=0
rightdock_units=0
rightdock_size=0

', NULL, NULL);
INSERT INTO SP$WDICTS (ID, PARENT_ID, CAPTION, DESCRIPTION, SID, STATUS, INSERTDT, INI, SORTING, FRAMECLASS)
               VALUES (49, 0, 'Сопроводительный документ интернет заказа', 'Сопроводительный документ интернет заказа', 'I$ORDER_DOC_DICT               ', 0, '2021-08-25 15:47:01', '[insertsql]

[deletesql_selected]

[deletesql]

[refreshsql]
select * from doc_detail_active where id=:id

[selectsqlwithdeleted]

[selectsql]
select * from doc_detail_active order by sname

[main]
sourcetablename=DOC_DETAIL_ACTIVE
returnfieldname=PART_ID
captionfieldname=SNAME
keyfieldname=PART_ID
ViewID=I_ORDER_DOC
RootGroupTableName=
ShowCaption=
GetCaption=
GroupSelect=0
foldergroup=
initfolder_id=
dataset=1
InitTMSGroup_id=0
folders_visible=0
Canfloating=0
hidetoppanel=1
ActivateDictAction=0

[cfSelect]
selectfieldexpression=
AllwaysPartial=1

[form_show]
position=1
left=0
Top=0
Width=0
Height=0
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[form_get]
position=1
left=0
Top=0
Width=0
Height=0
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[childs]
bottomdock_units=0
bottomdock_size=0
rightdock_units=0
rightdock_size=0', NULL, NULL);
INSERT INTO SP$WDICTS (ID, PARENT_ID, CAPTION, DESCRIPTION, SID, STATUS, INSERTDT, INI, SORTING, FRAMECLASS)
               VALUES (50, 0, 'Смена партии в интернет заказе', 'Смена партии в интернет заказе', 'I$ORDER_PARTS_DICT             ', 0, '2021-08-25 15:47:01', '[insertsql]

[deletesql_selected]

[deletesql]

[refreshsql]

[selectsqlwithdeleted]

[selectsql]
select * from warebase where ware_id='':ware_id:'' and part_id not in (:part_list:) and realquant>0

[main]
sourcetablename=WAREBASE
returnfieldname=PART_ID
captionfieldname=SNAME
keyfieldname=PART_ID
ViewID=i_order_warebase
RootGroupTableName=
ShowCaption=
GetCaption=
GroupSelect=0
foldergroup=
initfolder_id=
dataset=1
InitTMSGroup_id=0
folders_visible=0
Canfloating=0
hidetoppanel=1
ActivateDictAction=0

[cfSelect]
selectfieldexpression=SERIA
AllwaysPartial=1

[form_show]
position=1
left=0
Top=0
Width=0
Height=0
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[form_get]
position=6
left=0
Top=0
Width=800
Height=450
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[childs]
bottomdock_units=0
bottomdock_size=0
rightdock_units=0
rightdock_size=0

', NULL, NULL);

COMMIT WORK;