BUYER – PO Buyer Master

System
Purchase Order (PO)
Prefix
BUY
Primary key
PROCURE-GROUP, BUYER-CODE
Fields
50
Updated by
223 programs
Referenced by
50 programs

BUYER is the PO Buyer Master table in Lawson Purchase Order (prefix BUY). It is indexed by PROCURE-GROUP, BUYER-CODE (BUYSET1); alternate indexes: BUYSET2, BUYSET3 and BUYSET4. It is related 1:1 to BUYBOD, GLNLOC, GLNLOCDTL and PROCUREGRP and 1:M to BUYCLASS, BUYCMPLOC and BUYVENPF. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 215 more and referenced by AP06.1, AP205, CX55.1, IC10.1, IC10.2, IC130, IC226, IC258 and 42 more. The table has 50 fields, 4 indexes and 7 documented relations.

About BUYER

A file of valid buyers. Contains default and control information.

Fields (50)

Column = COBOL field name without the BUY- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BUY-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-BUYER-CODE PK
BUYER_CODE
Alpha 3The user-defined buyer identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-OPERATOR-ID
OPERATOR_ID
Alpha 10This field is used to store the login id of the person who entered the record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-BUYER-GRP
BUYER_GRP
Alpha 5The buyer's buyer group code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-NAME
NAME
Alpha 30 (Lower Case)The buyer's name.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-ADDR1
ADDR1
Alpha 30 (Lower Case)The buyer's first line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-ADDR2
ADDR2
Alpha 30 (Lower Case)The buyer's second line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-ADDR3
ADDR3
Alpha 30 (Lower Case)The buyer's third line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-ADDR4
ADDR4
Alpha 30 (Lower Case)The buyer's fourth line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-CITY-ADDR5
CITY_ADDR5
Alpha 18 (Lower Case)This is the buyer's city or the fifth line of address information.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-STATE-PROV
STATE_PROV
Alpha 2This is the buyer's state or province.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-POSTAL-CODE
POSTAL_CODE
Alpha 10 (Lower Case)This is the buyer's mail code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-COUNTRY
COUNTRY
Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-PHONE-PREFIX
PHONE_PREFIX
Alpha 6The buyer's telephone prefix.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-PHONE
PHONE
Alpha 15The buyer's telephone number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-PHONE-EXT
PHONE_EXT
Alpha 5The buyer's telephone extension number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-PO-LIMIT
PO_LIMIT
Signed 18.2The buyer's per purchase order amount limit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-CLASS-ONLY-FL
CLASS_ONLY_FL
Alpha 1
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-BUYER-CODE
FIL_BUYER_CODE
Alpha 1" "
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-BUY-PUR-CL
FIL_BUY_PUR_CL
Alpha 1" "
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-BUY-VEN-FL
FIL_BUY_VEN_FL
Alpha 1" "
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-BUY-LOC-FL
FIL_BUY_LOC_FL
Alpha 1" "
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-BUY-RQL-FL
FIL_BUY_RQL_FL
Alpha 1" "
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-VEN-OPTION
FIL_VEN_OPTION
Alpha 1" "
  • Y Items with no vendor
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-DEL-DAYS
FIL_DEL_DAYS
Numeric 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-FRM-PRI
FIL_FRM_PRI
Numeric 2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-TO-PRI
FIL_TO_PRI
Numeric 2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-NO-COST
FIL_NO_COST
Alpha 1" "
  • Y Items with no cost
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-PO-CODE
FIL_PO_CODE
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-MANUF-CODE
FIL_MANUF_CODE
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-MANUF-DIV
FIL_MANUF_DIV
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-AGRMT
FIL_AGRMT
Alpha 30AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FIL-ITEM-TYPE
FIL_ITEM_TYPE
Alpha 1
  • I Inventory
  • N Non Stock
  • X Special
  • S Service
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-MAN-OVER-ALWD
MAN_OVER_ALWD
Alpha 1If set to "Y", this field indicates that unit costs manually entered for a Purchase will be "held" and not overridden by the cost default routine.
  • Y Yes
  • N No
