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.

Field / columnTypeDescription & valuesUpdated by
PSN-PCARD-PROGRAM PK
PCARD_PROGRAM
Alpha 10PD08.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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PSNSET1PCARD-PROGRAM, REASON-CODEPrimaryPD08.1, PD20.1, PD20.3, PD21.1, PD230, PD262, PD62.3
PSNSET2PCARD-PROGRAM, STATUS*, REASON-CODEPD08.1

Programs

Updated by (2)

Referenced by (5)