Differences between ledger tables and other tables

anhu

Hi all,
i want to know exactly how Navision (version SQL) stores his data in his database during insertion or updating . So i want to know what's the difference between datas which are stored in ledger table ,s master table, subsidiary tables, register tables, journal document, document history.
Thank you for your help

kine

There is no difference in inserting and updating data. There is only difference in "meaning" of this data. But there are some common design things:

Ledger entries have one PK field, type Integer (or BigInteger), can be with autoincrement. FlowFields and Calcsums are common...

Register entries have one PK field, type Integer (or BigInteger), can be with autoincrement. Other fields are connected to the Ledger entries PK. No flowfields, no Calcsums...

Master table can have composite PK (Document type, Document No. for example) - Can have many FlowFields and Calcsums fields (but better is to have no calcsums on this tables)

Subsidiary table have composite PK including PK from Master table, extended with Line No. field (Integer). Can have many FlowFields and Calcsums fields (but better is to have no calcsums on this tables)

Journal lines have PK including Template name, Batch name and Line No. Very few flowfields and Calcsums fields in keys.