FND Design Data [Home] [Help]

Table: PAY_JP_BANK_BRANCHES

Product: PAY - Payroll
Description: This table is used for Japanese bank branch information.
Implementation/DBA Data: TableHR.PAY_JP_BANK_BRANCHES
Primary Key: PAY_JP_BANK_BRANCHES_PK
  1. ColumnBANK_CODE
  2. ColumnBRANCH_CODE
Primary Key: PAY_JP_BANK_BRANCHES_U1
  1. ColumnBANK_CODE
  2. ColumnBRANCH_NAME
Primary Key: PAY_JP_BANK_BRANCHES_U2
  1. ColumnBANK_CODE
  2. ColumnBRANCH_NAME_KANA
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_JP_BANK_BRANCHES FK Joins to TablePAY_JP_BANKS PAY_JP_BANK_BRANCHES.BANK_CODE