Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BUYCMPLOC FILE

REFERENCED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    AP510     DR100     IC12.1    IC141     IC142
IC28.1    IC330     IC83.1    MA180     MA278     MA43.9
MA53.1    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA66.3    MA67.1    MA67.2    MA70.1    MAI1.1
PO10.1    PO100     PO101     PO120     PO122     PO131
PO15.1    PO15.2    PO150     PO20.1    PO204     PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO220     PO223
PO224     PO225     PO23.1    PO23.5    PO230     PO25.2
PO251     PO27.2    PO275     PO276     PO277     PO280
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO33.1    PO34.1    PO35.1    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
POI3.1    POIE.1    POII.1    POIJ.1    RQ01.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ35.1    RQ44.1    RQ500
RQ810     RQIB.1    RQIF.1    WH20.2    WH20.7    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                                          AP125   AP126
          BUYER-CODE                                             AP131   AP25.1
          COMPANY                                                AP25.2  AP26.1
          LOCATION                                               AP27.1  AP510
          REQ-LOCATION                                           DR100   IC12.1
                                                                 IC141   IC142
                                                                 IC28.1  IC330
                                                                 IC83.1  MA180
                                                                 MA278   MA43.9
                                                                 MA53.1  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 ...

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

BYCSET3   PROCURE-GROUP Subset                                   AP125   AP126
          BUYER-CODE    Where LOCATION     = Spaces              AP131   AP25.1
          COMPANY       And   REQ-LOCATION = Spaces              AP25.2  AP26.1
                                                                 AP27.1  AP510
                                                                 DR100   IC12.1
                                                                 IC141   IC142
                                                                 IC28.1  IC330
                                                                 IC83.1  MA180
                                                                 MA278   MA43.9
                                                                 MA53.1  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 ...

BYCSET4   PROCURE-GROUP Subset                                   AP125   AP126
          BUYER-CODE    Where LOCATION     != Spaces             AP131   AP25.1
          COMPANY       And   REQ-LOCATION =  Spaces             AP25.2  AP26.1
          LOCATION                                               AP27.1  AP510
                                                                 DR100   IC12.1
                                                                 IC141   IC142
                                                                 IC28.1  IC330
                                                                 IC83.1  MA180
                                                                 MA278   MA43.9
                                                                 MA53.1  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 ...

BYCSET5   PROCURE-GROUP Subset                                   AP125   AP126
          BUYER-CODE    Where REQ-LOCATION != Spaces             AP131   AP25.1
          COMPANY       And   LOCATION     =  Spaces             AP25.2  AP26.1
          REQ-LOCATION                                           AP27.1  AP510
                                                                 DR100   IC12.1
                                                                 IC141   IC142
                                                                 IC28.1  IC330
                                                                 IC83.1  MA180
                                                                 MA278   MA43.9
                                                                 MA53.1  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 ...