Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AROPIVOT


                             AROPIVOT FILE

This file contains national account transaction records that reference open
iten records.  National account transaction records are used for cash
application and credit management sorting purposes.

REFERENCED BY

AR570     AR575     AR580     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     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

PVT-NAT-COMPANY        Numeric 4                                 AR112   AR115
Element: Company       The national account number               AR12.1  AR12.2
                       representing an AR company.               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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-NAT-CUSTOMER       Alpha 9  (Right Justified)                AR112   AR115
Element: Customer      The national account 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.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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-CUST-PO-NBR        Alpha 22                                  AR112   AR115
Element: Cust Po Nbr   The purchase order number of the related  AR12.1  AR12.2
                       transaction.                              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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-TRANS-TYPE         Alpha 1                                   AR112   AR115
Element: Trans Type    The transaction type of the related       AR12.1  AR12.2
                       transaction.                              AR129   AR130
                       C = Credit Memo                           AR131   AR135
                       D = Debit Memo                            AR137   AR180
                       I = Invoice                               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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-INVOICE            Alpha 22                                  AR112   AR115
Element: Invoice       Used 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.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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-TRANS-DATE         Numeric 8  (yyyymmdd)                     AR112   AR115
Element: Trans Date    The date of the related transaction.      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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-DUE-DATE           Numeric 8  (yyyymmdd)                     AR112   AR115
Element: Due Date      The related transaction due date.         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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-DISC-DATE          Numeric 8  (yyyymmdd) Occurs 3 Times      AR112   AR115
Element: Date          The related transaction discount date.    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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-DISC-PCT           Percent 7.5  (Percent) Occurs 3 Times     AR112   AR115
Element: Disc Pct      The related transaction discount          AR12.1  AR12.2
                       percent.                                  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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-PROCESS-LEVEL      Alpha 5                                   AR112   AR115
Element: Process Level This field contains the process level,    AR12.1  AR12.2
                       or the related transaction.               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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-ACTIVITY           Alpha 15                                  AR112   AR115
Element: Activity      The Activity value of the related         AR12.1  AR12.2
                       transaction.                              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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-BASE-AMT           Signed 18.2                               AR112   AR115
Element: Intl Amt      This is the amount of the related         AR12.1  AR12.2
                       transaction in the company base amount.   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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-TRAN-AMT           Signed 18.2                               AR112   AR115
Element: Intl Amt      The amount of the related transaction in  AR12.1  AR12.2
                       transaction currency.                     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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-OPEN-BASE          Signed 18.2                               AR12.1  AR12.2
Element: Intl Amt      The unapplied amount of the related       AR20.1  AR21.1
                       transaction in company base currency.     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
                                                                 AR80.1  AR80.2
                                                                 CB06.2  DT45.1
                                                                 DT92.1

PVT-OPEN-TRAN          Signed 18.2                               AR12.1  AR12.2
Element: Intl Amt      The unapplied amount of the related       AR20.1  AR21.1
                       transaction in transaction currency.      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
                                                                 AR80.1  AR80.2
                                                                 CB06.2  DT45.1
                                                                 DT92.1

PVT-SORT-AMOUNT        Numeric 17                                AR112   AR115
Element: Sort Amount   The unapplied amount of the related       AR12.1  AR12.2
                       transaction used for sorting purposes.    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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-TRANS-USER1        Alpha 10                                  AR112   AR115
Element: Trans User1   The related transaction's User 1 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.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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-XREF-TYPE          Alpha 1                                   AR112   AR115
Element: Xref Type     The related transaction's cross           AR12.1  AR12.2
                       reference type field.                     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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-XREF-NBR           Alpha 22                                  AR112   AR115
Element: Xref Nbr      The related transaction's cross           AR12.1  AR12.2
                       reference number field.                   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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-PAYMENT-SEQ        Numeric 6                                 AR112   AR115
Element: Seq Number    This is the related transaction's         AR12.1  AR12.2
                       generated sequence number to  separate    AR129   AR130
                       individual invoice payment requirements.  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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-ORIG-CURRENCY      Alpha 5                                   AR112   AR115
