Schema database qbfderv

- i -

inv-commodity	Commodity Code Categories	inv-imcde	Inventory management code table
inv-imcntr	Item Master Control Record	inv-invacct	Inventory Account Detail
inv-item	Item Master	inv-item-uplift	Item Upliftment
inv-itembin	Item Bin	inv-itemlot	Item Lot Detail
inv-itemtax	Vat Codes per Item	inv-ownitem	Own Item
inv-packno	Alternate barcodes & pack sizes for an item	inv-stktake-itm	Stock Take Item
inv-store	Store Details	inv-storebin	Store Bin
iuc-actmsg	Action Message	iuc-acttype	Action Type
iuc-grp	User Group	iuc-grpuser	User Group User
iuc-mailatt	Mail Attachment	iuc-mailbody	Mail Body
iuc-mailhdr	Mail Header

- 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 -
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-barcode	Pack barcodes
pur-cdetab	Code table for purchasing	pur-claim	Purchasing Claims
pur-clerk	Purchasing Clerk Setup	pur-contact	Contact persons for vendors
pur-ctrl	Purchase order control file	pur-edihdr	EDI header
pur-ediln	EDI Lines	pur-empty	Empties/Crates
pur-grnac	GRN Additional Cost	pur-grnauth	GRN Authorization
pur-grnhdr	Goods receiving header	pur-grnln	Goods received note line
pur-grnlot	GRN Lot details	pur-intvend	Internal Vendors
pur-item	Receiving Item per Branch	pur-item-vend	Item Vendor Relationship
pur-ordac	Order Additional Cost	pur-ordhdr	Order Header
pur-ordln	Order Lines	pur-ordstdrem	Order Standard Remarks
pur-prcchg	Purchase Order Price Change	pur-prov-ran	Provisional RAN
pur-ran	Return advice number	pur-recvlog	Receiving Log
pur-rethdr	Additional Return Header	pur-retln	Additional Return Line
pur-scanex	Scan/Weight Exceptions	pur-scanex-brn	Scan/Weight Exceptions per Branch
pur-scanhdr	Scan header	pur-scanln	Scan Lines
pur-scanlot	Scan Lot	pur-scanranhdr	Scan RAN Header
pur-scanranln	Scan RAN Line	pur-stdrem	Standard remarks for orders
pur-sup-intv	Super user intervention audit trail	pur-terminal	Purchasing Terminal
pur-vend-uplift	Pur Vendor Upliftment	pur-vendac	Vendor additional costs
pur-vendaddr	Address types	pur-vendgrp	Vendor groups
pur-vendor	Purchase Vendor detail	pur-vendprc	Vender item prices by effective date

- 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-actlock	Activity Locks	sys-actlog	Log activity usage
sys-actmsg	Action messages	sys-actroute	Action Message Routes
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-branchgln	Branch Global Location Number
sys-branchmng	Branch Management 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-jobcritical	Marks an activity as critical sequence	sys-jobparam	Job Parameters
sys-jobschedule	Job Schedule	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-policy	System Policy	sys-policy-grp	System Policy Group
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-usage	Usage statistics for functions
sys-user	User details	sys-user-lock	Use table to lock user for multi login
sys-user-log	User access log	sys-user-vendor	Vendor User Link
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:40