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 uses dispute
codes for classification.
REFERENCED BY
AR10.1 AR135 AR137 AR140 AR194 AR250
AR251 AR252 AR253 AR255 AR257 AR271
AR275 AR39.1 AR39.2 AR48.1 AR50.1 AR55.1
AR72.1 AR90.1 AR91.1 BR450 DT150 AR245
AR46.1
UPDATED BY
AR190 AR29.3 AR300 AR38.1 AR38.2 AR38.3
AR45.1 AR506 AR42.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADP-COMPANY Numeric 4 AR190 AR38.1
Element: Company The number representing an AR company. AR38.2 AR38.3
AR45.1 AR506
ADP-CUSTOMER Alpha 9 (Right Justified) AR190 AR29.3
Element: Customer Customer number. AR38.1 AR38.2
AR38.3 AR45.1
AR506
ADP-TRANS-TYPE Alpha 1 AR190 AR38.1
Element: Transaction TyTransaction type of open item in AR38.2 AR38.3
dispute. Valid values are: AR45.1 AR506
D = Debit Memo
I = Invoice
C = Credit Memo
ADP-INVOICE Alpha 22 AR190 AR38.1
Element: Invoice Used to identify the invoice. AR38.2 AR38.3
AR45.1 AR506
ADP-PAYMENT-SEQ Numeric 6 AR190 AR38.1
Element: Payment SequenPayment Sequence. The generated AR38.2 AR38.3
sequence number to separate individual AR45.1 AR506
invoice payment requirements.
ADP-SEQ Numeric 3 AR190 AR38.1
Element: Sequence NumbeThe record sequence number. A given AR38.2 AR38.3
open item may have up to 999 dispute AR45.1 AR506
records.
ADP-DISPUTE-AMT Signed 18.2 AR190 AR29.3
Element: Dispute AmountDisputed amount in company base AR38.1 AR38.2
currency. AR38.3 AR45.1
ADP-DISPUTE-CD Alpha 2 AR190 AR38.1
Element: Dispute Code The reason that the dispute was AR38.2 AR38.3
created. AR45.1 AR506
ADP-TRAN-AMT Signed 18.2 AR190 AR38.1
Element: Base Amount Amount of the disputed transaction in AR38.2 AR38.3
base currency. AR45.1 AR506
ADP-ORIG-DISP Signed 18.2 AR190 AR38.1
Disputed Disputed amount in transaction AR38.2 AR38.3
Transaction Amount currency. AR45.1 AR506
ADP-ORIG-AMT Signed 18.2 AR190 AR38.1
Element: Transaction AmThe original disputed amount of the AR38.2 AR38.3
transaction in transaction currency. AR45.1 AR506
ADP-ORIG-CURRENCY Alpha 5 AR190 AR38.1
Element: Transaction CuThe transaction currency. AR38.2 AR38.3
AR45.1 AR506
ADP-DISPUTE-DATE Numeric 8 (yyyymmdd) AR190 AR38.1
Element: Dispute Date The date the dispute went into effect. AR38.2 AR38.3
The system date defaults. AR45.1 AR506
ADP-RESOLV-DATE Numeric 8 (yyyymmdd) AR190 AR38.1
Element: Resolve Date Date of resolution of dispute record. AR38.2 AR38.3
AR45.1 AR506
ADP-DESC Alpha 30 (Lower Case) AR190 AR38.1
Element: Description A description of the dispute reason. AR38.2 AR38.3
Dispute code description will default. AR45.1 AR506
ARDISPUTE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADPSET1 COMPANY AR10.1 AR135
CUSTOMER AR137 AR140
TRANS-TYPE AR190 AR194
INVOICE AR250 AR251
PAYMENT-SEQ AR252 AR253
SEQ AR255 AR257
AR271 AR275
AR29.3 AR300
AR38.1 AR38.2
AR39.1 AR39.2
AR42.2 AR42.6
AR45.1 AR48.1
AR50.1 AR506
AR55.1 AR72.1
AR90.1 AR91.1
...
ADPSET2 COMPANY AR245
DISPUTE-CD
CUSTOMER
TRANS-TYPE
INVOICE
PAYMENT-SEQ
SEQ
ADPSET3 COMPANY KeyChange AR46.1
DISPUTE-CD
DISPUTE-DATE
RESOLV-DATE
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
|
