Designed for dBXL, a dBASE III PLUS clone with Quicksilver language extensions
Click here to view instructions on "How to Use" and to download a Development System of dBXL and Quicksilver
|DEBTOR.dbf||Main Customer master file See Option 1|
|Indexes||Includes MTD Statement balances Current, 30 day, 60 day, 90 day balances and Bal c/f Previous month as well as numerous other fields.
||DEBCLUBS.dbf||Customer Clubs file See bottom line menu via Option 1.2
||Index|| Customer Clubs - i.e. New Book Club , Album of the month club. Shows quantity required.
||MEMFILE.dbf||Customer Notes file See bottom line menu via Option 1.2
||Indexes||EMSENT.dbf||Customer Emails sent file See Option 1.8
||Index||Rarely (if at all) used. Keeps account of Emails Sent directly by Stock program that bypass MS Outlook
||BKO.dbf||Main Back Orders Outstanding file See Option 2
||Indexes||PRODUCT.dbf||Main Product master file See Option 3
||Indexes||PRODRPH.dbf||Product Replacement History Linkage File See bottom line menu via Option 3.2
||Index||When a new product is substituted to provide ongoing sales of a now deleted product, a linkage can be set up and its history reflected in this history file
||ITEMS.dbf||Manufactured Products Linkage file See bottom line menu via Option 3.2
||Indexes||Links Manufactured Products to their individual items, and vice-versa.
||PMEMFILE.dbf||Product Notes File See bottom line menu via Option 3.2
||Index||CATEGORY.dbf||Main Category master file See Option 4.1 and 4.2
||Index||CATSUPP.dbf||Supplier master file for CLC Wholesale See Option 4.5
||Index||REGION.dbf||Sales Region Budgets file See Option 4.6
||Index||Provides Monthly and Yearly Sales Budgets for each Sales Region
||PCONTROL.dbf||Product Prefix Control file See Option 4.7
||Index||Inserts Supplier Code 3 digits and Publisher Code 3 chars when a product with the applicable prefix is created.
||PCMASTER.dbf||Postcode Sales Region Lookup file See Option 4.8
||Index||Allocates a Sales Region to a specific Postcode / Postcode Range
||EXCHANGE.dbf||Supplier Exchange Rate file See Option 4.E
||Index||Provides Exchange Rate conversion as new stock arrives and is entered using foreign currency
||GROUPS.dbf||Customer Discount Groups file See Option 4.D
||Index||Provides a number of Discount price variations for customer groups such as Koorong for 1. a specific product, or 2. a specific supplier and product category, or 3. a specific supplier, or 4. just overall for that group.
||SALECODE.dbf||Sales Code file See Option 4.S
||Index||Provides a list of the Sales Codes used when entering Invoices / Credit Notes
||CCLASS.dbf||Customer Classes file See Option 4.C
||Index||Provides a list of the Customer Class Groups (up to 5) that each customer can be a member of
||GRIDFILE.dbf||Card Grid file See Option 4.G
||Index||Provides a lookup for current product code 7 chars attached to a Card ID
||RUNTRANS.dbf||Worksheet, Invoice, CreditNote, Payment, Journal, Consignment — Main Input file Used by Options 5.1 and 5.2
||Indexes||RUNCTRL.dbf||Worksheets, Invoices, Credits Input Status file Used by Options 5.1 and 5.2
||Index||RUNBATCH.dbf||Web Orders Batch Control file See Option 5.1.B
||Index||Shows date a specific batch file number was downloaded from web
||DAUDIT.dbf||Deleted Transactions Audit file See Option 5.D
||Index||Provides audit trail of transactions cancelled prior to update (Option 5.4)
||YTDTRANS.dbf||Main Accounts History file Updated by Option 5.4 ||Indexes ||Updated automatically by Option 5.4. Contains many years of account statement history - not just one year to date.
||CONTRANS.dbf||Main Consignment History file Updated by Option 5.4
||Indexes ||STKTRANS.dbf||Main Stock Sales History file Updated by Option 5.4
||Indexes ||STKMONTH.dbf||MTD Inv, Credits History file Updated by Option 5.4
||Index||Updated automatically by Option 5.4. Used to reprint invoices or credits.
||RUNCTRH.dbf||Inv, Credits History Status file Updated by Option 5.4
||Index||PTDTRANS.dbf||Inv, Pays, Jnls, Credits MTD Transaction file Updated by Option 5.4
||Indexes ||Updated automatically by Option 5.4. Used when printing statements and for MTD Sales Reports.
||FMTD.dbf||Customer Freight MTD file Updated by Option 5.4 Used by Option 1.4.
||Index||Used to show actual sales MTD on Customer Enquiry, by reducing Invoiced total by Freight total
||FTRANS.dbf||Customer Freight to date file Updated by Option 8.1 Used by Option 1.4.
||Index||Used to show actual sales YTD on Customer Enquiry, by reducing Invoiced total by Freight total
||ORDTRANS.dbf||Main Purchase Orders Outstanding file See Option P
||Indexes ||PURHDR.dbf||Current Purchase Orders Status file See Option P.C
||Index ||PURTRANS.dbf||Main Purchases History file Updated by Option P.3 (or 5.4)
||Index ||ARCHIVES||JAN.dbf - DEC.dbf||Copy of Previous STKMONTH.dbf. Updated by Option 8.1
||Index ||Stored in ARCHIVE sub-directory initially, then 12 months later, copied to a sub-directory that has the 4 digits of the year number (e.g. 2007) to save being overwritten. Used to reprint invoices or credits.
||2003.dbf (2004.dbf, etc)||Stock Sales History file for previous calendar years. Updated by Option 8.2
||Indexes ||2003s.dbf (2004s.dbf, etc)||Stock Sales Summary file of total sales by product code for each customer for previous calendar years. Updated by Option 8.2
||Stored in OLDSTOCK sub-directory. Used to keep track of past sales.
||OTHER SUB-DIRECTORIES||UPDATE||Copy of Data Files prior to Last Update (Options 5.4, 8.1 and 8.2)
||LG||All those same files following a Last Successful (Good) Update Option 5.4 only
||LMTH||All the files prior to last End of Month update Option 8.1
||LYR||Various Master files prior to last End of Year update Option 8.2
||MONTHLY||Various MTD files placed in the appropriate sub-sub-directory using YYYYmmm where YYYY is the year number and mmm is the month. Run prior to an End of Month update Option 8.1
||CONTROLS||Used to store Control Totals Option 5.6 when Email sub-option chosen only
||YTDSALES||Recent directory used to generate monthly management reports
||WORK||Temporary work files only
Main Processing Options
A copy is taken to the UPDATE sub-directory before Options 5.4, 8.1, and 8.2 are run of all critical files . Exclusive use of these files is then required. A flag is set, the process is run, then the flag is cleared. In the event of a power fail or any other error causing the process to fail, the system automatically rolls back the UPDATE folder when the system is restarted.
SETUP.mem is a System Control file that stores approx 60 memory variables. Many can be updated manually in Option 9.4.
DEBTORnn.mem is a Local Control file for approx 40 memory variables applicable to the workstation. nn is generated by a command line environment variable SCREEN (e.g. SET SCREEN=5)
Click here for some background on Stephen Williamson Computing Services Pty Ltd
Click here for a development system for dBXL and Quicksilver
** End of Schema