Tracking Lines
The Supply Tracking Lines Extract view object extracts tracking lines for the supply order.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyTrackingLinesExtractPVO
Primary Keys : DosSupplyTrackingLinesPEOTrackingLineId
Initial Extract Date : DosSupplyTrackingLinesPEOCreationDate
Incremental Extract Date : DosSupplyTrackingLinesPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosSupplyTrackingLinesPEOAttributeCategory | Category of the descriptive flexfield for the tracking line. |
| DosSupplyTrackingLinesPEOAttributeChar1 | Descriptive flexfield 1 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar10 | Descriptive flexfield 10 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar11 | Descriptive flexfield 11 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar12 | Descriptive flexfield 12 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar13 | Descriptive flexfield 13 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar14 | Descriptive flexfield 14 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar15 | Descriptive flexfield 15 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar16 | Descriptive flexfield 16 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar17 | Descriptive flexfield 17 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar18 | Descriptive flexfield 18 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar19 | Descriptive flexfield 19 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar2 | Descriptive flexfield 2 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar20 | Descriptive flexfield 20 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar3 | Descriptive flexfield 3 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar4 | Descriptive flexfield 4 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar5 | Descriptive flexfield 5 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar6 | Descriptive flexfield 6 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar7 | Descriptive flexfield 7 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar8 | Descriptive flexfield 8 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeChar9 | Descriptive flexfield 9 for the tracking line. The data type of the flexfield is character. |
| DosSupplyTrackingLinesPEOAttributeDate1 | Descriptive flexfield 1 for the tracking line. The data type of the flexfield is date. |
| DosSupplyTrackingLinesPEOAttributeDate2 | Descriptive flexfield 2 for the tracking line. The data type of the flexfield is date. |
| DosSupplyTrackingLinesPEOAttributeDate3 | Descriptive flexfield 3 for the tracking line. The data type of the flexfield is date. |
| DosSupplyTrackingLinesPEOAttributeDate4 | Descriptive flexfield 4 for the tracking line. The data type of the flexfield is date. |
| DosSupplyTrackingLinesPEOAttributeDate5 | Descriptive flexfield 5 for the tracking line. The data type of the flexfield is date. |
| DosSupplyTrackingLinesPEOAttributeNumber1 | Descriptive flexfield 1 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber10 | Descriptive flexfield 10 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber2 | Descriptive flexfield 2 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber3 | Descriptive flexfield 3 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber4 | Descriptive flexfield 4 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber5 | Descriptive flexfield 5 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber6 | Descriptive flexfield 6 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber7 | Descriptive flexfield 7 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber8 | Descriptive flexfield 8 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeNumber9 | Descriptive flexfield 9 for the tracking line. The data type of the flexfield is number. |
| DosSupplyTrackingLinesPEOAttributeTimestamp1 | Descriptive flexfield 1 for the tracking line. The data type of the flexfield is time stamp. |
| DosSupplyTrackingLinesPEOAttributeTimestamp2 | Descriptive flexfield 2 for the tracking line. The data type of the flexfield is time stamp. |
| DosSupplyTrackingLinesPEOAttributeTimestamp3 | Descriptive flexfield 3 for the tracking line. The data type of the flexfield is time stamp. |
| DosSupplyTrackingLinesPEOAttributeTimestamp4 | Descriptive flexfield 4 for the tracking line. The data type of the flexfield is time stamp. |
| DosSupplyTrackingLinesPEOAttributeTimestamp5 | Descriptive flexfield 5 for the tracking line. The data type of the flexfield is time stamp. |
| DosSupplyTrackingLinesPEOAvailableQuantity | Quantity on the tracking line. It's the quantity that fulfillment has fulfilled for the supply request. |
| DosSupplyTrackingLinesPEOCancelComments | Comments that the person who cancels a tracking line provides when canceling the line. |
| DosSupplyTrackingLinesPEOCancelReasonCode | Abbreviation that identifies the reason to cancel the tracking line. |
| DosSupplyTrackingLinesPEOCanceledFlag | This attribute contains 1 or 0. 1 means to cancel the tracking line. 0 means don't cancel it. No value means 0. 0 is the default value. |
| DosSupplyTrackingLinesPEOChangePendingFlag | This attribute contains 1 or 0. 1 means Supply Orchestration is in the process of fulfilling a change request for the tracking line. 0 means Supply Orchestration isn't processing a change request. No value means 0. 0 is the default value. |
| DosSupplyTrackingLinesPEOChangeRequestActionCode | Abbreviation that identifies the action to do for the change request on the tracking line. |
| DosSupplyTrackingLinesPEOCompensationMode | Specifies whether to compensate for change in demand or in supply. |
| DosSupplyTrackingLinesPEOCreatedBy | Name of the user who created the tracking line. |
| DosSupplyTrackingLinesPEOCreationDate | Date and time when the user created the tracking line. |
| DosSupplyTrackingLinesPEODestinationBuId | Value that uniquely identifies the business unit for the destination organization. |
| DosSupplyTrackingLinesPEODestinationOrganizationCode | Abbreviation that identifies the inventory organization where Supply Orchestration creates supply for the item on the tracking line. You must specify this value when you set up the organization in an Oracle Cloud application. |
| DosSupplyTrackingLinesPEODestinationOrganizationId | Value that uniquely the inventory organization where Supply Orchestration creates supply for the item on the tracking line. You must specify this value when you set up the organization in an Oracle Cloud application. |
| DosSupplyTrackingLinesPEOExceptionFlag | This attribute contains 1 or 0. 1 means the tracking line has an exception. 0 means it doesn't. No value means 0. 0 is the default value. |
| DosSupplyTrackingLinesPEOExecSystemProjectId | Value that uniquely identifies the project in the execution system where Supply Orchestration is using the tracking line to track fulfillment for the supply request. |
| DosSupplyTrackingLinesPEOExecSystemProjectName | Name of the project in the execution system where the tracking line is tracking fulfillment for the supply request. |
| DosSupplyTrackingLinesPEOExecSystemTaskId | Value that uniquely identifies a task in the execution system. The task is tracking fulfillment for the tracking line. |
| DosSupplyTrackingLinesPEOExecSystemTaskName | Name of a task in the execution system. The task is tracking fulfillment for the tracking line. |
| DosSupplyTrackingLinesPEOHeaderId | Value that uniquely identifies the supply header of the supply request. Supply Orchestration creates this value when it creates the supply request. |
| DosSupplyTrackingLinesPEOHoldFlag | This attribute contains 1 or 0. 1 means the tracking line is on hold. 0 means it isn't. No value means 0. 0 is the default value. |
| DosSupplyTrackingLinesPEOInventoryItemId | Value that uniquely identifies the item on the tracking line. |
| DosSupplyTrackingLinesPEOItemRevision | Number that measures the number of times Product Information Management revised the item on the tracking line. |
| DosSupplyTrackingLinesPEOItemType | Type of item. Your set up in the Product Information Management work area defines the type. |
| DosSupplyTrackingLinesPEOLanguage | Language that the tracking line uses. |
| DosSupplyTrackingLinesPEOLastUpdateDate | Date and time when the user most recently updated the tracking line. |
| DosSupplyTrackingLinesPEOLastUpdateLogin | Login that the user used when updating the tracking line. |
| DosSupplyTrackingLinesPEOLastUpdatedBy | User who most recently updated the tracking line. |
| DosSupplyTrackingLinesPEOLineId | Value that uniquely identifies the tracking line. This value is the foreign key to the dos_supply_lines table. |
| DosSupplyTrackingLinesPEONeedByDate | Date when the requester requested to deliver supply to the destination. |
| DosSupplyTrackingLinesPEOObjectVersionNumber | Version of the tracking line. This attribute makes sure no more than one user modifies the same object at the same time. The database increments the version every time it updates the row, then compares the version at the start and at the end of each transaction to determine whether another user updated the row during the current session. |
| DosSupplyTrackingLinesPEOOpenFlag | This attribute contains 1 or 0. 1 means the tracking line is open. 0 means it isn't. No value means 0. 0 is the default value. |
| DosSupplyTrackingLinesPEOParentTrackingLineId | Value that uniquely identifies the parent that Supply Orchestration used to create the tracking line. |
| DosSupplyTrackingLinesPEOPurchaseRequest | Name of the purchase request that requested supply for the item on the tracking line. |
| DosSupplyTrackingLinesPEOQuantity | Quantity of the item on the tracking line. The supply request provides the quantity. |
| DosSupplyTrackingLinesPEOReferenceTrackingLineId | Value that uniquely identifies the tracking line. |
| DosSupplyTrackingLinesPEOReservation | Reservation on the tracking line. |
| DosSupplyTrackingLinesPEOResubmitCount | Number of times that Supply Orchestration resubmitted the tracking line for processing. |
| DosSupplyTrackingLinesPEOSecondaryQuantity | Quantity in the secondary unit of measure for the item on the tracking line. |
| DosSupplyTrackingLinesPEOSecondaryUomCode | Abbreviation that identifies the secondary unit of measure for the item on the tracking line. Your set up in the Product Information Management work area defines the type. |
| DosSupplyTrackingLinesPEOShipmentFlag | This attribute contains 1 or 0. 1 means the tracking line is tracking a shipment request from outside processing. 0 means it isn't. No value means 0. 0 is the default value. |
| DosSupplyTrackingLinesPEOSplitFromTlineId | Value that uniquely identifies the parent tracking line that Supply Orchestration split to create this tracking line. |
| DosSupplyTrackingLinesPEOStatusCode | Abbreviation that identifies the current status of the tracking line. |
| DosSupplyTrackingLinesPEOSupplyOperation | Operation to do on the supply request. The operation processes the item on the tracking line. Values include CREATE, UPDATE, or CANCEL. |
| DosSupplyTrackingLinesPEOSupplyOrderRefLineNumber | Number that identifies the line on the document that's requesting supply. For example, sales order line, work order line, and so on. |
| DosSupplyTrackingLinesPEOSupplyOrderReferenceLineId | Value that uniquely identifies the line on the document that's requesting supply. For example, sales order line, work order line, and so on. |
| DosSupplyTrackingLinesPEOSupplySet | Name of a group of tracking lines that Supply Orchestration processes together in the supply order. |
| DosSupplyTrackingLinesPEOSupplySourceSystem | Supply application where Supply Orchestration creates supply. Values include INV, WIE, POR, and so on. |
| DosSupplyTrackingLinesPEOSupplyType | Type of supply that the source system is requesting. The ORA_DOS_SUPPLY_ORDER_TYPE lookup contains the values that you can use for this attribute. For example, BUY, MAKE, or TRANSFER. |
| DosSupplyTrackingLinesPEOTerminatedFlag | This attribute contains 1 or 0. 1 means Supply Orchestration stopped the tracking line from tracking fulfillment. 0 means it didn't. No value means 0. 0 is the default value. |
| DosSupplyTrackingLinesPEOTrackingLineId | Value that uniquely identifies the tracking line. Supply Orchestration creates this value when it creates the tracking line. It is the primary key for the tracking line. |
| DosSupplyTrackingLinesPEOTrackingLineNumber | Number that identifies the tracking line in the supply order. |
| DosSupplyTrackingLinesPEOUomCode | Abbreviation that identifies the unit of measure for the item on the tracking line. The supply request sends this value to Supply Orchestration. |