Jump to

• Request
• Response

Create lots

post

/fscmRestApi/resources/11.13.18.05/inventoryBalanceTransactions/{inventoryBalanceTransactionsUniqID}/child/transactionLines/{transactionLinesUniqID}/child/itemLots

Request

Path Parameters

• inventoryBalanceTransactionsUniqID(required): string
  This is the hash key of the attributes which make up the composite key for the Inventory Balance Transactions resource and used to uniquely identify an instance of Inventory Balance Transactions. The client should not generate the hash key value. Instead, the client should query on the Inventory Balance Transactions collection resource in order to navigate to a specific instance of Inventory Balance Transactions to get the hash key.
• transactionLinesUniqID(required): string
  This is the hash key of the attributes which make up the composite key for the Transaction Lines resource and used to uniquely identify an instance of Transaction Lines. The client should not generate the hash key value. Instead, the client should query on the Transaction Lines collection resource in order to navigate to a specific instance of Transaction Lines to get the hash key.

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.

Supported Media Types

• application/json

Request Body - application/json ()

Root Schema : schema

Type: object

Show Source

• Age: number
  Age of the lot.
• dffForItemLots: array Flexfields for Lots
  Title: Flexfields for Lots

  The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.
• ExpirationActionCode: string
  Title: Expiration Action

  Maximum Length: 32

  Abbreviation that identifies the action taken to expire the lot.
• ExpirationActionDate: string (date)
  Title: Expiration Action Date

  Date when the lot expiration action occurred.
• ExpirationActionName: string
  Title: Description

  Maximum Length: 80

  Description of the action taken to expire the lot.
• GradeCode: string
  Title: Grade

  Maximum Length: 150

  Abbreviation that identifies the lot grade.
• HoldDate: string (date)
  Title: Hold Until Date

  Date when the hold will release for the lot.
• itemSerialsForLot: array Serial and Lot Details for Items
  Title: Serial and Lot Details for Items

  The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.
• LotExpirationDate: string (date)
  Title: Lot Expiration Date

  Date when the lot expires.
• LotNumber(required): string
  Title: Lot

  Maximum Length: 80

  Lot number of the item when the warehouse places the item under lot control.
• OriginationDate: string (date)
  Title: Origination Date

  Date when the lot originated.
• OriginationType: string
  Title: Origination Type

  Maximum Length: 30

  Origination type of the lot.
• ParentLotNumber: string
  Title: Parent Lot

  Maximum Length: 80

  Lot number of the parent lot.
• PlaceOfOrigin: string
  Maximum Length: 150

  Place of origin of the lot.
• PrimaryQuantity: number
  Title: New On-Hand Quantity

  Transaction quantity for this lot in the primary unit of measure for the item.
• PrimaryUnitOfMeasure: string
  Title: New On-Hand Quantity UOM

  Maximum Length: 25

  Primary unit of measure for the item in the current organization.
• PrimaryUOMCode: string
  Maximum Length: 3

  Abbreviation that identifies the primary unit of measure for the item in the current organization.
• SecondaryQuantity: number
  Title: New Secondary On-Hand Quantity

  Transaction quantity for this lot in the secondary unit of measure for the item.
• SecondaryUnitOfMeasure: string
  Title: New Secondary On-Hand Quantity UOM

  Maximum Length: 25

  Secondary unit of measure for the item in the current organization.
• SecondaryUOMCode: string
  Maximum Length: 3

  Abbreviation that identifies the secondary unit of measure for the item in the current organization.
• StatusCode: string
  Title: Material Status

  Maximum Length: 80

  Abbreviation that identifies the status of the material that the lot references.
• StatusId: integer (int64)
  Value that uniquely identifies the lot status.
• StatusName: string
  Title: Description

  Maximum Length: 240

  Description of the lot status.
• SupplierLotNumber: string
  Title: Supplier Lot

  Maximum Length: 150

  Supplier lot number.
• TerritoryCode: string
  Maximum Length: 3

  Abbreviation that identifies the territory.
• TerritoryShortName: string
  Maximum Length: 80

  Name of the territory.
• VendorId: integer (int64)
  Value that uniquely identifies the supplier who supplies the material.
• VendorName: string
  Title: Supplier

  Maximum Length: 240

  Name of the supplier who supplies the material.

