Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCYCLE


                              ARCYCLE FILE

                        AR Statement Cycle Code

The AR Cycle Code file stores the valid customer statement cycle information
established in AR04 (Cycle Codes). Cycles are user defined and are assigned to
each individual customer by adding the cycle code (an element of this file) to
the customer master record.

REFERENCED BY

AR08.1    AR10.1    AR137     AR150     AR160     AR161
AR204     AR501     AR550     DT150

UPDATED BY

AR01.1    AR04.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACY-COMPANY            Numeric 4                                 AR01.1  AR04.1
Element: Company       Company number.

ACY-CYCLE-TYPE         Alpha 1                                   AR01.1  AR04.1
Element: Cycle Type    Indicates the cycle code type. Valid
                       values are:

                       B = Balance Forward
                       O = Open Item
                       D = Dunning Notice
                       F = Finance Charge

ACY-CYCLE              Alpha 2                                   AR01.1  AR04.1
Element: Cycle Code    Cycle code.

ACY-CYCLE-RANGE1       Alpha 1                                   AR04.1
Element: Cycle Range 1 Valid only for statement cycle codes
                       for balance forward customers. This is
                       the first value, of the first letter, of
                       the customer search name which
                       determines the beginning alpha sort
                       range to assign statement cycle codes.

ACY-CYCLE-RANGE2       Alpha 1                                   AR04.1
Element: Cycle Range 2 Valid only for statement cycle codes
                       for balance forward customers. This
                       ending value, of the first letter, of
                       the customer search name which
                       determines the ending alpha sort range
                       to assign statement cycle codes.

                         ARCYCLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACYSET1   COMPANY       The path is used to keep the records     AR01.1  AR04.1
          CYCLE-TYPE    unique.                                  AR08.1  AR10.1
          CYCLE                                                  AR137   AR150
                                                                 AR160   AR161
                                                                 AR204   AR501
                                                                 AR550   DT150