Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Retail Training Forum
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

0
Hi,
What are the tables which hold the data for internal and external banks, branches and bank accounts?
Thank you,
Yamini H Ravindra
Responses (1)
  • Accepted Answer

    Wednesday, May 25 2016, 11:21 AM - #Permalink
    0
    The TCA party model is being used to model banks and bank branches as parties with the associated attributes of Relationships, Address, Contact and Locations. The TCA tables used by Cash Management for modeling Banks and Bank Branches are listed below:

    HZ_PARTIES - Bank, Bank Branch, Account attribute, Contact Person.
    HZ_RELATIONSHIPS - Storing Relationships
    HZ_RELATIONSHIP_TYPES - Storing Relationship Type
    HZ_ORG_CONTACTS - Stores the contact titles
    HZ_ORG_CONTACT_ROLES - Stores the contact purpose or role
    HZ_CONTACT_POINTS - Contact detail and contact point
    HZ_PARTY_SITES - Stores Party Site
    HZ_LOCATIONS - Stores Address
    HZ_ORGANIZATION_PROFILES - Store additional attributes of banks and bank branches

    Cash Management Tables -

    CE_BANK_ACCOUNT - Stores Bank account attribute
    CE_BANK_ACCOUNT_USES_ALL- Stores the bank account attributes specific to OU and LE
    CE_GL_ACCOUNTS_CCID - The accounting data pertaining to the bank account use will be stored
    in the table.

    External bank Account Informations -

    IBY_EXT_BANK_ACCOUNTS - This table contains records of the external bank accounts.
    This table corresponds to the Banking details page of supplier or
    customer.
    IBY_PMT_INSTR_USES_ALL - This table contains records of the relationship between payment
    instruments and Payer/Payee

    IBY_EXTERNAL_PAYERS_ALL - This table contains payment details of an external payer.
    For example when customer or customer site is created manually,
    system automatically insert row in to the IBY_EXTERNAL_PAYERS_ALL
    table.
    IBY_EXTERNAL_PAYEES_ALL - This table contains payment details of an external payee.

    Thanks,
    Ashish
    Attachments:
    The reply is currently minimized Show
Your Reply

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    1  2  3  4  5
  6  7  8  9101112
13141516171819
20212223242526
2728293031  

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner