Description
...
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
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 |
...