Areas qbfderv


Tables
ProdData inv-commodity inv-imcde inv-imcntr
  inv-invacct inv-item inv-itembin
  inv-itemlot inv-itemtax inv-ownitem
  inv-packno inv-stktake-itm inv-store
  inv-storebin pur-barcode pur-cdetab
  pur-claim pur-clerk pur-contact
  pur-ctrl pur-edihdr pur-ediln
  pur-empty pur-grnac pur-grnauth
  pur-grnhdr pur-grnln pur-grnlot
  pur-intvend pur-item pur-item-vend
  pur-ordac pur-ordhdr pur-ordln
  pur-ordstdrem pur-prcchg pur-prov-ran
  pur-ran pur-recvlog pur-rethdr
  pur-retln pur-scanex pur-scanex-brn
  pur-scanhdr pur-scanln pur-scanlot
  pur-scanranhdr pur-scanranln pur-stdrem
  pur-sup-intv pur-terminal pur-vendac
  pur-vendaddr pur-vendgrp pur-vendor
  pur-vendprc sys-branchgln  
FinData inv-item-uplift pur-vend-uplift rpl-ent-field
  sys-audit    
SysData iuc-actmsg iuc-acttype iuc-grp
  iuc-grpuser iuc-mailatt iuc-mailbody
  iuc-mailhdr 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-actlock
  sys-actlog sys-actmsg sys-actroute
  sys-acttype sys-appserv sys-audit-ent
  sys-batch-ctrl sys-batch-job sys-batch-run
  sys-branch sys-branchctrl sys-branchmng
  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-jobcritical sys-jobparam sys-jobschedule
  sys-lastkey sys-lkup sys-menu
  sys-module sys-monthname sys-msg
  sys-nextnum sys-param sys-parcde
  sys-policy sys-policy-grp sys-region
  sys-remoteprog sys-scratch sys-section
  sys-stdholiday sys-superuser sys-taxrate
  sys-town sys-trntype sys-usage
  sys-user sys-user-lock sys-user-log
  sys-user-vendor 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 commodity-cde inv-acct short-desc
  cde-type-cde cde-type-desc ctrl-key
  inv-acct short-desc commodity-cde
  inv-acct item neg-item
  short-desc short-desc-word item-exp-date-bal
  item-lot item-no bar-cde
  item-no area-cost-cde store-cde
  store-name cde-type-cde cde-type-desc
  ac-grn-no grn-no grn-stat
  grn-vend-dn vendor-ord asset-ind
  grn-no-ln ord-no-ln vend-dn-ndx
  grn-lot ac-ord-no ord-no
  ord-stat vendor-no item-area-cc-date
  ord-ln-stat ord-no-ln ord-stdrem
  grn-no-ln ran-no ran-stat
  rem-cde short-desc vendor-no
  grp-desc vendor-grp clerk-no
  vendor-grp vendor-name vendor-no
  vendor-item branch-no gln-no
ProdIdx mfr-item restrict-cde item-uplift
  store-bin-item store-cde-item compare-date
  item-type-date brn-item item-brn
  store-bins grn-no ord-no
  vendor-dn-no clerk-no vendor-contact
  vendor-orders key inv-date
  vendor-dn-no vendor-order vendor-dn-no
  item-no grn-no grn-ln
  ord-grn rec-date item-no
  branch-vend item-store commodity-cde
  item-no mfr-item-cde vendor-no
  ord-no auto-run-no opn-date
  ord-date sht-no type-stat
  vend-confirm ord-no grn-no
  ran-no ran-stat suppl-batch-no
  accpt-date arrive-date branch-no
  vend-ord vendor-inv-no ret-no
  ret-stat vendor-ret item-no
  ret-ln item-no vendor-item
  vendor-no branch-no vendor-brn
  vendor-no rec-date scan-no
  vendor-order vendor-rec-date scan-no-ln
  scan-ln scan-date scan-no
  scan-no-ln super-id upd-date
  branch-ip vend-uplift item-br-end-date
  vendor-no next-ord-date remit-to
  item-br-alt-end-date item-vendor sched-no
FinData stat-cde stat-cde idx-name-field
  act-route ent-time upd-user-id
SysData MA-from-user MU-action-date P-touser
  PU-acttype grp-cde grp-cde
  PU-mailatt MA-body PU-mailbody
  MA-recdel MA-senddel MA-touser
  PU-mailhdr 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
  P-useract act-cde date-time
  user-id stat-date type-ref
  user-date-time sys-acttype sys-desc
  P-id audit-ent create-run
  seq-no date-run branch-name
  branch-no branch-no link-area
  branch-no 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 act-cde P-jobparam
  MA-userjob PS-compl-sched PU-job-no
  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
  typ-grp-no type-grp 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 MA-prdact P-actprd
  branch-section id-no surname-init
  user-id user-id action-date
  action-user user-id-vendor 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:41