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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BYCSET1PROCURE-GROUP, BUYER-CODE, COMPANY, LOCATION, REQ-LOCATIONPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
BYCSET2PROCURE-GROUP, COMPANY, BUYER-CODE, LOCATION, REQ-LOCATIONPO01.1
BYCSET3PROCURE-GROUP, BUYER-CODE, COMPANYSubsetWhere LOCATION = Spaces And REQ-LOCATION = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
BYCSET4PROCURE-GROUP, BUYER-CODE, COMPANY, LOCATIONSubsetWhere LOCATION != Spaces And REQ-LOCATION = SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
BYCSET5PROCURE-GROUP, BUYER-CODE, COMPANY, REQ-LOCATIONSubsetWhere 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)