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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
SEL-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | AR17.1 |
SEL-CREDIT-ANLYST PKCREDIT_ANLYST | Alpha 4 | Credit analyst assigned to the selected customer. | AR17.1 |
SEL-DATE PKDATE | Numeric 8 (yyyymmdd) | System date this customer was selected via AR170 (Customer Review Selection) or AR160 (Dunning Letter Creation). | AR17.1 |
SEL-SYS-TIME PKSYS_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 PKCUSTOMER | Alpha 9 (Right Justified) | Customer number of the selected customer. | AR17.1 |
SEL-SELECT-LEVEL PKSELECT_LEVEL | Alpha 1 | Indicates the level of the selection. Valid values are:
| AR17.1 |
SEL-STATUSSTATUS | Numeric 1 | Status of the selected customer record. Valid values are: Comments (AR17.1) source
| AR17.1 |
SEL-CRED-ACTIONCRED_ACTION | Alpha 1 | Indicates what action the analyst took when reviewing the selected customer's credit review record. Valid values are:
| — |
SEL-HOLD-FLAGHOLD_FLAG | Alpha 1 | This indicates whether or not the customer was put on credit hold. Valid values are:
| AR17.1 |
SEL-DUNNING-NBRDUNNING_NBR | Numeric 2 | Indicates 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-REVIEWNEW_REVIEW | Numeric 8 (yyyymmdd) | Date user can specify indicating when this customer should next be reviewed. | — |
SEL-REVIEW-FLREVIEW_FL | Alpha 1 | This 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:
| AR17.1 |
SEL-TYPETYPE | Alpha 2 | Identifies the reason the record was selected. It will be updated by AR160 (Dunning Letter Creation), and AR170 (Customer Review Selection). Valid values are:
| — |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
SELSET1 | COMPANY, CREDIT-ANLYST, DATE, SYS-TIME, CUSTOMER, SELECT-LEVEL | Primary | AR06.1 | |
SELSET2 | COMPANY, CREDIT-ANLYST, DATE, SYS-TIME, CUSTOMER, SELECT-LEVEL | Subset | Where STATUS = Zeroes | — |
SELSET3 | COMPANY, CREDIT-ANLYST, CUSTOMER, SELECT-LEVEL | Subset | Where STATUS = Zeroes | — |
SELSET4 | COMPANY, CUSTOMER, SELECT-LEVEL | Subset | Where DUNNING-NBR > Zeroes | AR17.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Aranalyst | CRANALYST | Required | SEL-COMPANY → CAN-COMPANY, SEL-CREDIT-ANLYST → CAN-CREDIT-ANLYST | |
| Arcomp | ARCOMP | Required | SEL-COMPANY → ACO-COMPANY | |
| Arcustomer | ARCUSTOMER | Required | SEL-COMPANY → ACM-COMPANY, SEL-CUSTOMER → ACM-CUSTOMER | |
| Custdesc | CUSTDESC | Required | ACO-CUST-GROUP → CUD-CUST-GROUP, SEL-CUSTOMER → CUD-CUSTOMER |