Areas qbfdetl


Tables
ProdData inv-combobrn inv-combocom inv-combohdr
  inv-comboitem inv-grp-item inv-rounding
  inv-serv-itm inv-serv-probrn inv-serv-prov
  pos-slsprc pos-yardreq-hdr pos-yardreq-ln
  pur-empty    
FinData acr-acctcard acr-address acr-arinv
  acr-arinvln acr-cdetab acr-client
  acr-clientcard acr-clntacct acr-emptycrn
  cbk-cdetab cbk-control cbk-probrn
  cbk-prodev cbk-prodtl cbk-protrn
  inv-itemstd inv-itemtax inv-packno
  inv-serv-itmdef inv-service inv-slsprc
  lsc-cdetab lsc-group-rew lsc-group-spec
  lsc-member lsc-member-card pos-blacklist
  pos-cancel-ln pos-cashier pos-cdetab
  pos-ctrl pos-floatadj pos-item
  pos-quote pos-quoteln pos-recpt
  pos-recptinv pos-rounding pos-salecomment
  pos-savetrn pos-savetrnln pos-scanord
  pos-sup-intv pos-tender pos-tenderln
  pos-tenderrel pos-tendertype pos-till
  pos-tillsess pos-tilltrn pos-time-rel
  pos-trn pos-trnln pos-trntime
  pos-voucher pos-waiter rpl-ent-field
  sys-audit sys-batch-ctrl sys-batch-job
  sys-batch-run    
SysData prn-class prn-ctrl prn-driver
  prn-escseq prn-printer prn-report
  prn-spoolfile prn-stnary prn-user
  rpl-ctrl rpl-ent rpl-prog
  rpl-srv rpl-tillsrv sys-acchist
  sys-act sys-actmsg sys-acttype
  sys-appserv sys-audit-ent sys-branch
  sys-branchctrl sys-brnacc sys-cal
  sys-calendar sys-calhrs sys-cdequery
  sys-cdetab sys-company sys-ctrl
  sys-custprog sys-district sys-email
  sys-emailhist sys-finmonth sys-finmth-aud
  sys-finyear sys-funcact sys-function
  sys-help sys-histctrl sys-holiday
  sys-int sys-lastkey sys-lkup
  sys-menu sys-module sys-monthname
  sys-msg sys-nextnum sys-param
  sys-parcde sys-region sys-remoteprog
  sys-scratch sys-section sys-stdholiday
  sys-superuser sys-taxrate sys-town
  sys-trntype sys-user sys-user-lock
  sys-user-log sys-useract sys-usercomp
  sys-userconn sys-userfunc sys-userhist
QBMsgData msg_ctrl msg_handler msg_inhdr
  msg_inln msg_log msg_mirror
  msg_outhdr msg_outln msg_ports
  msg_routing msg_subscr  

Indexes
Schema Area default    
ProdData branch-no combo-no combo-no
  commodity upd-date combo-item
  combo-lvl combo-no combo-stat
  combo-type end-date start-date
  upd-date combo-no item-no
  upd-date idx-item idx-cust-name
  idx-req-date idx-req-no  
ProdIdx grp-cde item-no inv-rounding
  pro-no stat-cde pro-branch
  pro-no item-seq sched-no
  upd-date item-no  
FinData pos-blackid pos-blname pos-desc
  pos-tab pos-tendertype pos-voucher
  trn-no idx-name-field  
FinIdx acct-card card-acct acct-no-addr-type
  route-cde acct-no clnt-type-date
  inv-date inv-name inv-no
  paid-ind prt-ind ref-inv-no
  source type-date-post-remit inv-no
  ref-no cde-type-cde cde-type-desc
  clerk-no client-name client-no
  clover-no id-no mem-no
  sls-grp sls-rep card-no
  client-no acct-grp acct-name
  acct-no create-date inv-no
  ref-inv-no teller-user-id upd-date
  cde-type-cde cde-type-desc ctrl-id
  pro-id-cde cell-no mac-id
  pro-id-cde pro-id-cde pro-id-cde
  item-std sched-no item-no
  bar-cde item-no item-no
  pro-no stat-cde serv-type
  service-no short-desc item-end-date
  item-seq sched-no upd-date
  cde-type-cde cde-type-desc grp-eff
  grp-type-eff grp-item-date client-no
  mem-no mem-stat stat-grp
  upd-user-date mem-card mem-no-stat
  stat-expiry pos-blacklist can-trn
  branch-no passwd branch-no
  till-ses item-no pos-item
  short-desc-word pos-quote quote-ln
  acct-no recpt-no recpt-inv
  pos-rounding pos-salcomm pos-trncomm
  till-ses-trn trn-ln inv-no
  super-id till-ses upd-date
  sess-remit sess-rem-ln doc-type-no
  ses-rem-doc branch-no pos-tillses
  post-ind user-id doc-no-type
  pos-tilltrn till-ses-seq till-ses-trn
  trn-ln till-ses-seq branch-no
  passwd ent-time upd-user-id
  create-run seq-no date-run
SysData prn-class prd prt-drv
  drv-seq prt-id Act-cde
  spool-date user-date user-gen
  stnry-type user-id branch
  ent-name msg-type branch-no
  branch-till date-time user-id
  act-cde sys-cde-desc stat-date
  type-ref user-date-time sys-acttype
  sys-desc P-id audit-ent
  branch-name branch-no branch-no
  link-area user-act cal-cde
  cal-date-cde day-no cal-cde
  hours P-cdequery cde-type-cde
  cde-type-desc comp-id comp-opsys
  orig-prog dist-cde dist-name
  branch-type date-sender recipient
  sender-date fin-year start-date
  fin-year fin-year start-date
  func-act func-no sys-cde
  type-topic-seq P-histctrl holiday
  eff-date user-key fld-file-prog
  act-cde menu-seq-act sys-cde
  sys-name fin-mth msg-no
  msg-type brn-tab-fld cpy-sys-par
  parcde region-cde region-name
  act user-id branch-section
  holiday user-id sys-taxrate
  city-suburb country-cde distr-cde
  post-cde st-cde suburb-city
  jrn-type trn-desc trn-type
  branch-section id-no surname-init
  user-id user-id action-date
  action-user acc-stat act-user-func
  ird-func-no user-id compuser
  usercomp db-conn ird-func-no
  sys-user-func user-id date-time
  user-id    
QBMsgData serv_id msg_type serv_no
  stat_serv_no serv_no_ln time_stamp
  serv_no serv_no_ln serv_id
  msg_serv    
QBMsgIdx post_time serv_stat_no from_to
  to_from post_time serv_stat_no
  stat_serv_no serv_port_type  

generated 24-6-2026 08:44