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

VIEW: CE.CE_PAYMENT_TRANSACTIONS#

Object Details
Object Name: CE_PAYMENT_TRANSACTIONS#
Object Type: VIEW
Owner: CE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRXN_REFERENCE_NUMBER NUMBER (15) Yes
SETTLE_BY_SYSTEM_FLAG VARCHAR2 (1) Yes
TRANSACTION_TYPE VARCHAR2 (30) Yes
TRXN_SUBTYPE_CODE_ID VARCHAR2 (15)
TRANSACTION_DATE DATE
Yes
ANTICIPATED_VALUE_DATE DATE

TRANSACTION_DESCRIPTION VARCHAR2 (255)
PAYMENT_CURRENCY_CODE VARCHAR2 (15) Yes
PAYMENT_AMOUNT NUMBER
Yes
SOURCE_PARTY_ID VARCHAR2 (15) Yes
SOURCE_LEGAL_ENTITY_ID VARCHAR2 (15) Yes
SOURCE_BANK_ACCOUNT_ID VARCHAR2 (15) Yes
DESTINATION_PARTY_ID VARCHAR2 (15) Yes
DESTINATION_LEGAL_ENTITY_ID VARCHAR2 (15)
DESTINATION_BANK_ACCOUNT_ID VARCHAR2 (15) Yes
DESTINATION_PARTY_SITE_ID NUMBER (15)
REPETITIVE_PAYMENT_CODE VARCHAR2 (150)
TRXN_STATUS_CODE VARCHAR2 (30) Yes
PAYMENT_METHOD_CODE VARCHAR2 (30)
AUTHORIZE_FLAG VARCHAR2 (1)
BANK_CHARGE_BEARER VARCHAR2 (30)
PAYMENT_REASON_CODE VARCHAR2 (30)
PAYMENT_REASON_COMMENTS VARCHAR2 (240)
REMITTANCE_MESSAGE1 VARCHAR2 (150)
REMITTANCE_MESSAGE2 VARCHAR2 (150)
REMITTANCE_MESSAGE3 VARCHAR2 (150)
CREATED_FROM_DIR VARCHAR2 (30)
CREATE_FROM_STMTLINE_ID NUMBER (15)
BANK_TRXN_NUMBER VARCHAR2 (100)
PAYMENT_REQUEST_NUMBER NUMBER

PAPER_DOCUMENT_NUMBER NUMBER (15)
DOC_SEQUENCE_ID NUMBER

DOC_SEQUENCE_VALUE NUMBER

DOC_CATEGORY_CODE VARCHAR2 (30)
PAYMENT_OFFSET_CCID NUMBER (15)
RECEIPT_OFFSET_CCID NUMBER (15)
CASHPOOL_ID NUMBER (15)
EXT_BANK_ACCOUNT_ID NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15) Yes
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# references the following:

SchemaCE
TableCE_PAYMENT_TRANSACTIONS
CE.CE_PAYMENT_TRANSACTIONS# is referenced by following:

SchemaAPPS
SynonymCE_PAYMENT_TRANSACTIONS