# queue_log

table_name: txn_log
identifier: s38381077690211846
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.466Z
updated_at: 2026-05-11T09:56:51.466Z
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','','2026-04-17','20009','7000','','','','7000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','7000','1','','being sales made','2','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38387107402180869-14','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38381077690211846','2026-05-08','18:21:41','2026-05-08 06-21-41','2')


table_name: stock
identifier: grn38382248777141516
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.469Z
updated_at: 2026-05-11T09:56:51.470Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38384718817220167-15','','','','','','prd22476213156047962','prd22479779946247162','1','4000','','','4000','15f142ab31314c5682f2381fd168bfe6','1','4000','cr','1','','','','78b316819edc4f52b7bb242124b8a86a','','','','0','','','','0','','prd22474299176679475','Friday','19','05','18','1654','1707','1330','3838','grn38382248777141516','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: item_log
identifier: s38387212547087216
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.473Z
updated_at: 2026-05-11T09:56:51.474Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3838','walk-in customer','3838','s38384718817220167-15','','','','prd22476213156047962','','prd22479779946247162','1','6000','','0','4000','cr','6000','','','','1.0','null','','78b316819edc4f52b7bb242124b8a86a','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','40500','','null','','','','','','','','false','prd22474299176679475','Friday','19','05','18','1654','1707','1330','3838','s38387212547087216','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: stock
identifier: grn38385422271671728
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.478Z
updated_at: 2026-05-11T09:56:51.478Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38384718817220167-15','','','','','','prd22476213156047962','prd22478737775250610','1','8500','','','8500','15f142ab31314c5682f2381fd168bfe6','1','8500','cr','1','','','','78b316819edc4f52b7bb242124b8a86a','','','','0','','','','0','','prd22471775785309720','Friday','19','05','18','1654','1707','1330','3838','grn38385422271671728','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: item_log
identifier: s38383114292277678
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.482Z
updated_at: 2026-05-11T09:56:51.482Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3838','walk-in customer','3838','s38384718817220167-15','','','','prd22476213156047962','','prd22478737775250610','1','13000','','0','8500','cr','13000','','','','1.0','null','','78b316819edc4f52b7bb242124b8a86a','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','40500','','null','','','','','','','','false','prd22471775785309720','Friday','19','05','18','1654','1707','1330','3838','s38383114292277678','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: stock
identifier: grn38385167285774122
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.486Z
updated_at: 2026-05-11T09:56:51.486Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38384718817220167-15','','','','','','prd22477445692183411','prd22471974668285151','3','3500','','','10500','15f142ab31314c5682f2381fd168bfe6','1','10500','cr','3','','','','78b316819edc4f52b7bb242124b8a86a','','','','0','','','','0','','prd22478617856012946','Friday','19','05','18','1654','1707','1330','3838','grn38385167285774122','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: item_log
identifier: s38381748227721696
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.490Z
updated_at: 2026-05-11T09:56:51.490Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3838','walk-in customer','3838','s38384718817220167-15','','','','prd22477445692183411','','prd22471974668285151','3','4500','','0','3500','cr','13500','','','','1.0','null','','78b316819edc4f52b7bb242124b8a86a','','13301','30004','3','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','40500','','null','','','','','','','','false','prd22478617856012946','Friday','19','05','18','1654','1707','1330','3838','s38381748227721696','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: stock
identifier: grn38382272718468417
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.493Z
updated_at: 2026-05-11T09:56:51.494Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38384718817220167-15','','','','','','prd22477445692183411','prd22474286997765125','2','3000','','','6000','15f142ab31314c5682f2381fd168bfe6','1','6000','cr','2','','','','78b316819edc4f52b7bb242124b8a86a','','','','0','','','','0','','prd22473766955917082','Friday','19','05','18','1654','1707','1330','3838','grn38382272718468417','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: item_log
identifier: s38388112272794576
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.497Z
updated_at: 2026-05-11T09:56:51.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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3838','walk-in customer','3838','s38384718817220167-15','','','','prd22477445692183411','','prd22474286997765125','2','4000','','0','3000','cr','8000','','','','1.0','null','','78b316819edc4f52b7bb242124b8a86a','','13301','30004','2','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','40500','','null','','','','','','','','false','prd22473766955917082','Friday','19','05','18','1654','1707','1330','3838','s38388112272794576','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: txn_log
identifier: s38382648274317107
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.502Z
updated_at: 2026-05-11T09:56:51.503Z
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','','2026-05-08','20001','40500','','','40500','','dr','pos','','','','','bnk22478750122307395','28','','15f142ab31314c5682f2381fd168bfe6','40500','1','walk-in customer','','2','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38384718817220167-15','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38382648274317107','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: txn_log
identifier: s38388037727164112
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.506Z
updated_at: 2026-05-11T09:56:51.506Z
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','','2026-05-08','30004','40500','','','','40500','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','40500','1','walk-in customer','','16','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38384718817220167-15','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38388037727164112','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: txn_log
identifier: s38387342184176172
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.509Z
updated_at: 2026-05-11T09:56:51.510Z
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','','2026-05-08','50047','29000','','','29000','','dr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','29000','1','','being sales made','11','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38384718817220167-15','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38387342184176172','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: txn_log
identifier: s38382312164177787
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.513Z
updated_at: 2026-05-11T09:56:51.514Z
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','','2026-05-08','20009','29000','','','','29000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','29000','1','','being sales made','2','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38384718817220167-15','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38382312164177787','2026-05-08','18:51:54','2026-05-08 06-51-54','2')


