Schema database qbfdecn

|  a  |  c  |  f  |  g  |  i  |  j  |  l  |  m  |  p  |  r  |  s  |
 
- a -
acp-ageing ACP Ageing acp-apadv Accounts Payable Advices
acp-apadv-allow Accounts Payable Advices Allowance acp-apadv-orig Original Invoice Line
acp-apinv Accounts Payable Invoices acp-apinv-orig Original Invoice
acp-cdetab Accounts Payable Code Tables acp-clerk Clerk Name
acp-clerkrel Creditor clerk relationships acp-devhdr Invoice Deviation Header
acp-devln Invoice Deviation Line acp-match Match Recon
acp-provtrn Provision Transaction acp-query Queries refered to Negotiator from Creditors
acp-recon Vendor Reconciliation acp-recur-inv Creditors Recurring Invoice Data
acp-recur-invln Recurring Invoice Lines acp-remit-allow Accounts Payable Remittance Allowance
acp-remit-audit Remittance Audit Trail acp-remit-ded Account Payable Remittance Allow Deductions
acp-remitadv Remittance Advice acp-valacc Accounts Payable Valid Accounts for sundry invoice
acp-vend-st-ln Vendor Statement Line acp-vend-stmnt Vendor Statements
acp-vendtrn Vendor Transaction acr-acctcard Client Acct Card
acr-acctcred Client Account Credit acr-acctgrp Account Groups
acr-acctslsgrp Account Sales Groups acr-acctstat Account Status
acr-address Client addresses acr-ageing ACR Ageing
acr-aralloc Accounts Receivable Invoice Allocation acr-arinv Invoice
acr-arinv-csh Invoice acr-arinvln Invoice Line
acr-arinvln-csh Invoice Line acr-arrange Arrangement
acr-cdetab Accounts Receivable Code Tables acr-clacctint Monthly Client Account Interest
acr-claimtrn Claim Transactions acr-clerk Clerk Detail
acr-clerk-grp Clerk Account Group Link acr-client Client details
acr-clientcard Client Card acr-clientcred Client Credit
acr-clientfund Client Fund acr-clienthist Client History
acr-clientmem Client Members acr-clientstat Client Status'
acr-clienttrn Client Transactions acr-clienttype Client Type
acr-clntacct Client Accounts acr-clntinv Client Invoices
acr-clntinv-ln Lines for Client Invoices acr-contact Client contact persons
acr-control Account Receiveable control File acr-credalloc Credit Reservation
acr-credaud Credit Audit acr-crinsurence Credit Insurence
acr-debtmth Debtor Months acr-dtcomm Communication Detail
acr-elecclnt Electronic Client acr-emptycrn ACR Empties Credit Notes
acr-fund Fund acr-funddep Fund Deposit
acr-fundint Fund Interest acr-fundpmnt Fund Payment
acr-grpmth Debtors Account Group Interest Run for Month acr-interest Overdue Accounts interest rates
acr-invmsg Invoice Message acr-itemsales Summary of daily sales per item per branch
acr-linkclients Linked Clients acr-milling Milling
acr-milltrn Milling Transactions acr-monthdeduct Month Deduction
acr-paysched Share Payment Schedule acr-paytrnsfer Payment Transfer
acr-policy Policy acr-poltar Policy Tariffs
acr-recbills Clients Recurring Billing acr-sainvhdr SalesAssist invoice headers
acr-sainvln SalesAssist Invoice lines acr-security Security
acr-service Services used for client invoices/credit notes acr-settlm Settlment detail per account and fin period
acr-slsgrpitem Account Sales Group Items acr-slsrep Sales Representitive
acr-valacc Accounts Receivable Valid Accounts acr-web-user Debtors Website User
acs-cdetab Code table acs-payreq Payment Requests
acs-trans Transactions asr-asset Assets
asr-cdetab Asset Register Code Tables asr-control Asset Register Control File
asr-deprec-grp Asset Depreciation Groups asr-deprec-std Depreciation Grp Standards
asr-grpcode Asset Group Codes asr-grptype Asset Group Types
asr-location Asset Register Location asr-prev-nr Asset Previous Number
asr-purch Asset Purchases from GRN's asr-trn Asset Transaction
asr-units-sold The amount of units sold for SUM OF UNITS assets    
 
