Make Orders
The Supply Make Order Details Extract view object extracts details from the make order.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyMakeOrderDetailsExtractPVO
Primary Keys : DosMakeOrderDetailsPEOSupplyMakeDetailsId
Initial Extract Date : DosMakeOrderDetailsPEOCreationDate
Incremental Extract Date : DosMakeOrderDetailsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosMakeOrderDetailsPEOAccountingClassCode | Abbreviation that identifies the accounting class of the make details. |
| DosMakeOrderDetailsPEOAllowExplosionFlag | This attribute contains 1 or 0. 1 means to use the work definition when creating the work order operations, resources, and operation material. 0 means don't use it. No value means 0. 0 is the default value. |
| DosMakeOrderDetailsPEOAltBomDesignator | Designator for the alternative bill of materials for the work order. |
| DosMakeOrderDetailsPEOAltRoutingDesignator | Designator for the alternative routing for the work order. |
| DosMakeOrderDetailsPEOBomRevisionDate | Date when Supply Orchestration most recently revised the bill of materials. |
| DosMakeOrderDetailsPEOBuildSequence | Sequence to use when building the item that the work order specifies. |
| DosMakeOrderDetailsPEOChangeSupplyOperation | Operation to perform for the primary supply when change occurs in demand. |
| DosMakeOrderDetailsPEOChargeAcctId | Value that uniquely identifies the charge account for the work order. |
| DosMakeOrderDetailsPEOCreatedBy | Name of the user who created the make details. |
| DosMakeOrderDetailsPEOCreationDate | Date and time when the user created the make details. |
| DosMakeOrderDetailsPEODeliverToSubinventory | Subinventory that contains finished inventory for jobs that are in process. |
| DosMakeOrderDetailsPEODemandClass | Abbreviation that identifies the demand class of the work order. |
| DosMakeOrderDetailsPEOExecSystemComplLoctrCode | Abbreviation that identifies the completion locator of the work order. |
| DosMakeOrderDetailsPEOFirmPlannedFlag | This attribute contains 1 or 0. 1 means that rescheduling the plan is firm for the make details. 0 means it isn't. No value means 0. 0 is the default value. |
| DosMakeOrderDetailsPEOGroupId | Value that uniquely identifies the group to use in manufacturing when fulfilling the items on the make order. |
| DosMakeOrderDetailsPEOLastUpdateDate | Date and time when the user most recently updated the make details. |
| DosMakeOrderDetailsPEOLastUpdateLogin | Login that the user used when updating the make details. |
| DosMakeOrderDetailsPEOLastUpdatedBy | User who most recently updated the make details. |
| DosMakeOrderDetailsPEOLoadType | Type of job to use when planning the make details. 1 means to create a standard, discrete job. 3 means to update a standard or nonstandard discrete job. 4 means to create a nonstandard, discrete job. If this attribute doesn't contain a value, then an error will occur. |
| DosMakeOrderDetailsPEONeedByDate | Date when fulfillment needs the work order. |
| DosMakeOrderDetailsPEONetQuantity | Net quantity or completed quantity of the work order. |
| DosMakeOrderDetailsPEONetQuantityUomCode | Abbreviation that uniquely identifies the unit of measure for the net quantity. |
| DosMakeOrderDetailsPEOObjectVersionNumber | Version of the make details. 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. |
| DosMakeOrderDetailsPEOPrimaryDocQuantity | Primary quantity of the document of the work order. |
| DosMakeOrderDetailsPEOPrimaryDocQuantityUom | Unit of measure for the primary quantity of the document of the work order. |
| DosMakeOrderDetailsPEORoutingRevisionDate | Date when the routing revision occurs for the work order. |
| DosMakeOrderDetailsPEOScheduleGrpId | Value that uniquely identifies the schedule group for the work order. |
| DosMakeOrderDetailsPEOSchedulingMethod | Specifies to schedule the work order according to work definition data or manually. |
| DosMakeOrderDetailsPEOSourceSystemId | Value that uniquely identifies the source system. If the source system type is INTERNAL, then this attribute stores the value. If it's EXTERNAL, then Trading Community Architecture stores the value in the APPLICATION_ID column of the FND_APPLICATION_ID table, and the ORIG_SYSTEM_ID column of the HZ_ORIG_SYSTEMS_VL table. |
| DosMakeOrderDetailsPEOSourceSystemType | Type of source system. Values include INTERNAL or EXTERNAL. The WIE_SOURCE_SYSTEM_TYPE lookup contains the values that you can use for this attribute. |
| DosMakeOrderDetailsPEOSupplyMakeDetailsId | Value that uniquely identifies supply details for the make order. |
| DosMakeOrderDetailsPEOTrackingLineId | Value that uniquely identifies the tracking line. |
| DosMakeOrderDetailsPEOWipQty | Quantity of the work that is in process. Manufacturing provides the value through a fulfillment task. Change management uses this value in a dynamic service rule to determine whether to update the work order. |
| DosMakeOrderDetailsPEOWorkDefinitionAsOfDate | Date that Supply Orchestration automatically uses to identify the work definition. Supply Orchestration uses this attribute when the user doesn't know the exact work definition to use. |
| DosMakeOrderDetailsPEOWorkDefinitionId | Value that uniquely identifies the work definition. |
| DosMakeOrderDetailsPEOWorkDefinitionName | Name of the work definition. |
| DosMakeOrderDetailsPEOWorkMethodCode | Abbreviation that uniquely identifies the work method for the work order. |
| DosMakeOrderDetailsPEOWorkOrderCompletionDate | Scheduled ship date that the payload from global order promising provides. Planning uses it to provide the start date or completion date of the work order. The completion date and the need by date might be different. |
| DosMakeOrderDetailsPEOWorkOrderDescription | Job description of the work that's in process. Planning provides this value for job requests that are in work in process. |
| DosMakeOrderDetailsPEOWorkOrderId | Value that uniquely identifies the work order. |
| DosMakeOrderDetailsPEOWorkOrderNumber | Number that identifies the work order. The work method or plant controls the value. |
| DosMakeOrderDetailsPEOWorkOrderStartDate | Expected start date for the work order. |
| DosMakeOrderDetailsPEOWorkOrderStatusId | Value that uniquely identifies the status of the work order. |
| DosMakeOrderDetailsPEOWorkOrderSubType | Type of work to perform for the work order, such as standard production, prototype, repair, and so on. |
| DosMakeOrderDetailsPEOWorkOrderType | Specifies production as standard or nonstandard according to the work method. |
| DosMakeOrderDetailsPEOWorkProcessName | Name of the process that fulfills the work order. |