PDCARDUSER – Merchant

System
Purchase Order (PO)
Prefix
PCU
Primary key
PROCURE-GROUP, CARD-USER-ID
Fields
16
Updated by
3 programs
Referenced by
9 programs

PDCARDUSER is the Merchant table in Lawson Purchase Order (prefix PCU). It is indexed by PROCURE-GROUP, CARD-USER-ID (PCUSET1). It is related 1:M to PDCARD. It is updated by PD00.1, PD01.1 and PD10.2 and referenced by PD20.1, PD20.2, PD20.3, PD210, PD230, PD235, PD261, PD57.1 and 1 more. The table has 16 fields, 1 index and 2 documented relations.

About PDCARDUSER

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the PCU- 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
#PCU-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together.PD00.1, PD01.1, PD10.2
#PCU-CARD-USER-ID PK
CARD_USER_ID		Alpha 10 (Lower Case)—PD00.1, PD01.1, PD10.2
#PCU-NAME
NAME		Alpha 30 (Lower Case)This field contains the name of the Procurement Card user, administrator or proxy.PD00.1, PD01.1, PD10.2
#PCU-INT-PREFIX
INT_PREFIX		Alpha 6—PD00.1, PD01.1, PD10.2
#PCU-PHONE-NMBR
PHONE_NMBR		Alpha 15—PD00.1, PD01.1, PD10.2
#PCU-PHONE-EXT
PHONE_EXT		Alpha 5—PD00.1, PD01.1, PD10.2
#PCU-FAX-PREFIX
FAX_PREFIX		Alpha 6—PD00.1
#PCU-FAX-NMBR
FAX_NMBR		Alpha 15—PD00.1
#PCU-FAX-EXT
FAX_EXT		Alpha 5—PD00.1
#PCU-NOTE
NOTE		Alpha 60 (Lower Case)Additional notes.PD00.1, PD10.2
#PCU-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)Email address.PD00.1, PD01.1, PD10.2
#PCU-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the Procurement Card user. If Inactive, cannot be assigned as an administrator or proxy and cannot request a new card.
  • A Active
  • I Inactive
PD00.1, PD01.1, PD10.2
#PCU-ADMINISTRATOR
ADMINISTRATOR		Alpha 1—
  • Y Yes
  • N No
PD00.1, PD01.1, PD10.2
#PCU-PROXY
PROXY		Alpha 1—
  • Y Yes
  • N No
PD00.1, PD01.1, PD10.2
#PCU-COMPANY
COMPANY		Numeric 4Company number.PD00.1
#PCU-EMPLOYEE
EMPLOYEE		Numeric 9Contains the number assigned to each employee.PD00.1, PD10.2

Indexes (1)

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
PCUSET1
  1. PROCURE-GROUP
  2. CARD-USER-ID
PrimaryPD00.1, PD01.1, PD10.1, PD10.2, PD20.1, PD20.2, PD20.3, PD210 +5 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PDCARDPDCARDUSER

One to many (2) — child tables

RelationTableRulesConditionField map
PdcardPDCARD
PCU-CARD-USER-ID→PDC-CARD-USER-ID
—→PDC-PCARD-PROGRAM
—→PDC-PCARD-NBR
—→PDC-REQUEST-NBR
Pdcard ProxyPDCARD
PCU-CARD-USER-ID→PDC-PROXY-USER-ID
—→PDC-PCARD-PROGRAM
—→PDC-PCARD-NBR
—→PDC-REQUEST-NBR

Programs

Updated by (3)

Referenced by (9)