PDPROGRAM – P-Card Program

System
Purchase Order (PO)
Prefix
PDP
Primary key
PCARD-PROGRAM
Fields
22
Updated by
3 programs
Referenced by
51 programs

PDPROGRAM is the P-Card Program table in Lawson Purchase Order (prefix PDP). It is indexed by PCARD-PROGRAM (PDPSET1); alternate indexes: PDPSET2. It is related 1:1 to PDCARDUSER and 1:M to PDCARD and PDPROGCOMP. It is updated by PD01.1, PD10.1 and PD10.2 and referenced by AP145, AP146, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 43 more. The table has 22 fields, 2 indexes and 3 documented relations.

About PDPROGRAM

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the PDP- 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
#PDP-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD01.1
#PDP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PD01.1
#PDP-PROCURE-GROUP SET2
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.PD01.1
#PDP-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 0 Active
  • 9 Cancelled
PD01.1
#PDP-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.PD01.1
#PDP-ADMIN
ADMIN		Alpha 30—PD01.1
#PDP-PREFIX
PREFIX		Alpha 6The telephone number country code.PD01.1
#PDP-PHONE
PHONE		Alpha 15Phone number.PD01.1
#PDP-EXTENSION
EXTENSION		Alpha 5This field contains the telephone extension number.PD01.1
#PDP-EMAIL
EMAIL		Alpha 60 (Lower Case)e-mail address.PD01.1
#PDP-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.PD01.1
#PDP-MASK-FL
MASK_FL		Alpha 1—
  • Y Yes
  • N No
PD01.1
#PDP-INV-CREATE-FL
INV_CREATE_FL		Alpha 1—
  • Y Yes
  • N No
—
#PDP-DISP-REASON-FL
DISP_REASON_FL		Alpha 1—
  • Y Yes
  • N No
PD01.1
#PDP-DISP-EXP-FL
DISP_EXP_FL		Alpha 1—
  • Y Yes
  • N No
—
#PDP-LAST-REQUEST
LAST_REQUEST		Numeric 16—PD10.1, PD10.2
#PDP-CHARGE-APPR-FL
CHARGE_APPR_FL		Alpha 1—
  • N No
  • P PO Charges Only
  • A Adhoc Charges Only
  • B Both
PD01.1
#PDP-AUTO-ADD
AUTO_ADD		Alpha 1—
  • Y Yes
  • N No
PD01.1
#PDP-CHARGE-CLS-FL
CHARGE_CLS_FL		Alpha 1—
  • N No
  • P PO Charges Only
  • A Adhoc Charges Only
  • B Both
PD01.1
#PDP-TRACK-CARDS-FL
TRACK_CARDS_FL		Alpha 1——
#PDP-AUTO-ADD-USER
AUTO_ADD_USER		Alpha 1—
  • Y Yes
  • N No
PD01.1
#PDP-ADMIN-USER-ID
ADMIN_USER_ID		Alpha 10 (Lower Case)—PD01.1

Indexes (2)

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
PDPSET1
  1. PCARD-PROGRAM
PrimaryAP145, AP146, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
PDPSET2
  1. PROCURE-GROUP
  2. PCARD-PROGRAM
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PdcarduserPDCARDUSERNot Required
PDP-PROCURE-GROUP→PCU-PROCURE-GROUP (PCUSET1)
PDP-ADMIN-USER-ID→PCU-CARD-USER-ID

One to many (2) — child tables

RelationTableRulesConditionField map
PdcardPDCARDDelete Cascades
PDP-PCARD-PROGRAM→PDC-PCARD-PROGRAM
—→PDC-REQUEST-NBR
PdprogcompPDPROGCOMPDelete Cascades
PDP-PCARD-PROGRAM→PGC-PCARD-PROGRAM
—→PGC-COMPANY

Programs

Updated by (3)

Referenced by (51)