ARACPIVOT – Acct Receivables Payment Trans

System
Accounts Receivable (AR)
Prefix
CCP
Primary key
COMPANY, TRANS-TYPE, BATCH-NBR, TRANSACTION, PAYMENT-SEQ
Fields
46
Updated by
6 programs
Referenced by
0 programs

ARACPIVOT is the Acct Receivables Payment Trans table in Lawson Accounts Receivable (prefix CCP). It is indexed by COMPANY, TRANS-TYPE, BATCH-NBR, TRANSACTION, PAYMENT-SEQ (CCPSET1); alternate indexes: CCPSET10, CCPSET11, CCPSET12, CCPSET13, CCPSET2, CCPSET3, CCPSET4, CCPSET5 and 4 more. It is related 1:1 to ACACTGRP, ACACTIVITY, ACCNTRACT, AROITEMS, ARPAYMENT and GMGRANT and 1:M to ACHISTHDR. It is updated by AR13.1, AR13.2, ARLL.1, BR450, CB06.2 and CB191. The table has 46 fields, 13 indexes and 7 documented relations.

About ARACPIVOT

No description in the Lawson data dictionary.

Fields (46)

Column = COBOL field name without the CCP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CCP-COMPANY PK
COMPANY		Numeric 4The AR company associated with the payment record.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-TRANS-TYPE PK
TRANS_TYPE		Alpha 1Determines 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 PK
BATCH_NBR		Numeric 6This 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 PK
TRANSACTION		Alpha 22The payment or transaction number.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6The unique payment or obligation sequence number.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-ACTIVITY SET12 SET2 SET5 SET8
ACTIVITY		Alpha 15The activity associated with the transaction or payment - interfaced from AC/BRAR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The account category associated with the transaction or payment - interfaced from AC/BR cost revenue accrual pass thruARLL.1, CB06.2
#CCP-CONTRACT SET10 SET11 SET4 SET7
CONTRACT		Alpha 15The contract asociated with the transaction or payment - interfaced from AC/BR.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-ACTIVITY-GRP SET13 SET3 SET6 SET9
ACTIVITY_GRP		Alpha 15The aactivity group associated with the transaction or payment - interfaced from AC/BR.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-STATUS
STATUS		Numeric 1The 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
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
OPEN_TRAN		Signed 18.2—AR13.1, AR13.2, CB06.2
#CCP-OPEN-BASE
OPEN_BASE		Signed 18.2—AR13.1, AR13.2, CB06.2
#CCP-SORT-AMOUNT
SORT_AMOUNT		Numeric 17—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-ORIG-CURRENCY
ORIG_CURRENCY		Alpha 5This contains the original transaction currency code.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-ORIG-ND
ORIG_ND		Numeric 1The 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
ORIG_RATE		Signed 14.7—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-CURR-MUDV
CURR_MUDV		Alpha 1—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-SUM-LINE
SUM_LINE		Alpha 1—ARLL.1, CB06.2
#CCP-DISC-DATE
DISC_DATE		Numeric 8 (yyyymmdd) Occurs 3 Times ×3This field displays the system date when this was created.ARLL.1, CB06.2
#CCP-ORIG-DISC-AMT
ORIG_DISC_AMT		Signed 18.2 Occurs 3 Times ×3—ARLL.1, CB06.2
#CCP-CUST-PO-NBR
CUST_PO_NBR		Alpha 22—ARLL.1, CB06.2
#CCP-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-XREF-TYPE
XREF_TYPE		Alpha 1—ARLL.1, CB06.2
#CCP-XREF-NBR
XREF_NBR		Alpha 22—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-BANK-INST-CODE
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.ARLL.1, CB06.2
#CCP-BANK-INST-TYPE
BANK_INST_TYPE		Alpha 1This categorizes the type of bank instrument.ARLL.1, CB06.2
#CCP-ALT-TYPE
ALT_TYPE		Alpha 1—
  • M Mixed signed transaction
  • I Invoice
  • C Credit Memo
  • D Debit Memo
