ARACPIVOT

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCPSET1 COMPANY
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
AR13.1 AR13.2
CB06.2 CB191
CCPSET10 CONTRACT
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange
CCPSET11 CONTRACT
DUE-DATE*
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange
CCPSET12 ACTIVITY
DUE-DATE*
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange
CCPSET13 ACTIVITY-GRP
DUE-DATE*
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange
CCPSET2 ACTIVITY
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange, Subset
Where((TRANS-TYPE ="I"
OrTRANS-TYPE ="C"
OrTRANS-TYPE ="D")
And(STATUS =1))
Or((TRANS-TYPE ="P")
And(STATUS =Zeroes
OrSTATUS =2))
CCPSET3 ACTIVITY-GRP
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange, Subset
Where((TRANS-TYPE ="I"
OrTRANS-TYPE ="C"
OrTRANS-TYPE ="D")
And(STATUS =1))
Or((TRANS-TYPE ="P")
And(STATUS =Zeroes
OrSTATUS =2))
CCPSET4 CONTRACT
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange, Subset
Where((TRANS-TYPE ="I"
OrTRANS-TYPE ="C"
OrTRANS-TYPE ="D")
And(STATUS =1))
Or((TRANS-TYPE ="P")
And(STATUS =Zeroes
OrSTATUS =2))
CCPSET5 ACTIVITY
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange, Subset
WhereSTATUS >Zeroes
AndSTATUS <9
CCPSET6 ACTIVITY-GRP
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange, Subset
WhereSTATUS >Zeroes
AndSTATUS <9
CCPSET7 CONTRACT
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange, Subset
WhereSTATUS >Zeroes
AndSTATUS <9
CCPSET8 ACTIVITY
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange
CCPSET9 ACTIVITY-GRP
DUE-DATE
TRANS-TYPE
BATCH-NBR
TRANSACTION
PAYMENT-SEQ
COMPANY
KeyChange


ARACPIVOT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Not Required
CCP-ACTIVITY-GRP->AGP-ACTIVITY-GRP (AGPSET1)
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR
Valid When CCP-CONTRACT !="SPACES"
CCP-CONTRACT->HIH-CONTRACT
  HIH-OBJ-ID


File created: Wed Jun 08 20:47:53 2016

Home
Contact Us



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