ARDISPUTE – AR Disputed Transactions

System
Accounts Receivable (AR)
Prefix
ADP
Primary key
COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ
Fields
15
Updated by
1 program
Referenced by
1 program

ARDISPUTE is the AR Disputed Transactions table in Lawson Accounts Receivable (prefix ADP). It is indexed by COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ (ADPSET1); alternate indexes: ADPSET2, ADPSET3 and ADPSET4. It is related 1:1 to ARCOMP, ARCUSTOMER, AROIHDR, CUSTDESC and DISPCODES. It is updated by BR450 and referenced by AR10.1. The table has 15 fields, 4 indexes and 5 documented relations.

About ARDISPUTE

The AR Disputed Transactions file contains current and historical dispute records that represent the total amount or a portion of the open item being disputed. Disputes can be added for invoices or debit memos and uses dispute codes for classification.

Fields (15)

Column = COBOL field name without the ADP- 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
#ADP-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.—
#ADP-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Customer number.—
#ADP-TRANS-TYPE PK
TRANS_TYPE		Alpha 1Transaction type of open item in dispute. Valid values are:
  • D Debit Memo
  • I Invoice
  • C Credit Memo
—
#ADP-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.—
#ADP-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6Payment Sequence. The generated sequence number to separate individual invoice payment requirements.—
#ADP-SEQ PK
SEQ		Numeric 3The record sequence number. A given open item may have up to 999 dispute records.—
#ADP-DISPUTE-AMT
DISPUTE_AMT		Signed 18.2Disputed amount in company base currency.—
#ADP-DISPUTE-CD SET2 SET3 SET4
DISPUTE_CD		Alpha 2The reason that the dispute was created.—
#ADP-TRAN-AMT
TRAN_AMT		Signed 18.2Amount of the disputed transaction in base currency.—
#ADP-ORIG-DISP
ORIG_DISP		Signed 18.2Disputed amount in transaction currency.—
#ADP-ORIG-AMT
ORIG_AMT		Signed 18.2The original disputed amount of the transaction in transaction currency.—
#ADP-ORIG-CURRENCY
ORIG_CURRENCY		Alpha 5The transaction currency.—
#ADP-DISPUTE-DATE SET3
DISPUTE_DATE		Numeric 8 (yyyymmdd)The date the dispute went into effect. The system date defaults.—
#ADP-RESOLV-DATE SET3 SET4
RESOLV_DATE		Numeric 8 (yyyymmdd)Date of resolution of dispute record.—
#ADP-DESC
DESC		Alpha 30 (Lower Case)A description of the dispute reason. Dispute code description will default.—

Indexes (4)

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
ADPSET1
  1. COMPANY
  2. CUSTOMER
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
  6. SEQ
PrimaryAR10.1, BR450
ADPSET2
  1. COMPANY
  2. DISPUTE-CD
  3. CUSTOMER
  4. TRANS-TYPE
  5. INVOICE
  6. PAYMENT-SEQ
  7. SEQ
—
ADPSET3
  1. COMPANY
  2. DISPUTE-CD
  3. DISPUTE-DATE
  4. RESOLV-DATE
  5. CUSTOMER
  6. TRANS-TYPE
  7. INVOICE
  8. PAYMENT-SEQ
  9. SEQ
KeyChange—
ADPSET4
  1. COMPANY
  2. DISPUTE-CD
  3. RESOLV-DATE
  4. CUSTOMER
  5. TRANS-TYPE
  6. INVOICE
  7. PAYMENT-SEQ
  8. SEQ
KeyChange, SubsetWhere RESOLV-DATE != Zeroes—

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
ADP-COMPANY→ACO-COMPANY (ACOSET1)
ArcustomerARCUSTOMERRequired
ADP-COMPANY→ACM-COMPANY
ADP-CUSTOMER→ACM-CUSTOMER
AroihdrAROIHDRRequired
ADP-COMPANY→ARH-COMPANY
ADP-CUSTOMER→ARH-CUSTOMER
ADP-TRANS-TYPE→ARH-TRANS-TYPE
ADP-INVOICE→ARH-INVOICE
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
ADP-CUSTOMER→CUD-CUSTOMER
DispcodesDISPCODESRequired
ADP-COMPANY→DCD-COMPANY
ADP-DISPUTE-CD→DCD-DISPUTE-CD

Programs

Updated by (1)

Referenced by (1)