EP CC Connector API - Production Agreements CC

Endpoint name	`ccProductionAgreements`
Source table in Wisefish	`WiFi Production Agreement`
Fixed view	No filter.
Editable	No data modification possible.
Procedures	There are no procedures on this endpoint.

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.

Data

Field List

Property	Table Field	Type	Field Type	Note
`no`	No.	Text	Code[20]
`status`	Status	Text	Option
`description`	Description	Text	Text[100]
`description2`	Description 2	Text	Text[100]
`creationDate`	Creation Date	Date	Date
`lastDateModified`	Last Date Modified	Date	Date
`comment`	Comment	true/false	Boolean	(the value false is the default value).
`dueDate`	Due Date	Date	Date
`locationCode`	Location Code	Text	Code[10]
`startingDateTime`	Starting Date-Time	DateTime	DateTime
`endingDateTime`	Ending Date-Time	DateTime	DateTime
`active`	Active	true/false	Boolean	(the value false is the default value).
`processingStage`	Processing Stage	Text	Code[20]
`stockCenterCode`	Stock Center Code	Text	Code[20]
`lotCode`	Lot Code	Text	Code[20]
`createdByUser`	Created by User	Text	Code[50]
`productionForecastNo`	Production Forecast No.	Text	Code[10]
`salesAgreementType`	Sales Agreement Type	Text	Option	`OptionMembers = Blanket,Delivery,,,,ShipmentWh;`
`salesAgreementNo`	Sales Agreement No.	Text	Code[20]
`exporterId`	WiFiStockCenter_IC.GLN	Text	Code[20]	Stock Center as registered in the main company (the other company).
`mainOriginLotCode`	Main Origin Lot Code	Text	Code[20]
`noOfLines`	WiFiEP No. of Lines	Integer	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).
`mixedOriginForCodeIT`	WiFiEP Mixed Origin for CodeIT	true/false	Boolean	`"WiFiEP Mixed Origin for CodeIT` is in a table extension `tableextension 23014083 "WiFiEP Production Agreement" extends "WiFi Production Agreement"`
`sellToCustomerNo`	Sell-to Customer No.	Text	Code[20]	from the record "WiFiCC ShipTo Info Inbox"
`sellToName`	Sell-to Customer Name	Text	Text[100]	from the record "WiFiCC ShipTo Info Inbox"
`refNo`	No.	Text	Code[20]	from the record "WiFiCC ShipTo Info Inbox". Essential field, as this is represents the original sale document.
`shipToCode`	Ship-to Code	Text	Code[10]	from the record "WiFiCC ShipTo Info Inbox"
`shipToName`	Ship-to Name	Text	Text[100]	from the record "WiFiCC ShipTo Info Inbox"
`shipToName2`	Ship-to Name 2	Text	Text[50]	from the record "WiFiCC ShipTo Info Inbox"
`shipToAddress`	Ship-to Address	Text	Text[100]	from the record "WiFiCC ShipTo Info Inbox"
`shipToAddress2`	Ship-to Address 2	Text	Text[50]	from the record "WiFiCC ShipTo Info Inbox"
`shipToCity`	Ship-to City	Text	Text[30]	from the record "WiFiCC ShipTo Info Inbox"
`shipToContact`	Ship-to Contact	Text	Text[100]	from the record "WiFiCC ShipTo Info Inbox"
`shipToPostCode`	Ship-to Post Code	Text	Text[20]	from the record "WiFiCC ShipTo Info Inbox"
`shipToCounty`	Ship-to County	Text	Text[30]	from the record "WiFiCC ShipTo Info Inbox"
`shipToCountryRegionCode`	Ship-to Country/Region Code	Text	Text[10]	from the record "WiFiCC ShipTo Info Inbox"
`shipmentMethodCode`	Shipment Method Code	Text	Text[10]	from the record "WiFiCC ShipTo Info Inbox"
`shipmentDate`	Shipment Date	Date	Date	from the record "WiFiCC ShipTo Info Inbox"
`shippingAgentCode`	Shipping Agent Code	Text		from the record "WiFiCC ShipTo Info Inbox"
`shippingAgentServiceCode`	Shipping Agent Service Code	Text		from the record "WiFiCC ShipTo Info Inbox"
`shippingFacilityCode`	Shipping Facility Code	Text		from the record "WiFiCC ShipTo Info Inbox"
`shippingReferenceType`	Shipping Reference Type	Text		from the record "WiFiCC ShipTo Info Inbox"
`shippingReferenceNo`	Shipping Reference No.	Text		from the record "WiFiCC ShipTo Info Inbox"
`shippingReferenceConsignee`	Shipping Reference Consignee	Text		from the record "WiFiCC ShipTo Info Inbox"
`transportMethodCode`	Transport Method Code	Text		from the record "WiFiCC ShipTo Info Inbox"
`placeOfDelivery`	Place of Delivery	Text		from the record "WiFiCC ShipTo Info Inbox"
`placeOfLoading`	Place of Loading	Text		from the record "WiFiCC ShipTo Info Inbox"
`placeOfDischarge`	Place of Discharge	Text		from the record "WiFiCC ShipTo Info Inbox"
`placeOfDestination`	Place of Destination	Text		from the record "WiFiCC ShipTo Info Inbox"
`systemId`	SystemId	GUID
`productionAgreementLines`		Array		Array of `productionAgreementLine` objects
lastModified	SystemModifiedAt	DateTime	DateTime