- c -
cbk-atmclerk Cash Book ATM Clerks cbk-atmcontrol Control File for ATM Accounts
cbk-bankclerk Cash Book Bank Clerks cbk-benific Cash book benificiaries
cbk-bnkacct Bank Accounts for organisation cbk-bnkrecon Bank Recon
cbk-bnkstmnt Bank Statements cbk-bnktrn Bank transactions from bank statement
cbk-bnktrntype Bank transaction types cbk-brnbnk Bank Accounts for Branches
cbk-cashier Cashbook Cashier cbk-cballoc Cash book allocations
cbk-cbsum Cashbook Summary cbk-cdetab Cash Book Code Tables
cbk-cheqno Cheque Numbers cbk-cheqpmnt Cheque Payments
cbk-cheqreg Register for Post Dated Cheques cbk-chqaud Cheque Audit Trail
cbk-clerk Cash Book Clerks cbk-coinage Cashbook Coinage
cbk-coinaud Coinage Audit cbk-control Cash Book Control File
cbk-deposit Cashbook Deposit cbk-devvend Deviation Vendor
cbk-elecpmnt Elect Payments cbk-hand-dep CashBook Hand Deposits
cbk-mailaud Cashbook Mail Audit cbk-maildtl Cashbook Mail Detail
cbk-mailhdr Cashbook Mail Header cbk-match Match Recon
cbk-memfund Applications for membership (shares) cbk-paymauth Cash Book Payment Authorisation levels
cbk-paymbatch Batch Payments cbk-paymreq Payment Request
cbk-pcacct Petty Cash Accounts cbk-pcalloc Petty Cash Allocation
cbk-pcclerk CB Clerk link to PC acct cbk-pcinvhdr Petty Cash Invoice Header
cbk-pcinvln Petty Cash Invoice Lines cbk-pcreq Petty Cash Request
cbk-probrn Payment Provider Branch cbk-prodev Payment Provider Device
cbk-prodtl Payment Providers cbk-profee Payment Provider Fee
cbk-protrn Payment Provider Transaction Type cbk-protrnaud Provider Transaction Audit Trail
cbk-protrnref Provider Transactions cbk-rdcheq RD Cheques
cbk-receipt Cashbook Receipts cbk-recon Cashbook Recon
cbk-recondev Recon Deviation cbk-shortack CBK Shortage Acknowledgement
cbk-tender Cashbook Tender cbk-tender-lnk Link tenders to branch tenders.
cbk-tiptrn Tip Transactions cbk-trnline Transaction bank stmnt line links
cbk-venduser Deviation Vendor UserID coe-cdetab Standard code table
coe-cl-cc Client and cost centre releationship coe-comment Customer comments.
coe-ctrl Customer control record coe-cust-item Customer item relationship
coe-disphdr Dispatch Header coe-displn Dispatch Line
coe-lostsls Lost sales per item coe-ordhdr Customer order header
coe-ordline Customer order line coe-prchist Special price history
coe-prcspec Special Prices coe-repsls Representative Sales History
coe-usage-hist Customer usage history    
 
- f -
fra-all-cl-line Franchise Allowance Claim Line fra-all-inv-ln Franchise Allowance Claim Invoice Link
fra-all-paid Franchise Allowance Paid fra-all-pd-line Franchise Allowance Paid Line
fra-allow-claim Franchise Allowance Claim fra-allow-run Franchise Claim Run
fra-allow-targ Franchise Allowance Target fra-cdetab Franchise Code Table
fra-favourite Franchise Favourite Items fra-grp-ret Franchise Member Group Retension
fra-inv-ln Franchise Invoice Line fra-invoice Franchise Invoice
fra-mem-allow Franchise Member Group Allowance fra-mem-grp Franchise Member Groups
fra-mem-grpchg Franchise Member Group Change fra-mem-user Franchise Members' Users
fra-member Franchise Members fra-message Franchise messages
fra-msg-sent Franchise Message Sent fra-ordhdr Franchise Order Headers
fra-ordln Franchise Order Lines fra-pay-run Franchise Payment Run
fra-valid-deal Franchise Valid Deals fra-vendor Franchise Vendors
 
