|
|
ARDUNSLDTL FILE
This file is generated by the DUNNING 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 company number represents an
established company and is entered on
all function codes.
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 NumbeCustomer to whom dunning letter is to be
sent.
DDL-INVOICE Alpha 22 AR140 AR74.1
Element: Invoice NumberThe user-defined value identifying the
transaction that is past due. Open
transaction numbers are stored in the
AROITEMS file.
DDL-TRANS-TYPE Alpha 1 AR140 AR74.1
Element: Transaction TyType of transaction (Debit Memo or
Invoice).
DDL-DUE-DATE Numeric 8 (yyyymmdd) AR140 AR74.1
Element: Date The transaction due date.
DDL-PAST-DUE-AMT Signed 15.2 AR140
Element: Past Due Amt Total amount that is past due on the
invoice in transaction currency.
DDL-TOBE-DUNNED-FL Alpha 1 AR140
Element: Tobe Dunned FlThis field indicates whether or not the
record is due for dunning.
Y = Yes
N = No
DDL-ORIG-AMT Signed 15.2 AR140
Element: Adj Amt The original amount of the transaction.
This field is populated from the field
ORIG-AMT within the AROITEMS file.
DDL-DUN-LEVEL Numeric 2 AR140
Element: 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 transactioin on the letter.
DDL-COLLECTION-LVL Alpha 1 AR140
Element: Collection LvlSpecifies whether this transaction
should be turned over to a collection
agency.
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
|