{
    "required":[
        "LotNumber"
    ],
    "type":"object",
    "properties":{
        "SecondaryUnitOfMeasure":{
            "title":"New Secondary On-Hand Quantity UOM",
            "maxLength":25,
            "type":"string",
            "description":"Secondary unit of measure for the item in the current organization.",
            "nullable":true
        },
        "VendorId":{
            "type":"integer",
            "description":"Value that uniquely identifies the supplier who supplies the material.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            }
        },
        "ParentLotNumber":{
            "title":"Parent Lot",
            "maxLength":80,
            "type":"string",
            "description":"Lot number of the parent lot.",
            "nullable":true
        },
        "TerritoryShortName":{
            "maxLength":80,
            "type":"string",
            "description":"Name of the territory.",
            "nullable":true
        },
        "LotExpirationDate":{
            "title":"Lot Expiration Date",
            "type":"string",
            "description":"Date when the lot expires.",
            "format":"date",
            "nullable":true
        },
        "StatusCode":{
            "title":"Material Status",
            "maxLength":80,
            "type":"string",
            "description":"Abbreviation that identifies the status of the material that the lot references.",
            "nullable":true
        },
        "GradeCode":{
            "title":"Grade",
            "maxLength":150,
            "type":"string",
            "description":"Abbreviation that identifies the lot grade.",
            "nullable":true
        },
        "PlaceOfOrigin":{
            "maxLength":150,
            "type":"string",
            "description":"Place of origin of the lot.",
            "nullable":true
        },
        "SecondaryUOMCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the secondary unit of measure for the item in the current organization.",
            "nullable":true
        },
        "TerritoryCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the territory.",
            "nullable":true
        },
        "OriginationType":{
            "title":"Origination Type",
            "maxLength":30,
            "type":"string",
            "description":"Origination type of the lot.",
            "nullable":true
        },
        "ExpirationActionName":{
            "title":"Description",
            "maxLength":80,
            "type":"string",
            "description":"Description of the action taken to expire the lot.",
            "nullable":true
        },
        "LotNumber":{
            "title":"Lot",
            "maxLength":80,
            "type":"string",
            "description":"Lot number of the item when the warehouse places the item under lot control.",
            "nullable":false
        },
        "Age":{
            "type":"number",
            "description":"Age of the lot.",
            "nullable":true
        },
        "PrimaryQuantity":{
            "title":"New On-Hand Quantity",
            "type":"number",
            "description":"Transaction quantity for this lot in the primary unit of measure for the item.",
            "nullable":true
        },
        "PrimaryUOMCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the primary unit of measure for the item in the current organization.",
            "nullable":true
        },
        "VendorName":{
            "title":"Supplier",
            "maxLength":240,
            "type":"string",
            "description":"Name of the supplier who supplies the material.",
            "nullable":true
        },
        "dffForItemLots":{
            "title":"Flexfields for Lots",
            "type":"array",
            "description":"The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.",
            "items":{
                "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-dffForItemLots-item-post-request"
            },
            "x-cardinality":"1"
        },
        "StatusName":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Description of the lot status.",
            "nullable":true
        },
        "PrimaryUnitOfMeasure":{
            "title":"New On-Hand Quantity UOM",
            "maxLength":25,
            "type":"string",
            "description":"Primary unit of measure for the item in the current organization.",
            "nullable":true
        },
        "SecondaryQuantity":{
            "title":"New Secondary On-Hand Quantity",
            "type":"number",
            "description":"Transaction quantity for this lot in the secondary unit of measure for the item.",
            "nullable":true
        },
        "SupplierLotNumber":{
            "title":"Supplier Lot",
            "maxLength":150,
            "type":"string",
            "description":"Supplier lot number.",
            "nullable":true
        },
        "OriginationDate":{
            "title":"Origination Date",
            "type":"string",
            "description":"Date when the lot originated.",
            "format":"date",
            "nullable":true
        },
        "ExpirationActionDate":{
            "title":"Expiration Action Date",
            "type":"string",
            "description":"Date when the lot expiration action occurred.",
            "format":"date",
            "nullable":true
        },
        "ExpirationActionCode":{
            "title":"Expiration Action",
            "maxLength":32,
            "type":"string",
            "description":"Abbreviation that identifies the action taken to expire the lot.",
            "nullable":true
        },
        "HoldDate":{
            "title":"Hold Until Date",
            "type":"string",
            "description":"Date when the hold will release for the lot.",
            "format":"date",
            "nullable":true
        },
        "StatusId":{
            "type":"integer",
            "description":"Value that uniquely identifies the lot status.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            }
        },
        "itemSerialsForLot":{
            "title":"Serial and Lot Details for Items",
            "type":"array",
            "description":"The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.",
            "items":{
                "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-item-post-request"
            }
        }
    }
}

