ALEX_INVOICE_PAYMENT (Attributes)

Column Source Data type Null Description
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