| 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 |
| ALEX_INVOICE_PAYMENT_ID |
|
Int |
N |
Primary key and also an identity column |