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
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
Company The company number. Must be a valid AR506
company in the AR Company file.
ADP-CUSTOMER Alpha 9 (Right Justified) AR190 AR29.3
Customer Customer number. AR45.1 AR506
ADP-TRANS-TYPE Alpha 1 AR190 AR45.1
Transaction Type Transaction type of open item in AR506
dispute. Valid values are:
D = Debit Memo
I = Invoice
ADP-INVOICE Alpha 22 AR190 AR45.1
Invoice Number Used to identify the invoice. AR506
ADP-PAYMENT-SEQ Numeric 6 AR190 AR45.1
Payment Sequence Payment Sequence. The generated AR506
sequence number to separate individual
invoice payment requirements.
ADP-SEQ Numeric 3 AR190 AR45.1
Sequence Number The record sequence number. A given AR506
open item may have up to 999 dispute
records.
ADP-DISPUTE-AMT Signed 15.2 AR190 AR45.1
Dispute Amount Disputed amount in company base
currency.
ADP-DISPUTE-CD Alpha 2 AR190 AR45.1
Dispute Code The reason that the dispute was AR506
created.
ADP-TRAN-AMT Signed 15.2 AR190 AR45.1
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
Transaction Amount The original disputed amount of the AR506
transaction in transaction currency.
ADP-ORIG-CURRENCY Alpha 5 AR190 AR45.1
Transaction Currency The transaction currency. AR506
ADP-DISPUTE-DATE Numeric 8 (yyyymmdd) AR190 AR45.1
Dispute Date The date the dispute went into effect. AR506
The system date defaults.
ADP-RESOLV-DATE Numeric 8 (yyyymmdd) AR190 AR45.1
Resolve Date Date of resolution of dispute record. AR506
ADP-DESC Alpha 30 (Lower Case) AR190 AR45.1
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 AR135 AR137
CUSTOMER and for primary processing. AR140 AR190
TRANS-TYPE AR194 AR250
INVOICE AR251 AR252
PAYMENT-SEQ AR253 AR255
SEQ AR271 AR275
AR29.3 AR300
AR42.2 AR45.1
AR48.1 AR50.1
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
|
