Is there a table that holds the IC Transaction types?

[stevep1958]

thread631-1700452

I am writing an In Out report from the ICHIST file. I want to reverse the sign when appropriate to make generally positive numbers so that PO receipts are positive and shipments are also positive. I am not trying to sum them to get on hand.

The attached thread give the text of the codes like 4=Shipment but I was hoping to join to the Accpac table (if present) to do this. Hopefully, the table also contains the sign to increase or decrease inventory. My data base does not have an example of every transaction type but for the ones where there is a transaction, I see the App that it came from which may or may not also be stored in this table.

I am on v5.5A, new to Accpac since January 2014. This is a great forum.

 

[ettienne]

No there is no table.
The AOM gives this list (which could change for 2014):

TRANSTYPE 13 Integer Transaction Type E A List: 20 entries
1 = Receipt
2 = Receipt Adjustment
3 = Receipt Return
4 = Shipment
5 = Shipment Return
6 = Adjustment Quantity Increase
7 = Adjustment Quantity Decrease
8 = Adjustment Cost Increase
9 = Adjustment Cost Decrease
10 = Adjustment Both Increase
11 = Adjustment Both Decrease
12 = Stock Transfer From
13 = Stock Transfer To
14 = Master Item Assembly
15 = Component Item Assembly
16 = Invoice
17 = Credit Note
18 = Debit Note
19 = Shipment Adjustment
20 = Internal Usage