Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OECUSTITEM


                            OECUSTITEM FILE

                           Customer Item Xref

This file stores cross-reference relationships established between your
company item identifier and your customer's identifier for those items. These
relationships are optional and allow the person entering orders into the
system to use the customer's number when entering line items.

REFERENCED BY

BL122     BL123     BL204     BL80.1    WH126     WH224
BL120     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    WH20.2
WH20.7

UPDATED BY

BL04.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OCI-COMPANY            Numeric 4                                 BL04.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OCI-CUSTOMER           Alpha 9  (Right Justified)                BL04.1
Element: Customer      This field contains the number that
                       represents a customer.

OCI-ITEM               Alpha 32                                  BL04.1  BL120
Element: Item          The item's identifier as set up in the    BL122   BL130
                       Inventory Control system.                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  WH20.2
                                                                 WH20.7

OCI-CUST-ITEM          Alpha 32                                  BL04.1
Element: Item          The customer's number for your
                       inventory item.

OCI-CUST-DESC          Alpha 30                                  BL04.1  BL122
Element: Item Desc     The customer's description for your       WH126   WH224
                       item.

OCI-CUST-ITEM-16       Derived
Element: Cust Item 16  This field contains the 16-character
                       customer number for your item.

OCI-ITEM-16            Derived
Element: Item 16       This field contains the first 16
                       characters of the item's identifier.
                       This information is used by inquiries
                       and reports.

                         OECUSTITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCISET1   COMPANY                                                BL04.1  BL122
          CUSTOMER                                               BL123   BL204
          ITEM                                                   BL80.1  WH126
          CUST-ITEM                                              WH224

OCISET2   COMPANY                                                BL04.1  BL120
          CUSTOMER                                               BL122   BL130
          CUST-ITEM                                              BL20.1  BL20.3
          ITEM                                                   BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  WH20.2
                                                                 WH20.7

                         OECUSTITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            OCI-COMPANY       -> ACO-COMPANY

Arcustgrp      ARCUSTGRP    Required

                            ACO-CUST-GROUP    -> ACG-CUST-GROUP

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP    -> CUD-CUST-GROUP
                            OCI-CUSTOMER      -> CUD-CUSTOMER

Iccompany      ICCOMPANY    Not Required

                            OCI-COMPANY       -> ICC-COMPANY

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP    -> ITE-ITEM-GROUP
                            OCI-ITEM          -> ITE-ITEM

Oecompany      OECOMPANY    Required

                            OCI-COMPANY       -> OEC-COMPANY