BUY-OVER-AGRMT
OVER_AGRMT
Alpha 1Enter a Y to indicate the user can manually enter a cost which will not be overridden by an existing price agreement.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-OVER-LC-LP
OVER_LC_LP
Alpha 1Enter a Y to indicate the user can manually enter a cost which will not be overridden by a last cost or last PO created cost default.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-EMAIL-ADDRESS
EMAIL_ADDRESS
Alpha 60 (Lower Case)e-mail address.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-BUY-OBJ-ID
BUY_OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-REQ-COMM-CODE
REQ_COMM_CODE
Numeric 1
  • 0 Commodity Code Not Required
  • 1 Commodity Code Required
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-P-CARD-FLAG
P_CARD_FLAG
Numeric 1
BUY-PCARD-NBR
PCARD_NBR
Alpha 16
BUY-OVER-PCARD
OVER_PCARD
Numeric 1
BUY-OVER-SS
OVER_SS
Alpha 1" " = No
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FAX-PREFIX
FAX_PREFIX
Alpha 6AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FAX-NUMBER
FAX_NUMBER
Alpha 15AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-FAX-EXT
FAX_EXT
Alpha 5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-GLN-NBR
GLN_NBR
Alpha 13AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-APPROVE-CD
APPROVE_CD
Alpha 5This is a code to identify the approval process (levels) that a purchase order has to pass before it can be released. PO approval codes are defined in PO08.1 (PO Approval Codes). Each buyer is required to have a PO approval code assigned to it. Depending on the total amount of the order, the purchase order may need to be approved by the necessary approval levels.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
BUY-APPROVAL-TYPE
APPROVAL_TYPE
Alpha 1The type of approval record. " " = Use value from IC Loc or PO Co
  • 0 Header approval-PO approval cd
  • 1 Header approval-Process Flow
  • 2 No approvals required
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BUYSET1PROCURE-GROUP, BUYER-CODEPrimaryAP06.1, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
BUYSET2PROCURE-GROUP, BUYER-GRP, BUYER-CODEKeyChangeMA278, PO04.1, PO115, PO120, PO15.1, PO15.2, PO15.4, PO204 +22 more
BUYSET3PROCURE-GROUP, OPERATOR-IDKeyChange, SubsetWhere OPERATOR-ID != SpacesPO04.1, PO23.1, POII.1, POIJ.1
BUYSET4BUY-OBJ-IDKeyChange, SubsetWhere BUY-OBJ-ID != ZeroesMX223, MX500, PO04.7, PO04.8, PO220, PO222, PO258, PO285 +3 more

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
BuybodBUYBODNot Required, Delete CascadesBUY-PROCURE-GROUPPBA-PROCURE-GROUP, BUY-BUYER-CODEPBA-BUYER-CODE
GlnlocGLNLOCNot RequiredValid When BUY-GLN-NBR != SpacesPCG-ITEM-GROUPGLO-ITEM-GROUP, BUY-GLN-NBRGLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When BUY-GLN-NBR != SpacesPCG-ITEM-GROUPGLX-ITEM-GROUP, 12GLX-GLN-TYPE, BUY-BUYER-CODEGLX-BUYER-CODE, BUY-GLN-NBRGLX-GLN-NBR
ProcuregrpPROCUREGRPNot RequiredBUY-PROCURE-GROUPPCG-PROCURE-GROUP

One to many (3) — child tables

RelationTableRulesConditionField map
BuyclassBUYCLASSBUY-PROCURE-GROUPBCL-PROCURE-GROUP, BUY-BUYER-CODEBCL-BUYER-CODE, BCL-PURCH-MAJCL, BCL-PURCH-MINCL
BuycmplocBUYCMPLOCBUY-PROCURE-GROUPBYC-PROCURE-GROUP, BUY-BUYER-CODEBYC-BUYER-CODE, BYC-COMPANY, BYC-LOCATION, BYC-REQ-LOCATION
BuyvenpfBUYVENPFBUY-PROCURE-GROUPBVP-PROCURE-GROUP, BUY-BUYER-CODEBVP-BUYER-CODE, BVP-VENDOR, BVP-PURCH-FR-LOC

Programs

Updated by (223)

Referenced by (50)