CTE_D_FIN_I_ENTR

Transparent Table Application Table

SubVal Importing table - Entry

CTE_D_FIN_I_ENTR is an SAP database table in S/4HANA. SubVal Importing table - Entry. It contains 134 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CTE_FIN_SUBS_IMPORTING_ENTRY view from Importing structure - Entry

Fields (134)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
entry_id CTE_CONCUR_FIELD_VALUE Concur Field Value
legacy_entry_id CTE_CONCUR_FIELD_VALUE Concur Field Value
expense_type_name CTE_CONCUR_FIELD_VALUE Concur Field Value
expense_type_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_date CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_currency_code CTE_CONCUR_FIELD_VALUE Concur Field Value
exchange_rate CTE_CONCUR_FIELD_VALUE Concur Field Value
exchange_rate_direction CTE_CONCUR_FIELD_VALUE Concur Field Value
is_personal CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_description CTE_CONCUR_FIELD_VALUE Concur Field Value
vendor_code CTE_CONCUR_FIELD_VALUE Concur Field Value
vendor_description CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_receipt_type CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit1_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit1_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit2_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit2_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit3_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit3_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit4_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit4_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit5_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit5_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit6_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_org_unit6_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom1_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom1_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom2_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom2_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom3_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom3_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom4_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom4_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom5_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom5_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom6_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom6_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom7_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom7_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom8_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom8_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom9_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom9_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom10_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom10_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom11_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom11_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom12_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom12_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom13_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom13_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom14_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom14_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom15_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom15_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom16_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom16_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom17_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom17_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom18_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom18_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom19_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom19_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom20_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom20_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom21_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom21_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom22_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom22_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom23_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom23_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom24_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom24_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom25_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom25_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom26_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom26_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom27_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom27_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom28_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom28_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom29_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom29_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom30_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom30_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom31_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom31_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom32_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom32_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom33_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom33_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom34_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom34_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom35_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom35_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom36_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom36_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom37_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom37_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom38_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom38_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom39_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom39_value CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom40_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_custom40_value CTE_CONCUR_FIELD_VALUE Concur Field Value
approved_amount CTE_CONCUR_FIELD_VALUE Concur Field Value
clearing_account_code CTE_CONCUR_FIELD_VALUE Concur Field Value
expense_pay_indicator CTE_CONCUR_FIELD_VALUE Concur Field Value
offset_pay_type CTE_CONCUR_FIELD_VALUE Concur Field Value
location_city_name CTE_CONCUR_FIELD_VALUE Concur Field Value
report_entry_transaction_amoun CTE_CONCUR_FIELD_VALUE Concur Field Value
is_billable CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_location_name CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_country_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_country_sub_code CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_uuid CTE_CONCUR_FIELD_VALUE Concur Field Value
supplier_tax_id CTE_CONCUR_FIELD_VALUE Concur Field Value
card_account_id CTE_CONCUR_FIELD_VALUE Concur Field Value
card_transaction_id CTE_CONCUR_FIELD_VALUE Concur Field Value
card_transaction_amount CTE_CONCUR_FIELD_VALUE Concur Field Value
card_transaction_currency CTE_CONCUR_FIELD_VALUE Concur Field Value
card_transaction_posted_amount CTE_CONCUR_FIELD_VALUE Concur Field Value
card_trans_posted_currency CTE_CONCUR_FIELD_VALUE Concur Field Value
card_billing_amount CTE_CONCUR_FIELD_VALUE Concur Field Value
card_program_type_code CTE_CONCUR_FIELD_VALUE Concur Field Value
card_statem_period_start_date CTE_CONCUR_FIELD_VALUE Concur Field Value
card_statem_period_end_date CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_electronic_receipt_id CTE_CONCUR_FIELD_VALUE Concur Field Value
entry_receipt_id CTE_CONCUR_FIELD_VALUE Concur Field Value
report_entry_pat_key CTE_CONCUR_FIELD_VALUE Concur Field Value
request_id CTE_CONCUR_FIELD_VALUE Concur Field Value
request_entry_id CTE_CONCUR_FIELD_VALUE Concur Field Value
card_billing_date CTE_CONCUR_FIELD_VALUE Concur Field Value

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- SubVal Importing table - Entry
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CTE_D_FIN_I_ENTR (
    CLIENT,                          -- Client [MANDT]
    ENTRY_ID,                        -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    LEGACY_ENTRY_ID,                 -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    EXPENSE_TYPE_NAME,               -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    EXPENSE_TYPE_CODE,               -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_DATE,                      -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CURRENCY_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    EXCHANGE_RATE,                   -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    EXCHANGE_RATE_DIRECTION,         -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    IS_PERSONAL,                     -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_DESCRIPTION,               -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    VENDOR_CODE,                     -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    VENDOR_DESCRIPTION,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_RECEIPT_TYPE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT1_CODE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT1_VALUE,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT2_CODE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT2_VALUE,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT3_CODE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT3_VALUE,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT4_CODE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT4_VALUE,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT5_CODE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT5_VALUE,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT6_CODE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ORG_UNIT6_VALUE,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM1_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM1_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM2_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM2_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM3_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM3_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM4_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM4_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM5_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM5_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM6_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM6_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM7_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM7_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM8_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM8_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM9_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM9_VALUE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM10_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM10_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM11_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM11_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM12_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM12_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM13_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM13_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM14_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM14_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM15_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM15_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM16_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM16_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM17_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM17_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM18_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM18_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM19_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM19_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM20_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM20_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM21_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM21_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM22_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM22_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM23_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM23_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM24_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM24_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM25_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM25_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM26_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM26_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM27_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM27_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM28_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM28_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM29_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM29_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM30_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM30_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM31_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM31_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM32_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM32_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM33_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM33_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM34_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM34_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM35_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM35_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM36_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM36_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM37_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM37_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM38_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM38_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM39_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM39_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM40_CODE,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_CUSTOM40_VALUE,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    APPROVED_AMOUNT,                 -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CLEARING_ACCOUNT_CODE,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    EXPENSE_PAY_INDICATOR,           -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    OFFSET_PAY_TYPE,                 -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    LOCATION_CITY_NAME,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    REPORT_ENTRY_TRANSACTION_AMOUN,  -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    IS_BILLABLE,                     -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_LOCATION_NAME,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_COUNTRY_CODE,              -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_COUNTRY_SUB_CODE,          -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_UUID,                      -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    SUPPLIER_TAX_ID,                 -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_ACCOUNT_ID,                 -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_TRANSACTION_ID,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_TRANSACTION_AMOUNT,         -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_TRANSACTION_CURRENCY,       -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_TRANSACTION_POSTED_AMOUNT,  -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_TRANS_POSTED_CURRENCY,      -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_BILLING_AMOUNT,             -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_PROGRAM_TYPE_CODE,          -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_STATEM_PERIOD_START_DATE,   -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_STATEM_PERIOD_END_DATE,     -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_ELECTRONIC_RECEIPT_ID,     -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    ENTRY_RECEIPT_ID,                -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    REPORT_ENTRY_PAT_KEY,            -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    REQUEST_ID,                      -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    REQUEST_ENTRY_ID,                -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    CARD_BILLING_DATE,               -- Concur Field Value [CTE_CONCUR_FIELD_VALUE]
    PRIMARY KEY (CLIENT)
);