LineExtractPVO

The Sales Order Lines view object extracts line details from the sales orders, such as line type, item, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.LineExtractPVO

Primary Keys : LineId

Initial Extract Date : LineCreationDate

Incremental Extract Date : LineLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
LineActualShipDate	Date when the item was shipped.
LineCanceledFlag	Indicates whether the sales order line was canceled. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
LineCanceledQty	Canceled quantity.
LineCategoryCode	Code that identifies the transaction category. It's used to organize sales order lines that have similar characteristics into a group. A list of accepted values is defined in the lookup type DOO_LINE_CATEGORY.
LineCompSeqPath	Defines the hierarchical relation of a model. It's derived from BOM table.
LineCreatedBy	User who created the sales order line row.
LineCreationDate	Date when the sales order line row was created.
LineDeltaType	Value that identifies the type of change, such as update, cancel, and so on. Order Management uses this values when processing change order.
LineDisplayLineNumber	Number that the order management work area displays to identify the sales order line.
LineExtendedAmount	Monetary amount of the sales order line.
LineFulfilledQty	Quantity of the item that has been fulfilled.
LineFulfillmentDate	Date when the sales order line was fulfilled.
LineHeaderId	Value that identifies the sales order header associated to the sales order line row. This is a foreign key to the Sales Order Headers view object.
LineId	Value that uniquely identifies the sales order line. This is the primary key of the Sales Order Lines view object.
LineInventoryItemId	Value that identifies the inventory item on the sales order line.
LineInventoryOrganizationId	Value that identifies the inventory organization associated to the inventory item.
LineItemTypeCode	Code that identifies the type of inventory item. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE.
LineLastUpdateDate	Date when the sales order line row was last updated.
LineLastUpdateLogin	Session login associated to the user who most recently updated the sales order line row.
LineLastUpdatedBy	User who most recently updated the sales order line row.
LineLineNumber	Number of the sales order line.
LineLineTypeCode	Code that identifies the type of sales order line. A list of accepted values is defined in the lookup type ORA_DOO_LINE_TYPES for a buy line and ORA_DOO_RETURN_LINE_TYPES for a return line.
LineObjectVersionNumber	Number of times the sales order line row has been updated.
LineOnHold	Indicates whether the sales order line is on hold. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
LineOpenFlag	Indicates whether the sales order line is open. A list of accepted values is defined in the lookup type YES_NO.
LineOrderedQty	Quantity of the item that's ordered or returned.
LineOrderedUom	Code that identifies the unit of measure for the ordered quantity.
LineOrgId	Value that identifies the business unit that sells the sales order line.
LineOrigSysDocumentLineRef	Original reference for the source order line from the source system.
LineOrigSysDocumentRef	Original reference for the source order from the source system.
LineOwnerId	Value that identifies the owner of the sales order line.
LineParentLineId	Value that identifies the parent sales order line. This value describes the sales order line hierarchy for a configured item or kits.
LineReferenceLineId	Value that identifies the previous sales order line. Order Management uses this values when processing change order.
LineRmaDeliveredQty	Quantity of the item that has been delivered for the return line.
LineRootParentLineId	Value that identifies the root parent sales order line. This value describes the sales order line hierarchy for a configured item or kits.
LineScheduleShipDate	Date when the item is scheduled for shipment.
LineShippedQty	Quantity of the item that has been shipped.
LineSourceLineId	Value that identifies the transaction line from the source system.
LineSourceLineNumber	Number of the source order line.
LineSourceOrderId	Value that uniquely identifies the transaction from the source system.
LineSourceOrderNumber	Number of the source order.
LineSourceOrderSystem	Code that identifies the source system that created the source order.
LineSourceOrgId	Value that identifies the business unit for the source order.
LineSourceScheduleId	Value that identifies the transaction line schedule from the source system.
LineSourceScheduleNumber	Number of the source order line schedule.
LineStatusCode	Code that identifies the status of the sales order line.
LineTransformFromLineId	Value that identifies the sales order line from which this particular sales order line is derived.
LineUnitListPrice	Selling price for each unit of the item before applying discounts.
LineUnitSellingPrice	Price that the buyer pays for one unit of the item.