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    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    AP510     API1.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
IC12.1    IC330     MA180     MA278     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.7
MA53.1    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1
PD10.1    PD10.2    PD130     PD20.1    PD20.2    PD20.3
PO10.1    PO10.2    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     PO234     PO24.1    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    PO32.4    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    POID.1    POII.1    POIJ.1    RQ01.1    RQ10.1
RQ10.2    RQ10.3    RQ11.1    RQ13.2    RQ35.1    RQ44.1
RQ500     RQ810     RQIB.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       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.

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

BYC-REQ-LOCATION       Alpha 5                                   PO04.3
Element: Req 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   AP20.1
          COMPANY                                                AP20.2  AP20.3
          LOCATION                                               AP20.4  AP20.5
          REQ-LOCATION                                           AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...