| external_key** |
VARCHAR (255) |
Yes* |
No |
aler_expense_report.exp_rep_data_id |
The external key -- Primary Key |
| user_ekey |
VARCHAR(255) |
Yes* |
No |
aler_expense_report.user_id |
The user the entry belongs to |
| import_status |
SMALLINT |
Yes |
Yes |
|
The import command/status (0=dont import, 1=do import, 2=success, 100+=re-process, -1=failed) |
| import_error_message |
VARCHAR(255) |
No |
No |
|
The import error message |
| import_change_ timestamp |
DATETIME |
No |
No |
|
The import timestamp |
| submit_status |
SMALLINT |
Yes |
Yes |
|
The auto-submit command/status (0=dont submit, 1=do submit, 2=success, -1=failed) |
| submit_error_message |
VARCHAR(255) |
No |
No |
|
The submit error message |
| submit_change_ _timestamp |
DATETIME |
No |
No |
|
The submit timestamp |
| er_paid_on |
DATETIME |
No |
No |
aler_expense_report.er_paid_on |
The date the ER was paid |
| er_amt_paid |
NUMERIC(28,10) |
No |
No |
aler_expense_report.er_amt_paid |
The amount that was paid |
| er_amt_paid_id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.er_amt_paid_id |
Currency of the amount that was paid |
| er_payment_number |
VARCHAR(255) |
No |
No |
aler_expense_report.er_payment_number |
Usually a check number |
| exp_rep_title |
VARCHAR(255) |
No |
No |
aler_expense_report.exp_rep_title |
The title of the ER |
| purpose_id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.purpose_id |
Purpose |
| corp_charge_date |
DATETIME |
No |
No |
aler_expense_report.corp_charge_date |
Document element |
| corp_charge _amt_paid_id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.corp_charge_amt_paid_id |
Document element |
| corp_charge_amt_paid |
NUMERIC(28,10) |
No |
No |
aler_expense_report.corp_charge_amt_paid |
Document element |
| create_location_ id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.create_location_id |
Location where the expense report is created. |
| flex_field_string_1 |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_string_1 |
Flex field in string |
| flex_field_string_2 |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_string_2 |
Flex field in string |
| flex_field_string_3 |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_string_3 |
Flex field in string |
| flex_field_string_4 |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_string_4 |
Flex field in string |
| flex_field_integer_1 |
INTEGER |
No |
No |
aler_expense_report.flex_field_integer_1 |
Flex field in integer |
| flex_field_integer_2 |
INTEGER |
No |
No |
aler_expense_report.flex_field_integer_2 |
Flex field in integer |
| flex_field_date_1 |
DATETIME |
No |
No |
aler_expense_report.flex_field_date_1 |
Flex field in date |
| flex_field_date_2 |
DATETIME |
No |
No |
aler_expense_report.flex_field_date_2 |
Flex field in date |
| flex_field_amount_1 |
NUMERIC(28,10) |
No |
No |
aler_expense_report.flex_field_amount_1 |
Flex field for amount |
| flex_field_amount_1 _id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_amount_id |
Current for flex field amount |
| flex_field_amount_2 |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_amount_2 |
Flex field for amount |
| flex_field_amount_1 _id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_amount_1_id |
Currency for flex field amount |
| flex_field_location _1_id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_location_1_id |
Flex field location |
| flex_field_ddlb_1 _id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_ddlb _1_id |
Flex field for DDLB |
| flex_field_ddlb _2_id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_ddlb _2_id |
Flex field for DDLB |
| flex_field_ddlb _3_id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_ddlb _3_id |
Flex field for DDLB |
| flex_field_ddlb _4_id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_ddlb _4_id |
Flex field for DDLB |
| flex_field_ddlb_5 _id_ekey |
VARCHAR(255) |
No |
No |
aler_expense_report.flex_field_ddlb _5_id |
Flex field for DDLB |
| keyword_note |
TEXT |
No |
No |
|
The documents note |