Product: | AR - Receivables |
---|---|
Description: | Header-level information about invoices, debit memos, chargebacks, commitments and credit memos |
Implementation/DBA Data: | AR.RA_CUSTOMER_TRX_ALL |
Table | |
Foreign Table | Foreign Key Column |
---|---|---|---|
RA_CUSTOMER_TRX_ALL | RA_ADDRESSES_ALL | RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID | |
RA_CUSTOMER_TRX_ALL | OKC_K_HEADERS_B | RA_CUSTOMER_TRX_ALL.CONTRACT_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNT_ROLES | RA_CUSTOMER_TRX_ALL.BILL_TO_CONTACT_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNTS | RA_CUSTOMER_TRX_ALL.BILL_TO_CUSTOMER_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_SITE_USES_ALL | RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNTS | RA_CUSTOMER_TRX_ALL.SHIP_TO_CUSTOMER_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_SITE_USES_ALL | RA_CUSTOMER_TRX_ALL.SHIP_TO_SITE_USE_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNT_ROLES | RA_CUSTOMER_TRX_ALL.SHIP_TO_CONTACT_ID | |
RA_CUSTOMER_TRX_ALL | RA_TERMS_B | RA_CUSTOMER_TRX_ALL.TERM_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCT_SITES_ALL | RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID | |
RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_ALL | RA_SALESREPS_ALL | RA_CUSTOMER_TRX_ALL.PRIMARY_SALESREP_ID | |
RA_CUSTOMER_TRX_ALL | RA_CUST_TRX_TYPES_ALL | RA_CUSTOMER_TRX_ALL.CUST_TRX_TYPE_ID | |
RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL.INITIAL_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_ALL | SO_AGREEMENTS_B | RA_CUSTOMER_TRX_ALL.AGREEMENT_ID | |
RA_CUSTOMER_TRX_ALL | FND_CURRENCIES | RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE | |
RA_CUSTOMER_TRX_ALL | AR_POSTING_CONTROL | RA_CUSTOMER_TRX_ALL.POSTING_CONTROL_ID | |
RA_CUSTOMER_TRX_ALL | AP_BANK_ACCOUNTS_ALL | RA_CUSTOMER_TRX_ALL.CUSTOMER_BANK_ACCOUNT_ID | |
RA_CUSTOMER_TRX_ALL | FND_DOCUMENT_SEQUENCES | RA_CUSTOMER_TRX_ALL.DOC_SEQUENCE_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNTS | RA_CUSTOMER_TRX_ALL.PAYING_CUSTOMER_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_SITE_USES_ALL | RA_CUSTOMER_TRX_ALL.PAYING_SITE_USE_ID | |
RA_CUSTOMER_TRX_ALL | GL_SETS_OF_BOOKS_11I | RA_CUSTOMER_TRX_ALL.SET_OF_BOOKS_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCT_SITES_ALL | RA_CUSTOMER_TRX_ALL.REMIT_TO_ADDRESS_ID | |
RA_CUSTOMER_TRX_ALL | RA_TERRITORIES | RA_CUSTOMER_TRX_ALL.TERRITORY_ID | |
RA_CUSTOMER_TRX_ALL | AR_RECEIPT_METHODS | RA_CUSTOMER_TRX_ALL.RECEIPT_METHOD_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_SITE_USES_ALL | RA_CUSTOMER_TRX_ALL.BILL_TO_SITE_USE_ID | |
RA_CUSTOMER_TRX_ALL | AP_BANK_ACCOUNTS_ALL | RA_CUSTOMER_TRX_ALL.DRAWEE_BANK_ACCOUNT_ID | |
RA_CUSTOMER_TRX_ALL | AP_BANK_ACCOUNTS_ALL | RA_CUSTOMER_TRX_ALL.REMITTANCE_BANK_ACCOUNT_ID | |
RA_CUSTOMER_TRX_ALL | AR_BATCHES_ALL | RA_CUSTOMER_TRX_ALL.REMITTANCE_BATCH_ID | |
RA_CUSTOMER_TRX_ALL | AR_BPA_TEMPLATES_B | RA_CUSTOMER_TRX_ALL.BILL_TEMPLATE_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCT_SITES_ALL | RA_CUSTOMER_TRX_ALL.BILL_TO_ADDRESS_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNT_ROLES | RA_CUSTOMER_TRX_ALL.DRAWEE_CONTACT_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCT_SITES_ALL | RA_CUSTOMER_TRX_ALL.SHIP_TO_ADDRESS_ID | |
RA_CUSTOMER_TRX_ALL | CE_BANK_ACCT_USES_ALL | RA_CUSTOMER_TRX_ALL.REMIT_BANK_ACCT_USE_ID | |
RA_CUSTOMER_TRX_ALL | IBY_FNDCPT_TX_EXTENSIONS | RA_CUSTOMER_TRX_ALL.PAYMENT_TRXN_EXTENSION_ID | |
RA_CUSTOMER_TRX_ALL | FND_APPLICATION | RA_CUSTOMER_TRX_ALL.APPLICATION_ID | |
RA_CUSTOMER_TRX_ALL | AR_INTEREST_HEADERS_ALL | RA_CUSTOMER_TRX_ALL.INTEREST_HEADER_ID | |
RA_CUSTOMER_TRX_ALL | RA_BATCH_SOURCES_ALL | RA_CUSTOMER_TRX_ALL.BATCH_SOURCE_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNTS | RA_CUSTOMER_TRX_ALL.SOLD_TO_CUSTOMER_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_ACCOUNT_ROLES | RA_CUSTOMER_TRX_ALL.SOLD_TO_CONTACT_ID | |
RA_CUSTOMER_TRX_ALL | HZ_CUST_SITE_USES_ALL | RA_CUSTOMER_TRX_ALL.SOLD_TO_SITE_USE_ID | |
AR_ADJUSTMENTS_ALL | RA_CUSTOMER_TRX_ALL | AR_ADJUSTMENTS_ALL.SUBSEQUENT_TRX_ID | |
AR_ADJUSTMENTS_ALL | RA_CUSTOMER_TRX_ALL | AR_ADJUSTMENTS_ALL.CUSTOMER_TRX_ID | |
AR_CC_ERROR_HISTORY | RA_CUSTOMER_TRX_ALL | AR_CC_ERROR_HISTORY.CC_TRX_ID | |
AR_CUSTOMER_CALL_TOPICS_ALL | RA_CUSTOMER_TRX_ALL | AR_CUSTOMER_CALL_TOPICS_ALL.CUSTOMER_TRX_ID | |
AR_GTA_TRX_HEADERS_ALL | RA_CUSTOMER_TRX_ALL | AR_GTA_TRX_HEADERS_ALL.RA_TRX_ID | |
AR_INTERIM_CASH_RECEIPTS_ALL | RA_CUSTOMER_TRX_ALL | AR_INTERIM_CASH_RECEIPTS_ALL.CUSTOMER_TRX_ID | |
AR_INTERIM_CASH_RCPT_LINES_ALL | RA_CUSTOMER_TRX_ALL | AR_INTERIM_CASH_RCPT_LINES_ALL.CUSTOMER_TRX_ID | |
AR_MC_PAYMENT_SCHEDULES | RA_CUSTOMER_TRX_ALL | AR_MC_PAYMENT_SCHEDULES.CUSTOMER_TRX_ID | |
AR_MC_TRANSACTION_HISTORY | RA_CUSTOMER_TRX_ALL | AR_MC_TRANSACTION_HISTORY.CUSTOMER_TRX_ID | |
AR_NOTES | RA_CUSTOMER_TRX_ALL | AR_NOTES.CUSTOMER_TRX_ID | |
AR_PAYMENT_SCHEDULES_ALL | RA_CUSTOMER_TRX_ALL | AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID | |
AR_RAMC_AUDIT_TRAIL | RA_CUSTOMER_TRX_ALL | AR_RAMC_AUDIT_TRAIL.CUSTOMER_TRX_ID | |
AR_RECEIVABLE_APPLICATIONS_ALL | RA_CUSTOMER_TRX_ALL | AR_RECEIVABLE_APPLICATIONS_ALL.CUSTOMER_TRX_ID | |
AR_RECEIVABLE_APPLICATIONS_ALL | RA_CUSTOMER_TRX_ALL | AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_ID | |
AR_RECEIVABLE_APPLICATIONS_ALL | RA_CUSTOMER_TRX_ALL | AR_RECEIVABLE_APPLICATIONS_ALL.LINK_TO_CUSTOMER_TRX_ID | |
AR_RECEIVABLE_APPLICATIONS_ALL | RA_CUSTOMER_TRX_ALL | AR_RECEIVABLE_APPLICATIONS_ALL.CHARGEBACK_CUSTOMER_TRX_ID | |
AR_REVENUE_ADJUSTMENTS_ALL | RA_CUSTOMER_TRX_ALL | AR_REVENUE_ADJUSTMENTS_ALL.CUSTOMER_TRX_ID | |
CN_NOT_TRX_ALL | RA_CUSTOMER_TRX_ALL | CN_NOT_TRX_ALL.SOURCE_TRX_ID | |
CN_TRX_ALL | RA_CUSTOMER_TRX_ALL | CN_TRX_ALL.SOURCE_TRX_ID | |
CST_MARGIN_TEMP | RA_CUSTOMER_TRX_ALL | CST_MARGIN_TEMP.CUSTOMER_TRX_ID | |
FV_INVOICE_FINANCE_CHRGS_ALL | RA_CUSTOMER_TRX_ALL | FV_INVOICE_FINANCE_CHRGS_ALL.CUSTOMER_TRX_ID | |
IGI_EXP_AR_TRANS_ALL | RA_CUSTOMER_TRX_ALL | IGI_EXP_AR_TRANS_ALL.CUSTOMER_TRX_ID | |
JAI_AR_PAYMENT_AUDITS | RA_CUSTOMER_TRX_ALL | JAI_AR_PAYMENT_AUDITS.CM_CUSTOMER_TRX_ID | |
JAI_AR_REC_APPL_AUDITS | RA_CUSTOMER_TRX_ALL | JAI_AR_REC_APPL_AUDITS.CUSTOMER_TRX_ID | |
JAI_AR_SUP_HDRS_ALL | RA_CUSTOMER_TRX_ALL | JAI_AR_SUP_HDRS_ALL.CUSTOMER_TRX_ID | |
JAI_AR_SUP_INV_T | RA_CUSTOMER_TRX_ALL | JAI_AR_SUP_INV_T.CUSTOMER_TRX_ID | |
JAI_AR_SUP_LINES | RA_CUSTOMER_TRX_ALL | JAI_AR_SUP_LINES.CUSTOMER_TRX_ID | |
JAI_AR_TRXS | RA_CUSTOMER_TRX_ALL | JAI_AR_TRXS.CUSTOMER_TRX_ID | |
JAI_AR_TRX_CM_T | RA_CUSTOMER_TRX_ALL | JAI_AR_TRX_CM_T.INV_TRX_ID | |
JAI_AR_TRX_CM_T | RA_CUSTOMER_TRX_ALL | JAI_AR_TRX_CM_T.CM_TRX_ID | |
JAI_AR_TRX_COPY_HDR_T | RA_CUSTOMER_TRX_ALL | JAI_AR_TRX_COPY_HDR_T.CUSTOMER_TRX_ID | |
JAI_AR_TRX_LINES | RA_CUSTOMER_TRX_ALL | JAI_AR_TRX_LINES.CUSTOMER_TRX_ID | |
JAI_AR_TRX_POE_DTLS | RA_CUSTOMER_TRX_ALL | JAI_AR_TRX_POE_DTLS.CUSTOMER_TRX_ID | |
JAI_AR_TRX_SUP_INV_T | RA_CUSTOMER_TRX_ALL | JAI_AR_TRX_SUP_INV_T.CUSTOMER_TRX_ID | |
JAI_AR_TRX_UPDATE_T | RA_CUSTOMER_TRX_ALL | JAI_AR_TRX_UPDATE_T.TRX_ID | |
JAI_RGM_INVOICE_GEN_T | RA_CUSTOMER_TRX_ALL | JAI_RGM_INVOICE_GEN_T.CUSTOMER_TRX_ID | |
JAI_RGM_ITEM_GEN_DOCS | RA_CUSTOMER_TRX_ALL | JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID | |
JAI_RGM_REFS_ALL | RA_CUSTOMER_TRX_ALL | JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID | |
JAI_RGM_REFS_ALL | RA_CUSTOMER_TRX_ALL | JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID | |
JE_IT_VAT_REPORT_INV | RA_CUSTOMER_TRX_ALL | JE_IT_VAT_REPORT_INV.TRX_ID | |
JL_BR_AR_COLLECTION_DOCS_ALL | RA_CUSTOMER_TRX_ALL | JL_BR_AR_COLLECTION_DOCS_ALL.CUSTOMER_TRX_ID | |
JL_BR_AR_COMP_INV_ALL | RA_CUSTOMER_TRX_ALL | JL_BR_AR_COMP_INV_ALL.CUSTOMER_TRX_ID | |
JL_BR_AR_PAY_SCHED_AUX | RA_CUSTOMER_TRX_ALL | JL_BR_AR_PAY_SCHED_AUX.CUSTOMER_TRX_ID | |
JMF_GTA_TRX_HEADERS_ALL | RA_CUSTOMER_TRX_ALL | JMF_GTA_TRX_HEADERS_ALL.RA_TRX_ID | |
LNS_AMORTIZATION_LINES | RA_CUSTOMER_TRX_ALL | LNS_AMORTIZATION_LINES.CUST_TRX_ID | |
LNS_AMORTIZATION_SCHEDS | RA_CUSTOMER_TRX_ALL | LNS_AMORTIZATION_SCHEDS.PRINCIPAL_TRX_ID | |
LNS_AMORTIZATION_SCHEDS | RA_CUSTOMER_TRX_ALL | LNS_AMORTIZATION_SCHEDS.INTEREST_TRX_ID | |
LNS_AMORTIZATION_SCHEDS | RA_CUSTOMER_TRX_ALL | LNS_AMORTIZATION_SCHEDS.FEE_TRX_ID | |
LNS_LOAN_HEADERS_ALL | RA_CUSTOMER_TRX_ALL | LNS_LOAN_HEADERS_ALL.REFERENCE_ID | |
OKL_EXT_SELL_INVS_ALL_B | RA_CUSTOMER_TRX_ALL | OKL_EXT_SELL_INVS_ALL_B.ISI_ID | |
OKL_EXT_SELL_INVS_B | RA_CUSTOMER_TRX_ALL | OKL_EXT_SELL_INVS_B.ISI_ID | |
PA_DRAFT_INVOICES_ALL | RA_CUSTOMER_TRX_ALL | PA_DRAFT_INVOICES_ALL.SYSTEM_REFERENCE | |
RA_CM_REQUESTS_ALL | RA_CUSTOMER_TRX_ALL | RA_CM_REQUESTS_ALL.CUSTOMER_TRX_ID | |
RA_CM_REQUESTS_ALL | RA_CUSTOMER_TRX_ALL | RA_CM_REQUESTS_ALL.CM_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL.PREVIOUS_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_ALL.INITIAL_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_LINES_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_LINES_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_LINES_ALL.BR_REF_CUSTOMER_TRX_ID | |
RA_CUSTOMER_TRX_LINES_ALL | RA_CUSTOMER_TRX_ALL | RA_CUSTOMER_TRX_LINES_ALL.PREVIOUS_CUSTOMER_TRX_ID | |
RA_CUST_TRX_LINE_GL_DIST_ALL | RA_CUSTOMER_TRX_ALL | RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID | |
RA_CUST_TRX_LINE_SALESREPS_ALL | RA_CUSTOMER_TRX_ALL | RA_CUST_TRX_LINE_SALESREPS_ALL.CUSTOMER_TRX_ID | |
SO_LINES_ALL | RA_CUSTOMER_TRX_ALL | SO_LINES_ALL.COMMITMENT_ID |
|
|
|