CARD_PROGRAM_ID in the AP_WEB_AMEX_PARAMS table - AP Setups. iExpense Setups.
Does anyone know how the CARD_PROGRAM_ID column gets populated in the AP_WEB_AMEX_PARAMS table to match the CARD_PROGRAM_ID from AP_CARD_PROGRAMS_ALL tables.
The CARD_PROGRAM_ID is assigned when you define a new Card Program (AP Setups -> Setups -> Credit Cards -> Card Programs).
When you Define the Data File Transfer Parameters: Global Card Programs, (AP i-Expense Setups -> Credit Card Programs -> Data File Transfers) this creates an entry into the AP_WEB_AMEX_PARAMS table. The CARD_PROGRAM_ID from this table should match to the CARD_PROGRAM_ID from the AP_CARD_PROGRAMS_ALL above.