Element: Orig Currency The related transaction's currency.       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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-ORIG-ND            Numeric 1                                 AR112   AR115
Element: Acct Nd       The related transaction's currency        AR12.1  AR12.2
                       decimal indicator.                        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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-ORIG-RATE          Signed 14.7                               AR112   AR115
Element: Orig Rate     The related transaction's currency        AR12.1  AR12.2
                       exchange rate.                            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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-CURR-MUDV          Alpha 1                                   AR112   AR115
Element: Curr Mudv     The related transaction's currency        AR12.1  AR12.2
                       multiply or divide indicator.             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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-SUM-LINE           Alpha 1                                   AR112   AR115
Element: Sum Line      The related transaction's sum line        AR12.1  AR12.2
                       indicator.  Valid values are:             AR129   AR130
                       N = No line summarization                 AR131   AR135
                       Y = Summarize lines                       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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-NAT-FLAG           Alpha 1                                   AR112   AR115
Element: Nat Flag      The related customer's national account   AR12.1  AR12.2
                       orientation.  Valid values are:           AR129   AR130
                       N = Invoiced customer flag                AR131   AR135
                       I = National account customer flag        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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-APPLIED-SEQ        Numeric 7                                 AR112   AR115
Element: Applied Seq   The related transction's applied          AR12.1  AR12.2
                       sequence number.                          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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-BANK-INST-CODE     Alpha 3                                   AR112   AR115
Element: Bank Inst CodeThe related transaction's payment code    AR12.1  AR12.2
                       representing a type of cash  payment      AR129   AR130
                       (with atributes for either receiving      AR131   AR135
                       AP payments, or                           AR137   AR180
                       creating EFT payments), bill of           AR190   AR20.1
                       exchange payment, or bank service         AR21.1  AR21.2
                       transaction.                              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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-BANK-INST-TYPE     Alpha 1                                   AR112   AR115
Element: Bank Inst TypeThis categorizes the type of bank         AR12.1  AR12.2
                       instrument.                               AR129   AR130
                       C = Cash payment                          AR131   AR135
                       D = Bill of Exchange                      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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-ALT-TYPE           Alpha 1                                   AR112   AR115
Element: Alt Type      The related transaction's alternate       AR12.1  AR12.2
                       transaction type used to access the       AR129   AR130
                       transaction header record.                AR131   AR135
                       I = Invoice                               AR137   AR180
                       C = Credit Memo                           AR190   AR20.1
                       D = Debit Memo                            AR21.1  AR21.2
                       M = Mixed signed lime items               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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-ORIG-DISC-AMT      Signed 18.2 Occurs 3 Times                AR112   AR115
Element: Intl Amt                                                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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-MAJ-CLASS          Alpha 4                                   AR112   AR115
Element: Major Class                                             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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-MIN-CLASS          Alpha 4
Element: Minor Class

PVT-RISK-CD            Alpha 1                                   AR112   AR115
Element: Risk Cd                                                 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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-SALESMAN           Numeric 4                                 AR112   AR115
Element: Salesman      This field contains the code that         AR12.1  AR12.2
                       represents the primary salesrep of this   AR129   AR130
                       line.  If left blank, this  defaults      AR131   AR135
                       from the order header.                    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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-TERMS-CD           Alpha 5                                   AR112   AR115
Element: Term Code     A user-defined code representing a        AR12.1  AR12.2
                       method of determining invoice due and     AR129   AR130
                       discount dates.                           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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

PVT-AC-CUSTOMER-ID     Alpha 5                                   AR112   AR115
Element: Ac Customer Id                                          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   AR560
                                                                 AR80.1  AR80.2
                                                                 AR82.1  ARLL.1
                                                                 CB06.2  DT150
                                                                 DT170   DT180
                                                                 DT181   DT45.1
                                                                 DT92.1

                         AROPIVOT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PVTSET1   NAT-COMPANY                                            AR112   AR115
          NAT-CUSTOMER                                           AR12.1  AR12.2
          TRANS-TYPE                                             AR129   AR130
          INVOICE                                                AR131   AR135
          PAYMENT-SEQ                                            AR137   AR180
          COMPANY                                                AR190   AR20.1
          CUSTOMER                                               AR21.1  AR21.2
                                                                 AR21.3  AR21.4
                                                                 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
                                                                 ...

