Parts history and future use

Yahoo Archive
1
yep! I am filtering by rows that have STK-CUS and STK-MTL in field tran type. Those are the only ones relevant to this report.

Thanks,
Kunal



----- Original Message ----
From: Calvin Krusen <ckrusen@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 4, 2008 3:05:03 PM
Subject: [Vantage] Re: parts history and future use


The PartTran table will give you more than you want. I spent a
couple of days creating in queries in Access (via ODBC links) to try
and identify parts without recent activity.

I found PartTran records for everything parts that had not 'real'
activity, but rather were 'touched' thus creating PartTran records
with insignificant dates. I had to make a query that first filtered
out trans action types like ADJ-CST, ADJ-STK, etc.. As I recall, our
physical inventory created PartTran records even if there was no
change in the QOH.

Only then could I look for the most recent tran dates for each part.

Just my $0.02

Calvin
--- In vantage@yahoogroups .com, Kunal Ganguly <kunal_vantage@ ...>
wrote:
>
> Hello,
>
> I need to mine some tables (in SQL) for the usage of parts in past
and future jobs over a +/-12 month timeline. The two tables I have
for this are parttran (for history) and pegdmdmst for
parts "reserved" for future jobs (also including part for the partnum
key, partbin for onhand quantity, and partcost for cost). Does anyone
have any suggestions to what other tables should be considered for
inclusion or even a better replacement for the ones I have mentioned?
The reason I ask is because I am just not sure that parttran and
pegdmdmst have all the history/future info I need.
>
> Thanks,
> Kunal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
2
Hello,

I need to mine some tables (in SQL) for the usage of parts in past and future jobs over a +/-12 month timeline. The two tables I have for this are parttran (for history) and pegdmdmst for parts "reserved" for future jobs (also including part for the partnum key, partbin for onhand quantity, and partcost for cost). Does anyone have any suggestions to what other tables should be considered for inclusion or even a better replacement for the ones I have mentioned? The reason I ask is because I am just not sure that parttran and pegdmdmst have all the history/future info I need.

Thanks,
Kunal





[Non-text portions of this message have been removed]
3
Part Detail. Contains all of the open demand and supply records

"mfgsys.PegDmdMst

This table is used during Multi-Level Pegging to store the system
demands"

I am not sure the PedDmdMst would have what you need unless you
always run multi level pegging...

--- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@...>
wrote:
>
> Hello,
>
> I need to mine some tables (in SQL) for the usage of parts in past
and future jobs over a +/-12 month timeline. The two tables I have
for this are parttran (for history) and pegdmdmst for
parts "reserved" for future jobs (also including part for the partnum
key, partbin for onhand quantity, and partcost for cost). Does anyone
have any suggestions to what other tables should be considered for
inclusion or even a better replacement for the ones I have mentioned?
The reason I ask is because I am just not sure that parttran and
pegdmdmst have all the history/future info I need.
>
> Thanks,
> Kunal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Thanks bw! The partdtl table might be a better match than the pegdmdmst. I will do some testing and report back.

Thanks,
Kunal



----- Original Message ----
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 4, 2008 12:53:03 PM
Subject: [Vantage] Re: parts history and future use


Part Detail. Contains all of the open demand and supply records

"mfgsys.PegDmdMst

This table is used during Multi-Level Pegging to store the system
demands"

I am not sure the PedDmdMst would have what you need unless you
always run multi level pegging...

--- In vantage@yahoogroups .com, Kunal Ganguly <kunal_vantage@ ...>
wrote:
>
> Hello,
>
> I need to mine some tables (in SQL) for the usage of parts in past
and future jobs over a +/-12 month timeline. The two tables I have
for this are parttran (for history) and pegdmdmst for
parts "reserved" for future jobs (also including part for the partnum
key, partbin for onhand quantity, and partcost for cost). Does anyone
have any suggestions to what other tables should be considered for
inclusion or even a better replacement for the ones I have mentioned?
The reason I ask is because I am just not sure that parttran and
pegdmdmst have all the history/future info I need.
>
> Thanks,
> Kunal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
5
The PartTran table will give you more than you want. I spent a
couple of days creating in queries in Access (via ODBC links) to try
and identify parts without recent activity.

I found PartTran records for everything parts that had not 'real'
activity, but rather were 'touched' thus creating PartTran records
with insignificant dates. I had to make a query that first filtered
out trans action types like ADJ-CST, ADJ-STK, etc.. As I recall, our
physical inventory created PartTran records even if there was no
change in the QOH.

Only then could I look for the most recent tran dates for each part.

Just my $0.02

Calvin
--- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@...>
wrote:
>
> Hello,
>
> I need to mine some tables (in SQL) for the usage of parts in past
and future jobs over a +/-12 month timeline. The two tables I have
for this are parttran (for history) and pegdmdmst for
parts "reserved" for future jobs (also including part for the partnum
key, partbin for onhand quantity, and partcost for cost). Does anyone
have any suggestions to what other tables should be considered for
inclusion or even a better replacement for the ones I have mentioned?
The reason I ask is because I am just not sure that parttran and
pegdmdmst have all the history/future info I need.
>
> Thanks,
> Kunal
>
>
>
>
>
> [Non-text portions of this message have been removed]
>