EP CC Connector API - Production Agreements CC 2

Overview

This API is for Production Agreements in Wisefish with Cross-Company functionality.

In this case there is a Delivery Agreement directly linked to the Production Agreement.

The data contains also the lines as a child array.

Note: refNo is gathered from “the source company” through Sales Agreement. It publishes what is the original document in the source company.

Below is an Entity Relationship Diagram showing the primary key fields of the production agreement lines table, and how one of the fields in the primary key, is the primary key of the header table.

WiFiProductionAgreement has No as Code[20].
WiFiProductionAgreementLine has composite PK: ProdAgreementNo (Code[20]) and LineNo (Integer).
Relationship: One-to-Many (||--o{) from Header to Lines.

Endpoint name	`ccProductionAgreements2`
Source table in Wisefish	`WiFi Production Agreement`
Fixed view	No filter.
Editable	No data modification possible.
Procedures	There are no procedures on this endpoint.
Primary key	As shown on entity relationship diagram above, the primary key of the “header table” is “No”. It stands for document number. The table representing the lines, has a combined key that consists of 2 fields: `"Prod. Agreement No.", "Line No.".`

Data

Field List

Property	Table Field	Type	Note
`no`	No.	Text
`status`	Status	Text
`description`	Description	Text
`description2`	Description 2	Text
`creationDate`	Creation Date	Date
`lastDateModified`	Last Date Modified	Date
`comment`	Comment
`dueDate`	Due Date	Date
`locationCode`	Location Code	Text
`startingDateTime`	Starting Date-Time	DateTime
`endingDateTime`	Ending Date-Time	DateTime
`active`	Active	true/false
`processingStage`	Processing Stage	Text
`stockCenterCode`	Stock Center Code	Text
`lotCode`	Lot Code	Text
`createdByUser`	Created by User	Text
`productionForecastNo`	Production Forecast No.	Text
`salesAgreementType`	Sales Agreement Type	Text
`salesAgreementNo`	Sales Agreement No.	Text
`exporterId`	WiFiStockCenter_IC.GLN	Text
`mainOriginLotCode`	Main Origin Lot Code	Text
`mixedOriginForCodeIT`	WiFiEP Mixed Origin for CodeIT
`noOfLines`	WiFiEP No. of Lines	Integer	Counts the number of lines associated with this Document No. BlankZero = true (can be benefical for external production system, as it can then check if the number of lines reported by this API matches the number of labels they have).
`refCompany`	CCShipToInformation."CC Partner Code"	Text
`refDocumentType`	CCShipToInformation."Document Type"	Text
`refNo`	CCShipToInformation."No."	Text
`systemId`	SystemId	GUID
`productionAgreementLines`		Array	Array of `productionAgreementLine` fields. See details of documentation for them in the “Production Agreement Lines” document.
`lastDateModified`	SystemModifiedAt	DateTime

Example

Expand to see the example json

An example of one object in the list:

JSON

    "value": [
        {
            "@odata.etag": "W/\"JzIwOzE2NDk0NTI4NzEzODg1MDQ1NDUwMTswMDsn\"",
            "systemId": "7f59e670-90ae-f011-bbd0-7c1e5288758b",
            "no": "PA951",
            "status": "Released",
            "description": "SHRIMP FACTORY LTD.",
            "description2": "Upper Manhattan",
            "creationDate": "2025-10-21",
            "lastDateModified": "2025-10-21",
            "comment": false,
            "dueDate": "2025-10-21",
            "locationCode": "FREEZER1",
            "startingDateTime": "2025-10-21T00:00:00Z",
            "endingDateTime": "2025-10-21T00:00:00Z",
            "active": false,
            "processingStage": "",
            "stockCenterCode": "PRODUCER01",
            "lotCode": "",
            "createdByUser": "ALAIN",
            "productionForecastNo": "",
            "salesAgreementType": "Delivery",
            "salesAgreementNo": "SA011",
            "exporterId": "",
            "mainOriginLotCode": "",
            "mixedOriginForCodeIT": false,
            "refCompany": "THESALESCOMPANY",
            "refDocumentType": "Delivery",
            "refNo": "SA645",
            "lastModified": "2025-10-21T15:13:20.147Z"
        }