|
|
ARDUNSLDTL FILE
This file is generated by the Duning Letter Selection program (AR140). It
contains a list of the invoices that are past due for a customer. The
records on this file are displayed on the Dunning Letter Selection Maintenance
form (AR74.1), where the Credit Analyst has the option of either including or
not including them in the list of invoices to be included on a dunning
letter.
REFERENCED BY
AR141
UPDATED BY
AR140 AR145 AR74.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDL-COMPANY Numeric 4 AR140 AR74.1
Element: Company The number representing an AR company.
DDL-DUN-CYCLE-ID Numeric 6 AR140
Element: Dun Cycle Id Last dunning letter cycle ID.
DDL-CUSTOMER Alpha 9 (Right Justified) AR140 AR74.1
Element: Customer Customer to whom dunning letter is to be
sent.
DDL-INVOICE Alpha 22 AR140 AR74.1
Element: Invoice The invoice number value identifying
the transaction that is past due.
DDL-TRANS-TYPE Alpha 1 AR140 AR74.1
Element: Trans Type Type of transaction (Debit Memo, Credit
Memo or Invoice).
DDL-DUE-DATE Numeric 8 (yyyymmdd) AR140 AR74.1
Element: Due Date The transaction due date.
DDL-PAST-DUE-AMT Signed 18.2 AR140
Element: Intl Amt
DDL-TOBE-DUNNED-FL Alpha 1 AR140
Element: Tobe Dunned FlThis field indicates whether or not the
record is due for dunning. Valid values
are:
Y = Yes
N = No
DDL-ORIG-AMT Signed 18.2 AR140
Element: Intl Amt The original amount of the transaction.
DDL-DUN-LEVEL Numeric 2 AR140
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 transactioin on the letter.
DDL-COLLECTION-LVL Alpha 1 AR140
Element: Collection LvlSpecifies whether this transaction
should be turned over to a collection
agency. Valid values are:
Y = Yes
N = No
ARDUNSLDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DDLSET1 COMPANY AR140 AR141
CUSTOMER AR145 AR74.1
INVOICE
TRANS-TYPE
|
