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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PGC-PCARD-PROGRAM PKPCARD_PROGRAM | Alpha 10 | — | PD01.2 |
#PGC-COMPANY PKCOMPANY | 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-ACCOUNTCLG_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-UNITCLG_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-ACCTCLG_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-ACCOUNTTAX_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-UNITTAX_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-ACCTTAX_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-COMPANYDIST_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-CODEAUTH_CODE | Alpha 3 | A user-defined code representing a person or department responsible for approving a registered invoice. | PD01.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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PGCSET1 |
| 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 |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Pdcard | PDCARD |
|