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.

Field / column	Type	Description & values	Updated by
`CCP-COMPANY` PK COMPANY	Numeric 4	The AR company associated with the payment record.	AR13.1, AR13.2, ARLL.1, CB06.2, CB191
`CCP-TRANS-TYPE` PK 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` PK 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` PK TRANSACTION	Alpha 22	The payment or transaction number.	AR13.1, AR13.2, ARLL.1, CB06.2, CB191
`CCP-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	The unique payment or obligation sequence number.	AR13.1, AR13.2, ARLL.1, CB06.2, CB191
`CCP-ACTIVITY` 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` 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` 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` 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` 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` 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 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` ORIG_CURRENCY	Alpha 5	This contains the original transaction currency code.	AR13.1, AR13.2, ARLL.1, CB06.2, CB191
`CCP-ORIG-ND` ORIG_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` 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 ×3	This 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 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` BANK_INST_TYPE	Alpha 1	This 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` 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 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` BASE_ND	Numeric 1	The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CCPSET1`	`COMPANY`, `TRANS-TYPE`, `BATCH-NBR`, `TRANSACTION`, `PAYMENT-SEQ`	Primary		AR13.1, AR13.2, ARLL.1, 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" Or TRANS-TYPE = "C" Or TRANS-TYPE = "D") And (STATUS = 1)) Or ((TRANS-TYPE = "P") And (STATUS = Zeroes Or STATUS = 2))	—
`CCPSET3`	`ACTIVITY-GRP`, `DUE-DATE`, `TRANS-TYPE`, `BATCH-NBR`, `TRANSACTION`, `PAYMENT-SEQ`, `COMPANY`	KeyChange, Subset	Where ((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`	`CONTRACT`, `DUE-DATE`, `TRANS-TYPE`, `BATCH-NBR`, `TRANSACTION`, `PAYMENT-SEQ`, `COMPANY`	KeyChange, Subset	Where ((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`	`ACTIVITY`, `DUE-DATE`, `TRANS-TYPE`, `BATCH-NBR`, `TRANSACTION`, `PAYMENT-SEQ`, `COMPANY`	KeyChange, Subset	Where STATUS > Zeroes And STATUS < 9	—
`CCPSET6`	`ACTIVITY-GRP`, `DUE-DATE`, `TRANS-TYPE`, `BATCH-NBR`, `TRANSACTION`, `PAYMENT-SEQ`, `COMPANY`	KeyChange, Subset	Where STATUS > Zeroes And STATUS < 9	—
`CCPSET7`	`CONTRACT`, `DUE-DATE`, `TRANS-TYPE`, `BATCH-NBR`, `TRANSACTION`, `PAYMENT-SEQ`, `COMPANY`	KeyChange, Subset	Where STATUS > Zeroes And STATUS < 9	BR450
`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		—

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Field map
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`
Gmgrant	GMGRANT	Required	`CCP-GRANT` → `GRN-GRANT`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Achisthdr	ACHISTHDR		Valid When CCP-CONTRACT != "SPACES"	`CCP-CONTRACT` → `HIH-CONTRACT`, → `HIH-OBJ-ID`

Programs

Updated by (6)

AR13.1 MICR Customer
AR13.2 Customer MICR
ARLL.1 AR Transaction Interface
BR450 Activity Aging
CB06.2 Bank Statement Detail Entry
CB191 Bank Statement Close