Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARACPIVOT


                             ARACPIVOT FILE

This table contains a record for each payment (ARPAYMENT) or transaction
(AROITEMS) record that has an Activity, Contract, or Activity Group value.

REFERENCED BY

AR296     AR91.1    AR257     AR55.1    BR450

UPDATED BY

AR115     AR124     AR129     AR13.1    AR13.2    AR130
AR131     AR135     AR137     AR180     AR190     AR196
AR198     AR20.1    AR21.1    AR21.2    AR21.3    AR24.1
AR28.1    AR28.2    AR29.1    AR29.2    AR29.3    AR30.1
AR30.2    AR30.8    AR300     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    AR45.1
AR48.3    AR502     AR503     AR504     AR506     AR525
AR560     AR570     AR575     AR580     AR80.1    AR80.2
AR800     AR82.1    ARLL.1    CB06.2    CB191     DT150
DT155     DT160     DT165     DT166     DT180     DT30.1
DT30.2    DT40.1    DT45.1    DT520     DT60.1    DT60.2
DT70.1    DT70.3    DT80.1    DT85.1    DT85.2    DT92.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CCP-COMPANY            Numeric 4                                 AR115   AR124
Element: Company       The AR company associated with the        AR129   AR13.1
                       payment record.                           AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-TRANS-TYPE         Alpha 1                                   AR115   AR124
Element: Trans Type    Determines the transaction type: Invoice  AR129   AR13.1
                       (I), Credit memo (I), Debit memo (D) or   AR13.2  AR130
                       Payment (P).                              AR131   AR135
                       I = Invoice                               AR137   AR180
                       C = Credit Memo                           AR190   AR196
                       D = Debit Memo                            AR198   AR20.1
                       P = Payment                               AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-BATCH-NBR          Numeric 6                                 AR115   AR124
Element: Batch Nbr     This identifies the batch the entered     AR129   AR13.1
                       invoices, debit memos, and credit memos   AR13.2  AR130
                       are a part of.                            AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-TRANSACTION        Alpha 22                                  AR115   AR124
Element: Transaction   The payment or transaction number.        AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-PAYMENT-SEQ        Numeric 6                                 AR115   AR124
Element: Seq Number    The unique payment or obligation          AR129   AR13.1
                       sequence number.                          AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-ACTIVITY           Alpha 15                                  AR115   AR124
Element: Activity      The activity associated with the          AR129   AR13.1
                       transaction or payment - interfaced from  AR13.2  AR130
                       AC/BR                                     AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-ACCT-CATEGORY      Alpha 5                                   AR115   AR129
Element: Acct Category The account category associated with the  AR130   AR131
                       transaction or payment - interfaced from  AR135   AR137
                       AC/BR                                     AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                       cost                                      AR30.8  AR300
                       revenue                                   AR32.1  AR33.1
                       accrual                                   AR33.3  AR33.5
                       pass thru                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-CONTRACT           Alpha 15                                  AR115   AR124
Element: Contract      The contract asociated with the           AR129   AR13.1
                       transaction or payment - interfaced from  AR13.2  AR130
                       AC/BR.                                    AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-ACTIVITY-GRP       Alpha 15                                  AR115   AR124
Element: Activity Grp  The aactivity group associated with the   AR129   AR13.1
                       transaction or payment - interfaced from  AR13.2  AR130
                       AC/BR.                                    AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-STATUS             Numeric 1                                 AR115   AR124
Element: Status        The status of the record in the           AR129   AR13.1
                       processing flow. Valid values are:        AR13.2  AR130
                                                                 AR131   AR135
                       1 = Released open item                    AR137   AR180
                       2 = Released assigned payment             AR190   AR196
                       7 = Fully applied                         AR198   AR20.1
                       8 = Closed                                AR21.1  AR21.2
                       9 = History                               AR21.3  AR24.1
                       0 = Unreleased payment                    AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-CUSTOMER           Alpha 9  (Right Justified)                AR115   AR124
Element: Customer      The customer associated with the          AR129   AR13.1
                       transacton or payment.                    AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-OPEN-TRAN          Signed 18.2                               AR13.1  AR13.2
Element: Intl Amt                                                AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  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
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

CCP-OPEN-BASE          Signed 18.2                               AR13.1  AR13.2
Element: Intl Amt                                                AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  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
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

CCP-SORT-AMOUNT        Numeric 17                                AR115   AR124
Element: Sort Amount                                             AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-PROCESS-LEVEL      Alpha 5                                   AR115   AR124
Element: Process Level This field contains the process level,    AR129   AR13.1
                       which is the reporting hierarchy below    AR13.2  AR130
                       company.                                  AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-ORIG-CURRENCY      Alpha 5                                   AR115   AR124