- g -
glr-acctactual Account Actuals glr-acctbudg Account Budget
glr-accttrn Account Transactions glr-allowbudg Allowance Budget
glr-area Area Detail glr-arevparam Management Report Analytical Review Parameters
glr-budgdtl Budget Detail glr-budgmodel Budget Model
glr-budperc Percentage Table for Budgets from actuals glr-cashbrparam Management Report Cashpot Branch Parameters
glr-cashpparam Management Report Cashpot Parameters glr-ccassign
glr-cdetab General Ledger Code Tables glr-commbudg Budget per Dept per Category
glr-commbudvend Budget per Dept per Category per Vendor glr-committrn Commitment Transactions
glr-control Control File glr-costcent Cost Centres
glr-costcode Cost Codes glr-costcom Cost Code Commodity Link
glr-dates Start and End Dates for Cost Centers and Accounts glr-empbudg Employee Budget
glr-expauth Expenditure Authorisation glr-expbudgacct Expense Budget Account
glr-expbudgbase Expense Budget Base Accounts glr-expbudget Expense Budget
glr-expbudgincr Expense Budget Increase glr-expbudgnote Expense Budget Note
glr-expbudgperc Expense Budget Percentage glr-expbudgreq Expense Budget Requirement
glr-expbudgyear Expense Budget Year glr-genjrn General Journals
glr-jrnline Journal Lines glr-mainacct Main Account Detail
glr-ohassign Over Cost Assignment Parameters glr-ohtype Overhead Types
glr-reconacct Recon Account Access glr-recvrbudg Recover Budget
glr-reg-area Statement Region Area Link glr-repcc Report Cost Centers
glr-repgrp Report Groups glr-repmodel Report Model
glr-std-jrnhdr Standard Journals glr-std-jrnln Standard Journal Line
glr-stmnt-reg Statement Regions glr-stmntacct Statement Account
glr-stmntform glr-stmnthdg Statement Heading
glr-stmntmodel Statement Model glr-stmntuser Statement Users
glr-subacct Sub Account glr-tt-acctact Temp-Table for Account Actuals
glr-tt-acctbudg Temp-Table for Account Budget glr-tt-committr Temp-Table for Commitment Transactions
glr-tt-subacct Temp-Table for Sub Account glr-unit Units
glr-unittarif Unit Tariffs    
 
