-----------------------------------------------------------------------------
- References
-----------------------------------------------------------------------------
=======================
GST Sample Stock Update
=======================
update mas_stock set
m_tax1 = 'T',
m_tax2 = 'T',
m_tax3 = 'F',
m_tax4 = 'F',
m_gst_code_input = 'TX',
m_gst_code_output= 'SR',
m_gst_trans_input= 'I',
m_gst_trans_output= 'O',
m_gst_type_input= 'S',
m_gst_type_output= 'S'


=================
Add Firebird User
=================
eg. C:\Program Files\Firebird\Firebird_2_0\bin\gsec -user xxxx -pa xxxx -add ABCD -pw 1234


====================
Modify Firebird User
====================
eg. C:\Program Files\Firebird\Firebird_2_0\bin\gsec -user xxxx -pa xxxx -modify ABCD -pw 1234


====================
Delete Firebird User
====================
eg. C:\Program Files\Firebird\Firebird_2_0\bin\gsec -user xxxx -pa xxxx -delete ABCD


==================
Firebird Reference
==================
1) If FireWall On, Please Open Port 3050.
2) If Interbase Installed, Please Removed Completely.
   Included gds32.dll - Win2000 C:\winnt\system32
                        WinXP   C:\windows\system32


=================
Version Reference
=================

eg. 3.000.0.0

 a) 3         - Product Version
 b)  .000     - Database Version
 c)      .0.0 - Program Version

========================
Database.db & Default.db
========================
- M_STATUS	01=Server,	0=Local 
				1=Remote

		02=Version,	00=FB1.5
				01=FB2.0
				02=IB6.0
				03=IB7.0

		04=OS,		0=Windows
				1=Linux

		05=Log Ext,	000=Start
				999=end

		08=Write Log,	0=No
				1=DB
                                2=File

		09=Load Photo,	0=No
				1=DB
                                2=File 

		10=Clear Log,	0=No
				1=Yes

		11=Clear Days,	001=Days
				999=Days

                14=Picture Size 00=KB
                                99=KB


=====================
12.215.0.0 2012-04-01
=====================
1) New QubeBack.exe


=====================
12.215.1.0 2012-04-26
=====================
1) Add Access Right
   - Change Table 
   - Price Change


=====================
12.216.0.0 2012-05-09
=====================
1) Change Master Username
   - QASDEV
2) Enable The Condiment
3) Stock To Print Label On FRontPos


=====================
12.216.1.0 2012-06-18
=====================
1) Security Command Changed
2) Add POSOFF - Log Off
3) Add POSMAP - Mapping Floor


=====================
12.216.1.0 2012-06-18
=====================
1) Command Changed
2) Payment With Fixed Value
3) Add Open Member


=====================
12.216.2.0 2012-07-14
=====================
1) Minor Changes


=====================
12.216.3.0 2012-07-21
=====================
1) Re-assign User Group Access
2) Security Level :
   a) Item/All Discount
   b) Sales Remark
   c) Open Discount
3) Membership Report
   - Membership Payment Report
   - Membership Payment Report By Date
   - Membership Spending Report


=====================
12.217.0.0 2012-07-21
=====================
1) Discount For :
   - Item Discount
   - Subtotal Discount
2) VOIDHL
   - Item Void After Hold
3) Add Reports
   - Bill Summary Report
   - Bill Audit Report
   - Table Performance Report


=====================
12.217.1.0 2012-07-24
=====================
1) Fixed User Group Access - POS


=====================
12.218.0.0 2012-07-28
=====================
1) Meal Count
   - With Report
2) Setup.Ini  
   [Meal_Count]
   Range01=0,9.50
   Range02=150,9.20
   Range03=250,8.70
   Range04=350,7.20
   Range05=400,7.00
   Range06=450,6.80
   Range07=500,6.50
   Range08=99999999,0
   Range09=99999999,0
   Range10=99999999,0


=====================
12.218.1.0 2012-08-23
=====================
1) Meal Count Report
   - Report\Sales\Customer Meal Count Report-Date.rtm
   - Report\Sales\Customer Spending Report No Cons-SKU.rtm
2) Add Security Access
   - COMTBL
   - SPLTBL


=====================
12.218.2.0 2012-08-24
=====================
1) Reason
   - Add Kitchen Message
2) Add Security Access
   - KPMSGS


=====================
12.218.3.0 2012-09-11
=====================
1) Add Customer Spending Count Report
2) Add Customer Meal Count Summary Report


=====================
12.218.4.0 2012-09-22
=====================
1) Add Security Access
   - TBLCXZ


=====================
12.219.0.0 2012-09-29
=====================
1) Linear Format
   - Add Customer Meal Count Summary Report


=====================
12.219.1.0 2012-10-09
=====================
1) Add Security Access
   - TRFTBL


=====================
12.219.2.0 2012-10-30
=====================
1) Add Security Access
   - FOC_XZ
   - AGT_XZ
   - HOB_XZ
2) Customer Meal Count By Date Report
   - Report\Sales\Customer Meal Count By Date


=====================
12.220.0.0 2012-11-07
=====================
1) Add Salesperson Card ID
2) Sales update Fix for House Bon Features
3) New rtm


======================
XE3.223.0.0 2013-02-10
======================
1) New Out look
2) Reason
   - Item Cancel
3) Report Access Level
   - Item Cancel Report
   

======================
XE3.223.1.0 2013-03-26
======================
1) Bugs Fixed (DLDLG)


