ISTech Support Forum - Table Information Need it

Welcome, Guest. Please Login.

	05/11/24 at 14:50:40 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues

‹ Previous topic | Next topic ›

Pages: 1

Table Information Need it (Read 920 times)

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Table Information Need it 03/30/04 at 09:15:26 What are these tables for?? Do they show what goes in and out of the inventory?? WOHRECV and WORECV WOHROUT and WOROUT Thank you all, Kelloggs ???
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

aricon

Active Member

Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male

Re: Table Information Need it
Reply #1 - 03/30/04 at 10:32:11

WORECV is the table that gets posted to when doing WO receipts and WOHRECV is the archive schema table for the same thing. In other words it gets populated when you archive WO info.

WOROUT is the WO specific routings table. When you convert a sales order item into a WO and it has a standard routing associated with the item, that routing gets copied into this table. Also when you create a WO routing in WO-K-B. WOHROUT is the archive schema table for this.

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: Table Information Need it Reply #2 - 03/30/04 at 11:40:28 Hi, Is there a specific table that has what has come out of the inventory?? Thank you, Kelloggs PD: wrong window
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Table Information Need it Reply #3 - 03/30/04 at 12:33:06 Don't understand what you mean.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

Tim Keating

Senior Member

DBA CLASSIC WIN 2000
C/S

Posts: 298

Re: Table Information Need it
Reply #4 - 03/30/04 at 17:10:53

Maybe you mean inventory transactions? They are collected in the INVTXN File.

A - Adjustments
S - Shipments
P - Purchase order receipts to stock
J - Purchase order receipts to work-in-process
W - Work order receipts to stock
I - Stock issues to work-in-process
O - Outside Processing Receipt to Work Order
Q - Purchase Receipt to QC
C - AP Price Change

Tim Keating
Motor Guard Corporation

IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues

‹ Previous topic | Next topic ›