- i -
icc-cases ICC Cases icc-cat ICC Category
icc-deal ICC Deal icc-dealitem ICC Deal Item
icc-dealreg Deals for Region icc-dept ICC Department
icc-image ICC Image icc-item ICC Item
icc-list ICC List Price icc-packmat ICC Packing Material
icc-packtyp ICC Packing Type icc-prodtyp ICC Product Type
icc-region ICC Regions icc-seaitem ICC Seasonal Item
icc-season ICC Season icc-stat ICC Status
icc-taxtyp ICC Tax Type icc-uom ICC UoM
icc-vendor ICC Vendor ins-admin Insurance Administrators
ins-advisor Insurance Advisors ins-broker Insurance Brokers
ins-broker-com Insurance Broker Commission ins-cdetab Insurance Code Table
ins-claim-desc Insurance Claim Descriptions ins-claims Insurance Claims
ins-clnt-hdr Insurance Client Document Header ins-clnt-ln Insurance client document line
ins-comm-pay Insurance Commission Payment ins-commission Insurance Commision Percentages
ins-company Insurance Companies ins-control Insurance Control
ins-crop-area Insurance Crop Areas ins-crop-link Insurance Crop Type Link
ins-crop-type Insurance Crop Types ins-doc-hdr Insurance Document Header
ins-doc-ln Insurance Document Line ins-policy Insurance Policies
ins-policy-stat Policy Status ins-policy-type Insurance Policy Types
ins-schedhdr Insurance Schedule Header ins-schedln Insurance Schedule Lines
inv-abonusgrp Agri Bonus Groups for Company's own items inv-abonusitem Agri Bonus Item
inv-actexpcomp Active Explosions Component Records inv-actexppar Active Explosions Parent Records
inv-alloc Alloc Qty Audit Trial inv-apurequest Apu Change Requests
inv-bonus-item Bonus Item inv-brand Inventory Brands
inv-brnlt Inter Branch Lead Time inv-brnpln Branch Planner
inv-brnrel Branch Relationships inv-budget Inventory Budget
inv-combobrn Combo Branches inv-combocom Combo Commodities
inv-combohdr Combo Master Header inv-comboitem Combo Items
inv-commbu Std defaults for commodities in a business unit inv-commodity Commodity Code Categories
inv-commsub Commodity Sub Categories inv-discgrp Item Discount Group
inv-discitem Discount Group Item inv-discperc Discount Group Percentage
inv-discrules Discounts Rules Matrix inv-disctend Valid Discount Tender Types
inv-dist-item Distribution Item inv-distbrn Distribution Branch
inv-distgrp Distribution Group inv-excbrn Excess Group Branch Link
inv-excess Publish Excess Stock inv-excgrp Excess Group
inv-expitem Contains Records for manufactured items inv-explnkcost Link records between expstruc and itemcost
inv-expstruc Manufactured Item Explosion of Components inv-facing Facing
inv-forecast Forecast inv-grp-item Item Group Junction
inv-grptype User Group Type inv-grpuser Valid users for user group
inv-handperc Hadeling Percentage inv-icost-trig Inv Itemcost Trigger
inv-imcde Inventory management code table inv-imcntr Item Master Control Record
inv-impwgt Table to save imported weights inv-invacct Inventory Account Detail
inv-item Item Master inv-item-audit Item Audit Details
inv-item-brnex Items that must be excluded from listed branches inv-item-grp Group codes per group type
inv-item-uplift Item Upliftment inv-itembal Item Daily On Hand Balances
inv-itemcost Item detail per cost centre (Branch) inv-itemfifo Item FIFO Detail
inv-itemhist Item History inv-itemlot Item Lot Detail
inv-itemmloc Item Multi Location Details inv-itemstd Item standard
inv-itemtax Vat Codes per Item inv-itemtaxcnty Tax Codes per Country
inv-itemtrig Item trigger to be checked inv-itemtrn Store Movement Transactions
inv-itemvar Item Master Variable Fields inv-lotstat Lot Status for status control
inv-lottrn Lot Transaction Details inv-mandgrp Mandatory Groups
inv-mfr Manufacturing Codes inv-mfritem Manufacturers Items
inv-mfrprc Manufacturers Item Prices inv-millcost Milling Cost
inv-millitem Mill Item inv-millpurch Mill Purchase Cost
inv-model-allow Items allowed for Model Stock inv-modstkreq Model Stock Change Requests
inv-negcde Negotiator Maintenance inv-negrel Negotiator Relationships
inv-negrem Negotiator Remarks inv-newplu New plu code for item
inv-packno Alternate barcodes & pack sizes for an item inv-plhdr Pick List Header Detail
inv-plline Pick List Line Detail inv-plncde Planner codes
inv-plnrel Planner Relationships inv-plu Central Plu File
inv-prccomp Company Price inv-prcdef Price Defaults
inv-prcexport Price Export inv-prcimport Price Import - QlikView Price Modeling
inv-prcprt Prices needed to be printed inv-prcseggp Price Group Segment GP and MU Percentage
inv-prodorder Production Unit Consolidated Order inv-produnit Production Units
inv-provbrn Provisional Price Branch inv-provsls Provisional Special Price
inv-provstd Provisional Standard Price inv-rounding Rounding of Cents
inv-scaleaud Scale Audit inv-scalebrn Scale Setup per Branch
inv-scaleprc Scale Price inv-segmentbu Std defaults for segments in a b
inv-segments Commodity Segments inv-serv-audit Service Transactions Audit Trail
inv-serv-comrun Service Provider Commission Run inv-serv-item Service Item
inv-serv-itm Service Provider Item Detail inv-serv-itmaud Syntell problem sales audit trail
inv-serv-itmcos Service Item Cost inv-serv-itmdef Service Item Default
inv-serv-itminv Service Item Invoice Detail inv-serv-itmprc Service Item Price
inv-serv-itmprt Service Item Reprint inv-serv-itmtrn Service Item Transaction
inv-serv-netcom Netcode Comission per Provider inv-serv-probrn Service Provider Branches
inv-serv-procom Service Provider Commission inv-serv-prodev Service Provider Devices
inv-serv-prov Service Provider Detail inv-service Service Items
inv-shvgl-sum Stock Holding vs GL summary snapshot inv-shvgl-trntp Stock Holding vs GL transaction-type summary snapshot
inv-slsprc Sales price details inv-stkprot Stock Protection
inv-stockjrn Chicky Stock Journal inv-store Store Details
inv-storereq Stores Requesition inv-trans-claim Transit Claim
inv-trans-item Transit Item inv-trans-trn Transit Transaction
inv-unique-term Unique number linked to the terminal Id inv-unit-conv Unit of measure conversion
inv-validfin Valid Financial Codes inv-volbrk Item Volume Break
inv-whlsale-mu Wholesale Markup 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
 
- j -
job-jobcard Jobcard Master File    
 