ARLL.1, CB06.2
#CCP-GL-DATE
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
CANCEL_DATE		Numeric 8 (yyyymmdd)The cancellation date.AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-DISPUTE-SEQ
DISPUTE_SEQ		Numeric 3—ARLL.1, CB06.2
#CCP-REVALUE-FL
REVALUE_FL		Alpha 1—ARLL.1, CB06.2
#CCP-TRANS-USER1
TRANS_USER1		Alpha 10—ARLL.1, CB06.2
#CCP-ORIG-AMT
ORIG_AMT		Signed 18.2—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-TRAN-AMT
TRAN_AMT		Signed 18.2—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-DUE-DATE SET10 SET11 SET12 SET13 SET2 SET3 SET4 SET5 SET6 SET7 SET8 SET9
DUE_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
GAINLOS_AMT		Signed 18.2—ARLL.1, CB06.2
#CCP-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.ARLL.1, CB06.2
#CCP-ADJ-FL
ADJ_FL		Alpha 1—ARLL.1, CB06.2
#CCP-GROUP-RATE
GROUP_RATE		Signed 14.7—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-GROUP-MUDV
GROUP_MUDV		Alpha 1—AR13.1, AR13.2, ARLL.1, CB06.2, CB191
#CCP-DISC-PCT
DISC_PCT		Percent 7.5 (Percent) Occurs 3 Times ×3—ARLL.1, CB06.2
#CCP-AC-CUSTOMER-ID
AC_CUSTOMER_ID		Alpha 5—ARLL.1, CB06.2
#CCP-GRANT
GRANT		Alpha 30—AR13.1, AR13.2, ARLL.1, CB06.2, CB191

Indexes (13)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CCPSET1
  1. COMPANY
  2. TRANS-TYPE
  3. BATCH-NBR
  4. TRANSACTION
  5. PAYMENT-SEQ
PrimaryAR13.1, AR13.2, ARLL.1, CB06.2, CB191
CCPSET10
  1. CONTRACT
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange—
CCPSET11
  1. CONTRACT
  2. DUE-DATE ↓
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange—
CCPSET12
  1. ACTIVITY
  2. DUE-DATE ↓
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange—
CCPSET13
  1. ACTIVITY-GRP
  2. DUE-DATE ↓
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange—
CCPSET2
  1. ACTIVITY
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange, SubsetWhere ((TRANS-TYPE = "I" Or TRANS-TYPE = "C" Or TRANS-TYPE = "D") And (STATUS = 1)) Or ((TRANS-TYPE = "P") And (STATUS = Zeroes Or STATUS = 2))—
CCPSET3
  1. ACTIVITY-GRP
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange, SubsetWhere ((TRANS-TYPE = "I" Or TRANS-TYPE = "C" Or TRANS-TYPE = "D") And (STATUS = 1)) Or ((TRANS-TYPE = "P") And (STATUS = Zeroes Or STATUS = 2))—
CCPSET4
  1. CONTRACT
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange, SubsetWhere ((TRANS-TYPE = "I" Or TRANS-TYPE = "C" Or TRANS-TYPE = "D") And (STATUS = 1)) Or ((TRANS-TYPE = "P") And (STATUS = Zeroes Or STATUS = 2))—
CCPSET5
  1. ACTIVITY
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange, SubsetWhere STATUS > Zeroes And STATUS < 9—
CCPSET6
  1. ACTIVITY-GRP
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange, SubsetWhere STATUS > Zeroes And STATUS < 9—
CCPSET7
  1. CONTRACT
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange, SubsetWhere STATUS > Zeroes And STATUS < 9BR450
CCPSET8
  1. ACTIVITY
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange—
CCPSET9
  1. ACTIVITY-GRP
  2. DUE-DATE
  3. TRANS-TYPE
  4. BATCH-NBR
  5. TRANSACTION
  6. PAYMENT-SEQ
  7. COMPANY
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTGRPACACTIVITYACCNTRACTAROITEMSARPAYMENTGMGRANTACHISTHDRARACPIVOT

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPNot Required
CCP-ACTIVITY-GRP→AGP-ACTIVITY-GRP (AGPSET1)
AcactivityACACTIVITYNot Required
CCP-ACTIVITY→ACV-ACTIVITY
AcntractACCNTRACTNot Required
CCP-CONTRACT→CNT-CONTRACT
AroitemsAROITEMSNot Required
CCP-COMPANY→ARO-COMPANY
CCP-TRANS-TYPE→ARO-TRANS-TYPE
CCP-TRANSACTION→ARO-INVOICE
CCP-PAYMENT-SEQ→ARO-PAYMENT-SEQ
ArpaymentARPAYMENTNot Required
CCP-COMPANY→APM-COMPANY
CCP-BATCH-NBR→APM-BATCH-NBR
CCP-PAYMENT-SEQ→APM-PAYMENT-SEQ
GmgrantGMGRANTRequired
CCP-GRANT→GRN-GRANT

One to many (1) — child tables

RelationTableRulesConditionField map
AchisthdrACHISTHDRValid When CCP-CONTRACT != "SPACES"
CCP-CONTRACT→HIH-CONTRACT
—→HIH-OBJ-ID

Programs

Updated by (6)