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 |