EP API - Lots

Endpoint name	`lots`
Source table in Wisefish	`WiFi Lot`
Fixed view	Shows entries from the table with: Production Type = empty
Editable	No data modification possible.
Procedures	There are no procedures on this endpoint.
Primary Key	The field `code` is the primary key (and only that field).

Data

Field List

Property	Type	Table Field	Field Type	Note
`code`	string	Code	Code[20]
`description`	string	Description	Text[50]
`startingDateTime`	date-time utc	Starting Date/Time	DateTime
`endingDateTime`	date-time utc	Ending Date/Time	DateTime
`stockCenterCode`	string	Stock Center Code	Code[20]
`processingStage`	string	Processing Stage	Code[20]
`group`	string	Group	Code[10]
`activeInProduction`	true/false	Active in Production	Boolean
`bestBeforeCalcFrom`	Date	Best Before calc. from	Date
`postingStatus`	string	Posting Status	Option	`'Open,Completed (Closed),Precreated'`
`navInvProductionPosting`	string	NAV Inv. Production Posting	Option	`' ,Lot,Stage within Lot,Close without Production'`
`productionType`	string	Production Type	Option	`,Production,Contracting,Repacking,Relabeling'`
`fishingTripNo`	string	Fishing Trip No.	Code[20]
`productionDate`	Date	Production Date	Date
`creationDate`	Date	Creation Date	Date
`vesselCode`	string	Vessel Code	Code[20]
`vesselName`	string	Vessel.Name	Text[50]
`vesselGLN`	string	GLN	Code[13]
`rawMaterial`	string	Raw Material	Code[20]
`type`	string	Type	Option	Origin, Production, Both
`originType`	string	Origin Type	Text	Wild,Farm Raised
`fishingAreaCode`	string	Fishing Area Code	Code[10]
`fishingAreaName`	string	FishingArea.Description	Text
`inboundDocTypeCreation`	string	Inbound Doc. Type	Option
`externalProducer`	string	External Producer	Code[20]
`systemId`	string uuid	SystemId	GUID
`lastModified`	date-time utc	SystemModifiedAt	DateTime	Note: The name of this field in business central is “systemmodifedAt” and it can be seen in page inspection in the user interface.

Example

Expand to see the example json

An example of one object in the list:

JSON

 {
            "@odata.etag": "W/\"JzIwOzE0MTAzOTM5MjE1NzkzNDg4NDY4MTswMDsn\"",
            "systemId": "7a2e0cef-3792-f011-b419-6045bdc6da3f",
            "code": "0707SOFFIA",
            "description": "0707 SOFFIA SHRIMP",
            "startingDateTime": "2025-07-07T00:00:00Z",
            "endingDateTime": "2025-09-15T23:59:59.997Z",
            "stockCenterCode": "PRODUCER01",
            "processingStage": "",
            "group": "",
            "activeInProduction": false,
            "bestBeforeCalcFrom": "0001-01-01",
            "postingStatus": "Completed (Closed)",
            "navInvProductionPosting": " ",
            "productionType": " ",
            "fishingTripNo": "",
            "productionDate": "0001-01-01",
            "creationDate": "2025-07-07",
            "vesselCode": "TITAN",
            "vesselName": "TITANIC AS IS-101",
            "vesselGLN": "",
            "rawMaterial": "",
            "type": "Origin",
            "originType": "Wild",
            "fishingAreaCode": "",
            "fishingAreaName": "",
            "inboundDocTypeCreation": "Receipt Agreement",
            "externalProducer": "EXT01",
            "lastModified": "2025-09-15T13:31:58.767Z"
        }

Overview

Data

Field List

Example