API

FTP

Manual

XML

x

x

JSON

x

CSV

x

x

Receipt

Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

ASNNumber

ASN reference identification code that allow the DC to identify the incoming goods. Typically one ASN per delivery (this may be a split of a PO).

nvarchar(50)

Mandatory

13/GRN/DeliveryNumber

HBReference

"House Bill" number. Open reference field. If no HBReference provided, ASNNumber populates this field. Must be unique. 

nvarchar(50)

13/GRN/HBRef

WarehouseETA

The date in which the goods are expected to reach the DC. Other CSV date format options available at request.

datetime

CSV: dd/MM/YYYY e.g. 12/09/2016. Other: YYYY-MM-ddTHH:mm:ssZ e.g. 2013-10-31T00:00:00Z

IsReturn

If this is a return delivery, mark this field as TRUE. If this is not specified, it will default as FALSE

boolean

true. false

Conditional: Set to TRUE if a return

Notes

Note to DC.

nvarchar(4000)

UpdateReceipt

The system will look for an existing ASN in status "Create" with the specified ASN Number. If this field is set to TRUE and the ASN Number already exists, the system will remove the existing record and create a new one in its place. This will also update the line items of the receipt.

ASN number must be unique in the system.

boolean

ReceiptType

Mark whether the receipt is a Standard delivery, or a return. Use either the IsReturn field, or this one. They control the same data in SEKO360 WMS.

nvarchar(100)

 Standard, Return

ReceiptHeader

Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

DCCode

SEKO created code that uniquely identifies the DC from other SEKO DC's. This code is supplied by SEKO.

Nvarchar(100)

Conditional: If more than one DC in use

13/GRN/DCCode

ReceiptLineItem

Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

LineNumber

Integer that uniquely identifies a line of an order. Must be more than 0. Character length restriction on the Line Number is 8. For CSV, can be auto incremented if this cannot be provided, which will increment each ASN starting from 1.

int

Mandatory

13/GRNLineItem/ LineNumber

SupplierCompanyCode

Defines which supplier is delivering the goods to SEKO. SupplierCompanyCode value used can be the default SupplierCode which is assigned to all SKU's or a supplier code that is assigned to the SKU at product master level. All suppliers created are viewable via SEKO360 'Admin→ Companies→ Suppliers'

nvarchar(100)

SKU must be assigned suppliercode

Mandatory

ProductCode

The SKU that is being delivered. A ProductCode cannot be used more than once on an ASNNumber.

nvarchar(100)

Mandatory

13/GRNLineItem/ ProductCode

Quantity

The quantity of the SKU in units.  0 Quantity should not be sent, although the iHub would not reject the ASN if 0 is sent.

int

Mandatory

11/ DeliveryArriveLineItem/ASNQuantity

ReturnReason

Reason for the return

nvarchar(100)

13/GRNLineItem/ReturnReason

BestBeforeDate

Best Before Date of SKU for delivery. SKU must be a date controlled (Load Product Master: DateControlled = TRUE). Other CSV date format options available at request.

datetime

CSV: dd/MM/YYYY e.g. 12/09/2016. Other: YYYY-MM-dd e.g. 2013-12-12)

Conditional: if SKU is date controlled and operating FEFO

LotNumber

Lot Number of SKU for delivery. SKU must be a lot controlled (Load Product Master: LotControlled = TRUE). Not case sensitive. 

nvarchar(100)

Conditional: if SKU is lot controlled

13/GRNLineItem/LotNumber