CREATE TABLE EX_AMEX_DAILY_ACTIVITY_FILE (

    message_type_identifier VARCHAR(4),

    message_number VARCHAR(8),

    transaction_status VARCHAR(2),

    participant_role_type VARCHAR(2),

    sending_processor_institution_identifier VARCHAR(11),

    sending_processor_organization_identifier VARCHAR(11),

    sending_institution_identifier VARCHAR(11),

    sending_organization_identifier VARCHAR(11),

    receiving_processor_institution_identifier VARCHAR(11),

    receiving_processor_organization_identifier VARCHAR(11),

    receiving_institution_identifier VARCHAR(11),

    receiving_organization_identifier VARCHAR(11),

    file_tracking_identifier VARCHAR(24),

    duplicate_message_number VARCHAR(8),

    message_transaction_sequence_number VARCHAR(3),

    transaction_identifier VARCHAR(15),

    duplicate_message_type_identifier VARCHAR(4),

    function_code VARCHAR(3),

    processing_code VARCHAR(6),

    transaction_date TIMESTAMP,

    transaction_time TIMESTAMP,

    network_processing_date TIMESTAMP,

    network_processing_time TIMESTAMP,

    transaction_amount DECIMAL(18, 2),

    transaction_currency_code VARCHAR(3),

    transaction_decimalization VARCHAR(1),

    primary_account_number_length VARCHAR(2),

    primary_account_number VARCHAR(19),

    merchant_category_code VARCHAR(4),

    acquirer_reference_number VARCHAR(23),

    first_presentment_presentment_amount DECIMAL(18, 2),

    first_presentment_presentment_currency_code VARCHAR(3),

    first_presentment_presentment_decimalization VARCHAR(1),

    net_settlement_amount DECIMAL(18, 2),

    settlement_currency_code VARCHAR(3),

    settlement_decimalization VARCHAR(1),

    gross_settlement_amount DECIMAL(18, 2),

    local_or_foreign VARCHAR(1),

    issuers_network_rate_amount DECIMAL(18, 2),

    issuers_network_rate DECIMAL(10, 8),

    reserved_field VARCHAR(15),

    settlement_calculation_date TIMESTAMP,

    message_reason_code VARCHAR(4),

    format_code VARCHAR(2),

    point_of_service_data_code VARCHAR(12),

    card_acceptor_terminal_identification VARCHAR(8),

    card_acceptor_identification_code VARCHAR(15),

    card_acceptor_country_code VARCHAR(3),

    first_presentment_transaction_to_presentment_conversion_rate DECIMAL(18, 8),

    icc_chip_pin_indicator VARCHAR(2),

    report_category_code VARCHAR(3),

    extended_payment_data VARCHAR(2),

    alternate_card_acceptor_identification_code_length VARCHAR(2),

    alternate_card_acceptor_identification_code VARCHAR(15),

    anticipated_transaction_settlement_date TIMESTAMP,

    filler VARCHAR(147)

);

​