Welcome, Guest
Username: Password: Remember me

TOPIC: confirm ship sql table

confirm ship sql table #3005

  • TIER331382
  • TIER331382's Avatar
  • 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.

confirm ship sql table #3006

  • dgillz
  • dgillz's Avatar
  • 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
Time to create page: 0.033 seconds
Powered by Kunena Forum  Protected by R Antispam