SAP B1iP Error

{"info":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","description":"

This document contains the data and requirements necessary for the integration with the mesAPI conector, a passive API to connect Shoop Floor and MES systems with ERP systems, as SAP Business One or TOTVS Protheus.

__mesAPI conector currently has the following HTTP REST Plain services - version 2 (v2.0.2):

billOfMaterials: search bill of materials in ERP
productionResources: search production resources in ERP
resourceGroups: search work centers in ERP
tools: search tools in ERP
operators: search operators in ERP
stopReasons: search stop reasons in ERP
wasteReasons: search waste reasons in ERP
productionRoutes: search production routes in ERP
goodReceipts: search good receipts in ERP
goodIssues: search good issues in ERP
stockTransfers: search stock transfers in ERP
inventoryCountings: search inventory countings in ERP
productionOrders: search production orders in ERP
productionSequences: search production sequences in ERO (production order + production route)
productionPoints: insert production point in ERP (with or without time)
stopPoints: insert stop point in ERP
wastePoints: insert waste point in ERP

Content Type: all finAPI services use the “content-type” application/json for Parameters (body request) and Responses.

Authentication: finAPI uses Basic Authentication (user/password)

Characteristics: pagination, incremental query, default fields, objects and processes, use of custom fields (limited use), API usage and ERP transactions monitoring

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"8243187","collectionId":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","publishedId":"SVYkx1vD","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2020-11-14T18:36:06.000Z"},"item":[{"name":"Resources","item":[{"name":"Resource Groups","id":"598c25e0-228b-4326-baea-8ac1ed5ebfe0","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/resourceGroups?erpKey=000001&erpId=2","description":"

Search resource groups (work centers) in ERP

(totvsProtheus=SHB)

The search of groups of production resources allows filtering the ERP by:

Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records.

The response will inform:

The number of returned objects in the “count” field

This service does not have pagination or incremental treatment.

This service does not have user field (UDF) treatment.

Resource Group Primary Key in ERP (optional)

\n","type":"text/plain"},"key":"erpKey","value":"000001"},{"description":{"content":"

Resource Group Id in ERP (optional)

\n","type":"text/plain"},"key":"erpId","value":"2"}],"variable":[]}},"response":[{"id":"46eb2728-a0a8-41bd-91b6-eaac4b6d8dbf","name":"Resource Groups","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/resourceGroups","host":["{{endpoint}}"],"path":["resourceGroups"],"query":[{"key":"erpKey","value":"000001","description":"Resource Group Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":"1","description":"Resource Group Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"360"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ResourceGroups\",\n \"system\": \"totvsProtheus\",\n \"target\": \"resourceGroups\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:26:13\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"000001\",\n \"erpId\": 1,\n \"description\": \"CENTRO DE TRABALHO\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"}],"_postman_id":"598c25e0-228b-4326-baea-8ac1ed5ebfe0"},{"name":"Production Resources","id":"c62852bc-6e82-4c79-96d1-3ff1b6be5137","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/productionResources?erpKey=000004&erpId=3","description":"

Search production resources in ERP

(totvsProtheus=SH1)

The search of production resources allows you to filter the ERP by:

Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records.

The response will inform:

The number of returned objects in the “count” field

This service does not have pagination or incremental treatment.

This service does not have user field (UDF) treatment.

Production Resource Primary Key in ERP (optional)

\n","type":"text/plain"},"key":"erpKey","value":"000004"},{"description":{"content":"

Production Resource Id in ERP (optional)

\n","type":"text/plain"},"key":"erpId","value":"3"}],"variable":[]}},"response":[{"id":"b0d53f8a-7e0a-40a5-ad64-01d4841437d4","name":"Production Resources","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionResources","host":["{{endpoint}}"],"path":["productionResources"],"query":[{"key":"erpKey","value":null,"description":"Resource Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":null,"description":"Resource Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"607"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"ProductionResources\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionResources\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-04-02T19:22:15\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"000001\",\n \"erpId\": 1,\n \"description\": \"RECURSO\",\n \"resourceGroupKey\": \"\",\n \"linear\": false,\n \"active\": true,\n \"speedFactor\": 1,\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"000002\",\n \"erpId\": 2,\n \"description\": \"MAQUINA\",\n \"resourceGroupKey\": \"\",\n \"linear\": false,\n \"active\": true,\n \"speedFactor\": 1,\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"}],"_postman_id":"c62852bc-6e82-4c79-96d1-3ff1b6be5137"},{"name":"Tools","id":"f1defdc6-ac3f-43b4-b281-7bf7903de323","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/tools?erpKey=000001&erpId=1","description":"

Search tools in ERP

(totvsProtheus=SH4)

The tool search allows you to filter the ERP by:

Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records.

The response will inform:

The number of returned objects in the “count” field

This service does not have pagination or incremental treatment.

This service does not have user field (UDF) treatment.

Tool Primary Key in ERP (optional)

\n","type":"text/plain"},"key":"erpKey","value":"000001"},{"description":{"content":"

Tool Id in ERP (optional)

\n","type":"text/plain"},"key":"erpId","value":"1"}],"variable":[]}},"response":[{"id":"d950589c-617b-484c-b80a-b2fefb276ebb","name":"Tools","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/tools","host":["{{endpoint}}"],"path":["tools"],"query":[{"key":"erpKey","value":null,"description":"Tool Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":null,"description":"Tool Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"334"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"Tools\",\n \"system\": \"totvsProtheus\",\n \"target\": \"tools\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:28:33\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"000001\",\n \"erpId\": 1,\n \"description\": \"FERRAMENTA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"}],"_postman_id":"f1defdc6-ac3f-43b4-b281-7bf7903de323"},{"name":"Operators","id":"a6e52bd3-8a34-41a0-9205-ab93b61b1f00","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/operators?erpKey=000001&erpId=1","description":"

Search operatores in ERP

(totvsProtheus=CB1)

The search of operators allows filtering the ERP by:

Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records.

The response will inform:

The number of returned objects in the “count” field

This service does not have pagination or incremental treatment.

This service does not have user field (UDF) treatment.

Operator Primary Key in ERP (optional)

\n","type":"text/plain"},"key":"erpKey","value":"000001"},{"description":{"content":"

Operator Id in ERP (optional)

\n","type":"text/plain"},"key":"erpId","value":"1"}],"variable":[]}},"response":[{"id":"530e0ba5-114d-4b34-b27d-de6e1891a914","name":"Operators","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/operators","host":["{{endpoint}}"],"path":["operators"],"query":[{"key":"erpKey","value":null,"description":"Operator Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":null,"description":"Operator Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"353"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"Operators\",\n \"system\": \"totvsProtheus\",\n \"target\": \"operators\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T16:08:38\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"000001\",\n \"erpId\": 1,\n \"description\": \"RAFAEL\",\n \"active\": true,\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"}],"_postman_id":"a6e52bd3-8a34-41a0-9205-ab93b61b1f00"}],"id":"62a2e5ac-b78b-4d47-986e-31a78c93212a","_postman_id":"62a2e5ac-b78b-4d47-986e-31a78c93212a","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}}},{"name":"Reasons Tables","item":[{"name":"Stop Reasons","id":"9cd38e92-d85a-4811-bf8e-8424d8af461e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/stopReasons?erpKey=FT&erpId=2408","description":"

Search stop reasons in ERP

(totvsProtheus=SX5/44)

The stop reasons search allows you to filter the ERP by:

Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records in table 44 of SX5.

The response will inform:

The number of returned objects in the “count” field

This service does not have pagination or incremental treatment.

This service does not have user field (UDF) treatment.

Stop Reason Primary Key in ERP (optional)

\n","type":"text/plain"},"key":"erpKey","value":"FT"},{"description":{"content":"

Stop Reason Id in ERP (optional)

