-------------------------------------------------------
The following are data
file formats that are used when a passing data between
our system and our retailers. All files should be a
simple text format using DOS naming conventions. Please
contact us in regards to the data transfer options that
are available.
Advanced Shipping Notice
The file contains a header portion and a
detail portion. The first record in the file identifies the file as an
advance ship notice file and the Watters and Martin customer number.
Each record it terminated by a CR & LF.
Header portion
First record
1-10 "ASN" (left adjusted)
11-20 Watters and Martin customer number (right adjusted)
Second record
1-5 "##EOH"
Detail portion
Record for each item
1-8 invoice number
9-23 po number (W&M invoice # is rightmost 8 positions)
24-30 Watters and Martin item number
31-42 universal product code
43-56 manufacturer part number
57-63 quantity shipped (0 decimals)
64-72 unit price (2 decimals)
73-81 retail price (2 decimals)
82-111 description
112-113 unit of measure
114-118 shelf pack quantity (0 decimals)
119-119 break shelf pack? (Y=yes; N=no)
120-122 item category code (descriptions of each code are available
123-132 Watters and Martin vendor number Left justified, (listing of
vendor numbers and names is available)
133-140 invoice date
End of File
1-5 "##EOF"
Promotions
The file contains a header portion and a
detail portion. The first record in the file identifies the file as an
promotion file and the Watters and Martin customer number. Each record
it terminated by a CR & LF.
Header portion
First record
1-10 "PR" (left adjusted)
Second record
1-5 "##EOH"
Detail portion
Record for each item
1-7 Watters and Martin item number
8-17 promotion number
30-36 promotion cost
37-45 promotion retail price
47-52 start date
54-59 stop date
End of File
1-5 "##EOF"
Retail Price
File
The file contains a header portion and a
detail portion. The first record in the file identifies the file as an
retail price file and the Watters and Martin customer number. Each
record it terminated by a CR & LF.
Header portion
First record
1-10 "Retail" (left adjusted)
11-20 Watters and Martin customer number (right adjusted)
Second record
1-5 "##EOH"
Detail portion
Record for each item
1-7 Watters and Martin item number
8-15 retail price
End of File
1-5 "##EOF"
----------------------------------------------------------------
 
|
