AP Automation

Tables (14)

department

  • id — SERIAL
  • coupa_name — VARCHAR — NOT NULL
  • created_at — TIMESTAMP

invoice

  • id — SERIAL
  • coupa_invoice_id — VARCHAR
  • invoice_number — VARCHAR
  • invoice_date — DATE
  • gross_total — NUMERIC(18,2)
  • supplier_total — NUMERIC(18,2)
  • authorization_code — VARCHAR
  • payment_term_code — VARCHAR
  • status — VARCHAR
  • updated_at_coupa — TIMESTAMP
  • supplier_id — INTEGER
  • requester_id — INTEGER
  • department_id — INTEGER
  • created_at — TIMESTAMP
  • raw_json — JSONB

invoice_line

  • id — SERIAL
  • invoice_id — INTEGER — NOT NULL
  • line_number — INTEGER
  • description — TEXT
  • quantity — NUMERIC(18,4)
  • unit_price — NUMERIC(18,4)
  • line_total — NUMERIC(18,2)
  • account_code — VARCHAR
  • account_name — VARCHAR
  • account_type — VARCHAR
  • vat_code — VARCHAR
  • vat_percentage — NUMERIC(5,2)
  • vat_description — VARCHAR
  • vat_amount — NUMERIC(18,2)
  • created_at — TIMESTAMP

invoice_ocr_link

  • id — SERIAL
  • invoice_id — INTEGER — NOT NULL
  • ocr_document_id — INTEGER — NOT NULL
  • link_reason — VARCHAR
  • created_at — TIMESTAMP

invoice_po_link

  • id — SERIAL
  • invoice_line_id — INTEGER — NOT NULL
  • po_line_id — INTEGER — NOT NULL
  • link_type — VARCHAR
  • created_at — TIMESTAMP

ocr_document

  • id — SERIAL
  • doc_type — ocr_doc_type — NOT NULL
  • external_doc_id — VARCHAR
  • supplier_vat_number — VARCHAR
  • buyer_vat_number — VARCHAR
  • invoice_number — VARCHAR
  • approval_number — VARCHAR
  • invoice_date — DATE
  • total_amount — NUMERIC(18,2)
  • vat_amount — NUMERIC(18,2)
  • vat_code — VARCHAR
  • created_at — TIMESTAMP
  • raw_json — JSONB

ocr_document_line

  • id — SERIAL
  • ocr_document_id — INTEGER — NOT NULL
  • line_number — INTEGER
  • description — TEXT
  • quantity — NUMERIC(18,4)
  • unit_price — NUMERIC(18,4)
  • amount — NUMERIC(18,2)
  • vat_amount — NUMERIC(18,2)
  • vat_code — VARCHAR

po

  • id — SERIAL
  • coupa_po_id — VARCHAR
  • po_number — VARCHAR
  • supplier_id — INTEGER
  • order_total — NUMERIC(18,2)
  • ordered_amount — NUMERIC(18,2)
  • received_amount — NUMERIC(18,2)
  • created_at — TIMESTAMP
  • raw_json — JSONB

po_line

  • id — SERIAL
  • po_id — INTEGER — NOT NULL
  • line_number — INTEGER
  • description — TEXT
  • quantity_ordered — NUMERIC(18,4)
  • quantity_received — NUMERIC(18,4)
  • unit_price — NUMERIC(18,4)
  • ordered_amount — NUMERIC(18,2)
  • received_amount — NUMERIC(18,2)
  • vat_code — VARCHAR
  • vat_percentage — NUMERIC(5,2)
  • vat_description — VARCHAR
  • vat_amount — NUMERIC(18,2)
  • created_at — TIMESTAMP

reconciliation_field_detail

  • id — SERIAL
  • result_id — INTEGER — NOT NULL
  • entity_type — VARCHAR — NOT NULL
  • field_name — VARCHAR — NOT NULL
  • expected_value — TEXT
  • actual_value — TEXT
  • status — field_match_status — NOT NULL
  • diff_value — TEXT

reconciliation_job

  • id — SERIAL
  • run_at — TIMESTAMP — NOT NULL
  • status — VARCHAR — NOT NULL
  • invoices_processed — INTEGER
  • error_message — TEXT
  • created_at — TIMESTAMP

reconciliation_result

  • id — SERIAL
  • job_id — INTEGER — NOT NULL
  • invoice_id — INTEGER — NOT NULL
  • header_status — match_status
  • line_status — line_match_status
  • po_status — po_match_status
  • tax_status — tax_match_status
  • giro_status — giro_match_status
  • score — NUMERIC(5,2)
  • summary — TEXT
  • created_at — TIMESTAMP

requester

  • id — SERIAL
  • coupa_user_id — VARCHAR
  • fullname — VARCHAR — NOT NULL
  • department_id — INTEGER
  • created_at — TIMESTAMP

supplier

  • id — SERIAL
  • coupa_supplier_id — VARCHAR
  • number — VARCHAR
  • display_name — VARCHAR
  • vat_number — VARCHAR
  • created_at — TIMESTAMP