EP API - External Items

Endpoint name

externalItems

Source table in Wisefish

WiFi External Item No.

Fixed view

Shows entries with

• Type of Ext. Party = Country or Customer

Editable

No data modification possible.

Procedures

There are no procedures on this endpoint.

Primary Key

 "Type of Ext. Party", "External Party Code", "Ext. Item No."

Property

Type

Table Field

Field Type

Note

itemNo

string

Item No.

Code[20]

TableRelation = Item where("WiFi Item Type" = filter(RawMat .. Product));

externalPartyCode

string

External Party Code

Code[20]

countryOfOrigin

string

Country of Origin

Code[10]

TableRelation = "Country/Region";

trademark

string

Trademark

Code[10]

extItemNo

string

Ext. Item No.

Code[20]

NotBlank = true;

extItemDescription2

string

Ext. Item Description 2

Text[300]

typeOfExtParty

string

Type of Ext. Party

Option

Stock Center,Customer,Vendor,Country'

noOfTIsPerPallet

decimal

No. of TIs per Pallet

Decimal

(Represents how many boxes are on a full pallet).

noOfTIsPerContainer

decimal

No. of TIs per Container

Decimal

(Represents how many boxes are in a container. The downside: In order for this to work, one has to decide beforehand if the relation should be to a 20ft container or a 40 ft container).

tiUnitOfMeasure

string

TI Unit of Measure

Code[10]

value to expect, Box, KG, LB etc.

palletUnitOfMeasure

string

Pallet Unit of Measure

Code[10]

value to expect: Pallet

containerUnitOfMeasure

string

Container Unit of Measure

Code[10]

value to Expect: 40 FT (or 20 FT)

extItemDescription

string

Ext. Item Description

Text[100]

The relevant description of the entry (specific to what is defined in Type of Ext. Party)

extItemSearchDescription

string

Ext. Item Search Description

Code[100]

shelfLifeDays

integer

Shelf Life Days

Integer

Interpretation of bestBefore. Some companies use “shelf life day left” rather than bestBefore.

expirationUnit

string

Expiration Unit

Integer

To be used together with “Expiration Type” in Item table.
(Expiration Type is an option field, containing options: Days, Months, Years
So, if one puts, say 18 into this field, and Item.”Expiration type” is set to Months, then the expiration calculation is set to 18 months after production date.

lastDateModified

date

Last Date Modified

Date

Last date this record was modified. It is suggested not to filter on this field, rather filter on “lastModified”, see the last field in this table, because that is a dateTime field, and thus will indicate changes more frequently.

countryInnerLabel

string

Country Inner Label

Text[30]

Represents the code of inner label for this record.

countryTradeItemLabel

string

Country Trade Item Label

Text[30]

Represents the code of trade item label for this record.

countryOuterLabel

string

Country Outer Label

Text[30]

Represents the code of outer label for this record.

countryPalletLabel

string

Country Pallet Label

Text[30]

Represents the code of pallet label for this record.

noOfLabels

integer

“No. Of Labels”

Integer

Counts the number of labels associated with this External Item No.
BlankZero = true
(can be benefical for external production system, as it can then check if the number of labels matches the number of labels they have).

systemId

string uuid (Universally Unique Identifier)

SystemId

GUID (Globally Unique Identifier)

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.