Macola Forum :: Topic: confirm ship sql table (1/1)

Welcome, Guest

TOPIC: confirm ship sql table

TIER331382 OFFLINE Fresh Boarder Posts: 2 Karma: 0	Where is the confirm ship table stored as I would like to create a Crystal report with the data
	The administrator has disabled public write access.

dgillz OFFLINE Platinum Boarder Posts: 395 Thank you received: 14 Karma: 6	There is no "table" to indicate what has confirm shipped. The oeordhdr_sql.status field will tell you this. Status 7 is confirm shipped. There is also a shipped_dt field in the oeordlin_sql table that will tell you the date this happened. This is important as not all line items on a given order of status 7 have necessarily been confirm shipped.
	www.gainfocus.biz Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports. Last Edit: by dgillz. The administrator has disabled public write access. The following user(s) said Thank You: TIER331382