[Home] [Help] [Dependency Information]
Object Name: | OE_PAYMENTS_IFACE_ALL |
---|---|
Object Type: | TABLE |
Owner: | ONT |
FND Design Data: | ONT.OE_PAYMENTS_IFACE_ALL |
Subobject Name: | |
Status: | VALID |
This is a multi-org table for payment records open interface. This table stores payment information that is imported from a feeder system into Oracle Order Management using Order Import. For single payment record at the order level, you can import it using the existing OE_HEADERS_IFACE_ALL.
Scope: public
Product: ONT
Lifecycle: active
Display Name: Sales Order Payments Interface
Category: BUSINESS_ENTITY ONT_SALES_ORDER
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OE_PAYMENTS_IFACE_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REQUEST_ID |
OE_PAYMENTS_IFACE_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ORDER_SOURCE_ID
ORIG_SYS_DOCUMENT_REF ORIG_SYS_LINE_REF ORIG_SYS_SHIPMENT_REF ORIG_SYS_PAYMENT_REF |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_SOURCE_ID | NUMBER | Order Source Id | ||
REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Original system document reference | |
ORIG_SYS_LINE_REF | VARCHAR2 | (50) | Original system line reference | |
ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | Original system shipment reference | |
ORIG_SYS_PAYMENT_REF | VARCHAR2 | (50) | Original system payment reference | |
SOLD_TO_ORG_ID | NUMBER | Sold to Org ID | ||
SOLD_TO_ORG | VARCHAR2 | (360) | Sold to Org | |
CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
CHANGE_REQUEST_CODE | VARCHAR2 | (30) | Change Request Code | |
ORG_ID | NUMBER | Organization ID | ||
PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Yes | Lookup type: OE_PAYMENT_TYPE |
COMMITMENT | VARCHAR2 | (20) | Commitment name: description of a contractual guarantee with a customer for future purchase. | |
PAYMENT_TRX_ID | NUMBER | Commitment ID, Customer Bank Account ID or NULL. | ||
PAYMENT_METHOD | VARCHAR2 | (30) | AR Payment Method name | |
RECEIPT_METHOD_ID | NUMBER | Foreign key reference to AR_Receipt_Methods. | ||
PAYMENT_COLLECTION_EVENT | VARCHAR2 | (30) | Lookup type: OE_PAYMENT_COLLECTION_EVENT. Values are Prepay or Invoice. | |
PAYMENT_SET_ID | NUMBER | Foreign key reference to AR. Unique ID to identify receipts created for an order. | ||
PREPAID_AMOUNT | NUMBER | Receipts created in AR. | ||
CREDIT_CARD_NUMBER | VARCHAR2 | (80) | Stores credit card number if payment type code is Credit Card. If ap_bank_account_id already exists, do not populate this column and use the payment_trx_id column instead. | |
CREDIT_CARD_HOLDER_NAME | VARCHAR2 | (80) | A holder for credit card holder name if payment type code is Credit Card. If Customer Bank Account ID already exists in AP, do not populate this column and use the payment_trx_id column instead. | |
CREDIT_CARD_EXPIRATION_DATE | DATE | Stores credit card expiration date if payment type code is Credit Card. If Customer Bank Account ID already exists in AP, do not populate this column and use the payment_trx_id column instead. | ||
CREDIT_CARD_CODE | VARCHAR2 | (80) | Lookup type: Credit_Card | |
CREDIT_CARD_APPROVAL_CODE | VARCHAR2 | (80) | Stores credit card approval code if payment type code is Credit Card. | |
CREDIT_CARD_APPROVAL_DATE | DATE | Stores credit card approval date if payment type code is Credit Card. | ||
CHECK_NUMBER | VARCHAR2 | (50) | Stores check number if payment type code is Check. | |
PAYMENT_AMOUNT | NUMBER | Stores payment amount input by user, or system calculated from payment_percentage. Example of values: amount written on check, commitment amount to be promised, or prepayment amount to be collected. | ||
PAYMENT_PERCENTAGE | NUMBER | Value is 1 to 100. Do not enter this column if Payment Amount has been populated. | ||
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 | ||
PROGRAM_APPLICATION_ID | NUMBER | Application id of the program that last updated this row. | ||
PROGRAM_ID | NUMBER | Program id of the program that last updated this row. | ||
PROGRAM_UPDATE_DATE | DATE | Date when a program last updated this row. | ||
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
OPERATION_CODE | VARCHAR2 | (30) | Operation Code | |
STATUS_FLAG | VARCHAR2 | (1) | Status Flag | |
INTERFACE_STATUS | VARCHAR2 | (1000) | Interface Status | |
ERROR_FLAG | VARCHAR2 | (1) | Error Flag | |
PAYMENT_NUMBER | NUMBER | For Insert, this number will be system generated. | ||
HEADER_ID | NUMBER | Unique Identified for Order Header | ||
LINE_ID | NUMBER | Unique Identifier for Order Line | ||
TRXN_EXTENSION_ID | NUMBER | Payment Transaction Extension Id | ||
INSTRUMENT_SECURITY_CODE | VARCHAR2 | (10) | Payment instrument security code |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_SOURCE_ID
, REQUEST_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, ORIG_SYS_PAYMENT_REF
, SOLD_TO_ORG_ID
, SOLD_TO_ORG
, CHANGE_SEQUENCE
, CHANGE_REQUEST_CODE
, ORG_ID
, PAYMENT_TYPE_CODE
, COMMITMENT
, PAYMENT_TRX_ID
, PAYMENT_METHOD
, RECEIPT_METHOD_ID
, PAYMENT_COLLECTION_EVENT
, PAYMENT_SET_ID
, PREPAID_AMOUNT
, CREDIT_CARD_NUMBER
, CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_CODE
, CREDIT_CARD_APPROVAL_CODE
, CREDIT_CARD_APPROVAL_DATE
, CHECK_NUMBER
, PAYMENT_AMOUNT
, PAYMENT_PERCENTAGE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, OPERATION_CODE
, STATUS_FLAG
, INTERFACE_STATUS
, ERROR_FLAG
, PAYMENT_NUMBER
, HEADER_ID
, LINE_ID
, TRXN_EXTENSION_ID
, INSTRUMENT_SECURITY_CODE
FROM ONT.OE_PAYMENTS_IFACE_ALL;
ONT.OE_PAYMENTS_IFACE_ALL does not reference any database object
ONT.OE_PAYMENTS_IFACE_ALL is referenced by following:
|
|
|