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.  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       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

USS-TRANS-TYPE         Alpha 1                                   AR42.2
Element: Transaction TyDetermines if amounts or units are
                       processed in each transaction.
                       C = Credit memo
                       D = Debit memo
                       I = Invoice

USS-INVOICE            Alpha 22                                  AR42.2
Element: Invoice NumberUsed to identify the invoice.

USS-PAYMENT-SEQ        Numeric 6
Record Sequence        Payment Sequence. This is the generated
Number                 sequence number to separate individual
                       invoice payment requirements.


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

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

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

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

                         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