Nested Schema : Flexfields for Lots

Type: array

Title: Flexfields for Lots

The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.

Show Source

• Array of: object schema

{
    "title":"Flexfields for Lots",
    "type":"array",
    "description":"The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.",
    "items":{
        "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-dffForItemLots-item-post-request"
    },
    "x-cardinality":"1"
}

Nested Schema : Serial and Lot Details for Items

Type: array

Title: Serial and Lot Details for Items

The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.

Show Source

• Array of: object inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-item-post-request

{
    "title":"Serial and Lot Details for Items",
    "type":"array",
    "description":"The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.",
    "items":{
        "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-item-post-request"
    }
}

Nested Schema : schema

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for item lots when an item is under lot control.
• __FLEX_Context_DisplayValue: string
  Title: Context Value

  Descriptive flexfield context display value for item lots when an item is under lot control.
• TxnLotInterfaceId: integer (int64)
  Value that uniquely identifies the lot balance record.

{
    "type":"object",
    "properties":{
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "description":"Descriptive flexfield context display value for item lots when an item is under lot control.",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        },
        "TxnLotInterfaceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the lot balance record.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            }
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":30,
            "type":"string",
            "description":"Descriptive flexfield context name for item lots when an item is under lot control.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        }
    }
}

Nested Schema : inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-item-post-request

Type: object

Show Source

• dffForItemSerialsForLot: array Flexfields for Serials and Lots
  Title: Flexfields for Serials and Lots

  The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.
• FromSerialNumber(required): string
  Title: From Serial Number

  Maximum Length: 80

  Starting serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.
• FromVendorSerialNumber: string
  Title: Supplier Serial Number

  Maximum Length: 80

  Starting supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.
• OriginationDate: string (date)
  Title: Origination Date

  Date when the serial originated.
• StatusCode: string
  Title: Material Status

  Maximum Length: 80

  Abbreviation that identifies the serial status.
• StatusId: integer (int64)
  Value that uniquely identifies the serial status.
• StatusName: string
  Title: Description

  Maximum Length: 240

  Name of the serial status.
• TerritoryCode: string
  Maximum Length: 30

  Value that uniquely identifies the territory.
• TerritoryShortName: string
  Maximum Length: 80

  Name of the territory.
• ToSerialNumber(required): string
  Title: To Serial Number

  Maximum Length: 80

  Ending serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.
• ToVendorSerialNumber: string
  Title: Supplier Serial Number

  Maximum Length: 80

  Ending supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.

{
    "required":[
        "FromSerialNumber",
        "ToSerialNumber"
    ],
    "type":"object",
    "properties":{
        "ToVendorSerialNumber":{
            "title":"Supplier Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Ending supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":true
        },
        "FromSerialNumber":{
            "title":"From Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Starting serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":false
        },
        "FromVendorSerialNumber":{
            "title":"Supplier Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Starting supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":true
        },
        "OriginationDate":{
            "title":"Origination Date",
            "type":"string",
            "description":"Date when the serial originated.",
            "format":"date",
            "nullable":true
        },
        "ToSerialNumber":{
            "title":"To Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Ending serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":false
        },
        "TerritoryCode":{
            "maxLength":30,
            "type":"string",
            "description":"Value that uniquely identifies the territory.",
            "nullable":true
        },
        "StatusId":{
            "type":"integer",
            "description":"Value that uniquely identifies the serial status.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            }
        },
        "StatusName":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Name of the serial status.",
            "nullable":true
        },
        "TerritoryShortName":{
            "maxLength":80,
            "type":"string",
            "description":"Name of the territory.",
            "nullable":true
        },
        "StatusCode":{
            "title":"Material Status",
            "maxLength":80,
            "type":"string",
            "description":"Abbreviation that identifies the serial status.",
            "nullable":true
        },
        "dffForItemSerialsForLot":{
            "title":"Flexfields for Serials and Lots",
            "type":"array",
            "description":"The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.",
            "items":{
                "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-dffForItemSerialsForLot-item-post-request"
            },
            "x-cardinality":"1"
        }
    }
}

Nested Schema : Flexfields for Serials and Lots

Type: array

