HelpPages

Home | Developer | Frames | Databases | Transaction tables

Transaction tables

    DATABASE - TABLES FOR SUPPORT OF TRANSACTION

    When setting up screens for transactions or movements, we can do it very easily through the use of screen movements. But for this to be able, we need a table of transaccines that must meet one requirement: must have a field to support the line number of the transaction and this must necessarily be called "N_LINE".
    Due to the structure of this system development, the index will default to the first field plus the N_LINE field. Furthermore, due to the nature of the tables of movement, there will normally be a date field. For all this is very typical (and this is the orientation of the utility of movements that is supported on this system) that the first field is the identifier (eg transaction number), the second field is the line number and third date.
    When the program AppDesigner detects the field N_LINE in the 2 nd, automatically adjusts the index, so that covers the first two fields, allowing within a transactional document, the lines remain in the same order they were created .