ARDUNLTR – No description in the Lawson data dictionary

System
Accounts Receivable (AR)
Prefix
DUL
Primary key
DUN-PROCESS-CD, DUN-LEVEL
Fields
9
Updated by
1 program
Referenced by
0 programs

ARDUNLTR is a Lawson Accounts Receivable table (prefix DUL); no description in the lawson data dictionary. It is indexed by DUN-PROCESS-CD, DUN-LEVEL (DULSET1). It is updated by AR18.2. The table has 9 fields, 1 index and 0 documented relations.

About ARDUNLTR

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the DUL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#DUL-DUN-PROCESS-CD PK
DUN_PROCESS_CD		Alpha 6Dunning letter process code. A unique code that represents a combination of Dunning Letter options.AR18.2
#DUL-DUN-LEVEL PK
DUN_LEVEL		Numeric 2Number assigned to a set of dunning actions triggered by a timeline within a process code. A process code can have up to 99 dunning levels.AR18.2
#DUL-DAYS-BETWN-LVL
DAYS_BETWN_LVL		Numeric 3Number of days between previous and current dunning letter. For the first level, number of past due days.AR18.2
#DUL-DUN-TEXT-CODE
DUN_TEXT_CODE		Alpha 6Code defining dunning letter text. One code is used to represent a unique letter text and its translations.AR18.2
#DUL-DUN-FEE
DUN_FEE		Signed 18.2—AR18.2
#DUL-DUN-EXTRCT-IND
DUN_EXTRCT_IND		Alpha 1The dunning extract indicator. Specifies whether to extract only dunned invoices or all open invoices for a customer to print on the statement accompanying the dunning letter.
  • 1 Only dunned invoices
  • 2 All open invoices
AR18.2
#DUL-MAILTO-CR-UNIN
MAILTO_CR_UNIN		Alpha 1Specify whether to mail the dunning letter to a customer's credit agency as well as to the customer. The address of the credit agency must be specified in AR10 (Customer).
  • Y Yes
  • N No
AR18.2
#DUL-COLLECTION-LVL
COLLECTION_LVL		Alpha 1Whether the level indicates that the invoice will be turned over to a collection agency.
  • Y Yes
  • N No
AR18.2
#DUL-DUN-FEE-ASSESS
DUN_FEE_ASSESS		Alpha 1Specify where the dunning fee assessment will be printed: 1 - on the dunning letter 2 - on a separate invoice 3 - on a separate late charge notice.
  • 1 Dunning Letter
  • 2 Customer Invoice
  • 3 Interest Charge Invoice
AR18.2

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DULSET1
  1. DUN-PROCESS-CD
  2. DUN-LEVEL
PrimaryAR18.2, AR18.3

Programs

Updated by (1)