\n","type":"text/plain"},"key":"erpId","value":"2408"}],"variable":[]}},"response":[{"id":"6f2e70b7-55fe-4cc6-8fb5-c9c011adbf7d","name":"Stop Reasons","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/stopReasons","host":["{{endpoint}}"],"path":["stopReasons"],"query":[{"key":"erpKey","value":null,"description":"Stop Reason Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":null,"description":"Stop Reason Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"967"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"StopReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"stopReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:40:02\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"FE\",\n \"erpId\": 2403,\n \"description\": \"FALTA DE ENERGIA ELETRICA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"FM\",\n \"erpId\": 2404,\n \"description\": \"FALTA DE MATERIA PRIMA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"FO\",\n \"erpId\": 2405,\n \"description\": \"FALTA DE OPERADOR\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"FS\",\n \"erpId\": 2406,\n \"description\": \"FALTA DE SERVICO\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"FT\",\n \"erpId\": 2407,\n \"description\": \"Fim do turno\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"PR\",\n \"erpId\": 2408,\n \"description\": \"Parada para refeicao\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 6\n}"},{"id":"ca885c0c-e22c-49ee-870a-991584358350","name":"Stop Reasons - by erpId","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/stopReasons?erpId=2408","host":["{{endpoint}}"],"path":["stopReasons"],"query":[{"key":"erpKey","value":"FT","description":"Stop Reason Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":"2408","description":"Stop Reason Id in ERP (optional)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"369"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"StopReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"stopReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:41:19\",\n \"erpId\": 2408,\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"PR\",\n \"erpId\": 2408,\n \"description\": \"Parada para refeicao\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"},{"id":"cdc323d6-bce5-4864-a826-1a0d491c1730","name":"Stop Reasons - not found","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/stopReasons?erpId=24081","host":["{{endpoint}}"],"path":["stopReasons"],"query":[{"key":"erpKey","value":"FT","description":"Stop Reason Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":"24081","description":"Stop Reason Id in ERP (optional)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"341"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"StopReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"stopReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:41:40\",\n \"erpId\": 24081,\n \"code\": \"404\",\n \"success\": false,\n \"error\": {\n \"code\": \"404\",\n \"message\": \"No valid stopReasons were found\",\n \"details\": \"No valid stopReasons were found\"\n }\n}"},{"id":"f3fb1d6a-1aeb-4511-aed0-206028bce06c","name":"Stop Reasons - by erpKey","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/stopReasons?erpKey=FT","host":["{{endpoint}}"],"path":["stopReasons"],"query":[{"key":"erpKey","value":"FT","description":"Stop Reason Primary Key in ERP (optional)"},{"key":"erpId","value":"2408","description":"Stop Reason Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"362"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"StopReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"stopReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:40:54\",\n \"erpKey\": \"FT\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"FT\",\n \"erpId\": 2407,\n \"description\": \"Fim do turno\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"}],"_postman_id":"9cd38e92-d85a-4811-bf8e-8424d8af461e"},{"name":"Waste Reasons","id":"f14e6702-da53-4db6-8d5f-013122ec7c76","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/wasteReasons?erpKey=FH&erpId=2399","description":"

Search waste reasons in ERP

(totvsProtheus=SX5/43)

The waste reasons search allows you to filter the ERP by:

Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records in table 43 of SX5.

The response will inform:

The number of returned objects in the “count” field

This service does not have pagination or incremental treatment.

This service does not have user field (UDF) treatment.

Waste Reason Primary Key in ERP (optional)

\n","type":"text/plain"},"key":"erpKey","value":"FH"},{"description":{"content":"

Waste Reason Id in ERP (optional)

\n","type":"text/plain"},"key":"erpId","value":"2399"}],"variable":[]}},"response":[{"id":"641a4b72-46c5-4221-b070-17e5d636022c","name":"Waste Reasons - by erpId","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/wasteReasons?erpId=2399","host":["{{endpoint}}"],"path":["wasteReasons"],"query":[{"key":"erpKey","value":"FH","description":"Waste Reason Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":"2399","description":"Waste Reason Id in ERP (optional)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"363"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"WasteReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"wasteReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:43:49\",\n \"erpId\": 2399,\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"FH\",\n \"erpId\": 2399,\n \"description\": \"FALHA HUMANA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"},{"id":"a374009b-23fe-4b70-9409-4f4b523f533f","name":"Waste Reasons","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/wasteReasons","host":["{{endpoint}}"],"path":["wasteReasons"],"query":[{"key":"erpKey","value":null,"description":"Waste Reason Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":null,"description":"Waste Reason Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"701"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"WasteReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"wasteReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:40:02\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"FH\",\n \"erpId\": 2399,\n \"description\": \"FALHA HUMANA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"FM\",\n \"erpId\": 2400,\n \"description\": \"FALHA MECANICA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"FP\",\n \"erpId\": 2401,\n \"description\": \"FALHA MATERIA PRIMA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"erpKey\": \"RB\",\n \"erpId\": 2402,\n \"description\": \"REBARBA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 4\n}"},{"id":"ab88abb2-d79a-43eb-aebf-19bffbdc1bb9","name":"Waste Reasons - not found","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/wasteReasons?erpId=23991","host":["{{endpoint}}"],"path":["wasteReasons"],"query":[{"key":"erpKey","value":"FH","description":"Waste Reason Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":"23991","description":"Waste Reason Id in ERP (optional)"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"345"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"WasteReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"wasteReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:44:04\",\n \"erpId\": 23991,\n \"code\": \"404\",\n \"success\": false,\n \"error\": {\n \"code\": \"404\",\n \"message\": \"No valid wasteReasons were found\",\n \"details\": \"No valid wasteReasons were found\"\n }\n}"},{"id":"b6876087-7a2c-47be-a01a-49128c7996cd","name":"Waste Reasons - by erpKey","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/wasteReasons?erpKey=FH","host":["{{endpoint}}"],"path":["wasteReasons"],"query":[{"key":"erpKey","value":"FH","description":"Waste Reason Primary Key in ERP (optional)"},{"key":"erpId","value":"2399","description":"Waste Reason Id in ERP (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"364"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"WasteReasons\",\n \"system\": \"totvsProtheus\",\n \"target\": \"wasteReasons\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T15:43:15\",\n \"erpKey\": \"FH\",\n \"code\": 200,\n \"success\": true,\n \"values\": [\n {\n \"erpKey\": \"FH\",\n \"erpId\": 2399,\n \"description\": \"FALHA HUMANA\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"}],"_postman_id":"f14e6702-da53-4db6-8d5f-013122ec7c76"}],"id":"7d7fe2ea-5384-4eec-8083-1b15f70ac7c3","_postman_id":"7d7fe2ea-5384-4eec-8083-1b15f70ac7c3","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}}},{"name":"Production Routes","item":[{"name":"Production Routes","id":"2f4aecbf-2c7b-4e00-84a9-589cbf005307","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/productionRoutes?productKey=900.000.003&erpId=4&pageNum&updatedAt","description":"

Search production routes in ERP

(totvsProtheus=SG2)

The search of production routes allows you to filter the ERP by:

Unitary: by productKey or erpId (TOTVS Protheus only)

If no field for unitary query (productKey or erpId) is informed in the request, the search returns all valid records.

The service will consider as valid products:

TOTVS Protheus: [1] “Finished Product” Type (B1_TIPO = PA), [2] active product (B1_MSBLQL other than 1), [3] E-commerce field active (B5_ECFLAG = 1)

TOTVS Protheus:

The service will also take into account the use of Alternative Resources (SH3 table), if the API Setup parameter (IG_USERALT) is set to true. In this situation, if any, the same production route will have more than one record with different resources for the same sequence.
The service treat the field \"G2_TPOPER\" only for 1=normal and 2=fixed time
There isn't treatment for the fields: \"G2_TPALOCF\", \"G2_MAOOBRA\", \"G2_FORMSTP\", \"G2_TPSOBRE\", \"G2_TPDESD\", \"G2_DESPROP\", \"G2_ROTALT\", \"G2_TEMPEND\"

The response will inform:

The number of returned objects in the “count” field

For all searches on production routes, the pagination feature will be used in the response, where the following fields are used to control the pagination:

“pageSize” = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
“pageNum” = desired page, provided in the request, and informed in the response. If “pageNum” not informed = 1, If “pageNum” <=0 = 1, If “pageNum”> ”pageTotal” = last page
“pageTotal” = total pages, reported in the response
“hasNext” = if there are more pages (true / false), informed in the response

This service will allow you to search production routes in two situations:

Full query: will result in all valid records.
Incremental Consultation: will result in all valid records that have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH: MM: SS) will be used to determine which products (partnumber / skus) should be returned. This information will be used in conjunction with: [1] TOTVS Protheus: fields G2_USERLGI and G2_USERLGA

This service does not have user field (UDF) treatment.

Product Primary Key in ERP (optional)

\n","type":"text/plain"},"key":"productKey","value":"900.000.003"},{"description":{"content":"

Production Route Id in ERP (optional)

\n","type":"text/plain"},"key":"erpId","value":"4"},{"description":{"content":"

Number of page - pagination (optional)

\n","type":"text/plain"},"key":"pageNum","value":null},{"description":{"content":"

Date do filter modified register - incremental query (optional)

\n","type":"text/plain"},"key":"updatedAt","value":null}],"variable":[]}},"response":[{"id":"44eb93cd-5bc4-4e68-975b-31a2cda3abec","name":"Production Routes","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionRoutes","host":["{{endpoint}}"],"path":["productionRoutes"],"query":[{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional)","disabled":true},{"key":"erpId","value":"4","description":"Production Route Id in ERP (optional)","disabled":true},{"key":"pageNum","value":null,"description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":null,"description":"Date do filter modified register - incremental query (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1131"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionRoutes\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionRoutes\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-15T18:18:53\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 3,\n \"values\": [\n {\n \"productKey\": \"900.000.003\",\n \"measureUnit\": \"PC\",\n \"timeUnit\": \"S\",\n \"erpId\": 3,\n \"route\": 1,\n \"sequence\": 1,\n \"resourceKey\": \"000001\",\n \"alternative\": false,\n \"tollKey\": \"\",\n \"setupTime\": 3600,\n \"batchSize\": 100,\n \"batchTime\": 36000,\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"productKey\": \"900.000.003\",\n \"measureUnit\": \"PC\",\n \"timeUnit\": \"S\",\n \"erpId\": 4,\n \"route\": 1,\n \"sequence\": 2,\n \"resourceKey\": \"000002\",\n \"alternative\": false,\n \"tollKey\": \"000001\",\n \"setupTime\": 0,\n \"batchSize\": 100,\n \"batchTime\": 72000,\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"productKey\": \"900.000.003\",\n \"measureUnit\": \"PC\",\n \"timeUnit\": \"S\",\n \"erpId\": 4,\n \"route\": 1,\n \"sequence\": 2,\n \"resourceKey\": \"000001\",\n \"alternative\": true,\n \"tollKey\": \"000001\",\n \"setupTime\": 0,\n \"batchSize\": 100,\n \"batchTime\": 64800,\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"}],"_postman_id":"2f4aecbf-2c7b-4e00-84a9-589cbf005307"}],"id":"17f974aa-62fa-47e2-b9d3-80250b953faa","_postman_id":"17f974aa-62fa-47e2-b9d3-80250b953faa","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}}},{"name":"Stock Movements*","item":[{"name":"Good Receipts","id":"dedb9907-373b-4370-af66-06a076fe6ccc","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":"{{endpoint}}/goodReceipts?createdFrom=2020-11-01&createdTo=2020-11-30&branch=2&productKey=MP000001&erpKey=53929&docNum=000001011&pageNum=2&updatedAt=2020-08-26T00:00:00","description":"

Search good receipts in ERP

(sapBusinessOne=59/OIGN, totvsProtheus=SD3)

This service will allow you to search good receipts on the ERP.

Searching good receipts allows you to filter the ERP by:

List search: by createdFrom + createdTo {required}, by branch, productKey {optional}
Unitary search: by erpKey or docNum or erpId (Protheus only)

If no field for unitary query is provided in the request (erpKey or docNum or erpId), the query for good receipts is carried out by creation date from/to (which become mandatory).

The good receipts service will consider good receipts with:

SAP Business One: OIGN.ObjType = 59
TOTVS Protheus: D3_CF IN 'DE' AND NOT 'DE4'/'DE7'

Comments:

branch: SAP Business One (OIGN.BPLId), TOTVS Protheus (D3_FILIAL)
productKey: SAP Business One (IGN1.ItemCode), TOTVS Protheus (D3_COD)
erpKey: SAP Business One (OIGN.DocEntry), TOTVS Protheus (D3_NUMSEQ)
erpId: TOTVS Protheus (R_E_C_N_O_)
docNum: SAP Business One (OIGN.DocNum), TOTVS Protheus (D3_DOC)
status: O = open, S = storned (D3_ESTORNO=S)
lineStatus: O = open, S = storned (D3_ESTORNO=S)

Data returned in response: Order data, Partner data, Items (+ taxes), Totals, Payments, Taxes, good receipts

The response will inform:

The number of returned objects in the count field

For list search, the pagination feature in the response will be used, where the following fields are used to control the pagination:

pageSize = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
pageNum = desired page, provided in the request, and informed in the response. If “pageNum” not informed = 1, If “pageNum” <=0 = 1, If “pageNum”> ”pageTotal” = last page
pageTotal = total pages, reported in the response
hasNext = if there are more pages (true / false), informed in the response

This service will allow you to search the sales order list in two situations:

Full Search: will result in all sales orders, according to filters.
Incremental Search: will result in all sales orders, according to filters, which have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH:MM:SS) will be used to determine which sales orders should be returned. This information will be used in conjunction with: [1] SAP Business One: the Creation Date and Document Update Date fields in SAP Business One (OIGN.CreateDate, OIGN.UpdateDate, OIGN.CreateTS, OIGN.UpdateTS), [2] TOTVS Protheus: fields D3_USERLGI and D3_USERLGA

This service does not have user field (UDF) treatment.

Final create date to filter good receipts (required if not unitary search)

\n","type":"text/plain"},"key":"createdTo","value":"2020-11-30"},{"description":{"content":"

Branch (optional in list search)

\n","type":"text/plain"},"key":"branch","value":"2"},{"description":{"content":"

Product Primary Key in ERP (optional in list search)

\n","type":"text/plain"},"key":"productKey","value":"MP000001"},{"description":{"content":"

Good Receipt Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpKey","value":"53929"},{"description":{"content":"

Good Receipt Document Number in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"docNum","value":"000001011"},{"description":{"content":"

Number of page - pagination (optional)

\n","type":"text/plain"},"key":"pageNum","value":"2"},{"description":{"content":"

Date do filter modified registers - incremental search (optional)

\n","type":"text/plain"},"key":"updatedAt","value":"2020-08-26T00:00:00"}],"variable":[]}},"response":[{"id":"516135af-af67-4e76-825d-8eea0a0abb96","name":"Good Receipts - TOTVS Protheus","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/goodReceipts?createdFrom=2020-11-01&createdTo=2020-11-30","host":["{{endpoint}}"],"path":["goodReceipts"],"query":[{"key":"createdFrom","value":"2020-11-01"},{"key":"createdTo","value":"2020-11-30","description":"Final create date to filter good receipts (required if not unitary search)"},{"key":"branch","value":"1","description":"Branch (optional in list search)","disabled":true},{"key":"productKey","value":"C001","description":"Product Primary Key in ERP (optional in list search)","disabled":true},{"key":"erpKey","value":"53929","description":"Good Receipt Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"docNum","value":"121313","description":"Good Receipt Document Number in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"2","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-08-26T00:00:00","description":"Date do filter modified registers - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Encoding","value":"gzip"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"GoodReceipts\",\n \"system\": \"totvsProtheus\",\n \"target\": \"goodReceipts\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.108\",\n \"effectiveTimestamp\": \"2020-11-10T17:41:26\",\n \"createdFrom\": \"2020-11-01\",\n \"createdTo\": \"2020-11-30\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"000007\",\n \"docNum\": \"000001011\",\n \"status\": \"O\",\n \"reference\": null,\n \"comments\": null,\n \"createdAt\": \"2020-11-10T00:00:00\",\n \"updatedAt\": null,\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"1\",\n \"productKey\": \"MP000001\",\n \"codeBars\": \"\",\n \"productName\": \"MATERIA PRIMA\",\n \"measureUnit\": \"KG\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": 200,\n \"unitaryCost\": 0.1,\n \"totalCost\": 20,\n \"account\": \"\",\n \"costCenterKey\": \"\",\n \"productionOrderKey\": \"\"\n }\n ]\n }\n ],\n \"count\": 1\n}"},{"id":"e85e44bf-b940-46fa-af91-b0c2e6da8332","name":"Good Receipts - SAP Business One","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/goodReceipts?createdFrom=2020-01-28&createdTo=2020-01-28","host":["{{endpoint}}"],"path":["goodReceipts"],"query":[{"key":"createdFrom","value":"2020-01-28"},{"key":"createdTo","value":"2020-01-28","description":"Final create date to filter good receipts (required if not unitary search)"},{"key":"branch","value":"1","description":"Branch (optional in list search)","disabled":true},{"key":"productKey","value":"C001","description":"Product Primary Key in ERP (optional in list search)","disabled":true},{"key":"erpKey","value":"53929","description":"Good Receipt Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"docNum","value":"121313","description":"Good Receipt Document Number in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"2","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-08-26T00:00:00","description":"Date do filter modified registers - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-FRAME-OPTIONS","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"Thu, 01 Jan 1970 00:00:00 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Date","value":"Fri, 16 Oct 2020 13:01:10 GMT"},{"key":"Server","value":""}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"GoodReceipts\",\n \"system\": \"sapBusinessOne\",\n \"target\": \"goodReceipts\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.108\",\n \"effectiveTimestamp\": \"2020-10-16T10:01:06\",\n \"createdFrom\": \"2020-01-28\",\n \"createdTo\": \"2020-01-28\",\n \"code\": \"200\",\n \"success\": true,\n \"useCustom\": \"\",\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"1\",\n \"branchName\": \"MATRIZ\",\n \"erpKey\": \"27\",\n \"docNum\": \"27\",\n \"status\": \"O\",\n \"reference\": \"\",\n \"comments\": \"\",\n \"createdAt\": \"2020-01-28T17:14:58\",\n \"updatedAt\": \"2020-01-28T17:15:02\",\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"0\",\n \"productKey\": \"I007\",\n \"codeBars\": \"I007\",\n \"productName\": \"Whey 3 Protein Speed Release Gel\",\n \"measureUnit\": \"Un\",\n \"batchControl\": false,\n \"serialControl\": true,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": 10,\n \"unitaryCost\": 13.01,\n \"totalCost\": 130.1,\n \"serialNumbers\": []\n }\n ]\n }\n ]\n}"}],"_postman_id":"dedb9907-373b-4370-af66-06a076fe6ccc"},{"name":"Good Issues","id":"f64f683e-b3ea-4b90-8bd6-2773e4e59921","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":"{{endpoint}}/goodIssues?createdFrom=2020-11-10&createdTo=2020-11-10&branch=1&productKey=PA00311&erpKey=53929&docNum=121313&pageNum=1&updatedAt=2020-08-26T00:00:00","description":"

Search good issues in ERP

(sapBusinessOne=60/OIGE, totvsProtheus=SD3)

This service will allow you to search good issues on the ERP.

Searching good issues allows you to filter the ERP by:

List search: by createdFrom + createdTo {required}, by branch, productKey {optional}
Unitary search: by erpKey or docNum

If no field for unitary query is provided in the request (erpKey or docNum), the query for good issues is carried out by creation date from/to (which become mandatory).

The good issues service will consider good issues with:

SAP Business One: [1] OIGE.ObjType='60'
TOTVS Protheus: [1] D3_CF IN 'RE' AND NOT 'RE4'/'RE7'

Comments:

branch: SAP Business One (OIGE.BPLId), TOTVS Protheus (D3_FILIAL)
productKey: SAP Business One (IGE1.ItemCode), TOTVS Protheus (D3_COD)
erpKey: SAP Business One (OIGE.DocEntry), TOTVS Protheus (D3_NUMSEQ)
erpId: TOTVS Protheus (R_E_C_N_O_)
docNum: SAP Business One (OIGE.DocNum), TOTVS Protheus (D3_DOC)
status: O = open, S = storned (D3_ESTORNO=S)
lineStatus: O = open, S = storned (D3_ESTORNO=S)

The response will inform:

The number of returned objects in the count field

For list search, the pagination feature in the response will be used, where the following fields are used to control the pagination:

pageSize = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
pageNum = desired page, provided in the request, and informed in the response. If pageNum not informed = 1, If pageNum <=0 = 1, If pageNum > pageTotal = last page
pageTotal = total pages, reported in the response
hasNext = if there are more pages (true / false), informed in the response

This service will allow you to search the good issues list in two situations:

Full Search: will result in all good issues, according to filters.
Incremental Search: will result in all good issues according to filters, which have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH:MM:SS) will be used to determine which good issues should be returned. This information will be used in conjunction with: [1] SAP Business One: the Creation Date and Document Update Date fields in SAP Business One (OIGE.CreateDate, OIGE.UpdateDate, OIGE.CreateTS, OIGE.UpdateTS), [2] TOTVS Protheus: fields D3_USERLGI and D3_USERLGA

This service does not have user field (UDF) treatment.

Initial create date to filter good issues (required if not unitary search)

\n","type":"text/plain"},"key":"createdFrom","value":"2020-11-10"},{"description":{"content":"

Final create date to filter good issues (required if not unitary search)

\n","type":"text/plain"},"key":"createdTo","value":"2020-11-10"},{"description":{"content":"

Branch (optional in list search)

\n","type":"text/plain"},"key":"branch","value":"1"},{"description":{"content":"

Product Primary Key in ERP (optional in list search)

\n","type":"text/plain"},"key":"productKey","value":"PA00311"},{"description":{"content":"

Good Issue Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpKey","value":"53929"},{"description":{"content":"

Good Issue Document Number in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"docNum","value":"121313"},{"description":{"content":"

Number of page - pagination (optional)

\n","type":"text/plain"},"key":"pageNum","value":"1"},{"description":{"content":"

Date do filter modified registers - incremental search (optional)

\n","type":"text/plain"},"key":"updatedAt","value":"2020-08-26T00:00:00"},{"disabled":true,"key":"reference","value":null}],"variable":[]}},"response":[{"id":"ad4b9257-3048-47e2-8974-c6d9d329fc55","name":"Good Issues - SAP Business One","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/goodIssues?createdFrom=2020-09-30&createdTo=2020-09-30","host":["{{endpoint}}"],"path":["goodIssues"],"query":[{"key":"createdFrom","value":"2020-09-30","description":"Initial create date to filter good issues (required if not unitary search)"},{"key":"createdTo","value":"2020-09-30","description":"Final create date to filter good issues (required if not unitary search)"},{"key":"branch","value":"1","description":"Branch (optional in list search)","disabled":true},{"key":"productKey","value":"PA00311","description":"Product Primary Key in ERP (optional in list search)","disabled":true},{"key":"erpKey","value":"53929","description":"Good Issue Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"docNum","value":"121313","description":"Good Issue Document Number in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-08-26T00:00:00","description":"Date do filter modified registers - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-FRAME-OPTIONS","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"Thu, 01 Jan 1970 00:00:00 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Date","value":"Thu, 01 Oct 2020 03:01:00 GMT"},{"key":"Server","value":""}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"GoodIssues\",\n \"system\": \"sapBusinessOne\",\n \"target\": \"goodIssues\",\n \"user\": \"intergate\",\n \"host\": \"186.251.109.141\",\n \"effectiveTimestamp\": \"2020-10-01T00:00:34\",\n \"createdFrom\": \"2020-09-30\",\n \"createdTo\": \"2020-09-30\",\n \"code\": \"200\",\n \"success\": true,\n \"useCustom\": \"\",\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 2,\n \"values\": [\n {\n \"branch\": \"1\",\n \"branchName\": \"Dengo Chocolates SA\",\n \"erpKey\": \"3550\",\n \"docNum\": \"3086\",\n \"status\": \"O\",\n \"reference\": \"\",\n \"comments\": \"\",\n \"createdAt\": \"2020-09-30T08:22:43\",\n \"updatedAt\": \"2020-09-30T08:22:43\",\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"0\",\n \"productKey\": \"PI00128\",\n \"codeBars\": \"\",\n \"productName\": \"DADINHO DE BANANA CAFUNE 10G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"03\",\n \"lineStatus\": \"O\",\n \"quantity\": 4,\n \"unitaryCost\": 0.9025,\n \"totalCost\": 3.61,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201921\",\n \"productionDate\": \"2020-07-10\",\n \"expirationDate\": \"2020-10-08\",\n \"quantity\": 4\n }\n ]\n },\n {\n \"lineNum\": \"1\",\n \"productKey\": \"PI00128\",\n \"codeBars\": \"\",\n \"productName\": \"DADINHO DE BANANA CAFUNE 10G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"708\",\n \"lineStatus\": \"O\",\n \"quantity\": 3.416,\n \"unitaryCost\": 0.9016,\n \"totalCost\": 3.08,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202691\",\n \"productionDate\": \"2020-09-29\",\n \"expirationDate\": \"2020-12-28\",\n \"quantity\": 3.416\n }\n ]\n }\n ]\n }\n ]\n}"},{"id":"d953cd73-81fc-403b-b846-782c32693e31","name":"Good Issues - TOTVS Protheus","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/goodIssues?createdFrom=2020-11-10&createdTo=2020-11-10","host":["{{endpoint}}"],"path":["goodIssues"],"query":[{"key":"createdFrom","value":"2020-11-10","description":"Initial create date to filter good issues (required if not unitary search)"},{"key":"createdTo","value":"2020-11-10","description":"Final create date to filter good issues (required if not unitary search)"},{"key":"branch","value":"1","description":"Branch (optional in list search)","disabled":true},{"key":"productKey","value":"PA00311","description":"Product Primary Key in ERP (optional in list search)","disabled":true},{"key":"erpKey","value":"53929","description":"Good Issue Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"docNum","value":"121313","description":"Good Issue Document Number in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-08-26T00:00:00","description":"Date do filter modified registers - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Encoding","value":"gzip"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"GoodIssues\",\n \"system\": \"totvsProtheus\",\n \"target\": \"goodIssues\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.108\",\n \"effectiveTimestamp\": \"2020-11-10T18:37:58\",\n \"createdFrom\": \"2020-11-10\",\n \"createdTo\": \"2020-11-10\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"000005\",\n \"docNum\": \"000001010\",\n \"status\": \"O\",\n \"reference\": null,\n \"comments\": null,\n \"createdAt\": \"2020-11-10T00:00:00\",\n \"updatedAt\": null,\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"1\",\n \"productKey\": \"MP000001\",\n \"codeBars\": \"\",\n \"productName\": \"MATERIA PRIMA\",\n \"measureUnit\": \"KG\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": 100,\n \"unitaryCost\": 0.1,\n \"totalCost\": 10,\n \"account\": \"\",\n \"costCenterKey\": \"\",\n \"productionOrderKey\": \"00000101001\"\n },\n {\n \"lineNum\": \"1\",\n \"productKey\": \"MP000002\",\n \"codeBars\": \"\",\n \"productName\": \"MATERIA PRIMA 2\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": 100,\n \"unitaryCost\": 0,\n \"totalCost\": 0,\n \"account\": \"\",\n \"costCenterKey\": \"\",\n \"productionOrderKey\": \"00000101001\"\n }\n ]\n }\n ],\n \"count\": 1\n}"}],"_postman_id":"f64f683e-b3ea-4b90-8bd6-2773e4e59921"},{"name":"Good Issues*","id":"5b93e96f-54e9-4b4c-b1a2-fa3a9af90805","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"branch\": \"3\",\r\n \"#whsCode\": \"05\",\r\n \"reference\":\"ks-15\",\r\n \"comments\":\"TAIS NASCIMENTO DA SILVA\",\r\n \"items\": [\r\n {\r\n \"#lineNum\": 1,\r\n \"productKey\": \"PA00013\",\r\n \"quantity\": 40,\r\n \"issueReason\": \"07\",\r\n \"batchNumbers\": [\r\n {\r\n \"batchCode\": \"200661\",\r\n \"expirationDate\": \"2021-03-06\",\r\n \"quantity\": 40\r\n }\r\n ]\r\n }\r\n ]\r\n}"},"url":"{{endpoint}}/goodIssues","description":"

Insert good issue in ERP

(sapBusinessOne=60/OIGE, totvsProtheus=SD3)

<<< NOT YET AVAILABLE. RELEASE IN 2020 Q4 >>>

This service will allow you to insert a new good issue on the ERP.

To insert a new good issue you need to inform branch and items. Optionally you can inform whsCode, reference and comments.

Products sent to the service will be validated for the search key. Products can be identified in the ERP in 2 ways:

SAP B1: OITM.CodeBars = codeBars or OITM.ItemCode = productKey
TOTVS Protheus: B1_CODBAR = codeBars or B1_COD = productKey

This service does not have user field (UDF) treatment.

Request object has the following properties

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Description
branch	number	Branch
baseKey	string	Base Key
totalWeight	number	Total Weight
totalVolume	number	Total Volume
totalCubage	number	Total cubage
items	array	invoice Items Object
items.lineNum	string	number line
items.productKey	string	Product key
items.codeBars	string	Code bars
items.quantity	number	quantity
payments	array	Method
payments.paymentMethod	string	Payment Method
payments.amount	number	Amount
payments.installments	number	installments
payments.paymentMethod	string	Payment Method
payments.amount	number	Amount
payments.installments	number	installments
payments.details	object	details
payments.details.cardName	string	Card name
payments.details.acquirer	string	Acquire
payments.details.tid	string	tid
payments.details.authid	string	Authid
payments.details.nsu	string	nsu

* = Required field

Response object has the following properties

Field	Type	Description
package	string	package
process	string	Process
system	string	System
target	string	Target
user	string	User
host	string	Host
effectiveTimestamp	string	Effective Time stamp
code	string	Code
success	booleano	success
values	array	values
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp key
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp key
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp key

Search stock transfers in ERP

(sapBusinessOne=67/OWTR, totvsProtheus=SD3)

This service will allow you to search stock transfers on the ERP.

Searching stock transfers allows you to filter the ERP by:

List search: by branch and createdFrom + createdTo, by productKey {optional}
Unitary search: by erpKey or docNum

If no field for unitary query is provided in the request (erpKey or docNum), the query for sales orders is carried out by creation date from/to (which become mandatory).

The stock transfers service will consider stock transfers with:

SAP Business One: OWTR.ObjType = 67
TOTVS Protheus: D3_CF IN DE4 RE4 DE7 RE7

Comments:

branch: SAP Business One (OWTR.BPLId), TOTVS Protheus (D3_FILIAL)
productKey: SAP Business One (OWTR.CardCode), TOTVS Protheus (D3_COD)
erpKey: SAP Business One (OWTR.DocEntry), TOTVS Protheus (D3_NUMSEQ)
erpId: TOTVS Protheus (R_E_C_N_O_)
docNum: SAP Business One (OWTR.DocNum), TOTVS Protheus (D3_DOC)
status: O = open, S = storned (D3_ESTORNO=S)
lineStatus: O = open, S = storned (D3_ESTORNO=S)
quantity, totalCost: positive for transfer receipts, negative for transfer issues

Data returned in response: stock transfer data

The response will inform:

The number of returned objects in the count field

For list search, the pagination feature in the response will be used, where the following fields are used to control the pagination:

pageSize = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
pageNum = desired page, provided in the request, and informed in the response. If “pageNum” not informed = 1, If “pageNum” <=0 = 1, If “pageNum”> ”pageTotal” = last page
pageTotal = total pages, reported in the response
hasNext = if there are more pages (true / false), informed in the response

This service will allow you to search the stock transfers list in two situations:

Full Search: will result in all stock transfers, according to filters.
Incremental Search: will result in all stock transfers, according to filters, which have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH:MM:SS) will be used to determine which stock transfers should be returned. This information will be used in conjunction with: [1] SAP Business One: the Creation Date and Document Update Date fields in SAP Business One (OWTR.CreateDate, OWTR.UpdateDate, OWTR.CreateTS, OWTR.UpdateTS), [2] TOTVS Protheus: fields D3_USERLGI and D3_USERLGA

