Jump to

• Request
• Response

Get all work orders

get

/fscmRestApi/resources/11.13.18.05/productionSchedulingPlans/{PlanId}/child/workOrders

Request

Path Parameters

• PlanId(required): integer(int64)
  The value of this parameter could be a hash of the key that is used to uniquely identify the resource item. The client should not generate the hash key value. Instead, the client should query on the collection resource with a filter to navigate to a specific resource item. For example: products?q=InventoryItemId=

Query Parameters

• dependency: string
  This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
  
  Format: <attr1>=<val1>,<attr2>=<value2>
• expand: string
  When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
• fields: string
  This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
  
  Format: ?fields=Attribute1,Attribute2
  
  Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
• finder: string
  Used as a predefined finder to search the collection.
  
  Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
  
  The following are the available finder names and corresponding finder variables
  
  

  • PrimaryKey Find work orders according to the primary key.
    Finder Variables
    • PlanId; integer; Value that uniquely identifies the production schedule.
    • WorkOrderId; integer; Value that uniquely identifies the work order. It's a primary key of the work order.
  • RescheduledInReleaseHorizonFinder Find work orders according to the primary key.
    Finder Variables
    • ReleaseHorizonEndDate; string; Find work orders according to the release horizon end date.
• limit: integer
  This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
• links: string
  This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
  
  Example:
  self,canonical
  
• offset: integer
  Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
• onlyData: boolean
  The resource item payload will be filtered in order to contain only data (no links section, for example).
• orderBy: string
  This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
• q: string
  This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
  
  Format: ?q=expression1;expression2
  
  You can use these queryable attributes to filter this collection resource using the q query parameter:
  

  • ActualEndDate; string; Date and time when the work order operation is no longer effective.
  • ActualStartDate; string; Date and time when the work order operation is actually effective.
  • AssetDescription; string; Description of the asset that the user defines. It can describe the features, characteristics, and so on of the asset.
  • AssetId; integer; Value that uniquely identifies the asset charge. This attribute is read only.
  • AssetNumber; string; Number that uniquely identifies the asset.
  • CompletedQuantity; number; Quantity of primary product completed so far in the work order.
  • CreatedBy; string; User who created the record.
  • CreationDate; string; Date and time when the user created the record.
  • Description; string; Description of the production schedule.
  • EarliestStartDate; string; Date when the work order operation can be requested at the earliest.
  • FirmPlannedFlag; boolean; Contains one of the following values: true or false. If true, then allow Oracle Supply Planning Cloud from suggesting rescheduling and replanning recommendations with respect to the work order. If false, then don't allow Oracle Supply Planning Cloud from suggesting rescheduling and replanning recommendations. This attribute doesn't have a default value.
  • InventoryItemId; integer; Value that uniquely identifies the inventory item.
  • ItemCode; string; Abbreviation that identifies the item.
  • ItemDescription; string; Description of the item that's produced by the work order.
  • LastUpdateDate; string; Date and time when the user most recently updated the record.
  • LastUpdateLogin; string; Login that the user used when updating the document.
  • LastUpdatedBy; string; User who most recently updated the record.
  • MaterialAvailable; string; Contains one of the following values: true or false. If true, then all the material is available for a work order. If false, then the material isn't available for a work order. This attribute doesn't have a default value.
  • OnHoldFlag; boolean; Contains one of the following values: true or false. If true, then the work order is on hold. If false, then the work order isn't on hold. This attribute doesn't have a default value.
  • OrderClass; string; Class of the work order. Valid values include HotOrder, Committed, and Uncommitted.
  • PlanId; integer; Value that uniquely identifies the production schedule.
  • PlannedStartQuantity; number; Quantity of planned work order which should be greater than zero for standard work orders, and can be equal to or greater than zero for nonstandard work orders.
  • PrimaryProductQuantity; number; Quantity planned to be produced for the work order.
  • PrimaryProductRemainingQuantity; number; Quantity remaining to be produced for the work order.
  • RejectedQuantity; number; Total rejected quantity across all operations for the work order.
  • RemainingQuantity; number; Quantity that's remaining.
  • RequestedDate; string; Date when the work order operation is requested.
  • RescheduledFlag; boolean; Contains one of the following values: true or false. If true, then work order is rescheduled. If false, then work order isn't rescheduled. This attribute doesn't have a default value.
  • ReservedQuantity; number; The total quantity of demands reserved to the work order.
  • RoutingCode; string; Abbreviation that identifies the work definition for this work order.
  • ScheduledEndDate; string; Date when the work order is scheduled to complete.
  • ScheduledStartDate; string; Date when the work order is scheduled to start.
  • ScrappedQuantity; number; Total scrapped quantity across all operations for the work order.
  • SelectedForReleaseFlag; boolean; Contains one of the following values: true or false. If true, then work order is selected for release. If false, then work order isn't selected for release. This attribute doesn't have a default value.
  • SerialNumber; string; Number that uniquely identifies the serial that the asset references. This attributes is applied when the item is serial controlled.
  • SupplyPlanSupplyId; integer; Value that uniquely identifies the supply plan for planned order supplies.
  • TargetCompletionDate; string; Date when the work order is targeted to be scheduled. This attribute overrides the need-by date of the work order.
  • UOMCode; string; Abbreviation that identifies the unit of measure for the primary product.
  • UnitOfMeasure; string; Name of the unit of measure.
  • WorkDefinitionId; integer; Value that uniquely identifies the work definition.
  • WorkDefinitionVersionNumber; string; Value that indicates the version of the work definition.
  • WorkMethodCode; string; Abbreviation that identifies the user key to the work method.
  • WorkMethodId; integer; Value that uniquely identifies the work method for which this work definition is applicable.
  • WorkMethodName; string; Name of the work method.
  • WorkOrderId; integer; Value that uniquely identifies the work order. It's a primary key of the work order.
  • WorkOrderNumber; string; Number that uniquely identifies the work order.
  • WorkOrderPriority; number; Value that indicates the value of the work order.
  • WorkOrderStatus; string; Value the indicates the status of the work order.
  • WorkOrderStatusName; string; The work order status.
  • WorkOrderSubTypeCode; string; Abbreviation that identifies the subtype of the work order.
  • WorkOrderSubTypeName; string; Name of the work order subtype.
  • WorkOrderType; string; Type of work order. Valid vales include Production, Maintenance, or EAM work order.
  • WorkOrderTypeCode; string; Abbreviation that identifies the type of the work order.
  • WorkOrderTypeName; string; Name of the work order type.
• totalResults: boolean
  The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".

Header Parameters

• Metadata-Context:
  If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
• REST-Framework-Version:
  The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

Default Response

The following table describes the default response for this task.

Headers

• Metadata-Context(required):
  If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
• REST-Framework-Version(required):
  The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

Body ()

Root Schema : productionSchedulingPlans-workOrders

Type: object

Show Source

• count(required): integer
  The number of resource instances returned in the current range.
• hasMore(required): boolean
  Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
• items: array Items
  Title: Items

  The items in the collection.
• limit(required): integer
  The actual paging size used by the server.
• links(required): array Links
  Title: Links

  The link relations associated with the resource instance.
• offset(required): integer
  The offset value used in the current page.
• totalResults: integer
  The estimated row count when "?totalResults=true", otherwise the count is not included.

{
    "required":[
        "count",
        "hasMore",
        "limit",
        "links",
        "offset"
    ],
    "type":"object",
    "properties":{
        "totalResults":{
            "type":"integer",
            "description":"The estimated row count when \"?totalResults=true\", otherwise the count is not included."
        },
        "offset":{
            "type":"integer",
            "description":"The offset value used in the current page."
        },
        "count":{
            "type":"integer",
            "description":"The number of resource instances returned in the current range."
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false."
        },
        "limit":{
            "type":"integer",
            "description":"The actual paging size used by the server."
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "items":{
            "title":"Items",
            "type":"array",
            "description":"The items in the collection.",
            "items":{
                "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-item-response"
            }
        }
    }
}

Nested Schema : Items

Type: array

Title: Items

The items in the collection.

Show Source

• Array of: object productionSchedulingPlans-workOrders-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The items in the collection.",
    "items":{
        "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : productionSchedulingPlans-workOrders-item-response

Type: object

Show Source

• ActualEndDate: string (date-time)
  Date and time when the work order operation is no longer effective.
• ActualStartDate: string (date-time)
  Date and time when the work order operation is actually effective.
• AssetDescription: string
  Read Only: true

  Maximum Length: 240

  Description of the asset that the user defines. It can describe the features, characteristics, and so on of the asset.
• AssetId: integer (int64)
  Read Only: true

  Value that uniquely identifies the asset charge. This attribute is read only.
• AssetNumber: string
  Read Only: true

  Maximum Length: 80

  Number that uniquely identifies the asset.
• CompletedQuantity: number
  Quantity of primary product completed so far in the work order.
• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User who created the record.
• CreationDate: string (date-time)
  Read Only: true

  Date and time when the user created the record.
• demands: array Demands
  Title: Demands

  Demands and customers pegged to a work order.
• Description: string
  Maximum Length: 500

  Description of the production schedule.
• EarliestStartDate: string (date-time)
  Date when the work order operation can be requested at the earliest.
• FirmPlannedFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then allow Oracle Supply Planning Cloud from suggesting rescheduling and replanning recommendations with respect to the work order. If false, then don't allow Oracle Supply Planning Cloud from suggesting rescheduling and replanning recommendations. This attribute doesn't have a default value.
• InventoryItemId: integer (int64)
  Value that uniquely identifies the inventory item.
• ItemCode: string
  Read Only: true

  Maximum Length: 300

  Abbreviation that identifies the item.
• ItemDescription: string
  Read Only: true

  Maximum Length: 500

  Description of the item that's produced by the work order.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the user most recently updated the record.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who most recently updated the record.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Login that the user used when updating the document.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• MaterialAvailable: string
  Maximum Length: 30

  Contains one of the following values: true or false. If true, then all the material is available for a work order. If false, then the material isn't available for a work order. This attribute doesn't have a default value.
• OnHoldFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then the work order is on hold. If false, then the work order isn't on hold. This attribute doesn't have a default value.
• operations: array Work Order Operations
  Title: Work Order Operations

  The Operations resource manages the operations that are a part of the work definition.
• OrderClass: string
  Maximum Length: 20

  Class of the work order. Valid values include HotOrder, Committed, and Uncommitted.
• PlanId: integer (int64)
  Value that uniquely identifies the production schedule.
• PlannedStartQuantity: number
  Quantity of planned work order which should be greater than zero for standard work orders, and can be equal to or greater than zero for nonstandard work orders.
• PrimaryProductQuantity: number
  Quantity planned to be produced for the work order.
• PrimaryProductRemainingQuantity: number
  Quantity remaining to be produced for the work order.
• RejectedQuantity: number
  Total rejected quantity across all operations for the work order.
• RemainingQuantity: number
  Quantity that's remaining.
• RequestedDate: string (date-time)
  Date when the work order operation is requested.
• RescheduledFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then work order is rescheduled. If false, then work order isn't rescheduled. This attribute doesn't have a default value.
• ReservedQuantity: number
  The total quantity of demands reserved to the work order.
• RoutingCode: string
  Maximum Length: 300

  Abbreviation that identifies the work definition for this work order.
• ScheduledEndDate: string (date-time)
  Date when the work order is scheduled to complete.
• ScheduledStartDate: string (date-time)
  Date when the work order is scheduled to start.
• ScrappedQuantity: number
  Total scrapped quantity across all operations for the work order.
• SelectedForReleaseFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then work order is selected for release. If false, then work order isn't selected for release. This attribute doesn't have a default value.
• SerialNumber: string
  Read Only: true

  Maximum Length: 80

  Number that uniquely identifies the serial that the asset references. This attributes is applied when the item is serial controlled.
• SupplyPlanSupplyId: integer (int64)
  Value that uniquely identifies the supply plan for planned order supplies.
• TargetCompletionDate: string (date-time)
  Date when the work order is targeted to be scheduled. This attribute overrides the need-by date of the work order.
• UnitOfMeasure: string
  Maximum Length: 25

  Name of the unit of measure.
• UOMCode: string
  Maximum Length: 3

  Abbreviation that identifies the unit of measure for the primary product.
• WorkDefinitionId: integer (int64)
  Value that uniquely identifies the work definition.
• WorkDefinitionVersionNumber: string
  Maximum Length: 10

  Value that indicates the version of the work definition.
• WorkMethodCode: string
  Maximum Length: 30

  Abbreviation that identifies the user key to the work method.
• WorkMethodId: integer (int64)
  Value that uniquely identifies the work method for which this work definition is applicable.
• WorkMethodName: string
  Maximum Length: 120

  Name of the work method.
• WorkOrderId: integer (int64)
  Value that uniquely identifies the work order. It's a primary key of the work order.
• WorkOrderNumber: string
  Maximum Length: 300

  Number that uniquely identifies the work order.
• WorkOrderPriority: number
  Value that indicates the value of the work order.
• WorkOrderStatus: string
  Maximum Length: 30

  Value the indicates the status of the work order.
• WorkOrderStatusName: string
  Read Only: true

  Maximum Length: 120

  The work order status.
• WorkOrderSubTypeCode: string
  Maximum Length: 30

  Abbreviation that identifies the subtype of the work order.
• WorkOrderSubTypeName: string
  Maximum Length: 80

  Name of the work order subtype.
• WorkOrderType: string
  Maximum Length: 30

  Type of work order. Valid vales include Production, Maintenance, or EAM work order.
• WorkOrderTypeCode: string
  Maximum Length: 30

  Abbreviation that identifies the type of the work order.
• WorkOrderTypeName: string
  Maximum Length: 80

  Name of the work order type.

{
    "type":"object",
    "properties":{
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the user created the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkMethodName":{
            "maxLength":120,
            "type":"string",
            "description":"Name of the work method.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkDefinitionId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work definition.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "AssetDescription":{
            "maxLength":240,
            "type":"string",
            "description":"Description of the asset that the user defines. It can describe the features, characteristics, and so on of the asset.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderStatus":{
            "maxLength":30,
            "type":"string",
            "description":"Value the indicates the status of the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "ActualStartDate":{
            "type":"string",
            "description":"Date and time when the work order operation is actually effective.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "AssetNumber":{
            "maxLength":80,
            "type":"string",
            "description":"Number that uniquely identifies the asset.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ScheduledStartDate":{
            "type":"string",
            "description":"Date when the work order is scheduled to start.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "MaterialAvailable":{
            "maxLength":30,
            "type":"string",
            "description":"Contains one of the following values: true or false. If true, then all the material is available for a work order. If false, then the material isn't available for a work order. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkOrderSubTypeName":{
            "maxLength":80,
            "type":"string",
            "description":"Name of the work order subtype.",
            "nullable":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "RequestedDate":{
            "type":"string",
            "description":"Date when the work order operation is requested.",
            "format":"date-time",
            "nullable":false,
            "x-queryable":true
        },
        "UOMCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the unit of measure for the primary product.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkOrderTypeName":{
            "maxLength":80,
            "type":"string",
            "description":"Name of the work order type.",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who most recently updated the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderSubTypeCode":{
            "maxLength":30,
            "type":"string",
            "description":"Abbreviation that identifies the subtype of the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "RemainingQuantity":{
            "type":"number",
            "description":"Quantity that's remaining.",
            "nullable":true,
            "x-queryable":true
        },
        "UnitOfMeasure":{
            "maxLength":25,
            "type":"string",
            "description":"Name of the unit of measure.",
            "nullable":true,
            "x-queryable":true
        },
        "ScrappedQuantity":{
            "type":"number",
            "description":"Total scrapped quantity across all operations for the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "SelectedForReleaseFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then work order is selected for release. If false, then work order isn't selected for release. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "InventoryItemId":{
            "type":"integer",
            "description":"Value that uniquely identifies the inventory item.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "OrderClass":{
            "maxLength":20,
            "type":"string",
            "description":"Class of the work order. Valid values include HotOrder, Committed, and Uncommitted.",
            "nullable":true,
            "x-queryable":true
        },
        "TargetCompletionDate":{
            "type":"string",
            "description":"Date when the work order is targeted to be scheduled. This attribute overrides the need-by date of the work order.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "SerialNumber":{
            "maxLength":80,
            "type":"string",
            "description":"Number that uniquely identifies the serial that the asset references. This attributes is applied when the item is serial controlled.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderNumber":{
            "maxLength":300,
            "type":"string",
            "description":"Number that uniquely identifies the work order.",
            "nullable":false,
            "x-queryable":true
        },
        "PrimaryProductQuantity":{
            "type":"number",
            "description":"Quantity planned to be produced for the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkOrderTypeCode":{
            "maxLength":30,
            "type":"string",
            "description":"Abbreviation that identifies the type of the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "AssetId":{
            "type":"integer",
            "description":"Value that uniquely identifies the asset charge. This attribute is read only.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "RescheduledFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then work order is rescheduled. If false, then work order isn't rescheduled. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Login that the user used when updating the document.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ItemCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the item.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Description":{
            "maxLength":500,
            "type":"string",
            "description":"Description of the production schedule.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkOrderType":{
            "maxLength":30,
            "type":"string",
            "description":"Type of work order. Valid vales include Production, Maintenance, or EAM work order.",
            "nullable":false,
            "x-queryable":true
        },
        "CompletedQuantity":{
            "type":"number",
            "description":"Quantity of primary product completed so far in the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "SupplyPlanSupplyId":{
            "type":"integer",
            "description":"Value that uniquely identifies the supply plan for planned order supplies.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ItemDescription":{
            "maxLength":500,
            "type":"string",
            "description":"Description of the item that's produced by the work order.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "OnHoldFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then the work order is on hold. If false, then the work order isn't on hold. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "EarliestStartDate":{
            "type":"string",
            "description":"Date when the work order operation can be requested at the earliest.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "operations":{
            "title":"Work Order Operations",
            "type":"array",
            "description":"The Operations resource manages the operations that are a part of the work definition.",
            "items":{
                "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-operations-item-response"
            }
        },
        "RejectedQuantity":{
            "type":"number",
            "description":"Total rejected quantity across all operations for the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "PrimaryProductRemainingQuantity":{
            "type":"number",
            "description":"Quantity remaining to be produced for the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "ActualEndDate":{
            "type":"string",
            "description":"Date and time when the work order operation is no longer effective.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "RoutingCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the work definition for this work order.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the production schedule.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WorkOrderStatusName":{
            "maxLength":120,
            "type":"string",
            "description":"The work order status.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ReservedQuantity":{
            "type":"number",
            "description":"The total quantity of demands reserved to the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkMethodId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work method for which this work definition is applicable.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WorkMethodCode":{
            "maxLength":30,
            "type":"string",
            "description":"Abbreviation that identifies the user key to the work method.",
            "nullable":true,
            "x-queryable":true
        },
        "ScheduledEndDate":{
            "type":"string",
            "description":"Date when the work order is scheduled to complete.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "FirmPlannedFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then allow Oracle Supply Planning Cloud from suggesting rescheduling and replanning recommendations with respect to the work order. If false, then don't allow Oracle Supply Planning Cloud from suggesting rescheduling and replanning recommendations. This attribute doesn't have a default value.",
            "nullable":false,
            "x-queryable":true
        },
        "WorkDefinitionVersionNumber":{
            "maxLength":10,
            "type":"string",
            "description":"Value that indicates the version of the work definition.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkOrderId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order. It's a primary key of the work order.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WorkOrderPriority":{
            "type":"number",
            "description":"Value that indicates the value of the work order.",
            "nullable":true,
            "x-queryable":true
        },
        "PlannedStartQuantity":{
            "type":"number",
            "description":"Quantity of planned work order which should be greater than zero for standard work orders, and can be equal to or greater than zero for nonstandard work orders.",
            "nullable":false,
            "x-queryable":true
        },
        "demands":{
            "title":"Demands",
            "type":"array",
            "description":"Demands and customers pegged to a work order.",
            "items":{
                "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-demands-item-response"
            }
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the user most recently updated the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Demands

Type: array

Title: Demands

Demands and customers pegged to a work order.

Show Source

• Array of: object productionSchedulingPlans-workOrders-demands-item-response

{
    "title":"Demands",
    "type":"array",
    "description":"Demands and customers pegged to a work order.",
    "items":{
        "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-demands-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : Work Order Operations

Type: array

Title: Work Order Operations

The Operations resource manages the operations that are a part of the work definition.

Show Source

• Array of: object productionSchedulingPlans-workOrders-operations-item-response

{
    "title":"Work Order Operations",
    "type":"array",
    "description":"The Operations resource manages the operations that are a part of the work definition.",
    "items":{
        "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-operations-item-response"
    }
}

Nested Schema : productionSchedulingPlans-workOrders-demands-item-response

Type: object

Show Source

• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User who created the record.
• CreationDate: string (date-time)
  Read Only: true

  Date and time when the user created the record.
• CustomerName: string
  Read Only: true

  Maximum Length: 300

  Name of the customer with the demand.
• CustomerNumber: string
  Read Only: true

  Maximum Length: 240

  Number of the customer with the demand.
• DemandId: integer (int64)
  Read Only: true

  Value that uniquely identifies the demand.
• DemandLineItemNumber: string
  Read Only: true

  Maximum Length: 150

  Number that identifies the line of the demand.
• DemandNumber: string
  Read Only: true

  Maximum Length: 240

  Number that identifies the demand.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the user most recently updated the record.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who most recently updated the record.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Login that the user used when updating the document.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• PlanId: integer (int64)
  Read Only: true

  Value that uniquely identifies the production schedule.
• WorkOrderId: integer (int64)
  Read Only: true

  Value that uniquely identifies the work order. It's a primary key of the work order.

{
    "type":"object",
    "properties":{
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who most recently updated the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the user created the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the production schedule.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "DemandId":{
            "type":"integer",
            "description":"Value that uniquely identifies the demand.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WorkOrderId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order. It's a primary key of the work order.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "CustomerNumber":{
            "maxLength":240,
            "type":"string",
            "description":"Number of the customer with the demand.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "CustomerName":{
            "maxLength":300,
            "type":"string",
            "description":"Name of the customer with the demand.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "DemandLineItemNumber":{
            "maxLength":150,
            "type":"string",
            "description":"Number that identifies the line of the demand.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the user most recently updated the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Login that the user used when updating the document.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "DemandNumber":{
            "maxLength":240,
            "type":"string",
            "description":"Number that identifies the demand.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : link

Type: object

Show Source

• href: string
  Title: hyperlink reference

  The URI to the related resource.
• kind: string
  Title: kind

  Allowed Values: [ "collection", "item", "describe", "other" ]

  The kind of the related resource.
• name: string
  Title: name

  The name of the link to the related resource.
• properties: object properties
• rel: string
  Title: relation

  Allowed Values: [ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]

  The name of the relation to the resource instance. Example: self.

{
    "type":"object",
    "properties":{
        "kind":{
            "title":"kind",
            "type":"string",
            "description":"The kind of the related resource.",
            "enum":[
                "collection",
                "item",
                "describe",
                "other"
            ]
        },
        "rel":{
            "title":"relation",
            "type":"string",
            "description":"The name of the relation to the resource instance.  Example: self.",
            "enum":[
                "self",
                "lov",
                "parent",
                "canonical",
                "child",
                "enclosure",
                "action",
                "custom"
            ]
        },
        "name":{
            "title":"name",
            "type":"string",
            "description":"The name of the link to the related resource."
        },
        "href":{
            "title":"hyperlink reference",
            "type":"string",
            "description":"The URI to the related resource."
        },
        "properties":{
            "type":"object",
            "properties":{
                "changeIndicator":{
                    "type":"string",
                    "description":"Change indicator or the ETag value of the resource instance."
                }
            }
        }
    }
}

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{
    "type":"object",
    "properties":{
        "changeIndicator":{
            "type":"string",
            "description":"Change indicator or the ETag value of the resource instance."
        }
    }
}

Nested Schema : productionSchedulingPlans-workOrders-operations-item-response

Type: object

Show Source

• ActualEndDate: string (date-time)
  Date and time when the work order operation is no longer effective.
• ActualStartDate: string (date-time)
  Date and time when the work order operation is actually effective.
• ChangedByLastRepairFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then object is changed by last repair solve. If false, then object isn't changed by last repair solve. This attribute doesn't have a default value.
• ChangedSinceLastSolveFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then object is changed by last solve. If false, then object isn't changed by last solve. This attribute doesn't have a default value.
• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User who created the record.
• CreationDate: string (date-time)
  Read Only: true

  Date and time when the user created the record.
• DurationResourceCode: string
  Read Only: true

  Maximum Length: 300

  Abbreviation that identifies the resource for the duration resource in an operation.
• DurationResourceId: integer (int64)
  Value that uniquely identifies the duration production resource which is the principal resource.
• DurationResourceSetCode: string
  Maximum Length: 100

  Abbreviation that identifies the resource set of the duration resource.
• EndDate: string (date-time)
  Date and time when the work order operation is no longer effective.
• ExecutionSequence: number
  Execution sequence of the work order operation.
• FirmStatus: string
  Maximum Length: 30

  Status of the operation firm. Valid values include Firm Start, Firm End, and Firm Range. The operation isn't firmed if this isn't specified.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the user most recently updated the record.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who most recently updated the record.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Login that the user used when updating the document.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LotMultipleResourceCode: string
  Read Only: true

  Maximum Length: 300

  Abbreviation that identifies the resource that's the lot multiple resource.
• LotMultipleResourceId: integer (int64)
  Value that uniquely identifies the production resource that's the lot multiple resource.
• LotMultipleResourceSetCode: string
  Maximum Length: 100

  Abbreviation that identifies the resource set with the lot multiple resource.
• OperationCode: string
  Maximum Length: 300

  Abbreviation that identifies the operation.
• operationMaterials: array Operation Materials
  Title: Operation Materials

  The Operation Materials resource manages the items that are either produced or consumed during the manufacturing production process.
• OperationName: string
  Maximum Length: 120

  Name of the operation.
• operationResources: array Operation Resources
  Title: Operation Resources

  The Operation Resources resource manages the production resources that are used for a particular operation.
• OperationSequenceNumber: number
  Number that identifies the execution sequence of the operation.
• OperationType: string
  Maximum Length: 30

  Type of the resource operation, which indicates if it's an in house or and outside supplier operation.
• PlanId: integer (int64)
  Value that uniquely identifies the production schedule.
• ResourceSequenceNumber: integer
  Number that identifies the resource sequence of the operation.
• ScheduledDuration: number
  Duration of schedule of the operation.
• ScheduledDurationUnit: string
  Maximum Length: 30

  Time unit of measure for the schedule duration of the operation. Valid values include second, minutes, hours, and days.
• ScheduledEndDate: string (date-time)
  Date when the work order operation schedule ends.
• ScheduledStartDate: string (date-time)
  Date when the work order operation is scheduled.
• StartDate: string (date-time)
  Date and time when the work order operation is effective.
• Status: string
  Maximum Length: 30

  Status of the operation. Valid values include Open, Active, or Closed.
• SupplierId: integer (int64)
  Value that uniquely identifies the supplier for the operation.
• SupplierName: string
  Maximum Length: 360

  Name of the supplier associated with the operation.
• SupplierSiteCode: string
  Maximum Length: 15

  Abbreviation that identifies the supplier associated with the operation.
• SupplierSiteId: integer (int64)
  Value that uniquely identifies the supplier site for the operation.
• SupplyReservationsFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then the work order contains supply reservations. If false, then work order doesn't contain a supply reservation. The default value is false.
• WorkCenterId: integer (int64)
  Value that uniquely identifies the work center. It's a primary key of the work center.
• WorkDefinitionOperationId: integer (int64)
  Value that uniquely identifies the work definition operation.
• WorkOrderId: integer (int64)
  Value that uniquely identifies the work order. It's a primary key of the work order.
• WorkOrderNumber: string
  Read Only: true

  Maximum Length: 300

  Number that uniquely identifies the work order.
• WorkOrderOperationId: integer (int64)
  Value that uniquely identifies the work order operation. It's a primary key of the work order operation.
• Yield: number
  Yield percent of the work order operation.

{
    "type":"object",
    "properties":{
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the user created the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ScheduledDurationUnit":{
            "maxLength":30,
            "type":"string",
            "description":"Time unit of measure for the schedule duration of the operation. Valid values include second, minutes, hours, and days.",
            "nullable":true,
            "x-queryable":true
        },
        "DurationResourceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the duration production resource which is the principal resource.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WorkCenterId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work center. It's a primary key of the work center.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "OperationCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the operation.",
            "nullable":true,
            "x-queryable":true
        },
        "ActualStartDate":{
            "type":"string",
            "description":"Date and time when the work order operation is actually effective.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "ScheduledDuration":{
            "type":"number",
            "description":"Duration of schedule of the operation.",
            "nullable":true,
            "x-queryable":true
        },
        "StartDate":{
            "type":"string",
            "description":"Date and time when the work order operation is effective.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "LotMultipleResourceSetCode":{
            "maxLength":100,
            "type":"string",
            "description":"Abbreviation that identifies the resource set with the lot multiple resource.",
            "nullable":true,
            "x-queryable":true
        },
        "SupplierSiteCode":{
            "maxLength":15,
            "type":"string",
            "description":"Abbreviation that identifies the supplier associated with the operation.",
            "nullable":true,
            "x-queryable":true
        },
        "ScheduledStartDate":{
            "type":"string",
            "description":"Date when the work order operation is scheduled.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "SupplierSiteId":{
            "type":"integer",
            "description":"Value that uniquely identifies the supplier site for the operation.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "FirmStatus":{
            "maxLength":30,
            "type":"string",
            "description":"Status of the operation firm. Valid values include Firm Start, Firm End, and Firm Range. The operation isn't firmed if this isn't specified.",
            "nullable":true,
            "x-queryable":true
        },
        "LotMultipleResourceCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the resource that's the lot multiple resource.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "operationMaterials":{
            "title":"Operation Materials",
            "type":"array",
            "description":"The Operation Materials resource manages the items that are either produced or consumed during the manufacturing production process.",
            "items":{
                "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-operations-operationMaterials-item-response"
            }
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "WorkDefinitionOperationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work definition operation.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "LotMultipleResourceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the production resource that's the lot multiple resource.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ChangedSinceLastSolveFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then object is changed by last solve. If false, then object isn't changed by last solve. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who most recently updated the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Status":{
            "maxLength":30,
            "type":"string",
            "description":"Status of the operation. Valid values include Open, Active, or Closed.",
            "nullable":false,
            "x-queryable":true
        },
        "DurationResourceSetCode":{
            "maxLength":100,
            "type":"string",
            "description":"Abbreviation that identifies the resource set of the duration resource.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkOrderOperationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order operation. It's a primary key of the work order operation.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ActualEndDate":{
            "type":"string",
            "description":"Date and time when the work order operation is no longer effective.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "ChangedByLastRepairFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then object is changed by last repair solve. If false, then object isn't changed by last repair solve. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "OperationName":{
            "maxLength":120,
            "type":"string",
            "description":"Name of the operation.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the production schedule.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ResourceSequenceNumber":{
            "type":"integer",
            "description":"Number that identifies the resource sequence of the operation.",
            "nullable":false,
            "x-queryable":true
        },
        "SupplyReservationsFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then the work order contains supply reservations. If false, then work order doesn't contain a supply reservation. The default value is false.",
            "nullable":true,
            "x-queryable":true
        },
        "ScheduledEndDate":{
            "type":"string",
            "description":"Date when the work order operation schedule ends.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "EndDate":{
            "type":"string",
            "description":"Date and time when the work order operation is no longer effective.",
            "format":"date-time",
            "nullable":true,
            "x-queryable":true
        },
        "ExecutionSequence":{
            "type":"number",
            "description":"Execution sequence of the work order operation.",
            "nullable":true,
            "x-queryable":true
        },
        "operationResources":{
            "title":"Operation Resources",
            "type":"array",
            "description":"The Operation Resources resource manages the production resources that are used for a particular operation.",
            "items":{
                "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-operations-operationResources-item-response"
            }
        },
        "SupplierId":{
            "type":"integer",
            "description":"Value that uniquely identifies the supplier for the operation.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "WorkOrderNumber":{
            "maxLength":300,
            "type":"string",
            "description":"Number that uniquely identifies the work order.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order. It's a primary key of the work order.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "SupplierName":{
            "maxLength":360,
            "type":"string",
            "description":"Name of the supplier associated with the operation.",
            "nullable":true,
            "x-queryable":true
        },
        "DurationResourceCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the resource for the duration resource in an operation.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "OperationSequenceNumber":{
            "type":"number",
            "description":"Number that identifies the execution sequence of the operation.",
            "nullable":false,
            "x-queryable":true
        },
        "Yield":{
            "type":"number",
            "description":"Yield percent of the work order operation.",
            "nullable":true,
            "x-queryable":true
        },
        "OperationType":{
            "maxLength":30,
            "type":"string",
            "description":"Type of the resource operation, which indicates if it's an in house or and outside supplier operation.",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the user most recently updated the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Login that the user used when updating the document.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : Operation Materials

Type: array

Title: Operation Materials

The Operation Materials resource manages the items that are either produced or consumed during the manufacturing production process.

Show Source

• Array of: object productionSchedulingPlans-workOrders-operations-operationMaterials-item-response

{
    "title":"Operation Materials",
    "type":"array",
    "description":"The Operation Materials resource manages the items that are either produced or consumed during the manufacturing production process.",
    "items":{
        "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-operations-operationMaterials-item-response"
    }
}

Nested Schema : Operation Resources

Type: array

Title: Operation Resources

The Operation Resources resource manages the production resources that are used for a particular operation.

Show Source

• Array of: object productionSchedulingPlans-workOrders-operations-operationResources-item-response

{
    "title":"Operation Resources",
    "type":"array",
    "description":"The Operation Resources resource manages the production resources that are used for a particular operation.",
    "items":{
        "$ref":"#/components/schemas/productionSchedulingPlans-workOrders-operations-operationResources-item-response"
    }
}

Nested Schema : productionSchedulingPlans-workOrders-operations-operationMaterials-item-response

Type: object

Show Source

• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User who created the record.
• CreationDate: string (date-time)
  Read Only: true

  Date and time when the user created the record.
• InventoryItemId: integer (int64)
  Value that uniquely identifies the inventory item.
• IssuedQuantity: number
  Quantity issued on the operation.
• ItemCode: string
  Read Only: true

  Maximum Length: 300

  Abbreviation that identifies the item.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the user most recently updated the record.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who most recently updated the record.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Login that the user used when updating the document.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• MaterialSequenceNumber: number
  Number that indicates the sequence for a component item for a work order operation.
• MaterialType: string
  Maximum Length: 30

  Type of material either produced or consumed by the operation. Valid values include Consumed Item and Produced Item.
• PlanId: integer (int64)
  Value that uniquely identifies the production schedule.
• ProducedQuantity: number
  Quantity issued so far, since partial issues are possible.
• Quantity: number
  Quantity of the material either consumed in the operation or produced from the operation.
• RemainingQuantity: number
  Quantity that's remaining.
• ResourceSequenceNumber: integer
  Number that identifies the resource sequence of the operation material.
• UnitOfMeasure: string
  Read Only: true

  Maximum Length: 25

  Name of the unit of measure.
• UOMCode: string
  Read Only: true

  Maximum Length: 30

  Abbreviation that identifies the unit of measure.
• WorkOrderOperationId: integer (int64)
  Value that uniquely identifies the work order operation. It's a primary key of the work order operation.
• WorkOrderOperationMaterialId: integer (int64)
  Value that uniquely identifies the component item for a work order operation.

{
    "type":"object",
    "properties":{
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who most recently updated the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderOperationMaterialId":{
            "type":"integer",
            "description":"Value that uniquely identifies the component item for a work order operation.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the user created the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderOperationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order operation. It's a primary key of the work order operation.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ItemCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the item.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "UnitOfMeasure":{
            "maxLength":25,
            "type":"string",
            "description":"Name of the unit of measure.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "RemainingQuantity":{
            "type":"number",
            "description":"Quantity that's remaining.",
            "nullable":true,
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the production schedule.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ResourceSequenceNumber":{
            "type":"integer",
            "description":"Number that identifies the resource sequence of the operation material.",
            "nullable":false,
            "x-queryable":true
        },
        "InventoryItemId":{
            "type":"integer",
            "description":"Value that uniquely identifies the inventory item.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "Quantity":{
            "type":"number",
            "description":"Quantity of the material either consumed in the operation or produced from the operation.",
            "nullable":false,
            "x-queryable":true
        },
        "MaterialType":{
            "maxLength":30,
            "type":"string",
            "description":"Type of material either produced or consumed by the operation. Valid values include Consumed Item and Produced Item.",
            "nullable":false,
            "x-queryable":true
        },
        "ProducedQuantity":{
            "type":"number",
            "description":"Quantity issued so far, since partial issues are possible.",
            "nullable":true,
            "x-queryable":true
        },
        "IssuedQuantity":{
            "type":"number",
            "description":"Quantity issued on the operation.",
            "nullable":true,
            "x-queryable":true
        },
        "MaterialSequenceNumber":{
            "type":"number",
            "description":"Number that indicates the sequence for a component item for a work order operation.",
            "nullable":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "UOMCode":{
            "maxLength":30,
            "type":"string",
            "description":"Abbreviation that identifies the unit of measure.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the user most recently updated the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Login that the user used when updating the document.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : productionSchedulingPlans-workOrders-operations-operationResources-item-response

Type: object

Show Source

• AllowOffloading: string
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then allow offloading of the production resource to a viable alternate. If false, then don't allow offloading of the production resource to a viable alternate. This attribute doesn't have a default value.
• CapacityRequired: number
  Number of alternate resource instances. Valid values include Labor or Equipment.
• CreatedBy: string
  Read Only: true

  Maximum Length: 64

  User who created the record.
• CreationDate: string (date-time)
  Read Only: true

  Date and time when the user created the record.
• Duration: number
  Duration of the resource for an operation.
• DurationUnit: string
  Maximum Length: 30

  Time unit of measure for the duration. Valid values include seconds, minutes, hours, and days.
• ExpendedDuration: number
  Duration of the expended resource on the operation.
• LastUpdateDate: string (date-time)
  Read Only: true

  Date and time when the user most recently updated the record.
• LastUpdatedBy: string
  Read Only: true

  Maximum Length: 64

  User who most recently updated the record.
• LastUpdateLogin: string
  Read Only: true

  Maximum Length: 32

  Login that the user used when updating the document.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LotMultiple: number
  Lot multiple of the operation resource.
• OriginalCapacityRequired: number
  Capacity required for the original planned resource.
• OriginalResourceCode: string
  Read Only: true

  Maximum Length: 300

  Abbreviation that identifies the original resource.
• OriginalResourceId: integer (int64)
  Value that uniquely identifies the original resource.
• PlanId: integer (int64)
  Value that uniquely identifies the production schedule.
• PrincipalFlag: boolean
  Maximum Length: 1

  Contains one of the following values: true or false. If true, then the resource is the principal resource among the group of simultaneous resources. If false, then the resource isn't the principal resource. This attribute doesn't have a default value.
• RemainingDuration: number
  Duration that's remaining.
• ResourceActivityName: string
  Maximum Length: 80

  Name of the resource activity.
• ResourceCode: string
  Read Only: true

  Maximum Length: 300

  Abbreviation that identifies the production resource.
• ResourceId: integer (int64)
  Value that uniquely identifies the production resource. It's a primary key of the resource.
• ResourceSequenceNumber: number
  Number that identifies the resource sequence of the operation resource.
• ScheduledFlag: boolean
  Maximum Length: 1

  Contains one of the following values: Yes or No. If Yes, then scheduling schedules the resource and computes the start date and completion dates. If No, then scheduling doesn't schedule the resource, and it sets the start date equal to the completion date. This attribute doesn't have a default value.
• WorkCenterCode: string
  Read Only: true

  Maximum Length: 100

  Abbreviation that identifies the work center.
• WorkCenterId: integer (int64)
  Value that uniquely identifies the work center. It's a primary key of the work center.
• WorkDefinitionOperationResourceId: integer (int64)
  Value that uniquely identifies the work definition operation resource.
• WorkOrderOperationId: integer (int64)
  Value that uniquely identifies the work order operation. It's a primary key of the work order operation.
• WorkOrderOperationResourceId: integer (int64)
  Value that uniquely identifies the work order operation resource. It's a primary key of the work order operation resource.

{
    "type":"object",
    "properties":{
        "CreationDate":{
            "type":"string",
            "description":"Date and time when the user created the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkCenterId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work center. It's a primary key of the work center.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ScheduledFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: Yes or No. If Yes, then scheduling schedules the resource and computes the start date and completion dates. If No, then scheduling doesn't schedule the resource, and it sets the start date equal to the completion date. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "RemainingDuration":{
            "type":"number",
            "description":"Duration that's remaining.",
            "nullable":true,
            "x-queryable":true
        },
        "OriginalCapacityRequired":{
            "type":"number",
            "description":"Capacity required for the original planned resource.",
            "nullable":true,
            "x-queryable":true
        },
        "CapacityRequired":{
            "type":"number",
            "description":"Number of alternate resource instances. Valid values include Labor or Equipment.",
            "nullable":true,
            "x-queryable":true
        },
        "PrincipalFlag":{
            "maxLength":1,
            "type":"boolean",
            "description":"Contains one of the following values: true or false. If true, then the resource is the principal resource among the group of simultaneous resources. If false, then the resource isn't the principal resource. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "WorkCenterCode":{
            "maxLength":100,
            "type":"string",
            "description":"Abbreviation that identifies the work center.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who most recently updated the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ResourceCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the production resource.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkOrderOperationId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order operation. It's a primary key of the work order operation.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "CreatedBy":{
            "maxLength":64,
            "type":"string",
            "description":"User who created the record.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "WorkDefinitionOperationResourceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work definition operation resource.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "PlanId":{
            "type":"integer",
            "description":"Value that uniquely identifies the production schedule.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ResourceSequenceNumber":{
            "type":"number",
            "description":"Number that identifies the resource sequence of the operation resource.",
            "nullable":false,
            "x-queryable":true
        },
        "OriginalResourceCode":{
            "maxLength":300,
            "type":"string",
            "description":"Abbreviation that identifies the original resource.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Duration":{
            "type":"number",
            "description":"Duration of the resource for an operation.",
            "nullable":false,
            "x-queryable":true
        },
        "OriginalResourceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the original resource.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "AllowOffloading":{
            "maxLength":1,
            "type":"string",
            "description":"Contains one of the following values: true or false. If true, then allow offloading of the production resource to a viable alternate. If false, then don't allow offloading of the production resource to a viable alternate. This attribute doesn't have a default value.",
            "nullable":true,
            "x-queryable":true
        },
        "ExpendedDuration":{
            "type":"number",
            "description":"Duration of the expended resource on the operation.",
            "nullable":true,
            "x-queryable":true
        },
        "LotMultiple":{
            "type":"number",
            "description":"Lot multiple of the operation resource.",
            "nullable":true,
            "x-queryable":true
        },
        "ResourceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the production resource. It's a primary key of the resource.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "DurationUnit":{
            "maxLength":30,
            "type":"string",
            "description":"Time unit of measure for the duration. Valid values include seconds, minutes, hours, and days.",
            "nullable":true,
            "x-queryable":true
        },
        "WorkOrderOperationResourceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the work order operation resource. It's a primary key of the work order operation resource.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ResourceActivityName":{
            "maxLength":80,
            "type":"string",
            "description":"Name of the resource activity.",
            "nullable":true,
            "x-queryable":true
        },
        "LastUpdateDate":{
            "type":"string",
            "description":"Date and time when the user most recently updated the record.",
            "format":"date-time",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "LastUpdateLogin":{
            "maxLength":32,
            "type":"string",
            "description":"Login that the user used when updating the document.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Back to Top