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
|