SalesOrdersForOrderHublinespayments
Manages detailed payment records associated with sales orders, including methods and schedules.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking payment details to the parent order. This is crucial for maintaining order integrity and tracking payment-related activities across orders. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the payment, enabling tracking of payments at the line level within the sales order. |
| PaymentTransactionId [KEY] | Long | Unique identifier for the payment transaction, helping to link the payment activity with its associated sales order line for reconciliation and audit. |
| Amount | Decimal | Amount authorized for the payment, representing the total funds approved for the transaction. |
| AuthorizationStatusCode | String | Code representing the status of the payment authorization. Possible values include 'Pass' or 'Fail' to indicate whether the payment was successfully authorized. |
| AuthorizationStatus | String | Text description of the authorization status, reflecting whether the payment transaction passed or failed authorization. |
| AuthorizedInSourceFlag | Bool | Flag indicating whether the payment was authorized in the source system. This field is used to track the payment status across different systems. |
| AuthorizedOn | Datetime | Date and time when the payment authorization was processed, marking the approval or rejection time for the transaction. |
| InstrumentAssignmentId | Long | Unique identifier for the instrument assignment, used to track the payment instrument assigned to the transaction. |
| OriginalSystemPaymentReference | String | Reference number from the source system that identifies the original payment transaction, ensuring consistency and proper tracking across systems. |
| PaymentTypeCode | String | Abbreviation identifying the payment type, such as credit card or bank transfer. |
| PaymentType | String | Name of the payment method used for the transaction, indicating whether it was made via credit card, bank transfer, or another payment method. |
| PaymentSetId | Long | Identifier for the group of payments associated with a prepaid sales order. This is important for tracking all payments related to prepayments and their reference to billing. |
| PaymentMethod | String | Name of the payment method used for billing the transaction (for example, card payments or ACH). |
| TransactionExtensionId | Long | Identifier for the extension of the payment transaction in the payment system, used for additional transaction details beyond the basic payment authorization. |
| UniquePaymentReference | String | A unique identifier for the payment, ensuring that each payment transaction is tracked and referenced distinctly. |
| PaymentMethodCode | Long | Abbreviation for the payment method used, referenced for billing purposes in Oracle Fusion Order Management, ensuring payments are properly allocated. |
| CardTokenNumber | String | Token number provided by the tokenization service, used to replace sensitive card information with a secure token, protecting cardholder data. |
| CardFirstName | String | First name of the cardholder associated with the payment card. |
| CardLastName | String | Last name of the cardholder associated with the payment card. |
| CardExpirationDate | String | Expiration date of the payment card in YYYY/MM/DD format, indicating when the card is no longer valid for transactions. |
| CardIssuerCode | String | Code representing the issuer of the payment card, such as 'Visa' or 'MasterCard'. |
| MaskedCardNumber | String | Partially masked card number for security purposes, showing only the last four digits and replacing others with 'X'. This protects sensitive payment information while allowing reference. 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 is XXXXXXXXXXXX2345. |
| AuthorizationRequestId | String | Identifier for the authorization request sent to the tokenization service, used to track the request made to authorize the card. To import a card authorization other than the Card Token Number, provide the Card Authorization Request Identifier or the Card Voice Authorization Code. If both are provided, the Card Authorization Request Identifier takes precedence. |
| VoiceAuthorizationCode | String | Authorization code provided for voice-based authorization, used when a card authorization is conducted via a phone call or manually through a service. To import a card authorization other than the Card Token Number, provide the Card Authorization Request Identifier or the Card Voice Authorization Code. If both are provided, the Card Authorization Request Identifier takes precedence. |
| PaymentServerOrderNumber | String | Order number assigned by Oracle Payments Cloud, identifying the payment transaction in the Oracle payments system. |
| AuthorizedAmount | Decimal | Amount authorized by the tokenization service provider, confirming the amount approved for the transaction. |
| Finder | String | Method or tool used to locate specific payment records in Oracle Fusion Order Management, facilitating quick retrieval of payment data. |
| FromDate | Date | Start date when the payment details become valid or applicable, used to track the payment period. |
| HeaderId | Long | Header ID for the order, used to link the payment details with the overall sales order in Oracle Fusion Order Management. |
| OrderKey | String | Key used to uniquely reference the order associated with the payment, ensuring that all related transactions are grouped correctly. |
| OrderNumber | String | Sales order number used for referencing the order and associated payment activities in reports, invoicing, and fulfillment. |
| SourceTransactionNumber | String | Source transaction number from the originating system, linking the payment to its source transaction and ensuring consistency during system integration. |
| SourceTransactionSystem | String | Source system name where the original payment data was generated, providing insight into external system integration and context. |
| ToDate | Date | End date when the payment details are no longer valid, marking the conclusion of the payment period. |