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 |