ARCDSELECT – AR Credit Selects

System
Accounts Receivable (AR)
Prefix
SEL
Primary key
COMPANY, CREDIT-ANLYST, DATE, SYS-TIME, CUSTOMER, SELECT-LEVEL
Fields
13
Updated by
2 programs
Referenced by
0 programs

ARCDSELECT is the AR Credit Selects table in Lawson Accounts Receivable (prefix SEL). It is indexed by COMPANY, CREDIT-ANLYST, DATE, SYS-TIME, CUSTOMER, SELECT-LEVEL (SELSET1); alternate indexes: SELSET2, SELSET3 and SELSET4. It is related 1:1 to CRANALYST, ARCOMP, ARCUSTOMER and CUSTDESC. It is updated by AR06.1 and AR17.1. The table has 13 fields, 4 indexes and 4 documented relations.

About ARCDSELECT

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the SEL- 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
#SEL-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR17.1
#SEL-CREDIT-ANLYST PK
CREDIT_ANLYST		Alpha 4Credit analyst assigned to the selected customer.AR17.1
#SEL-DATE PK
DATE		Numeric 8 (yyyymmdd)System date this customer was selected via AR170 (Customer Review Selection) or AR160 (Dunning Letter Creation).AR17.1
#SEL-SYS-TIME PK
SYS_TIME		Numeric 6 (hhmmss)System time this customer record was selected via AR170 (Customer Review Selection) or AR160 (Dunning Letter Creation)AR17.1
#SEL-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Customer number of the selected customer.AR17.1
#SEL-SELECT-LEVEL PK
SELECT_LEVEL		Alpha 1Indicates the level of the selection. Valid values are:
  • C Company level
  • N National account level
AR17.1
#SEL-STATUS
STATUS		Numeric 1Status of the selected customer record. Valid values are: Comments (AR17.1) source
  • 0 Open status - needs review
  • 2 Reviewed
  • 9 Dunning Letter Select (AR160) or
AR17.1
#SEL-CRED-ACTION
CRED_ACTION		Alpha 1Indicates what action the analyst took when reviewing the selected customer's credit review record. Valid values are:
  • C Called
  • N No problem
  • O Other action
—
#SEL-HOLD-FLAG
HOLD_FLAG		Alpha 1This indicates whether or not the customer was put on credit hold. Valid values are:
  • N Not put on hold
  • Y Credit hold on customer
AR17.1
#SEL-DUNNING-NBR
DUNNING_NBR		Numeric 2Indicates whether a dunning letter (past due notice) is to be created. If a dunning letter is to be printed, this field will be greater than 00.AR17.1
#SEL-NEW-REVIEW
NEW_REVIEW		Numeric 8 (yyyymmdd)Date user can specify indicating when this customer should next be reviewed.—
#SEL-REVIEW-FL
REVIEW_FL		Alpha 1This flag will indicate if the customer credit limit was reviewed. If it was, the system date will be moved to the Credit Limit Date field in the customer file. Valid values are:
  • N Credit Limit not reviewed
  • Y Credit Limit was reviewed
AR17.1
#SEL-TYPE
TYPE		Alpha 2Identifies the reason the record was selected. It will be updated by AR160 (Dunning Letter Creation), and AR170 (Customer Review Selection). Valid values are:
  • 1 Review date reached
  • 2 Credit limit date review
  • 3 Exceeded credit limit
  • 4 Exceeded aging limit
—

Indexes (4)

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
SELSET1
  1. COMPANY
  2. CREDIT-ANLYST
  3. DATE
  4. SYS-TIME
  5. CUSTOMER
  6. SELECT-LEVEL
PrimaryAR06.1
SELSET2
  1. COMPANY
  2. CREDIT-ANLYST
  3. DATE
  4. SYS-TIME
  5. CUSTOMER
  6. SELECT-LEVEL
SubsetWhere STATUS = Zeroes—
SELSET3
  1. COMPANY
  2. CREDIT-ANLYST
  3. CUSTOMER
  4. SELECT-LEVEL
SubsetWhere STATUS = Zeroes—
SELSET4
  1. COMPANY
  2. CUSTOMER
  3. SELECT-LEVEL
SubsetWhere DUNNING-NBR > ZeroesAR17.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CRANALYSTARCOMPARCUSTOMERCUSTDESCARCDSELECT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
AranalystCRANALYSTRequired
SEL-COMPANY→CAN-COMPANY
SEL-CREDIT-ANLYST→CAN-CREDIT-ANLYST
ArcompARCOMPRequired
SEL-COMPANY→ACO-COMPANY
ArcustomerARCUSTOMERRequired
SEL-COMPANY→ACM-COMPANY
SEL-CUSTOMER→ACM-CUSTOMER
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
SEL-CUSTOMER→CUD-CUSTOMER

Programs

Updated by (2)