Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BUYCMPLOC FILE

REFERENCED BY

AP510     DR100     IC12.1    IC141     IC142     IC330
IC83.1    MA278     MA53.1    PO10.1    PO120     PO15.1
PO15.2    PO204     PO220     PO223     PO224     PO225
PO230     PO251     PO275     PO276     PO277     PO280
PO61.1    POIJ.1    RQ01.1    RQ11.1    RQ44.1    RQ810
PO01.1

UPDATED BY

PO04.1    PO04.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BYC-PROCURE-GROUP    Alpha 4                                     PO04.3
Procure Group        This field contains the identifier for a
                     group of companies that share a common
                     procurement effort. They buy items and
                     services together.

BYC-BUYER-CODE       Alpha 3                                     PO04.3
Buyer Code           The user defined buyer identifier.

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

BYC-LOCATION         Alpha 5                                     PO04.3
Location Code        This field contains a valid stocking
                     location within the company inventory.

BYC-REQ-LOCATION     Alpha 5                                     PO04.3
To Location          The location requisitioning items.
                     This location can be an inventory or
                     noninventory location.

                         BUYCMPLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BYCSET1   PROCURE-GROUP                                          AP510   DR100
          BUYER-CODE                                             IC12.1  IC141
          COMPANY                                                IC142   IC330
          LOCATION                                               IC83.1  MA278
          REQ-LOCATION                                           MA53.1  PO04.1
                                                                 PO04.3  PO10.1
                                                                 PO120   PO15.1
                                                                 PO15.2  PO204
                                                                 PO220   PO223
                                                                 PO224   PO225
                                                                 PO230   PO251
                                                                 PO275   PO276
                                                                 PO277   PO280
                                                                 PO61.1  POIJ.1
                                                                 RQ01.1  RQ11.1
                                                                 ...

BYCSET2   PROCURE-GROUP                                          PO01.1
          COMPANY
          BUYER-CODE
          LOCATION
          REQ-LOCATION

BYCSET3   PROCURE-GROUP Subset                                   AP510   DR100
          BUYER-CODE    Where LOCATION     = Spaces              IC12.1  IC141
          COMPANY       And   REQ-LOCATION = Spaces              IC142   IC330
                                                                 IC83.1  MA278
                                                                 MA53.1  PO10.1
                                                                 PO120   PO15.1
                                                                 PO15.2  PO204
                                                                 PO220   PO223
                                                                 PO224   PO225
                                                                 PO230   PO251
                                                                 PO275   PO276
                                                                 PO277   PO280
                                                                 PO61.1  POIJ.1
                                                                 RQ01.1  RQ11.1
                                                                 RQ44.1  RQ810

BYCSET4   PROCURE-GROUP Subset                                   AP510   DR100
          BUYER-CODE    Where LOCATION     != Spaces             IC12.1  IC141
          COMPANY       And   REQ-LOCATION =  Spaces             IC142   IC330
          LOCATION                                               IC83.1  MA278
                                                                 MA53.1  PO10.1
                                                                 PO120   PO15.1
                                                                 PO15.2  PO204
                                                                 PO220   PO223
                                                                 PO224   PO225
                                                                 PO230   PO251
                                                                 PO275   PO276
                                                                 PO277   PO280
                                                                 PO61.1  POIJ.1
                                                                 RQ01.1  RQ11.1
                                                                 RQ44.1  RQ810

BYCSET5   PROCURE-GROUP Subset                                   AP510   DR100
          BUYER-CODE    Where REQ-LOCATION != Spaces             IC12.1  IC141
          COMPANY       And   LOCATION     =  Spaces             IC142   IC330
          REQ-LOCATION                                           IC83.1  MA278
                                                                 MA53.1  PO10.1
                                                                 PO120   PO15.1
                                                                 PO15.2  PO204
                                                                 PO220   PO223
                                                                 PO224   PO225
                                                                 PO230   PO251
                                                                 PO275   PO276
                                                                 PO277   PO280
                                                                 PO61.1  POIJ.1
                                                                 RQ01.1  RQ11.1
                                                                 RQ44.1  RQ810