ARDUNHIST FILE
AR Dunning History
This file maintains dunning history records. It keeps track of the status of
the dunning cycle ID (Selected, Printed, Complete, or Historical) and of the
last dunning level applied to transactions.
REFERENCED BY
AR145 AR274
UPDATED BY
AR141
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DUH-COMPANY Numeric 4 AR141
Company The company number represents an
established company and is entered on
all function codes.
DUH-CUSTOMER Alpha 9 (Right Justified) AR141
Customer Number This field contains the number that
represents a customer.
DUH-TRANS-TYPE Alpha 1 AR141
Transaction Type Determines if amounts or units are
processed in each transaction.
DUH-INVOICE Alpha 22 AR141
Invoice Number Used to identify the invoice.
DUH-DUN-CYCLE-ID Numeric 6 AR141
Dun Cycle Id Last dunning letter cycle ID.
DUH-DUN-PROCESS-CD Alpha 6 AR141
Dun Process Cd Dunning letter process code. A unique
code that represents a combination of
Dunning Letter options.
DUH-DUN-LEVEL Numeric 2 AR141
Dun Level This represents the DUN-LEVEL for which
this transaction would be dunned in
isolation. I.E. As if it were the only
overdue transaction on the letter.
DUH-DUN-TEXT-CODE Alpha 6 AR141
Dun Text Code The last dunning text code used for this
customer. The text code represents a
specific dunning letter text and its
translations.
DUH-PAST-DUE-AMT Signed 15.2 AR141
Past Due Amt Total amount that is open on the invoice
in transaction currency. This amount
may or may not be past due.
DUH-PRINTED-DATE Numeric 8 (yyyymmdd) AR141
Printed Date The date in which this transaction was
printed on the dunning letter.
DUH-TOBE-DUNNED-FL Alpha 1 AR141
Tobe Dunned Fl This field indicates whether or not the
record is due for dunning.
Y = Yes
N = No
DUH-COLLECTION-LVL Alpha 1 AR141
Collection Lvl Whether the level indicates that the
invoice will be turned over to a
collection agency. Yes or No.
Y = Yes
N = No
ARDUNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DUHSET1 COMPANY AR145 AR274
CUSTOMER
TRANS-TYPE
INVOICE
DUN-PROCESS-CD
DUN-LEVEL
DUN-CYCLE-ID
|