Description |
Once a delivery is confirmed by the DC on SupplyStream, this method will push the delivery information to the Hub. |
...
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
GRN | ||
Field | Description | Data Type |
MessageGroupId | Placeholder | nvarchar(100) |
MessagePart | This is the message part of the total number of messages. | int |
MessageTotal | This is the total number of messages. | int |
IntegrationId | This is determined by SupplyStream and is the client unique identifier. This will be a consistent unique value per client. Example: CCIND | nvarchar(100) |
SequenceNumber | This is determined by SupplyStream. Every push message will increment by 1 for each service selected | int |
RMA | This data is generated only on a return raised by the DC against the sales order number. Of the Push GRN message, you also have the HB Ref and Delivery Number fields. This RMA field is a conjunction of both these fields. For example: | nvarchar(50) |
ReceiptReason | Placeholder. | nvarchar(50) |
InterfaceRecordId | This is the SupplyStream Globally Unique Identifier. If the GUID is not provided in the Load message, this will be automatically generated by the system. System generated example: a99645dc-5b45-4917-890c-4b02c68ac342. | varchar(100) |
DeliveryNumber | This is the delivery reference number. An ASN Number provided in the Load Receipts message will show here. If the return was raised by the DC against the sales order number, this will be an incremental value. | nvarchar(100) |
HBRef | The HB_Ref provided in the Load Receipts message will show here. For returns raised by the DC against the sales order number, this field will contain the original sales order number the goods were dispatched on. | nvarchar(50) |
ArrivedDate | The date that the DC has marked the ASN as arrived. | datetime |
ReceivingStartDate | The date that the DC started receiving the ASN | datetime |
ConfirmedDate | The date that the DC have confirmed the ASN as put away | datetime |
DCCode | SEKO created code that uniquely identifies the DC from other SEKO DC's. This code is supplied by SEKO. | nvarchar(100) |
ReturnService | Placeholder | nvarchar(100) |
SupplierCode | Supplier code assigned to the ASN | nvarchar(100) |
DeliveryType | The Type of the delivery, i.e. Standard, Return | nvarchar(100) |
GRNLineItem | ||
Field | Description | Data Type |
LineInterfaceRecordId | SupplyStream internal value. Example: 31dcea54-d4c9-42a7-bed9-6fe22d1f7a41 | varchar(100) |
LineNumber | Integer that identifies the line number of the ASN/GRN. If the return was raised by the DC against the sales order number, this will match the line number of the sales order. | int |
ProductCode | The product code of the SKU that has been processed | nvarchar(100) |
EAN | The EAN of the SKU that has been processed | nvarchar(50) |
Quantity | The quantity that was received. Quantity shows total stock GRN'd, irrespective of location. | int |
ReturnCode | This is the returns code that was entered by the DC when returns are raised by the DC against the sales order number | nvarchar(50) |
ReturnReason | Returns the data specified in the ReceiptLineItem → ReturnReason. Alternatively, this is the notes entered by the DC when returns are raised by the DC against the sales order number | nvarchar(100) |
LotNumber | The lot number of the SKU processed | nvarchar(100) |
UOM | The system currently supports single units and the UOM will return 1 | nvarchar(50) |
QCRequired | Placeholder | boolean |
ProductDescription | The description of the SKU, set on the product master. | nvarchar(200) |
HTSCode | The HTS Code of the SKU, set on the product master. | nvarchar(100) |
ASNQuantity | Quantity that was input when the ASN was first raised. | int |
...