Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AROPIVOT


                             AROPIVOT FILE

REFERENCED BY

AR72.1

UPDATED BY

AR112     AR115     AR12.1    AR12.2    AR129     AR130
AR131     AR135     AR137     AR180     AR190     AR20.1
AR21.1    AR21.2    AR21.3    AR29.3    AR30.1    AR30.2
AR30.3    AR30.4    AR30.8    AR31.5    AR31.6    AR35.1
AR35.2    AR37.1    AR37.2    AR37.3    AR37.4    AR37.5
AR37.6    AR37.7    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR48.3    AR502     AR504     AR560
AR82.1    CB06.2    DT150     DT170     DT180     DT181
DT45.1    DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PVT-NAT-COMPANY        Numeric 4                                 AR112   AR115
Element: Company                                                 AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-NAT-CUSTOMER       Alpha 9  (Right Justified)                AR112   AR115
Element: Customer Number                                         AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-COMPANY            Numeric 4                                 AR112   AR115
Element: Company       The company number represents an          AR12.1  AR12.2
                       established company and is entered on     AR129   AR130
                       all function codes.                       AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-CUSTOMER           Alpha 9  (Right Justified)                AR112   AR115
Element: Customer NumbeThis field contains the number that       AR12.1  AR12.2
                       represents a customer.                    AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-CUST-PO-NBR        Alpha 22                                  AR112   AR115
Element: Customer P.O. Number                                    AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-TRANS-TYPE         Alpha 1                                   AR112   AR115
Element: Transaction TyDetermines if amounts or units are        AR12.1  AR12.2
                       processed in each 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.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-INVOICE            Alpha 22                                  AR112   AR115
Element: Invoice NumberUsed to identify the invoice.             AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-TRANS-DATE         Numeric 8  (yyyymmdd)                     AR112   AR115
Element: 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.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-DUE-DATE           Numeric 8  (yyyymmdd)                     AR112   AR115
Element: Date          The 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.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-DISC-DATE          Numeric 8  (yyyymmdd) Occurs 3 Times      AR112   AR115
Element: 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.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-DISC-PCT           Percent 7.5  (Percent) Occurs 3 Times     AR112   AR115
Element: Discount Percent                                        AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-PROCESS-LEVEL      Alpha 5                                   AR112   AR115
Element: Process Level This field contains the process level,    AR12.1  AR12.2
                       which is the reporting hierarchy below    AR129   AR130
                       company.                                  AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-ACTIVITY           Alpha 15                                  AR112   AR115
Element: Activity      Activities are the processes or           AR12.1  AR12.2
                       procedures that produce work. Cost        AR129   AR130
                       objects (products, services, customers,   AR131   AR135
                       and so on) are the reasons for            AR137   AR180
                       performing the activity.                  AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-BASE-AMT           Signed 15.2                               AR112   AR115
Element: Base Amount   This is the amount of the transaction in  AR12.1  AR12.2
                       the company base amount.                  AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-TRAN-AMT           Signed 15.2                               AR112   AR115
Element: Adj 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.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-OPEN-BASE          Signed 15.2                               AR12.1  AR12.2
Element: Open Base                                               AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR37.1  AR37.2
                                                                 AR37.3  AR37.4
                                                                 AR37.5  AR37.6
                                                                 AR37.7  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 CB06.2  DT45.1
                                                                 DT92.1

PVT-OPEN-TRAN          Signed 15.2                               AR12.1  AR12.2
Element: Open Tran                                               AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR37.1  AR37.2
                                                                 AR37.3  AR37.4
                                                                 AR37.5  AR37.6
                                                                 AR37.7  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 CB06.2  DT45.1
                                                                 DT92.1

PVT-SORT-AMOUNT        Numeric 17                                AR112   AR115
Element: Sort Amount                                             AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-TRANS-USER1        Alpha 10                                  AR112   AR115
Element: Cust User1                                              AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-XREF-TYPE          Alpha 1                                   AR112   AR115
Element: Xref Type                                               AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-XREF-NBR           Alpha 22                                  AR112   AR115
Element: Xref Nbr                                                AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-PAYMENT-SEQ        Numeric 6                                 AR112   AR115
Record Sequence                                                  AR12.1  AR12.2
Number                                                           AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-ORIG-CURRENCY      Alpha 5                                   AR112   AR115
To Company Base                                                  AR12.1  AR12.2
Currency                                                         AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-ORIG-ND            Numeric 1                                 AR112   AR115
Account Currency                                                 AR12.1  AR12.2
Code                                                             AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-ORIG-RATE          Signed 12.6                               AR112   AR115
Element: Account Rate                                            AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-CURR-MUDV          Alpha 1                                   AR112   AR115
Currency                                                         AR12.1  AR12.2
Multiply/Divide                                                  AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-SUM-LINE           Alpha 1                                   AR112   AR115
Element: All Flag      N = No line summarization                 AR12.1  AR12.2
                       Y = Summarize lines                       AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-NAT-FLAG           Alpha 1                                   AR112   AR115
Element: Nat Flag      N = Invoiced customer flag                AR12.1  AR12.2
                       I = National account customer flag        AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-APPLIED-SEQ        Numeric 5                                 AR112   AR115
Element: App Seq                                                 AR12.1  AR12.2
                                                                 AR129   AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-BANK-INST-CODE     Alpha 3                                   AR112   AR115
Element: Transaction CoA transaction code represents a type of   AR12.1  AR12.2
                       cash payment, bill of exchange payment,   AR129   AR130
                       or bank service transaction.              AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-BANK-INST-TYPE     Alpha 1                                   AR112   AR115
Transaction Code       This categorizes the type of bank         AR12.1  AR12.2
Type                   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.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

PVT-ALT-TYPE           Alpha 1                                   AR112   AR115
Element: Alt Type      I = Invoice                               AR12.1  AR12.2
                       C = Credit Memo                           AR129   AR130
                       D = Debit Memo                            AR131   AR135
                       M = Mixed signed lime items               AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR504   AR560
                                                                 AR82.1  CB06.2
                                                                 DT150   DT170
                                                                 DT180   DT181
                                                                 DT45.1  DT92.1

                         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  AR29.3
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR31.5
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 ...

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

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

PVTSET12  NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR30.3  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"                     AR30.2  AR30.3
          ACTIVITY                                               AR72.1
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

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

PVTSET2   NAT-COMPANY                                            AR131   AR30.1
          NAT-CUSTOMER                                           AR30.2  AR30.3
          DUE-DATE                                               AR72.1
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

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

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

PVTSET5   NAT-COMPANY                                            AR30.1  AR30.2
          NAT-CUSTOMER                                           AR30.3  AR72.1
          TRANS-USER1
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

PVTSET6   NAT-COMPANY                                            AR30.1  AR30.2
          NAT-CUSTOMER                                           AR30.3  AR72.1
          ACTIVITY
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          COMPANY
          CUSTOMER

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

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

PVTSET9   NAT-COMPANY   Subset                                   AR30.1  AR30.2
          NAT-CUSTOMER  Where NAT-FLAG = "I"                     AR30.3  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