table_name: stock
identifier: grn38387227918891067
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.517Z
updated_at: 2026-05-11T09:56:51.518Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38388987696728821-16','','','','','','prd22477445692183411','prd22477893912536969','1','700','','','700','15f142ab31314c5682f2381fd168bfe6','1','700','cr','1','','','','78b316819edc4f52b7bb242124b8a86a','','','','0','','','','0','','prd22479019759686264','Friday','19','05','18','1654','1707','1330','3838','grn38387227918891067','2026-05-08','18:56:38','2026-05-08 06-56-38','2')


table_name: item_log
identifier: s38387729886179622
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.522Z
updated_at: 2026-05-11T09:56:51.522Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3838','walk-in customer','3838','s38388987696728821-16','','','','prd22477445692183411','','prd22477893912536969','1','1000','','0','700','cr','1000','','','','1.0','null','','78b316819edc4f52b7bb242124b8a86a','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','1000','','null','','','','','','','','false','prd22479019759686264','Friday','19','05','18','1654','1707','1330','3838','s38387729886179622','2026-05-08','18:56:38','2026-05-08 06-56-38','2')


table_name: txn_log
identifier: s38382979862713837
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.526Z
updated_at: 2026-05-11T09:56:51.527Z
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','','2026-05-08','20001','1000','','','1000','','dr','bank transfer','','','','','bnk22478750122307395','28','','15f142ab31314c5682f2381fd168bfe6','1000','1','walk-in customer','','2','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38388987696728821-16','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38382979862713837','2026-05-08','18:56:38','2026-05-08 06-56-38','2')


table_name: txn_log
identifier: s38387398267162879
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.530Z
updated_at: 2026-05-11T09:56:51.530Z
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','','2026-05-08','30004','1000','','','','1000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','1000','1','walk-in customer','','16','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38388987696728821-16','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38387398267162879','2026-05-08','18:56:38','2026-05-08 06-56-38','2')


table_name: txn_log
identifier: s38381770927984862
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.534Z
updated_at: 2026-05-11T09:56:51.534Z
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','','2026-05-08','50047','700','','','700','','dr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','700','1','','being sales made','11','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38388987696728821-16','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38381770927984862','2026-05-08','18:56:38','2026-05-08 06-56-38','2')


table_name: txn_log
identifier: s38388872929714627
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.538Z
updated_at: 2026-05-11T09:56:51.538Z
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','','2026-05-08','20009','700','','','','700','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','700','1','','being sales made','2','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38388987696728821-16','','','','','','','','Friday','19','05','18','1654','1707','1330','3838','s38388872929714627','2026-05-08','18:56:38','2026-05-08 06-56-38','2')


table_name: stock
identifier: grn38381457297291866
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.563Z
updated_at: 2026-05-11T09:56:51.563Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-04-27','','s38387268245147669-17','','','','','','prd22471117581611944','prd22477687198969633','1','2500','','','2500','15f142ab31314c5682f2381fd168bfe6','1','2500','cr','1','','','','78b316819edc4f52b7bb242124b8a86a','','','','0','','','','0','','prd22477649689371699','Friday','19','05','19','1654','1707','1330','3838','grn38381457297291866','2026-05-08','19:17:36','2026-05-08 07-17-36','2')


