Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              SICOMP FILE

REFERENCED BY

AR10.1    AR11.1    AR09.1    AR09.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SCO-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.


SCO-CUST-GROUP       Alpha 5
Customer Group       Customer group. Used to identify a
                     group of customer associated with one or
                     more companies.

SCO-DEFAULT-CODE     Alpha 5
Default Code

SCO-HOLD-CODE        Alpha 4
Hold Code            The hold code.

SCO-MAN-NBR-METHOD   Numeric 1
Man Nbr Method       0 = Auto Customer Numbering
                     1 = Defined Prefix/Range
                     2 = Custom User Exit
                     3 = Entry in Cust Conversion Rec

                         SICOMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SCOSET1   COMPANY                                                AR10.1  AR11.1

SCOSET2   CUST-GROUP    KeyChange                                AR09.1  AR09.4
          COMPANY

                         SICOMP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            SCO-COMPANY       -> ACO-COMPANY

Arcustgrp      ARCUSTGRP    Required

                            SCO-CUST-GROUP    -> ACG-CUST-GROUP