# queue_log

table_name: item_log
identifier: s21198004029261739
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.359Z
updated_at: 2025-04-03T14:56:57.360Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21191873400908362-4','','','','prd15546727749771337','0','828d71f9f0fa47ae86f72775381dc997','1','7000','','0','3500','cr','7000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','1.0','0','46000','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21198004029261739','2025-04-02','15:09:40','2025-04-02 03-09-40',2)


table_name: stock
identifier: grn21196428176939100
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.361Z
updated_at: 2025-04-03T14:56:57.362Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21191873400908362-4','','','','','','prd15547677370121353','prd15541124725004175','1','7100','','','7100','ef3cd4ff50e942f9a4486bc359c6e2a5','1','7100','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21196428176939100','2025-04-02','15:09:40','2025-04-02 03-09-40',2)


table_name: item_log
identifier: s21199109489132607
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.363Z
updated_at: 2025-04-03T14:56:57.364Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21191873400908362-4','','','','prd15547677370121353','','prd15541124725004175','1','12000','','0','7100','cr','12000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','','0','46000','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21199109489132607','2025-04-02','15:09:40','2025-04-02 03-09-40',2)


table_name: txn_log
identifier: s21194902938267410
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.365Z
updated_at: 2025-04-03T14:56:57.365Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20001','46000','','','46000','','dr','bank transfer','','','','','bnk15549102647961118','29','','ef3cd4ff50e942f9a4486bc359c6e2a5','46000','1','walk-in customer','','2','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21191873400908362-4','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21194902938267410','2025-04-02','15:09:40','2025-04-02 03-09-40',2)


table_name: txn_log
identifier: s21192827130609964
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.367Z
updated_at: 2025-04-03T14:56:57.367Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('004','','2025-04-02','30004','46000','','','','46000','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','46000','1','walk-in customer','','16','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21191873400908362-4','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21192827130609964','2025-04-02','15:09:40','2025-04-02 03-09-40',2)


table_name: txn_log
identifier: s21190176483922909
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.369Z
updated_at: 2025-04-03T14:56:57.369Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('005','','2025-04-02','50047','23190','','','23190','','dr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','23190','1','','being sales made','11','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21191873400908362-4','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21190176483922909','2025-04-02','15:09:40','2025-04-02 03-09-40',2)


table_name: txn_log
identifier: s21194062839307019
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.371Z
updated_at: 2025-04-03T14:56:57.371Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','23190','','','','23190','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','23190','1','','being sales made','2','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21191873400908362-4','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21194062839307019','2025-04-02','15:09:40','2025-04-02 03-09-40',2)


table_name: stock
identifier: grn15540361667675343
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.372Z
updated_at: 2025-04-03T14:56:57.373Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15547132466765603','','','','','33fbd82413354d07aa8bd041a4e7409c','prd15547322797137707','51da4c958b604dcca0a4da6a5a9acfd0','1','10800','','','10800','ef3cd4ff50e942f9a4486bc359c6e2a5','1','10800','dr','','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15540361667675343','2025-04-02','15:21:16','2025-04-02 03-21-16',2)


table_name: item_price
identifier: upd15546331660777645
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.374Z
updated_at: 2025-04-03T14:56:57.374Z
data:
  UPDATE item_price SET control_user_id='1554', cp='10800', update_date='2025-04-02 03-21-16' WHERE item_id='51da4c958b604dcca0a4da6a5a9acfd0' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: txn_log
identifier: grn15543310046756776
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.376Z
updated_at: 2025-04-03T14:56:57.376Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','10800','','','10800','','dr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','10800','1','default vendor','being goods received','2','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15547132466765603','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15543310046756776','2025-04-02','15:21:16','2025-04-02 03-21-16',2)


table_name: txn_log
identifier: grn15540666751273437
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.377Z
updated_at: 2025-04-03T14:56:57.377Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','10800','','','','10800','cr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','10800','1','default vendor','being goods received','17','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15547132466765603','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15540666751273437','2025-04-02','15:21:16','2025-04-02 03-21-16',2)


table_name: stock
identifier: grn15542613641637704
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.379Z
updated_at: 2025-04-03T14:56:57.379Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15540361274761443','','','','','33fbd82413354d07aa8bd041a4e7409c','c56a67395bdc45889067e22e96b314e7','e0a4834f359c43cbb7c598a48711c8d3','3','12800','','','38400','ef3cd4ff50e942f9a4486bc359c6e2a5','1','38400','dr','','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15542613641637704','2025-04-02','15:21:52','2025-04-02 03-21-52',2)


table_name: item_price
identifier: upd15543149326164077
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.381Z
updated_at: 2025-04-03T14:56:57.381Z
data:
  UPDATE item_price SET control_user_id='1554', cp='12800', update_date='2025-04-02 03-21-52' WHERE item_id='e0a4834f359c43cbb7c598a48711c8d3' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: txn_log
identifier: grn15544063302771147
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.382Z
updated_at: 2025-04-03T14:56:57.383Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','38400','','','38400','','dr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','38400','1','default vendor','being goods received','2','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15540361274761443','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15544063302771147','2025-04-02','15:21:52','2025-04-02 03-21-52',2)


