David,
The ITH file has the inventory transactions and the transaction date and time are in the TTDTE and THTIME fields. I think there are some kinds of transactions generated from screens where the transaction date will default to "Today" but can be overridden, so the ITH TTDTE field may not be the date the transaction was actually done - other contributors may confirm this.
There are also other fields THCDT and THCTM which are the date and time the transaction was actually written to file.
Not sure what version you are on, but later versions cater for dates and times in different time zones - eg. USA, Australia. Most files have a "Time Zone" field beside dates, but they don't always (in fact rarely) seem to be populated and I'm not sure if the dates are just populated with a date in the system format (eg UK) or in the time zone of the user doing the transaction. I'd be interested in other users experience of dates and times when they have users in different regions/time zones.
If you don't allocate our users to different time zones, this shouldn't be an issue.
Tom Molyneux
NOV Mono
MIS Department
Tel. +44 (161) 214 2142
Fax. +44 (161) 214 2344
E:mail Tom.Molyneux@xxxxxxx
-----Original Message-----
From: bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx] On Behalf Of David.ANTONISSE@xxxxxxxxxxxxxxxx
Sent: 20 October 2010 13:36
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Last transaction date per item info - which file and field?
For a certain file I have to find the last transaction date for a list of
items.
Which field in which file should I use in a query to find this information?
Thank you very much!
Rgds,
David Antonisse
The NetherlandsPlease consider the environment before printing this e-mail. --------------------------------------------------------------------------------------------------------------------- Discover Impress on
http://www.impressgroup.com The information contained in this e-mail and any attachments is strictly confidential and may be legally privileged.It is intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee, you are hereby notified that it is prohibited and may be unlawful to disclose, distribute, store, copy the information in any medium or usage for another purpose. ---------------------------------------------------------------------------------------------------------------------
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/bpcs-l.
Delivered-To: Tom.Molyneux@xxxxxxx
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
midrange.com
