BUYCMPLOC – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
BYC
Primary key
PROCURE-GROUP, BUYER-CODE, COMPANY, LOCATION, REQ-LOCATION
Fields
5
Updated by
2 programs
Referenced by
220 programs

BUYCMPLOC is a Lawson Purchase Order table (prefix BYC); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, BUYER-CODE, COMPANY, LOCATION, REQ-LOCATION (BYCSET1); alternate indexes: BYCSET2, BYCSET3, BYCSET4 and BYCSET5. It is updated by PO04.1 and PO04.3 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 212 more. The table has 5 fields, 5 indexes and 0 documented relations.

About BUYCMPLOC

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the BYC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BYC-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.PO04.3
#BYC-BUYER-CODE PK
BUYER_CODE		Alpha 3—PO04.3
#BYC-COMPANY PK
COMPANY		Numeric 4Identifies 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.PO04.3
#BYC-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.PO04.3
#BYC-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.PO04.3

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BYCSET1
  1. PROCURE-GROUP
  2. BUYER-CODE
  3. COMPANY
  4. LOCATION
  5. REQ-LOCATION
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
BYCSET2
  1. PROCURE-GROUP
  2. COMPANY
  3. BUYER-CODE
  4. LOCATION
  5. REQ-LOCATION
PO01.1
BYCSET3
  1. PROCURE-GROUP
  2. BUYER-CODE
  3. COMPANY
SubsetWhere LOCATION = Spaces And REQ-LOCATION = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
BYCSET4
  1. PROCURE-GROUP
  2. BUYER-CODE
  3. COMPANY
  4. LOCATION
SubsetWhere LOCATION != Spaces And REQ-LOCATION = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
BYCSET5
  1. PROCURE-GROUP
  2. BUYER-CODE
  3. COMPANY
  4. REQ-LOCATION
SubsetWhere REQ-LOCATION != Spaces And LOCATION = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (2)

Referenced by (220)