table_name: txn_log
identifier: grn15543176301244727
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.384Z
updated_at: 2025-04-03T14:56:57.384Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','38400','','','','38400','cr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','38400','1','default vendor','being goods received','17','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15540361274761443','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15543176301244727','2025-04-02','15:21:52','2025-04-02 03-21-52',2)


table_name: items
identifier: upd15547344731061441
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.386Z
updated_at: 2025-04-03T14:56:57.386Z
data:
  UPDATE items SET name='tiam b3 serum', description='naicinamide', sku='ti4581724166799', vat_status='1',reorder_level='2', item_category_id ='c56a67395bdc45889067e22e96b314e7', brand_id ='undefined',barcode='', disabled_status='', update_date='2025-04-02 03-22-24' WHERE id='e0a4834f359c43cbb7c598a48711c8d3' AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15544464743613071
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.388Z
updated_at: 2025-04-03T14:56:57.388Z
data:
  UPDATE item_price SET rate='14500', qty='1', control_user_id='1554', cal_qty='1', cp='12800', update_date='2025-04-02 03-22-24' WHERE item_id='e0a4834f359c43cbb7c598a48711c8d3' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15547103841443647
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.389Z
updated_at: 2025-04-03T14:56:57.389Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-22-24' WHERE item_id='e0a4834f359c43cbb7c598a48711c8d3' AND location_id='1167' AND m_metric='2' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15547443463041207
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.391Z
updated_at: 2025-04-03T14:56:57.391Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-22-24' WHERE item_id='e0a4834f359c43cbb7c598a48711c8d3' AND location_id='1167' AND m_metric='3' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: items
identifier: upd15545775356413708
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.392Z
updated_at: 2025-04-03T14:56:57.392Z
data:
  UPDATE items SET name='tiam vitc', description='', sku='ti8661724193865', vat_status='1',reorder_level='1', item_category_id ='prd15547322797137707', brand_id ='undefined',barcode='', disabled_status='0', update_date='2025-04-02 03-22-38' WHERE id='51da4c958b604dcca0a4da6a5a9acfd0' AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15543488751306057
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.393Z
updated_at: 2025-04-03T14:56:57.394Z
data:
  UPDATE item_price SET rate='14500', qty='1', control_user_id='1554', cal_qty='1', cp='10800', update_date='2025-04-02 03-22-38' WHERE item_id='51da4c958b604dcca0a4da6a5a9acfd0' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15546723578354810
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.395Z
updated_at: 2025-04-03T14:56:57.395Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-22-38' WHERE item_id='51da4c958b604dcca0a4da6a5a9acfd0' AND location_id='1167' AND m_metric='2' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15547437468355810
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.396Z
updated_at: 2025-04-03T14:56:57.396Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-22-38' WHERE item_id='51da4c958b604dcca0a4da6a5a9acfd0' AND location_id='1167' AND m_metric='3' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15541505463218743
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.397Z
updated_at: 2025-04-03T14:56:57.398Z
data:
  UPDATE item_price SET control_user_id='1554', cp='22000', update_date='2025-04-02 03-24-14' WHERE item_id='prd15544204685157233' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: items
