Dashboard

📅 Year to Date

All Transactions

Loading…

All Transactions

Loading…

Categories

    Suppliers

      Period
      Month
      Card
      Supplier
      Category

      Spend by Category

      Repairs — Spend Breakdown

      Breakdown

      Database Structure

      Budget Dashboard — Database Structure Database Structure — data.json categories 🔑 id integer name string budget number|null e.g. "Repairs All Vessels" budget: 6600 (or null) suppliers 🔑 id integer name string 117 suppliers in DB transactions 🔑 idinteger 🔗 category_idinteger input_dateYYYY-MM-DD invoice_dateYYYY-MM-DD po_numberstring (QG…) supplierstring card"arek"|"eddy"|"" descriptionstring amountAUD float invoice_filepath|null invoice_originalfilename|null 6,894 records in DB uploads/ SupplierName/ timestamp_file.pdf timestamp_file.docx counters nextIdinteger nextCatIdinteger nextSupplierId 1 N name ref invoice_file Foreign key Name reference (soft) File path reference Filesystem

      User Management

      New User

      EmailNameRole
      Loading…

      Change Password

      Marine Ops Budget