Tables definition

jherrando

Hi,

Where can I found documentation about what is each table in Attain's 3.60 database ?

I want to create P.O.s from a web application, what tables do I need to fill ?


TIA

eromein

ouch...

Don't think it worls like this

You will have to speak to somebody who knows Navision.

FabriceG

I don't know a documentation about this.
If you want to know all the table you need for this operation. Use code coverage and made a transaction in navision. This tools match all table, form, codeunit etc used for the transaction.
I hope it's a good answer.

Timo_Lässer

IMHO it is enough, if you "simulate" users input.

What does a user do if he creates an order?

1. He press F3

   PurchOrder.INIT;
   

2. He press enter to leave the primary key field so Navision will fill the Order No.

   PurchOrder."Document Type" := PurchOrder."Document Type"::Order;
   PurchOrder."No." := '';  // leave it blank so Navision will fill this field
   PurchOrder.INSERT(TRUE);
   

3. He enters the Vendor No.

   PurchOrder.VALIDATE("Buy-from Vendor No.",MyNewValue)
   

4. He fills some other fields in the Header

   PurchOrder.VALIDATE(TheOtherField),MyNewOtherValue)
   

5. He goes to the Purchase Lines (Here you must initialise the Primary Key fields by yourself)

   PurchLine.INIT;
   PurchLine."Document Type" := PurchOrder."Document Type";
   PurchLine."Document No." := PurchOrder."No.";
   

6. He enters the type

   PurchLine.VALIDATE(Type,PurchLine.Type::Item);
   

7. He enters the Item No.

   PurchLine.VALIDATE("No.",MyNewItemNo);
   

8. He enters the quantity

   PurchLine.VALIDATE(Quantity,MyNewQuantity);
   

9. He enters some other fields

   PurchLine.VALIDATE(MyOtherField,MyNewOtherValue);
   

10. He leave the line and inserts the record

    PurchLine.INSERT(TRUE);
    

As you can see, I simulate the users input with "INIT", "VALIDATE" and "INSERT(TRUE)"