Title: Flexfields for Serials and Lots

The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.

Show Source

• Array of: object schema

{
    "title":"Flexfields for Serials and Lots",
    "type":"array",
    "description":"The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.",
    "items":{
        "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-dffForItemSerialsForLot-item-post-request"
    },
    "x-cardinality":"1"
}

Nested Schema : schema

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for serials when an item is under serial control.
• __FLEX_Context_DisplayValue: string
  Title: Context Value

  Descriptive flexfield context display value for serials when an item is under serial control.
• SerialTxnInterfaceId: integer (int64)
  Value that uniquely identifies the serial balance.

{
    "type":"object",
    "properties":{
        "SerialTxnInterfaceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the serial balance.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            }
        },
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "description":"Descriptive flexfield context display value for serials when an item is under serial control.",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":30,
            "type":"string",
            "description":"Descriptive flexfield context name for serials when an item is under serial control.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            }
        }
    }
}

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 : inventoryBalanceTransactions-transactionLines-itemLots-item-response

Type: object

Show Source

• Age: number
  Age of the lot.
• dffForItemLots: array Flexfields for Lots
  Title: Flexfields for Lots

  The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.
• ExpirationActionCode: string
  Title: Expiration Action

  Maximum Length: 32

  Abbreviation that identifies the action taken to expire the lot.
• ExpirationActionDate: string (date)
  Title: Expiration Action Date

  Date when the lot expiration action occurred.
• ExpirationActionName: string
  Title: Description

  Maximum Length: 80

  Description of the action taken to expire the lot.
• GradeCode: string
  Title: Grade

  Maximum Length: 150

  Abbreviation that identifies the lot grade.
• HoldDate: string (date)
  Title: Hold Until Date

  Date when the hold will release for the lot.
• itemSerialsForLot: array Serial and Lot Details for Items
  Title: Serial and Lot Details for Items

  The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LotExpirationDate: string (date)
  Title: Lot Expiration Date

  Date when the lot expires.
• LotNumber: string
  Title: Lot

  Maximum Length: 80

  Lot number of the item when the warehouse places the item under lot control.
• OriginationDate: string (date)
  Title: Origination Date

  Date when the lot originated.
• OriginationType: string
  Title: Origination Type

  Maximum Length: 30

  Origination type of the lot.
• ParentLotNumber: string
  Title: Parent Lot

  Maximum Length: 80

  Lot number of the parent lot.
• PlaceOfOrigin: string
  Maximum Length: 150

  Place of origin of the lot.
• PrimaryQuantity: number
  Title: New On-Hand Quantity

  Transaction quantity for this lot in the primary unit of measure for the item.
• PrimaryUnitOfMeasure: string
  Title: New On-Hand Quantity UOM

  Maximum Length: 25

  Primary unit of measure for the item in the current organization.
• PrimaryUOMCode: string
  Maximum Length: 3

  Abbreviation that identifies the primary unit of measure for the item in the current organization.
• SecondaryQuantity: number
  Title: New Secondary On-Hand Quantity

  Transaction quantity for this lot in the secondary unit of measure for the item.
• SecondaryUnitOfMeasure: string
  Title: New Secondary On-Hand Quantity UOM

  Maximum Length: 25

  Secondary unit of measure for the item in the current organization.
• SecondaryUOMCode: string
  Maximum Length: 3

  Abbreviation that identifies the secondary unit of measure for the item in the current organization.
• StatusCode: string
  Title: Material Status

  Maximum Length: 80

  Abbreviation that identifies the status of the material that the lot references.
• StatusId: integer (int64)
  Value that uniquely identifies the lot status.
• StatusName: string
  Title: Description

  Maximum Length: 240

  Description of the lot status.
• SupplierLotNumber: string
  Title: Supplier Lot

  Maximum Length: 150

  Supplier lot number.
• TerritoryCode: string
  Maximum Length: 3

  Abbreviation that identifies the territory.
• TerritoryShortName: string
  Maximum Length: 80

  Name of the territory.
• VendorId: integer (int64)
  Value that uniquely identifies the supplier who supplies the material.
• VendorName: string
  Title: Supplier

  Maximum Length: 240

  Name of the supplier who supplies the material.

