FND Design Data [Home] [Help]

Table: RA_CUSTOMER_TRX_ALL

Product: AR - Receivables
Description: Header-level information about invoices, debit memos, chargebacks, commitments and credit memos
Implementation/DBA Data: TableAR.RA_CUSTOMER_TRX_ALL
Primary Key: RA_CUSTOMER_TRX_PK
  1. ColumnCUSTOMER_TRX_ID
Primary Key: RA_CUSTOMER_TRX_UK1
  1. ColumnBATCH_SOURCE_ID
  2. ColumnTRX_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_ADDRESSES_ALL RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableOKC_K_HEADERS_B RA_CUSTOMER_TRX_ALL.CONTRACT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.BILL_TO_CONTACT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNTS RA_CUSTOMER_TRX_ALL.BILL_TO_CUSTOMER_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNTS RA_CUSTOMER_TRX_ALL.SHIP_TO_CUSTOMER_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.SHIP_TO_SITE_USE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.SHIP_TO_CONTACT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_TERMS_B RA_CUSTOMER_TRX_ALL.TERM_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_SALESREPS_ALL RA_CUSTOMER_TRX_ALL.PRIMARY_SALESREP_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_CUST_TRX_TYPES_ALL RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_ALL.INITIAL_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableSO_AGREEMENTS_B RA_CUSTOMER_TRX_ALL.AGREEMENT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableFND_CURRENCIES RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE
