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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ADP-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | — |
ADP-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | Customer number. | — |
ADP-TRANS-TYPE PKTRANS_TYPE | Alpha 1 | Transaction type of open item in dispute. Valid values are:
| — |
ADP-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | — |
ADP-PAYMENT-SEQ PKPAYMENT_SEQ | Numeric 6 | Payment Sequence. The generated sequence number to separate individual invoice payment requirements. | — |
ADP-SEQ PKSEQ | Numeric 3 | The record sequence number. A given open item may have up to 999 dispute records. | — |
ADP-DISPUTE-AMTDISPUTE_AMT | Signed 18.2 | Disputed amount in company base currency. | — |
ADP-DISPUTE-CDDISPUTE_CD | Alpha 2 | The reason that the dispute was created. | — |
ADP-TRAN-AMTTRAN_AMT | Signed 18.2 | Amount of the disputed transaction in base currency. | — |
ADP-ORIG-DISPORIG_DISP | Signed 18.2 | Disputed amount in transaction currency. | — |
ADP-ORIG-AMTORIG_AMT | Signed 18.2 | The original disputed amount of the transaction in transaction currency. | — |
ADP-ORIG-CURRENCYORIG_CURRENCY | Alpha 5 | The transaction currency. | — |
ADP-DISPUTE-DATEDISPUTE_DATE | Numeric 8 (yyyymmdd) | The date the dispute went into effect. The system date defaults. | — |
ADP-RESOLV-DATERESOLV_DATE | Numeric 8 (yyyymmdd) | Date of resolution of dispute record. | — |
ADP-DESCDESC | Alpha 30 (Lower Case) | A description of the dispute reason. Dispute code description will default. | — |
Indexes (4)
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 |
|---|---|---|---|---|
ADPSET1 | COMPANY, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ | Primary | AR10.1, BR450 | |
ADPSET2 | COMPANY, DISPUTE-CD, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ | — | ||
ADPSET3 | COMPANY, DISPUTE-CD, DISPUTE-DATE, RESOLV-DATE, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ | KeyChange | — | |
ADPSET4 | COMPANY, DISPUTE-CD, RESOLV-DATE, CUSTOMER, TRANS-TYPE, INVOICE, PAYMENT-SEQ, SEQ | KeyChange, Subset | Where RESOLV-DATE != Zeroes | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | ADP-COMPANY → ACO-COMPANY (ACOSET1) | |
| Arcustomer | ARCUSTOMER | Required | ADP-COMPANY → ACM-COMPANY, ADP-CUSTOMER → ACM-CUSTOMER | |
| Aroihdr | AROIHDR | Required | ADP-COMPANY → ARH-COMPANY, ADP-CUSTOMER → ARH-CUSTOMER, ADP-TRANS-TYPE → ARH-TRANS-TYPE, ADP-INVOICE → ARH-INVOICE | |
| Custdesc | CUSTDESC | Required | ACO-CUST-GROUP → CUD-CUST-GROUP, ADP-CUSTOMER → CUD-CUSTOMER | |
| Dispcodes | DISPCODES | Required | ADP-COMPANY → DCD-COMPANY, ADP-DISPUTE-CD → DCD-DISPUTE-CD |
Programs
Updated by (1)
- BR450 Activity Aging
Referenced by (1)
- AR10.1 Customer