Sales Order Lines
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. |