CASH

Table: Locations
Locations ColumnTypeNotes Code TEXT CompanyNumber WHOLE NUMBER Name TEXT LastEditDate DATETIME Deleted BINARY
Wed, 8 Jun, 2022 at 3:57 PM
Table: LUDeliveryStatus
LUDeliveryStatus ColumnTypeNotes Code TEXT Description TEXT
Wed, 8 Jun, 2022 at 3:57 PM
Table: LUOrderStatus
LUOrderStatus ColumnTypeNotes Code TEXT Description TEXT
Wed, 8 Jun, 2022 at 3:57 PM
Table: LUStockAuditTransactionTypes
LUStockAuditTransactionTypes ColumnTypeNotes Code TEXT TransactionDescription TEXT
Wed, 8 Jun, 2022 at 3:57 PM
Table: LUSupplierAccountStatus
LUSupplierAccountStatus ColumnTypeNotes Code TEXT Description TEXT
Wed, 8 Jun, 2022 at 3:57 PM
Table: NominalCodes
NominalCodes ColumnTypeNotes CodeType TEXT Code TEXT DebitOrCredit TEXT Description TEXT ProfLossOrBalSheet TEXT Deleted BINAR...
Wed, 8 Jun, 2022 at 3:57 PM
Table: PostcodeRegions
PostcodeRegions ColumnTypeNotes Area TEXT Region TEXT
Wed, 8 Jun, 2022 at 3:59 PM
Table: Products
Products - main products table ColumnTypeNotes CodeProductOrCharge TEXT Tugger created column combining: Code, ProductOrCharge Code TEXT Descrip...
Wed, 8 Jun, 2022 at 3:59 PM
Table: PurchaseInvoiceHeaders
PurchaseInvoiceHeaders - Main table for purchase invoices ColumnTypeNotes Authorised_YN TEXT CompanyNumberPurchaseInvoiceNumber TEXT Tugger create...
Wed, 8 Jun, 2022 at 3:59 PM
Table: PurchaseOrderHeaders
PurchaseOrderHeaders - main table giving an overview of purchase orders ColumnTypeNotes AnalysisCode3 TEXT CallActionNumber WHOLE NUMBER CallN...
Wed, 8 Jun, 2022 at 3:59 PM