Element: Orig Currency This contains the original transaction    AR129   AR13.1
                       currency code.                            AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-ORIG-ND            Numeric 1                                 AR115   AR124
Element: Acct Nd       The number of decimals assigned to a      AR129   AR13.1
                       particular account as determined by the   AR13.2  AR130
                       account currency.                         AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-ORIG-RATE          Signed 14.7                               AR115   AR124
Element: Orig Rate                                               AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-CURR-MUDV          Alpha 1                                   AR115   AR124
Element: Curr Mudv                                               AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-SUM-LINE           Alpha 1                                   AR115   AR129
Element: Sum Line                                                AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-DISC-DATE          Numeric 8  (yyyymmdd) Occurs 3 Times      AR115   AR129
Element: Date          This field displays the system date       AR130   AR131
                       when this was created.                    AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-ORIG-DISC-AMT      Signed 18.2 Occurs 3 Times                AR115   AR129
Element: Intl Amt                                                AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-CUST-PO-NBR        Alpha 22                                  AR115   AR129
Element: Cust Po Nbr                                             AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-TRANS-DATE         Numeric 8  (yyyymmdd)                     AR115   AR124
Element: Tran Date                                               AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-XREF-TYPE          Alpha 1                                   AR115   AR129
Element: Xref Type                                               AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-XREF-NBR           Alpha 22                                  AR115   AR124
Element: Xref Nbr                                                AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-BANK-INST-CODE     Alpha 3                                   AR115   AR129
Element: Bank Inst CodeA transaction code represents a type of   AR130   AR131
                       cash payment, bill of exchange payment,   AR135   AR137
                       or bank service transaction.              AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-BANK-INST-TYPE     Alpha 1                                   AR115   AR129
Element: Bank Inst TypeThis categorizes the type of bank         AR130   AR131
                       instrument.                               AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-ALT-TYPE           Alpha 1                                   AR115   AR129
Element: Alt Type      M = Mixed signed transaction              AR130   AR131
                       I = Invoice                               AR135   AR137
                       C = Credit Memo                           AR180   AR190
                       D = Debit Memo                            AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-GL-DATE            Numeric 8  (yyyymmdd)                     AR115   AR124
Element: Gl Date       This field contains the general ledger    AR129   AR13.1
                       posting date.                             AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AR115   AR124
Element: Cancel Date   The cancellation date.                    AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-DISPUTE-SEQ        Numeric 3                                 AR115   AR129
Element: Dispute Seq                                             AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-REVALUE-FL         Alpha 1                                   AR115   AR129
Element: Revalue Fl                                              AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-TRANS-USER1        Alpha 10                                  AR115   AR129
Element: Trans User1                                             AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-ORIG-AMT           Signed 18.2                               AR115   AR124
Element: Intl Amt                                                AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-TRAN-AMT           Signed 18.2                               AR115   AR124
Element: Intl Amt                                                AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-DUE-DATE           Numeric 8  (yyyymmdd)                     AR115   AR124
Element: Date          This field displays the system date       AR129   AR13.1
                       when this was created.                    AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-GAINLOS-AMT        Signed 18.2                               AR115   AR129
Element: Intl Amt                                                AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-CURRENCY-CODE      Alpha 5                                   AR115   AR124
Element: Currency Code This field contains the company base      AR129   AR13.1
                       currency code established in Company      AR13.2  AR130
                       (GL10.1 ).                                AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-BASE-ND            Numeric 1                                 AR115   AR129
Element: Base Nd       The number of decimal positions defined   AR130   AR131
                       for the company base currency.            AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-ADJ-FL             Alpha 1                                   AR115   AR129
Element: Flag1                                                   AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-GROUP-RATE         Signed 14.7                               AR115   AR124
Element: Group Rate                                              AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-GROUP-MUDV         Alpha 1                                   AR115   AR124
Element: Group Mudv                                              AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.8
                                                                 AR300   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  AR45.1
                                                                 AR48.3  AR502
                                                                 AR503   AR504
                                                                 AR506   AR525
                                                                 ...

CCP-DISC-PCT           Percent 7.5  (Percent) Occurs 3 Times     AR115   AR129
Element: Disc Pct                                                AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

