Topic Options
#26904 - 04/12/11 05:43 AM OE Time Stamp
GeorgeandLaura Offline
Adagio Scholar

Registered: 08/09/10
Posts: 92
Loc: LaSalle Ontario
Hi There, Does anyone know of an Order Entry Time stamp that I can pull into Gridview. I see a date in the DB, but I don't see anything with a time extension. Thanks!

Top
#26905 - 04/12/11 06:19 AM Re: OE Time Stamp [Re: GeorgeandLaura]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4509
Loc: Wynnewood, PA
I'm looking in the O/E Sales Order Header Master table, and I see two time stamp fields - "Created Time" and "Last Updated Time". They are at the very end of the list of fields. There are also date and time stamp fields that indicate when each each form was printed.

Where were you looking?

Steve

Top
#26906 - 04/12/11 06:25 AM Re: OE Time Stamp [Re: Steve Schwartz]
GeorgeandLaura Offline
Adagio Scholar

Registered: 08/09/10
Posts: 92
Loc: LaSalle Ontario
Not there, I guess - thanks! :o)

Top
#26907 - 04/12/11 06:32 AM Re: OE Time Stamp [Re: GeorgeandLaura]
GeorgeandLaura Offline
Adagio Scholar

Registered: 08/09/10
Posts: 92
Loc: LaSalle Ontario
FYI - I am using the OE Hst Detail w/ Head table. I am pulling in detals for each order and just need the time the order was last changed or placed.
Thanks for your help.


Edited by GeorgeandLaura (04/12/11 06:33 AM)

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 79 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70632 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30