| 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 |