Tables definition

jherrando
jherrando Member Posts: 2
edited 2004-02-11 in Navision Attain
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

Comments

  • eromein
    eromein Member Posts: 589
    ouch...

    Don't think it worls like this :(

    You will have to speak to somebody who knows Navision.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • FabriceG
    FabriceG Member Posts: 12
    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
    Timo_Lässer Member Posts: 481
    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)"
    Timo Lässer
    Microsoft Dynamics NAV Developer since 1997
    MSDynamics.de - German Microsoft Dynamics Community - member of [clip]

Categories