| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 5143.1 | | BUSY::SLAB | A thousand pints of lite | Tue Feb 18 1997 13:13 | 4 |
|
How about a customer name/number or identifying order format on
a PO?
|
| 5143.2 | | ASABET::DCLARK | NP-complete | Tue Feb 18 1997 14:10 | 8 |
| re .-1
well, the data sample I'm looking at has about 5900 DEC numbers
in it, and about 700 different customer names. About 3700 of the
DEC numbers have customer name = blank. Customer numbers map into
more than one customer name. What's identifying order format?
thanks - Dave
|
| 5143.3 | | BUSY::SLAB | Act like you own the company | Tue Feb 18 1997 14:24 | 23 |
|
Typically, a PO [purchase order] number will be unique to a spec-
ific customer, and the format of that PO number or order number
might even help to identifythe customer:
MOTOROLA - MOT12345, MOT00013
IE, a common prefix, or a standardized alphanumeric combination
or configuration.
However, if the data isn't entered/retained, it's very difficult
[if not impossible] to retrieve.
Keep in mind that I'm basing this on my own knowledge, and I do
realize that not all systems record/retain data the way ours does
here ... so don't think that you're doomed just because it looks
that way to me.
And also keep in mind that a customer might become a distributor
at times also. IE, sometimes the end user and sometimes a mid-
dleman for other end users ... and I don't think that your infor-
mation would reveal that.
|
| 5143.4 | | BUSY::SLAB | Act like you own the company | Tue Feb 18 1997 14:25 | 4 |
|
Oh, yeah ... can you tie your info back to a more complete data-
base? Or is what you have as complete as you're going to get?
|
| 5143.5 | Maybe you can use... | HITOPS::BURKHARDT | | Tue Feb 18 1997 15:00 | 7 |
| Dave,
When you say "distributor order" are you referring to where
the order is being fulfilled (i.e. MICROAGE, TECH DATA)? If so, you
can use the ORS Document No. assigned by the Switch.
Paul
|
| 5143.6 | ex | ASABET::DCLARK | NP-complete | Tue Feb 18 1997 15:20 | 12 |
| re .-1
yes, that's what I'm referring to. The database I'm using is
a corporate database called DOC which gets its feed from DRC.
I don't know if the ORS Document No. is in there; I'll look
for it.
I've found a list of distributors/resellers on the internal
web; bouncing that off the orders data 'by eyeball' looks
promising.
thanks - Dave
|
| 5143.7 | call me | HITOPS::BURKHARDT | | Wed Feb 19 1997 21:02 | 6 |
| Dave,
Send me email or give me a call and we'll discuss it in more
detail.
Paul
|
| 5143.8 | thanks guys | ASABET::DCLARK | NP-complete | Fri Feb 21 1997 15:13 | 7 |
| Thanks to Moe Beauchesne and Paul for helping me out! I'm
a tad less baffled than I was a few days ago about the
mind-numbing complexity of Digital's order processing
and fulfillment.
Also, as was pointed out to me, DOC gets its feed from FOCUS
and common scheduling, not DRC.
|