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