PDREASONCD – Procurement Card Reason Code

System
Purchase Order (PO)
Prefix
PSN
Primary key
PCARD-PROGRAM, REASON-CODE
Fields
6
Updated by
2 programs
Referenced by
5 programs

PDREASONCD is the Procurement Card Reason Code table in Lawson Purchase Order (prefix PSN). It is indexed by PCARD-PROGRAM, REASON-CODE (PSNSET1); alternate indexes: PSNSET2. It is updated by PD08.1 and PD21.1 and referenced by PD20.1, PD20.3, PD230, PD262 and PD62.3. The table has 6 fields, 2 indexes and 0 documented relations.

About PDREASONCD

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the PSN- 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
#PSN-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD08.1
#PSN-REASON-CODE PK
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.PD08.1
#PSN-DESC1
DESC1		Alpha 30 (Lower Case)This field displays the description.PD08.1
#PSN-DESC2
DESC2		Alpha 30 (Lower Case)This field displays the description.PD08.1
#PSN-STATUS SET2
STATUS		Numeric 1This field displays the status of the transaction.
  • 0 Inactive
  • 1 Active
PD08.1
#PSN-USED-FL
USED_FL		Numeric 1—
  • 0 Never Used
  • 1 Used
PD21.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
PSNSET1
  1. PCARD-PROGRAM
  2. REASON-CODE
PrimaryPD08.1, PD20.1, PD20.3, PD21.1, PD230, PD262, PD62.3
PSNSET2
  1. PCARD-PROGRAM
  2. STATUS ↓
  3. REASON-CODE
PD08.1

Programs

Updated by (2)

Referenced by (5)