Lawson Insight Technical Documentation |
|
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
|