SET NOCOUNT ON
 
 
PRINT 'Inserting values into [TouchScreenMatrixHeader]'

INSERT INTO [TouchScreenMatrixHeader] ([TSMHCode],[TSMHStatus],[TSMHDesc],[TSMHWidth],[TSMHHeight],[TSMHOther],[tblDummy])VALUES('MAIN',1,'MAIN MENU',6,8,' ',NULL)


PRINT 'Done'
 
 
 
PRINT 'Inserting values into [TouchScreenMatrix]'

INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0101',1,'',3,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Change Transaction to Cash Sale (Def)''
Picture=''''
BackColor=4227327
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.oTranHead.THTranCode="CS"''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0102',1,'',3,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Change Trasaction to Invoice''
Picture=''''
BackColor=8454143
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.oTranHead.THTranCode="IN"''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0103',1,'',2,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.T.
FontItalic=.F.
ForeColor=0
Caption=''Find Client''
Picture=''''
BackColor=4227327
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ChangeTSClient()''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0104',1,'',2,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Non Stock @ 18%''
Picture=''''
BackColor=8454016
','Item Type=''N''
Item Code=''NONSTOCK003''
Weighing Required=0
Desc Required=1
Price Required=1
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0105',1,'',2,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''''
Picture=''''
BackColor=16776960
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''Alltrim(oApp.GetUser("Code"))$"BBB,PO1"''
Enabled=''Alltrim(oApp.GetUser("Code"))$"BBB,PO1"''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0106',1,'',2,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.T.
FontItalic=.F.
ForeColor=0
Caption=''Find Non Stock Item''
Picture=''''
BackColor=16755801
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=1
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''Keyboard"*{BackSpace}@N" + NVL(oApp.DoFormRetVal("FindNominalCateg", ""), "") + Chr(13) Clear''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0107',1,'',2,2,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''Special Functions''
Picture=''''
BackColor=16711680
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''SPCFUN''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0201',0,'',1,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Text''
Picture=''''
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0208',0,'',1,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Text''
Picture=''''
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0303',1,'',1,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''''
Picture=''''
BackColor=12632256
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0304',1,'',2,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Non Stock @ 5%''
Picture=''''
BackColor=65535
','Item Type=''N''
Item Code=''NONSTOCK002''
Weighing Required=0
Desc Required=0
Price Required=1
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0305',1,'',2,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''''
Picture=''''
BackColor=16776960
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0306',1,'',2,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''''
Picture=''''
BackColor=16776960
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0307',1,'',2,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.T.
FontItalic=.F.
ForeColor=0
Caption=''Find Stock Item''
Picture=''''
BackColor=4227327
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''Keyboard"*{BackSpace}" + NVL(oApp.DoFormRetVal("FindStockCard", ""), "") + Chr(13) Clear''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0308',1,'',2,1,'FontName=''Times New Roman''
FontSize=48
FontBold=.T.
FontItalic=.T.
ForeColor=0
Caption=''*''
Picture=''''
BackColor=8454016
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''*''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0401',1,'',3,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Change Trasaction to Cash Return''
Picture=''''
BackColor=12615935
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.oTranHead.THTranCode="CR"''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0402',1,'',3,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=65535
Caption=''Change Transaction to Credit Note''
Picture=''''
BackColor=32768
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.oTranHead.THTranCode="CN"''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0403',1,'',1,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''''
Picture=''''
BackColor=12632256
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0503',1,'',2,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.T.
FontItalic=.T.
ForeColor=0
Caption=''Vat No''
Picture=''''
BackColor=16777088
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ChangeTSVatNo()''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0504',1,'',2,1,'FontName=''Times New Roman''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Non Stock @ 0%''
Picture=''''
BackColor=54741
','Item Type=''N''
Item Code=''NONSTOCK001''
Weighing Required=0
Desc Required=0
Price Required=1
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0505',1,'',2,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''''
Picture=''''
BackColor=16776960
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0506',1,'',2,1,'FontName=''Times New Roman''
FontSize=12
FontBold=.T.
FontItalic=.F.
ForeColor=0
Caption=''Price Change''
Picture=''''
BackColor=4227200
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ChangeUnitPrice()''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)
INSERT INTO [TouchScreenMatrix] ([TSMCode],[TSMButton],[TSMStatus],[TSMCaption],[TSMWidth],[TSMHeight],[TSMOther],[TSMCmd],[tblDummy])VALUES('MAIN','0507',1,'',2,2,'FontName=''Times New Roman''
FontSize=18
FontBold=.T.
FontItalic=.F.
ForeColor=0
Caption=''End Bill''
Picture=''''
BackColor=255
','Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''{F12}''
Command=''''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
',NULL)


PRINT 'Done'

 
SET NOCOUNT OFF