PVTSET10  NAT-COMPANY   KeyChange, Subset                        AR30.1  AR33.1
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR72.1
          SORT-AMOUNT*
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET11  NAT-COMPANY   Subset                                   AR30.1  AR33.1
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR72.1
          PROCESS-LEVEL
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET12  NAT-COMPANY   Subset                                   AR30.1  AR33.1
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR72.1
          TRANS-USER1
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET13  NAT-COMPANY   Subset                                   AR12.2  AR30.1
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR33.1  AR72.1
          ACTIVITY
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET14  NAT-COMPANY   Subset                                   AR30.1  AR33.1
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR72.1
          CUST-PO-NBR
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET2   NAT-COMPANY                                            AR130   AR131
          NAT-CUSTOMER                                           AR30.1  AR30.8
          DUE-DATE                                               AR33.1  AR39.1
          TRANS-TYPE                                             AR72.1
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET3   NAT-COMPANY   KeyChange                                AR30.1  AR33.1
          NAT-CUSTOMER                                           AR39.1  AR72.1
          SORT-AMOUNT*
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET4   NAT-COMPANY                                            AR30.1  AR33.1
          NAT-CUSTOMER                                           AR39.1  AR72.1
          PROCESS-LEVEL
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET5   NAT-COMPANY                                            AR30.1  AR33.1
          NAT-CUSTOMER                                           AR39.1  AR72.1
          TRANS-USER1
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET6   NAT-COMPANY                                            AR30.1  AR33.1
          NAT-CUSTOMER                                           AR39.1  AR72.1
          ACTIVITY
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET7   NAT-COMPANY                                            AR30.1  AR33.1
          NAT-CUSTOMER                                           AR39.1  AR72.1
          CUST-PO-NBR
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET8   NAT-COMPANY   Subset                                   AR112   AR12.1
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR12.2  AR30.1
          TRANS-TYPE                                             AR33.1  AR72.1
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET9   NAT-COMPANY   Subset                                   AR30.1  AR33.1
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR72.1
          DUE-DATE
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

                         AROPIVOT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aroihdr        AROIHDR      Required

                            PVT-COMPANY           -> ARH-COMPANY
                            PVT-ALT-TYPE          -> ARH-TRANS-TYPE
                            PVT-INVOICE           -> ARH-INVOICE

Aroitems       AROITEMS     Required

                            PVT-COMPANY           -> ARO-COMPANY
                            PVT-TRANS-TYPE        -> ARO-TRANS-TYPE
                            PVT-INVOICE           -> ARO-INVOICE
                            PVT-PAYMENT-SEQ       -> ARO-PAYMENT-SEQ

Arsapplied     ARSAPPLIED   Not Required

                            PVT-COMPANY           -> ASG-COMPANY
                            PVT-TRANS-TYPE        -> ASG-TRANS-TYPE
                            PVT-INVOICE           -> ASG-INVOICE
                            PVT-PAYMENT-SEQ       -> ASG-PAYMENT-SEQ

Cbbankinst     CBBANKINST   Required

                            PVT-BANK-INST-CODE    -> CBI-BANK-INST-CODE

                         AROPIVOT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arapplied      ARAPPLIED

                            PVT-COMPANY           -> ARA-COMPANY
                            PVT-TRANS-TYPE        -> ARA-TRANS-TYPE
                            PVT-INVOICE           -> ARA-INVOICE
                            PVT-PAYMENT-SEQ       -> ARA-PAYMENT-SEQ
                                                     ARA-BATCH-NBR
                                                     ARA-APP-SEQ