Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARUSERSORT


                            ARUSERSORT FILE

This table contains user sort data entered from AR42 Transaction Entry.  This
table is deleted  when a transaction (invoice, debit memo, or credit memo) is
released.

REFERENCED BY

ARLL.1

UPDATED BY

AR42.1    AR42.2    AR42.7    AR43.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

USS-COMPANY            Numeric 4                                 AR42.2
Element: Company       The number representing an AR company.

USS-TRANS-TYPE         Alpha 1                                   AR42.2
Element: Trans Type    The transaction type.  Valid valus are:

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice
                       M = Mixed
                       emo

USS-INVOICE            Alpha 22                                  AR42.2
Element: Invoice       Used to identify the invoice, credit
                       memo, or debit memo.

USS-PAYMENT-SEQ        Numeric 6
Element: Seq Number    Payment Sequence. This is the generated
                       sequence number to separate individual
                       invoice, credit memo, or debit memo
                       payment requirements.

USS-SORT-1             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 1        User Sort 1 value.

USS-SORT-2             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 2        User Sort 2 value.

USS-SORT-3             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 3        User Sort 3 value.

USS-SORT-4             Alpha 32  (Lower Case)                    AR42.2
Element: Sort 4        User Sort 4 value.

                         ARUSERSORT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

USSSET1   COMPANY                                                AR42.1  AR42.2
          TRANS-TYPE                                             AR42.7  AR43.1
          INVOICE                                                ARLL.1
          PAYMENT-SEQ