Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCUSTTOTS


                            ARCUSTTOTS FILE

                       AR Customer PL Inclusions

The AR Customer Process Level Inclusions file will hold the information
regarding a customer's inclusion Process Levels for invoicing (maintained and
created in  AR10.2 (Customer Process Level Inclusions).  If a set of
inclusion Process Levels is defined, only open items with Process Level values
within the inclusion set will be allowed to be added.

REFERENCED BY

AC56.1    AC560     AR219     AR42.1    AR42.2    AR42.6
AR42.7    AR43.1    AR44.3    AR48.1    AR48.3    AR502
AR560     ARLL.1    BL02.1    BL04.1    BL10.1    BL120
BL121     BL122     BL123     BL125     BL130     BL20.1
BL20.3    BL20.6    BL202     BL204     BL21.2    BL21.5
BL217     BL220     BL231     BL246     BL29.1    BL29.2
BL290     BL291     BL31.1    BL31.2    BL31.3    BL31.5
BL31.7    BL32.3    BL32.4    BL33.1    BL331     BL34.1
BL46.1    BL46.2    BL520     BL530     BL546     BL80.1
BL80.3    BL802     BL81.1    BL82.1    BL820     BL85.1
BL85.2    BL90.1    BL92.1    BR00.1    BR00.2    BR02.3
BR10.1    BR10.9    BR11.1    BR120     BR121     BR122
BR123     BR140     BR151     BR152     BR155     BR156
BR16.1    BR16.2    BR17.1    BR180     BR19.1    BR20.1
BR20.2    BR20.3    BR20.4    BR20.5    BR20.7    BR21.2
BR210     BR211     BR216     BR217     BR220     BR251
BR252     BR253     BR400     BR420     BR45.1    BR450
BR46.1    BR46.2    BR46.4    BR51.1    BR51.2    BR52.1
BR52.2    BR521     BR53.1    BR55.2    BR70.1    BR70.2
BR91.1    BRIP.1    CB06.2    DT150     DT155     DT160
DT165     DT166     DT180     DT30.1    DT30.2    DT40.1
DT45.1    DT520     DT60.1    DT60.2    DT70.1    DT70.3
DT80.1    DT85.1    DT85.2    DT92.1    IC02.1    PW110
TX140     TX40.1    WH110     WH120     WH130     WH132
WH190     WH20.1    WH20.2    WH20.7    WH21.2    WH224
WH226     WH30.1    WH30.2    WH30.3    WH30.4    WH31.1
WH31.2    WH31.3    WH31.4    WH32.1    WH32.2    WH32.3
WH32.4    WH33.5    WH34.1    WH34.2    WH34.3    WH34.4
WH40.1    WH40.2    WH520     WH830

UPDATED BY

AR10.1    AR10.2    AR301

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CUT-COMPANY            Numeric 4                                 AR10.2
Element: Company       The number representing an AR company.

CUT-CUSTOMER           Alpha 9  (Right Justified)                AR10.2
Element: Customer      Customer number.

CUT-PROCESS-LEVEL      Alpha 5                                   AR10.2
Element: Process Level Process Level that is included
                       (invoicing restricted to) for invoicing.


CUT-PL-EXCL-FL         Alpha 1                                   AR10.2
Process Level          Process level exclusion flag. Used in
Exclusion              conjunction with the process level
                       inclusion flag in the customer file.
                       Valid values are:

                       I = Process level invoice allowed
                       Blank = Process level invoice not
                       allowed

                         ARCUSTTOTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CUTSET1   COMPANY                                                AC56.1  AC560
          CUSTOMER                                               AR10.1  AR10.2
          PROCESS-LEVEL                                          AR219   AR301
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.1  AR48.3
                                                                 AR502   AR560
                                                                 ARLL.1  BL02.1
                                                                 BL04.1  BL10.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL125   BL130
                                                                 BL20.1  BL20.3
                                                                 BL20.6  BL202
                                                                 ...

                         ARCUSTTOTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            CUT-COMPANY          -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            CUT-COMPANY          -> ACM-COMPANY
                            CUT-CUSTOMER         -> ACM-CUSTOMER

Arproclevl     ARPROCLEVL   Required

                            CUT-COMPANY          -> APV-COMPANY
                            CUT-PROCESS-LEVEL    -> APV-PROCESS-LEVEL

Customername   CUSTDESC     Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            ACM-CUSTOMER         -> CUD-CUSTOMER