DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.RA_CUSTOMER_TRX_ALL

Object Details
Object Name: RA_CUSTOMER_TRX_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.RA_CUSTOMER_TRX_ALL
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


This is the RA_CUSTOMER_TRX_ALL view
which may be used by all products.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RA_CUSTOMER_TRX_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
RA_CUSTOMER_TRX_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREVERSED_CASH_RECEIPT_ID
RA_CUSTOMER_TRX_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_NUMBER
ColumnORG_ID
RA_CUSTOMER_TRX_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYING_SITE_USE_ID
RA_CUSTOMER_TRX_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_TO_CUSTOMER_ID
ColumnCUST_TRX_TYPE_ID
ColumnAGREEMENT_ID
RA_CUSTOMER_TRX_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
RA_CUSTOMER_TRX_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRINTING_LAST_PRINTED
RA_CUSTOMER_TRX_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
RA_CUSTOMER_TRX_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnCC_ERROR_FLAG
RA_CUSTOMER_TRX_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINITIAL_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRINTING_PENDING
ColumnTRX_DATE
RA_CUSTOMER_TRX_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TO_CUSTOMER_ID
RA_CUSTOMER_TRX_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGLOBAL_ATTRIBUTE1
RA_CUSTOMER_TRX_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPURCHASE_ORDER
RA_CUSTOMER_TRX_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOLD_TO_CUSTOMER_ID
RA_CUSTOMER_TRX_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDRAWEE_ID
RA_CUSTOMER_TRX_N22 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREMITTANCE_BATCH_ID
RA_CUSTOMER_TRX_N23 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCC_ERROR_FLAG
RA_CUSTOMER_TRX_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_DATE
RA_CUSTOMER_TRX_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREVIOUS_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATION_DATE
RA_CUSTOMER_TRX_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYING_CUSTOMER_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TRX_NUMBER VARCHAR2 (20) Yes
CUST_TRX_TYPE_ID NUMBER (15) Yes
TRX_DATE DATE
Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
BILL_TO_CONTACT_ID NUMBER (15)

BATCH_ID NUMBER (15)

BATCH_SOURCE_ID NUMBER (15)

REASON_CODE VARCHAR2 (30)

SOLD_TO_CUSTOMER_ID NUMBER (15)

SOLD_TO_CONTACT_ID NUMBER (15)

SOLD_TO_SITE_USE_ID NUMBER (15)

BILL_TO_CUSTOMER_ID NUMBER (15)

BILL_TO_SITE_USE_ID NUMBER (15)

SHIP_TO_CUSTOMER_ID NUMBER (15)

SHIP_TO_CONTACT_ID NUMBER (15)

SHIP_TO_SITE_USE_ID NUMBER (15)

SHIPMENT_ID NUMBER (15)

REMIT_TO_ADDRESS_ID NUMBER (15)

TERM_ID NUMBER (15)

TERM_DUE_DATE DATE


PREVIOUS_CUSTOMER_TRX_ID NUMBER (15)

PRIMARY_SALESREP_ID NUMBER (15)

PRINTING_ORIGINAL_DATE DATE


PRINTING_LAST_PRINTED DATE


PRINTING_OPTION VARCHAR2 (20)

PRINTING_COUNT NUMBER (15)

PRINTING_PENDING VARCHAR2 (1)

PURCHASE_ORDER VARCHAR2 (50)

PURCHASE_ORDER_REVISION VARCHAR2 (50)

PURCHASE_ORDER_DATE DATE


CUSTOMER_REFERENCE VARCHAR2 (30)

CUSTOMER_REFERENCE_DATE DATE


COMMENTS VARCHAR2 (1760)

INTERNAL_NOTES VARCHAR2 (240)

EXCHANGE_RATE_TYPE VARCHAR2 (30)

EXCHANGE_DATE DATE


EXCHANGE_RATE NUMBER


TERRITORY_ID NUMBER (15)