Example

Expand to see the example json

An example of one object in the list:

JSON

    "value": [
        {
            "@odata.etag": "W/\"JzE5OzgxMjkyMDYxOTc5NzA2NDc2ODgxOzAwOyc=\"",
            "systemId": "7f59e670-90ae-f011-bbd0-7c1e5288758b",
            "no": "PA951",
            "status": "Released",
            "description": "BUBBA GUMP LTD",
            "description2": "WEST MANHATTAN 12",
            "creationDate": "2025-10-21",
            "lastDateModified": "2025-10-21",
            "comment": false,
            "dueDate": "2025-10-21",
            "locationCode": "FREEZER01",
            "startingDateTime": "2025-10-21T00:00:00Z",
            "endingDateTime": "2025-10-21T00:00:00Z",
            "active": false,
            "processingStage": "",
            "stockCenterCode": "PRODUCER01",
            "lotCode": "",
            "createdByUser": "Alain",
            "productionForecastNo": "",
            "salesAgreementType": "Delivery",
            "salesAgreementNo": "SA11",
            "exporterId": "",
            "mainOriginLotCode": "",
            "mixedOriginForCodeIT": false,
            "sellToCustomerNo": "007",
            "sellToName": "The Final Distributer ltd.",
            "refNo": "Agreement01",
            "shipToCode": "1",
            "shipToName": "The Final Distributer ltd.",
            "shipToName2": "",
            "shipToAddress": "Man 72",
            "shipToAddress2": "",
            "shipToCity": "NEW YORK",
            "shipToContact": "",
            "shipToPostCode": "NY-187719",
            "shipToCounty": "",
            "shipToCountryRegionCode": "NY",
            "shipmentMethodCode": "FOB",
            "shipmentDate": "0001-01-01",
            "shippingAgentCode": "APS",
            "shippingAgentServiceCode": "",
            "shippingFacilityCode": "",
            "shippingReferenceType": " ",
            "shippingReferenceNo": "",
            "shippingReferenceConsignee": "",
            "transportMethodCode": "SEA",
            "placeOfDelivery": "",
            "placeOfLoading": "",
            "placeOfDischarge": "",
            "placeOfDestination": "",
            "lastModified": "2025-10-21T15:13:20.147Z"
        }
        ]

Overview

Data

Field List

Example