- l -
lsc-app-hits Loyalti APP hits lsc-bonus-point Loyalty Bonus Points
lsc-bp-acct bonus point account detail lsc-cdetab Loyalty Code Table
lsc-comp-entry Loyalty Competition Entries lsc-comp-item Loyalty Competition Qualifying Items
lsc-comp-vendor Loyalty Competition Qualifying Vendors lsc-competition Loyalty Competitions
lsc-control Loyalty Control File lsc-exclusion Exclusion Items
lsc-feedback Member Feedback lsc-group Loyalty Groups
lsc-group-rew Loyalty Group Reward lsc-group-spec Loyalty Group Specials
lsc-mem-point Member Points earned lsc-member Loyalty Member
lsc-member-card Loyalty member card lsc-memitm-use Loyalty member item usage
lsc-message Loyalty Message lsc-msg-member Loyalty messages send to member
lsc-msg-sent Loyalty message sent lsc-point-red Member Points Redeemed
lsc-promo-item Loyalty Promotion Items lsc-promo-rew Loyalty promotion Rewards
lsc-promotion Loyalty Item Promotions lsc-purch-point Loyalty Purchased Points
lsc-vendor-point Loyalty Vendor Points lve-accrual Leave Accrual Parameters
lve-cdetab Leave Code Tables lve-control Leave Control Record
lve-entry Leave entries lve-form Leave Forms
lve-grptype Leave Group Type Links lve-pmntadv Leave Payment Advise
lve-reason Leave Reasons lve-reqst Leave Requests
lve-takeon Leave Takeon lve-type Leave Types
 