This service does not have user field (UDF) treatment.

Initial create date to filter sales orders (required if not unitary search)

\n","type":"text/plain"},"key":"createdFrom","value":"2020-11-10"},{"description":{"content":"

Final create date to filter sales orders (required if not unitary search)

\n","type":"text/plain"},"key":"createdTo","value":"2020-11-10"},{"description":{"content":"

Branch (optional in list search)

\n","type":"text/plain"},"key":"branch","value":"1"},{"description":{"content":"

Product Primary Key in ERP (optional in list search)

\n","type":"text/plain"},"key":"productKey","value":"C001"},{"description":{"content":"

Stock Transfer Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpKey","value":"53929"},{"description":{"content":"

Stock Transfer Document Number in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"docNum","value":"121313"},{"description":{"content":"

Number of page - pagination (optional)

\n","type":"text/plain"},"key":"pageNum","value":"2"},{"description":{"content":"

Date do filter modified registers - incremental search (optional)

\n","type":"text/plain"},"key":"updatedAt","value":"2020-08-26T00:00:00"}],"variable":[]}},"response":[{"id":"cb66e6d0-132f-42c6-af1b-2bace1e796c5","name":"Stock Transfers - TOTVS Protheus","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/stockTransfers?createdFrom=2020-11-10&createdTo=2020-11-10","host":["{{endpoint}}"],"path":["stockTransfers"],"query":[{"key":"createdFrom","value":"2020-11-10","description":"Initial create date to filter sales orders (required if not unitary search)"},{"key":"createdTo","value":"2020-11-10","description":"Final create date to filter sales orders (required if not unitary search)"},{"key":"branch","value":"1","description":"Branch (optional in list search)","disabled":true},{"key":"productKey","value":"C001","description":"Product Primary Key in ERP (optional in list search)","disabled":true},{"key":"erpKey","value":"53929","description":"Stock Transfer Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"docNum","value":"121313","description":"Stock Transfer Document Number in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"2","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-08-26T00:00:00","description":"Date do filter modified registers - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Encoding","value":"gzip"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"GoodReceipts\",\n \"system\": \"totvsProtheus\",\n \"target\": \"goodReceipts\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.108\",\n \"effectiveTimestamp\": \"2020-11-10T18:47:04\",\n \"createdFrom\": \"2020-11-10\",\n \"createdTo\": \"2020-11-10\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"000009\",\n \"docNum\": \"000001013\",\n \"status\": \"O\",\n \"reference\": null,\n \"comments\": null,\n \"createdAt\": \"2020-11-10T00:00:00\",\n \"updatedAt\": null,\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"1\",\n \"productKey\": \"MP000001\",\n \"codeBars\": \"\",\n \"productName\": \"MATERIA PRIMA\",\n \"measureUnit\": \"KG\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": -10,\n \"unitaryCost\": 0.1,\n \"totalCost\": -1,\n \"account\": \"\",\n \"costCenterKey\": \"\",\n \"productionOrderKey\": \"\"\n },\n {\n \"lineNum\": \"1\",\n \"productKey\": \"MP000002\",\n \"codeBars\": \"\",\n \"productName\": \"MATERIA PRIMA 2\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": 10,\n \"unitaryCost\": 0.1,\n \"totalCost\": 1,\n \"account\": \"\",\n \"costCenterKey\": \"\",\n \"productionOrderKey\": \"\"\n }\n ]\n }\n ],\n \"count\": 1\n}"},{"id":"fcc45189-a4e6-4b88-8026-2fb386686ea4","name":"Stock Transfers - SAP Business One","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/stockTransfers?createdFrom=2010-08-01&createdTo=2020-08-26","host":["{{endpoint}}"],"path":["stockTransfers"],"query":[{"key":"createdFrom","value":"2010-08-01","description":"Initial create date to filter sales orders (required if not unitary search)"},{"key":"createdTo","value":"2020-08-26","description":"Final create date to filter sales orders (required if not unitary search)"},{"description":"Branch (optional in list search)","key":"branch","value":"1","disabled":true},{"description":"Product Primary Key in ERP (optional in list search)","key":"productKey","value":"C001","disabled":true},{"key":"erpKey","value":"53929","description":"Stock Transfer Primary Key in ERP (optional - unitary search)","disabled":true},{"description":"Stock Transfer Document Number in ERP (optional - unitary search)","key":"docNum","value":"121313","disabled":true},{"description":"Number of page - pagination (optional)","key":"pageNum","value":"2","disabled":true},{"description":"Date do filter modified registers - incremental search (optional)","key":"updatedAt","value":"2020-08-26T00:00:00","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-FRAME-OPTIONS","value":"SAMEORIGIN"},{"key":"Set-Cookie","value":"JSESSIONID=4F0BAF8445212D05205B3C573707F4AE; Path=/B1iXcellerator; HttpOnly"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"Thu, 01 Jan 1970 00:00:00 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Date","value":"Thu, 05 Nov 2020 14:03:27 GMT"},{"key":"Server","value":""}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"StockTransfers\",\n \"system\": \"sapBusinessOne\",\n \"target\": \"stockTransfers\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.108\",\n \"effectiveTimestamp\": \"2020-11-05T12:03:22\",\n \"createdFrom\": \"2010-08-01\",\n \"createdTo\": \"2020-08-26\",\n \"code\": \"200\",\n \"success\": true,\n \"useCustom\": \"\",\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 2,\n \"values\": [\n {\n \"branch\": \"1\",\n \"branchName\": \"MATRIZ\",\n \"erpKey\": \"5\",\n \"docNum\": \"5\",\n \"status\": \"O\",\n \"reference\": \"\",\n \"comments\": \"\",\n \"createdAt\": \"2017-05-10T12:34:19\",\n \"updatedAt\": \"2017-05-10T12:34:19\",\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"0\",\n \"productKey\": \"A00002\",\n \"codeBars\": \"\",\n \"productName\": \"Impressora 2\",\n \"measureUnit\": \"\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"05\",\n \"lineStatus\": \"O\",\n \"quantity\": 1,\n \"unitaryCost\": 250,\n \"totalCost\": 0\n },\n {\n \"lineNum\": \"0\",\n \"productKey\": \"A00002\",\n \"codeBars\": \"\",\n \"productName\": \"Impressora 2\",\n \"measureUnit\": \"\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": -1,\n \"unitaryCost\": 250,\n \"totalCost\": 0\n }\n ]\n },\n {\n \"branch\": \"1\",\n \"branchName\": \"MATRIZ\",\n \"erpKey\": \"6\",\n \"docNum\": \"6\",\n \"status\": \"O\",\n \"reference\": \"\",\n \"comments\": \"\",\n \"createdAt\": \"2017-05-10T12:34:51\",\n \"updatedAt\": \"2017-05-10T12:34:51\",\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"0\",\n \"productKey\": \"A00002\",\n \"codeBars\": \"\",\n \"productName\": \"Impressora 2\",\n \"measureUnit\": \"\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"O\",\n \"quantity\": 1,\n \"unitaryCost\": 250,\n \"totalCost\": 0\n },\n {\n \"lineNum\": \"0\",\n \"productKey\": \"A00002\",\n \"codeBars\": \"\",\n \"productName\": \"Impressora 2\",\n \"measureUnit\": \"\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"05\",\n \"lineStatus\": \"O\",\n \"quantity\": -1,\n \"unitaryCost\": 250,\n \"totalCost\": 0\n }\n ]\n }\n ]\n}"}],"_postman_id":"14d6b308-f86d-4ee0-8c5b-6f9086d807f4"},{"name":"Stock Transfer [NEW]","id":"39e5354d-5ec8-40e0-a35e-c406bdeb998f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"branch\": \"1\",\r\n \"whsCodeFrom\": \"01\",\r\n \"whsCodeTo\": \"02\",\r\n \"reference\":\"KS-000015\",\r\n \"comments\":\"THAIS DA SILVA\",\r\n \"items\": [\r\n {\r\n \"productKey\": \"A00006\",\r\n \"quantity\": 1\r\n }\r\n ]\r\n}"},"url":"{{endpoint}}/stockTransfers","description":"

Insert good issue in ERP

(sapBusinessOne=60/OIGE, totvsProtheus=SD3)

<<< NOT YET AVAILABLE. RELEASE IN 2020 Q4 >>>

This service will allow you to insert a new good issue on the ERP.

To insert a new good issue you need to inform branch and items. Optionally you can inform whsCode, reference and comments.

Products sent to the service will be validated for the search key. Products can be identified in the ERP in 2 ways:

SAP B1: OITM.CodeBars = codeBars or OITM.ItemCode = productKey
TOTVS Protheus: B1_CODBAR = codeBars or B1_COD = productKey

This service does not have user field (UDF) treatment.

Request object has the following properties

Field	Type	Description
branch	number	Branch
baseKey	string	Base Key
totalWeight	number	Total Weight
totalVolume	number	Total Volume
totalCubage	number	Total cubage
items	array	invoice Items Object
items.lineNum	string	number line
items.productKey	string	Product key
items.codeBars	string	Code bars
items.quantity	number	quantity
payments	array	Method
payments.paymentMethod	string	Payment Method
payments.amount	number	Amount
payments.installments	number	installments
payments.paymentMethod	string	Payment Method
payments.amount	number	Amount
payments.installments	number	installments
payments.details	object	details
payments.details.cardName	string	Card name
payments.details.acquirer	string	Acquire
payments.details.tid	string	tid
payments.details.authid	string	Authid
payments.details.nsu	string	nsu

* = Required field

Response object has the following properties

Field	Type	Description
package	string	package
process	string	Process
system	string	System
target	string	Target
user	string	User
host	string	Host
effectiveTimestamp	string	Effective Time stamp
code	string	Code
success	booleano	success
values	array	values
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp key
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp key
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp key

","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}},"urlObject":{"path":["stockTransfers"],"host":["{{endpoint}}"],"query":[],"variable":[]}},"response":[{"id":"522cf53e-139f-4558-84b6-beed14a4dab6","name":"Stock Transfer - TOTVS Protheus","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"branch\": \"3\",\r\n \"whsCodeFrom\": \"02\",\r\n \"whsCodeTo\": \"02-01\",\r\n \"reference\":\"ks-15\",\r\n \"comments\":\"TAIS NASCIMENTO DA SILVA\",\r\n \"items\": [\r\n {\r\n \"productKey\": \"PA00013\",\r\n \"#whsCode\": \"02\",\r\n \"quantity\": 40,\r\n \"#issueReason\": \"07\",\r\n \"#batchNumbers\": [\r\n {\r\n \"batchCode\": \"200661\",\r\n \"expirationDate\": \"2021-03-06\",\r\n \"quantity\": 40\r\n }\r\n ]\r\n },\r\n // TOTVS PROTHEUS: transfer in productKey and whsCode\r\n {\r\n \"productKey\": \"PA00014\",\r\n \"#whsCode\": \"02-TR\",\r\n \"quantity\": -40,\r\n \"#issueReason\": \"07\",\r\n \"#batchNumbers\": [\r\n {\r\n \"batchCode\": \"200661\",\r\n \"expirationDate\": \"2021-03-06\",\r\n \"quantity\": -40\r\n }\r\n ]\r\n }\r\n ]\r\n}"},"url":"{{endpoint}}/stockTransfer"},"status":"Internal Server Error","code":500,"_postman_previewlanguage":"html","header":[{"key":"X-FRAME-OPTIONS","value":"SAMEORIGIN"},{"key":"Set-Cookie","value":"JSESSIONID=AB6F932E698FD8CE120CA52A011827C3; Path=/B1iXcellerator; HttpOnly"},{"key":"Expires","value":"Thu, 01 Jan 1970 00:00:00 GMT"},{"key":"Content-Type","value":"text/html"},{"key":"Content-Length","value":"1524"},{"key":"Date","value":"Tue, 24 Aug 2021 14:44:05 GMT"},{"key":"Connection","value":"close"},{"key":"Server","value":""}],"cookie":[],"responseTime":null,"body":"\n \n \n SAP B1iP Error\n \n \n

SAP B1iP detected an error:

\n \n Emitted HTTP-Code:\n
500 - Internal Server Error\n \n

\n \n Internal Reason:\n

Server side cannot respond your request (No scenario step (vBIU) assigned for step for sender system (SysId) [0009] [incoming identifier = 'io'])

\n \n

\n \n Recommendation:\n
Check for the correctness of your activity or environment or ask your system-administrator for further help.\n \n

\n \n tid\n \n \n

TID: 21082410111444206184C0A80B0A65E3

\n \n

\n \n Full Internal Error Message:\n \n \n

com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception:
com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: com.sap.b1i.utilities.UtilException: UTE001 Nested exception: com.sap.engine.lib.xml.util.NestedException: Server side cannot respond your request (No scenario step (vBIU) assigned for step for sender system (SysId) [0009] [incoming identifier = 'io'])

\n \n

\n \n Log-ID:\n \n \n

LID21082410111444206518C0A80B0A3951

\n \n

