FND Design Data [Home] [Help]

Table: IBY_BATCHES_ALL

Product: IBY - Payments
Description: "This table contains records of the settlement batch information which is updated by system while processing 'Create settlement Batches' program.IBY_BATCHES_ALL stores information about batch operations for credit cards and bank account tra
Implementation/DBA Data: TableIBY.IBY_BATCHES_ALL
Primary Key: IBY_BATCHES_ALL_PK
  1. ColumnMBATCHID
Primary Key: IBY_BATCH_PREQ_BATCH_PAYEE_UK
  1. ColumnBATCHID
  2. ColumnPAYEEID
Foreign Keys
Table
Foreign Table Foreign Key Column
IBY_BATCHES_ALL FK Joins to TableIBY_BEPINFO IBY_BATCHES_ALL.BEPID
IBY_BATCHES_ALL FK Joins to TableIBY_PAYEE IBY_BATCHES_ALL.MPAYEEID
TableIBY_PAY_BATCHES_ALL FK Joins to IBY_BATCHES_ALL IBY_PAY_BATCHES_ALL.IBY_BATCH_ID
IBY_PAY_BATCHES_ALL.PAYER_ID
TableIBY_TRXN_SUMMARIES_ALL FK Joins to IBY_BATCHES_ALL IBY_TRXN_SUMMARIES_ALL.MBATCHID