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     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    AP510     BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    DR100     IC12.1    IC141
IC142     IC28.1    IC330     IC83.1    MA180     MA278
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    OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE111     OE113
OE114     OE116     OE129     OE13.2    OE13.3    OE13.5
OE13.6    OE14.4    OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE510     OE530
OE81.1    OE810     OE830     OE90.1    OE90.2    PO10.1
PO100     PO101     PO115     PO120     PO122     PO131
PO15.1    PO15.2    PO150     PO20.1    PO204     PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO220     PO224
PO225     PO229     PO23.1    PO23.5    PO230     PO25.1
PO25.6    PO25.7    PO251     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     PO536     POI3.1    POIE.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         The user defined buyer identifier.

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 Code This field contains a valid stocking
                       location within the company inventory.

BYC-REQ-LOCATION       Alpha 5                                   PO04.3
Element: 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  AP30.4
          REQ-LOCATION                                           AP510   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 ...

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  AP30.4
                                                                 AP510   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 ...

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  AP30.4
                                                                 AP510   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 ...

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  AP30.4
                                                                 AP510   BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  DR100
                                                                 IC12.1  IC141
                                                                 IC142   IC28.1
                                                                 IC330   IC83.1
                                                                 MA180   MA278
                                                                 ...