| export_invoice_hdr_id
|
alex_invoice_export_header - export_invoice_hdr_id
|
INT
|
N
|
A primary key and also foreign key.
|
| paid_amount
|
alpr_invoice - paid_amount
|
numeric(20,10)
|
Y
|
The amount paid to the vendor
|
| paid_date
|
alpr_invoice - paid_date
|
Datetime
|
Y
|
The time and date the vendor is paid
|
| payment_number
|
alpr_invoice - payment_number
|
varchar(255)
|
Y
|
The description of the payment, and a check number
|
| VOUCHER_NUMBER
|
alex_invoice_export_header
|
varchar(255)
|
Y
|
The voucher number of the invoice payment.
|
| UPDATE_STATUS
|
|
INT
|
Y
|
NULL = new record ready to import 2 = successfully imported
3 = non-recoverable error during import 6 = recoverable error during import
|