SalesOrdersForOrderHubpayments
Manages payment-related data for the entire sales order, including totals and payment terms.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the payment transaction to the overall order. This ensures proper tracking and association of payments at the order level. |
| PaymentTransactionId [KEY] | Long | Unique identifier for the payment transaction, used to track the payment in the system and link it to specific order or invoice transactions. |
| Amount | Decimal | Amount authorized for the payment, representing the monetary value that has been approved for the transaction. |
| AuthorizationStatusCode | String | Status code of the payment authorization. Possible values include 'Pass' or 'Fail', indicating whether the payment was successfully authorized. |
| AuthorizationStatus | String | Text description of the authorization status of the payment transaction. Values include 'Pass' or 'Fail', providing a more detailed status of the authorization process. |
| AuthorizedInSourceFlag | Bool | Flag indicating whether the payment has been authorized in the source system. If true, the payment is authorized; if false, it has not been authorized. |
| AuthorizedOn | Datetime | Date and time when the payment was authorized, indicating when the authorization was processed by the system. |
| InstrumentAssignmentId | Long | Unique identifier for the payment instrument assignment, linking the payment to a specific instrument, such as a credit card or bank account, in the system. |
| OriginalSystemPaymentReference | String | Value that uniquely identifies the payment details from the source application, allowing for integration and tracking of the payment in external systems. |
| PaymentTypeCode | String | Abbreviation that identifies the payment type, such as credit card or bank transfer, used to categorize the payment method. |
| PaymentType | String | Name of the payment method used for the transaction, such as 'Credit Card' or 'Bank Transfer', describing how the payment was made. |
| PaymentSetId | Long | Unique identifier for the group of payments associated with a prepayment on a sales order. This attribute references billing for grouped payments related to prepaid orders. |
| PaymentMethod | String | Name of the billing payment method, such as 'Credit Card', 'Direct Debit', used for collecting the open balance on the invoice. |
| TransactionExtensionId | Long | Identifier for the extension of the payment transaction in the payment system, used for tracking additional payment-related details. |
| UniquePaymentReference | String | Unique reference assigned to the payment for tracking and reconciliation purposes. |
| PaymentMethodCode | Long | Abbreviation that identifies the payment method, used by the application to collect the payment on the invoice and manage payment processing. |
| CardTokenNumber | String | Token number issued by the tokenization service provider corresponding to the card number. This is required for card token and authorization imports. |
| CardFirstName | String | First name of the cardholder, as it appears on the card used for the payment. |
| CardLastName | String | Last name of the cardholder, as it appears on the card used for the payment. |
| CardExpirationDate | String | Expiration date of the card used for the payment, formatted as YYYY/MM/DD, indicating when the card is no longer valid. |
| CardIssuerCode | String | Issuer code of the card, identifying the card network (for example, Visa, MasterCard) or the issuing bank. |
| MaskedCardNumber | String | Masked version of the card number, showing only the last four digits for security purposes. All other digits are replaced with 'X'. The length of the masked card number must match the actual length of the number provided by the card issuer. For example, the masked card number for a Visa is XXXXXXXXXXXX2345. |
| AuthorizationRequestId | String | Unique identifier for the authorization request received from the tokenization service provider, used for tracking authorization attempts and statuses. To import a card authorization other than the Card Token Number, provide either the Card Authorization Request Identifier or the Card Voice Authorization Code. If both are provided, the Card Authorization Request Identifier takes precedence. |
| VoiceAuthorizationCode | String | Code identifying the card authorization. If both the Card Authorization Request Identifier and the Voice Authorization Code are provided, the former takes precedence. |
| PaymentServerOrderNumber | String | Number that identifies the card payment authorized by Oracle Payments Cloud, linking the payment to the specific transaction within Oracle Payments. |
| AuthorizedAmount | Decimal | Amount authorized for the transaction, as received from the tokenization service provider. This value must be provided if the authorization request identifier is included. |
| Finder | String | Method or tool used to locate payment records in the system, allowing efficient retrieval of payments associated with a particular order or transaction. |
| FromDate | Date | Start date when the payment transaction becomes valid, used for tracking the transaction's time period. |
| HeaderId | Long | Unique identifier for the header record of the payment transaction, linking it to the overall sales order or billing record. |
| OrderKey | String | Key used to reference the sales order associated with the payment transaction, ensuring all related payments are tracked under the correct order. |
| OrderNumber | String | Unique number assigned to the sales order, used to reference the order in reports, invoicing, and fulfillment. |
| SourceTransactionNumber | String | Transaction number from the source system, linking the payment transaction to its originating transaction and ensuring consistency in integration. |
| SourceTransactionSystem | String | Source system name from which the payment transaction data originated, providing context for integration with external systems. |
| ToDate | Date | End date when the payment transaction is no longer valid, marking the expiration of the payment in the system and ensuring correct tracking of payment validity. |