Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARXIND


                              ARXIND FILE

UPDATED BY

AR112     AR115     AR12.1    AR12.2    AR129     AR130
AR131     AR135     AR137     AR180     AR190     AR20.1
AR21.1    AR21.2    AR21.3    AR29.3    AR30.1    AR30.2
AR30.3    AR30.4    AR30.8    AR31.5    AR31.6    AR35.1
AR35.2    AR37.1    AR37.2    AR37.3    AR37.4    AR37.5
AR37.6    AR37.7    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR48.3    AR502     AR504     AR560
AR82.1    CB06.2    DT150     DT170     DT180     DT181
DT45.1    DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARX-COMPANY            Numeric 4                                 AR112   AR115
Element: Company       The company number represents an          AR12.1  AR12.2
                       established company and is entered on     AR129   AR130
                       all function codes.                       AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-CUSTOMER           Alpha 9  (Right Justified)                AR112   AR115
Element: Customer NumbeThis field contains the number that       AR12.1  AR12.2
                       represents a customer.                    AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-NAT-COMPANY        Numeric 4                                 AR112   AR115
Element: Company                                                 AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-NAT-CUSTOMER       Alpha 9  (Right Justified)                AR112   AR115
Element: Customer Number                                         AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-TRANS-TYPE         Alpha 1                                   AR112   AR115
Element: Transaction TyDetermines if amounts or units are        AR12.1  AR12.2
                       processed in each transaction.            AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-INVOICE            Alpha 22                                  AR112   AR115
Element: Invoice NumberUsed to identify the invoice.             AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-PAYMENT-SEQ        Numeric 6                                 AR112   AR115
Record Sequence                                                  AR12.1  AR12.2
Number                                                           AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-INDEX-NBR          Numeric 1                                 AR112   AR115
Element: Index Nbr                                               AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-NAT-FLAG           Alpha 1                                   AR112   AR115
Element: Nat Flag                                                AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

ARX-SORT-FIELD         Alpha 32  (Lower Case)                    AR112   AR115
Element: Sort Field                                              AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

                         ARXIND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARXSET1   COMPANY                                                AR112   AR115
          TRANS-TYPE                                             AR12.1  AR12.2
          INVOICE                                                AR129   AR130
          PAYMENT-SEQ                                            AR131   AR135
          INDEX-NBR                                              AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 ...

ARXSET10  NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR = 1                      AR30.3
          SORT-FIELD    And   NAT-FLAG  = "I"
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET11  NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR = 2                      AR30.3
          SORT-FIELD    And   NAT-FLAG  = "I"
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET12  NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR = 3                      AR30.3
          SORT-FIELD    And   NAT-FLAG  = "I"
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET13  NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR = 4                      AR30.3
          SORT-FIELD    And   NAT-FLAG  = "I"
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET2   COMPANY       Subset                                   AR30.1  AR30.2
          CUSTOMER      Where INDEX-NBR = 1                      AR30.3
          SORT-FIELD
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET3   COMPANY       Subset                                   AR30.1  AR30.2
          CUSTOMER      Where INDEX-NBR = 2                      AR30.3
          SORT-FIELD
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET4   COMPANY       Subset                                   AR30.1  AR30.2
          CUSTOMER      Where INDEX-NBR = 3                      AR30.3
          SORT-FIELD
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET5   COMPANY       Subset                                   AR30.1  AR30.2
          CUSTOMER      Where INDEX-NBR = 4                      AR30.3
          SORT-FIELD
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET6   NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR =  1                     AR30.3
          SORT-FIELD    And   NAT-FLAG  != Spaces
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET7   NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR =  2                     AR30.3
          SORT-FIELD    And   NAT-FLAG  != Spaces
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET8   NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR =  3                     AR30.3
          SORT-FIELD    And   NAT-FLAG  != Spaces
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR

ARXSET9   NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where INDEX-NBR =  4                     AR30.3
          SORT-FIELD    And   NAT-FLAG  != Spaces
          COMPANY
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          INDEX-NBR