ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Table Information Need it
http://www.istechforum.com/YaBB.pl?num=1080666926

Message started by Kelloggs on 03/30/04 at 09:15:26

Title: Table Information Need it
Post by Kelloggs on 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

???

Title: Re: Table Information Need it
Post by aricon on 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.

Title: Re: Table Information Need it
Post by Kelloggs on 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
:P

Title: Re: Table Information Need it
Post by aricon on 03/30/04 at 12:33:06

Don't understand what you mean.

Title: Re: Table Information Need it
Post by Tim Keating on 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