Column name Data type Required Default update table Data target Comments
external_key** VARCHAR (255) Yes* No alpr_invoice.invoice_id The external key -- Primary Key
user_ekey VARCHAR(255) Yes* No The user the entry belongs to
import_status SMALLINT Yes Yes The import command/status (0=dont import, 1=do import, 2=success, 100+=re-process, -1=failed)
import_error _message VARCHAR(255) No No The import error message
import_change _timestamp DATETIME No No The import timestamp
submit_status SMALLINT Yes Yes The auto-submit command/status (0=dont submit, 1=do submit, 2=success, -1=failed)
submit_error_ message VARCHAR(255) No No The submit error message
submit_change _timestamp DATETIME No No The submit timestamp
title VARCHAR(255) No No alpr_invoice.title document element
invoice_ number VARCHAR(255) No No alpr_invoice.invoice_number document element
invoice_date DATETIME No No alpr_invoice.invoice_date document element
total_amount NUMERIC(28,10) No No alpr_invoice.total_amount document element
total_amount _id_ekey VARCHAR(255) No No alpr_invoice.total_amount_id document element
paid_date DATETIME No No alpr_invoice.paid_date document element
paid_amount NUMERIC(28,10) No No alpr_invoice.paid_amount document element
payment_ number VARCHAR(255) No No alpr_invoice.payment_number document element
pr_vendor_id _ekey VARCHAR(255) No No alpr_invoice.pr_vendor_id document element
send_to_id SMALLINT Yes No alpr_invoice.send_to_id document element
pr_purpose_ id_ekey VARCHAR(255) No No alpr_invoice.pr_purpose_id document element
requested_ payment_date DATETIME No No alpr_invoice.requested_payment_date document element
voucher_ number VARCHAR(255) No No alpr_invoice.voucher_number document element
special_ handling VARCHAR(255) No No alpr_invoice.special_handling document element
keyword_note TEXT No No The documents note