Home > Technical > Table Definitions > DELIVERYSLOT

DELIVERYSLOT

Delivery slots are used to control when an item can be delivered. Its currently used for customer orders but could be extended for goods receipt use as well. It basically controls what time windows are available each day for delivery orders. for example customer orders can be delivered 9:00-12:00 Monday to Friday as well as 13:00-17:00 on Tuesday and Thursday.

Column Type Description
STRTRADECODE VARCHAR(10) The location to which the delivery rule belongs.

TRADUNIT.strTradeCode

STRGUID VARCHAR(10) Unique identifier assigned by the system.
INTTYPE INT Indicates the usage of the rule. 0=Customer Order
YSNSUNDAY VARCHAR(1) 'T' if this delivery slot can be used on Sunday.
YSNMONDAY VARCHAR(1) 'T' if this delivery slot can be used on Monday.
YSNTUESDAY VARCHAR(1) 'T' if this delivery slot can be used on Tuesday.
YSNWEDNESDAY VARCHAR(1) 'T' if this delivery slot can be used on Wednesday.
YSNTHURSDAY VARCHAR(1) 'T' if this delivery slot can be used on Thursday.
YSNFRIDAY VARCHAR(1) 'T' if this delivery slot can be used on Friday.
YSNSATURDAY VARCHAR(1) 'T' if this delivery slot can be used on Saturday.
DTMFROMTIME DATETIME The from time of the delivery slot.
DTMTOTIME DATETIME The to time of the delivery slot.
 

Primary Key: STRTRADECODE + STRGUID

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)