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

AR13.1

AR13.2

CB06.2

CB191

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CCP-COMPANY Element: Company	Numeric 4 The AR company associated with the payment record.	AR13.1 AR13.2 CB06.2 CB191
CCP-TRANS-TYPE Element: Trans Type	Alpha 1 Determines the transaction type: Invoice (I), Credit memo (I), Debit memo (D) or Payment (P). I = Invoice C = Credit Memo D = Debit Memo P = Payment	AR13.1 AR13.2 CB06.2 CB191
CCP-BATCH-NBR Element: Batch Nbr	Numeric 6 This identifies the batch the entered invoices, debit memos, and credit memos are a part of.	AR13.1 AR13.2 CB06.2 CB191
CCP-TRANSACTION Element: Transaction	Alpha 22 The payment or transaction number.	AR13.1 AR13.2 CB06.2 CB191
CCP-PAYMENT-SEQ Element: Seq Number	Numeric 6 The unique payment or obligation sequence number.	AR13.1 AR13.2 CB06.2 CB191
CCP-ACTIVITY Element: Activity	Alpha 15 The activity associated with the transaction or payment - interfaced from AC/BR	AR13.1 AR13.2 CB06.2 CB191
CCP-ACCT-CATEGORY Element: Acct Category	Alpha 5 The account category associated with the transaction or payment - interfaced from AC/BR cost revenue accrual pass thru	CB06.2
CCP-CONTRACT Element: Contract	Alpha 15 The contract asociated with the transaction or payment - interfaced from AC/BR.	AR13.1 AR13.2 CB06.2 CB191
CCP-ACTIVITY-GRP Element: Activity Grp	Alpha 15 The aactivity group associated with the transaction or payment - interfaced from AC/BR.	AR13.1 AR13.2 CB06.2 CB191
CCP-STATUS Element: Status	Numeric 1 The status of the record in the processing flow. Valid values are: 1 = Released open item 2 = Released assigned payment 7 = Fully applied 8 = Closed 9 = History 0 = Unreleased payment	AR13.1 AR13.2 CB06.2 CB191
CCP-CUSTOMER Element: Customer	Alpha 9 (Right Justified) The customer associated with the transacton or payment.	AR13.1 AR13.2 CB06.2 CB191
CCP-OPEN-TRAN Element: Intl Amt	Signed 18.2	AR13.1 AR13.2 CB06.2
CCP-OPEN-BASE Element: Intl Amt	Signed 18.2	AR13.1 AR13.2 CB06.2
CCP-SORT-AMOUNT Element: Sort Amount	Numeric 17	AR13.1 AR13.2 CB06.2 CB191
CCP-PROCESS-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.	AR13.1 AR13.2 CB06.2 CB191
CCP-ORIG-CURRENCY Element: Orig Currency	Alpha 5 This contains the original transaction currency code.	AR13.1 AR13.2 CB06.2 CB191
CCP-ORIG-ND Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.	AR13.1 AR13.2 CB06.2 CB191
CCP-ORIG-RATE Element: Orig Rate	Signed 14.7	AR13.1 AR13.2 CB06.2 CB191
CCP-CURR-MUDV Element: Curr Mudv	Alpha 1	AR13.1 AR13.2 CB06.2 CB191
CCP-SUM-LINE Element: Sum Line	Alpha 1	CB06.2
CCP-DISC-DATE Element: Date	Numeric 8 (yyyymmdd) Occurs 3 Times This field displays the system date when this was created.	CB06.2
CCP-ORIG-DISC-AMT Element: Intl Amt	Signed 18.2 Occurs 3 Times	CB06.2
CCP-CUST-PO-NBR Element: Cust Po Nbr	Alpha 22	CB06.2
CCP-TRANS-DATE Element: Tran Date	Numeric 8 (yyyymmdd)	AR13.1 AR13.2 CB06.2 CB191
CCP-XREF-TYPE Element: Xref Type	Alpha 1	CB06.2
CCP-XREF-NBR Element: Xref Nbr	Alpha 22	AR13.1 AR13.2 CB06.2 CB191
CCP-BANK-INST-CODE Element: Bank Inst Code	Alpha 3 A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.	CB06.2
CCP-BANK-INST-TYPE Element: Bank Inst Type	Alpha 1 This categorizes the type of bank instrument.	CB06.2
CCP-ALT-TYPE Element: Alt Type	Alpha 1 M = Mixed signed transaction I = Invoice C = Credit Memo D = Debit Memo	CB06.2
CCP-GL-DATE Element: Gl Date	Numeric 8 (yyyymmdd) This field contains the general ledger posting date.	AR13.1 AR13.2 CB06.2 CB191
CCP-CANCEL-DATE Element: Cancel Date	Numeric 8 (yyyymmdd) The cancellation date.	AR13.1 AR13.2 CB06.2 CB191
CCP-DISPUTE-SEQ Element: Dispute Seq	Numeric 3	CB06.2
CCP-REVALUE-FL Element: Revalue Fl	Alpha 1	CB06.2
CCP-TRANS-USER1 Element: Trans User1	Alpha 10	CB06.2
CCP-ORIG-AMT Element: Intl Amt	Signed 18.2	AR13.1 AR13.2 CB06.2 CB191
CCP-TRAN-AMT Element: Intl Amt	Signed 18.2	AR13.1 AR13.2 CB06.2 CB191
CCP-DUE-DATE Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.	AR13.1 AR13.2 CB06.2 CB191
CCP-GAINLOS-AMT Element: Intl Amt	Signed 18.2	CB06.2
CCP-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	AR13.1 AR13.2 CB06.2 CB191
CCP-BASE-ND Element: Base Nd	Numeric 1 The number of decimal positions defined for the company base currency.	CB06.2
CCP-ADJ-FL Element: Flag1	Alpha 1	CB06.2
CCP-GROUP-RATE Element: Group Rate	Signed 14.7	AR13.1 AR13.2 CB06.2 CB191
CCP-GROUP-MUDV Element: Group Mudv	Alpha 1	AR13.1 AR13.2 CB06.2 CB191
CCP-DISC-PCT Element: Disc Pct	Percent 7.5 (Percent) Occurs 3 Times	CB06.2
CCP-AC-CUSTOMER-ID Element: Ac Customer Id	Alpha 5	CB06.2

ARACPIVOT FILE INDEX

ARACPIVOT FILE RELATIONS

ONE TO ONE RELATIONS

ARACPIVOT FILE RELATIONS

ONE TO MANY RELATIONS

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