\n\n"},{"id":"dc7e8e4c-409c-4a18-8f91-3335d2306ba6","name":"Stock Transfer - SAP Business One","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"branch\": \"1\",\r\n \"whsCodeFrom\": \"01\",\r\n \"whsCodeTo\": \"02\",\r\n \"reference\":\"KS-000015\",\r\n \"comments\":\"THAIS DA SILVA\",\r\n \"items\": [\r\n {\r\n \"productKey\": \"A00006\",\r\n \"quantity\": 1\r\n }\r\n ]\r\n}"},"url":"{{endpoint}}/stockTransfers"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"X-FRAME-OPTIONS","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"Thu, 01 Jan 1970 00:00:00 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Date","value":"Tue, 24 Aug 2021 19:34:31 GMT"},{"key":"Server","value":""}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"StockTransfers\",\n \"system\": \"sapBusinessOne\",\n \"target\": \"stockTransfers\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.104\",\n \"effectiveTimestamp\": \"2021-08-24T16:34:26\",\n \"code\": \"200\",\n \"success\": true,\n \"useCustom\": \"true\",\n \"values\": [\n {\n \"object\": \"67\",\n \"table\": \"STRF\",\n \"action\": \"Insert\",\n \"erpKey\": \"1001\"\n }\n ]\n}"}],"_postman_id":"39e5354d-5ec8-40e0-a35e-c406bdeb998f"}],"id":"a9435a89-5fdb-4e0f-ad8a-c99e9c9f7015","_postman_id":"a9435a89-5fdb-4e0f-ad8a-c99e9c9f7015","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}}},{"name":"Inventory","item":[{"name":"Inventory Countings","id":"99d84bc4-c15c-4f29-a5e5-e4a989d148d2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":"{{endpoint}}/inventoryCountings?createdFrom=2020-11-10&createdTo=2020-11-10&branch=1&productKey=MP000002&erpKey=53929&docNum=121313&pageNum=2&updatedAt=2020-08-26T00:00:00","description":"

Search inventory countings in ERP

(sapBusinessOne=1470000065/OINC, totvsProtheus=SB7)

This service will allow you to search inventory countings on the ERP.

Searching inventory countings allows you to filter the ERP by:

List search: by createdFrom + createdTo {required}, by branch, productKey {optional}
Unitary search: by erpKey or docNum

If no field for unitary query is provided in the request (erpKey or docNum), the query for inventory countings is carried out by creation date from/to (which become mandatory).

The inventory countings service will consider inventory countings with:

SAP Business One: [1] OINC.ObjType='1470000065'
TOTVS Protheus:

Comments:

branch: SAP Business One (OINC.BPLId), TOTVS Protheus (B7_FILIAL)
productKey: SAP Business One (INC1.ItemCode), TOTVS Protheus (B7_COD)
erpKey: SAP Business One (OINC.DocEntry), TOTVS Protheus (B7_DOC)
docNum: SAP Business One (OINC.DocNum), TOTVS Protheus (R_E_C_N_O_)
docStatus: O = open, C = closed, X=canceled

Data returned in response: inventory countings data

The response will inform:

The number of returned objects in the count field

For list search, the pagination feature in the response will be used, where the following fields are used to control the pagination:

pageSize = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
pageNum = desired page, provided in the request, and informed in the response. If pageNum not informed = 1, If pageNum <=0 = 1, If pageNum > pageTotal = last page
pageTotal = total pages, reported in the response
hasNext = if there are more pages (true / false), informed in the response

This service will allow you to search the inventory countings list in two situations:

Full Search: will result in all inventory countings, according to filters.
Incremental Search: will result in all inventory countings, according to filters, which have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH:MM:SS) will be used to determine which sales orders should be returned. This information will be used in conjunction with: [1] SAP Business One: the Creation Date and Document Update Date fields in SAP Business One (OINC.CreateDate, OINC.UpdateDate, OINC.CreateTS, OINC.UpdateTS), [2] TOTVS Protheus: fields B7_USERLGI and B7_USERLGA

This service does not have user field (UDF) treatment.

Initial create date to filter inventory countings (required if not unitary search)

\n","type":"text/plain"},"key":"createdFrom","value":"2020-11-10"},{"description":{"content":"

Final create date to filter inventory countings (required if not unitary search)

\n","type":"text/plain"},"key":"createdTo","value":"2020-11-10"},{"description":{"content":"

Branch (optional in list search)

\n","type":"text/plain"},"key":"branch","value":"1"},{"description":{"content":"

Product Primary Key in ERP (optional in list search)

\n","type":"text/plain"},"key":"productKey","value":"MP000002"},{"description":{"content":"

Inventory Counting Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpKey","value":"53929"},{"description":{"content":"

