ALER_EXPENSE_EXTERNAL_DATA (Attributes)

Column Source Data type Null Description
EXPORT_ER_HDR_ID N/A INT N Bob id for row. A unique number that serves as the primary key for the row.
ER_PAID_ON DATETIME Y
ER_AMT_PAID NUMERIC(20) Y
ER_PAYMENT_NUMBER VARCHAR(255) Y
CORP_CHARGE_DATE DATETIME Y
CORP_CHARGE_AMT_PAID NUMERIC(20) Y
UPDATE_STATUS INT Y NULL = new record ready to import 2 = successfully imported 3 = non-recoverable error during import 6 = recoverable error during import