table_name: item_log
identifier: s38385268213370774
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.567Z
updated_at: 2026-05-11T09:56:51.568Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-04-27','','','3838','walk-in customer','3838','s38387268245147669-17','','','','prd22471117581611944','','prd22477687198969633','1','4000','','0','2500','cr','4000','','','','1.0','null','','78b316819edc4f52b7bb242124b8a86a','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','4000','','null','','','','','','','','false','prd22477649689371699','Friday','19','05','19','1654','1707','1330','3838','s38385268213370774','2026-05-08','19:17:37','2026-05-08 07-17-37','2')


table_name: txn_log
identifier: s38386228757470417
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.572Z
updated_at: 2026-05-11T09:56:51.573Z
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','','2026-04-27','20001','4000','','','4000','','dr','bank transfer','','','','','bnk22478750122307395','28','','15f142ab31314c5682f2381fd168bfe6','4000','1','walk-in customer','','2','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38387268245147669-17','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38386228757470417','2026-05-08','19:17:37','2026-05-08 07-17-37','2')


table_name: txn_log
identifier: s38380125576722847
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.577Z
updated_at: 2026-05-11T09:56:51.578Z
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','','2026-04-27','30004','4000','','','','4000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','4000','1','walk-in customer','','16','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38387268245147669-17','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38380125576722847','2026-05-08','19:17:37','2026-05-08 07-17-37','2')


table_name: txn_log
identifier: s38387505146286727
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.582Z
updated_at: 2026-05-11T09:56:51.582Z
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','','2026-04-27','50047','2500','','','2500','','dr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','2500','1','','being sales made','11','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38387268245147669-17','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38387505146286727','2026-05-08','19:17:37','2026-05-08 07-17-37','2')


table_name: txn_log
identifier: s38384071287962575
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.586Z
updated_at: 2026-05-11T09:56:51.587Z
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','','2026-04-27','20009','2500','','','','2500','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','2500','1','','being sales made','2','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38387268245147669-17','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38384071287962575','2026-05-08','19:17:37','2026-05-08 07-17-37','2')


table_name: stock
identifier: grn38387962677418400
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.611Z
updated_at: 2026-05-11T09:56:51.612Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38382704197846391-18','','','','','','prd22477445692183411','prd22478622916612627','1','2500','','','2500','15f142ab31314c5682f2381fd168bfe6','1','2500','cr','1','','','','78b316819edc4f52b7bb242124b8a86a','','','','0','','','','0','','prd22476636127226912','Friday','19','05','19','1654','1707','1330','3838','grn38387962677418400','2026-05-08','19:28:24','2026-05-08 07-28-24','2')


table_name: item_log
identifier: s38387684707146129
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.633Z
updated_at: 2026-05-11T09:56:51.634Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3838','walk-in customer','3838','s38382704197846391-18','','','','prd22477445692183411','','prd22478622916612627','1','3000','','0','2500','cr','3000','','','','1.0','null','','78b316819edc4f52b7bb242124b8a86a','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','3000','','null','','','','','','','','false','prd22476636127226912','Friday','19','05','19','1654','1707','1330','3838','s38387684707146129','2026-05-08','19:28:24','2026-05-08 07-28-24','2')


table_name: txn_log
identifier: s38380769874341826
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.638Z
updated_at: 2026-05-11T09:56:51.639Z
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','','2026-05-08','20001','3000','','','3000','','dr','pos','','','','','bnk22478750122307395','28','','15f142ab31314c5682f2381fd168bfe6','3000','1','walk-in customer','','2','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38382704197846391-18','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38380769874341826','2026-05-08','19:28:24','2026-05-08 07-28-24','2')


table_name: txn_log
identifier: s38384427661079887
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.643Z
updated_at: 2026-05-11T09:56:51.644Z
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','','2026-05-08','30004','3000','','','','3000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','3000','1','walk-in customer','','16','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38382704197846391-18','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38384427661079887','2026-05-08','19:28:24','2026-05-08 07-28-24','2')


table_name: txn_log
identifier: s38387089471642692
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.647Z
updated_at: 2026-05-11T09:56:51.648Z
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','','2026-05-08','50047','2500','','','2500','','dr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','2500','1','','being sales made','11','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38382704197846391-18','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38387089471642692','2026-05-08','19:28:24','2026-05-08 07-28-24','2')


