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