Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SICOMP


                              SICOMP FILE

REFERENCED BY

AR09.1    AR09.4    AR10.1    AR11.1    WH130     WH20.2
WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

SCO-CUST-GROUP         Alpha 5
Element: Buyer Group

SCO-DEFAULT-CODE       Alpha 5
Element: Default Code

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

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

SCO-OE-FLAG            Alpha 1
Element: Oe Flag       Y
                       N

SCO-ORDER-TYPE         Alpha 2
Element: Order Type CodThis field contains the order type.

SCO-PROCESS-LEVEL      Alpha 5
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

SCO-INV-LOCATION       Alpha 5
Element: Location Code

SCO-ORDER-SOURCE       Alpha 2
Element: Order Source

SCO-N-UNIT-COST0       Signed 13.5
Element: N Unit Cost0

SCO-N-UNIT-COST1       Signed 13.5
Element: N Unit Cost1

SCO-N-UNIT-COST2       Signed 13.5
Element: N Unit Cost2

SCO-N-UNIT-COST3       Signed 13.5
Element: N Unit Cost3

SCO-N-UNIT-COST4       Signed 13.5
Element: N Unit Cost4

SCO-N-UNIT-COST5       Signed 13.5
Element: N Unit Cost5

SCO-X-UNIT-COST        Signed 13.5
Element: X Unit Cost

SCO-X-UNIT-COST-ND     Numeric 1
Element: X Unit Cost Nd

SCO-UOM                Alpha 4
Element: Unit of MeasurThis field contains the valid stock
                       unit of measure for this item.


SCO-FREIGHT-CODE       Alpha 2
Element: Add On Cost Code

SCO-RESTRICT-FL        Alpha 1
Element: Restrict Fl   Y
                       N

SCO-ORD-RELEASE-FL     Alpha 1
Element: Ord Release FlY
                       N

SCO-AGREE-BILL-FL      Alpha 1
Element: Agree Bill Fl Y
                       N

SCO-INVC-TYPE          Alpha 4
Element: Invoice Type

SCO-INVC-PROC-LEV      Alpha 5
Element: Invc Proc Lev

SCO-INVC-LOC           Alpha 5
Element: Invc Loc

SCO-INVC-UOM           Alpha 4
Element: Invc Uom

                         SICOMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SCOSET1   COMPANY                                                AR09.1  AR10.1
                                                                 AR11.1  WH130
                                                                 WH20.2  WH20.7

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