EP API - Production Agreement Lines

Overview

This API returns the Production Agreement Lines.

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	`productionAgreementLines`
Source table in Wisefish	`WiFi Production Agreement Line`
Fixed view	No filter.
Editable	No data modification allowed.
Primary Key	`consist of 2 fields: "Prod. Agreement No.", "Line No."`

Data

Field List

Property	Table Field	Type	Field Type	Note
`productionAgreementNo`	Prod. Agreement No.	Text	Code[20]
`status`	Status	Option	Option	`OptionMembers = Simulated,Planned,"Firm Planned",Released,Finished;`
`lineNo`	Line No.	Integer	Integer
`itemNo`	Item No.	Text	Code[20]
`variantCode`	Variant Code	Text	Code[10]	Represents variant such as size grade and/or quality grade.
`description`	Description	Text	Text[100]
`description2`	Description 2	Text	Text[50]
`binCode`	Bin Code	Text	Code[20]	Represents a warehoues “bin code” (like a rack or “one specific place in a location”).
`quantity`	Quantity	Decimal	Decimal
`priority`	Priority	Integer		The idea behind this field is to enable user in a production system to have a screen that shows lines to produce to, in priority order.
`unitOfMeasureCode`	Unit of Measure Code	Text	Code[10]
`quantityBase`	Quantity (Base)	Decimal	Decimal	Decimal places 2:5 (minimum 2 decimals below zero, max 5).
`reserveItemNo`	Reserve Item No.	Text	Code[20]	This field is not used.
`palletStandardCode`	Pallet Standard Code	Text	Code[20]	For example used by CodeIT in Norway. Represents what pallet standard to use.
`numberOfTIsOnPallet`	WiFiPalletStandard. Number of TIs on Pallet	Decimal	Decimal	Number of trade items (boxes ,or “outers / inners” on a pallet).
`processingOptionCode`	Processing Option Code	Text	Code[10]	This field is not used.
`processingOptionDescription`	Processing Option Description	Text	Text[50]	This field is not used.
`lotLineInteger`	Lot-Line Integer	Integer	Integer	Only used in integration with the external RBK production system (germany/netherlands)
`lotLineNo`	Lot-Line No.	Text	Code[20]	Only used in integration with the external RBK production system (germany/netherlands)
`minimumQuantity`	Minimum Quantity	Decimal	Decimal	Decimal places 0:5 (minimum 0 decimals below zero, max 5).
`maximumQuantity`	Maximum Quantity	Decimal	Decimal	Decimal places 0:5 (minimum 0 decimals below zero, max 5).
`noOfTradeItems`	No. of Trade Items	Decimal	Decimal	Decimal places 0:5 (minimum 0 decimals below zero, max 5).
`tiUnitOfMeasureCode`	TI Unit of Measure Code	Text	Code[10]
`stockCenterFilter`	Stock Center Filter	Text	Code[20]	Ability to select a stock center (producer) for the record.
`fishingTripFilter`	Fishing Trip Filter	Text	Code[20]	Ability to set a filter on fishing trip for the record.
`tradeItemsBase`	Trade Items (Base)	Decimal	Decimal	Decimal places 0:5 (minimum 0 decimals below zero, max 5).
`tiBaseUoMCode`	TI (Base) UoM Code	Text	Code[10]	(value expected such as KG, LB etc.)
`qtyPerUnitOfMeasure`	Qty. per Unit of Measure	Decimal	Decimal	Decimal places 0:5 (minimum 0 decimals below zero, max 5).
`salesAgreementType`	Sales Agreement Type	Text	Option	`OptionMembers = Blanket,Delivery;`
`salesAgreementNo`	Sales Agreement No.	Text	Code[20]	The document number that this line belongs to.
`salesAgreementLineNo`	Sales Agreement Line No.	Integer	Integer	The records line no.
`systemId`	SystemId	GUID
`lastModified`	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

   "value": [
        {
            "@odata.etag": "W/\"JzE5Ozc2NTI1NTE4MzkzNzQzNTU2ODYxOzAwOyc=\"",
            "systemId": "e2663614-faed-ef11-aac0-c0b6f9b7cac7",
            "productionAgreementNo": "PA20000000",
            "status": "Finished",
            "lineNo": 10000,
            "itemNo": "FINALPROD43",
            "variantCode": "",
            "description": "SHRIMP, COOKED and PEALED, IQF, 150-250 pcs/lb, 8-12% GLAZING. 4 x 3 kg TITAN",
            "description2": "",
            "binCode": "",
            "quantity": 21840,
            "priority": 3,
            "unitOfMeasureCode": "KG",
            "quantityBase": 7280,
            "reserveItemNo": "",
            "palletStandardCode": "S600_10",
            "numberOfTIsOnPallet": 70,
            "processingOptionCode": "",
            "processingOptionDescription": "",
            "lotLineInteger": 0,
            "lotLineNo": "",
            "minimumQuantity": 0,
            "maximumQuantity": 0,
            "noOfTradeItems": 1820,
            "tiUnitOfMeasureCode": "CASE",
            "stockCenterFilter": "PRODUCER01",
            "fishingTripFilter": "",
            "tradeItemsBase": 1820,
            "tiBaseUoMCode": "KRT",
            "qtyPerUnitOfMeasure": 0.333333333333333333,
            "salesAgreementType": "Delivery",
            "salesAgreementNo": "DELAGREE200",
            "salesAgreementLineNo": 10000,
            "lastModified": "0001-01-01T00:00:00Z"
        }
        ]