1. Tables and Views for SCM
  2. DOO_ORDER_PAYMENTS_INT

DOO_ORDER_PAYMENTS_INT

This interface table contains details of Payments for an imported Source Sales Order.

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
SOURCE_TRANSACTION_SYSTEM VARCHAR2 30 System or application that submitted the order request.
SOURCE_TRANSACTION_ID VARCHAR2 50 Unique identifier of the transaction in the system that captured the transaction.
SOURCE_TRANSACTION_LINE_ID VARCHAR2 50 Unique identifier of the transaction line from the system that captured the transaction.
SOURCE_TRANSACTION_SCHEDULE_ID VARCHAR2 50 Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction.
PAYMENT_METHOD_CODE VARCHAR2 1000 Payment method code associated with the customer account payment instrument.
PAYMENT_METHOD VARCHAR2 1000 Payment method associated with the customer account payment instrument.
PAYMENT_TRANSACTION_ID NUMBER 18 Unique identifier of the payment.
PAYMENT_SET_ID NUMBER 18 Unique identifier of a group of payments belonging to one prepaid order. It contains a foreign key reference to the Billing table in case of prepayments.
SOURCE_TRANSACTION_PAYMENT_ID VARCHAR2 50 Unique identifier of the payment that is assigned by the system that captured the transaction.
PAYMENT_TYPE VARCHAR2 80 Payment Type associated with the customer account payment instrument.
PAYMENT_TYPE_CODE VARCHAR2 30 Code for the payment type associated with the customer account payment instrument.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LOAD_REQUEST_ID NUMBER 18 Unique identifier of the import request.
CC_TOKEN_NUMBER VARCHAR2 30 Token number issued by the tokenization service provider corresponding to a credit card number.
CC_EXPIRATION_DATE DATE Date when the credit card is no longer valid. Use the YYYY/MM/DD format.
CC_FIRST_NAME VARCHAR2 40 First name of the credit card holder.
CC_LAST_NAME VARCHAR2 40 Last name of the credit card holder.
CC_ISSUER_CODE VARCHAR2 30 Abbreviation that uniquely identifies the organization that issued the credit card. For example, VISA or MASTERCARD.
CC_MASKED_NUMBER VARCHAR2 30 Masked format that displays only the last four digits of a credit card number, and replaces all other digits with X. This attribute is used for security purposes. The length of the masked card number should match the actual length of the number provided by the card issuer. For example, the masked card number for a Visa card number is XXXXXXXXXXXX2345.
CC_AUTH_REQUEST_ID VARCHAR2 30 Authorization request identifier received from the tokenization service provider to authorize the credit card number. If you want to import a credit card authorization other than the Credit Card Token Number, then you must provide either the Credit Card Authorization Request Identifier or the Credit Card Voice Authorization Code. If both are provided, then the Credit Card Authorization Request Identifier takes precedence.
CC_VOICE_AUTH_CODE VARCHAR2 100 Voice authorization code received from the tokenization service provider to authorize the credit card number. If you want to import a credit card authorization other than the Credit Card Token Number, then you must provide either the Credit Card Authorization Request Identifier or the Credit Card Voice Authorization Code. If both are provided, then the Credit Card Authorization Request Identifier takes precedence.
PAYMENT_SERVER_ORDER_NUM VARCHAR2 80 Number that identifies the credit card payment that was authorized by Oracle Payment Server.
AUTHORIZED_AMOUNT NUMBER Authorized amount received from the tokenization service provider to authorize the transaction. The authorized amount must be provided if the authorization request identifier is sent in the payload.

Indexes

Index Uniqueness Tablespace Columns
DOO_ORDER_PAYMENTS_INT_N1 Non Unique Default SOURCE_TRANSACTION_ID, SOURCE_TRANSACTION_SYSTEM, LOAD_REQUEST_ID, SOURCE_TRANSACTION_LINE_ID