Vinculum Stock API

API to retrieve or manipulate Stock related information.

OpenAPI Specification

vinculum-stock-api-openapi.yml Raw ↑
swagger: '2.0'
info:
  title: Vinculum Advance Shipping Notice Stock API
  description: API to retrieve or manipulate ASN related information.
host: erp.vineretail.com
tags:
- name: Stock
  description: API to retrieve or manipulate Stock related information.
paths:
  /RestWS/api/eretail/v2/stock/updateInventory:
    post:
      tags:
      - Stock
      summary: Max no.of Lines/hit:100 API For Updating Inventory(Hit Quota 40/5 min)
      consumes:
      - application/x-www-form-urlencoded
      produces:
      - application/json
      parameters:
      - in: formData
        name: RequestBody
        type: string
        description: <table class="table-style-three"><tbody><tr><tr align="center"><td style="vertical-align:middle" width='100'><strong>Field Name </strong></td><td style="vertical-align:middle" width='100'><strong>Data Type </strong></td><td style="vertical-align:middle" width='100'><strong>Mandatory </strong></td><td style="vertical-align:middle" width='300'><strong>Description </strong></td></tr><tr align="center"><td style="vertical-align:middle">skuCode</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Skucode</td></tr><tr align="center"><td style="vertical-align:middle">qty</td><td style="vertical-align:middle">Varchar(10)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Quantity</td></tr><tr align="center"><td style="vertical-align:middle">bin</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Inventory bin(Possible Value for bin is GOOD.)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_01</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_02</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_03</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_04</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_05</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_06</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_07</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">reason</td><td style="vertical-align:middle">Varchar(200)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Possible Value for reason is Misc.</td></tr><tr align="center"><td style="vertical-align:middle">mode</td><td style="vertical-align:middle">Varchar(10)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Possible Value for mode is Increase or Decrease or New.</td></tr><tr align="center"><td style="vertical-align:middle">location</td><td style="vertical-align:middle">Varchar(3)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">locCode</td></tr><tr align="center"><td style="vertical-align:middle">operationOn</td><td style="vertical-align:middle">Varchar</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Can be Free Qty and by default SOH.</td></tr><tr align="center"><td style="vertical-align:middle">remarks</td><td style="vertical-align:middle">Varchar(1000)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Possible Value for remarks is Misc</td></tr><tr align="center"><td style="vertical-align:middle">udf1</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf2</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf3</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf4</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf5</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">lpn</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">LPN</td></tr><tr align="center"><td style="vertical-align:middle" colspan=4 ><b>Additional Information</b></td></tr><tr align="left"><td style="vertical-align:middle" colspan=4 >Max Allowance - 100 inventoryList at a time.</td></tr><tr><td  colspan=5> <b>Case- </b><br/> <b>{</br>&nbsp;&nbsp;"inventoryList":[{</br>&nbsp;&nbsp;&nbsp;&nbsp;"skuCode":"YOCL0014",</br>&nbsp;&nbsp;&nbsp;&nbsp;"qty":1,</br>&nbsp;&nbsp;&nbsp;&nbsp;"bin":"POSBIN",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lottable_01":"123",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lottable_02":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lottable_03":"10/07/2018",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lottable_04":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lottable_05":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lottable_06":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lottable_07":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"reason":"MISC",</br>&nbsp;&nbsp;&nbsp;&nbsp;"mode":"Decrease",</br>&nbsp;&nbsp;&nbsp;&nbsp;"location":"NWB",</br>&nbsp;&nbsp;&nbsp;&nbsp;"operationOn":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"remarks":"adjusted qty",</br>&nbsp;&nbsp;&nbsp;&nbsp;"udf1":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"udf2":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"udf3":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"udf4":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"udf5":"",</br>&nbsp;&nbsp;&nbsp;&nbsp;"lpn":""</br>&nbsp;&nbsp;}]</br>} </tr></tbody></table><p>&nbsp;</p><br/>
        required: true
      - in: formData
        name: ApiOwner
        type: string
        description: This Field Will Be Used To Send API Owner
        required: true
      - in: formData
        name: ApiKey
        type: string
        description: This is the API Key
        required: true
      responses:
        200:
          description: <table border='1'width='672'>  <h1  style="color:#FFFF00;">API Generic Error Codes</h1><tbody><tr align="center"><td style="vertical-align:middle" width='167'><p><strong>Response Code </strong></p></td><td style="vertical-align:middle" colspan='2' width='171'><p><strong> Response Message </strong></p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>422</p></td><td style="vertical-align:middle" width='167'><p>Invalid Location</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>503</p></td><td style="vertical-align:middle" width='167'><p>UniqueKey is mandatory and must be unique within the request.</p></td><tr align="center"><td style="vertical-align:middle" width='167'><p>505</p></td><td style="vertical-align:middle" width='167'><p>Too many orders in a single request.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3052</p></td><td style="vertical-align:middle" width='167'><p>skuCode is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3053</p></td><td style="vertical-align:middle" width='167'><p>qty is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3054</p></td><td style="vertical-align:middle" width='167'><p>qty can't be negative.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3057</p></td><td style="vertical-align:middle" width='167'><p>reason is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3050</p></td><td style="vertical-align:middle" width='167'><p>location is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3051</p></td><td style="vertical-align:middle" width='167'><p>No Access for given location</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3060</p></td><td style="vertical-align:middle" width='167'><p>Possible Value for mode is Increase or Decrease or New</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3061</p></td><td style="vertical-align:middle" width='167'><p>qty can't be greater than 99999</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3063</p></td><td style="vertical-align:middle" width='167'><p>qty can be any decimal value</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3064</p></td><td style="vertical-align:middle" width='167'><p>Multiple Ext Loc Code Found</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3065</p></td><td style="vertical-align:middle" width='167'><p>lottable_02 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3066</p></td><td style="vertical-align:middle" width='167'><p>lottable_03 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3067</p></td><td style="vertical-align:middle" width='167'><p>lottable_04 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>6001</p></td><td style="vertical-align:middle" width='167'><p>Default Good bin for location [ ** ] is not found in System</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>9001</p></td><td style="vertical-align:middle" width='167'><p>reason [ ** ] not found in ERP</p></td></tr><tr><td style="vertical-align:middle" colspan=5> <b>Case 1- When Single Inventory Update:<br/> {<br/> &nbsp;"responsecode":"0",</br>&nbsp;"responseMessage":"Success"<br/>&nbsp;"requestStatus":{</br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"uniqueKey":"TESTAM0018",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"requestKey":"TESTAM0018",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"outputKey":null,<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"status":"Error",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"errorDesc":"SKU Not Found."<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br/><br/>}</b><br/><br/> <b>Case 2- When Multiple Inventory Update:<br/>{<br/> &nbsp;"responseCode":0,</br>&nbsp;"responseMessage":"Success",<br/>&nbsp;"requestId":"lsdfjl9734jls834ojsdljfsjsdfssdfdj"<br/>&nbsp;}</b><br/><br/></tbody></table>
  /RestWS/api/eretail/v3/stock/updateInventory:
    post:
      tags:
      - Stock
      summary: Max no.of Lines/hit:100 API For Updating Inventory(Hit Quota 40/5 min)
      consumes:
      - application/json
      produces:
      - application/json
      parameters:
      - in: header
        name: ApiOwner
        required: true
        type: string
        description: API Owner.
      - in: header
        name: ApiKey
        required: true
        type: string
        description: API Key.
      - in: body
        name: UpdateInventoryJSON
        description: <table class="table-style-three"><tbody><tr><tr align="center"><td style="vertical-align:middle" width='100'><strong>Field Name </strong></td><td style="vertical-align:middle" width='100'><strong>Data Type </strong></td><td style="vertical-align:middle" width='100'><strong>Mandatory </strong></td><td style="vertical-align:middle" width='300'><strong>Description </strong></td></tr><tr align="center"><td style="vertical-align:middle">skuCode</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Skucode</td></tr><tr align="center"><td style="vertical-align:middle">qty</td><td style="vertical-align:middle">Decimal(20,3)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Quantity</td></tr><tr align="center"><td style="vertical-align:middle">bin</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Inventory bin(Possible Value for bin is GOOD.)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_01</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_02</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_03</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_04</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields </td></tr><tr align="center"><td style="vertical-align:middle">lottable_05</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_06</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_07</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">reason</td><td style="vertical-align:middle">Varchar(200)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Possible Value for reason is Misc.</td></tr><tr align="center"><td style="vertical-align:middle">mode</td><td style="vertical-align:middle">Varchar(10)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Possible Value for mode is Increase or Decrease or New.</td></tr><tr align="center"><td style="vertical-align:middle">location</td><td style="vertical-align:middle">Varchar(3)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">locCode</td></tr><tr align="center"><td style="vertical-align:middle">operationOn</td><td style="vertical-align:middle">Varchar</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Can be Free Qty and by default SOH.</td></tr><tr align="center"><td style="vertical-align:middle">remarks</td><td style="vertical-align:middle">Varchar(1000)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Possible Value for remarks is Misc</td></tr><tr align="center"><td style="vertical-align:middle">udf1</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf2</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf3</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf4</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf5</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">lpn</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">LPN</td></tr><tr align="center"><td style="vertical-align:middle" colspan=4 ><b>Additional Information</b></td></tr><tr align="left"><td style="vertical-align:middle" colspan=4 >Max Allowance - 100 inventoryList at a time.</td></tr><tr><td  colspan=5> <b>Case- </b><br/>
        schema:
          $ref: '#/definitions/updateInventoryModelV3'
      responses:
        200:
          description: <table border='1'width='672'>  <h1  style="color:#FFFF00;">API Generic Error Codes</h1><tbody><tr align="center"><td style="vertical-align:middle" width='167'><p><strong>Response Code </strong></p></td><td style="vertical-align:middle" colspan='2' width='171'><p><strong> Response Message </strong></p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>422</p></td><td style="vertical-align:middle" width='167'><p>Invalid Location</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>503</p></td><td style="vertical-align:middle" width='167'><p>UniqueKey is mandatory and must be unique within the request.</p></td><tr align="center"><td style="vertical-align:middle" width='167'><p>505</p></td><td style="vertical-align:middle" width='167'><p>Too many orders in a single request.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3052</p></td><td style="vertical-align:middle" width='167'><p>skuCode is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3053</p></td><td style="vertical-align:middle" width='167'><p>qty is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3054</p></td><td style="vertical-align:middle" width='167'><p>qty can't be negative.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3057</p></td><td style="vertical-align:middle" width='167'><p>reason is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3050</p></td><td style="vertical-align:middle" width='167'><p>location is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3051</p></td><td style="vertical-align:middle" width='167'><p>No Access for given location</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3060</p></td><td style="vertical-align:middle" width='167'><p>Possible Value for mode is Increase or Decrease or New</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3061</p></td><td style="vertical-align:middle" width='167'><p>qty can't be greater than 99999</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3063</p></td><td style="vertical-align:middle" width='167'><p>qty can be any decimal value</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3064</p></td><td style="vertical-align:middle" width='167'><p>Multiple Ext Loc Code Found</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3065</p></td><td style="vertical-align:middle" width='167'><p>lottable_02 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3066</p></td><td style="vertical-align:middle" width='167'><p>lottable_03 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3067</p></td><td style="vertical-align:middle" width='167'><p>lottable_04 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>6001</p></td><td style="vertical-align:middle" width='167'><p>Default Good bin for location [ ** ] is not found in System</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>9001</p></td><td style="vertical-align:middle" width='167'><p>reason [ ** ] not found in ERP</p></td></tr><tr><td style="vertical-align:middle" colspan=5>
  /RestWS/api/eretail/v4/stock/updateInventory:
    post:
      tags:
      - Stock
      summary: Max no.of Lines/hit:100 API For Updating Inventory(Hit Quota 40/5 min)
      consumes:
      - application/json
      produces:
      - application/json
      parameters:
      - in: header
        name: ApiKey
        required: true
        type: string
        description: API Key.
      - in: header
        name: DbId
        required: true
        type: string
        description: DB Identifier.
      - in: body
        name: UpdateInventoryJSON
        description: <table><tr align="center" ><td width="100" style="color:#ec0c0c !important;font-size:16px !important;"><strong>Beta Version (Case Pack Compatible)</strong></td></tr></table><table class="table-style-three"><tbody><tr><tr align="center"><td style="vertical-align:middle" width='100'><strong>Field Name </strong></td><td style="vertical-align:middle" width='100'><strong>Data Type </strong></td><td style="vertical-align:middle" width='100'><strong>Mandatory </strong></td><td style="vertical-align:middle" width='300'><strong>Description </strong></td></tr><tr align="center"><td style="vertical-align:middle">skuCode</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Skucode</td></tr><tr align="center"><td style="vertical-align:middle">uomQty</td><td style="vertical-align:middle">Varchar(10)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">UOM Quantity</td></tr><tr align="center"><td style="vertical-align:middle">uom</td><td style="vertical-align:middle">Varchar(20)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">UOM</td></tr><tr align="center"><td style="vertical-align:middle">conversion</td><td style="vertical-align:middle">Int(11)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">CaseSize</td></tr><tr align="center"><td style="vertical-align:middle">bin</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Inventory bin</td></tr><tr align="center"><td style="vertical-align:middle">lpn</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">LPN</td></tr><tr align="center"><td style="vertical-align:middle">lottable_01</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_02</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_03</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_04</td><td style="vertical-align:middle">Date</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields (DD/MM/YYYY)</td></tr><tr align="center"><td style="vertical-align:middle">lottable_05</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_06</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">lottable_07</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot attribute fields</td></tr><tr align="center"><td style="vertical-align:middle">reason</td><td style="vertical-align:middle">Varchar(200)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Possible Value for reason is Misc.</td></tr><tr align="center"><td style="vertical-align:middle">mode</td><td style="vertical-align:middle">Varchar(10)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">Possible Value for mode is Increase or Decrease or New.</td></tr><tr align="center"><td style="vertical-align:middle">location</td><td style="vertical-align:middle">Varchar(3)</td><td style="vertical-align:middle">Mandatory</td><td style="vertical-align:middle">locCode</td></tr><tr align="center"><td style="vertical-align:middle">operationOn</td><td style="vertical-align:middle">Varchar</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Can be Free Qty and by default SOH.</td></tr><tr align="center"><td style="vertical-align:middle">remarks</td><td style="vertical-align:middle">Varchar(1000)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Possible Value for remarks is Misc</td></tr><tr align="center"><td style="vertical-align:middle">udf1</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf2</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf3</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf4</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">udf5</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">user defined field</td></tr><tr align="center"><td style="vertical-align:middle">lotNo</td><td style="vertical-align:middle">Varchar(50)</td><td style="vertical-align:middle">Optional</td><td style="vertical-align:middle">Lot No</td></tr></tbody></table>
        schema:
          properties:
            items:
              type: array
              items:
                $ref: '#/definitions/updateInventory'
      responses:
        200:
          description: <table border='1'width='672'>  <h1  style="color:#FFFF00;">API Generic Error Codes</h1><tbody><tr align="center"><td style="vertical-align:middle" width='167'><p><strong>Response Code </strong></p></td><td style="vertical-align:middle" colspan='2' width='171'><p><strong> Response Message </strong></p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>422</p></td><td style="vertical-align:middle" width='167'><p>Invalid Location</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3052</p></td><td style="vertical-align:middle" width='167'><p>skuCode is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3118</p></td><td style="vertical-align:middle" width='167'><p>UOM Qty is Mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3119</p></td><td style="vertical-align:middle" width='167'><p>UOM Qty can be any decimal value</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3120</p></td><td style="vertical-align:middle" width='167'><p>UOM Qty can't be negative.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3121</p></td><td style="vertical-align:middle" width='167'><p>UOM Qty can't be greater than 99999.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3055</p></td><td style="vertical-align:middle" width='167'><p>bin is mandatory.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3057</p></td><td style="vertical-align:middle" width='167'><p>reason is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3059</p></td><td style="vertical-align:middle" width='167'><p>mode is mandatory.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3050</p></td><td style="vertical-align:middle" width='167'><p>location is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3060</p></td><td style="vertical-align:middle" width='167'><p>Possible Value for mode is Increase or Decrease or New</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3064</p></td><td style="vertical-align:middle" width='167'><p>Multiple Ext Loc Code Found</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3065</p></td><td style="vertical-align:middle" width='167'><p>lottable_02 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3066</p></td><td style="vertical-align:middle" width='167'><p>lottable_03 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3067</p></td><td style="vertical-align:middle" width='167'><p>lottable_04 Format Not Correct Should Be (dd/MM/yyyy)</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>9233</p></td><td style="vertical-align:middle" width='167'><p>Maximum 1000 characters allowed.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>615</p></td><td style="vertical-align:middle" width='167'><p>LPN is mandatory</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3068</p></td><td style="vertical-align:middle" width='167'><p>LPN is not active.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3069</p></td><td style="vertical-align:middle" width='167'><p>Serial Tracking is ON for Sku [{0}]. API does not Support Serial Tracking.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3070</p></td><td style="vertical-align:middle" width='167'><p>SKU [{0}] is a BOM SKU, API does not BOM SKU.</p></td></tr><tr align="center"><td style="vertical-align:middle" width='167'><p>3071</p></td><td style="vertical-align:middle" width='167'><p>Invalid Bin, Not exists in system</p></td></tr><tr align="center"><td style="vertica

# --- truncated at 32 KB (91 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/vinculum/refs/heads/main/openapi/vinculum-stock-api-openapi.yml