VENDOR
|
DB Column
|
Field name
|
Sample
|
Sequence
|
Begin
|
End
|
Length
|
Decimal Places
|
|
Vendor_ID
|
Vendor ID
|
230113
|
1
|
1
|
9
|
9
|
N/A
|
|
Location
|
Location #
|
3
|
2
|
10
|
14
|
5
|
N/A
|
|
A_Fill_Rate
|
Class A Order Fill Rate %
|
88.8
|
3
|
15
|
18
|
4
|
1
|
|
Class A Ord. Freq in days
|
Class A Ord. Freq in days
|
14
|
4
|
19
|
22
|
4
|
0
|
|
Class A Aqusition Time
|
Class A Aqusition Time
|
|
5
|
23
|
26
|
4
|
0
|
|
Class A Transit Time
|
Class A Transit Time
|
|
6
|
27
|
30
|
4
|
0
|
|
Class A Safety Time
|
Class A Safety Time
|
|
7
|
31
|
34
|
4
|
0
|
|
Class B Order Fill Rate %
|
Class B Order Fill Rate %
|
44.6
|
8
|
35
|
38
|
4
|
1
|
|
Class B Ord. Freq in days
|
Class B Ord. Freq in days
|
90.9
|
9
|
39
|
42
|
4
|
0
|
|
Class B Aqusition Time
|
Class B Aqusition Time
|
|
10
|
43
|
46
|
4
|
0
|
|
Class B Transit Time
|
Class B Transit Time
|
|
11
|
47
|
50
|
4
|
0
|
|
Class B Safety Time
|
Class B Safety Time
|
|
12
|
51
|
54
|
4
|
0
|
|
Class C Order Fill Rate %
|
Class C Order Fill Rate %
|
22.2
|
13
|
55
|
58
|
4
|
1
|
|
Class C Ord. Freq in days
|
Class C Ord. Freq in days
|
44.4
|
14
|
59
|
62
|
4
|
0
|
|
Class C Aqusition Time
|
Class C Aqusition Time
|
|
15
|
63
|
66
|
4
|
0
|
|
Class C Transit Time
|
Class C Transit Time
|
|
16
|
67
|
70
|
4
|
0
|
|
Class C Safety Time
|
Class C Safety Time
|
|
17
|
71
|
74
|
4
|
0
|
|
Goal Percent Weight
|
Goal Percent Weight
|
80.5 (=80.5%)
|
18
|
75
|
84
|
10
|
0
|
|
Goal Percent Units
|
Goal Percent Units
|
50
|
19
|
85
|
94
|
10
|
0
|
|
Goal Percent Volume
|
Goal Percent Volume
|
60
|
20
|
95
|
104
|
10
|
0
|
|
Goal Percent Cost
|
Goal Percent Cost
|
70
|
21
|
105
|
114
|
10
|
0
|
|
Goal Weight
|
Goal Weight
|
40000 (=40000)
|
22
|
115
|
124
|
10
|
0
|
|
Goal Units
|
Goal Units
|
500
|
23
|
125
|
134
|
10
|
0
|
|
Goal Volume
|
Goal Volume
|
240
|
24
|
135
|
144
|
10
|
0
|
|
Goal Cost
|
Goal Cost
|
15000
|
25
|
145
|
154
|
10
|
0
|
|
Goal Option
|
Goal Option
|
1
|
26
|
155
|
155
|
1
|
|
VENDOR INFO
|
Column
|
Field name
|
Sample
|
Sequence
|
Begin
|
End
|
Length
|
Decimal Places
|
|
Vendor #
|
Vendor #
|
9
|
1
|
1
|
9
|
9
|
N/A
|
|
Location #
|
Location #
|
2
|
2
|
10
|
14
|
5
|
N/A
|
|
Name
|
Name
|
National Business Data Systems
|
3
|
15
|
44
|
30
|
N/A
|
|
Address 1
|
Address 1
|
1400 Energy Park
|
4
|
45
|
74
|
30
|
N/A
|
|
Address 2
|
Address 2
|
Suite #24
|
5
|
75
|
104
|
30
|
N/A
|
|
City
|
City
|
St.Paul
|
6
|
105
|
119
|
15
|
N/A
|
|
State
|
State
|
MN
|
7
|
120
|
121
|
2
|
N/A
|
|
Zip
|
Zip
|
55108-0000
|
8
|
122
|
131
|
10
|
N/A
|
|
Phone
|
Phone
|
612/647-0143
|
9
|
132
|
146
|
15
|
N/A
|
|
FAX
|
FAX
|
612/642-0913
|
10
|
147
|
161
|
15
|
N/A
|
|
Attn.
|
Attn.
|
Ron Fishback
|
11
|
162
|
191
|
30
|
N/A
|
|
Buyer
|
Buyer
|
Keith Root
|
12
|
192
|
206
|
15
|
N/A
|
