Lawson Insight Technical Documentation |
|
ARXIND
ARXIND FILE
This file contains reference records relating to open items records with the
same user sort field value. These records are used for cash application and
credit management inquiry sorting purposes.
REFERENCED BY
AR72.1
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.8
AR32.1 AR33.1 AR33.3 AR33.5 AR33.6 AR34.1
AR35.1 AR35.2 AR37.1 AR37.2 AR37.3 AR37.4
AR37.5 AR37.6 AR37.7 AR38.1 AR38.2 AR38.3
AR39.1 AR39.2 AR42.1 AR42.2 AR42.6 AR42.7
AR43.1 AR44.3 AR48.3 AR502 AR504 AR510
AR560 AR80.1 AR80.2 AR82.1 ARLL.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 number representing an AR 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.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-CUSTOMER Alpha 9 (Right Justified) AR112 AR115
Element: Customer This 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.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-NAT-COMPANY Numeric 4 AR112 AR115
Element: Company The national account 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.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-NAT-CUSTOMER Alpha 9 (Right Justified) AR112 AR115
Element: Customer The national account customer. AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-TRANS-TYPE Alpha 1 AR112 AR115
Element: Trans Type The related transaction type. Valid AR12.1 AR12.2
values are: AR129 AR130
AR131 AR135
C = Credit Mem AR137 AR180
D = Debit Memo AR190 AR20.1
I = Invoice AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-INVOICE Alpha 22 AR112 AR115
Element: Invoice Used to identify the related invoice, AR12.1 AR12.2
debit memo, or credit memo. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-PAYMENT-SEQ Numeric 6 AR112 AR115
Element: Seq Number The payment sequence number of the AR12.1 AR12.2
related transaciont. This is the AR129 AR130
generated sequence number to separate AR131 AR135
individual invoic, credit memo, or debit AR137 AR180
memo payment requirements. AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-INDEX-NBR Numeric 1 AR112 AR115
Element: Index Nbr This number represents the indexed AR12.1 AR12.2
access method to the related AR129 AR130
transaction. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-NAT-FLAG Alpha 1 AR112 AR115
Element: Nat Flag This field incdicates the national AR12.1 AR12.2
account affiliation. AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 CB06.2
DT150 DT170
DT180 DT181
DT45.1 DT92.1
ARX-SORT-FIELD Alpha 32 (Lower Case) AR112 AR115
Element: Sort Field The user sort data value. AR12.1 AR12.2
AR129 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR29.3
AR30.1 AR30.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR504 AR510
AR560 AR80.1
AR80.2 AR82.1
ARLL.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.8
AR32.1 AR33.1
AR33.3 AR33.5
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
...
ARXSET10 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 1 AR72.1
SORT-FIELD And NAT-FLAG = "I"
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET11 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 2 AR72.1
SORT-FIELD And NAT-FLAG = "I"
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET12 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 3 AR72.1
SORT-FIELD And NAT-FLAG = "I"
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET13 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 4 AR72.1
SORT-FIELD And NAT-FLAG = "I"
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET2 COMPANY Subset AR30.1 AR33.1
CUSTOMER Where INDEX-NBR = 1 AR39.1 AR72.1
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET3 COMPANY Subset AR30.1 AR33.1
CUSTOMER Where INDEX-NBR = 2 AR39.1 AR72.1
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET4 COMPANY Subset AR30.1 AR33.1
CUSTOMER Where INDEX-NBR = 3 AR39.1 AR72.1
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET5 COMPANY Subset AR30.1 AR33.1
CUSTOMER Where INDEX-NBR = 4 AR39.1 AR72.1
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET6 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 1 AR39.1 AR72.1
SORT-FIELD And NAT-FLAG != Spaces
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET7 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 2 AR39.1 AR72.1
SORT-FIELD And NAT-FLAG != Spaces
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET8 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 3 AR39.1 AR72.1
SORT-FIELD And NAT-FLAG != Spaces
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
ARXSET9 NAT-COMPANY Subset AR30.1 AR33.1
NAT-CUSTOMER Where INDEX-NBR = 4 AR39.1 AR72.1
SORT-FIELD And NAT-FLAG != Spaces
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
|