identifier: prd15544204685157233
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.399Z
updated_at: 2025-04-03T14:56:57.399Z
data:
  INSERT INTO items (item_category_id,brand_id, name, reorder_level, barcode, vat_status, sku, start_date, expiry_date, description, sales_type, income_account, status, disabled_status, m_category_id, item_class_id,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('prd15547322797137707','','efamol evening primerose','1','','0','efa899','2025-04-02','','hormone balancing ','1','30004','0','0','353','',1126,1167,385,1554,'prd15544204685157233','2025-04-02','15:24:14','2025-04-02 03-24-14',2)


table_name: item_price
identifier: prd15542524960831734
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.400Z
updated_at: 2025-04-03T14:56:57.401Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('0','prd15544204685157233','2','0',0,0,'0','prd15547322797137707','353','',0,'','0','0','',1,0,1126,1167,385,1554,'prd15542524960831734','2025-04-02','15:24:14','2025-04-02 03-24-14',2)


table_name: item_price
identifier: prd15541403715368423
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.402Z
updated_at: 2025-04-03T14:56:57.402Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('0','prd15544204685157233','3','0',0,0,'0','prd15547322797137707','353','',0,'','0','0','',1,0,1126,1167,385,1554,'prd15541403715368423','2025-04-02','15:24:14','2025-04-02 03-24-14',2)


table_name: item_price
identifier: prd15547316405438332
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.404Z
updated_at: 2025-04-03T14:56:57.404Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('28000','prd15544204685157233','1','0',0,0,'1','prd15547322797137707','353','',0,'','1','1','',1,0,1126,1167,385,1554,'prd15547316405438332','2025-04-02','15:24:14','2025-04-02 03-24-14',2)


table_name: stock
identifier: grn15543170244336854
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.406Z
updated_at: 2025-04-03T14:56:57.406Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15543480756340421','','','','','','prd15547322797137707','prd15544204685157233','3','22000','','','66000','ef3cd4ff50e942f9a4486bc359c6e2a5','1','66000','dr','3','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15543170244336854','2025-04-02','15:24:14','2025-04-02 03-24-14',2)


table_name: txn_log
identifier: grn15545383245404716
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.407Z
updated_at: 2025-04-03T14:56:57.408Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','66000','','','66000','','dr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','66000','1','','being inventory previous balance','2','','','','0','grn','','','','','cade44841886465daee83ed06bb54306','','','0','','grn15543480756340421','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15545383245404716','2025-04-02','15:24:14','2025-04-02 03-24-14',2)


table_name: txn_log
identifier: grn15546732440584136
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.409Z
updated_at: 2025-04-03T14:56:57.409Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','66000','','','','66000','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','66000','1','','being inventory previous balance','17','','','','0','grn','','','','','cade44841886465daee83ed06bb54306','','','0','','grn15543480756340421','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15546732440584136','2025-04-02','15:24:14','2025-04-02 03-24-14',2)


table_name: item_price
identifier: upd15541333097377764
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.411Z
updated_at: 2025-04-03T14:56:57.411Z
data:
  UPDATE item_price SET control_user_id='1554', cp='3000', update_date='2025-04-02 03-26-17' WHERE item_id='prd15543439177436107' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: items
identifier: prd15543439177436107
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.412Z
updated_at: 2025-04-03T14:56:57.412Z
data:
  INSERT INTO items (item_category_id,brand_id, name, reorder_level, barcode, vat_status, sku, start_date, expiry_date, description, sales_type, income_account, status, disabled_status, m_category_id, item_class_id,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('prd15547322797137707','','vitamin c','1','','0','vit486','2025-04-02','','skin glow','1','30004','0','0','353','',1126,1167,385,1554,'prd15543439177436107','2025-04-02','15:26:17','2025-04-02 03-26-17',2)


table_name: item_price
identifier: prd15541733470619376
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.414Z
updated_at: 2025-04-03T14:56:57.414Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('0','prd15543439177436107','2','0',0,0,'0','prd15547322797137707','353','',0,'','0','0','',1,0,1126,1167,385,1554,'prd15541733470619376','2025-04-02','15:26:17','2025-04-02 03-26-17',2)


table_name: item_price
identifier: prd15549737630142730
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.415Z
updated_at: 2025-04-03T14:56:57.416Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('0','prd15543439177436107','3','0',0,0,'0','prd15547322797137707','353','',0,'','0','0','',1,0,1126,1167,385,1554,'prd15549737630142730','2025-04-02','15:26:17','2025-04-02 03-26-17',2)


table_name: item_price
identifier: prd15546319341370727
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.417Z
updated_at: 2025-04-03T14:56:57.417Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('3500','prd15543439177436107','1','0',0,0,'1','prd15547322797137707','353','',0,'','1','1','',1,0,1126,1167,385,1554,'prd15546319341370727','2025-04-02','15:26:17','2025-04-02 03-26-17',2)


table_name: stock
identifier: grn15547303417792396
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.419Z
updated_at: 2025-04-03T14:56:57.419Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15543068771473239','','','','','','prd15547322797137707','prd15543439177436107','12','3000','','','36000','ef3cd4ff50e942f9a4486bc359c6e2a5','1','36000','dr','12','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15547303417792396','2025-04-02','15:26:17','2025-04-02 03-26-17',2)


table_name: txn_log
identifier: grn15549141603773337
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.421Z
updated_at: 2025-04-03T14:56:57.421Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','36000','','','36000','','dr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','36000','1','','being inventory previous balance','2','','','','0','grn','','','','','cade44841886465daee83ed06bb54306','','','0','','grn15543068771473239','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15549141603773337','2025-04-02','15:26:17','2025-04-02 03-26-17',2)


table_name: txn_log
identifier: grn15547934763733031
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.422Z
updated_at: 2025-04-03T14:56:57.423Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','36000','','','','36000','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','36000','1','','being inventory previous balance','17','','','','0','grn','','','','','cade44841886465daee83ed06bb54306','','','0','','grn15543068771473239','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15547934763733031','2025-04-02','15:26:17','2025-04-02 03-26-17',2)


table_name: item_price
identifier: upd15541006640605347
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.424Z
updated_at: 2025-04-03T14:56:57.424Z
data:
  UPDATE item_price SET control_user_id='1554', cp='7000', update_date='2025-04-02 03-27-36' WHERE item_id='prd15545971465036408' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: items
identifier: prd15545971465036408
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.425Z
updated_at: 2025-04-03T14:56:57.426Z
data:
  INSERT INTO items (item_category_id,brand_id, name, reorder_level, barcode, vat_status, sku, start_date, expiry_date, description, sales_type, income_account, status, disabled_status, m_category_id, item_class_id,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('prd15547322797137707','','collagen c','1','','0','col287','2025-04-02','','collagen booster','1','30004','0','0','353','',1126,1167,385,1554,'prd15545971465036408','2025-04-02','15:27:35','2025-04-02 03-27-35',2)


table_name: item_price
identifier: prd15545450908436179
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.427Z
updated_at: 2025-04-03T14:56:57.427Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('0','prd15545971465036408','2','0',0,0,'0','prd15547322797137707','353','',0,'','0','0','',1,0,1126,1167,385,1554,'prd15545450908436179','2025-04-02','15:27:35','2025-04-02 03-27-35',2)


table_name: item_price
identifier: prd15544095590037416
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.429Z
updated_at: 2025-04-03T14:56:57.429Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('0','prd15545971465036408','3','0',0,0,'0','prd15547322797137707','353','',0,'','0','0','',1,0,1126,1167,385,1554,'prd15544095590037416','2025-04-02','15:27:35','2025-04-02 03-27-35',2)


table_name: item_price
identifier: prd15541374250594609
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.430Z
updated_at: 2025-04-03T14:56:57.431Z
data:
  INSERT INTO item_price (rate, item_id, m_metric, status,control_user_id, control_id, qty, item_category_id, m_category_id, item_class_id, reset, outlet_id, primary_measurement,cal_qty,price_profile_id,default_price,cp,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('10000','prd15545971465036408','1','0',0,0,'1','prd15547322797137707','353','',0,'','1','1','',1,0,1126,1167,385,1554,'prd15541374250594609','2025-04-02','15:27:35','2025-04-02 03-27-35',2)


table_name: stock
identifier: grn15540414507993956
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.432Z
updated_at: 2025-04-03T14:56:57.432Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15540945093417765','','','','','','prd15547322797137707','prd15545971465036408','3','7000','','','21000','ef3cd4ff50e942f9a4486bc359c6e2a5','1','21000','dr','3','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15540414507993956','2025-04-02','15:27:36','2025-04-02 03-27-36',2)


table_name: txn_log
identifier: grn15546046037040115
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.434Z
updated_at: 2025-04-03T14:56:57.434Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','21000','','','21000','','dr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','21000','1','','being inventory previous balance','2','','','','0','grn','','','','','cade44841886465daee83ed06bb54306','','','0','','grn15540945093417765','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15546046037040115','2025-04-02','15:27:36','2025-04-02 03-27-36',2)


table_name: txn_log
identifier: grn15547034061040365
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.447Z
updated_at: 2025-04-03T14:56:57.447Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','21000','','','','21000','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','21000','1','','being inventory previous balance','17','','','','0','grn','','','','','cade44841886465daee83ed06bb54306','','','0','','grn15540945093417765','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15547034061040365','2025-04-02','15:27:36','2025-04-02 03-27-36',2)


table_name: stock
identifier: grn15548803364416754
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.449Z
updated_at: 2025-04-03T14:56:57.449Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15544837486134406','','','','','33fbd82413354d07aa8bd041a4e7409c','prd15547322797137707','d563c21797a94dbfaf0637f777ca36de','9','8000','','','72000','ef3cd4ff50e942f9a4486bc359c6e2a5','1','72000','dr','','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15548803364416754','2025-04-02','15:33:58','2025-04-02 03-33-58',2)


table_name: item_price
identifier: upd15541840634837469
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.451Z
updated_at: 2025-04-03T14:56:57.451Z
data:
  UPDATE item_price SET control_user_id='1554', cp='8000', update_date='2025-04-02 03-33-58' WHERE item_id='d563c21797a94dbfaf0637f777ca36de' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: txn_log
identifier: grn15543847764031048
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.453Z
updated_at: 2025-04-03T14:56:57.453Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','72000','','','72000','','dr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','72000','1','default vendor','being goods received','2','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15544837486134406','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15543847764031048','2025-04-02','15:33:58','2025-04-02 03-33-58',2)


table_name: txn_log
identifier: grn15540744863742183
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.454Z
updated_at: 2025-04-03T14:56:57.455Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','72000','','','','72000','cr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','72000','1','default vendor','being goods received','17','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15544837486134406','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15540744863742183','2025-04-02','15:33:58','2025-04-02 03-33-58',2)


table_name: items
identifier: upd15549487627407143
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.456Z
updated_at: 2025-04-03T14:56:57.457Z
data:
  UPDATE items SET name='face fact bright and clear face ceam', description='description', sku='fac53', vat_status='',reorder_level='1', item_category_id ='prd15547322797137707', brand_id ='undefined',barcode='barcode', disabled_status='0', update_date='2025-04-02 03-42-58' WHERE id='prd15542821608466798' AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15544748613749807
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.458Z
updated_at: 2025-04-03T14:56:57.458Z
data:
  UPDATE item_price SET rate='9500', qty='1', control_user_id='1554', cal_qty='1', cp='null', update_date='2025-04-02 03-42-58' WHERE item_id='prd15542821608466798' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15548467740194803
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.460Z
updated_at: 2025-04-03T14:56:57.460Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-42-58' WHERE item_id='prd15542821608466798' AND location_id='1167' AND m_metric='2' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15547409873484621
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.462Z
updated_at: 2025-04-03T14:56:57.462Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-42-58' WHERE item_id='prd15542821608466798' AND location_id='1167' AND m_metric='3' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: items
identifier: upd15543146000547506
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.464Z
updated_at: 2025-04-03T14:56:57.464Z
data:
  UPDATE items SET name='retin a soap', description='acne', sku='re9711724191005', vat_status='1',reorder_level='2', item_category_id ='prd15547322797137707', brand_id ='undefined',barcode='', disabled_status='', update_date='2025-04-02 03-43-26' WHERE id='54812352d8f345c09d28d72498733c0a' AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15544500706104361
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.465Z
updated_at: 2025-04-03T14:56:57.465Z
data:
  UPDATE item_price SET rate='3500', qty='1', control_user_id='1554', cal_qty='1', cp='null', update_date='2025-04-02 03-43-26' WHERE item_id='54812352d8f345c09d28d72498733c0a' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15547616104030154
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.469Z
updated_at: 2025-04-03T14:56:57.469Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-43-26' WHERE item_id='54812352d8f345c09d28d72498733c0a' AND location_id='1167' AND m_metric='2' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15545461305710460
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.471Z
updated_at: 2025-04-03T14:56:57.471Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-43-26' WHERE item_id='54812352d8f345c09d28d72498733c0a' AND location_id='1167' AND m_metric='3' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: stock
identifier: grn15547204850163045
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.473Z
updated_at: 2025-04-03T14:56:57.473Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15541350751480648','','','','','33fbd82413354d07aa8bd041a4e7409c','prd15547322797137707','54812352d8f345c09d28d72498733c0a','6','2500','','','15000','ef3cd4ff50e942f9a4486bc359c6e2a5','1','15000','dr','','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15547204850163045','2025-04-02','15:44:18','2025-04-02 03-44-18',2)


table_name: item_price
identifier: upd15548345756412007
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.474Z
updated_at: 2025-04-03T14:56:57.475Z
data:
  UPDATE item_price SET control_user_id='1554', cp='2500', update_date='2025-04-02 03-44-18' WHERE item_id='54812352d8f345c09d28d72498733c0a' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: txn_log
identifier: grn15540074833655041
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.476Z
updated_at: 2025-04-03T14:56:57.477Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','15000','','','15000','','dr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','15000','1','default vendor','being goods received','2','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15541350751480648','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15540074833655041','2025-04-02','15:44:18','2025-04-02 03-44-18',2)


table_name: txn_log
identifier: grn15544581563030471
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.478Z
updated_at: 2025-04-03T14:56:57.478Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','15000','','','','15000','cr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','15000','1','default vendor','being goods received','17','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15541350751480648','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15544581563030471','2025-04-02','15:44:18','2025-04-02 03-44-18',2)


table_name: items
identifier: upd15548615237450023
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.480Z
updated_at: 2025-04-03T14:56:57.480Z
data:
  UPDATE items SET name='retin a soap', description='acne', sku='re9711724191005', vat_status='1',reorder_level='2', item_category_id ='prd15547322797137707', brand_id ='undefined',barcode='', disabled_status='', update_date='2025-04-02 03-44-42' WHERE id='54812352d8f345c09d28d72498733c0a' AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15545640361250837
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.482Z
updated_at: 2025-04-03T14:56:57.482Z
data:
  UPDATE item_price SET rate='3500', qty='1', control_user_id='1554', cal_qty='1', cp='2500', update_date='2025-04-02 03-44-42' WHERE item_id='54812352d8f345c09d28d72498733c0a' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15545398301467250
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.484Z
updated_at: 2025-04-03T14:56:57.484Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-44-42' WHERE item_id='54812352d8f345c09d28d72498733c0a' AND location_id='1167' AND m_metric='2' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: item_price
identifier: upd15541025385674024
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.486Z
updated_at: 2025-04-03T14:56:57.486Z
data:
  UPDATE item_price SET rate='0', qty='0', control_user_id='1554', cal_qty='0', cp='0', update_date='2025-04-02 03-44-42' WHERE item_id='54812352d8f345c09d28d72498733c0a' AND location_id='1167' AND m_metric='3' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: stock
identifier: grn15544831075367164
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.488Z
updated_at: 2025-04-03T14:56:57.488Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','grn15544140331768574','','','','','33fbd82413354d07aa8bd041a4e7409c','prd15547322797137707','prd15542261978780884','4','19000','','','76000','ef3cd4ff50e942f9a4486bc359c6e2a5','1','76000','dr','','','','','cade44841886465daee83ed06bb54306','353','','1','0','','','','0','','Wednesday','14','04','15',1126,1167,385,1554,'grn15544831075367164','2025-04-02','15:45:48','2025-04-02 03-45-48',2)


table_name: item_price
identifier: upd15548315197630447
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.490Z
updated_at: 2025-04-03T14:56:57.490Z
data:
  UPDATE item_price SET control_user_id='1554', cp='19000', update_date='2025-04-02 03-45-48' WHERE item_id='prd15542261978780884' AND location_id='1167' AND m_metric='1' AND (default_price = '1' or default_price = '' or default_price is NULL) AND status = 0 AND client_id = '1126'


table_name: txn_log
identifier: grn15547158104473164
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.492Z
updated_at: 2025-04-03T14:56:57.492Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','76000','','','76000','','dr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','76000','1','default vendor','being goods received','2','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15544140331768574','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15547158104473164','2025-04-02','15:45:48','2025-04-02 03-45-48',2)


table_name: txn_log
identifier: grn15547548106217443
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.494Z
updated_at: 2025-04-03T14:56:57.494Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('003','','2025-04-02','10002','76000','','','','76000','cr','','','','','','0','0','','ef3cd4ff50e942f9a4486bc359c6e2a5','76000','1','default vendor','being goods received','17','','','','0','grn','','','33fbd82413354d07aa8bd041a4e7409c','','cade44841886465daee83ed06bb54306','','','0','','grn15544140331768574','','','','','','','','Wednesday','14','04','15',1126,1167,385,1554,'grn15547548106217443','2025-04-02','15:45:48','2025-04-02 03-45-48',2)


table_name: stock
identifier: grn21199125367406861
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.496Z
updated_at: 2025-04-03T14:56:57.496Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21193962615406780-1','','','','','','prd15547322797137707','prd15542821608466798','1','0','','','0','ef3cd4ff50e942f9a4486bc359c6e2a5','1','0','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21199125367406861','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: item_log
identifier: s21190371666247598
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.498Z
updated_at: 2025-04-03T14:56:57.498Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21193962615406780-1','','','','prd15547322797137707','','prd15542821608466798','1','9500','','0','0','cr','9500','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','','0','24500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21190371666247598','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: stock
identifier: grn21196358702968124
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.500Z
updated_at: 2025-04-03T14:56:57.500Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21193962615406780-1','','','','','','prd15540443713771732','prd15547012414274745','1','5400','','','5400','ef3cd4ff50e942f9a4486bc359c6e2a5','1','5400','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21196358702968124','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: item_log
identifier: s21190187659624836
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.502Z
updated_at: 2025-04-03T14:56:57.502Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21193962615406780-1','','','','prd15540443713771732','','prd15547012414274745','1','15000','','0','5400','cr','15000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','','0','24500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21190187659624836','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: txn_log
identifier: s21198693227694150
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.505Z
updated_at: 2025-04-03T14:56:57.505Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20001','24500','','','24500','','dr','pos','','','','','bnk15549102647961118','29','','ef3cd4ff50e942f9a4486bc359c6e2a5','24500','1','walk-in customer','','2','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21193962615406780-1','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21198693227694150','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: txn_log
identifier: s21190957692648316
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.507Z
updated_at: 2025-04-03T14:56:57.507Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('004','','2025-04-02','30004','24500','','','','24500','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','24500','1','walk-in customer','','16','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21193962615406780-1','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21190957692648316','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: txn_log
identifier: s21199207146275038
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.509Z
updated_at: 2025-04-03T14:56:57.509Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('005','','2025-04-02','50047','5400','','','5400','','dr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','5400','1','','being sales made','11','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21193962615406780-1','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21199207146275038','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: txn_log
identifier: s21198463490752017
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.511Z
updated_at: 2025-04-03T14:56:57.511Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','5400','','','','5400','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','5400','1','','being sales made','2','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21193962615406780-1','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21198463490752017','2025-04-02','15:48:09','2025-04-02 03-48-09',2)


table_name: stock
identifier: grn21191736513484140
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.513Z
updated_at: 2025-04-03T14:56:57.513Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21197134935608474-2','','','','','','prd15547322797137707','54812352d8f345c09d28d72498733c0a','3','2500','','','7500','ef3cd4ff50e942f9a4486bc359c6e2a5','1','7500','cr','3','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21191736513484140','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: item_log
identifier: s21194344616537801
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.515Z
updated_at: 2025-04-03T14:56:57.515Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21197134935608474-2','','','','prd15547322797137707','0','54812352d8f345c09d28d72498733c0a','3','3500','','0','2500','cr','10500','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','3','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','1.0','0','16500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21194344616537801','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: stock
identifier: grn21194578214364330
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.517Z
updated_at: 2025-04-03T14:56:57.517Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21197134935608474-2','','','','','','prd15547322797137707','prd15546114373912417','1','4000','','','4000','ef3cd4ff50e942f9a4486bc359c6e2a5','1','4000','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21194578214364330','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: item_log
identifier: s21193473440851364
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.519Z
updated_at: 2025-04-03T14:56:57.520Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21197134935608474-2','','','','prd15547322797137707','','prd15546114373912417','1','6000','','0','4000','cr','6000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','0.0','0','16500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21193473440851364','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: txn_log
identifier: s21197134336847504
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.521Z
updated_at: 2025-04-03T14:56:57.522Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20001','16500','','','16500','','dr','bank transfer','','','','','bnk15549102647961118','29','','ef3cd4ff50e942f9a4486bc359c6e2a5','16500','1','walk-in customer','','2','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21197134935608474-2','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21197134336847504','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: txn_log
identifier: s21197804315434406
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.523Z
updated_at: 2025-04-03T14:56:57.524Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('004','','2025-04-02','30004','16500','','','','16500','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','16500','1','walk-in customer','','16','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21197134935608474-2','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21197804315434406','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: txn_log
identifier: s21197340618434354
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.525Z
updated_at: 2025-04-03T14:56:57.525Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('005','','2025-04-02','50047','11500','','','11500','','dr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','11500','1','','being sales made','11','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21197134935608474-2','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21197340618434354','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: txn_log
identifier: s21194034154453876
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.527Z
updated_at: 2025-04-03T14:56:57.528Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','11500','','','','11500','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','11500','1','','being sales made','2','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21197134935608474-2','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21194034154453876','2025-04-02','15:49:04','2025-04-02 03-49-04',2)


table_name: stock
identifier: grn21194807357064117
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.529Z
updated_at: 2025-04-03T14:56:57.530Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21197055468101436-3','','','','','','prd15547322797137707','51da4c958b604dcca0a4da6a5a9acfd0','1','10800','','','10800','ef3cd4ff50e942f9a4486bc359c6e2a5','1','10800','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21194807357064117','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: item_log
identifier: s21198407580411063
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.531Z
updated_at: 2025-04-03T14:56:57.532Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21197055468101436-3','','','','prd15547322797137707','0','51da4c958b604dcca0a4da6a5a9acfd0','1','14500','','0','10800','cr','14500','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','1.0','0','55500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21198407580411063','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: stock
identifier: grn21191820647905134
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.533Z
updated_at: 2025-04-03T14:56:57.534Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21197055468101436-3','','','','','','prd15546727749771337','828d71f9f0fa47ae86f72775381dc997','1','3500','','','3500','ef3cd4ff50e942f9a4486bc359c6e2a5','1','3500','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21191820647905134','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: item_log
identifier: s21191013486570964
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.535Z
updated_at: 2025-04-03T14:56:57.536Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21197055468101436-3','','','','prd15546727749771337','0','828d71f9f0fa47ae86f72775381dc997','1','7000','','0','3500','cr','7000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','1.0','0','55500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21191013486570964','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: stock
identifier: grn21198011713441365
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.537Z
updated_at: 2025-04-03T14:56:57.538Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21197055468101436-3','','','','','','prd15547322797137707','f3bb3d25daee4d8ab1643a05aee81724','1','17500','','','17500','ef3cd4ff50e942f9a4486bc359c6e2a5','1','17500','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21198011713441365','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: item_log
identifier: s21196851176141430
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.539Z
updated_at: 2025-04-03T14:56:57.539Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21197055468101436-3','','','','prd15547322797137707','0','f3bb3d25daee4d8ab1643a05aee81724','1','22000','','0','17500','cr','22000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','1.0','0','55500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21196851176141430','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: stock
identifier: grn21192351714603148
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.541Z
updated_at: 2025-04-03T14:56:57.541Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21197055468101436-3','','','','','','prd15546727749771337','prd15541882514527216','1','5400','','','5400','ef3cd4ff50e942f9a4486bc359c6e2a5','1','5400','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','15',1126,1167,385,2119,'grn21192351714603148','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: item_log
identifier: s21195076141134483
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.543Z
updated_at: 2025-04-03T14:56:57.543Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21197055468101436-3','','','','prd15546727749771337','','prd15541882514527216','1','12000','','0','5400','cr','12000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','','0','55500','','null','','','','','','','',false,'Wednesday','14','04','15',1126,1167,385,2119,'s21195076141134483','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: txn_log
identifier: s21195470134684101
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.544Z
updated_at: 2025-04-03T14:56:57.545Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20001','55500','','','55500','','dr','pos','','','','','bnk15549102647961118','29','','ef3cd4ff50e942f9a4486bc359c6e2a5','55500','1','walk-in customer','','2','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21197055468101436-3','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21195470134684101','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: txn_log
identifier: s21190879411356441
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.546Z
updated_at: 2025-04-03T14:56:57.546Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('004','','2025-04-02','30004','55500','','','','55500','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','55500','1','walk-in customer','','16','','','','0','s','','','1fd2175c8b0b48dfb5a570efa4b98f0b','','cade44841886465daee83ed06bb54306','','','0','','s21197055468101436-3','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21190879411356441','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: txn_log
identifier: s21194415782161350
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.548Z
updated_at: 2025-04-03T14:56:57.548Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('005','','2025-04-02','50047','37200','','','37200','','dr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','37200','1','','being sales made','11','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21197055468101436-3','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21194415782161350','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: txn_log
identifier: s21194857041351316
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.549Z
updated_at: 2025-04-03T14:56:57.550Z
data:
  INSERT INTO txn_log (account_type, txnid, txn_date, chart_id, jvalue, log_type, sync_id, jvdr, jvcr, effect, pmethod, rep_id, region_id, pmt_split, sales_person, bank_account_id, bank_id, teller, currency_id, currency_value, currency_unit, bene, being, chart_cate, pmt, pmt_action, t, status, prefix, credit_duration_date, br, coy, comp, outlet_id, up_date, control_user_id, control_id, notification, token, voucher, billing_type, coy2, room_id, room_class, shift, cus_cate,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('001','','2025-04-02','20009','37200','','','','37200','cr','','','','','','','','','ef3cd4ff50e942f9a4486bc359c6e2a5','37200','1','','being sales made','2','','','','0','s','','','','','cade44841886465daee83ed06bb54306','','','0','','s21197055468101436-3','','','','','','','','Wednesday','14','04','15',1126,1167,385,2119,'s21194857041351316','2025-04-02','15:50:18','2025-04-02 03-50-18',2)


table_name: stock
identifier: grn21193629090864701
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.551Z
updated_at: 2025-04-03T14:56:57.552Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21194368088110976-4','','','','','','prd15547677370121353','prd15541124725004175','1','7100','','','7100','ef3cd4ff50e942f9a4486bc359c6e2a5','1','7100','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','16',1126,1167,385,2119,'grn21193629090864701','2025-04-02','16:48:26','2025-04-02 04-48-26',2)


table_name: item_log
identifier: s21190616839430907
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.553Z
updated_at: 2025-04-03T14:56:57.553Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21194368088110976-4','','','','prd15547677370121353','','prd15541124725004175','1','12000','','0','7100','cr','12000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','','0','24000','','null','','','','','','','',false,'Wednesday','14','04','16',1126,1167,385,2119,'s21190616839430907','2025-04-02','16:48:26','2025-04-02 04-48-26',2)


table_name: stock
identifier: grn21190632978103649
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.555Z
updated_at: 2025-04-03T14:56:57.555Z
data:
  INSERT INTO stock (txn_date, expiry_date, token, return_token, return_status, log_type, sync_id, supplier_id, item_category_id, item_id, qty, price, cp, converted_price, amount, currency_id, currency_unit, currency_value, effect, uqty, store_status, batch_no, batch_status, store_id, m_category_id, t, m_metric, status, outlet_id, up_date, control_user_id, control_id, import_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','s21194368088110976-4','','','','','','c56a67395bdc45889067e22e96b314e7','prd15545137382445251','1','1250','','','1250','ef3cd4ff50e942f9a4486bc359c6e2a5','1','1250','cr','1','','','','cade44841886465daee83ed06bb54306','353','','1.0','0','','','','0','','Wednesday','14','04','16',1126,1167,385,2119,'grn21190632978103649','2025-04-02','16:48:26','2025-04-02 04-48-26',2)


table_name: item_log
identifier: s21199663174093084
last_pull: 2025-04-03
created_at: 2025-04-03T14:56:57.556Z
updated_at: 2025-04-03T14:56:57.557Z
data:
  INSERT INTO item_log (txn_date, br, tab, waiter, customer, sales_person, token, return_token, 
          log_type, sync_id, item_category_id, item_class_id, item_id, qty, price, current_price, 
          discount, cp, effect, amount, transfer, batch_no, pmt_split, sales_type, description,  comp, 
          store_id, m_category_id, m_metric,income_account, uqty, promo_id, status,outlet_id,coy, control_user_id, 
          control_id, up_date, vat_status, vat_value, tender, extra, queuer, table_id, table_type, table_charge, adjusted, source_outlet, source_br,txn_discount,absolute_discount,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2025-04-02','','','2119','walk-in customer','2119','s21194368088110976-4','','','','c56a67395bdc45889067e22e96b314e7','','prd15545137382445251','1','4000','','0','1250','cr','4000','','','','1.0','null','','cade44841886465daee83ed06bb54306','353','1.0','30004','1','',0,'','1fd2175c8b0b48dfb5a570efa4b98f0b',0,0,'','','0','24000','','null','','','','','','','',false,'Wednesday','14','04','16',1126,1167,385,2119,'s21199663174093084','2025-04-02','16:48:26','2025-04-02 04-48-26',2)


# profile

name: amololo cosmetics
username: ginalarrybeauty@gmail.com
location_id: 1167
update_date: 2025-04-03 01-48-19
api_token:
  eyj0exaioijkv1qilcjhbgcioijiuzi1nij9.eyjpc3mioijodhrwczovl2tsywtwywqubmv0l2fwav9uzxdfmi4wljcvyxbpl2xvz2luiiwiawf0ijoxnzqznjkxndaylcjuymyioje3ndm2ote0mdisimp0asi6ikvlcgo3wgfgovn5wfrqexmilcjzdwiioiixntu0iiwichj2ijoizjy3njm4ytmynmuwytu4ztkznjc0nmflzmqzzgu1yzuymdnhyzi5msisinvzzxjuyw1lijoiz2luywxhcnj5ymvhdxr5qgdtywlslmnvbsisinbob25lijoimdgxntg2njy2njyilcjlbwfpbci6bnvsbcwibg9jyxrpb25fawqiojexnjcsim5hbwuioijbbw9sb2xvienvc21ldgljcyisinzlcmlmawnhdglvbl9zdgf0dxmiojasinn1ynnjcmlwdglvbl9zdgf0dxmioijhy3rpdmuifq.bo2mwuzsq-bozdcvxaonr8yvhsgwc4gqm9hnkp34bne


