iExpense - Mastercard CDF3 Mapping
Hello
I'm trying to understand how Oracle maps the columns from the CDF3 file we receive from Mastercard and loads them into AP_CREDIT_CARD_TRXNS_ALL.
Reason I ask is, within the file we receive, there is no Billing_date. However that column gets populated once we run the Mastercard CDF3 Loader program. So, how does this happen ?
Also, has anyone used Mastercard for their transactions ? If so, what date range do they normally send their transaction file ? Is it based on BILLING_DATE, TRANSACTION_DATE or POSTED_DATE ?
Reason I ask is Oracle's CC programs uses the Billing_date as their parameters.