Mandatory Columns In Customer Interface Tables

Q. Tell me some mandatory columns in the customer interface tables? 

Ans.  a) Ra_customers_interface_all

          1) Orig_system_customer_ref

          2) insert_update_flag

          3) customer_number 

          4) customer_status

                  5)last_updated_by     

                  6) last_updated_date 

                  7)created_by              

                  8) creation_date.       

         b) Ra_customer_profile_int_all

                    1) customer_profile_class_name

         c) Ra_contact_phones_int_all

                    1)orig_system_telephone_ref

                    2)telephone

                    3) telephone_type

         d) Ra_customer_banks_int_all

                    1) bank_a/c_name     

                    2)bank_a/c_no  

                    3)bank_a/c_currency_code

         e) Ra_cust_paymethod_int_all

                     1) payment_method_name

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. Interface Tables In customer interface
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?