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
|