Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCDSELECT


                            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
Element: 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
Element: Credit AnalystCredit analyst assigned to the selected   AR170   AR70.2
                       customer.

SEL-DATE               Numeric 8  (yyyymmdd)                     AR160   AR17.1
Element: 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
Element: 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
Element: Customer      Customer number of the selected           AR170   AR70.2
                       customer.

SEL-SELECT-LEVEL       Alpha 1                                   AR160   AR17.1
Element: Selection LeveIndicates 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
Element: 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) or
                       AR17 (Comments) source

SEL-CRED-ACTION        Alpha 1                                   AR160   AR70.2
Element: 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   AR17.1
Element: On Hold Flag  This indicates whether or not the         AR170   AR70.2
                       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
Element: Dunning NumberIndicates 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
Element: Next Review DaDate user can specify indicating when
                       this customer should next be reviewed.

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