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