Inventory Counting Document Number in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"docNum","value":"121313"},{"description":{"content":"

Number of page - pagination (optional)

\n","type":"text/plain"},"key":"pageNum","value":"2"},{"description":{"content":"

Date do filter modified registers - incremental search (optional)

\n","type":"text/plain"},"key":"updatedAt","value":"2020-08-26T00:00:00"},{"disabled":true,"key":"status","value":"O"},{"disabled":true,"key":"takerKey","value":"C001"}],"variable":[]}},"response":[{"id":"3f8c40e5-e69f-42bb-b4b5-de8eddc525dd","name":"Inventory Countings - TOTVS Protheus","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/inventoryCountings?createdFrom=2020-11-10&createdTo=2020-11-10","host":["{{endpoint}}"],"path":["inventoryCountings"],"query":[{"key":"createdFrom","value":"2020-11-10","description":"Initial create date to filter inventory countings (required if not unitary search)"},{"key":"createdTo","value":"2020-11-10","description":"Final create date to filter inventory countings (required if not unitary search)"},{"key":"branch","value":"1","description":"Branch (optional in list search)","disabled":true},{"key":"productKey","value":"PA00256","description":"Product Primary Key in ERP (optional in list search)","disabled":true},{"key":"erpKey","value":"53929","description":"Inventory Counting Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"docNum","value":"121313","description":"Inventory Counting Document Number in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"2","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-08-26T00:00:00","description":"Date do filter modified registers - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Encoding","value":"gzip"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"GoodReceipts\",\n \"system\": \"totvsProtheus\",\n \"target\": \"goodReceipts\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.108\",\n \"effectiveTimestamp\": \"2020-11-10T19:15:59\",\n \"createdFrom\": \"2020-11-10\",\n \"createdTo\": \"2020-11-10\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"20201110\",\n \"docNum\": \"20201110\",\n \"status\": \"C\",\n \"reference\": null,\n \"comments\": null,\n \"takerKey\": null,\n \"countDate\": \"2020-11-10\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"1\",\n \"productKey\": \"MP000001\",\n \"codeBars\": \"\",\n \"productName\": \"MATERIA PRIMA\",\n \"measureUnit\": \"KG\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 10,\n \"difference\": null\n },\n {\n \"lineNum\": \"1\",\n \"productKey\": \"MP000002\",\n \"codeBars\": \"\",\n \"productName\": \"MATERIA PRIMA 2\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"01\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 25,\n \"difference\": null\n }\n ]\n }\n ],\n \"count\": 1\n}"},{"id":"5abc155d-eebd-43bf-8d24-d248efbb779e","name":"Inventory Countings - SAP Business One","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"url":{"raw":"{{endpoint}}/inventoryCountings?createdFrom=2020-01-01&createdTo=2020-09-30&productKey=PA00256","host":["{{endpoint}}"],"path":["inventoryCountings"],"query":[{"key":"createdFrom","value":"2020-01-01","description":"Initial create date to filter inventory countings (required if not unitary search)"},{"key":"createdTo","value":"2020-09-30","description":"Final create date to filter inventory countings (required if not unitary search)"},{"key":"branch","value":"1","description":"Branch (optional in list search)","disabled":true},{"key":"productKey","value":"PA00256","description":"Product Primary Key in ERP (optional in list search)"},{"key":"erpKey","value":"53929","description":"Inventory Counting Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"docNum","value":"121313","description":"Inventory Counting Document Number in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"2","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-08-26T00:00:00","description":"Date do filter modified registers - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Set-Cookie","value":"JSESSIONID=7A594E4B4A957BD349AF76C2E0E23020; Path=/B1iXcellerator; HttpOnly"},{"key":"X-FRAME-OPTIONS","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"Thu, 01 Jan 1970 00:00:00 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Date","value":"Thu, 01 Oct 2020 01:25:12 GMT"},{"key":"Server","value":""}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"InventoryCountings\",\n \"system\": \"sapBusinessOne\",\n \"target\": \"inventoryCountings\",\n \"user\": \"intergate\",\n \"host\": \"186.251.109.141\",\n \"effectiveTimestamp\": \"2020-09-30T22:25:03\",\n \"createdFrom\": \"2020-01-01\",\n \"createdTo\": \"2020-09-30\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"19\",\n \"branchName\": \"Alphaville\",\n \"erpKey\": \"1\",\n \"docNum\": \"1\",\n \"status\": \"C\",\n \"reference\": \"\",\n \"comments\": \"\",\n \"takerKey\": \"22\",\n \"countDate\": \"2020-01-14\",\n \"createdAt\": \"2020-01-14T19:53:00\",\n \"updatedAt\": \"2020-01-15T17:29:58\",\n \"canceledAt\": null,\n \"items\": [\n {\n \"lineNum\": \"1\",\n \"productKey\": \"PA00109\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE G - 160X320X150X40 - AMARELA - DOBRÁVEL\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 71,\n \"difference\": 71\n },\n {\n \"lineNum\": \"2\",\n \"productKey\": \"PA00256\",\n \"codeBars\": \"\",\n \"productName\": \"CHOCOLATE QUENTE AO LEITE EM PÓ 200G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 29,\n \"difference\": 29,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201761\",\n \"productionDate\": \"2020-06-30\",\n \"expirationDate\": \"2021-06-24\"\n }\n ]\n },\n {\n \"lineNum\": \"3\",\n \"productKey\": \"PA00005\",\n \"codeBars\": \"\",\n \"productName\": \"AGUA COM GAS\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 9,\n \"difference\": 9,\n \"batchNumbers\": [\n {\n \"batchCode\": \"1878\",\n \"productionDate\": \"2020-07-13\",\n \"expirationDate\": \"2021-01-13\"\n }\n ]\n },\n {\n \"lineNum\": \"4\",\n \"productKey\": \"PA00004\",\n \"codeBars\": \"\",\n \"productName\": \"AGUA SEM GÁS\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 5,\n \"difference\": 5,\n \"batchNumbers\": [\n {\n \"batchCode\": \"1655\",\n \"productionDate\": \"2020-01-23\",\n \"expirationDate\": \"2021-01-23\"\n },\n {\n \"batchCode\": \"1946\",\n \"productionDate\": \"\",\n \"expirationDate\": \"2021-08-24\"\n }\n ]\n },\n {\n \"lineNum\": \"5\",\n \"productKey\": \"PA00033\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO PARA CAFETERIA\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 33,\n \"difference\": 33,\n \"batchNumbers\": [\n {\n \"batchCode\": \"PL1\",\n \"productionDate\": \"\",\n \"expirationDate\": \"2021-07-31\"\n }\n ]\n },\n {\n \"lineNum\": \"6\",\n \"productKey\": \"PA00158\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO CARAMELO 2018 PEDRO BRÁS 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 56,\n \"difference\": 56,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"7\",\n \"productKey\": \"PA00163\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO CARLOS MENGALI 2018 - 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 16,\n \"difference\": 16,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"8\",\n \"productKey\": \"PA00162\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO CHOCOLATE 2018 PAULO MENGALI 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 23,\n \"difference\": 23,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"9\",\n \"productKey\": \"PA00159\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO CÍTRICO 2018 PAULINHO CRUZ 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 50,\n \"difference\": 50,\n \"batchNumbers\": [\n {\n \"batchCode\": \"CT4\",\n \"productionDate\": \"2019-11-01\",\n \"expirationDate\": \"2020-11-01\"\n }\n ]\n },\n {\n \"lineNum\": \"10\",\n \"productKey\": \"PA00164\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO PEDRO ROSSI 2018 - 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 25,\n \"difference\": 25,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"11\",\n \"productKey\": \"PA00149\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO FRUTADO 2018 MARCELO SANTOS 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 21,\n \"difference\": 21,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"12\",\n \"productKey\": \"PA00161\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO INTENSO 2018 JOSE CLOVIS 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 21,\n \"difference\": 21,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"13\",\n \"productKey\": \"PA00160\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO E MOÍDO MARCOS RICETTO 2018 - 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 53,\n \"difference\": 53,\n \"batchNumbers\": [\n {\n \"batchCode\": \"MR3\",\n \"productionDate\": \"2019-11-04\",\n \"expirationDate\": \"2020-11-04\"\n }\n ]\n },\n {\n \"lineNum\": \"14\",\n \"productKey\": \"PA00151\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO EM GRÃOS CARAMELO 2018 PEDRO BRÁS 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 48,\n \"difference\": 48,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"15\",\n \"productKey\": \"PA00156\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO EM GRÃOS CARLOS MENGALI 2018 - 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 20,\n \"difference\": 20,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"16\",\n \"productKey\": \"PA00155\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO EM GRÃOS CHOCOLATE 2018 PAULO MENGALI 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 15,\n \"difference\": 15,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"17\",\n \"productKey\": \"PA00152\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO EM GRÃOS CÍTRICO 2018 PAULINHO CRUZ 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 37,\n \"difference\": 37,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"18\",\n \"productKey\": \"PA00157\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO EM GRÃOS PEDRO ROSSI 2018 - 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 27,\n \"difference\": 27,\n \"batchNumbers\": [\n {\n \"batchCode\": \"PR2\",\n \"productionDate\": \"2019-11-05\",\n \"expirationDate\": \"2020-11-05\"\n }\n ]\n },\n {\n \"lineNum\": \"19\",\n \"productKey\": \"PA00154\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO EM GRÃOS INTENSO 2018 JOSE CLOVIS 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 22,\n \"difference\": 22,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"20\",\n \"productKey\": \"PA00153\",\n \"codeBars\": \"\",\n \"productName\": \"CAFÉ TORRADO EM GRÃOS MARCOS RICETTO 2018 - 250G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 19,\n \"difference\": 19,\n \"batchNumbers\": [\n {\n \"batchCode\": \"MR3\",\n \"productionDate\": \"2019-11-04\",\n \"expirationDate\": \"2020-11-04\"\n }\n ]\n },\n {\n \"lineNum\": \"21\",\n \"productKey\": \"PA00329\",\n \"codeBars\": \"\",\n \"productName\": \"PELUCIA ARARA BABY AZUL\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 7,\n \"difference\": 7\n },\n {\n \"lineNum\": \"22\",\n \"productKey\": \"PA00287\",\n \"codeBars\": \"\",\n \"productName\": \"CAFUNE BANANA 70G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 6,\n \"difference\": 6,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201921\",\n \"productionDate\": \"2020-07-10\",\n \"expirationDate\": \"2020-10-08\"\n },\n {\n \"batchCode\": \"202301\",\n \"productionDate\": \"2020-08-17\",\n \"expirationDate\": \"2020-11-15\"\n }\n ]\n },\n {\n \"lineNum\": \"23\",\n \"productKey\": \"PA00286\",\n \"codeBars\": \"\",\n \"productName\": \"CAFUNE COCO 70G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 7,\n \"difference\": 7,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"24\",\n \"productKey\": \"PA00284\",\n \"codeBars\": \"\",\n \"productName\": \"CAFUNE GOIABA 70G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 17,\n \"difference\": 17,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202331\",\n \"productionDate\": \"2020-08-20\",\n \"expirationDate\": \"2020-11-18\"\n }\n ]\n },\n {\n \"lineNum\": \"25\",\n \"productKey\": \"PA00285\",\n \"codeBars\": \"\",\n \"productName\": \"CAFUNE MARACUJA 70G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202531\",\n \"productionDate\": \"2020-09-09\",\n \"expirationDate\": \"2020-12-07\"\n }\n ]\n },\n {\n \"lineNum\": \"26\",\n \"productKey\": \"PA00066\",\n \"codeBars\": \"\",\n \"productName\": \"CAFUNE DRÁGEAS DE CÔCO TRONCO 50G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"27\",\n \"productKey\": \"PA00330\",\n \"codeBars\": \"\",\n \"productName\": \"PELUCIA LOBO GUARA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 8,\n \"difference\": 8\n },\n {\n \"lineNum\": \"28\",\n \"productKey\": \"PA00331\",\n \"codeBars\": \"\",\n \"productName\": \"PELUCIA LONTRA TORTINHA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 10,\n \"difference\": 10\n },\n {\n \"lineNum\": \"29\",\n \"productKey\": \"PA00332\",\n \"codeBars\": \"\",\n \"productName\": \"PELUCIA MACACO ARANHA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 8,\n \"difference\": 8\n },\n {\n \"lineNum\": \"30\",\n \"productKey\": \"PA00307\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE M 255X210X70 - VERMELHA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 26,\n \"difference\": 26\n },\n {\n \"lineNum\": \"31\",\n \"productKey\": \"MC00312\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA DENGOS A GRANEL\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 881,\n \"difference\": 881\n },\n {\n \"lineNum\": \"32\",\n \"productKey\": \"PA00308\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE M 255X210X70 - AMARELA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 19,\n \"difference\": 19\n },\n {\n \"lineNum\": \"33\",\n \"productKey\": \"PA00305\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE P 190X210X70 - AMARELA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 24,\n \"difference\": 24\n },\n {\n \"lineNum\": \"34\",\n \"productKey\": \"PA00108\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE G - 160X320X150X40 - LARANJA - DOBRÁVEL\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 14,\n \"difference\": 14\n },\n {\n \"lineNum\": \"35\",\n \"productKey\": \"PA00107\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE G - 160X320X150X40 - VERMELHO - DOBRÁVEL\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 78,\n \"difference\": 78\n },\n {\n \"lineNum\": \"36\",\n \"productKey\": \"PA00311\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA CLASSICOS DA FLORESTA 300G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 35,\n \"difference\": 35,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202271\",\n \"productionDate\": \"2020-08-14\",\n \"expirationDate\": \"2020-10-27\"\n }\n ]\n },\n {\n \"lineNum\": \"37\",\n \"productKey\": \"PA00260\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA DE BOMBONS 12 UNIDADES\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 15,\n \"difference\": 15,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"38\",\n \"productKey\": \"PA00120\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA DE BOMBOM 6 UNIDADES\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 17,\n \"difference\": 17,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202521\",\n \"productionDate\": \"2020-09-08\",\n \"expirationDate\": \"2020-11-08\"\n }\n ]\n },\n {\n \"lineNum\": \"39\",\n \"productKey\": \"PA00194\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA DE BOMBOM 18 UNIDADES\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 1,\n \"difference\": 1,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202461\",\n \"productionDate\": \"2020-09-02\",\n \"expirationDate\": \"2020-11-01\"\n }\n ]\n },\n {\n \"lineNum\": \"40\",\n \"productKey\": \"PA00306\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE P 190X210X70 - KRAFT\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 78,\n \"difference\": 78\n },\n {\n \"lineNum\": \"41\",\n \"productKey\": \"PA00310\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE M 255X210X70 - KRAFT\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 57,\n \"difference\": 57\n },\n {\n \"lineNum\": \"42\",\n \"productKey\": \"PA00309\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE M 255X210X70 - LARANJA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 40,\n \"difference\": 40\n },\n {\n \"lineNum\": \"43\",\n \"productKey\": \"PA00304\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE P 190X210X70 - LARANJA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 17,\n \"difference\": 17\n },\n {\n \"lineNum\": \"44\",\n \"productKey\": \"PA00113\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA DIVERSOS - 180X130X40 (LOJA)\",\n \"measureUnit\": \"MI\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 129,\n \"difference\": 129\n },\n {\n \"lineNum\": \"45\",\n \"productKey\": \"PA00327\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA MEIO QUEBRA-QUEBRA PRESENTE AMARELA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 88,\n \"difference\": 88\n },\n {\n \"lineNum\": \"46\",\n \"productKey\": \"PA00303\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA QUEBRA-QUEBRA PRESENTE AMARELA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 20,\n \"difference\": 20\n },\n {\n \"lineNum\": \"47\",\n \"productKey\": \"PA00324\",\n \"codeBars\": \"\",\n \"productName\": \"CAIXA PRESENTE P 190X210X70 - VERMELHA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 14,\n \"difference\": 14\n },\n {\n \"lineNum\": \"48\",\n \"productKey\": \"PA00267\",\n \"codeBars\": \"\",\n \"productName\": \"CERVEJA DENGO AMERICAN PILSEN CACAU/CAFÉ 300ML\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 24,\n \"difference\": 24,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"49\",\n \"productKey\": \"PA00266\",\n \"codeBars\": \"\",\n \"productName\": \"CERVEJA DENGO PORTER CAFÉ 300ML\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 90,\n \"difference\": 90,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"50\",\n \"productKey\": \"PA00265\",\n \"codeBars\": \"\",\n \"productName\": \"CERVEJA DENGO STRONG ALE CACAU 300ML\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 31,\n \"difference\": 31,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"51\",\n \"productKey\": \"PA00232\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 58% CACAU 20G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 67,\n \"difference\": 67,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201601\",\n \"productionDate\": \"2020-06-11\",\n \"expirationDate\": \"2021-06-08\"\n }\n ]\n },\n {\n \"lineNum\": \"52\",\n \"productKey\": \"PA00014\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 58% CACAU 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 61,\n \"difference\": 61,\n \"batchNumbers\": [\n {\n \"batchCode\": \"200511\",\n \"productionDate\": \"2020-02-20\",\n \"expirationDate\": \"2021-02-20\"\n },\n {\n \"batchCode\": \"202091\",\n \"productionDate\": \"2020-07-27\",\n \"expirationDate\": \"2021-07-27\"\n }\n ]\n },\n {\n \"lineNum\": \"53\",\n \"productKey\": \"PA00233\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 65% CACAU 20G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": [\n {\n \"batchCode\": \"200341\",\n \"productionDate\": \"2020-02-03\",\n \"expirationDate\": \"2021-02-02\"\n },\n {\n \"batchCode\": \"202051\",\n \"productionDate\": \"2020-07-23\",\n \"expirationDate\": \"2021-07-23\"\n }\n ]\n },\n {\n \"lineNum\": \"54\",\n \"productKey\": \"PA00240\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 65% CACAU 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 108,\n \"difference\": 108,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201681\",\n \"productionDate\": \"2020-06-16\",\n \"expirationDate\": \"2021-06-16\"\n },\n {\n \"batchCode\": \"202181\",\n \"productionDate\": \"2020-08-05\",\n \"expirationDate\": \"2021-08-05\"\n }\n ]\n },\n {\n \"lineNum\": \"55\",\n \"productKey\": \"PA00236\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 65% CACAU ZERO AÇÚCAR 20G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 101,\n \"difference\": 101,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201671\",\n \"productionDate\": \"2020-06-16\",\n \"expirationDate\": \"2021-06-15\"\n }\n ]\n },\n {\n \"lineNum\": \"56\",\n \"productKey\": \"PA00243\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 65% CACAU ZERO AÇÚCAR 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 95,\n \"difference\": 95,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202171\",\n \"productionDate\": \"2020-08-04\",\n \"expirationDate\": \"2021-08-04\"\n }\n ]\n },\n {\n \"lineNum\": \"57\",\n \"productKey\": \"PA00234\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 70% CACAU 20G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 51,\n \"difference\": 51,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201611\",\n \"productionDate\": \"2020-06-09\",\n \"expirationDate\": \"2021-06-09\"\n },\n {\n \"batchCode\": \"202061\",\n \"productionDate\": \"2020-07-24\",\n \"expirationDate\": \"2021-07-24\"\n }\n ]\n },\n {\n \"lineNum\": \"58\",\n \"productKey\": \"PA00241\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 70% CACAU 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 3,\n \"difference\": 3,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202181\",\n \"productionDate\": \"2020-08-05\",\n \"expirationDate\": \"2021-08-05\"\n }\n ]\n },\n {\n \"lineNum\": \"59\",\n \"productKey\": \"PA00143\",\n \"codeBars\": \"\",\n \"productName\": \"CHOCOLATE AMARGO 70% VARIETAL PH 16 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 19,\n \"difference\": 19,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201951\",\n \"productionDate\": \"2020-07-14\",\n \"expirationDate\": \"2021-07-13\"\n }\n ]\n },\n {\n \"lineNum\": \"60\",\n \"productKey\": \"PA00235\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 75% CACAU 20G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 16,\n \"difference\": 16,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201611\",\n \"productionDate\": \"2020-06-11\",\n \"expirationDate\": \"2021-06-09\"\n }\n ]\n },\n {\n \"lineNum\": \"61\",\n \"productKey\": \"PA00209\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AMARGO 85% CACAU 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202241\",\n \"productionDate\": \"2020-08-11\",\n \"expirationDate\": \"2021-08-11\"\n }\n ]\n },\n {\n \"lineNum\": \"62\",\n \"productKey\": \"PA00230\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AO LEITE 36% CACAU 20G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": [\n {\n \"batchCode\": \"200591\",\n \"productionDate\": \"2020-02-28\",\n \"expirationDate\": \"2021-02-28\"\n },\n {\n \"batchCode\": \"200731\",\n \"productionDate\": \"2020-07-02\",\n \"expirationDate\": \"2021-03-13\"\n }\n ]\n },\n {\n \"lineNum\": \"63\",\n \"productKey\": \"PA00237\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AO LEITE 36% CACAU 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 28,\n \"difference\": 28,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202041\",\n \"productionDate\": \"2020-07-22\",\n \"expirationDate\": \"2021-07-22\"\n }\n ]\n },\n {\n \"lineNum\": \"64\",\n \"productKey\": \"PA00231\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AO LEITE 50% CACAU 20G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": [\n {\n \"batchCode\": \"200661\",\n \"productionDate\": \"2020-03-06\",\n \"expirationDate\": \"2021-03-06\"\n },\n {\n \"batchCode\": \"202131\",\n \"productionDate\": \"2020-08-10\",\n \"expirationDate\": \"2021-07-31\"\n }\n ]\n },\n {\n \"lineNum\": \"65\",\n \"productKey\": \"PA00013\",\n \"codeBars\": \"\",\n \"productName\": \"BARRA CHOCOLATE AO LEITE 50% CACAU 80G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 86,\n \"difference\": 86,\n \"batchNumbers\": [\n {\n \"batchCode\": \"200661\",\n \"productionDate\": \"2020-03-06\",\n \"expirationDate\": \"2021-03-06\"\n },\n {\n \"batchCode\": \"202111\",\n \"productionDate\": \"2020-07-29\",\n \"expirationDate\": \"2021-07-29\"\n }\n ]\n },\n {\n \"lineNum\": \"66\",\n \"productKey\": \"PA00205\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA 0% AÇÚCARES MANGA E MACADAMIA 200G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 77,\n \"difference\": 77,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202171\",\n \"productionDate\": \"2020-08-04\",\n \"expirationDate\": \"2020-11-01\"\n },\n {\n \"batchCode\": \"202411\",\n \"productionDate\": \"2020-08-28\",\n \"expirationDate\": \"2020-12-11\"\n }\n ]\n },\n {\n \"lineNum\": \"67\",\n \"productKey\": \"PA00102\",\n \"codeBars\": \"\",\n \"productName\": \"CHOCOLATE QUEBRA-QUEBRA ABACAXI COM COCO 200G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 43,\n \"difference\": 43,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202231\",\n \"productionDate\": \"2020-08-10\",\n \"expirationDate\": \"2020-10-09\"\n },\n {\n \"batchCode\": \"202441\",\n \"productionDate\": \"2020-08-31\",\n \"expirationDate\": \"2020-11-25\"\n }\n ]\n },\n {\n \"lineNum\": \"68\",\n \"productKey\": \"PA00099\",\n \"codeBars\": \"\",\n \"productName\": \"CHOCOLATE QUEBRA-QUEBRA BANANA E CASTANHA DE CAJU 200G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 84,\n \"difference\": 84,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202471\",\n \"productionDate\": \"2020-09-03\",\n \"expirationDate\": \"2020-12-01\"\n }\n ]\n },\n {\n \"lineNum\": \"69\",\n \"productKey\": \"PA00101\",\n \"codeBars\": \"\",\n \"productName\": \"CHOCOLATE QUEBRA-QUEBRA CUPUAÇU COM CASTANHA DE CAJU 200G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 23,\n \"difference\": 23,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202451\",\n \"productionDate\": \"2020-09-01\",\n \"expirationDate\": \"2020-11-29\"\n },\n {\n \"batchCode\": \"202051\",\n \"productionDate\": \"2020-07-23\",\n \"expirationDate\": \"2029-10-18\"\n }\n ]\n },\n {\n \"lineNum\": \"70\",\n \"productKey\": \"PA00090\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO BANANA 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 43,\n \"difference\": 43,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201841\",\n \"productionDate\": \"2020-07-02\",\n \"expirationDate\": \"2020-10-29\"\n },\n {\n \"batchCode\": \"202251\",\n \"productionDate\": \"2020-08-12\",\n \"expirationDate\": \"2020-11-10\"\n }\n ]\n },\n {\n \"lineNum\": \"71\",\n \"productKey\": \"PA00010\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO CACHAÇA 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 232,\n \"difference\": 232,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201991\",\n \"productionDate\": \"2020-07-17\",\n \"expirationDate\": \"2020-10-15\"\n }\n ]\n },\n {\n \"lineNum\": \"72\",\n \"productKey\": \"PA00092\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO CASTANHA DE CAJU 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 67,\n \"difference\": 67,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201771\",\n \"productionDate\": \"2020-06-25\",\n \"expirationDate\": \"2020-10-23\"\n }\n ]\n },\n {\n \"lineNum\": \"73\",\n \"productKey\": \"PA00095\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO CUMARU 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 53,\n \"difference\": 53,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202111\",\n \"productionDate\": \"2020-07-29\",\n \"expirationDate\": \"2020-10-27\"\n },\n {\n \"batchCode\": \"202181\",\n \"productionDate\": \"2020-08-05\",\n \"expirationDate\": \"2020-11-03\"\n }\n ]\n },\n {\n \"lineNum\": \"74\",\n \"productKey\": \"PA00060\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO DE LARANJA ZERO ACUCAR 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 116,\n \"difference\": 116,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202231\",\n \"productionDate\": \"2020-08-10\",\n \"expirationDate\": \"2020-11-08\"\n }\n ]\n },\n {\n \"lineNum\": \"75\",\n \"productKey\": \"PA00087\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO GANACHE AMARGO 70% 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 144,\n \"difference\": 144,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202441\",\n \"productionDate\": \"2020-08-31\",\n \"expirationDate\": \"2020-11-29\"\n }\n ]\n },\n {\n \"lineNum\": \"76\",\n \"productKey\": \"PA00086\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO GANACHE AO LEITE 50% 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 138,\n \"difference\": 138,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202131\",\n \"productionDate\": \"2020-07-31\",\n \"expirationDate\": \"2020-10-29\"\n },\n {\n \"batchCode\": \"202441\",\n \"productionDate\": \"2020-09-01\",\n \"expirationDate\": \"2020-11-29\"\n }\n ]\n },\n {\n \"lineNum\": \"77\",\n \"productKey\": \"PA00093\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO GANACHE DE CAFÉ 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 128,\n \"difference\": 128,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202061\",\n \"productionDate\": \"2020-07-24\",\n \"expirationDate\": \"2020-10-22\"\n }\n ]\n },\n {\n \"lineNum\": \"78\",\n \"productKey\": \"PA00091\",\n \"codeBars\": \"\",\n \"productName\": \"DENGO JABUTICABA 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 211,\n \"difference\": 211,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202121\",\n \"productionDate\": \"2020-07-31\",\n \"expirationDate\": \"2020-10-28\"\n },\n {\n \"batchCode\": \"202271\",\n \"productionDate\": \"2020-08-14\",\n \"expirationDate\": \"2020-11-12\"\n }\n ]\n },\n {\n \"lineNum\": \"79\",\n \"productKey\": \"PA00280\",\n \"codeBars\": \"\",\n \"productName\": \"DRÁGEAS DE CAFÉ COM CHOCOLATE AMARGO 120G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201881\",\n \"productionDate\": \"2020-07-08\",\n \"expirationDate\": \"2020-11-03\"\n },\n {\n \"batchCode\": \"202111\",\n \"productionDate\": \"2020-07-31\",\n \"expirationDate\": \"2020-11-26\"\n }\n ]\n },\n {\n \"lineNum\": \"80\",\n \"productKey\": \"PA00279\",\n \"codeBars\": \"\",\n \"productName\": \"DRÁGEAS DE CAFÉ COM CHOCOLATE AO LEITE 120G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 22,\n \"difference\": 22,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201741\",\n \"productionDate\": \"2020-06-29\",\n \"expirationDate\": \"2020-10-20\"\n }\n ]\n },\n {\n \"lineNum\": \"81\",\n \"productKey\": \"PA00206\",\n \"codeBars\": \"\",\n \"productName\": \"DRÁGEAS DE CASTANHA DE CAJU COM CHOCOLATE AMARGO TO GO 150G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 64,\n \"difference\": 64,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201921\",\n \"productionDate\": \"2020-07-10\",\n \"expirationDate\": \"2020-11-05\"\n },\n {\n \"batchCode\": \"201971\",\n \"productionDate\": \"2020-07-15\",\n \"expirationDate\": \"2020-11-10\"\n },\n {\n \"batchCode\": \"202381\",\n \"productionDate\": \"2020-08-25\",\n \"expirationDate\": \"2020-12-15\"\n },\n {\n \"batchCode\": \"202481\",\n \"productionDate\": \"2020-09-04\",\n \"expirationDate\": \"2021-01-01\"\n }\n ]\n },\n {\n \"lineNum\": \"83\",\n \"productKey\": \"PA00036\",\n \"codeBars\": \"\",\n \"productName\": \"DRÁGEAS DE CASTANHA DE CAJÚ KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 25,\n \"difference\": 25,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202051\",\n \"productionDate\": \"2020-07-23\",\n \"expirationDate\": \"2020-11-20\"\n },\n {\n \"batchCode\": \"202261\",\n \"productionDate\": \"2020-08-13\",\n \"expirationDate\": \"2020-12-11\"\n },\n {\n \"batchCode\": \"202271\",\n \"productionDate\": \"2020-08-14\",\n \"expirationDate\": \"2020-12-12\"\n }\n ]\n },\n {\n \"lineNum\": \"84\",\n \"productKey\": \"PA00281\",\n \"codeBars\": \"\",\n \"productName\": \"DRÁGEAS DE MACADÂMIA KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 5,\n \"difference\": 5,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202191\",\n \"productionDate\": \"2020-08-06\",\n \"expirationDate\": \"2020-12-04\"\n },\n {\n \"batchCode\": \"202251\",\n \"productionDate\": \"2020-08-12\",\n \"expirationDate\": \"2020-12-10\"\n }\n ]\n },\n {\n \"lineNum\": \"85\",\n \"productKey\": \"PA00296\",\n \"codeBars\": \"\",\n \"productName\": \"GUIRLANDA P BANANA 200G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"86\",\n \"productKey\": \"PA00297\",\n \"codeBars\": \"\",\n \"productName\": \"GUIRLANDA P ZERO AÇÚCAR MACADAMIA E MANGA 200G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"87\",\n \"productKey\": \"PA00268\",\n \"codeBars\": \"\",\n \"productName\": \"MEL DE CACAU 275ML\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 30,\n \"difference\": 30,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"88\",\n \"productKey\": \"PA00254\",\n \"codeBars\": \"\",\n \"productName\": \"NIBS DE CACAU PURO 50G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 2,\n \"difference\": 2,\n \"batchNumbers\": [\n {\n \"batchCode\": \"200653\",\n \"productionDate\": \"2020-03-09\",\n \"expirationDate\": \"2021-03-05\"\n },\n {\n \"batchCode\": \"202335\",\n \"productionDate\": \"2020-08-24\",\n \"expirationDate\": \"2021-08-20\"\n }\n ]\n },\n {\n \"lineNum\": \"89\",\n \"productKey\": \"PA00255\",\n \"codeBars\": \"\",\n \"productName\": \"NIBS DE CACAU SALGADO 50G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201971\",\n \"productionDate\": \"2020-07-16\",\n \"expirationDate\": \"2021-01-11\"\n }\n ]\n },\n {\n \"lineNum\": \"90\",\n \"productKey\": \"PA00313\",\n \"codeBars\": \"\",\n \"productName\": \"PANELINHA CERAMICA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": false,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0\n },\n {\n \"lineNum\": \"91\",\n \"productKey\": \"PA00288\",\n \"codeBars\": \"\",\n \"productName\": \"PANETONE CUPUAÇU COM GOTAS DE CHOCOLATE\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"92\",\n \"productKey\": \"PA00290\",\n \"codeBars\": \"\",\n \"productName\": \"PANETONE GOIABA COM COCO\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 66,\n \"difference\": 66,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"93\",\n \"productKey\": \"PA00289\",\n \"codeBars\": \"\",\n \"productName\": \"PANETONE RECHADO GANACHE VINHO DE CACAU\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 0,\n \"difference\": 0,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"94\",\n \"productKey\": \"PA00282\",\n \"codeBars\": \"\",\n \"productName\": \"PEPITA ZERO AÇÚCAR KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 19,\n \"difference\": 19,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202091\",\n \"productionDate\": \"2020-07-27\",\n \"expirationDate\": \"2020-11-21\"\n }\n ]\n },\n {\n \"lineNum\": \"95\",\n \"productKey\": \"PA00239\",\n \"codeBars\": \"\",\n \"productName\": \"PEPITAS COM AÇÚCAR MASCAVO 150G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 89,\n \"difference\": 89,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201741\",\n \"productionDate\": \"2020-06-22\",\n \"expirationDate\": \"2020-11-09\"\n },\n {\n \"batchCode\": \"201921\",\n \"productionDate\": \"2020-07-10\",\n \"expirationDate\": \"2020-12-06\"\n },\n {\n \"batchCode\": \"202021\",\n \"productionDate\": \"2020-07-20\",\n \"expirationDate\": \"2020-12-14\"\n },\n {\n \"batchCode\": \"202461\",\n \"productionDate\": \"2020-09-02\",\n \"expirationDate\": \"2021-01-11\"\n }\n ]\n },\n {\n \"lineNum\": \"97\",\n \"productKey\": \"PA00262\",\n \"codeBars\": \"\",\n \"productName\": \"PEPITAS COM MASCAVO KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 15,\n \"difference\": 15,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202401\",\n \"productionDate\": \"2020-08-27\",\n \"expirationDate\": \"2020-12-24\"\n },\n {\n \"batchCode\": \"202101\",\n \"productionDate\": \"2020-07-28\",\n \"expirationDate\": \"2020-12-25\"\n }\n ]\n },\n {\n \"lineNum\": \"98\",\n \"productKey\": \"PA00238\",\n \"codeBars\": \"\",\n \"productName\": \"PEPITAS COM PÓ DE CACAU 150G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 46,\n \"difference\": 46,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202172\",\n \"productionDate\": \"2020-08-04\",\n \"expirationDate\": \"2020-12-27\"\n },\n {\n \"batchCode\": \"202331\",\n \"productionDate\": \"2020-08-20\",\n \"expirationDate\": \"2021-01-16\"\n }\n ]\n },\n {\n \"lineNum\": \"99\",\n \"productKey\": \"PA00261\",\n \"codeBars\": \"\",\n \"productName\": \"PEPITAS COM PÓ DE CACAU KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 11,\n \"difference\": 11,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202061\",\n \"productionDate\": \"2020-07-24\",\n \"expirationDate\": \"2020-11-19\"\n },\n {\n \"batchCode\": \"202131\",\n \"productionDate\": \"2020-07-31\",\n \"expirationDate\": \"2020-12-28\"\n },\n {\n \"batchCode\": \"202171\",\n \"productionDate\": \"2020-08-04\",\n \"expirationDate\": \"2021-01-01\"\n }\n ]\n },\n {\n \"lineNum\": \"101\",\n \"productKey\": \"PA00283\",\n \"codeBars\": \"\",\n \"productName\": \"PEPITA ZERO AÇÚCAR 150G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 116,\n \"difference\": 116,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201881\",\n \"productionDate\": \"2020-07-06\",\n \"expirationDate\": \"2020-11-20\"\n },\n {\n \"batchCode\": \"201971\",\n \"productionDate\": \"2020-07-15\",\n \"expirationDate\": \"2020-12-11\"\n }\n ]\n },\n {\n \"lineNum\": \"104\",\n \"productKey\": \"PA00300\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA QUEBRA PANETONE COM PECAN\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 16,\n \"difference\": 16,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"105\",\n \"productKey\": \"PA00062\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA 0% AÇÚCAR MANGA E MACADAMIA KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 7,\n \"difference\": 7,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202161\",\n \"productionDate\": \"2020-08-03\",\n \"expirationDate\": \"2020-11-01\"\n }\n ]\n },\n {\n \"lineNum\": \"106\",\n \"productKey\": \"PA00247\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA ABACAXI E COCO KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 17,\n \"difference\": 17,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202231\",\n \"productionDate\": \"2020-08-10\",\n \"expirationDate\": \"2020-10-09\"\n }\n ]\n },\n {\n \"lineNum\": \"107\",\n \"productKey\": \"PA00248\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA BANANA KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 15,\n \"difference\": 15,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202341\",\n \"productionDate\": \"2020-08-21\",\n \"expirationDate\": \"2020-11-19\"\n },\n {\n \"batchCode\": \"202461\",\n \"productionDate\": \"2020-09-02\",\n \"expirationDate\": \"2020-12-01\"\n },\n {\n \"batchCode\": \"202481\",\n \"productionDate\": \"2020-09-04\",\n \"expirationDate\": \"2020-12-03\"\n }\n ]\n },\n {\n \"lineNum\": \"108\",\n \"productKey\": \"PA00104\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA BIJU 200G TO GO\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 53,\n \"difference\": 53,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202181\",\n \"productionDate\": \"2020-08-05\",\n \"expirationDate\": \"2020-11-02\"\n },\n {\n \"batchCode\": \"202261\",\n \"productionDate\": \"2020-08-13\",\n \"expirationDate\": \"2020-11-10\"\n },\n {\n \"batchCode\": \"202521\",\n \"productionDate\": \"2020-09-08\",\n \"expirationDate\": \"2020-11-25\"\n }\n ]\n },\n {\n \"lineNum\": \"109\",\n \"productKey\": \"PA00055\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA BIJU 44% CACAU KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 10,\n \"difference\": 10,\n \"batchNumbers\": [\n {\n \"batchCode\": \"201981\",\n \"productionDate\": \"2020-07-16\",\n \"expirationDate\": \"2020-10-14\"\n },\n {\n \"batchCode\": \"202171\",\n \"productionDate\": \"2020-08-04\",\n \"expirationDate\": \"2020-11-02\"\n },\n {\n \"batchCode\": \"202351\",\n \"productionDate\": \"2020-08-24\",\n \"expirationDate\": \"2020-11-22\"\n }\n ]\n },\n {\n \"lineNum\": \"110\",\n \"productKey\": \"PA00249\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA CASTANHA DE CAJU COM CUPUAÇU KG\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 14,\n \"difference\": 14,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202441\",\n \"productionDate\": \"2020-08-31\",\n \"expirationDate\": \"2020-11-29\"\n }\n ]\n },\n {\n \"lineNum\": \"111\",\n \"productKey\": \"PA00244\",\n \"codeBars\": \"\",\n \"productName\": \"QUEBRA-QUEBRA I GIANDUIA\",\n \"measureUnit\": \"KG\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 13,\n \"difference\": 13,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202451\",\n \"productionDate\": \"2020-09-01\",\n \"expirationDate\": \"2020-10-31\"\n }\n ]\n },\n {\n \"lineNum\": \"112\",\n \"productKey\": \"PA00322\",\n \"codeBars\": \"\",\n \"productName\": \"CROCANTE DE CASTANHA DO PARA COM CUMARU 100G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 26,\n \"difference\": 26,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"113\",\n \"productKey\": \"PA00321\",\n \"codeBars\": \"\",\n \"productName\": \"CROCANTE DE MACADAMIA COM LARANJA 100G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 53,\n \"difference\": 53,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"114\",\n \"productKey\": \"PA00291\",\n \"codeBars\": \"\",\n \"productName\": \"TRIO DE BARRAS - CLUTCH NATAL - 120G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 30,\n \"difference\": 30,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"115\",\n \"productKey\": \"PA00299\",\n \"codeBars\": \"\",\n \"productName\": \"TRONCO DE GIANDUIA\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 42,\n \"difference\": 42,\n \"batchNumbers\": []\n },\n {\n \"lineNum\": \"116\",\n \"productKey\": \"PA00328\",\n \"codeBars\": \"\",\n \"productName\": \"TRUFA DE GANACHE AMARGA 12G\",\n \"measureUnit\": \"UN\",\n \"batchControl\": true,\n \"serialControl\": false,\n \"whsCode\": \"24\",\n \"lineStatus\": \"C\",\n \"counted\": true,\n \"countedQuantity\": 589,\n \"difference\": 589,\n \"batchNumbers\": [\n {\n \"batchCode\": \"202391\",\n \"productionDate\": \"2020-08-26\",\n \"expirationDate\": \"2020-11-24\"\n }\n ]\n }\n ]\n }\n ]\n}"}],"_postman_id":"99d84bc4-c15c-4f29-a5e5-e4a989d148d2"},{"name":"Inventory Countings","id":"6f72af1d-b61c-4614-831b-80a805276ac8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","type":"text","value":"application/json"}],"body":{"mode":"raw","raw":"{\r\n \"branch\": \"17\",\r\n \"docNum\": \"77\",\r\n \"#erpKey\": \"9\",\r\n \"reference\": \"KAIROS-68\",\r\n \"items\": [\r\n {\r\n \"#lineNum\": 1,\r\n \"productKey\": \"PA00646\",\r\n \"#whsCode\": \"12\",\r\n \"countedQuantity\": 804,\r\n \"costCenter\": \"3.02\",\r\n \"batchNumbers\": [\r\n {\r\n \"batchCode\": \"212242\",\r\n \"#expirationDate\": \"2021-03-06\",\r\n \"countedQuantity\": 804\r\n }\r\n ]\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/inventoryCountings","description":"

Search inventory countings in ERP

(sapBusinessOne=1470000065/OINC, totvsProtheus=SB7)

This service will allow you to search inventory countings on the ERP.

Searching inventory countings allows you to filter the ERP by:

List search: by createdFrom + createdTo {required}, by branch, productKey {optional}
Unitary search: by erpKey or docNum

If no field for unitary query is provided in the request (erpKey or docNum), the query for inventory countings is carried out by creation date from/to (which become mandatory).

The inventory countings service will consider inventory countings with:

SAP Business One: [1] OINC.ObjType='1470000065'
TOTVS Protheus:

Comments:

branch: SAP Business One (OINC.BPLId), TOTVS Protheus (B7_FILIAL)
productKey: SAP Business One (INC1.ItemCode), TOTVS Protheus (B7_COD)
erpKey: SAP Business One (OINC.DocEntry), TOTVS Protheus (B7_DOC)
docNum: SAP Business One (OINC.DocNum), TOTVS Protheus (R_E_C_N_O_)
docStatus: O = open, C = closed, X=canceled

Data returned in response: inventory countings data

The response will inform:

The number of returned objects in the count field

For list search, the pagination feature in the response will be used, where the following fields are used to control the pagination:

pageSize = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
pageNum = desired page, provided in the request, and informed in the response. If pageNum not informed = 1, If pageNum <=0 = 1, If pageNum > pageTotal = last page
pageTotal = total pages, reported in the response
hasNext = if there are more pages (true / false), informed in the response

This service will allow you to search the inventory countings list in two situations:

Full Search: will result in all inventory countings, according to filters.
Incremental Search: will result in all inventory countings, according to filters, which have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH:MM:SS) will be used to determine which sales orders should be returned. This information will be used in conjunction with: [1] SAP Business One: the Creation Date and Document Update Date fields in SAP Business One (OINC.CreateDate, OINC.UpdateDate, OINC.CreateTS, OINC.UpdateTS), [2] TOTVS Protheus: fields B7_USERLGI and B7_USERLGA

This service does not have user field (UDF) treatment.

\n","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}},"urlObject":{"path":["inventoryCountings"],"host":["{{endpoint}}"],"query":[],"variable":[]}},"response":[{"id":"8f225333-d050-47a7-ae3a-315ebf6f4664","name":"Inventory Countings - SAP Business One","originalRequest":{"method":"POST","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n \"branch\": \"9\",\r\n \"docNum\": \"13\",\r\n \"#erpKey\": \"9\",\r\n \"items\": [\r\n {\r\n \"#lineNum\": 1,\r\n \"productKey\": \"PA00261\",\r\n \"#whsCode\": \"12\",\r\n \"countedQuantity\": 12,\r\n \"batchNumbers\": [\r\n {\r\n \"batchCode\": \"200651\",\r\n \"#expirationDate\": \"2021-03-06\",\r\n \"countedQuantity\": 3\r\n },\r\n {\r\n \"batchCode\": \"200721B\",\r\n \"#expirationDate\": \"2021-03-06\",\r\n \"countedQuantity\": 4\r\n },\r\n {\r\n \"batchCode\": \"200721C\",\r\n \"#expirationDate\": \"2021-03-06\",\r\n \"countedQuantity\": 5\r\n }\r\n ]\r\n }\r\n ]\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/inventoryCountings"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Set-Cookie","value":"JSESSIONID=7A594E4B4A957BD349AF76C2E0E23020; Path=/B1iXcellerator; HttpOnly"},{"key":"X-FRAME-OPTIONS","value":"SAMEORIGIN"},{"key":"Content-Encoding","value":"gzip"},{"key":"Expires","value":"Thu, 01 Jan 1970 00:00:00 GMT"},{"key":"Content-Type","value":"application/json;charset=UTF-8"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Date","value":"Thu, 01 Oct 2020 01:25:12 GMT"},{"key":"Server","value":""}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"kairosRPA\",\n \"process\": \"InventoryCountings\",\n \"system\": \"sapBusinessOne\",\n \"target\": \"inventoryCountings\",\n \"user\": \"intergate\",\n \"host\": \"40.79.57.152\",\n \"effectiveTimestamp\": \"2020-07-21T19:20:20\",\n \"code\": \"200\",\n \"success\": true,\n \"values\": [\n {\n \"object\": \"14765\",\n \"table\": \"OINC\",\n \"action\": \"Update\",\n \"erpKey\": \"21\"\n },\n {\n \"object\": \"10071\",\n \"table\": \"OIQR\",\n \"action\": \"Insert\",\n \"erpKey\": \"231\"\n }\n ]\n}"}],"_postman_id":"6f72af1d-b61c-4614-831b-80a805276ac8"},{"name":"Inventory Postings","id":"c5b0b0b1-4bf9-4948-b8e7-cb673d54f64c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\r\n \"branch\": \"3\",\r\n \"docNum\": \"9\"/*,\r\n \"items\": [\r\n {\r\n \"lineNum\": 1,\r\n \"productKey\": \"PA00013\",\r\n \"whsCode\": \"05\",\r\n \"countedQuantity\": 40,\r\n \"batchNumbers\": [\r\n {\r\n \"batchCode\": \"200661\",\r\n \"expirationDate\": \"2021-03-06\",\r\n \"countedQuantity\": 40\r\n }\r\n ]\r\n }\r\n ]*/\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/inventoryPostings","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}},"urlObject":{"path":["inventoryPostings"],"host":["{{endpoint}}"],"query":[],"variable":[]}},"response":[],"_postman_id":"c5b0b0b1-4bf9-4948-b8e7-cb673d54f64c"},{"name":"insInventoryPosting","id":"9ee4ef91-c9e4-44b4-8b53-d1bdd516907e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"\r\n inventoryPostings\r\n intergate\r\n kairosRPA\r\n POST\r\n 9\r\n 12\r\n","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/insInventoryPosting","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}},"urlObject":{"path":["insInventoryPosting"],"host":["{{endpoint}}"],"query":[],"variable":[]}},"response":[],"_postman_id":"9ee4ef91-c9e4-44b4-8b53-d1bdd516907e"}],"id":"2a805cf4-29e2-41ae-8675-5413ffe5eb34","_postman_id":"2a805cf4-29e2-41ae-8675-5413ffe5eb34","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}}},{"name":"Production Orders","item":[{"name":"Production Orders","id":"1de851ac-dd78-4488-8eb7-9956b971f87c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":"{{endpoint}}/productionOrders?createdFrom=2020-11-01&createdTo=2020-11-30&startFrom=2020-05-18&startTo=2020-05-22&finishFrom=2020-05-18&finishTo=2020-05-31&orderType&status&productKey=900.000.004&orderKey=000004&erpKey=05758101001&erpId=847&pageNum=1&updatedAt=2020-05-16T00:00:00","description":"

Search production orders in ERP

(totvsProtheus=SC2)

Search production orders allows you to filter the ERP by:

List: by productKey or orderKey {optional}, or by createdFrom, createdTo, startFrom, startTo, finishFrom or finishTo. Lists can be also filtered by orderType or status {optional}
Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records. The list search can be filtered by Product (productKey) or Sales Order (orderKey) or by production order dates (creation, expected start, expected end).

productKey: [1] TOTVS Protheus: field C2_PRODUTO
orderKey: [1] TOTVS Protheus: field C2_PEDIDO
Production dates: [1] TOTVS Protheus: C2_EMISSAO, C2_DATPRI, C2_DATPRF

Comments:

erpKey: the production order key = C2_NUM + C2_ITEM + C2_SEQUEN + C2_ITEMGRD
erpId: the R_E_C_N_O_ of SC2
orderType: production order type (E=expected, C=confirmed, *=all - default=F)
status: production order status (O=open, S=started, C=closed - default=O,S)

The service will consider as valid products:

TOTVS Protheus: [1] “Finished Product” Type (B1_TIPO = PA), [2] active product (B1_MSBLQL other than 1), [3] E-commerce field active (B5_ECFLAG = 1)

The search will return production orders regardless of whether or not the products have a registered operating route.

The response will inform:

The number of returned objects in the count field

For all searches, the pagination feature will be used in the response, where the following fields are used to control the pagination:

pageSize = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
pageNum = desired page, provided in the request, and informed in the response. If pageNum not informed = 1, If pageNum <=0 = 1, If pageNum > pageTotal = last page.
pageTotal = total pages, reported in the response
hasNext = if there are more pages (true / false), informed in the response

This service will allow search in two situations:

Full query: will result in all valid records
Incremental Consultation: will result in all valid records that have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH: MM: SS) will be used to determine which products (partnumber / skus) should be returned. This information will be used in conjunction with: [1] TOTVS Protheus: fields C2_USERLGI and C2_USERLGA

For the use of user fields (UDF) created in the table of production orders (TOTVS Protheus: SC2), the respective registration must be performed in the Custom Table.

Initial create date to filter production orders (required - list search)

\n","type":"text/plain"},"key":"createdFrom","value":"2020-11-01"},{"description":{"content":"

Final create date to filter production orders (required - list search)

\n","type":"text/plain"},"key":"createdTo","value":"2020-11-30"},{"description":{"content":"

Initial start date to filter production orders (optional - list search)

\n","type":"text/plain"},"key":"startFrom","value":"2020-05-18"},{"description":{"content":"

Final start date to filter production orders (optional - list search)

\n","type":"text/plain"},"key":"startTo","value":"2020-05-22"},{"description":{"content":"

Initial finish date to filter production orders (optional - list search)

\n","type":"text/plain"},"key":"finishFrom","value":"2020-05-18"},{"description":{"content":"

Final finish date to filter production orders (optional - list search)

\n","type":"text/plain"},"key":"finishTo","value":"2020-05-31"},{"description":{"content":"

Production Order Type: E=expected, C=confirmed, *=all (optional - list search)

\n","type":"text/plain"},"key":"orderType","value":null},{"description":{"content":"

Production Order Status: O=open, S=started, C=closed (optional - list search)

\n","type":"text/plain"},"key":"status","value":null},{"description":{"content":"

Product Primary Key in ERP (optional - list search)

\n","type":"text/plain"},"key":"productKey","value":"900.000.004"},{"description":{"content":"

Sales Order Primary Key in ERP (optional - list search)

\n","type":"text/plain"},"key":"orderKey","value":"000004"},{"description":{"content":"

Production Order Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpKey","value":"05758101001"},{"description":{"content":"

Production Order Id in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpId","value":"847"},{"description":{"content":"

Number of page - pagination (optional)

\n","type":"text/plain"},"key":"pageNum","value":"1"},{"description":{"content":"

Date to filter production order changes - incremental search (optional)

\n","type":"text/plain"},"key":"updatedAt","value":"2020-05-16T00:00:00"}],"variable":[]}},"response":[{"id":"0d427207-c770-47ba-9475-0adcacfbca72","name":"Production Orders - by createdFrom/createdTo","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?createdFrom=2020-05-16&createdTo=2020-05-16","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)"},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)"},{"key":"startFrom","value":"2020-05-16","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-16","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-16","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-16","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"839"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T17:16:24\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1328,\n \"priority\": 500,\n \"note\": \"\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM \",\n \"measureUnit\": \"PC\",\n \"orderKey\": null,\n \"orderLineNum\": null,\n \"partnerName\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"},{"id":"645b6c0a-9be5-4c42-94c7-eb0d081f23d7","name":"Production Orders - by productKey","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?productKey=900.000.004","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-16","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-16","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-16","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-16","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)"},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"894"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T17:08:44\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000402001\",\n \"erpId\": 847,\n \"priority\": 500,\n \"note\": \"PARA EXPORTACAO\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.004\",\n \"productName\": \"PORTA DE PINUS 6P 90 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"orderKey\": \"000004\",\n \"orderLineNum\": \"02\",\n \"partnerName\": \"BLUTRAFOS BLUMENAU TRANSFORMADORES LTDA\",\n \"quantity\": 20,\n \"quantityProduced\": 0,\n \"createDate\": \"2018-12-13\",\n \"startDate\": \"2020-05-20\",\n \"finishDate\": \"2020-05-31\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"},{"id":"691b481b-07a7-4a88-aea5-6f839231a61c","name":"Production Orders - by erpId","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?erpId=847","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-16","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-16","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-16","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-16","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)"},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"907"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T17:07:45\",\n \"erpId\": 847,\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000402001\",\n \"erpId\": 847,\n \"priority\": 500,\n \"note\": \"PARA EXPORTACAO\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.004\",\n \"productName\": \"PORTA DE PINUS 6P 90 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"orderKey\": \"000004\",\n \"orderLineNum\": \"02\",\n \"partnerName\": \"BLUTRAFOS BLUMENAU TRANSFORMADORES LTDA\",\n \"quantity\": 20,\n \"quantityProduced\": 0,\n \"createDate\": \"2018-12-13\",\n \"startDate\": \"2020-05-20\",\n \"finishDate\": \"2020-05-31\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"},{"id":"6be0fdbd-acdc-43c7-ace9-d3054b1cc2f5","name":"Production Orders - by erpKey","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?erpKey=00000402001","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-16","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-16","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-16","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-16","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)"},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"918"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T17:06:47\",\n \"erpKey\": \"00000402001\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000402001\",\n \"erpId\": 847,\n \"priority\": 500,\n \"note\": \"PARA EXPORTACAO\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.004\",\n \"productName\": \"PORTA DE PINUS 6P 90 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"orderKey\": \"000004\",\n \"orderLineNum\": \"02\",\n \"partnerName\": \"BLUTRAFOS BLUMENAU TRANSFORMADORES LTDA\",\n \"quantity\": 20,\n \"quantityProduced\": 0,\n \"createDate\": \"2018-12-13\",\n \"startDate\": \"2020-05-20\",\n \"finishDate\": \"2020-05-31\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"},{"id":"7e9c5f61-a7e0-415d-bb9d-ce3a15a16ee7","name":"Production Orders - by finishFrom/finishTo","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?finishFrom=2020-05-18&finishTo=2020-05-31","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-18","description":"Initial finish date to filter production orders (required if not unitary search)"},{"key":"finishTo","value":"2020-05-31","description":"Final finish date to filter production orders (required if not unitary search)"},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1267"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T23:48:42\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000402001\",\n \"erpId\": 847,\n \"priority\": 500,\n \"note\": \"PARA EXPORTACAO\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.004\",\n \"productName\": \"PORTA DE PINUS 6P 90 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"orderKey\": \"000004\",\n \"orderLineNum\": \"02\",\n \"partnerName\": \"BLUTRAFOS BLUMENAU TRANSFORMADORES LTDA\",\n \"quantity\": 20,\n \"quantityProduced\": 0,\n \"createDate\": \"2018-12-13\",\n \"startDate\": \"2020-05-20\",\n \"finishDate\": \"2020-05-31\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1328,\n \"priority\": 500,\n \"note\": \"\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"orderKey\": null,\n \"orderLineNum\": null,\n \"partnerName\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"},{"id":"cffb5b47-5abf-4059-934e-55c753d1a39b","name":"Production Orders - TOTVS Protheus","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?createdFrom=2020-11-01&createdTo=2020-11-30","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-11-01","description":"Initial create date to filter production orders (required - list search)"},{"key":"createdTo","value":"2020-11-30","description":"Final create date to filter production orders (required - list search)"},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (optional - list search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (optional - list search)","disabled":true},{"key":"finishFrom","value":"2020-05-18","description":"Initial finish date to filter production orders (optional - list search)","disabled":true},{"key":"finishTo","value":"2020-05-31","description":"Final finish date to filter production orders (optional - list search)","disabled":true},{"key":"orderType","value":null,"description":"Production Order Type: E=expected, C=confirmed, *=all (optional - list search)","type":"text","disabled":true},{"key":"status","value":null,"description":"Production Order Status: O=open, S=started, C=closed (optional - list search)","type":"text","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - list search)","disabled":true},{"key":"orderKey","value":"000004","description":"Sales Order Primary Key in ERP (optional - list search)","disabled":true},{"key":"erpKey","value":"05758101001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Encoding","value":"gzip"},{"key":"Transfer-Encoding","value":"chunked"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"mesAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"192.168.0.108\",\n \"effectiveTimestamp\": \"2020-11-10T18:09:08\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000101001\",\n \"erpId\": 1,\n \"priority\": 500,\n \"startDate\": \"2020-11-10\",\n \"finishDate\": \"2020-11-10\",\n \"comments\": \"TESTE\",\n \"orderType\": \"C\",\n \"status\": \"S\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"PA000001\",\n \"productName\": \"TENIS TOPPER STYLUS 35\",\n \"measureUnit\": \"UN\",\n \"orderKey\": null,\n \"orderLineNum\": null,\n \"partnerName\": null,\n \"quantity\": 200,\n \"quantityProduced\": 100,\n \"createDate\": \"2020-11-10T00:00:00\",\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"},{"id":"dbdac58b-cf07-4a42-9d02-b8e53fa7a376","name":"Production Orders - orderKey","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?orderKey=000004","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-16","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-16","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-16","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-16","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)"},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"894"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T17:10:55\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000402001\",\n \"erpId\": 847,\n \"priority\": 500,\n \"note\": \"PARA EXPORTACAO\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.004\",\n \"productName\": \"PORTA DE PINUS 6P 90 24 35 RETA EUA MM \",\n \"measureUnit\": \"PC\",\n \"orderKey\": \"000004\",\n \"orderLineNum\": \"02\",\n \"partnerName\": \"BLUTRAFOS BLUMENAU TRANSFORMADORES LTDA \",\n \"quantity\": 20,\n \"quantityProduced\": 0,\n \"createDate\": \"2018-12-13\",\n \"startDate\": \"2020-05-20\",\n \"finishDate\": \"2020-05-31\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"},{"id":"df1c0e21-b2c7-4089-baf5-a47d97e18738","name":"Production Orders","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-16","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-16","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-16","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-16","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"894"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T17:01:42\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 1,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000402001\",\n \"erpId\": 847,\n \"priority\": 500,\n \"note\": \"PARA EXPORTACAO\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.004\",\n \"productName\": \"PORTA DE PINUS 6P 90 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"orderKey\": \"000004\",\n \"orderLineNum\": \"02\",\n \"partnerName\": \"BLUTRAFOS BLUMENAU TRANSFORMADORES LTDA\",\n \"quantity\": 20,\n \"quantityProduced\": 0,\n \"createDate\": \"2018-12-13\",\n \"startDate\": \"2020-05-20\",\n \"finishDate\": \"2020-05-31\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"},{"id":"e5240a0a-4e5a-4202-913d-de98734ceea1","name":"Production Orders - by startFrom/startTo","originalRequest":{"method":"GET","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"url":{"raw":"{{endpoint}}/productionOrders?startFrom=2020-05-18&startTo=2020-05-22","host":["{{endpoint}}"],"path":["productionOrders"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)"},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)"},{"key":"finishFrom","value":"2020-05-25","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updatedAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1417"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionOrders\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionOrders\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T17:21:34\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"count\": 2,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00000402001\",\n \"erpId\": 847,\n \"priority\": 500,\n \"note\": \"PARA EXPORTACAO\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.004\",\n \"productName\": \"PORTA DE PINUS 6P 90 24 35 RETA EUA MM \",\n \"measureUnit\": \"PC\",\n \"orderKey\": \"000004\",\n \"orderLineNum\": \"02\",\n \"partnerName\": \"BLUTRAFOS BLUMENAU TRANSFORMADORES LTDA \",\n \"quantity\": 20,\n \"quantityProduced\": 0,\n \"createDate\": \"2018-12-13\",\n \"startDate\": \"2020-05-20\",\n \"finishDate\": \"2020-05-31\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1328,\n \"priority\": 500,\n \"observation\": \"\",\n \"whsCode\": \"01\",\n \"profitCenter\": null,\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM \",\n \"measureUnit\": \"PC\",\n \"orderKey\": null,\n \"orderLineNum\": null,\n \"partnerName\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ]\n}"}],"_postman_id":"1de851ac-dd78-4488-8eb7-9956b971f87c"},{"name":"Production Sequences","id":"0f5a640d-af3a-4e47-87dd-9c5b7dff616c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"{{endpoint}}/productionSequences?createdFrom=2020-05-16&createdTo=2020-05-16&orderType=C&status=O","description":"

Search production sequences in ERP

(totvsProtheus=SG2)

The search of production sequences allows you to filter the ERP by:

List: by productKey or orderKey {optional}, or by createdFrom, createdTo, startFrom, startTo, finishFrom or finishTo {optional}
Unitary: by erpKey or erpId (TOTVS Protheus only)

If no field for unitary query (erpKey or erpId) is informed in the request, the search returns all valid records. The list query can be filtered by Product (productKey) or Sales Order (orderKey) or by production order dates (creation, expected start, expected end).

Product: [1] TOTVS Protheus: field C2_PRODUCT
Sales order: [1] TOTVS Protheus: field C2_PEDIDO
Production dates: [1] TOTVS Protheus: C2_EMISSAO, C2_DATPRI, C2_DATPRF

Note:

erpKey is the key to the production sequence = C2_NUM + C2_ITEM + C2_SEQUEN + C2_ITEMGRD
erpId is the recno at SC2 + G2_OPERAC

The service will consider as valid products:

TOTVS Protheus: [1] “Finished Product” Type (B1_TIPO = PA), [2] active product (B1_MSBLQL other than 1), [3] E-commerce field active (B5_ECFLAG = 1)

The search will return production orders only for products that have a registered operating route.

The response will inform:

The number of returned objects in the “count” field

For all searches, the pagination feature will be used in the response, where the following fields are used to control the pagination:

“pageSize” = maximum number of records on each page (eg: 100), defined in the API configuration, and informed in the response
“pageNum” = desired page, provided in the request, and informed in the response. If “pageNum” not informed = 1, o If “pageNum” <=0 = 1, If “pageNum”> ”pageTotal” = last page
“pageTotal” = total pages, reported in the response
“hasNext” = if there are more pages (true / false), informed in the response

This service will allow search in two situations:

Full query: will result in all valid records
Incremental Consultation: will result in all valid records that have been included and / or changed in the main register after a certain date / time provided in the request. In the Incremental Consultation, the updatedAt field of the body request (format YYYY-MM-DDTHH: MM: SS) will be used to determine which products (partnumber / skus) should be returned. This information will be used in conjunction with: [1] TOTVS Protheus: fields C2_USERLGI and C2_USERLGA

For the use of user fields (UDF) created in the table of production orders (TOTVS: SC2), the respective registration must be performed in the table [@IGT_CUSTOM].

Initial create date to filter production orders (required if not unitary search)

\n","type":"text/plain"},"key":"createdFrom","value":"2020-05-16"},{"description":{"content":"

Final create date to filter production orders (required if not unitary search)

\n","type":"text/plain"},"key":"createdTo","value":"2020-05-16"},{"disabled":true,"description":{"content":"

Initial start date to filter production orders (required if not unitary search)

\n","type":"text/plain"},"key":"startFrom","value":"2020-05-18"},{"disabled":true,"description":{"content":"

Final start date to filter production orders (required if not unitary search)

\n","type":"text/plain"},"key":"startTo","value":"2020-05-22"},{"disabled":true,"description":{"content":"

Initial finish date to filter production orders (required if not unitary search)

\n","type":"text/plain"},"key":"finishFrom","value":"2020-05-18"},{"disabled":true,"description":{"content":"

Final finish date to filter production orders (required if not unitary search)

\n","type":"text/plain"},"key":"finishTo","value":"2020-05-29"},{"description":{"content":"

Production Order Type: E=expected, C=confirmed (optional - list search)

\n","type":"text/plain"},"key":"orderType","value":"C"},{"description":{"content":"

Production Order Status: O=open, S=started, C=closed (optional - list search)

\n","type":"text/plain"},"key":"status","value":"O"},{"disabled":true,"description":{"content":"

Production Order Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpKey","value":"00002001001"},{"disabled":true,"description":{"content":"

Production Sequence Route Id in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"erpId","value":"1329"},{"disabled":true,"description":{"content":"

Product Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"productKey","value":"900.000.003"},{"disabled":true,"description":{"content":"

Order Primary Key in ERP (optional - unitary search)

\n","type":"text/plain"},"key":"orderKey","value":"000004"},{"disabled":true,"description":{"content":"

Number of page - pagination (optional)

\n","type":"text/plain"},"key":"pageNum","value":"1"},{"disabled":true,"description":{"content":"

Date to filter production order changes - incremental search (optional)

\n","type":"text/plain"},"key":"updateAt","value":"2020-05-16T00:00:00"}],"variable":[]}},"response":[{"id":"0a26a35d-6170-4a35-a33e-4481c0733d7d","name":"Production Sequences - by erpId","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences?erpId=1329","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-18","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00002001001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"1329","description":"Production Sequence Route Id in ERP (optional - unitary search)"},{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"805"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:44:03\",\n \"erpId\": 1329,\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1329,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 1,\n \"resource\": \"000001\",\n \"description\": null,\n \"tool\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 3600,\n \"productionTime\": 36000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 1\n}"},{"id":"31c8cbf6-aee5-4461-b821-9a5828ebe501","name":"Production Sequences - by finishFrom/finishTo","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences?finishFrom=2020-05-18&finishTo=2020-05-29","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-18","description":"Initial finish date to filter production orders (required if not unitary search)"},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)"},{"key":"erpKey","value":"00000201001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"1329","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1262"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:23:33\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1329,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 1,\n \"resource\": \"000001\",\n \"description\": null,\n \"tool\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 3600,\n \"batchTime\": 36000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1330,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 2,\n \"resource\": \"000002\",\n \"description\": null,\n \"tool\": \"000001\",\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 0,\n \"batchTime\": 72000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"},{"id":"3c08b4e8-175c-4eb6-935a-311fe45d906c","name":"Production Sequences - by createdFrom/createdTo","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences?createdFrom=2020-05-16&createdTo=2020-05-16","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)"},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)"},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-25","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000201001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"1329","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1262"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:21:13\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1329,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 1,\n \"resource\": \"000001\",\n \"description\": null,\n \"tool\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 3600,\n \"batchTime\": 36000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1330,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 2,\n \"resource\": \"000002\",\n \"description\": null,\n \"tool\": \"000001\",\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 0,\n \"batchTime\": 72000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"},{"id":"4ff5d534-5782-448b-9514-b11787aa84db","name":"Production Sequences - by orderKey - not found","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences?orderKey=000004","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-18","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000201001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"1329","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)"},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"358"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:25:06\",\n \"code\": \"404\",\n \"success\": false,\n \"error\": {\n \"code\": \"404\",\n \"message\": \"No valid productionSequences were found\",\n \"details\": \"No valid productionSequences were found\"\n }\n}"},{"id":"6b7363e9-c2de-4d9f-8458-79278c4045fa","name":"Production Sequences","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-25","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1262"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:14:52\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1329,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 1,\n \"resource\": \"000001\",\n \"description\": null,\n \"tool\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 3600,\n \"productionTime\": 36000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1330,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 2,\n \"resource\": \"000002\",\n \"description\": null,\n \"tool\": \"000001\",\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 0,\n \"productionTime\": 72000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"},{"id":"8b73bc38-3a3e-4c01-ab43-d944c22460e5","name":"Production Sequences - by erpKey","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences?erpKey=00002001001","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-18","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00002001001","description":"Production Order Primary Key in ERP (optional - unitary search)"},{"key":"erpId","value":"1329","description":"Production Sequence Route Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1296"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:45:00\",\n \"erpKey\": \"00002001001\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1329,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 1,\n \"resource\": \"000001\",\n \"description\": null,\n \"tool\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 3600,\n \"productionTime\": 36000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1330,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 2,\n \"resource\": \"000002\",\n \"description\": null,\n \"tool\": \"000001\",\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 0,\n \"productionTime\": 72000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"},{"id":"8ddc088f-f4bc-4a05-a00f-f845afdd6114","name":"Production Sequences - by startFrom/startTo","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences?startFrom=2020-05-18&startTo=2020-05-22","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)"},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)"},{"key":"finishFrom","value":"2020-05-25","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000201001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"1329","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1262"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:22:22\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1329,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 1,\n \"resource\": \"000001\",\n \"description\": null,\n \"tool\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 3600,\n \"batchTime\": 36000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1330,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 2,\n \"resource\": \"000002\",\n \"description\": null,\n \"tool\": \"000001\",\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 0,\n \"batchTime\": 72000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"},{"id":"b823f336-520c-45f9-aaef-50ce6e295a79","name":"Production Sequences - not found","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-16","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-16","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-16","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-16","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000402001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"847","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.004","description":"Product Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"358"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-16T16:58:10\",\n \"code\": \"404\",\n \"success\": false,\n \"error\": {\n \"code\": \"404\",\n \"message\": \"No valid productionSequences were found\",\n \"details\": \"No valid productionSequences were found\"\n }\n}"},{"id":"c012035e-3ccc-4931-876d-7677b61dcae7","name":"Production Sequences - by productKey","originalRequest":{"method":"GET","header":[],"url":{"raw":"{{endpoint}}/productionSequences?productKey=900.000.003","host":["{{endpoint}}"],"path":["productionSequences"],"query":[{"key":"createdFrom","value":"2020-05-16","description":"Initial create date to filter production orders (required if not unitary search)","disabled":true},{"key":"createdTo","value":"2020-05-16","description":"Final create date to filter production orders (required if not unitary search)","disabled":true},{"key":"startFrom","value":"2020-05-18","description":"Initial start date to filter production orders (required if not unitary search)","disabled":true},{"key":"startTo","value":"2020-05-22","description":"Final start date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishFrom","value":"2020-05-18","description":"Initial finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"finishTo","value":"2020-05-29","description":"Final finish date to filter production orders (required if not unitary search)","disabled":true},{"key":"erpKey","value":"00000201001","description":"Production Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"erpId","value":"1329","description":"Production Order Id in ERP (optional - unitary search)","disabled":true},{"key":"productKey","value":"900.000.003","description":"Product Primary Key in ERP (optional - unitary search)"},{"key":"orderKey","value":"000004","description":"Order Primary Key in ERP (optional - unitary search)","disabled":true},{"key":"pageNum","value":"1","description":"Number of page - pagination (optional)","disabled":true},{"key":"updateAt","value":"2020-05-16T00:00:00","description":"Date to filter production order changes - incremental search (optional)","disabled":true}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"1262"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionSequences\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionSequences\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T00:24:35\",\n \"code\": \"200\",\n \"success\": true,\n \"pageSize\": 100,\n \"pageNum\": 1,\n \"pageTotal\": 1,\n \"hasNext\": false,\n \"values\": [\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1329,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 1,\n \"resource\": \"000001\",\n \"description\": null,\n \"tool\": null,\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 3600,\n \"batchTime\": 36000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n },\n {\n \"branch\": \"01\",\n \"erpKey\": \"00002001001\",\n \"erpId\": 1330,\n \"priority\": 500,\n \"note\": \"\",\n \"productKey\": \"900.000.003\",\n \"productName\": \"PORTA DE PINUS 6P 80 24 35 RETA EUA MM\",\n \"measureUnit\": \"PC\",\n \"route\": 1,\n \"sequence\": 2,\n \"resource\": \"000002\",\n \"description\": null,\n \"tool\": \"000001\",\n \"quantity\": 100,\n \"quantityProduced\": 0,\n \"setupTime\": 0,\n \"batchTime\": 72000,\n \"createDate\": \"2020-05-16\",\n \"startDate\": \"2020-05-18\",\n \"finishDate\": \"2020-05-26\",\n \"createdAt\": null,\n \"updatedAt\": null,\n \"canceledAt\": null\n }\n ],\n \"count\": 2\n}"}],"_postman_id":"0f5a640d-af3a-4e47-87dd-9c5b7dff616c"}],"id":"f7272288-9bb1-4865-8921-11d27959f2e7","_postman_id":"f7272288-9bb1-4865-8921-11d27959f2e7","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}}},{"name":"Production Points","item":[{"name":"Production Points","id":"e5abb1fb-e5fe-4a96-8dfa-9ba3d1dbcf83","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n\t\"extId\": 29,\r\n\t\"branch\": 1,\r\n\t\"productionOrder\": \"00002101001\",\r\n\t\"productKey\": \"900.000.003\",\r\n\t\"routeSequence\": 1,\r\n\t\"productionResource\": \"000001\",\r\n\t\"operator\": \"Rafael\",\r\n\t\"quantity\": 10,\r\n\t\"createdAt\": \"2020-05-17T07:00:00\",\r\n\t\"startedAt\": \"2020-05-17T08:00:00\",\r\n\t\"fineshedAt\": \"2020-05-17T09:00:00\",\r\n\t\"duration\": 60\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/productionPoints","description":"

