ARDISPUTE

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 uses dispute codes for classification.
UPDATED BY
AR10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADP-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ADP-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Customer number.
ADP-TRANS-TYPE
Element: Transaction Type
Alpha 1
Transaction type of open item in dispute. Valid values are: D = Debit Memo I = Invoice
C = Credit Memo
ADP-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
ADP-PAYMENT-SEQ
Element: Payment Sequence
Numeric 6
Payment Sequence. The generated sequence number to separate individual invoice payment requirements.
ADP-SEQ
Element: Sequence Number
Numeric 3
The record sequence number. A given open item may have up to 999 dispute records.
ADP-DISPUTE-AMT
Element: Dispute Amount
Signed 18.2
Disputed amount in company base currency.
ADP-DISPUTE-CD
Element: Dispute Code
Alpha 2
The reason that the dispute was created.
ADP-TRAN-AMT
Element: Base Amount
Signed 18.2
Amount of the disputed transaction in base currency.
ADP-ORIG-DISP
Disputed
Transaction Amount
Signed 18.2
Disputed amount in transaction currency.
ADP-ORIG-AMT
Element: Transaction Amount
Signed 18.2
The original disputed amount of the transaction in transaction currency.
ADP-ORIG-CURRENCY
Element: Transaction Currency
Alpha 5
The transaction currency.
ADP-DISPUTE-DATE
Element: Dispute Date
Numeric 8 (yyyymmdd)
The date the dispute went into effect. The system date defaults.
ADP-RESOLV-DATE
Element: Resolve Date
Numeric 8 (yyyymmdd)
Date of resolution of dispute record.
ADP-DESC
Element: Description
Alpha 30 (Lower Case)
A description of the dispute reason. Dispute code description will default.


ARDISPUTE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADPSET1 COMPANY
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
SEQ
AR10.1
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


ARDISPUTE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:47:54 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.