INVOICE_CURRENCY_CODE VARCHAR2 (15)

INITIAL_CUSTOMER_TRX_ID NUMBER (15)

AGREEMENT_ID NUMBER (15)

END_DATE_COMMITMENT DATE


START_DATE_COMMITMENT DATE


LAST_PRINTED_SEQUENCE_NUM NUMBER (15)

ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ORIG_SYSTEM_BATCH_NAME VARCHAR2 (40)

POST_REQUEST_ID NUMBER (15)

REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
FINANCE_CHARGES VARCHAR2 (1)

COMPLETE_FLAG VARCHAR2 (1) Yes
POSTING_CONTROL_ID NUMBER (15)

BILL_TO_ADDRESS_ID NUMBER (15)

RA_POST_LOOP_NUMBER NUMBER (15)

SHIP_TO_ADDRESS_ID NUMBER (15)

CREDIT_METHOD_FOR_RULES VARCHAR2 (30)

CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR2 (30)

RECEIPT_METHOD_ID NUMBER (15)

ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
RELATED_CUSTOMER_TRX_ID NUMBER (15)

INVOICING_RULE_ID NUMBER (15)

SHIP_VIA VARCHAR2 (30)

SHIP_DATE_ACTUAL DATE


WAYBILL_NUMBER VARCHAR2 (50)

FOB_POINT VARCHAR2 (30)

CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)

INTERFACE_HEADER_ATTRIBUTE1 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE2 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE3 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE4 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE5 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE6 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE7 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE8 VARCHAR2 (150)

INTERFACE_HEADER_CONTEXT VARCHAR2 (30)

DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)

INTERFACE_HEADER_ATTRIBUTE10 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE11 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE12 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE13 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE14 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE15 VARCHAR2 (150)

INTERFACE_HEADER_ATTRIBUTE9 VARCHAR2 (150)

DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2 (30)

RECURRED_FROM_TRX_NUMBER VARCHAR2 (20)

STATUS_TRX VARCHAR2 (30)

DOC_SEQUENCE_ID NUMBER (15)

DOC_SEQUENCE_VALUE NUMBER (15)

PAYING_CUSTOMER_ID NUMBER (15)

PAYING_SITE_USE_ID NUMBER (15)

RELATED_BATCH_SOURCE_ID NUMBER (15)

DEFAULT_TAX_EXEMPT_FLAG VARCHAR2 (1)

CREATED_FROM VARCHAR2 (30) Yes
ORG_ID NUMBER (15)
Organization identifier
WH_UPDATE_DATE DATE

Warehouse update date when record was recorded or changed
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE21 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE22 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE23 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE24 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE25 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE26 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE27 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE28 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE29 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE30 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved For Globalization Functionality
EDI_PROCESSED_FLAG VARCHAR2 (1)
EDI_PROCESSED_STATUS VARCHAR2 (10)
MRC_EXCHANGE_RATE_TYPE VARCHAR2 (2000)
No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
MRC_EXCHANGE_DATE VARCHAR2 (2000)
No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
MRC_EXCHANGE_RATE VARCHAR2 (2000)
No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12.
PAYMENT_SERVER_ORDER_NUM VARCHAR2 (80)
Identifies credit card payment authorized by Oracle Payment Server
APPROVAL_CODE VARCHAR2 (80)
Payment approval code from credit card issuer
ADDRESS_VERIFICATION_CODE VARCHAR2 (80)
Credit card address verification code from Oracle Payment Server
OLD_TRX_NUMBER VARCHAR2 (20)
BR_AMOUNT NUMBER

