|
|
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 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DUH-COMPANY Numeric 4 AR141
Element: Company The number representing an AR company.
DUH-CUSTOMER Alpha 9 (Right Justified) AR141
Element: Customer This field contains the number that
represents a customer.
DUH-TRANS-TYPE Alpha 1 AR141
Element: Trans Type The transaction type. Valid values are:
C = Credit Memo
D = Debit Memo
I = Invoice
DUH-INVOICE Alpha 22 AR141
Element: Invoice Used to identify the invoice.
DUH-DUN-CYCLE-ID Numeric 6 AR141
Element: Dun Cycle Id Last dunning letter cycle ID.
DUH-DUN-PROCESS-CD Alpha 6 AR141
Element: Dun Process CdDunning letter process code. A unique
code that represents a combination of
Dunning Letter options.
DUH-DUN-LEVEL Numeric 2 AR141
Element: Dun Level This represents the dunning 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
Element: 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 18.2 AR141
Element: Intl 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
Element: Printed Date The date in which this transaction was
printed on the dunning letter.
DUH-TOBE-DUNNED-FL Alpha 1 AR141
Element: Tobe Dunned FlThis field indicates whether or not the
record is due for dunning. valid values
are:
Y = Yes
N = No
DUH-COLLECTION-LVL Alpha 1 AR141
Element: Collection LvlWhether the level indicates that the
invoice will be turned over to a
collection agency. Valid values are:
Y = Yes
N = No
ARDUNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DUHSET1 COMPANY AR145 AR274
CUSTOMER AR300
TRANS-TYPE
INVOICE
DUN-PROCESS-CD
DUN-LEVEL
DUN-CYCLE-ID
|
