API - Trade Item Inventory | Wisefish Manuals

Overview

The API returns the inventory of items that are Trade Items. No data update is allowed.

Trade Items are items that have the field “Trade Item Type” populated. The options are:

Raw Material
WIP
Product

Endpoint name	`inventoryTradeItems`
Source table	`WiFi Open Trade Item`
Fixed view	The endpoint only lists item that are still in inventory, so to ensure that, there is a fixed filter on empty Closing Type: `"Closing Type" = filter(" "));`
Requests allowed	GET
Primary key	`stage, number`
Record ID	`systemId`
Procedures	None

Data

Field List

	Property	Type	Max Len	Description
1	`systemId`	guid		They systemID of the entry.	Record ID
2	`stage`	string	20	Each trade item was created for a specific Stage.	primary key
3	`lineNo`	Integer		Within each stage, the trade items are numbered with a sequential number.	primary key
4	`itemNo`	string	20	Every trade item is a unique “individual” of a standard BC item.
5	`description`	string	50	Description of the Trade Item.
6	`type`	enum		Blank if it is a standard item, if not blank, it is a “trade item”. Options: blank - standard item, can be used if it is not seafood, for example packaging Product Raw Material WIP - produced material that will be used as a consumption for products
7	`lot`	string	10
8	`itemDescription`	string	50	Description from the Item card.
9	`variantCode`	string	20	Every trade item is a unique “individual” of a standard BC item.
10	`packageDescription`	string	30	ADD ?
11	`locationCode`	string	20
12	`stockCenterCode`	string	20
13	`tradeItems`	decimal
14	`tradeItemUnitOfMeasure`	string	10
15	`tradeItemsBase`	decimal
16	`tradeItemBaseUnitOfMeasure`	string	10
17	`quantity`	decimal
18	`unitOfMeasure`	string	10
19	`quantityBase`	decimal
20	`qtyPerUnitOfMeasure`	decimal
21	`palletBarcode`	string	???
22	`palletNo`	string	???
23	`physicalPalletID`	string	???
24	`tradeItemBarcode`	string	???
25	`inventoryPosted`	boolean		Shows if this inventory has been fully posted to BC Item Ledger Entries
26	`holdStatus`	enum
27	`postingDateInbound`	date
28	`productionDate`	date
29	`expirationDate`	date
30	`zoneCode`	string	10
31	`binCode`	string	10
32	`lastModified`	date-time

Example Object

JSON

        {
            "@odata.etag": "W/\"JzIwOzE1MjY5MDk1ODAyNDQ4Mzc5OTM3MTswMDsn\"",
            "systemId": "e996b124-3003-f011-b01d-f992b2580806",
            "stage": "PRODUCTION",
            "lineNo": 64,
            "itemNo": "70064",
            "description": "Cod - raw material",
            "type": "Raw Material",
            "lot": "LOT0051",
            "itemDescription": "Cod - raw material",
            "variantCode": "SV-0002",
            "locationCode": "BLUE",
            "stockCenterCode": "BLA",
            "tradeItems": 500,
            "tradeItemUnitOfMeasure": "KG",
            "tradeItemsBase": 500,
            "tradeItemBaseUnitOfMeasure": "KG",
            "quantity": 500,
            "unitOfMeasure": "KG",
            "quantityBase": 500,
            "qtyPerUnitOfMeasure": 1,
            "palletBarcode": "",
            "palletNo": "",
            "physicalPalletID": "",
            "tradeItemBarcode": "",
            "status": "Posted in (BC inv.)",
            "holdStatus": " ",
            "postingDateInbound": "2025-03-17",
            "productionDate": "2025-03-17",
            "expirationDate": "0001-01-01",
            "zoneCode": "",
            "binCode": "",
            "lastModified": "2025-03-26T10:11:17.52Z"
        }

Usage

Trade Items in stock on specific Location

To get the inventory on Location BLUE this request will do:

JSON

GET ../inventoryTradeItems?$filter=locationCode eq 'BLUE'