Send production point to ERP

(totvsProtheus=SD3)

The production appointment will use automatic routines and tables in TOTVS Protheus according to the data received in the Body Request and according to the registration of operation routes:

If there is no operation guide or resource and time data have not been sent: MATA250 and table SD3
If there is an operation guide and resource and time data have been sent: MATA681 and table SH6

Comments:

erpKey: D3_NUMSEQ
erpId: SD3 slot or SH6 slot
extId: recorded only in the Monit table, and used to validate previous notes

Mandatory information in the Body Request (for Simple Pointing): extId, branch, productionOrder, productKey, quantity and createdAt.

Mandatory information in the Body Request (for Appointment Mod2): extId, branch, productionOrder, productKey, routeSequence, productionResource, quantity, createdAt, startedAt and finishedAt.

Optional information in the Body Request: tool, operator and duration.

Comments:

Appointment can be T = Total or P = Partial, depending on whether the amount indicated is greater than the OP balance (OP balance = C2_QUANT - C2_QUJE)
The Movement Type used in Simple Production (MATA250) will be obtained from the MV_TMPAD parameter

Request object has the following properties

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Description
extId	number	ext erpId
branch	number	Branch
productionOrder	string	Production productionOrder
productKey	string	Product erpKey
routeSequence	number	Route routeSequence
productionResource	string	Production resource
tool	string	Tools
operator	string	operator
quantity	number	quantity
weight	number	Weight
createdAt	string	Creation date
startedAt	string	Start date
fineshedAt	string	End date
duration	number	duration