table_name: txn_log
identifier: s38387749448296601
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.653Z
updated_at: 2026-05-11T09:56:51.653Z
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','','2026-05-08','20009','2500','','','','2500','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','2500','1','','being sales made','2','','','','0','s','','','','','78b316819edc4f52b7bb242124b8a86a','','','0','','s38382704197846391-18','','','','','','','','Friday','19','05','19','1654','1707','1330','3838','s38387749448296601','2026-05-08','19:28:24','2026-05-08 07-28-24','2')


table_name: stock
identifier: grn38101730787416211
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.677Z
updated_at: 2026-05-11T09:56:51.677Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38101497872560017-1','','','','','','prd22471729286616766','prd22473477013432300','1','7000','','','7000','15f142ab31314c5682f2381fd168bfe6','1','7000','cr','1','','','','str22470905936811773','','','','0','','','','0','','prd22470341043773038','Friday','19','05','19','1654','1707','1335','3810','grn38101730787416211','2026-05-08','19:16:10','2026-05-08 07-16-10','2')


table_name: item_log
identifier: s38107031481236177
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.682Z
updated_at: 2026-05-11T09:56:51.682Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3810','walk-in customer','3810','s38101497872560017-1','','','','prd22471729286616766','','prd22473477013432300','1','10000','','0','7000','cr','10000','','','','1.0','null','','str22470905936811773','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','10000','','null','','','','','','','','false','prd22470341043773038','Friday','19','05','19','1654','1707','1335','3810','s38107031481236177','2026-05-08','19:16:10','2026-05-08 07-16-10','2')


table_name: txn_log
identifier: s38101278141047647
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.686Z
updated_at: 2026-05-11T09:56:51.687Z
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','','2026-05-08','20001','10000','','','10000','','dr','bank transfer','','','','','bnk22478750122307395','28','','15f142ab31314c5682f2381fd168bfe6','10000','1','walk-in customer','','2','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','str22470905936811773','','','0','','s38101497872560017-1','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38101278141047647','2026-05-08','19:16:10','2026-05-08 07-16-10','2')


table_name: txn_log
identifier: s38104111776770482
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.690Z
updated_at: 2026-05-11T09:56:51.691Z
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','','2026-05-08','30004','10000','','','','10000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','10000','1','walk-in customer','','16','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','str22470905936811773','','','0','','s38101497872560017-1','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38104111776770482','2026-05-08','19:16:10','2026-05-08 07-16-10','2')


table_name: txn_log
identifier: s38102715718764011
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.694Z
updated_at: 2026-05-11T09:56:51.694Z
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','','2026-05-08','50047','7000','','','7000','','dr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','7000','1','','being sales made','11','','','','0','s','','','','','str22470905936811773','','','0','','s38101497872560017-1','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38102715718764011','2026-05-08','19:16:10','2026-05-08 07-16-10','2')


table_name: txn_log
identifier: s38104672151477018
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.697Z
updated_at: 2026-05-11T09:56:51.698Z
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','','2026-05-08','20009','7000','','','','7000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','7000','1','','being sales made','2','','','','0','s','','','','','str22470905936811773','','','0','','s38101497872560017-1','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38104672151477018','2026-05-08','19:16:10','2026-05-08 07-16-10','2')


table_name: stock
identifier: grn38108178572324603
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.700Z
updated_at: 2026-05-11T09:56:51.701Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38108261272670334-2','','','','','','prd22476213156047962','prd22477131104273944','1','9000','','','9000','15f142ab31314c5682f2381fd168bfe6','1','9000','cr','1','','','','str22470905936811773','','','','0','','','','0','','prd22471331404789217','Friday','19','05','19','1654','1707','1335','3810','grn38108178572324603','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


table_name: item_log
identifier: s38107082143776293
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.704Z
updated_at: 2026-05-11T09:56:51.705Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3810','walk-in customer','3810','s38108261272670334-2','','','','prd22476213156047962','','prd22477131104273944','1','12000','','0','9000','cr','12000','','','','1.0','null','','str22470905936811773','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','24000','','null','','','','','','','','false','prd22471331404789217','Friday','19','05','19','1654','1707','1335','3810','s38107082143776293','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


