Schema database qbfdetl

- a -

acr-acctcard	Client Acct Card	acr-address	Client addresses
acr-arinv	Invoice	acr-arinvln	Invoice Line
acr-cdetab	Accounts Receivable Code Tables	acr-client	Client details
acr-clientcard	Client Card	acr-clntacct	Client Accounts
acr-emptycrn	ACR Empties Credit Notes

- c -
cbk-cdetab	Cash Book Code Tables	cbk-control	Cash Book Control File
cbk-probrn	Payment Provider Branch	cbk-prodev	Payment Provider Device
cbk-prodtl	Payment Providers	cbk-protrn	Payment Provider Transaction Type

- i -
inv-combobrn		inv-combocom
inv-combohdr	Combo Master Header	inv-comboitem
inv-grp-item	Item Group Junction	inv-itemstd	Item standard
inv-itemtax	Vat Codes per Item	inv-packno	Alternate barcodes & pack sizes for an item
inv-rounding	Rounding of Cents	inv-serv-itm	Service Provider Item Detail
inv-serv-itmdef	Service Item Default	inv-serv-probrn	Service Provider Branches
inv-serv-prov	Service Provider Detail	inv-service	Service Items
inv-slsprc	Sales price details

- l -
lsc-cdetab	Loyalty Code Table	lsc-group-rew	Loyalty Group Reward
lsc-group-spec	Loyalty Group Specials	lsc-member	Loyalty Member
lsc-member-card	Loyalty member card

- m -
msg_ctrl	Message control file	msg_handler	Message handler
msg_inhdr	Incoming message header	msg_inln	Incoming message line
msg_log	Message log	msg_mirror	Traffic mirrors
msg_outhdr	Outgoing message header	msg_outln	Outgoing message line
msg_ports	Message Transmitter & Receiver Ports	msg_routing	Message routing
msg_subscr	Message subscribers

- p -
pos-blacklist	Point of Sale Blacklisted Clients	pos-cancel-ln	Cancelled Lines
pos-cashier	Cashiers and supervisors	pos-cdetab	Point of Sale Code Table
pos-ctrl	POS Control	pos-floatadj	Float Adjustment
pos-item	POS Item	pos-quote	Point of Sale Quotation
pos-quoteln	Point of Sale Quotation Lines	pos-recpt	POS Debtor account payments
pos-recptinv	POS Account payment Invoices to be allocated	pos-rounding	POS Rounding of cents setup
pos-salecomment	Pos Comments per Sale/Return	pos-savetrn	Temporary Point of Sale Header
pos-savetrnln	Temporary Point of Sale Lines	pos-scanord	Scan Order Record
pos-slsprc	Online Sales price details	pos-sup-intv	Supervisor Intervention Records
pos-tender	POS Tender	pos-tenderln	POS Tender Lines
pos-tenderrel	Tender relations	pos-tendertype	POS Tendertypes
pos-till	Till record	pos-tillsess	POS Till Session
pos-tilltrn	POS Till Transaction	pos-time-rel	Transaction time relationship
pos-trn	Temporary Point of Sale Header	pos-trnln	Temporary Point of Sale Lines
pos-trntime	Log transaction times	pos-voucher	POS Gift and promotional vouchers
pos-waiter	Waiter cashiers and supervisors	pos-yardreq-hdr	Request for items to be picked up in the yard
pos-yardreq-ln	Line for the sale items requested to be picked up in the yard	prn-class	Printer Class
prn-ctrl	Printer Control	prn-driver	Printer Drivers
prn-escseq	Printer Escape Sequence	prn-printer	System Printers
prn-report	Printer Report	prn-spoolfile	Printer Spoolfile
prn-stnary	Printer Stationary	prn-user	Printer User
pur-empty	Empties/Crates

- r -
rpl-ctrl	Replication Control	rpl-ent	Entities to be replicated
rpl-ent-field	Entities Fields to Replicate	rpl-prog	Replication programs
rpl-srv	Replication Servers	rpl-tillsrv	Replication Till Servers

- s -
sys-acchist	User access history	sys-act	Activity (System function)
sys-actmsg	Action messages	sys-acttype	Action types
sys-appserv	App Server Info	sys-audit	Audit records
sys-audit-ent	System Audit Entities	sys-batch-ctrl	System batch control
sys-batch-job	System batch jobs	sys-batch-run	System batch run
sys-branch	Branch Details	sys-branchctrl	Branch control setup
sys-brnacc	Control user access to branch	sys-cal	Calendar
sys-calendar	Calender header	sys-calhrs	Calendar hours
sys-cdequery	Code Description Query Table	sys-cdetab	System code table
sys-company	Company Details	sys-ctrl	System Control Record
sys-custprog	Custom program table	sys-district	Namibian district details
sys-email	Email parameters	sys-emailhist	Email History
sys-finmonth	System Financial Month	sys-finmth-aud	Sys Finmonth Audit Trail
sys-finyear	System Financial Year	sys-funcact	Job Function default access
sys-function	System function	sys-help	System help text
sys-histctrl	Configuration of Audit Trails and History	sys-holiday	Calendar holidays
sys-int	Interest table	sys-lastkey	Remember last key values for a user
sys-lkup	System look up table	sys-menu	Menu functions
sys-module	System details	sys-monthname	System Month Name
sys-msg	System messages	sys-nextnum	System Stored Next Numbers
sys-param	System Parameters	sys-parcde	System Parameter Code Table
sys-region	Region codes	sys-remoteprog	Remote program list
sys-scratch	User scratch pad	sys-section	Section details
sys-stdholiday	System standard holidays	sys-superuser	Super User Access
sys-taxrate	Tax rates per tax code and effective date	sys-town	Cities, suburbs and postal codes
sys-trntype	Global Transaction types	sys-user	User details
sys-user-lock	Use table to lock user for multi login	sys-user-log	User access log
sys-useract	User access permissions	sys-usercomp	Systems User-Company Link Table
sys-userconn	User Connections to the DB	sys-userfunc	User job function
sys-userhist	User history

generated 24-6-2026 08:43