* = Required field

Response object has the following properties

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Description
package	string	Package
process	string	Process
system	string	System
target	string	Target
user	string	user
host	string	host
effectiveTimestamp	string	Effective Time stamp
code	string	code
success	booleano	Success
values	array	values
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp erpKey
values.erpId	string	Id erpKey
values.erpProcess	string	Process erp

","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}},"urlObject":{"path":["productionPoints"],"host":["{{endpoint}}"],"query":[],"variable":[]}},"response":[{"id":"212230d4-b406-43e0-a69c-e3d8a669e953","name":"Production Points","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n\t\"extId\": 27,\r\n\t\"branch\": 1,\r\n\t\"productionOrder\": \"00002001001\",\r\n\t\"productKey\": \"900.000.003\",\r\n\t\"routeSequence\": 1,\r\n\t\"productionResource\": \"000001\",\r\n\t\"tool\": \"000001\",\r\n\t\"operator\": \"Rafael\",\r\n\t\"quantity\": 10,\r\n\t\"weight\": 200,\r\n\t\"createdAt\": \"2019-08-08T15:00:00\",\r\n\t\"startedAt\": \"2019-08-08T08:00:00\",\r\n\t\"fineshedAt\": \"2019-08-08T09:00:00\",\r\n\t\"duration\": 60\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/productionPoints"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"347"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"ProductionPoints\",\n \"system\": \"totvsProtheus\",\n \"target\": \"productionPoints\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T03:59:44\",\n \"code\": \"200\",\n \"success\": true,\n \"values\": [\n {\n \"object\": \"10000071\",\n \"table\": \"SD3\",\n \"action\": \"Insert\",\n \"erpKey\": \"000295\",\n \"erpId\": \"349\",\n \"erpProcess\": \"MATA250\"\n }\n ]\n}"}],"_postman_id":"e5abb1fb-e5fe-4a96-8dfa-9ba3d1dbcf83"},{"name":"Stop Points","id":"ec61fa9f-f99e-4408-93b2-9a8a1efdfc07","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n\t\"extId\": 11,\r\n\t\"branch\": 1,\r\n\t\"productionResource\": \"000001\",\r\n\t\"stopReason\": \"FM\",\r\n\t\"createdAt\": \"2020-05-16T23:52:00\",\r\n\t\"startedAt\": \"2020-05-16T07:00:00\",\r\n\t\"finishedAt\": \"2020-05-16T07:15:00\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/stopPoints","description":"

Send stop points to ERP

(totvsProtheus=SH6)

The stop appointment will use automatic routines and tables in TOTVS Protheus: MATA682 and table SH6.

Comments:

erpKey: D3_NUMSEQ
erpId: SH6 housing
extId: recorded only in the Monit table, and used to validate previous notes

Mandatory information in the Body Request: extId, branch, productionResource, stopReason, createdAt, startedAt and finishedAt.

Optional information in the Body Request: tool and operator.

Request object has the following properties

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Description
extId	number	Ext erpId
branch	number	branch
productionResource	string	Production Resource
stopReason	string	Stop reason
createdAt	string	Creation date
startedAt	string	start date
finishedAt	string	end date

* = Required field

Response object has the following properties

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Description
package	string	Package
process	string	Process
system	string	System
target	string	Target
user	string	user
host	string	host
effectiveTimestamp	string	Effective Time stamp
code	string	code
success	booleano	Success
values	array	values
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp erpKey
values.erpId	string	Id erpKey
values.erpProcess	string	Process erp

","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}},"urlObject":{"path":["stopPoints"],"host":["{{endpoint}}"],"query":[],"variable":[]}},"response":[{"id":"cf6994d6-ce72-442e-8d6d-bb3b1b43535c","name":"Stop Points","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n\t\"extId\": 11,\r\n\t\"branch\": 1,\r\n\t\"productionResource\": \"000001\",\r\n\t\"stopReason\": \"FM\",\r\n\t\"createdAt\": \"2020-05-16T23:52:00\",\r\n\t\"startedAt\": \"2020-05-16T07:00:00\",\r\n\t\"finishedAt\": \"2020-05-16T07:15:00\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/stopPoints"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"334"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"StopPoints\",\n \"system\": \"totvsProtheus\",\n \"target\": \"stopPoints\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T02:19:39\",\n \"code\": \"200\",\n \"success\": true,\n \"values\": [\n {\n \"object\": \"10000071\",\n \"table\": \"SH6\",\n \"action\": \"Insert\",\n \"erpKey\": \"000284\",\n \"erpId\": \"20\",\n \"erpProcess\": \"MATA682\"\n }\n ]\n}"}],"_postman_id":"ec61fa9f-f99e-4408-93b2-9a8a1efdfc07"},{"name":"Waste Points","id":"bad3e668-9ce9-4c9d-b600-c82784380c1f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n\t\"extId\": 23,\r\n\t\"branch\": 1,\r\n\t\"productionOrder\": \"00002001001\",\r\n\t\"productKey\": \"0330\",\r\n\t\"wasteReason\": \"FM\",\r\n\t\"quantity\": 1,\r\n\t\"createdAt\": \"2019-08-08T15:00:00\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/wastePoints","description":"

Search waste point to ERP

(totvsProtheus=SBC)

The refuse appointment will use automatic routines and tables in TOTVS Protheus: MATA682 and table SH6.

Comments:

erpKey: BC_NUMSEQ
erpId: SBC's headquarters
extId: recorded only in the Monit table, and used to validate previous notes

Mandatory information in the Body Request: extId, branch, productionOrder, productKey, wasteReason, quantity and createdAt.

Optional information in the Body Request: routeSequence, resource, operator and batchNumber.

Request object has the following properties

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Description
extId	number	ext Id
branch	number	branch
productionOrder	string	Prodction Order
productKey	string	Product key
wasteReason	string	Waste Reason
quantity	number	Quantity
createdAt	string	Creation date

* = Required field

Response object has the following properties

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Field	Type	Description
package	string	Package
process	string	Process
system	string	System
target	string	Target
user	string	user
host	string	host
effectiveTimestamp	string	Effective Time stamp
code	string	code
success	booleano	Success
values	array	values
values.object	string	Object
values.table	string	Table
values.action	string	action
values.erpKey	string	Erp erpKey
values.erpId	string	Id erpKey
values.erpProcess	string	Process erp

","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}},"urlObject":{"path":["wastePoints"],"host":["{{endpoint}}"],"query":[],"variable":[]}},"response":[{"id":"422d117d-e43e-469a-9c51-8c199d226508","name":"Waste Points","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","name":"Content-Type","value":"application/json","type":"text"}],"body":{"mode":"raw","raw":"{\r\n\t\"extId\": 23,\r\n\t\"branch\": 1,\r\n\t\"productionOrder\": \"00002001001\",\r\n\t\"productKey\": \"0330\",\r\n\t\"wasteReason\": \"FM\",\r\n\t\"quantity\": 1,\r\n\t\"createdAt\": \"2019-08-08T15:00:00\"\r\n}","options":{"raw":{"language":"json"}}},"url":"{{endpoint}}/wastePoints"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Version","value":"1.1"},{"key":"FWRESTBUILD","value":"1.15.0717"},{"key":"Content-Type","value":"application/json"},{"key":"Status","value":"200 OK"},{"key":"Content-Length","value":"335"},{"key":"Connection","value":"keep-alive"},{"key":"Keep-Alive","value":"timeout=15"}],"cookie":[],"responseTime":null,"body":"{\n \"package\": \"b2cAPI\",\n \"process\": \"WastePoints\",\n \"system\": \"totvsProtheus\",\n \"target\": \"wastePoints\",\n \"user\": \"intergate\",\n \"host\": \"127.0.0.1\",\n \"effectiveTimestamp\": \"2020-05-17T03:11:49\",\n \"code\": \"20\",\n \"success\": true,\n \"values\": [\n {\n \"object\": \"10000071\",\n \"table\": \"SBC\",\n \"action\": \"Insert\",\n \"erpKey\": \"000289\",\n \"erpId\": \"21\",\n \"erpProcess\": \"MATA685\"\n }\n ]\n}"}],"_postman_id":"bad3e668-9ce9-4c9d-b600-c82784380c1f"}],"id":"18cde122-8413-42fe-9719-b8ded8cfdd67","_postman_id":"18cde122-8413-42fe-9719-b8ded8cfdd67","description":"","auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]},"isInherited":true,"source":{"_postman_id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","id":"53154c4a-81f4-4e77-b9e9-fe89e9f7a9d7","name":"mesAPI - Shop Floor & MES API for ERP (v2)","type":"collection"}}}],"auth":{"type":"basic","basic":{"basicConfig":[{"key":"username","value":"{{user}}"},{"key":"password","value":"{{pass}}"}]}},"event":[{"listen":"prerequest","script":{"id":"b9a9aeb4-3a5c-4ebf-bebd-8fe959134859","type":"text/javascript","exec":[""]}},{"listen":"test","script":{"id":"cb4db526-909b-4a58-9bd4-c269d86b0f85","type":"text/javascript","exec":[""]}}]}