ARXIND

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.
UPDATED BY
AR12.1 AR12.2 ARLL.1 CB06.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARX-COMPANY
Element: Company		Numeric 4
The number representing an AR company.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-CUSTOMER
Element: Customer		Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-NAT-COMPANY
Element: Company		Numeric 4
The national account company.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-NAT-CUSTOMER
Element: Customer		Alpha 9 (Right Justified)
The national account customer.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-TRANS-TYPE
Element: Trans Type		Alpha 1
The related transaction type. Valid values are: C = Credit Mem D = Debit Memo I = Invoice
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-INVOICE
Element: Invoice		Alpha 22
Used to identify the related invoice, debit memo, or credit memo.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-PAYMENT-SEQ
Element: Seq Number		Numeric 6
The payment sequence number of the related transaciont. This is the generated sequence number to separate individual invoic, credit memo, or debit memo payment requirements.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-INDEX-NBR
Element: Index Nbr		Numeric 1
This number represents the indexed access method to the related transaction.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-NAT-FLAG
Element: Nat Flag		Alpha 1
This field incdicates the national account affiliation.
AR12.1 AR12.2
ARLL.1 CB06.2
ARX-SORT-FIELD
Element: Sort Field		Alpha 32 (Lower Case)
The user sort data value.
AR12.1 AR12.2
ARLL.1 CB06.2


ARXIND FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARXSET1 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
AR12.1 AR12.2
ARLL.1 CB06.2
ARXSET10 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =1
AndNAT-FLAG ="I"
ARXSET11 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =2
AndNAT-FLAG ="I"
ARXSET12 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =3
AndNAT-FLAG ="I"
ARXSET13 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =4
AndNAT-FLAG ="I"
ARXSET2 COMPANY
CUSTOMER
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =1
ARXSET3 COMPANY
CUSTOMER
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =2
ARXSET4 COMPANY
CUSTOMER
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =3
ARXSET5 COMPANY
CUSTOMER
SORT-FIELD
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =4
ARXSET6 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =1
AndNAT-FLAG !=Spaces
ARXSET7 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =2
AndNAT-FLAG !=Spaces
ARXSET8 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =3
AndNAT-FLAG !=Spaces
ARXSET9 NAT-COMPANY
NAT-CUSTOMER
SORT-FIELD
COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
INDEX-NBR
Subset
WhereINDEX-NBR =4
AndNAT-FLAG !=Spaces

File created: Thu Jun 09 02:09:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.