ALEX_IMPORT_ER_DOCUMENT (Staging Table)

Column name Data type Required Default update table Data target Comments
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