- 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 -
pmm-cdetab Preventative Maintenance Code Table pmm-comp-hist Component History
pmm-comp-master Component Master pmm-defcomp Default Component Tasks
pmm-defmach Default Machine Tasks pmm-grp-access PMM Group Access
pmm-mach-comp Machine Components pmm-mach-hist Machine History
pmm-mach-maint Machine Maintenance pmm-machine Preventative Maintenance Machines
pmm-maint-task Machine/Component Maintenance Tasks pmm-spares-req Spares Requested
pos-apprcheq Point of Sale Approve Cheques pos-apprcheqtrn Point of Sale Approve Cheque Transactions
pos-blacklist Point of Sale Blacklisted Clients pos-cashier Cashiers and supervisors
pos-item POS Item pos-slsprc Online Sales price details
pos-till Till record pos-voucher POS Gift and promotional vouchers
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 prs-acting Employee Acting Detail/History
prs-actremun Employee Actual Remuneration prs-applcrse Applicant Courses
prs-applicant Applicants for vacant posts prs-applqual Applicant qualifications
prs-applskill Applicant skills prs-apply Vacant posts applications
prs-areateam Area Team prs-authopt Authorisation Options
prs-author Authorisations prs-awards Employee Awards History
prs-benefic Beneficiary prs-budgremun Employee Budget Remuneration
prs-ccshift Cost Centre Shifts prs-cdetab Personnel Code tables
prs-clerk Personnel Clerks prs-clerk-br Personnel Clerks linked to branch
prs-club Employee Club Detail prs-control Control File
prs-counsel Counselling Sessions prs-course Employee Courses
prs-coursetype Employee Course Types prs-cpa Critical Performance Appraisal
prs-crssched Course Schedules prs-depend Employee Dependends
prs-displ-acc Disciplinary Manager Access prs-displ-mng Disciplinary Manager
prs-emp-deduct Personnel Deductions prs-empapln Employee Appraisal Lines
prs-empappr Employee Appraisals prs-empcc Employee transfers between cost centres
prs-empcpa Critical Performance Appraisal per Employee prs-empgrp Employee Grouping
prs-employee Employees prs-empmed Employee Medical
prs-empoth-opt Employee 'Other' Screen Options prs-empsched Employee course applications and schedule
prs-empstruc Employee Reporting Structures prs-empteam Employee Team
prs-emptrain Employee Training prs-exit-int Employee Exit Interview
prs-exit-interview Employee Exit Interview prs-experience Employee Experience
prs-hearing Employee Ad Hoc Hearing prs-indarea Area Indicator
prs-itaudit IT Audit prs-language Employee Language skills
prs-leave Leave prs-lvcap Leave Capitalised
prs-lvcde Leave Code prs-medical Medical
prs-medtable Medical Table prs-merit Employee merit detail
prs-obligation Employee Obligations prs-postcpa Critical Performance Appraisal per Posttitle
prs-postskill Skills for each Post prs-posttitle Employee Post Titles
prs-qual Employee Qualification history prs-qualtype Employee Qualification Types
prs-recreation Employee Recreation Detail prs-repopt Report Options
prs-resign Employee Resign history prs-shift Shift
prs-skill Employee Skills prs-spouse Employee Spouse Detail
prs-subject Employee Qualification subjects prs-union Employee Union member ships
prs-vacancy Personel vacancies prs-viol-hist Personnel Warning History
prs-violation Employee Violation History prs-wcmed Work Centre Medical
prs-wcpost Work Centre Post prs-wcshift Work Centre Shift
prs-workcent Employee Work Centre prt-class Printer Classes
prt-defpar Default report parameters prt-drvctrl Printer driver controls
prt-printer Printer details prt-prtdrv Printer driver
prt-prtfile Print file prt-report standard report details
prt-stat Printer Stationary prt-stationary Stationary types
pur-all-cat-typ Purchasing Allowance Category Type link Table pur-all-cl-inv Allowance Debtor Invoices per Claim
pur-allow-alloc Purchasing Allowance Allocation pur-allow-cat Purchasing Allowance Category
pur-allow-claim Allowance Claims pur-allow-inv Vendor Invoices per Debtor Inv per Allow Claim
pur-allow-item Purchasing Allowance Items pur-allow-targ Purchasing Allowance Target
pur-allow-type Purchasing Allowance Type pur-auto-ord Automatic Order
pur-auto-stat Job Status pur-auto-vend Automatic Order Setup
pur-buyer Buyer detail pur-buyer-claim Purchase Buyer Claims
pur-buyerbrn Buyer Branch Relationship pur-buyerrel Buyer Relations
pur-buyerresp Purchasing Buyer Responsibilities pur-cal-appaud Purchasing Web Calendar Appointment Audit Trail
pur-cal-appdeal Purchasing Web Calendar Appointment Deal pur-cal-appoint Purchasing Web Calendar Appointment
pur-cal-userlnk Purchasing Web Calender Superuser Link pur-cal-vendor Purchasing Web Calendar User Vendor Link
pur-cdetab Code table for purchasing pur-claim Purchasing Claims
pur-contact Contact persons for vendors pur-contract Vendor Purchasing Contracts
pur-contrsched Vendor contract payment schedule pur-ctrl Purchase order control file
pur-dropship Direct Customer Order pur-dsbooks Direct Speed Purchase Order Books
pur-edi-log Log entries for EDI files transfers pur-edivendor Vendor EDI Setup
pur-empty Empties/Crates pur-fvbrn Fruit & Veg Branches
pur-fvcat Fruit & Veg Categories pur-fvordbrn Fruit & Veg Branch Order
pur-fvordhdr Fruit & Veg Order Header pur-fvordln Fruit & Veg Order Line
pur-fvpalitem Fruit & Veg Pallet Item pur-fvpalvend Fruit & Veg Pallet Vendor
pur-grnac GRN Additional Cost pur-grnaud ACP/PUR Audit Trial
pur-grnhdr Goods receiving header pur-grnln Goods received note line
pur-grnlot GRN Lot details pur-handperc
pur-icc-deal ICC Deals Imported pur-intacct Internal Client Accounts
pur-intvend Internal Vendors pur-item Receiving Item per Branch
pur-item-vend Item Vendor Relationship pur-item-vendbrn Item Vendor Branches
pur-itemvendbrn Item Vendor Branches pur-itemvendgrp Item Vendor Group Override
pur-namecnty Vendor Name per Country pur-ordac Order Additional Cost
pur-ordaud Order Audit pur-ordhdr Order Header
pur-ordln Order Lines pur-ordstdrem Order Standard Remarks
pur-pallet Pallet Configuration pur-palletitm Pallet Configuration Items
pur-palletvend Pallet Configuration Vendor pur-prcchg Purchase Order Price Change
pur-prhdr Purchase Requisition Header Detail pur-prln Purchase Requisition Lines
pur-prombr Promotional Sheet for Branch pur-promhdr Promotional Sheet Header
pur-promhist Promotional Sheet Order History pur-promln Promotional Sheet Line
pur-promvol Promo Volume Break pur-provbrn Vendor Provisional Price Branch
pur-provprc Vendor Provisional Price pur-ran Return advice number
pur-rebate Vendor Rebates pur-recvreg receiving register
pur-rethdr Additional Return Header pur-retln Additional Return Line
pur-scan Detail and progress of scanning in packs pur-scanex Scan/Weight Exceptions
pur-scanex-brn Scan/Weight Exceptions per Branch pur-schedadv Buying Schedule Claim Line
pur-schedhdr Buying Schedule pur-schedinv Buying Schedule Claim
pur-schedln Buying Schedule Line pur-schedpur Buying Schedule Purchase Price
pur-schedsls Buying Schedule Selling Price pur-settlcon Settlement conditions
pur-stdrem Standard remarks for orders pur-tallydoc Tally/Sally Claim Documents
pur-tallyitem Tally/Sally Claim Items pur-tallyvend Tally/Sally Claim Vendor
pur-terminal Purchasing Terminal pur-uplift-type Purchasing Upliftment Type
pur-vend-allow Pur Vendor Allowance pur-vend-uplift Pur Vendor Upliftment
pur-vendac Vendor additional costs pur-vendaddr Address types
pur-vendbrn Vendor Branch Relationship pur-vendbrnacct Stores Vendor Account numbers per branch
pur-vendcitem Vendor Consignment Contract Items pur-vendclaim Vendor Claim Parameter
pur-vendcnty Vendor per Country pur-vendcomm Vendor commodity relationship
pur-vendcontr Vendor Consignment Contracts pur-vendgrp Vendor groups
pur-vendor Purchase Vendor detail pur-vendprc Vender item prices by effective date
pur-web-autord Temp Table for Supplier Website Auto Order Report pur-web-claims Temp Table for Supplier Website Claims Report
pur-web-comp Supplier Website Company pur-web-ordstat Temp Table for Supplier Website Orders per Status
pur-web-overstk Temp Table for Supplier Website Reports pur-web-range Temp Table for Supplier Ranging Reports
pur-web-servlvl Temp Table for Supplier Website Service level Rep pur-web-user Supplier Website User
pur-web-vend Supplier Website Vendor pur-web-vendsls Temp Table for Supplier Website Sales Reports
pur-web-zerostk Temp Table for Supplier Website Reports    
 
