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.