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.

REFERENCED BY
AR10.1


UPDATED BY
BR450

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 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
WhereRESOLV-DATE !=Zeroes


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: Thu Jun 09 02:09:02 2016

Home
Contact Us



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