 |
Lawson Insight Technical Documentation |
|
ARXIND FILE
UPDATED BY
AR115 AR12.1 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 AR115 AR12.1
Company The company number represents an AR129 AR130
established company and is entered on AR131 AR135
all function codes. 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) AR115 AR12.1
Customer Number This field contains the number that AR129 AR130
represents a customer. 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 AR115 AR12.1
Nat Company 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) AR115 AR12.1
Nat 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-TRANS-TYPE Alpha 1 AR115 AR12.1
Transaction Type Determines if amounts or units are AR129 AR130
processed in each transaction. 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 AR115 AR12.1
Invoice Number Used to identify the invoice. 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 AR115 AR12.1
Payment Seq Payment Sequence. This is the generated AR129 AR130
sequence number to separate individual AR131 AR135
invoice payment requirements. 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 AR115 AR12.1
Index Nbr 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 AR115 AR12.1
Nat Flag 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) AR115 AR12.1
Sort Field 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 AR115 AR12.1
TRANS-TYPE AR129 AR130
INVOICE AR131 AR135
PAYMENT-SEQ AR137 AR180
INDEX-NBR 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
...
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
|