Dear Jeff There is a field in the parts table called 'priceupdate'.
When a part is created, the date is inserted in this field. Not sure what other events trigger this field to be updated. Regards Jean-Pierre _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Jean-Pierre Guillou Director *DCDM Management Services Ltd* Tel PABX : (230) 202 3000 Tel Direct : (230) 202 3057 Fax : (230) 208 0086 Web :www.dcdm-ms.com Business Registration Number : CC07051938 ******************************************************************** Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivering the message to the intended recipient), you should not read it, nor copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply E-mail. Opinions, conclusions and other information in this message that do not relate to the official business of any member firm of the DCDM Organisation shall be understood as neither given nor endorsed by the firm. On 26 October 2011 23:14, Jeff Kaminsky <[email protected]> wrote: > Is there any way in SQL to run a report to see what day a part number was > created? I need to review new parts created for accuracy and I have not > otherwise been informed by actual people when that happens. > > -- > Jeff Kaminsky > Sr. Accountant / Logistics > IX Systems > 408-943-4100 ext 122 > 408-943-4101 fax > > ______________________________**_________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/**mailman/listinfo/sql-ledger<http://lists.ledger123.com/mailman/listinfo/sql-ledger> >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
