Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BUYCMPLOC


                             BUYCMPLOC FILE

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    AP510     API1.1    DR100
IC12.1    IC141     IC142     IC28.1    IC330     IC83.1
MA180     MA278     MA41.2    MA41.7    MA43.1    MA43.2
MA43.3    MA43.9    MA53.1    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.1
MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1    PO10.1
PO100     PO101     PO115     PO120     PO122     PO131
PO15.1    PO15.2    PO150     PO20.1    PO204     PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO220
PO224     PO225     PO229     PO23.1    PO23.5    PO230
PO25.1    PO25.5    PO25.6    PO25.7    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    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     POI3.1    POII.1    POIJ.1    RQ01.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ35.1    RQ44.1    RQ500
RQ810     RQIB.1    RQIE.1    RQIF.1    RQII.1    RQIJ.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
Element: 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
Element: Buyer

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

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

BYC-REQ-LOCATION       Alpha 5                                   PO04.3
Element: Location Code

                         BUYCMPLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BYCSET1   PROCURE-GROUP                                          AP125   AP126
          BUYER-CODE                                             AP131   AP20.1
          COMPANY                                                AP20.2  AP20.3
          LOCATION                                               AP20.4  AP20.5
          REQ-LOCATION                                           AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 ...

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

BYCSET3   PROCURE-GROUP Subset                                   AP125   AP126
          BUYER-CODE    Where LOCATION     = Spaces              AP131   AP20.1
          COMPANY       And   REQ-LOCATION = Spaces              AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 ...

BYCSET4   PROCURE-GROUP Subset                                   AP125   AP126
          BUYER-CODE    Where LOCATION     != Spaces             AP131   AP20.1
          COMPANY       And   REQ-LOCATION =  Spaces             AP20.2  AP20.3
          LOCATION                                               AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 ...

BYCSET5   PROCURE-GROUP Subset                                   AP125   AP126
          BUYER-CODE    Where REQ-LOCATION != Spaces             AP131   AP20.1
          COMPANY       And   LOCATION     =  Spaces             AP20.2  AP20.3
          REQ-LOCATION                                           AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  AP510
                                                                 API1.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 ...