CCP-AC-CUSTOMER-ID     Alpha 5                                   AR115   AR129
Element: Ac Customer Id                                          AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR29.3  AR30.1
                                                                 AR30.8  AR300
                                                                 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
                                                                 AR45.1  AR48.3
                                                                 AR502   AR504
                                                                 AR506   AR525
                                                                 AR560   AR80.1
                                                                 AR80.2  AR800
                                                                 ARLL.1  CB06.2
                                                                 DT150

                         ARACPIVOT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CCPSET1   COMPANY                                                AR115   AR124
          TRANS-TYPE                                             AR129   AR13.1
          BATCH-NBR                                              AR13.2  AR130
          TRANSACTION                                            AR131   AR135
          PAYMENT-SEQ                                            AR137   AR180
                                                                 AR190   AR196
                                                                 AR198   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR28.2
                                                                 AR29.1  AR29.2
                                                                 AR29.3  AR296
                                                                 AR30.1  AR30.2
                                                                 AR30.8  AR300
                                                                 AR32.1  AR33.1
                                                                 ...

CCPSET10  CONTRACT      KeyChange
          DUE-DATE
          TRANS-TYPE
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET11  CONTRACT      KeyChange                                AR91.1
          DUE-DATE*
          TRANS-TYPE
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET12  ACTIVITY      KeyChange                                AR91.1
          DUE-DATE*
          TRANS-TYPE
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET13  ACTIVITY-GRP  KeyChange                                AR91.1
          DUE-DATE*
          TRANS-TYPE
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET2   ACTIVITY      KeyChange, Subset                        AR257   AR32.1
          DUE-DATE      Where((TRANS-TYPE = "I"                  AR55.1
          TRANS-TYPE    Or     TRANS-TYPE = "C"
          BATCH-NBR     Or     TRANS-TYPE = "D" )
          TRANSACTION   And   (STATUS     = 1 ))
          PAYMENT-SEQ   Or   ((TRANS-TYPE = "P" )
          COMPANY       And   (STATUS     = Zeroes
                        Or     STATUS     = 2 ))

CCPSET3   ACTIVITY-GRP  KeyChange, Subset                        AR257   AR32.1
          DUE-DATE      Where((TRANS-TYPE = "I"                  AR55.1
          TRANS-TYPE    Or     TRANS-TYPE = "C"
          BATCH-NBR     Or     TRANS-TYPE = "D" )
          TRANSACTION   And   (STATUS     = 1 ))
          PAYMENT-SEQ   Or   ((TRANS-TYPE = "P" )
          COMPANY       And   (STATUS     = Zeroes
                        Or     STATUS     = 2 ))

CCPSET4   CONTRACT      KeyChange, Subset                        AR32.1  AR55.1
          DUE-DATE      Where((TRANS-TYPE = "I"
          TRANS-TYPE    Or     TRANS-TYPE = "C"
          BATCH-NBR     Or     TRANS-TYPE = "D" )
          TRANSACTION   And   (STATUS     = 1 ))
          PAYMENT-SEQ   Or   ((TRANS-TYPE = "P" )
          COMPANY       And   (STATUS     = Zeroes
                        Or     STATUS     = 2 ))

CCPSET5   ACTIVITY      KeyChange, Subset                        AR257
          DUE-DATE      Where STATUS > Zeroes
          TRANS-TYPE    And   STATUS < 9
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET6   ACTIVITY-GRP  KeyChange, Subset                        AR257
          DUE-DATE      Where STATUS > Zeroes
          TRANS-TYPE    And   STATUS < 9
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET7   CONTRACT      KeyChange, Subset                        BR450
          DUE-DATE      Where STATUS > Zeroes
          TRANS-TYPE    And   STATUS < 9
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET8   ACTIVITY      KeyChange                                AR296
          DUE-DATE
          TRANS-TYPE
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

CCPSET9   ACTIVITY-GRP  KeyChange                                AR296
          DUE-DATE
          TRANS-TYPE
          BATCH-NBR
          TRANSACTION
          PAYMENT-SEQ
          COMPANY

                         ARACPIVOT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Not Required

                            CCP-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Not Required

                            CCP-ACTIVITY        -> ACV-ACTIVITY

Acntract       ACCNTRACT    Not Required

                            CCP-CONTRACT        -> CNT-CONTRACT

Aroitems       AROITEMS     Not Required

                            CCP-COMPANY         -> ARO-COMPANY
                            CCP-TRANS-TYPE      -> ARO-TRANS-TYPE
                            CCP-TRANSACTION     -> ARO-INVOICE
                            CCP-PAYMENT-SEQ     -> ARO-PAYMENT-SEQ

Arpayment      ARPAYMENT    Not Required

                            CCP-COMPANY         -> APM-COMPANY
                            CCP-BATCH-NBR       -> APM-BATCH-NBR
                            CCP-PAYMENT-SEQ     -> APM-PAYMENT-SEQ

                         ARACPIVOT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Achisthdr      ACHISTHDR
                            Valid When CCP-CONTRACT != "SPACES"

                            CCP-CONTRACT        -> HIH-CONTRACT
                                                   HIH-OBJ-ID