{
    "type":"object",
    "properties":{
        "SecondaryUnitOfMeasure":{
            "title":"New Secondary On-Hand Quantity UOM",
            "maxLength":25,
            "type":"string",
            "description":"Secondary unit of measure for the item in the current organization.",
            "nullable":true,
            "x-queryable":true
        },
        "VendorId":{
            "type":"integer",
            "description":"Value that uniquely identifies the supplier who supplies the material.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "ParentLotNumber":{
            "title":"Parent Lot",
            "maxLength":80,
            "type":"string",
            "description":"Lot number of the parent lot.",
            "nullable":true,
            "x-queryable":true
        },
        "TerritoryShortName":{
            "maxLength":80,
            "type":"string",
            "description":"Name of the territory.",
            "nullable":true,
            "x-queryable":true
        },
        "LotExpirationDate":{
            "title":"Lot Expiration Date",
            "type":"string",
            "description":"Date when the lot expires.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "StatusCode":{
            "title":"Material Status",
            "maxLength":80,
            "type":"string",
            "description":"Abbreviation that identifies the status of the material that the lot references.",
            "nullable":true,
            "x-queryable":true
        },
        "GradeCode":{
            "title":"Grade",
            "maxLength":150,
            "type":"string",
            "description":"Abbreviation that identifies the lot grade.",
            "nullable":true,
            "x-queryable":true
        },
        "PlaceOfOrigin":{
            "maxLength":150,
            "type":"string",
            "description":"Place of origin of the lot.",
            "nullable":true,
            "x-queryable":true
        },
        "SecondaryUOMCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the secondary unit of measure for the item in the current organization.",
            "nullable":true,
            "x-queryable":true
        },
        "TerritoryCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the territory.",
            "nullable":true,
            "x-queryable":true
        },
        "OriginationType":{
            "title":"Origination Type",
            "maxLength":30,
            "type":"string",
            "description":"Origination type of the lot.",
            "nullable":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "ExpirationActionName":{
            "title":"Description",
            "maxLength":80,
            "type":"string",
            "description":"Description of the action taken to expire the lot.",
            "nullable":true,
            "x-queryable":true
        },
        "LotNumber":{
            "title":"Lot",
            "maxLength":80,
            "type":"string",
            "description":"Lot number of the item when the warehouse places the item under lot control.",
            "nullable":false,
            "x-queryable":true
        },
        "Age":{
            "type":"number",
            "description":"Age of the lot.",
            "nullable":true,
            "x-queryable":true
        },
        "PrimaryQuantity":{
            "title":"New On-Hand Quantity",
            "type":"number",
            "description":"Transaction quantity for this lot in the primary unit of measure for the item.",
            "nullable":true,
            "x-queryable":true
        },
        "PrimaryUOMCode":{
            "maxLength":3,
            "type":"string",
            "description":"Abbreviation that identifies the primary unit of measure for the item in the current organization.",
            "nullable":true,
            "x-queryable":true
        },
        "VendorName":{
            "title":"Supplier",
            "maxLength":240,
            "type":"string",
            "description":"Name of the supplier who supplies the material.",
            "nullable":true,
            "x-queryable":true
        },
        "dffForItemLots":{
            "title":"Flexfields for Lots",
            "type":"array",
            "description":"The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.",
            "items":{
                "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-dffForItemLots-item-response"
            },
            "x-cardinality":"1"
        },
        "StatusName":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Description of the lot status.",
            "nullable":true,
            "x-queryable":true
        },
        "PrimaryUnitOfMeasure":{
            "title":"New On-Hand Quantity UOM",
            "maxLength":25,
            "type":"string",
            "description":"Primary unit of measure for the item in the current organization.",
            "nullable":true,
            "x-queryable":true
        },
        "SecondaryQuantity":{
            "title":"New Secondary On-Hand Quantity",
            "type":"number",
            "description":"Transaction quantity for this lot in the secondary unit of measure for the item.",
            "nullable":true,
            "x-queryable":true
        },
        "SupplierLotNumber":{
            "title":"Supplier Lot",
            "maxLength":150,
            "type":"string",
            "description":"Supplier lot number.",
            "nullable":true,
            "x-queryable":true
        },
        "OriginationDate":{
            "title":"Origination Date",
            "type":"string",
            "description":"Date when the lot originated.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "ExpirationActionDate":{
            "title":"Expiration Action Date",
            "type":"string",
            "description":"Date when the lot expiration action occurred.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "ExpirationActionCode":{
            "title":"Expiration Action",
            "maxLength":32,
            "type":"string",
            "description":"Abbreviation that identifies the action taken to expire the lot.",
            "nullable":true,
            "x-queryable":true
        },
        "HoldDate":{
            "title":"Hold Until Date",
            "type":"string",
            "description":"Date when the hold will release for the lot.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "StatusId":{
            "type":"integer",
            "description":"Value that uniquely identifies the lot status.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "itemSerialsForLot":{
            "title":"Serial and Lot Details for Items",
            "type":"array",
            "description":"The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.",
            "items":{
                "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-item-response"
            }
        }
    }
}

