The Purchase Line table has a field in it called Type. This is a number which relates to the type of line, so if it was 4, the drop down in the RTC is Fixed Asset.
My external program is populating various elements of the XML file before is imported.
In order so that I can successfully post the imported invoice XML data, it needs to have the Type number populated, all I need to know is where in the CRONUS database does it tell you that Fixed Asset corresponds to the number 4 or Item corrsponds to 2 and so on.
This is more of a SQL question than a NAV question I think, just to be 100% clear I in no way want to have to edit the contents of the XML file once it’s reached NAV so I’m not sure creating an integer variable can help me. I’ll try and explain again …
The Purc_ Inv_ Line table contains
Type No_ Description
4 FA000010 Mercedes 300
2 700010 Wooden Door
And so on…
Other than the Purch_ Inv_ Line table, is there another table that contains these fields / anywhere else I can get this information in order to populate the XML file to be uploaded.
i.e. is there a table that tells Dynamics that FA000010 is an Fixed Asset because it has a Type of 4?