Mandatory Columns in the Customer Interface Tables

 Mandatory Columns in the 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