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.

Field / column	Type	Description & values	Updated 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` PROCURE_GROUP	Alpha 4	This 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 1	This 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 6	The telephone number country code.	PD01.1
`PDP-PHONE` PHONE	Alpha 15	Phone number.	PD01.1
`PDP-EXTENSION` EXTENSION	Alpha 5	This 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PDPSET1`	`PCARD-PROGRAM`	Primary		AP145, AP146, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
`PDPSET2`	`PROCURE-GROUP`, `PCARD-PROGRAM`			—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Pdcarduser	PDCARDUSER	Not Required		`PDP-PROCURE-GROUP` → `PCU-PROCURE-GROUP (PCUSET1)`, `PDP-ADMIN-USER-ID` → `PCU-CARD-USER-ID`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Pdcard	PDCARD	Delete Cascades		`PDP-PCARD-PROGRAM` → `PDC-PCARD-PROGRAM`, → `PDC-REQUEST-NBR`
Pdprogcomp	PDPROGCOMP	Delete Cascades		`PDP-PCARD-PROGRAM` → `PGC-PCARD-PROGRAM`, → `PGC-COMPANY`

Programs

Updated by (3)

PD01.1 P-Card Program Setup
PD10.1 P-Card Card Request
PD10.2 P-Card Cardholder

Referenced by (51)

AP145 1099 Forms Creation
AP146 1099 Tape Creation
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP245 Reportable Income Report
AP246 Secondary Withholding Report
API1.1 Add Invoice
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
PD00.1 PCard Users
PD04.1 P-Card Merchant
PD05.1 P-Card Merchant Group
PD06.1 P-Card Merchant Cross Reference
PD08.1 P-Card Reason Code
PD130 P-Card Invoice and Release
PD20.1 P-Card Charge Approval
PD20.2 P-Card Charge Approval Level
PD20.3 P-Card Charge Approval SEA
PD201 P-Card Program Listing
PD204 P-Card Merchant Listing
PD21.1 P-Card Charge Detail
PD210 P-Card Cardholder Listing
PD22.1 P-Card Charge Accounts
PD230 P-Card Charge Report
PD235 P-Card Merchant Report
PD260 P-Card Audit Log
PD262 PCard Setup Audit Report
PD263 PCard Merchant Audit Report
PD57.1 P-Card Charge Import Maintenance
PD57.2 P-Card Charge Import Distributions
PD57.3 P-Card Charge Import Errors
PD570 P-Card Charge Import
PD62.1 Pcard Program Audit Inquiry
PD62.2 Pcard Program Company Audit Inquiry
PD62.3 Pcard Reason Code Audit Inquiry
PD63.1 P Card Merchant Audit Inquiry
PD63.2 Pcard Merchant Group Audit Inquiry
PD63.3 Pcard Merchant Cross Reference Audit Inquiry
PO00.1 Procurement Group