table_name: stock
identifier: grn38102713487104826
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.708Z
updated_at: 2026-05-11T09:56:51.709Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','s38108261272670334-2','','','','','','prd22471729286616766','prd22474687266919278','1','9000','','','9000','15f142ab31314c5682f2381fd168bfe6','1','9000','cr','1','','','','str22470905936811773','','','','0','','','','0','','prd22470910464067970','Friday','19','05','19','1654','1707','1335','3810','grn38102713487104826','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


table_name: item_log
identifier: s38103144282677130
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.712Z
updated_at: 2026-05-11T09:56:51.712Z
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,item_price_id,day_name,week_no,month_no,hr,client_id,location_id,device_id,user_id,id,date,tm,update_date,origin) VALUES ('2026-05-08','','','3810','walk-in customer','3810','s38108261272670334-2','','','','prd22471729286616766','','prd22474687266919278','1','12000','','0','9000','cr','12000','','','','1.0','null','','str22470905936811773','','13301','30004','1','','0','','ba934b61e7304d68b0b914c76660581c','0','0','','0.0','0','24000','','null','','','','','','','','false','prd22470910464067970','Friday','19','05','19','1654','1707','1335','3810','s38103144282677130','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


table_name: txn_log
identifier: s38103027442684781
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.716Z
updated_at: 2026-05-11T09:56:51.717Z
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','','2026-05-08','20001','24000','','','24000','','dr','bank transfer','','','','','bnk22470457750582201','28','','15f142ab31314c5682f2381fd168bfe6','24000','1','walk-in customer','','2','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','str22470905936811773','','','0','','s38108261272670334-2','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38103027442684781','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


table_name: txn_log
identifier: s38106471104283572
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.720Z
updated_at: 2026-05-11T09:56:51.721Z
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','','2026-05-08','30004','24000','','','','24000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','24000','1','walk-in customer','','16','','','','0','s','','','ba934b61e7304d68b0b914c76660581c','','str22470905936811773','','','0','','s38108261272670334-2','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38106471104283572','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


table_name: txn_log
identifier: s38100427875144362
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.725Z
updated_at: 2026-05-11T09:56:51.726Z
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','','2026-05-08','50047','18000','','','18000','','dr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','18000','1','','being sales made','11','','','','0','s','','','','','str22470905936811773','','','0','','s38108261272670334-2','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38100427875144362','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


table_name: txn_log
identifier: s38106732475814720
last_pull: 2026-05-11
created_at: 2026-05-11T09:56:51.730Z
updated_at: 2026-05-11T09:56:51.731Z
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','','2026-05-08','20009','18000','','','','18000','cr','','','','','','','','','15f142ab31314c5682f2381fd168bfe6','18000','1','','being sales made','2','','','','0','s','','','','','str22470905936811773','','','0','','s38108261272670334-2','','','','','','','','Friday','19','05','19','1654','1707','1335','3810','s38106732475814720','2026-05-08','19:17:10','2026-05-08 07-17-10','2')


# profile

name: anixx cosmetic and beauty product
username: annixplace@gmail.com
location_id: 1707
update_date: 2026-05-11 10-56-37
api_token:
  eyj0exaioijkv1qilcjhbgcioijiuzi1nij9.eyjpc3mioijodhrwczovl2tsywtwywqubmv0l2fwav8yljeuny9hcgkvbg9naw4ilcjpyxqioje3nzgyntyyodesim5izii6mtc3odi1nji4mswianrpijoiu2r4odn0q1iwsuprb24zdcisinn1yii6ijiyndcilcjwcnyioijmnjc2mzhhmzi2ztbhnthlotm2nzq2ywvmzdnkztvjntiwm2fjmjkxiiwidxnlcm5hbwuioijhbm5pehbsywnlqgdtywlslmnvbsisinbob25lijoimdgwmzqyotq0mjgilcjlbwfpbci6bnvsbcwibg9jyxrpb25fawqioje3mdcsim5hbwuioijhbml4ecbjb3ntzxrpyybhbmqgymvhdxr5ihbyb2r1y3qilcj2zxjpzmljyxrpb25fc3rhdhvzijowlcjzdwjzy3jpchrpb25fc3rhdhvzijoiywn0axzlin0.x21xvupl7pcbatljtzthl5v7qbcvj2wssblcsvn582m


