1 Reply Latest reply on Jul 5, 2019 11:42 AM by 2837182

    receivables - customer tables

    user599292

      for release 12.1.3 - do you know which table/tables in the underlying database stores customer information, e.g. name, ID, address details, contact details etc. I am struggling to track it down.

        • 1. Re: receivables - customer tables
          2837182

          Hi,

           

          Below are the tables to get details of customers,

           

          SELECT HCA.CUST_ACCOUNT_ID,

                HCSUA.SITE_USE_ID,

                HZLB.ADDRESS1,

                HZLB.ADDRESS2,

                upper(HZLB.CITY) CITY,

                upper(HZLB.STATE) STATE,

                HZLB.POSTAL_CODE,

                HZLB.COUNTRY

              FROM RA_CUSTOMER_TRX_ALL RCTA,

                HZ_PARTIES HP,

                HZ_CUST_ACCOUNTS HCA,

                HZ_CUST_ACCT_SITES_ALL HCASA,

                HZ_CUST_SITE_USES_ALL HCSUA,

                HZ_PARTY_SITES HPS_BILL,

                HZ_LOCATIONS HZLB

              WHERE 1                     =1

              AND RCTA.BILL_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID

              AND HCA.PARTY_ID            = HP.PARTY_ID

              AND HCA.CUST_ACCOUNT_ID     = HCASA.CUST_ACCOUNT_ID

              AND HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_ID

              AND HCASA.PARTY_SITE_ID     = HPS_BILL.PARTY_SITE_ID

              AND HP.PARTY_ID             = HPS_BILL.PARTY_ID

              AND HPS_BILL.LOCATION_ID    = HZLB.LOCATION_ID

           

          Hope this helps...!

           

           

          Regards,

          Priya