how to create credit card information via interface table
Dears,
I need to create credit card information via interface table.
I can't find the credit card information after the Customer Interface complete . but the interface data has been processed.
My import CC information SQL as below:
INSERT INTO ra_customer_banks_int_all
( created_by,
creation_date,
last_update_date,
last_updated_by,
orig_system_customer_ref,
orig_system_address_ref,
primary_flag,
start_date,
org_id,
BANK_HOME_COUNTRY,
BANK_ACCOUNT_NUM,
BANK_ACCOUNT_CURRENCY_CODE,
BANK_NAME,
BANK_BRANCH_NAME,
Bank_branch_country,
BANK_ACCOUNT_NAME,
BANK_ACCOUNT_INACTIVE_DATE,
bank_number,
bank_num)
VALUES
( 6685, --created_by