Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARCDSELECT FILE

                           AR Credit Selects

The AR Credit Selects file contains customer records that have been selected
for credit review or dunning letter generation via AR170 (Customer Review
Selection) or AR160 (Dunning Letter Creation).

UPDATED BY

AR06.1    AR160     AR161     AR17.1    AR170     AR70.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SEL-COMPANY          Numeric 4                                   AR160   AR17.1
Company              The company number represents an            AR170   AR70.2
                     established company and is entered on
                     all function codes.

SEL-CREDIT-ANLYST    Alpha 4                                     AR160   AR17.1
Credit Analyst       Credit analyst assigned to the selected     AR170   AR70.2
                     customer.

SEL-DATE             Numeric 8  (yyyymmdd)                       AR160   AR17.1
Date                 System date this customer was selected      AR170   AR70.2
                     via AR170 (Customer Review Selection) or
                     AR160 (Dunning Letter Creation).

SEL-SYS-TIME         Numeric 6  (hhmmss)                         AR160   AR17.1
System Time          System time this customer record was        AR170   AR70.2
                     selected via AR170 (Customer Review
                     Selection) or AR160 (Dunning Letter
                     Creation)

SEL-CUSTOMER         Alpha 9  (Right Justified)                  AR160   AR17.1
Customer             Customer number of the selected             AR170   AR70.2
                     customer.

SEL-SELECT-LEVEL     Alpha 1                                     AR160   AR17.1
Selection Level      Indicates the level of the selection.       AR170   AR70.2
                     Valid values are:

                     C = Company level
                     N = National account level

SEL-STATUS           Numeric 1                                   AR160   AR17.1
Record Status        Status of the selected customer record.     AR70.2
                     Valid values are:

                     0 = Open status - needs review
                     2 = Reviewed
                     9 = AR160 (Dunning Letter Creation)
                     source



SEL-CRED-ACTION      Alpha 1                                     AR160   AR70.2
Credit Action        Indicates 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        Alpha 1                                     AR160   AR70.2
On Hold Flag         This indicates whether or not the
                     customer was put on credit hold. Valid
                     values are:

                     N = Not put on hold
                     Y = Credit hold on customer

SEL-DUNNING-NBR      Numeric 2                                   AR160   AR161
Dunning Number       Indicates whether a dunning letter          AR17.1  AR70.2
                     (past due notice) is to be created. If a
                     dunning letter is to be printed, this
                     field will be greater than 00.

SEL-NEW-REVIEW       Numeric 8  (yyyymmdd)                       AR160   AR70.2
Next Review Date     Date user can specify indicating when
                     this customer should next be reviewed.

SEL-REVIEW-FL        Alpha 1                                     AR160   AR170
Review Flag          This flag will indicate if the customer     AR70.2
                     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

SEL-TYPE             Alpha 2                                     AR160   AR170
Review Reason        Identifies 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
                      1 = Review date reached
                      2 = Credit limit date review
                      3 = Exceeded credit limit
                      4 = Exceeded aging limit

                         ARCDSELECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SELSET1   COMPANY       This is the primary path used to access  AR06.1  AR170
          CREDIT-ANLYST credit select records.
          DATE
          SYS-TIME
          CUSTOMER
          SELECT-LEVEL

SELSET2   COMPANY       This path is used to access those        AR70.1  AR70.2
          CREDIT-ANLYST credit select records which have not
          DATE          been reviewed for display online.
          SYS-TIME      Subset
          CUSTOMER      Where STATUS = Zeroes
          SELECT-LEVEL

SELSET3   COMPANY       This path is used to access those        AR170   AR70.2
          CREDIT-ANLYST credit select records which have not
          CUSTOMER      been reviewed for batch processing.
          SELECT-LEVEL  Subset
                        Where STATUS = Zeroes

SELSET4   COMPANY       This path is used to process credit      AR160   AR161
          CUSTOMER      select records which will produce        AR17.1  AR70.2
          SELECT-LEVEL  dunning letters.
                        Subset
                        Where DUNNING-NBR > Zeroes

                         ARCDSELECT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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