FND Design Data [Home] [Help]

Table: AR_LOCKBOXES_ALL

Product: AR - Receivables
Description: Lockbox details used by the AutoLockbox program
Implementation/DBA Data: TableAR.AR_LOCKBOXES_ALL
Primary Key: AR_LOCKBOXES_PK
  1. ColumnLOCKBOX_ID
Primary Key: AR_LOCKBOXES_UK1
  1. ColumnLOCKBOX_NUMBER
  2. ColumnBANK_ORIGINATION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_LOCKBOXES_ALL FK Joins to TableAR_BATCH_SOURCES_ALL AR_LOCKBOXES_ALL.BATCH_SOURCE_ID
AR_LOCKBOXES_ALL FK Joins to TableAR_RECEIPT_METHODS AR_LOCKBOXES_ALL.RECEIPT_METHOD_ID
TableAR_BATCHES_ALL FK Joins to AR_LOCKBOXES_ALL AR_BATCHES_ALL.LOCKBOX_ID
TableAR_TRANSMISSIONS_ALL FK Joins to AR_LOCKBOXES_ALL AR_TRANSMISSIONS_ALL.REQUESTED_LOCKBOX_ID