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

TABLE: CE.CE_PAYMENT_TRANSACTIONS

Object Details
Object Name: CE_PAYMENT_TRANSACTIONS
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_PAYMENT_TRANSACTIONS
Subobject Name:
Status: VALID


Table for storing Bank Account Transfer


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_PAYMENT_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRXN_REFERENCE_NUMBER
ColumnTRXN_STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
TRXN_REFERENCE_NUMBER NUMBER (15) Yes Payment Transaction Identifier
SETTLE_BY_SYSTEM_FLAG VARCHAR2 (1) Yes Valued Include Y/N
TRANSACTION_TYPE VARCHAR2 (30) Yes Transaction Type
TRXN_SUBTYPE_CODE_ID VARCHAR2 (15)
Transaction sub type code identifier
TRANSACTION_DATE DATE
Yes Transaction date
ANTICIPATED_VALUE_DATE DATE

Anticipated value date
TRANSACTION_DESCRIPTION VARCHAR2 (255)
Free text description
PAYMENT_CURRENCY_CODE VARCHAR2 (15) Yes Payment Currency Code
PAYMENT_AMOUNT NUMBER
Yes Amount to be paid in payment currency
SOURCE_PARTY_ID VARCHAR2 (15) Yes TCA HZ identifier of source party
SOURCE_LEGAL_ENTITY_ID VARCHAR2 (15) Yes Legal Entity identifier of source party
SOURCE_BANK_ACCOUNT_ID VARCHAR2 (15) Yes Identifier of the source partys bank account that will be used to process this transaction. Links to the internal bank accounts table
DESTINATION_PARTY_ID VARCHAR2 (15) Yes TCA HZ identifier of destination party
DESTINATION_LEGAL_ENTITY_ID VARCHAR2 (15)
Legal Entity identifier of destination party.Populated only if the destination party is an internal legal entity.
DESTINATION_BANK_ACCOUNT_ID VARCHAR2 (15) Yes Identifier of the destination partys bank account that will be used to process this transaction. Links to the internal bank accounts table
DESTINATION_PARTY_SITE_ID NUMBER (15)
TCA HZ identifier of destination party site use.This identifier will be used to derive address information if required by the payment method
REPETITIVE_PAYMENT_CODE VARCHAR2 (150)
Repetitive code used in wire transfers
TRXN_STATUS_CODE VARCHAR2 (30) Yes Transaction status. Indicates whether the transaction has been
PAYMENT_METHOD_CODE VARCHAR2 (30)
Payment method identifier
AUTHORIZE_FLAG VARCHAR2 (1)
Authorize flag
BANK_CHARGE_BEARER VARCHAR2 (30)
Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER
PAYMENT_REASON_CODE VARCHAR2 (30)
Payment reason code
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
Free text field available for entering a reason for the payment
REMITTANCE_MESSAGE1 VARCHAR2 (150)
Remittance message for use in payment processing
REMITTANCE_MESSAGE2 VARCHAR2 (150)
Remittance message for use in payment processing
REMITTANCE_MESSAGE3 VARCHAR2 (150)
Remittance message for use in payment processing
CREATED_FROM_DIR VARCHAR2 (30)
Statement Line type. Either PAYMENT or RECEIPT.
CREATE_FROM_STMTLINE_ID NUMBER (15)
Statement Line Identifier
BANK_TRXN_NUMBER VARCHAR2 (100)
Bank Transaction Number
PAYMENT_REQUEST_NUMBER NUMBER

Payment request number
PAPER_DOCUMENT_NUMBER NUMBER (15)
Payment document number, if a printed payment.Generated by Oracle Payments if payment is printed by system. Recorded by user otherwise
DOC_SEQUENCE_ID NUMBER

Transaction sequence id
DOC_SEQUENCE_VALUE NUMBER

Transaction sequence value
DOC_CATEGORY_CODE VARCHAR2 (30)
Transaction category code
PAYMENT_OFFSET_CCID NUMBER (15)
CCID of non-cash GL account used in seeded accounting definition for clearing event
RECEIPT_OFFSET_CCID NUMBER (15)
CCID of non-cash GL account used in seeded accounting definition for clearing event
CASHPOOL_ID NUMBER (15)
Cash pool id
EXT_BANK_ACCOUNT_ID NUMBER (15)
External Bank Account ID
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object Version Number
Query Text

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


SELECT TRXN_REFERENCE_NUMBER
,      SETTLE_BY_SYSTEM_FLAG
,      TRANSACTION_TYPE
,      TRXN_SUBTYPE_CODE_ID
,      TRANSACTION_DATE
,      ANTICIPATED_VALUE_DATE
,      TRANSACTION_DESCRIPTION
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_AMOUNT
,      SOURCE_PARTY_ID
,      SOURCE_LEGAL_ENTITY_ID
,      SOURCE_BANK_ACCOUNT_ID
,      DESTINATION_PARTY_ID
,      DESTINATION_LEGAL_ENTITY_ID
,      DESTINATION_BANK_ACCOUNT_ID
,      DESTINATION_PARTY_SITE_ID
,      REPETITIVE_PAYMENT_CODE
,      TRXN_STATUS_CODE
,      PAYMENT_METHOD_CODE
,      AUTHORIZE_FLAG
,      BANK_CHARGE_BEARER
,      PAYMENT_REASON_CODE
,      PAYMENT_REASON_COMMENTS
,      REMITTANCE_MESSAGE1
,      REMITTANCE_MESSAGE2
,      REMITTANCE_MESSAGE3
,      CREATED_FROM_DIR
,      CREATE_FROM_STMTLINE_ID
,      BANK_TRXN_NUMBER
,      PAYMENT_REQUEST_NUMBER
,      PAPER_DOCUMENT_NUMBER
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      DOC_CATEGORY_CODE
,      PAYMENT_OFFSET_CCID
,      RECEIPT_OFFSET_CCID
,      CASHPOOL_ID
,      EXT_BANK_ACCOUNT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM CE.CE_PAYMENT_TRANSACTIONS;

Dependencies

[top of page]

CE.CE_PAYMENT_TRANSACTIONS does not reference any database object

CE.CE_PAYMENT_TRANSACTIONS is referenced by following:

SchemaCE
ViewCE_PAYMENT_TRANSACTIONS#