RA_CUSTOMER_TRX_ALL FK Joins to TableAR_POSTING_CONTROL RA_CUSTOMER_TRX_ALL.POSTING_CONTROL_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL RA_CUSTOMER_TRX_ALL.CUSTOMER_BANK_ACCOUNT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableFND_DOCUMENT_SEQUENCES RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNTS RA_CUSTOMER_TRX_ALL.PAYING_CUSTOMER_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.PAYING_SITE_USE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I RA_CUSTOMER_TRX_ALL.SET_OF_BOOKS_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_TERRITORIES RA_CUSTOMER_TRX_ALL.TERRITORY_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableAR_RECEIPT_METHODS RA_CUSTOMER_TRX_ALL.RECEIPT_METHOD_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL RA_CUSTOMER_TRX_ALL.DRAWEE_BANK_ACCOUNT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL RA_CUSTOMER_TRX_ALL.REMITTANCE_BANK_ACCOUNT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableAR_BATCHES_ALL RA_CUSTOMER_TRX_ALL.REMITTANCE_BATCH_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableAR_BPA_TEMPLATES_B RA_CUSTOMER_TRX_ALL.BILL_TEMPLATE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL RA_CUSTOMER_TRX_ALL.BILL_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.DRAWEE_CONTACT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL RA_CUSTOMER_TRX_ALL.SHIP_TO_ADDRESS_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableCE_BANK_ACCT_USES_ALL RA_CUSTOMER_TRX_ALL.REMIT_BANK_ACCT_USE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableIBY_FNDCPT_TX_EXTENSIONS RA_CUSTOMER_TRX_ALL.PAYMENT_TRXN_EXTENSION_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableFND_APPLICATION RA_CUSTOMER_TRX_ALL.APPLICATION_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableAR_INTEREST_HEADERS_ALL RA_CUSTOMER_TRX_ALL.INTEREST_HEADER_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableRA_BATCH_SOURCES_ALL RA_CUSTOMER_TRX_ALL.BATCH_SOURCE_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNTS RA_CUSTOMER_TRX_ALL.SOLD_TO_CUSTOMER_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_ACCOUNT_ROLES RA_CUSTOMER_TRX_ALL.SOLD_TO_CONTACT_ID
RA_CUSTOMER_TRX_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL RA_CUSTOMER_TRX_ALL.SOLD_TO_SITE_USE_ID
TableAR_ADJUSTMENTS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_ADJUSTMENTS_ALL.SUBSEQUENT_TRX_ID
TableAR_ADJUSTMENTS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_ADJUSTMENTS_ALL.CUSTOMER_TRX_ID
TableAR_CC_ERROR_HISTORY FK Joins to RA_CUSTOMER_TRX_ALL AR_CC_ERROR_HISTORY.CC_TRX_ID
TableAR_CUSTOMER_CALL_TOPICS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_CUSTOMER_CALL_TOPICS_ALL.CUSTOMER_TRX_ID
TableAR_GTA_TRX_HEADERS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_GTA_TRX_HEADERS_ALL.RA_TRX_ID
TableAR_INTERIM_CASH_RECEIPTS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_TRX_ID
TableAR_INTERIM_CASH_RCPT_LINES_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_INTERIM_CASH_RCPT_LINES_ALL.CUSTOMER_TRX_ID
TableAR_MC_PAYMENT_SCHEDULES FK Joins to RA_CUSTOMER_TRX_ALL AR_MC_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID
TableAR_MC_TRANSACTION_HISTORY FK Joins to RA_CUSTOMER_TRX_ALL AR_MC_TRANSACTION_HISTORY.CUSTOMER_TRX_ID
TableAR_NOTES FK Joins to RA_CUSTOMER_TRX_ALL AR_NOTES.CUSTOMER_TRX_ID
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID
TableAR_RAMC_AUDIT_TRAIL FK Joins to RA_CUSTOMER_TRX_ALL AR_RAMC_AUDIT_TRAIL.CUSTOMER_TRX_ID
TableAR_RECEIVABLE_APPLICATIONS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.CUSTOMER_TRX_ID
TableAR_RECEIVABLE_APPLICATIONS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_ID
TableAR_RECEIVABLE_APPLICATIONS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.LINK_TO_CUSTOMER_TRX_ID
TableAR_RECEIVABLE_APPLICATIONS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.CHARGEBACK_CUSTOMER_TRX_ID
TableAR_REVENUE_ADJUSTMENTS_ALL FK Joins to RA_CUSTOMER_TRX_ALL AR_REVENUE_ADJUSTMENTS_ALL.CUSTOMER_TRX_ID
TableCN_NOT_TRX_ALL FK Joins to RA_CUSTOMER_TRX_ALL CN_NOT_TRX_ALL.SOURCE_TRX_ID
TableCN_TRX_ALL FK Joins to RA_CUSTOMER_TRX_ALL CN_TRX_ALL.SOURCE_TRX_ID
TableCST_MARGIN_TEMP FK Joins to RA_CUSTOMER_TRX_ALL CST_MARGIN_TEMP.CUSTOMER_TRX_ID
TableFV_INVOICE_FINANCE_CHRGS_ALL FK Joins to RA_CUSTOMER_TRX_ALL FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_TRX_ID
TableIGI_EXP_AR_TRANS_ALL FK Joins to RA_CUSTOMER_TRX_ALL IGI_EXP_AR_TRANS_ALL.CUSTOMER_TRX_ID
TableJAI_AR_PAYMENT_AUDITS FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_PAYMENT_AUDITS.CM_CUSTOMER_TRX_ID
TableJAI_AR_REC_APPL_AUDITS FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_REC_APPL_AUDITS.CUSTOMER_TRX_ID
TableJAI_AR_SUP_HDRS_ALL FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_SUP_HDRS_ALL.CUSTOMER_TRX_ID
TableJAI_AR_SUP_INV_T FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_SUP_INV_T.CUSTOMER_TRX_ID
TableJAI_AR_SUP_LINES FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_SUP_LINES.CUSTOMER_TRX_ID
TableJAI_AR_TRXS FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRXS.CUSTOMER_TRX_ID
TableJAI_AR_TRX_CM_T FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRX_CM_T.INV_TRX_ID
TableJAI_AR_TRX_CM_T FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRX_CM_T.CM_TRX_ID
TableJAI_AR_TRX_COPY_HDR_T FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRX_COPY_HDR_T.CUSTOMER_TRX_ID
TableJAI_AR_TRX_LINES FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRX_LINES.CUSTOMER_TRX_ID
TableJAI_AR_TRX_POE_DTLS FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRX_POE_DTLS.CUSTOMER_TRX_ID
TableJAI_AR_TRX_SUP_INV_T FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRX_SUP_INV_T.CUSTOMER_TRX_ID
TableJAI_AR_TRX_UPDATE_T FK Joins to RA_CUSTOMER_TRX_ALL JAI_AR_TRX_UPDATE_T.TRX_ID
TableJAI_RGM_INVOICE_GEN_T FK Joins to RA_CUSTOMER_TRX_ALL JAI_RGM_INVOICE_GEN_T.CUSTOMER_TRX_ID
TableJAI_RGM_ITEM_GEN_DOCS FK Joins to RA_CUSTOMER_TRX_ALL JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID
TableJAI_RGM_REFS_ALL FK Joins to RA_CUSTOMER_TRX_ALL JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID
TableJAI_RGM_REFS_ALL FK Joins to RA_CUSTOMER_TRX_ALL JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID
TableJE_IT_VAT_REPORT_INV FK Joins to RA_CUSTOMER_TRX_ALL JE_IT_VAT_REPORT_INV.TRX_ID
TableJL_BR_AR_COLLECTION_DOCS_ALL FK Joins to RA_CUSTOMER_TRX_ALL JL_BR_AR_COLLECTION_DOCS_ALL.CUSTOMER_TRX_ID
TableJL_BR_AR_COMP_INV_ALL FK Joins to RA_CUSTOMER_TRX_ALL JL_BR_AR_COMP_INV_ALL.CUSTOMER_TRX_ID
TableJL_BR_AR_PAY_SCHED_AUX FK Joins to RA_CUSTOMER_TRX_ALL JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_TRX_ID
TableJMF_GTA_TRX_HEADERS_ALL FK Joins to RA_CUSTOMER_TRX_ALL JMF_GTA_TRX_HEADERS_ALL.RA_TRX_ID
TableLNS_AMORTIZATION_LINES FK Joins to RA_CUSTOMER_TRX_ALL LNS_AMORTIZATION_LINES.CUST_TRX_ID
TableLNS_AMORTIZATION_SCHEDS FK Joins to RA_CUSTOMER_TRX_ALL LNS_AMORTIZATION_SCHEDS.PRINCIPAL_TRX_ID
TableLNS_AMORTIZATION_SCHEDS FK Joins to RA_CUSTOMER_TRX_ALL LNS_AMORTIZATION_SCHEDS.INTEREST_TRX_ID
TableLNS_AMORTIZATION_SCHEDS FK Joins to RA_CUSTOMER_TRX_ALL LNS_AMORTIZATION_SCHEDS.FEE_TRX_ID
TableLNS_LOAN_HEADERS_ALL FK Joins to RA_CUSTOMER_TRX_ALL LNS_LOAN_HEADERS_ALL.REFERENCE_ID
TableOKL_EXT_SELL_INVS_ALL_B FK Joins to RA_CUSTOMER_TRX_ALL OKL_EXT_SELL_INVS_ALL_B.ISI_ID
TableOKL_EXT_SELL_INVS_B FK Joins to RA_CUSTOMER_TRX_ALL OKL_EXT_SELL_INVS_B.ISI_ID
TablePA_DRAFT_INVOICES_ALL FK Joins to RA_CUSTOMER_TRX_ALL PA_DRAFT_INVOICES_ALL.SYSTEM_REFERENCE
TableRA_CM_REQUESTS_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CM_REQUESTS_ALL.CUSTOMER_TRX_ID
TableRA_CM_REQUESTS_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CM_REQUESTS_ALL.CM_CUSTOMER_TRX_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_ALL.INITIAL_CUSTOMER_TRX_ID
TableRA_CUSTOMER_TRX_LINES_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID
TableRA_CUSTOMER_TRX_LINES_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_LINES_ALL.BR_REF_CUSTOMER_TRX_ID
TableRA_CUSTOMER_TRX_LINES_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUSTOMER_TRX_LINES_ALL.PREVIOUS_CUSTOMER_TRX_ID
TableRA_CUST_TRX_LINE_GL_DIST_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID
TableRA_CUST_TRX_LINE_SALESREPS_ALL FK Joins to RA_CUSTOMER_TRX_ALL RA_CUST_TRX_LINE_SALESREPS_ALL.CUSTOMER_TRX_ID
TableSO_LINES_ALL FK Joins to RA_CUSTOMER_TRX_ALL SO_LINES_ALL.COMMITMENT_ID