Interface Tables In customer interface

Q.      What are the interface tables in the customer interface tables?

1)     Ra_customers_interface_all

               This table stores customer, address, and business purpose information. You do not have to enter values in this table if you do not want to import customers, addresses, or business purposes.

ADDRESS1 through 4

                       Enter the address for your customer in these four columns. You can enter up to four lines of an address.

Validation:  

      If you enter a value in ORIG_SYSTEM_ADDRESS_REF, you must enter a value in ADDRESS1. For multiple rows with the same address reference, insert values in address 1–4.

  Destination:                      HZ_LOCATIONS.ADDRESS1,

                                             HZ_LOCATIONS.ADDRESS2,

                                             HZ_LOCATIONS.ADDRESS3,

                                             HZ_LOCATIONS.ADDRESS4

           2) Ra_customer_profile_int_all

A customer level profile must exist in A_CUSTOMER_PROFILES_INTERFACE for new customers and each bill–to business purpose.

           3) Ra_contact_phones_int_all

This table stores telephone numbers for customers, addresses and contacts as well as contacts for customers and addresses.

           4) Ra_customer_banks_int_all

This table stores bank information for a customer or for a specific Bill–To address, you must enter a bank account for this customer,

            5) Ra_cust_paymethod_int_all

To import payment methods for customers and bill–to business purposes.

Other Articles Related To Customer Interface:

1. API’s FOR CUSTOMER INTERFACE?
2. How to send additional customer and address information through customer interafce
3. Important Fields That Customer Interface Does Not Load
4. Mandatory Columns In Customer Interface Tables
5. Staging Tables In The Customer Interface
6. Tables Which Cannot Be Updated Through Customer Interface
7. Validations In The Customer Interface
8. Why does customer interface error out if there is mismatch in address information?