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

TABLE: ONT.OE_PAYMENTS

Object Details
Object Name: OE_PAYMENTS
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_PAYMENTS
Subobject Name:
Status: VALID


It holds the commitment payment information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_PAYMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnLINE_ID
ColumnPAYMENT_NUMBER
OE_PAYMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_TRX_ID
ColumnPAYMENT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
PAYMENT_TRX_ID NUMBER

Payment id
COMMITMENT_APPLIED_AMOUNT NUMBER

Commitment Id
COMMITMENT_INTERFACED_AMOUNT NUMBER

Commitment amount
PAYMENT_LEVEL_CODE VARCHAR2 (30) Yes Payment level code
HEADER_ID NUMBER
Yes Header id
LINE_ID NUMBER

Line id
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent program internal request id
PROGRAM_APPLICATION_ID NUMBER

Concurrent program id
PROGRAM_ID NUMBER

Concurrent program id.
PROGRAM_UPDATE_DATE DATE

Concurrent program that last updated row.
CONTEXT VARCHAR2 (30)
Descriptive flex-field segment
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flex-field segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flex-field segment
PAYMENT_TYPE_CODE VARCHAR2 (30)
Stores the type of payment. Possible values for now: COMMITMENT, CREDIT_CARD or Null. Null is equivalent to COMMITMENT.
CREDIT_CARD_CODE VARCHAR2 (80)
Stores Credit Card Type.
CREDIT_CARD_NUMBER VARCHAR2 (80)
Stores Credit Card Number.
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
Stores Credit Card Holder Name
CREDIT_CARD_EXPIRATION_DATE DATE

Stores Credit Card Expiration Date
PREPAID_AMOUNT NUMBER

Stores total of amount successfully collected (including refund) for the entire order.
PAYMENT_SET_ID NUMBER

This is unique number to group payments belonging to one prepaid order. Foreign Key reference to AR.
RECEIPT_METHOD_ID NUMBER

Foreign key to AR payment method. This payment method will be used on the invoice to collect the open balance
PAYMENT_COLLECTION_EVENT VARCHAR2 (30)
Payment Collection Event
CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
Credit Card Approval Code
CREDIT_CARD_APPROVAL_DATE DATE

Credit Card Approval Date
TANGIBLE_ID VARCHAR2 (80)
Internal use only
CHECK_NUMBER VARCHAR2 (50)
Check Number
PAYMENT_AMOUNT NUMBER

Payment Amount
PAYMENT_NUMBER NUMBER

Payment Number
LOCK_CONTROL NUMBER

Internal use only
ORIG_SYS_PAYMENT_REF VARCHAR2 (50)
Original Payment information in external system
DEFER_PAYMENT_PROCESSING_FLAG VARCHAR2 (1)
Set this flag to Y, if you want to do payment processing offline for this payment type
TRXN_EXTENSION_ID NUMBER

Payment Transaction Extension Id
PAYMENT_PERCENTAGE NUMBER

Payment Percentage
INST_ID NUMBER

used in RAC INSTANCE AFFINITY for context setting
INVOICED_FLAG VARCHAR2 (1)
Flag to store if the Payment details have been interfaced to Receivables or not
Query Text

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


SELECT PAYMENT_TRX_ID
,      COMMITMENT_APPLIED_AMOUNT
,      COMMITMENT_INTERFACED_AMOUNT
,      PAYMENT_LEVEL_CODE
,      HEADER_ID
,      LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PAYMENT_TYPE_CODE
,      CREDIT_CARD_CODE
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_EXPIRATION_DATE
,      PREPAID_AMOUNT
,      PAYMENT_SET_ID
,      RECEIPT_METHOD_ID
,      PAYMENT_COLLECTION_EVENT
,      CREDIT_CARD_APPROVAL_CODE
,      CREDIT_CARD_APPROVAL_DATE
,      TANGIBLE_ID
,      CHECK_NUMBER
,      PAYMENT_AMOUNT
,      PAYMENT_NUMBER
,      LOCK_CONTROL
,      ORIG_SYS_PAYMENT_REF
,      DEFER_PAYMENT_PROCESSING_FLAG
,      TRXN_EXTENSION_ID
,      PAYMENT_PERCENTAGE
,      INST_ID
,      INVOICED_FLAG
FROM ONT.OE_PAYMENTS;

Dependencies

[top of page]

ONT.OE_PAYMENTS does not reference any database object

ONT.OE_PAYMENTS is referenced by following:

SchemaONT
ViewOE_PAYMENTS#