BR_UNPAID_FLAG VARCHAR2 (1)
BR_ON_HOLD_FLAG VARCHAR2 (1)
DRAWEE_ID NUMBER (15)
DRAWEE_CONTACT_ID NUMBER (15)
DRAWEE_SITE_USE_ID NUMBER (15)
REMITTANCE_BANK_ACCOUNT_ID NUMBER (15)
OVERRIDE_REMIT_ACCOUNT_FLAG VARCHAR2 (1)
DRAWEE_BANK_ACCOUNT_ID NUMBER (15)
SPECIAL_INSTRUCTIONS VARCHAR2 (240)
REMITTANCE_BATCH_ID NUMBER (15)
PREPAYMENT_FLAG VARCHAR2 (1)
CT_REFERENCE VARCHAR2 (150)
Derived Reference Field. Derived from Interface Header attribute based on the batch source
CONTRACT_ID NUMBER

Identifies the contract from Oracle Contracts Core that is associated with this line
BILL_TEMPLATE_ID NUMBER (15)
Identifies the template id of the presented bill
REVERSED_CASH_RECEIPT_ID NUMBER (15)
CC_ERROR_CODE VARCHAR2 (80)
Error code from credit card payment processor
CC_ERROR_TEXT VARCHAR2 (255)
User-enterable description for credit card error code
CC_ERROR_FLAG VARCHAR2 (1)
Y indicates a transaction had a creidt card processing error
UPGRADE_METHOD VARCHAR2 (30)
Upgrade flag to indicate the origin of the transaction
LEGAL_ENTITY_ID NUMBER (15)
Identifies the legal entity that owns or issues this transaction.
REMIT_BANK_ACCT_USE_ID NUMBER (15)
Unique identifier of remittance bank account use that automatic receipt will be deposited into
PAYMENT_TRXN_EXTENSION_ID NUMBER (15)
Payment extension identifier provided by Oracle Payments. Populated only when an automatic receipt method is associated with the transaction.
AX_ACCOUNTED_FLAG VARCHAR2 (1)
Upgrade flag to indicate the distributions have been upgraded by AX
APPLICATION_ID NUMBER (15)
Internal identifier of the application that interfaced the transaction to Receivables
PAYMENT_ATTRIBUTES VARCHAR2 (1000)
Payment attributes for the transaction provided by Oracle Payments.
BILLING_DATE DATE

