SalesOrdersForOrderHublineslineDetails
Records specific details about shipping and billing for each order line, including carrier and payment terms.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking line details to the overall order. This ensures that all line-level information is correctly associated with the sales order. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the order line, allowing tracking of order fulfillment at the line level. |
| ActualDeliveryDate | Datetime | Actual date the item was delivered, used for accurate delivery tracking and reporting in systems like Oracle Fusion Order Management. |
| AvailabilityShipDate | Datetime | The planned or actual date when the item is available for shipment, used to monitor the readiness of goods for delivery. |
| BillOfLadingNumber | String | Unique identifier for the bill of lading document, which provides information about the shipment of goods, often required for logistics and fulfillment tracking. |
| BillingTransactionAmount | Decimal | Amount billed for the specific order line, captured during the billing process. This value is crucial for invoicing and financial reporting. |
| BillingTransactionDate | Datetime | Date when the billing transaction occurred, typically used for accounting and revenue recognition. |
| BillingTransactionNumber | String | Unique identifier for the billing transaction associated with the order line, enabling the linking of financial records and supporting payment processing. |
| CustomerTransactionLineId | Long | Unique identifier for the customer's transaction line, used for reference and tracking in the customer account system. |
| DeliveryName | String | The name of the recipient or customer for the delivery, used for shipping documentation and fulfillment tracking. |
| ExceptionFlag | Bool | Flag indicating whether an exception occurred during the fulfillment process, helping identify and address issues such as delays or missing items. |
| FulfillLineDetailId [KEY] | Long | Unique identifier for the specific detail of the fulfillment line, aiding in precise tracking of the fulfillment process. |
| Quantity | Decimal | Quantity of the item for the order line, ensuring correct stock levels and fulfillment quantities. |
| SecondaryQuantity | Decimal | Secondary unit of measure for the quantity, used when different units of measure (like weight or volume) are involved in the transaction. |
| RMAReceiptDate | Date | Date when the returned goods were received, used for processing returns and managing reverse logistics. |
| RMAReceiptDateTime | Datetime | Timestamp for the return receipt, providing exact timing for returns processing. |
| RMAReceiptLineNumber | String | Unique line number for the RMA receipt, used to identify the specific line of returned goods in the system. |
| RMAReceiptNumber | String | Unique identifier for the RMA receipt, helping to track and manage returned goods within the returns process. |
| RMAReceiptTransactionId | String | Transaction ID for the RMA receipt, enabling seamless integration with returns and inventory systems. |
| StatusCode | String | Code representing the status of the order line (for example, shipped, pending), useful for tracking fulfillment stages and managing customer expectations. |
| Status | String | Description of the current status of the order line, providing detailed information on its fulfillment or processing stage. |
| StatusAsOfDate | Datetime | Date when the status of the order line was last updated, used for tracking progress and ensuring up-to-date reporting. |
| TaskType | String | Type of task or action associated with the order line (for example, fulfillment, shipping), used for workflow and task management in systems like Oracle Fusion. |
| TrackingNumber | String | Tracking number for the shipment, allowing customers and service teams to trace the delivery status in real-time. |
| TradeComplianceCode | String | Code representing the trade compliance classification for the order line, helping ensure the goods meet legal and regulatory standards. |
| TradeComplianceExplanation | String | Description of the trade compliance status or issues related to the order line, helping to clarify any compliance-related concerns. |
| TradeComplianceResultCode | String | Result code indicating the outcome of the trade compliance check for the order line, used for regulatory reporting and managing compliance risks. |
| TradeComplianceTypeCode | String | Code that categorizes the type of trade compliance check performed (for example, export, tariff), supporting legal and regulatory compliance. |
| TradeComplianceType | String | Description of the trade compliance check type, used for tracking the different compliance processes applied to the order. |
| WaybillNumber | String | Number assigned to the waybill, used for tracking shipments and ensuring proper delivery documentation. |
| Finder | String | Method or tool used to locate the specific line details, ensuring easy retrieval of data for reporting and customer service. |
| FromDate | Date | Start date indicating when the order line details become applicable or valid. |
| HeaderId | Long | Unique identifier for the order header, linking the line details to the overall order. |
| OrderKey | String | Unique key referencing the order for better identification and linkage within the system. |
| OrderNumber | String | Unique order number assigned to the sales order, used in reporting, invoicing, and fulfillment tracking. |
| SourceTransactionNumber | String | Transaction number from the source system that links the order line to its originating transaction, ensuring proper integration and traceability. |
| SourceTransactionSystem | String | Name of the source system from which the transaction data originated, providing context for integration with external platforms. |
| ToDate | Date | End date when the order line details are no longer valid, ensuring accurate and time-bound tracking of fulfillment processes. |