Field "Source Type" in table "Reservation Ent

Nizar

Hello,

I have migrated my database from navision version 2.60 to 4SP1.
In navision 4SP1, values of field "Source Type" in table "Reservation Entry" is different in the version 2.60.
Exemple : In version 2.60, when the "Source Type" in table "Reservation Entry" is "Sales" , this value in version 4SP1 is 37.

I want to khnow all values of field "Source Type" in 4SP1.

Can you help me.

Thank you.

Mbad

The migration should work since the field was changed from option to tableno(your reservation was from a sales line, hence the (table)37 in the entry).

I assume you ran report 104026 when you upgraded?

Nizar

Thanks for your reply,

Yes I run the report 104026 where upgrated, but now i want to khow the values of the tableno of field "Source type" to do the correspondence with the option of the versionb 2.60

kine

It is simple - in NF 2.60 are options like (I do not know exact english names, I have just Czech DB...):

0=
1=Sales
2=Requisition Line
3=Purchase
4=Item Journal
5=BOM Journal
6=item Ledger Entry
7=Production Order Line
8=Production Order Component

As you can see, each option can be assigned to one table in NAV.

1 = Sales Line (tab 37)
2 = Requisition Line (tab 246)
3 = Purchase Line (tab 39)
4 = Item Journal Line (tab 83)
5 = BOM Journal Line (tab 89)
6 = Item Ledger Entry (tab 32)
7 = Prod. Order Line (tab 5406)
8 = Prod. Order Component (tab 5407)

It is simple, doesn't it? 8)