Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARDISPUTE


                             ARDISPUTE FILE

                        AR Disputed Transactions

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 use dispute
codes for classification.

REFERENCED BY

AR10.1    AR135     AR137     AR140     AR194     AR250
AR251     AR252     AR253     AR255     AR271     AR275
AR48.1    AR50.1    AR72.1    AR90.1    DT150     AR245
AR46.1

UPDATED BY

AR190     AR29.3    AR300     AR45.1    AR506     AR42.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADP-COMPANY            Numeric 4                                 AR190   AR45.1
Element: Company       The company number. Must be a valid       AR506
                       company in the AR Company file.

ADP-CUSTOMER           Alpha 9  (Right Justified)                AR190   AR29.3
Element: Customer      Customer number.                          AR45.1  AR506

ADP-TRANS-TYPE         Alpha 1                                   AR190   AR45.1
Element: Transaction TyTransaction type of open item in          AR506
                       dispute. Valid values are:

                       D = Debit Memo
                       I = Invoice

ADP-INVOICE            Alpha 22                                  AR190   AR45.1
Element: Invoice NumberUsed to identify the invoice.             AR506

ADP-PAYMENT-SEQ        Numeric 6                                 AR190   AR45.1
Element: Payment SequenPayment Sequence. The generated           AR506
                       sequence number to separate individual
                       invoice payment requirements.

ADP-SEQ                Numeric 3                                 AR190   AR45.1
Element: Sequence NumbeThe record sequence number. A given       AR506
                       open item may have up to 999 dispute
                       records.

ADP-DISPUTE-AMT        Signed 15.2                               AR190   AR29.3
Element: Dispute AmountDisputed amount in company base           AR45.1
                       currency.


ADP-DISPUTE-CD         Alpha 2                                   AR190   AR45.1
Element: Dispute Code  The reason that the dispute was           AR506
                       created.

ADP-TRAN-AMT           Signed 15.2                               AR190   AR45.1
Element: Base Amount   Amount of the disputed transaction in     AR506
                       base currency.

ADP-ORIG-DISP          Signed 15.2                               AR190   AR45.1
Disputed               Disputed amount in transaction            AR506
Transaction Amount     currency.

ADP-ORIG-AMT           Signed 15.2                               AR190   AR45.1
Element: Transaction AmThe original disputed amount of the       AR506
                       transaction in transaction currency.

ADP-ORIG-CURRENCY      Alpha 5                                   AR190   AR45.1
Element: Transaction CuThe transaction currency.                 AR506

ADP-DISPUTE-DATE       Numeric 8  (yyyymmdd)                     AR190   AR45.1
Element: Dispute Date  The date the dispute went into effect.    AR506
                       The system date defaults.


ADP-RESOLV-DATE        Numeric 8  (yyyymmdd)                     AR190   AR45.1
Element: Resolve Date  Date of resolution of dispute record.     AR506

ADP-DESC               Alpha 30  (Lower Case)                    AR190   AR45.1
Element: Description   A description of the dispute reason.      AR506
                       Dispute code description will default.

                         ARDISPUTE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADPSET1   COMPANY       The path is used to keep records unique  AR10.1  AR135
          CUSTOMER      and for primary processing.              AR137   AR140
          TRANS-TYPE                                             AR190   AR194
          INVOICE                                                AR250   AR251
          PAYMENT-SEQ                                            AR252   AR253
          SEQ                                                    AR255   AR271
                                                                 AR275   AR29.3
                                                                 AR300   AR42.2
                                                                 AR42.6  AR45.1
                                                                 AR48.1  AR50.1
                                                                 AR506   AR72.1
                                                                 AR90.1  DT150

ADPSET2   COMPANY       The path is used to list records by      AR245
          DISPUTE-CD    dispute code.
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          SEQ

ADPSET3   COMPANY       The path is used to display resolved     AR46.1
          DISPUTE-CD    records.
          RESOLV-DATE   KeyChange
          CUSTOMER
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          SEQ

                         ARDISPUTE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ADP-COMPANY       -> ACO-COMPANY

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