ARDISPUTE FILE
AR Disputed Transactions
AR Disputed Transactions
REFERENCED BY
AR10.1 AR135 AR137 AR140 AR194 AR250
AR251 AR252 AR253 AR255 AR271 AR275
AR50.1 AR72.1 DT150 AR245 AR46.1
UPDATED BY
AR190 AR29.3 AR300 AR45.1 AR506 AR970
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 AR970
company in the AR Company file.
ADP-CUSTOMER Alpha 9 (Right Justified) AR190 AR29.3
Customer Customer number. AR45.1 AR506
AR970
ADP-TRANS-TYPE Alpha 1 AR190 AR45.1
Transaction Type Transaction type of open item in AR506 AR970
dispute. Valid values are:
D = Debit Memo
I = Invoice
ADP-TRANS-NBR Alpha 10 (Right Justified) AR190 AR45.1
Transaction Number Transaction number of disputed open AR506 AR970
item.
ADP-PAYMENT-SEQ Numeric 6 AR190 AR45.1
Payment Sequence Payment Sequence. The generated AR506 AR970
sequence number to separate individual
invoice payment requirements.
ADP-SEQ Numeric 3 AR190 AR45.1
Sequence Number The record sequence number. A given AR506 AR970
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 AR970
currency.
ADP-DISPUTE-CD Alpha 2 AR190 AR45.1
Dispute Code The reason that the dispute was AR506 AR970
created.
ADP-TRAN-AMT Signed 15.2 AR190 AR45.1
Base Amount Amount of the disputed transaction in AR506 AR970
base currency.
ADP-ORIG-DISP Signed 15.2 AR190 AR45.1
Disputed Disputed amount in transaction AR506 AR970
Transaction Amount currency.
ADP-ORIG-AMT Signed 15.2 AR190 AR45.1
Transaction Amount The original disputed amount of the AR506 AR970
transaction in transaction currency.
ADP-ORIG-CURRENCY Alpha 5 AR190 AR45.1
Transaction Currency The transaction currency. AR506 AR970
ADP-DISPUTE-DATE Numeric 8 (yyyymmdd) AR190 AR45.1
Dispute Date The date the dispute went into effect. AR506 AR970
The system date defaults.
ADP-RESOLV-DATE Numeric 8 (yyyymmdd) AR190 AR45.1
Resolve Date Date of resolution of dispute record. AR506 AR970
ADP-DESC Alpha 30 (Lower Case) AR190 AR45.1
Description A description of the dispute reason. AR506 AR970
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
TRANS-NBR AR250 AR251
PAYMENT-SEQ AR252 AR253
SEQ AR255 AR271
AR275 AR29.3
AR300 AR42.2
AR45.1 AR50.1
AR72.1 DT150
ADPSET2 COMPANY The path is used to list records by AR245
DISPUTE-CD dispute code.
CUSTOMER
TRANS-TYPE
TRANS-NBR
PAYMENT-SEQ
SEQ
ADPSET3 COMPANY The path is used to display resolved AR46.1
DISPUTE-CD records.
RESOLV-DATE KeyChange
CUSTOMER
TRANS-TYPE
TRANS-NBR
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-TRANS-NBR -> ARH-TRANS-NBR
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
|