Fulfillment Details
The Fulfillment Details view object that extracts fulfillment details from the fulfillment lines, such as invoicing details, return receipt information, shipping details, and so on.
Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.FulfillLineDetailExtractPVO
Primary Keys : FulfillLineDetailFulfillLineDetailId
Initial Extract Date : FulfillLineDetailCreationDate
Incremental Extract Date : FulfillLineDetailLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
FulfillLineDetailActualDeliveryDate | Date when the carrier delivered the item that the fulfillment line contains. |
FulfillLineDetailAvailabilityShipDate | Ship date for each fulfillment line that the carrier sends to order management. |
FulfillLineDetailBillOfLadingNumber | Number of the bill of lading. It's a carrier's contract and receipt for the goods that the carrier agrees to transport from a specific origin address to a specific destination address. |
FulfillLineDetailBillingTransactionAmount | Amount of the billing transaction. |
FulfillLineDetailBillingTransactionDate | Date when the billing transaction occurred. It appears on the customer invoice and is used to calculate the invoice due date, according to the payment term. |
FulfillLineDetailBillingTransactionNumber | Number of the billing transaction. |
FulfillLineDetailCreatedBy | User who created the fulfillment detail row. |
FulfillLineDetailCreationDate | Date when the fulfillment detail row was created. |
FulfillLineDetailCustomerTrxLineId | Value that identifies the billing transaction line. |
FulfillLineDetailDeliveryName | A separately identifiable collection of goods or materials to be carried under the terms of a single bill of lading. |
FulfillLineDetailDeltaType | Value that identifies the type of change processed on the fulfillment line detail. |
FulfillLineDetailExceptionFlag | Value that identifies whether back-to-back supply isn't available for the fulfillment line. If true, then the available-to-ship date for the line on the back-to-back supply order has gone past the requested date. |
FulfillLineDetailFulfillLineDetailId | Value that uniquely identifies the fulfillment detail. This is the primary key of the Fulfillment Details view object. |
FulfillLineDetailFulfillLineId | Value that identifies the fulfillment line associated to the fulfillment detail row. This is a foreign key to the Fulfillment Lines view object. |
FulfillLineDetailLastUpdateDate | Date when the fulfillment detail row was last updated. |
FulfillLineDetailLastUpdateLogin | Session login associated to the user who most recently updated the fulfillment detail row. |
FulfillLineDetailLastUpdatedBy | User who most recently updated the fulfillment detail row. |
FulfillLineDetailModifiedFlag | Value that identifies the fulfillment line detail has been modified in the version currently submitted. |
FulfillLineDetailObjectVersionNumber | Number of times the fulfillment detail row has been updated. |
FulfillLineDetailQuantity | Quantity of the item that the fulfillment system processed. |
FulfillLineDetailReferenceFlineDetailId | Value that identifies the previous fulfillment line detail. Order Management uses this value when processing change orders. |
FulfillLineDetailRmaReceiptDate | Date when the receiving system received the item. |
FulfillLineDetailRmaReceiptLineNumber | Number of the receipt line. |
FulfillLineDetailRmaReceiptNumber | Number of the receipt. |
FulfillLineDetailRmaReceiptTransactionId | Value that identifies the receiving transaction. |
FulfillLineDetailSecondaryQuantity | Value that identifies the shipped, received, or delivered quantity on the fulfillment line for the item or service in the secondary unit of measure. This attribute is applicable when more than one unit of measure is used to measure and track the item. |
FulfillLineDetailShipmentRequestedQuantity | Value that identifies the requested quantity for the shipment in the shipment advice that inventory management sends to order management. In the context of the shipment tolerance, the flow splits the fulfillment line according to the requested quantity. |
FulfillLineDetailStatus | Code that identifies the status of the fulfillment. |
FulfillLineDetailStatusAsofDate | Date when the transaction occurred. |
FulfillLineDetailTaskType | Type of fulfillment task. |
FulfillLineDetailTrackingNumber | Tracking number for the shipment. |
FulfillLineDetailTradeComplianceCode | Value that identifies the trade compliance screening. |
FulfillLineDetailTradeComplianceExplanation | Value that describes the result of trade compliance screening. |
FulfillLineDetailTradeComplianceResultCode | Value that identifies the result of trade compliance screening. |
FulfillLineDetailTradeComplianceTypeCode | Value that identifies the type of trade compliance screening. |
FulfillLineDetailWaybillNumber | Waybill, Nonnegotiable document describing the contract for transporting cargo, or airbill number for the shipment. |