1. SQLDET Database Structure Datafile Software SQLDET Database Structure Two new data items can be added to the SQLDET.DFD file that will record the program and the parameter number which generated, together with the existing (Premier only) options to record the user-id, da... Read More
2. Print Database Structure Datafile Software Print Database Structure During system maintenance it can be useful tool to print the database structure which details the data item names and types within the system. Where Table Items and Constant Values (both as an item type... Read More
3. Discount Matrix File Structure Datafile Software Discount Matrix File Structure The matrix database has a pre-defined structure, as described below. The prime index is a composite of the account code or group and the product code or group (and the expiry date if so configured... Read More
4. Print Menu Structure Datafile Software Print Menu Structure This option allows you to print details of a particular menu or all menus. If you want to print details for a specific menu highlight the menu required using the mouse or the arrow keys and then click P... Read More
5. Input File Structure - Sales/Purchase Batch Updates Datafile Software Input File Structure - Sales/Purchase Batch Updates This requests the type of file being imported. There are two possible options – D for Datafile database input file, or Afor ASCII/CSV file.... Read More
6. Input File Structure - Stock Batch Update Datafile Software Input File Structure - Stock Batch Update This requests the type of file being imported. There are two possible options – D for Datafile database files and A for an ASCII file.... Read More
7. Input File Structure - Job Costing Batch Update Datafile Software Input File Structure - Job Costing Batch Update This requests the type of file being imported. There are two possible options – D for Datafile database input file, or Afor an ASCII file.... Read More
8. Application Menu Structure - EDI Order Processing Datafile Software Application Menu Structure - EDI Order Processing The application menu has seven options: Process Recieved Messages Pass Orders to Datafile Software Revalidate Incoming Orders (incl prior) Reprint Pending Orders Re... Read More
9. Lookup File Structure Datafile Software Lookup File Structure Item Name Type Size Description 1 CODE X 17 Lookup code, which might be a trading partner code, an EAN product or location code, or any other code 2 NAME X 40 Description or name 3 INTERNAL-CODE X 17 Used ... Read More
10. P11 Transaction File Database Structure Datafile Software P11 Transaction File Database Structure This database is maintained and used by the system for P11 reporting. This list allows you to see what the data items hold for use in reports and documents. You can add your own data ... Read More