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