======================
XE3.225.0.0 2013-05-04
======================
1) Stock Card DB Connection Error
2) Optional To Update Document With Period
3) Auto unlock Document


======================
XE3.225.1.0 2013-06-08
======================
1) View Group By (Updated)


======================
XE3.225.2.0 2013-08-01
======================
1) PK+Main Set -> PK -> Raw Material
2) Click Tab 'Description' Next To '='
3) Copy & Paste All For Stock
   - Except Menu Item, Raw Material & Pull Down Item
4) Set Stock Queue Link
   - Clear Then Link


======================
XE3.225.3.0 2013-09-18
======================
1) Support KDS


======================
XE3.225.4.0 2013-11-18
======================
1) Q-FNB POS Version
2) Plu Wih Price/Weight
3) Security POS
   - Condiment Sales Report
4) Condiment Max Default = 1


======================
XE3.225.5.0 2014-01-02
======================
1) Encryption
2) Customer Code Max 16
3) Membership Code Max 16


======================
XE3.226.0.0 2014-03-06
======================
1) Prepaid Card
   - PaidCard.ini
   - NecoList.txt
   - SCL.exe
   - OTP.dll
2) Fix Batch File
   - db\FixPos_XXXX.bat
3) Sales Report By X Changed
   - Group
   - Department
   - Sub-Department
   - Category
4) Hide Unused Function
5) Support Firebird 2.5


======================
XE3.226.1.0 2014-04-04
======================
1) Minor Bug Fixed
2) Option To Disable Function Password
3) Customer Meal Count Summary By Account Report
   - Report\Sales\SS051.rtm


======================
XE3.227.0.0 2014-05-09
======================
1) Tax Symbol (GST)
2) Tax Report Option To Exclude Transaction Void
3) Tax Table
4) Stock
   - Input Tax
   - Output Tax
5) Supplier & Customer Document With Tax Code
6) Revamp Front Pos Reports


======================
XE3.227.1.0 2014-05-22
======================
1) Documents Add GST Format
   - Supplier
   - Customer


======================
XE3.227.2.0 2014-07-24
======================
1) Payment Add EFT Payment
2) User Group Access Add EFT Payment Report


======================
XE3.228.0.0 2014-09-19
======================
1) Tax System Add Tax Link
2) Customer and Supplier Add GST ID
3) Document Add Tax Trans and Tax Type


======================
XE3.228.1.0 2014-10-22
======================
1) Add Area Maintenance
   FOR CLIENT :-
   a) update mas_customer set m_area = 'EMP'
   b) update mas_customer set m_area = 'CON' WHERE M_CODE > 'C' and M_CODE < 'D'
2) Auto Disable GST Code If No GST No For
   - Supplier
   - Customer


======================
XE3.228.2.0 2014-11-01
======================
1) Stock Tax Auto Link


======================
XE3.228.3.0 2014-11-17
======================
1) Add GST Summary Report


======================
XE3.228.4.0 2015-03-05
======================
1) Requisition Option To Not Allow To Edit Unit Cost
2) Support SCL011
3) Utilities
   - Copy Price Shift
   - Preset Stock GST


======================
XE3.228.5.0 2015-03-13
======================
1) Support SCL011G
2) FPOS - Transaction Void Report


======================
XE3.229.0.0 2015-04-27
======================
1) Price Auto Updating By Date
2) Data Clear
   - Stock Item, Group, Department, Sub-Department, Category
3) Tax Set Exempt Selection
4) Printer Queue Summary Default 'F'


======================
XE3.230.0.0 2015-05-26
======================
1) GST Started Stock No Output Tax Will Prompt Message
2) Add CLOUD 3700 Mifare Reader
3) PaidCard.ini
   [Setting]
   Timer_Delay=250
4) Add Customer Monthly Processing
5) Monthly/Yearly Sales Report Add Rounding
6) Avg Cost Will Not Calculate if Current Balance < 0


======================
XE3.230.1.0 2015-06-17
======================
1) Transaction Detail Analysis
   - Support Tax Inclusive


======================
XE3.230.2.0 2015-06-19
======================
1) Customer Credit Limit Range Copy
2) Show Credit Balance At Customer Limit Adjustment


======================
XE3.230.3.0 2015-06-25
======================
1) Sales Average Report
   - TR023.rtm


======================
XE3.230.4.0 2015-07-07
======================
1) Sales Average Report - Fixed Filter 


======================
XE3.230.5.0 2015-07-27
======================
1) Receipt Analysis Report
   - Add Fields for Membership


======================
XE3.230.6.0 2015-08-18
======================
1) Some Report Multi Selection No Function


======================
XE3.230.7.0 2015-11-25
======================
1) Check Digit EAB8 & EAN-13


======================
XE3.230.8.0 2015-12-04
======================
1) Default Stock Input & Output Tax
2) Terminal Can Same if Different Outlet


======================
XE3.230.9.0 2016-08-23
======================
1) If Set Menu Change To Normal M_SET_MENU_1 - 6 Set To 0
2) Sales Consolidate & Sales Import Got Date Selection


======================
XE3.230.10.0 2016-09-23
======================
1) Time Attendance Report Fixed


======================
XE3.230.11.0 2017-02-14
======================
1) Add Prepaid Card Balance
   - Payemnt Analysis Report
   - Cash Management Report


======================
XE3.230.12.0 2017-02-24
======================
1) Stock Print Label Able To Assign Printer 1 or Printer 2


======================
XE3.230.12.1 2017-04-12
======================
1) Sales Person Commission Report By Stock Rate