Billing date for balance forward transactions
INTEREST_HEADER_ID NUMBER (15)
Internal identifier of the late charges transaction header.
LATE_CHARGES_ASSESSED VARCHAR2 (30)
Column to control whether late charge is applicable for the transaction.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_TRX_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TRX_NUMBER
,      CUST_TRX_TYPE_ID
,      TRX_DATE
,      SET_OF_BOOKS_ID
,      BILL_TO_CONTACT_ID
,      BATCH_ID
,      BATCH_SOURCE_ID
,      REASON_CODE
,      SOLD_TO_CUSTOMER_ID
,      SOLD_TO_CONTACT_ID
,      SOLD_TO_SITE_USE_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_CONTACT_ID
,      SHIP_TO_SITE_USE_ID
,      SHIPMENT_ID
,      REMIT_TO_ADDRESS_ID
,      TERM_ID
,      TERM_DUE_DATE
,      PREVIOUS_CUSTOMER_TRX_ID
,      PRIMARY_SALESREP_ID
,      PRINTING_ORIGINAL_DATE
,      PRINTING_LAST_PRINTED
,      PRINTING_OPTION
,      PRINTING_COUNT
,      PRINTING_PENDING
,      PURCHASE_ORDER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      CUSTOMER_REFERENCE
,      CUSTOMER_REFERENCE_DATE
,      COMMENTS
,      INTERNAL_NOTES
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      TERRITORY_ID
,      INVOICE_CURRENCY_CODE
,      INITIAL_CUSTOMER_TRX_ID
,      AGREEMENT_ID
,      END_DATE_COMMITMENT
,      START_DATE_COMMITMENT
,      LAST_PRINTED_SEQUENCE_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORIG_SYSTEM_BATCH_NAME
,      POST_REQUEST_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FINANCE_CHARGES
,      COMPLETE_FLAG
,      POSTING_CONTROL_ID
,      BILL_TO_ADDRESS_ID
,      RA_POST_LOOP_NUMBER
,      SHIP_TO_ADDRESS_ID
,      CREDIT_METHOD_FOR_RULES
,      CREDIT_METHOD_FOR_INSTALLMENTS
,      RECEIPT_METHOD_ID
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RELATED_CUSTOMER_TRX_ID
,      INVOICING_RULE_ID
,      SHIP_VIA
,      SHIP_DATE_ACTUAL
,      WAYBILL_NUMBER
,      FOB_POINT
,      CUSTOMER_BANK_ACCOUNT_ID
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_CONTEXT
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      INTERFACE_HEADER_ATTRIBUTE9
,      DEFAULT_USSGL_TRANSACTION_CODE
,      RECURRED_FROM_TRX_NUMBER
,      STATUS_TRX
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      RELATED_BATCH_SOURCE_ID
,      DEFAULT_TAX_EXEMPT_FLAG
,      CREATED_FROM
,      ORG_ID
,      WH_UPDATE_DATE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE21
,      GLOBAL_ATTRIBUTE22
,      GLOBAL_ATTRIBUTE23
,      GLOBAL_ATTRIBUTE24
,      GLOBAL_ATTRIBUTE25
,      GLOBAL_ATTRIBUTE26
,      GLOBAL_ATTRIBUTE27
,      GLOBAL_ATTRIBUTE28
,      GLOBAL_ATTRIBUTE29
,      GLOBAL_ATTRIBUTE30
,      GLOBAL_ATTRIBUTE_CATEGORY
,      EDI_PROCESSED_FLAG
,      EDI_PROCESSED_STATUS
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      PAYMENT_SERVER_ORDER_NUM
,      APPROVAL_CODE
,      ADDRESS_VERIFICATION_CODE
,      OLD_TRX_NUMBER
,      BR_AMOUNT
,      BR_UNPAID_FLAG
,      BR_ON_HOLD_FLAG
,      DRAWEE_ID
,      DRAWEE_CONTACT_ID
,      DRAWEE_SITE_USE_ID
,      REMITTANCE_BANK_ACCOUNT_ID
,      OVERRIDE_REMIT_ACCOUNT_FLAG
,      DRAWEE_BANK_ACCOUNT_ID
,      SPECIAL_INSTRUCTIONS
,      REMITTANCE_BATCH_ID
,      PREPAYMENT_FLAG
,      CT_REFERENCE
,      CONTRACT_ID
,      BILL_TEMPLATE_ID
,      REVERSED_CASH_RECEIPT_ID
,      CC_ERROR_CODE
,      CC_ERROR_TEXT
,      CC_ERROR_FLAG
,      UPGRADE_METHOD
,      LEGAL_ENTITY_ID
,      REMIT_BANK_ACCT_USE_ID
,      PAYMENT_TRXN_EXTENSION_ID
,      AX_ACCOUNTED_FLAG
,      APPLICATION_ID
,      PAYMENT_ATTRIBUTES
,      BILLING_DATE
,      INTEREST_HEADER_ID
,      LATE_CHARGES_ASSESSED
FROM AR.RA_CUSTOMER_TRX_ALL;

Dependencies

[top of page]

AR.RA_CUSTOMER_TRX_ALL does not reference any database object

AR.RA_CUSTOMER_TRX_ALL is referenced by following:

SchemaAPPS
TriggerJAI_AR_RCTA_ARIUD_T1
TriggerJAI_AR_RCTA_ASI_T1
TriggerJG_ZZ_AR_AUTO_TRX_NUM_UPD
TriggerJL_AR_AR_RECT_DM_TRX_NUM_INS
TriggerJL_BR_AR_AUTO_INT_PARAM
TriggerJL_BR_AR_OCC_DOCS_DIS_N_OTHER
SynonymRA_CUSTOMER_TRX
SynonymRA_CUSTOMER_TRX_ALL
TriggerRA_CUSTOMER_TRX_BRI