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

No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...