PDPROGCOMP – P-Card Program by Company

System: Purchase Order (PO)
Prefix: PGC
Primary key: PCARD-PROGRAM, COMPANY
Fields: 10
Updated by: 2 programs
Referenced by: 9 programs

PDPROGCOMP is the P-Card Program by Company table in Lawson Purchase Order (prefix PGC). It is indexed by PCARD-PROGRAM, COMPANY (PGCSET1). It is related 1:1 to PDCARDCOMP and 1:M to PDCARD. It is updated by PD01.1 and PD01.2 and referenced by PD10.2, PD10.3, PD130, PD20.1, PD20.2, PD20.3, PD21.1, PD230 and 1 more. The table has 10 fields, 1 index and 2 documented relations.

About PDPROGCOMP

No description in the Lawson data dictionary.

Fields (10)

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

Field / column	Type	Description & values	Updated by
`PGC-PCARD-PROGRAM` PK PCARD_PROGRAM	Alpha 10	—	PD01.2
`PGC-COMPANY` PK COMPANY	Numeric 4	Identifies 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.	PD01.2
`PGC-CLG-ACCOUNT` CLG_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	PD01.2
`PGC-CLG-ACCT-UNIT` CLG_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	PD01.2
`PGC-CLG-SUB-ACCT` CLG_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	PD01.2
`PGC-TAX-ACCOUNT` TAX_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	PD01.2
`PGC-TAX-ACCT-UNIT` TAX_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	PD01.2
`PGC-TAX-SUB-ACCT` TAX_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	PD01.2
`PGC-DIST-COMPANY` DIST_COMPANY	Numeric 4	Identifies 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.	PD01.2
`PGC-AUTH-CODE` AUTH_CODE	Alpha 3	A user-defined code representing a person or department responsible for approving a registered invoice.	PD01.2

Indexes (1)

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
`PGCSET1`	`PCARD-PROGRAM`, `COMPANY`	Primary		PD01.1, PD01.2, PD10.2, PD10.3, PD130, PD20.1, PD20.2, PD20.3 +3 more

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Pdcardcomp	PDCARDCOMP	Required		`PGC-PCARD-PROGRAM` → `PCA-PCARD-PROGRAM`, `Zeroes` → `PCA-REQUEST-NBR`, `PGC-COMPANY` → `PCA-COMPANY`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Pdcard	PDCARD			`PGC-PCARD-PROGRAM` → `PDC-PCARD-PROGRAM`, → `PDC-REQUEST-NBR`

Programs

Updated by (2)

PD01.1 P-Card Program Setup
PD01.2 P-Card Program Companies

Referenced by (9)

PD10.2 P-Card Cardholder
PD10.3 P-Card Companies
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
PD21.1 P-Card Charge Detail
PD230 P-Card Charge Report
PD570 P-Card Charge Import