Skip to content

BOS Print Database

 

Before you can query a database, it is important that you know and understand the tables as well as the relations between the tables in a database.

The following table outlines how the Transactional Tables in the QuickEasy database are linked.

BOSPrint Tables

TABLE NAMEPRIMARY KEYDESCRIPTION
ACCOUNTCATSACCOUNTCATIDStores the Account Categories
ACCOUNTSACCOUNTIDStores the Accounts
AGEINGAGEIDStores the values of the Age Analysis for both the Customers and Suppliers
ALERTSALERTIDStores the Setups for Transactional Alerts
ASSETSASSETIDList of companies assets
AUDITSAUDITIDStores Records of Changes, Updates, Deletes of Transactional and Systematic updates
BALSHTBALSHTIDStores information Displayed on the Balance Sheet
BANKBANKIDStores Transactions from the Bank Import
CALENDAR_EVENTSEVENTIDStores events added to the Calendar
CASHFLOATCASHFLOATIDStores the Monetary value of a Cashup done in QE
CASHUPCASHUPIDStores the Cash-ups done in the POS
CATEGORIESCATEGORYIDJob Categories
CCENTRECCENTREIDCost Centres/Machines setup in the Database
CCCOSTSCCCOSTIDStores Costs Allocated to Cost Centres
CONSOLECONSOLEIDDashboard Indicators
CONTACTSCONTACTIDStores all the Contacts the DB has, Customer, Supplier, and Staff Contacts
COSTITEMSCOSTITEMIDStores items that reflect the costs surrounding a set transaction / Transaction item
COSTTYPESCOSTTYPEIDStores Types of costs. Ie Material, Finsihing, pre – press
CPYMAINCPYMAINIDStores information of the licensed company
CPYSTAFFSTAFFIDLicensed Company Staff
CREDITTERMSCREDITTERMIDStores the Credit Terms
CURRENCIESCURRENCYIDDifferent Currencies and a conversion rate in respect to the Home currency
CUSADDRESSADDRESSIDCustomers Delivery Addresses
CUSCATCUSCATIDCustomer Categories
CUSCONTACTSCUSCONTACTIDCustomer Contacts
CUSCREDITMAINCCMAINIDCustomer Credit Notes
CUSCREDITITEMSCCITEMIDCustomer Credit Note Transaction items
CUSMAINCUSIDStores Customers information
DELMAINDELIDDelivery Notes
DELITEMSDELITEMIDDelivery Note transactional items
DOCUMENTSDOCIDStores Document records Loaded in QE
DSAUDITSDSAUDITIDStores Records of all things Exported / Imported Using Datashift
DSMAINDSMAINIDData shift export / Import files
DSTABLESDSTABLEIDTables used in the Export / import file
DSFIELDSDSFIELDIDFields that will be imported/Exported from the selected table
EMAILSEMAILIDStores Email (sent and in the outbox)
EMAILS_ATTACHMENTSATTACHMENTIDStores the Email Attachments
EMAIL_LISTEMAIL_LIST_IDStores Email group for Mailshots
EMAIL_LIST_ITEMSLIST_ITEM_IDStores the Contacts in the Mailshot (Mail Group)
ENTRYTYPESENTRYTYPEIDStores the Ledger Transactions Setup
FIELDSPECSFIELDSPECIDUserfields that are setup in the DB
FIELDVALUESFIELDVALUEIDThe information stored in these userfields
HOLIDAYSHOLIDAYIDStores Holidays
INCSTATINCSTATIDStores information Displayed on the Income Statement
INFO_TOPICSTOPICIDStores the Articles in the Knowledge Base
INKGROUPSINKGROUPIDStores Ink groups set up in the DB eg. CMYK, 3 Spot Colours
INKGROUPITEMSINKGROUPITEMIDStores information of the inks in the Ink Group
INVMAININVIDCustomer Invoices
INVITEMSINVITEMIDCustomer Invoices transactional information
LEAVELOGLEAVELOGIDThis is where the Staff leave information is kept
LEAVERULESLEAVERULEIDThis is where the rules for the Leave Types are kept
LEAVETYPESLEAVETYPEIDInformation of the Type of leave days are kept. eg. Sick Leave, Family responsibilities
LEDGERTRANSIDThis is where all Accounting related transactional information is stored
LEDGERALLOCATIONSLEDGERALLOCIDThis is where all the transactional allocations are kept
LOOKUPSLOOKUPIDThis is where the fixed look up list in QE are kept
MATBOMMATBOMIDMaterial Bill of Materials are stored
MATCATMATCATIDThis is where Material Categories are stored.
MATCOSTMATCOSTIDWhere the Selling price information of an item is kept
MATPRICEMATPRICEIDWhere the Cost price information of an item is kept
MATPROCESSMATPROCIDMaterials linked to Services
MATQUOTESMATQUOTEIDQuotes Linked to items
MATTREEMATTREEIDInformation of the Bill of material of an item, eg, Qty's costs, BOM Level
MATUNITMATUNITIDAll items in the DB are kept here
NOTESCOINSNOTESCOINSIDDenominations of home currency is stored here
PACKAGINGPACKIDStores the Delivery options
PACKMATPACKMATIDStores information on the Item linking to the Packaging Options
POMAINPOIDPurchase Orders
POITEMSPOITEMIDPurchase Orders Transactional items
POSITIONSPOSITIONIDStores the Staff Positions eg. Production, Sales, Owner
PRESSMAINPRESSIDStores the Presses
PRESSCYLINDERSPRESSCYLINDERIDStores Cylinder Setup information of Flexo Press Machines
PRESSDIESPRESSDIEIDStores Dies Setup information of Flexo Press Machines
PRESSMATPRESSMATIDMaterials linked to Press Run Options
PRESSPREPRESSPRESSPREPIDPress Pre-Press Options
PRESSRUNOPTIONSPRESSOPTIONIDPress Run Options
PRICEMAINPRICEIDStores Price Manager Setups
PRINTTYPESPRINTTYPEIDStores the Types of Printing
PROCCATPROCCATIDStores Service Categories
PROCESSPROCESSIDStores Services
PROCMATPROCMATIDStores information of the materials linking to services
PRODCODESPRODCODEIDStores Production Codes
QUOTEBROKEQUOTEBROKEIDEstimate Outsourced Services are stored here.
QUOTECOSTSQUOTECOSTIDStores Ink Prices on Quotes
QUOTEDESCQUOTEDESCIDStores the Quote Descriptions
QUOTEFINQUOTEFINIDStores the Quote Services
QUOTEITEMSQUOTEITEMIDStores the Quote items on Itemised Quotes
QUOTEMAINQUOTEID,ENQIDStores the Quote Header information eg, Customer, Date, Status etc
QUOTEOUTSOURCEQUOTEOUTIDStores Material items that are linked to the Quote, excluding Inks and Printing Paper (Other Material)
QUOTEQTYQUOTEQTYIDStores the Quote Qty's and Values per Qty
QUOTEREPROQUOTEREPROIDStores the Quote Pre-Press information
QUOTESECTIONQUOTESECIDStores Printing Sections on Quotes
QUOTESHIPPINGQUOTESHIPIDStores Delivery option of the Quote
QUOTESUBQUOTESUBIDStores Estimate Outsourced Prices and Qty's
QUOTESUMQUOTESUMIDStores the Quote Values, eg, Direct cost, commission, VAT
REMINDREMINDIDStores Custom and Workflow Reminders
REPORTSREPORTIDStores Reports and Templates in the DB
REPORT_FIELDSFIELDIDStores the Report Fields in the DB. (Data fields and Calculated)
SECTIONFINITEMSSECTIONFINITEMIDFinishing services linking to Sections Setup
SECTIONOPTIONSSECTIONOPTIONIDStores the Default Press information on the Section Setups
SECTIONSSECTIONIDStores the Printing Sections
SETTINGSSETTINGIDStores the System Settings
SHIPCOSTSSHIPCOSTIDStores the Shipping locations
SHIPPRICESSHIPPRICEIDStores the Shipping options
SOMAINSOIDSales Orders
SOITEMSSOITEMIDStores Sales Orders Transactional Information
SOPOSPOSIDStores POS Transaction information
SOSTAGESSOSTAGEIDPlanning board Stages
STAGESSTAGEIDPlanning board Stage Setups
STAGESTATUSSTAGESTATUSIDStatuses on the Planning board Stages
STATUSSTATUSIDStores Statuses of transactions, and Fixed modules excluding PB Stage Statuses
STOCKSTOCKIDInventory items
STOCKCHECKSTOCKCHECKIDStores System Stock Checks done
STOCKMOVEMENTSTOCKMOVEMENTIDMaterials Movement and Stock Movement Transactions
STOCKMOVEMENTITEMSSTOCKMOVEITEMIDStores Items that are on the Stock Movement Transactions
STOCKTRANSSTOCKTRANSIDStores all transactions that affect Inventory
STOCKTRANSMAINSTRMAINIDStores header information of Stock Transfers
STOCKTRANSITEMSSTRITEMIDItems on Stock Transfers
SUPCATSUPCATIDSupplier Categorries
SUPCONTACTSSUPCONTACTIDSupplier Contats
SUPCREDITMAINSCMAINIDSupplier Credit Notes
SUPCREDITITEMSSCITEMIDSupplier Credit Note Transactional items
SUPINVOICESUPINVIDSupplier Invoices
SUPINVITEMSSUPINVITEMSSupplier Invoice Items
SUPMAINSUPIDStores Supplier Informations
TIMELOGTIMELOGIDStores Time keeping Records
TRAILTRAILIDStores information on the Trail Balance
UNITCOST_HISTORYHISTORYIDPrice Update information are kept here
UNITSUNITIDMaterial Units
WOBOMWOBOMIDBill of material on a Work Order
WOMAINWOIDStores Work Order information
WOOUTPUTWOOUTPUTIDHeader information on the Work Order
WOPROCSWOPROCIDStores the Services on the Work Order
WORKFLOWWORKFLOWIDWorkflows are stored here
WORKFLOWMODULESMODULEIDWorkflow Modules are stored here
WORKFLOWITEMSWFITEMIDItems on a Work Flow
WORKFLOWTEMPLATESWFTEMPIDWorkflow Setups are kept here