Acct Receivables Payment Trans

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

ARLL.1

CB06.2

CB191

BR450

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 ARLL.1 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 ARLL.1 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 ARLL.1 CB06.2 CB191
CCP-TRANSACTION Element: Transaction	Alpha 22 The payment or transaction number.	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-PAYMENT-SEQ Element: Seq Number	Numeric 6 The unique payment or obligation sequence number.	AR13.1 AR13.2 ARLL.1 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 ARLL.1 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	ARLL.1 CB06.2
CCP-CONTRACT Element: Contract	Alpha 15 The contract asociated with the transaction or payment - interfaced from AC/BR.	AR13.1 AR13.2 ARLL.1 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 ARLL.1 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 ARLL.1 CB06.2 CB191
CCP-CUSTOMER Element: Customer	Alpha 9 (Right Justified) The customer associated with the transacton or payment.	AR13.1 AR13.2 ARLL.1 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 ARLL.1 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 ARLL.1 CB06.2 CB191
CCP-ORIG-CURRENCY Element: Orig Currency	Alpha 5 This contains the original transaction currency code.	AR13.1 AR13.2 ARLL.1 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 ARLL.1 CB06.2 CB191
CCP-ORIG-RATE Element: Orig Rate	Signed 14.7	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-CURR-MUDV Element: Curr Mudv	Alpha 1	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-SUM-LINE Element: Sum Line	Alpha 1	ARLL.1 CB06.2
CCP-DISC-DATE Element: Date	Numeric 8 (yyyymmdd) Occurs 3 Times This field displays the system date when this was created.	ARLL.1 CB06.2
CCP-ORIG-DISC-AMT Element: Intl Amt	Signed 18.2 Occurs 3 Times	ARLL.1 CB06.2
CCP-CUST-PO-NBR Element: Cust Po Nbr	Alpha 22	ARLL.1 CB06.2
CCP-TRANS-DATE Element: Tran Date	Numeric 8 (yyyymmdd)	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-XREF-TYPE Element: Xref Type	Alpha 1	ARLL.1 CB06.2
CCP-XREF-NBR Element: Xref Nbr	Alpha 22	AR13.1 AR13.2 ARLL.1 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.	ARLL.1 CB06.2
CCP-BANK-INST-TYPE Element: Bank Inst Type	Alpha 1 This categorizes the type of bank instrument.	ARLL.1 CB06.2
CCP-ALT-TYPE Element: Alt Type	Alpha 1 M = Mixed signed transaction I = Invoice C = Credit Memo D = Debit Memo	ARLL.1 CB06.2
CCP-GL-DATE Element: Gl Date	Numeric 8 (yyyymmdd) This field contains the general ledger posting date.	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-CANCEL-DATE Element: Cancel Date	Numeric 8 (yyyymmdd) The cancellation date.	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-DISPUTE-SEQ Element: Dispute Seq	Numeric 3	ARLL.1 CB06.2
CCP-REVALUE-FL Element: Revalue Fl	Alpha 1	ARLL.1 CB06.2
CCP-TRANS-USER1 Element: Trans User1	Alpha 10	ARLL.1 CB06.2
CCP-ORIG-AMT Element: Intl Amt	Signed 18.2	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-TRAN-AMT Element: Intl Amt	Signed 18.2	AR13.1 AR13.2 ARLL.1 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 ARLL.1 CB06.2 CB191
CCP-GAINLOS-AMT Element: Intl Amt	Signed 18.2	ARLL.1 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 ARLL.1 CB06.2 CB191
CCP-BASE-ND Element: Base Nd	Numeric 1 The number of decimal positions defined for the company base currency.	ARLL.1 CB06.2
CCP-ADJ-FL Element: Flag1	Alpha 1	ARLL.1 CB06.2
CCP-GROUP-RATE Element: Group Rate	Signed 14.7	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-GROUP-MUDV Element: Group Mudv	Alpha 1	AR13.1 AR13.2 ARLL.1 CB06.2 CB191
CCP-DISC-PCT Element: Disc Pct	Percent 7.5 (Percent) Occurs 3 Times	ARLL.1 CB06.2
CCP-AC-CUSTOMER-ID Element: Ac Customer Id	Alpha 5	ARLL.1 CB06.2
CCP-GRANT Element: Grant	Alpha 30	AR13.1 AR13.2 ARLL.1 CB06.2 CB191

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.