Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Description

This method can be called to create new receipts in SupplyStream, suitable for both standard deliveries and returns. This will create an advance ship notice of pending deliveries to the DC.

...


API

FTP

Manual

XML

x

x


JSON

x



CSV


x

x

Supplier details management

...

 Entity Relationships

This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.

Field level details

SupplyStream Globally Unique Identifier. If GUID not provided, this will be automatically generated by the system. System generated example:
a99645dc-5b45-4917-890c-4b02c68ac342. Returned in API response message. Mustbe unique to the service.

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.

Duplicate ASNNumber rejection setting can be on, alongside this functionASN 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 SupplyStream.

nvarchar(100)

 Standard, Return

GUID





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

...

GUID

ReceiptLineItem







Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

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

SupplyStream Globally Unique Identifier. If GUID not provided, this will be automatically generated by the system. System generated example:
a99645dc-5b45-4917-890c-4b02c68ac342. Must be unique to the line of the order.
varchar(100)

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 SupplyStream '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

...