FND Design Data [Home] [Help]

Table: AR_INTERIM_CASH_RECEIPTS_ALL

Product: AR - Receivables
Description: QuickCash payments processed by the PostBatch program
Implementation/DBA Data: TableAR.AR_INTERIM_CASH_RECEIPTS_ALL
Primary Key: AR_INTERIM_CASH_RECEIPTS_PK
  1. ColumnCASH_RECEIPT_ID
Primary Key: AR_INTERIM_CASH_RECEIPTS_UK1
  1. ColumnRECEIPT_NUMBER
  2. ColumnBATCH_ID
  3. ColumnCUSTOMER_TRX_ID
Primary Key: AR_INTERIM_CASH_RECEIPTS_UK2
  1. ColumnPAY_FROM_CUSTOMER
  2. ColumnRECEIPT_NUMBER
  3. ColumnAMOUNT
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableAR_BATCHES_ALL AR_INTERIM_CASH_RECEIPTS_ALL.BATCH_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableIBY_EXT_BANK_ACCOUNTS AR_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_BANK_ACCOUNT_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableFND_DOCUMENT_SEQUENCES AR_INTERIM_CASH_RECEIPTS_ALL.DOC_SEQUENCE_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL AR_INTERIM_CASH_RECEIPTS_ALL.SITE_USE_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL AR_INTERIM_CASH_RECEIPTS_ALL.OLD_REMIT_BANK_ACCOUNT_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableAP_BANK_BRANCHES AR_INTERIM_CASH_RECEIPTS_ALL.OLD_CUSTOMER_BANK_BRANCH_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableHZ_CUST_ACCOUNTS AR_INTERIM_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableAR_PAYMENT_SCHEDULES_ALL AR_INTERIM_CASH_RECEIPTS_ALL.PAYMENT_SCHEDULE_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL AR_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_TRX_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableFND_CURRENCIES AR_INTERIM_CASH_RECEIPTS_ALL.CURRENCY_CODE
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableAR_RECEIPT_METHODS AR_INTERIM_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID
AR_INTERIM_CASH_RECEIPTS_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL AR_INTERIM_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID
TableAR_INTERIM_CASH_RCPT_LINES_ALL FK Joins to AR_INTERIM_CASH_RECEIPTS_ALL AR_INTERIM_CASH_RCPT_LINES_ALL.CASH_RECEIPT_ID