ISTech Support Forum

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

Message started by Kelloggs on 04/06/04 at 10:40:26

Title: INVTXN Table
Post by Kelloggs on 04/06/04 at 10:40:26

Hi,
The table INVTXN has a column called: MTIT_TYPE that has the following values

A
C
I
J
M
P
Q
S
W

Could anyone tell me what those letters stand for?

Thank you,

Kelloggs

Title: Re: INVTXN Table
Post by tcook on 04/06/04 at 10:44:57

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

Title: Re: INVTXN Table
Post by Kelloggs on 04/06/04 at 11:23:50

:D

Thanks

Title: Re: INVTXN Table
Post by aricon on 04/06/04 at 11:48:42

You can get a list of these if you go to IN-B and bring up an item, then go to the Purch UoM field and press F1.