- 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 -
sal-balance Salary Balance sal-benefic Salary Beneficiary
sal-cdetab Salary Code Tables sal-claim Claims
sal-clerk Salary Clerk sal-control Salary Control
sal-costalloc Sal Cost Allocations sal-deduct Deductions
sal-denom Salary Denominations sal-directive Salary Directive
sal-earning Earnings sal-effrule Effective Rules
sal-empalloc Employee salary allocations sal-empben Employee Beneficiary
sal-empbudg Employee Budget sal-empclerk Salary Empclerk
sal-empdenom Employee Denominations sal-employer Salary Employer
sal-empmed Salary Empmed sal-emprun Keeps track of employees who's sal run completed
sal-empsum Employee Summery sal-formula Formulas
sal-irpno Salary IRP5 no sal-medtable Salary MedTable
sal-mthname Month Name sal-payearn Pay Earnings
sal-payroll Salary Payroll sal-payslip Payslip
sal-perk Perks sal-posttar Post Tariffs
sal-remitadv Salary and Beneficiary Remittance advice sal-revremit Reverse Remittence
sal-rule Rules sal-runaud Run Audit
sal-salacct Salary Account sal-salben Salary Code Beneficiary
sal-salcde Salary Codes sal-salmth Salary Month
sal-salrun Salary Run sal-salweek Salary Week
sal-salyear Salary Year sal-stdcde Standard Code
sal-tarfact Salaries Tariff Factors sal-taxyear Tax year
sal-typealloc Sal Type Allocations scl-log Support Logs
scl-log-plan Log Planning scl-log-resp Log Responses
scl-log-type Log Types scl-tech-brn Branch Technician Link
scl-technician Support Technicians scl-type Support Types
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-banktype Bank Type Link 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-branchglncde 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-contact Contact persons for branches 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-glncde Branch Global Location Number
sys-help System help text sys-histctrl Configuration of Audit Trails and History
sys-holiday Calendar holidays 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-menu User-specific menu access overrides 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-usergrp User groups / roles for menu access sys-usergrp-mem User to group membership for menu access
sys-usergrp-menu Menu access assigned to user groups sys-userhist User history
sys-webmenu Web Menu    

generated 18-9-2026 10:01