EP API - Inbound Entries

Endpoint name

inboundInnovaEntries

Source table in Wisefish

"WiFi Inbound from Innova"

Fixed view

No filter.

Editable

This API will only insert new entries.

Procedures

There are no procedures on this endpoint, POST request is used to insert data. (Modify not allowed).

Primary key of table

Line no. (auto increment integer). Handled internally, sender of data doesn’t have to do anything about it.

Property

Table Field

Type

Notes

packetId

PacketID

Integer

field that allows external production system to send in a reference to the records sent to wisefish. Can be used for backwards traceability.

producerId

ProducerID

Text[20]

weight

Weight

Decimal

quantity

Quantity

Integer

quantityUnit

QuantityUnit

Code[10]

lotId

LotID

Code[20]

itemId

ItemID

Code[20]

(accepts value upto Code[30], but will be truncated to 20 before validating)

palletNo

PalletNo

Code[20]

palletStatus

"Pallet Status"

Option

" ",Open,Full

warehouseId

WarehouseID

Code[20]

productionDate

ProductionDate

DateTime

orderNo

OrderNo

Code[20]

orderLineNo

OrderLineNo

Integer

material

Material

Code[20]

supplier

Supplier

Code[20]

po

Po

Code[20]

(accepts value upto Code[30], but will be truncated to 20 before validating)

usageDate

UsageDate

Date

lotFrom

LotFrom

Code[20]

lotTo

LotTo

Code[20]

nominal

Nominal

Decimal

Represents “the sales weight” from ext. prod. system. Is optional.

registrationDate

RegistrationDate

DateTime

handledPacketDate

HandledPacketDate

DateTime

handledPalletDate

HandledPalletDate

DateTime

soapPacketNo

SoapPacketNo

Integer

Obsoleted field

soapPalletNo

SoapPalletNo

Integer

Obsoleted field

lotDescription

LotDescription

Text[30]

weightUnit

WeightUnit

Code[10]

masters

Masters

Decimal

Decimal places 2:5 (minimum 2, maximum 5).

soapID

SoapID

Text[10]

• 107 = Production

• 108 = Receiving

• 119 = Remove from Pallet

• 120 = Sales (can trigger Production through DA also)

• 122 = Consumption

• 123 = Credit Production

sscc

SSCC

Code[20]

Pallet number in SSCC format.

processed

Processed

Boolean

Represents if wisefish has processed (posted) the entry. Irrelevant, because the record is moved to an archive table at the time of posting.

transactionTable

"Transaction Table"

Option

OptionMembers = " ",Receiving,Consumption,Production,"Estimated Catch",Pallet,Sales

wPConnectionPK

"WP Connection PK"

BigInteger

Irrelevant, for internal use (WiseFish maps together records containing same basic parameters, in order to consolidate them into fewer entries containing more quantity per entry at the time of posting).

tripNo

TripNo

Code[20]

Fishing Trip No.

portNo

PortNo

Code[10]

Number of Harbor that fish was landed into.

landingType

LandingType

Code[10]

Parameter to determine if fishing trip line is supposed to have normal affect on inventory, salary and quota, or some exceptional affect (such as landed as damaged, thus inventory = 0).

startDate

"Fishing Trip Start Date"

Date

first date of fishing trip

endDate

"Fishing Trip End Date"

Date

last date of fishing trip

aveWeightOfFish

"Average Weight of Fish"

Decimal

Used to populate corresponding field in a fishing trip line, when importing received qty into a fishing trip. (receiving “a landing note” into a fishing trip.

landingDate

LandingDate

DateTime

the landing date of fishing trip (can be the same as ending date of fishing trip, but not before that).

catchArea

CatchArea

Code[10]

The formal area where the catch of fishing trip line belongs to. Can be used to affect quota deduction.

container

Container

Code[20]

Represents a fishing trip (raw material) tub number.

sizeGrade

SizeGrade

Code[10]

Raw material size grade

qualityGrade

QualityGrade

Code[10]

raw material quality grade

reserveToAgreementType

ReserveToAgreementType

Option

OptionMembers = Delivery,Production,Receipt,ShipmentWh,BlanketPurch,StorageReceiptAgr,BCPurchaseDoc

reserveToAgreementNo

ReserveToAgreementNo

Code[20]

Document No.

reserveToAgreementLineNo

ReserveToAgreementLineNo

Integer

Document Line No.

delAgreeNo

DelAgreeNo

Code[20]

Document No. of sales order (delivery agreement) that this record belongs to. Often used when produced to order.

delAgreeLnNo

DelAgreeLnNo

Integer

Document Line No. of sales order (delivery agreement). Often used when produced to order.

shippingRefNo

"Shipping Reference No."

Code[20]

Ability for external prod. system to send this info to wisefish. It is inherited to delivery agreement header in wisefish.

extDocumentNo

"External Document No."

Code[35]

OptionCaption = ' ,AWB (Airway Bill),Consignment Note'
OptionMembers = " ",AWB,CONNOTE

validateCert

"Validate Incoming Cert"

Option

OptionMembers = " ",Validate;
Option Validate opens up an exception in Wisefish, that allows an external production system to send in production related information, for example to create a lot, or produce a pack, but violate (ignore) all internal logic of wisefish that would normally automatically assign certifications (i.e. allowing user on external system to manually control this).

customer

Customer

Code[20]

Code of customer (relates to sales document)

currency

Currency

Code[10]

Stands for currency of sales document, codes such as EUR, USD expected.

salesDate

SalesDate

Date

The date of the sales document.

salesPrice

SalesPrice

Decimal

The price in a line of a sales document. If the document is in USD, then this price represents USD.

sealNoexport

"Seal No. (Export)"

Code[20]

Seal number on container. Can be used in sales documents.

containerNoExport

"Container No. (Export)"

Code[20]

The fixed number of the container in a sales document.

shippingAgentCode

"Shipping Agent Code"

Code[10]

The shipping company specified in a sales document

certificationProgram

CertificationProgram

Code[10]

Expected values such as MSC. Used in pelagic factories, as they decide the certification on the fly in the production system.

originalRecordedWeight

"Original Recorded Weight"

Decimal

The weight originally sent from the production system. Kept for reference.

processingOption

"Processing Option"

Option

Not relevant, only for internal use of wisefish
OptionMembers = " ",Process,CloseAsError,NotUsed;

errorMsg

ErrorMsg

Text[200]

internal use in wisefish. If wisefish can not post the record, it will throw an error in this field, stating what is missing/wrong in order for the record to post.

warning

Warning

Text[50]

Same as errorMsg.

bestBeforeDate

BestBeforeDate)

Date

the bestBeforeDate

workCenter

"Work Center"

Code[20]

Becomes a “stage” in posted trade item.

processingRouteCode

"Processing Route Code"

Code[20]

rarely used.

palletStartDateTime

"Pallet Start DateTime"

DateTime

Start date/time of pallet.

palletEndDateTime

"Pallet End DateTime"

DateTime

End date/time of pallet.

tareWeight

"Tare Weight"

Decimal

Tare weight of pallet. Rarely used.