KS_GEO_RESTRICTIONS

Ordinal

Description

Data
Type

Data
Length

Required

Check
Constraints

Comments

1

Restriction ID

string

30

Y

 

This is a cross reference field used to lookup the SQL table row

2

Category Code

string

30

 

 

Optionally restrictions can be defined for all products within a category of products

3

Item ID

string

25

 

 

Optionally restrictions can be defined for a specific product item

4

Country Code

string

30

 

 

Optionally restricted geographies can be generalized to a country

5

State Code

string

30

 

 

Optionally restricted geographies can be generalized to a state or province

6

From Postal Range

integer

 

 

 

Optionally restricted geographies can be further refined based on a range of zip/postal codes. This field is the lower numerical range value. It is required if a range will be used

7

To Postal Range

integer

 

 

 

This field is the upper numerical range value. It is required if a range will be used

8

Restricted Range Flag

string

1

 

Y||N

This field defines whether the range is either restricted (value="Y") or non-restricted (value="N"). It may be easier to declare all zip codes within a geographical area as restricted except for one or more ranges. It is required if a range will be used