PRVENDOR – This file contains AP vendors defined for a deduction code and process level.

System
Payroll (PR)
Prefix
PRV
Primary key
COMPANY, DED-CODE, PROCESS-LEVEL
Fields
5
Updated by
1 program
Referenced by
4 programs

PRVENDOR is the This file contains AP vendors defined for a deduction code and process level. table in Lawson Payroll (prefix PRV). It is indexed by COMPANY, DED-CODE, PROCESS-LEVEL (PRVSET1). It is related 1:1 to DEDCODE and PRSYSTEM. It is updated by PR05.3 and referenced by PR198, PR26.1, PR47.1 and PR514. The table has 5 fields, 1 index and 2 documented relations.

About PRVENDOR

This file contains AP vendors defined for a deduction code and process level.

Fields (5)

Column = COBOL field name without the PRV- 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
#PRV-COMPANY PK
COMPANY		Numeric 4—PR05.3
#PRV-DED-CODE PK
DED_CODE		Alpha 4Contains the deduction code.PR05.3
#PRV-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—PR05.3
#PRV-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.PR05.3
#PRV-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4A user-defined code that represents a vendor's remittance address.PR05.3

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.

IndexKeysFlagsConditionUsed in
PRVSET1
  1. COMPANY
  2. DED-CODE
  3. PROCESS-LEVEL
PrimaryPR05.3, PR198, PR26.1, PR47.1, PR514

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
DEDCODEPRSYSTEMPRVENDOR

One to one (2) — lookups and parents

RelationTableRulesConditionField map
DedcodeDEDCODERequired
PRV-COMPANY→DDC-COMPANY
PRV-DED-CODE→DDC-DED-CODE
PrsystemPRSYSTEMRequired
PRV-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (4)