Monday, June 28, 2010

Customer's Credit Card

Customer's credit cards are stored in table IBY_CREDITCARD.
Main columns of this table






Addressid Refers to party_site_use_id column of HZ_PARTY_SITE_USES table
Card_Owner_Id Refers to party_id column of HZ_PARTIES table
Card_Issuer_Code Refers to card_issuer_code of IBY_CREDITCARD_ISSUERS_B/TL tables



This information is applicable to Rel 12.1.2

Posted by Sanjai Misra at 11:55 AM
Labels:

4 comments:

  1. UnknownMonday, June 8, 2015 at 10:16:00 AM CDT

    Addess ID : Address identifier, FK to HZ_LOCATIONS table

    ReplyDelete
    Replies
    1. Sanjai MisraMonday, June 8, 2015 at 10:57:00 AM CDT

      In my test system, i created a new credit card. ADDRESSID is FK to HZ_PARTY_SITE_USES. i used this query to verify.

      select pty.party_name
      , psu.site_use_type
      , loc.address1
      , loc.city
      , loc.state
      , loc.postal_code
      from iby_creditcard cc
      , hz_parties pty
      , hz_party_site_uses psu
      , hz_party_sites ps
      , hz_locations loc
      where cc.chname = 'SANJAI MISRA NAME ON CARD'
      and cc.card_owner_id = pty.party_id
      and cc.addressid = psu.party_site_use_id
      and psu.party_site_id = ps.party_site_id
      and ps.location_id = loc.location_id
      ;

      Delete
  2. Ines GrunwaldThursday, January 9, 2020 at 1:53:00 AM CST

    Friend, this web site might be fabolous, i just like it. dlrcollectionagency.com

    ReplyDelete
  3. Stacey W. BurtFriday, January 28, 2022 at 3:28:00 AM CST

    I really enjoyed reading this post, big fan. Keep up the good work andplease tell me when can you publish more articles or where can I read more on the subject? Roblox USernames

    ReplyDelete

Subscribe to: Post Comments (Atom)