Nested Schema : Flexfields for Lots

Type: array

Title: Flexfields for Lots

The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.

Show Source

• Array of: object inventoryBalanceTransactions-transactionLines-itemLots-dffForItemLots-item-response

{
    "title":"Flexfields for Lots",
    "type":"array",
    "description":"The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.",
    "items":{
        "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-dffForItemLots-item-response"
    },
    "x-cardinality":"1"
}

Nested Schema : Serial and Lot Details for Items

Type: array

Title: Serial and Lot Details for Items

The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.

Show Source

• Array of: object inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-item-response

{
    "title":"Serial and Lot Details for Items",
    "type":"array",
    "description":"The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.",
    "items":{
        "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-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 : inventoryBalanceTransactions-transactionLines-itemLots-dffForItemLots-item-response

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for item lots when an item is under lot control.
• __FLEX_Context_DisplayValue: string
  Title: Context Value

  Descriptive flexfield context display value for item lots when an item is under lot control.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• TxnLotInterfaceId: integer (int64)
  Value that uniquely identifies the lot balance record.

{
    "type":"object",
    "properties":{
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "description":"Descriptive flexfield context display value for item lots when an item is under lot control.",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        },
        "TxnLotInterfaceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the lot balance record.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":30,
            "type":"string",
            "description":"Descriptive flexfield context name for item lots when an item is under lot control.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "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 : inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-item-response

Type: object

Show Source

• dffForItemSerialsForLot: array Flexfields for Serials and Lots
  Title: Flexfields for Serials and Lots

  The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.
• FromSerialNumber: string
  Title: From Serial Number

  Maximum Length: 80

  Starting serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.
• FromVendorSerialNumber: string
  Title: Supplier Serial Number

  Maximum Length: 80

  Starting supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• OriginationDate: string (date)
  Title: Origination Date

  Date when the serial originated.
• StatusCode: string
  Title: Material Status

  Maximum Length: 80

  Abbreviation that identifies the serial status.
• StatusId: integer (int64)
  Value that uniquely identifies the serial status.
• StatusName: string
  Title: Description

  Maximum Length: 240

  Name of the serial status.
• TerritoryCode: string
  Maximum Length: 30

  Value that uniquely identifies the territory.
• TerritoryShortName: string
  Maximum Length: 80

  Name of the territory.
• ToSerialNumber: string
  Title: To Serial Number

  Maximum Length: 80

  Ending serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.
• ToVendorSerialNumber: string
  Title: Supplier Serial Number

  Maximum Length: 80

  Ending supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.

{
    "type":"object",
    "properties":{
        "ToVendorSerialNumber":{
            "title":"Supplier Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Ending supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":true,
            "x-queryable":true
        },
        "FromSerialNumber":{
            "title":"From Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Starting serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":false,
            "x-queryable":true
        },
        "FromVendorSerialNumber":{
            "title":"Supplier Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Starting supplier serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":true,
            "x-queryable":true
        },
        "OriginationDate":{
            "title":"Origination Date",
            "type":"string",
            "description":"Date when the serial originated.",
            "format":"date",
            "nullable":true,
            "x-queryable":true
        },
        "ToSerialNumber":{
            "title":"To Serial Number",
            "maxLength":80,
            "type":"string",
            "description":"Ending serial number in a range of serial numbers. This attribute is used when the warehouse places the item under lot and serial control.",
            "nullable":false,
            "x-queryable":true
        },
        "TerritoryCode":{
            "maxLength":30,
            "type":"string",
            "description":"Value that uniquely identifies the territory.",
            "nullable":true,
            "x-queryable":true
        },
        "StatusId":{
            "type":"integer",
            "description":"Value that uniquely identifies the serial status.",
            "format":"int64",
            "nullable":true,
            "x-hints":{
                "precision":18
            },
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "StatusName":{
            "title":"Description",
            "maxLength":240,
            "type":"string",
            "description":"Name of the serial status.",
            "nullable":true,
            "x-queryable":true
        },
        "TerritoryShortName":{
            "maxLength":80,
            "type":"string",
            "description":"Name of the territory.",
            "nullable":true,
            "x-queryable":true
        },
        "StatusCode":{
            "title":"Material Status",
            "maxLength":80,
            "type":"string",
            "description":"Abbreviation that identifies the serial status.",
            "nullable":true,
            "x-queryable":true
        },
        "dffForItemSerialsForLot":{
            "title":"Flexfields for Serials and Lots",
            "type":"array",
            "description":"The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.",
            "items":{
                "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-dffForItemSerialsForLot-item-response"
            },
            "x-cardinality":"1"
        }
    }
}

Nested Schema : Flexfields for Serials and Lots

Type: array

Title: Flexfields for Serials and Lots

The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.

Show Source

• Array of: object inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-dffForItemSerialsForLot-item-response

{
    "title":"Flexfields for Serials and Lots",
    "type":"array",
    "description":"The Flexfields for Serials and Lots resource manages descriptive flexfields that contain details about the item when a serial and lot control the item.",
    "items":{
        "$ref":"#/components/schemas/inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-dffForItemSerialsForLot-item-response"
    },
    "x-cardinality":"1"
}

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 : inventoryBalanceTransactions-transactionLines-itemLots-itemSerialsForLot-dffForItemSerialsForLot-item-response

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Value

  Maximum Length: 30

  Descriptive flexfield context name for serials when an item is under serial control.
• __FLEX_Context_DisplayValue: string
  Title: Context Value

  Descriptive flexfield context display value for serials when an item is under serial control.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• SerialTxnInterfaceId: integer (int64)
  Value that uniquely identifies the serial balance.

{
    "type":"object",
    "properties":{
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "SerialTxnInterfaceId":{
            "type":"integer",
            "description":"Value that uniquely identifies the serial balance.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "includeInCompactView":true,
                "precision":18,
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "__FLEX_Context_DisplayValue":{
            "title":"Context Value",
            "type":"string",
            "description":"Descriptive flexfield context display value for serials when an item is under serial control.",
            "nullable":true,
            "x-hints":{
                "updateable":"false",
                "DISPLAYHINT":"Hide",
                "FND_ACFF_IsReadOnly":"true",
                "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context",
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_ListDisplayAttrName":"Name",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "x-queryable":true
        },
        "__FLEX_Context":{
            "title":"Context Value",
            "maxLength":30,
            "type":"string",
            "description":"Descriptive flexfield context name for serials when an item is under serial control.",
            "nullable":true,
            "x-hints":{
                "DISPLAYHINT":"Hide",
                "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT",
                "controlType":"choice",
                "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue",
                "includeInCompactView":true,
                "FND_ACFF_JavaType":"java.lang.String",
                "FND_ACFF_MaximumLength":"1024",
                "FND_ACFF_PreferredDisplayType":"HIDDEN"
            },
            "x-oj":{
                "transform":{
                    "path":"oj-sp/common-util/flex-util",
                    "name":"transformFlexUIHints"
                }
            },
            "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"
    }
}

Links

dffForItemLots

Operation: /fscmRestApi/resources/11.13.18.05/inventoryBalanceTransactions/{inventoryBalanceTransactionsUniqID}/child/transactionLines/{transactionLinesUniqID}/child/itemLots/{itemLotsUniqID}/child/dffForItemLots

Parameters:

• inventoryBalanceTransactionsUniqID: $request.path.inventoryBalanceTransactionsUniqID
• itemLotsUniqID: $request.path.itemLotsUniqID
• transactionLinesUniqID: $request.path.transactionLinesUniqID

The Flexfields for Lots resource manages descriptive flexfields that contain details about the lot.

itemSerialsForLot

Operation: /fscmRestApi/resources/11.13.18.05/inventoryBalanceTransactions/{inventoryBalanceTransactionsUniqID}/child/transactionLines/{transactionLinesUniqID}/child/itemLots/{itemLotsUniqID}/child/itemSerialsForLot

Parameters:

• inventoryBalanceTransactionsUniqID: $request.path.inventoryBalanceTransactionsUniqID
• itemLotsUniqID: $request.path.itemLotsUniqID
• transactionLinesUniqID: $request.path.transactionLinesUniqID

The Serial and Lot Details for Items resource manages details that the inventory balance references when a serial and a lot control the item.

Back to Top