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