CASH
PurchaseOrderLineAnalysis ColumnTypeNotes Amount DECIMAL NUMBER CompanyNumber WHOLE NUMBER Department TEXT LineKey TEXT NominalCod...
Wed, 8 Jun, 2022 at 3:59 PM
SalesEnquires - Main table for all sales enquires ColumnTypeNotes Area TEXT AssignedDate DATETIME Branch TEXT CallNumber WHOLE NUMBER ...
Wed, 8 Jun, 2022 at 3:59 PM
SalesEnquiryHistoricalData ColumnTypeNotes CreatedDate DATETIME EnquiryNo WHOLE NUMBER EnteredDate DATETIME ExpectedOrderDate DATETIME ...
Wed, 8 Jun, 2022 at 3:59 PM
SalesEnquiryStatus - Lookup table for decoding the status in the SalesEnquires table. ColumnTypeNotes EnquiryStatusCode TEXT EnquiryStatus TEXT...
Wed, 8 Jun, 2022 at 3:59 PM
SalesEnquiryValues - Values which relate to a sales enquiry eg hours, cost, margins etc. Chaild table of SalesEnquires table ColumnTypeNotes EnquiryNo ...
Wed, 8 Jun, 2022 at 4:00 PM
SiteCharges - Regular charges for each maintatined system at each customers site ColumnTypeNotes ContractExpiryDate DATETIME Description TEXT I...
Wed, 8 Jun, 2022 at 4:00 PM
Sites - Details of each customers sites ColumnTypeNotes Area TEXT Branch TEXT CustomerNo TEXT EngineeringArea TEXT Latitude DECIMAL...
Wed, 8 Jun, 2022 at 4:00 PM
SiteSystems - Systems maintained at each customers site ColumnTypeNotes CancellationDate DATETIME CancellationReason TEXT CompanyNumber WHO...
Wed, 8 Jun, 2022 at 4:00 PM
StockAtLocations - Product stock levels at each location ColumnTypeNotes LocationCode TEXT MaximumStockQuantity DECIMAL NUMBER MinimumStockQuan...
Wed, 8 Jun, 2022 at 4:00 PM
StockAuditTrails - Audit trail of stock movements i.e. added, removed ColumnTypeNotes AuditNo WHOLE NUMBER CallNo WHOLE NUMBER IssueRef TEXT ...
Wed, 8 Jun, 2022 at 4:00 PM