PCODESTYPE – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
PCS- Primary key
TYPE- Fields
- 6
- Updated by
- 1 program
- Referenced by
- 3 programs
PCODESTYPE is a Lawson Human Resources table (prefix PCS); no description in the lawson data dictionary. It is indexed by TYPE (PCSSET1); alternate indexes: PCSSET2. It is related 1:M to PCODES and PCODESDTL. It is updated by HR100 and referenced by HR04.2, HR204 and PA532. The table has 6 fields, 2 indexes and 2 documented relations.
About PCODESTYPE
No description in the Lawson data dictionary.
Fields (6)
Column = COBOL field name without the PCS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PCS-TYPE PKTYPE | Alpha 2 | This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code. | — |
PCS-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | — |
PCS-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | The Active flag of the credit card type.
| — |
PCS-SETUP-FLAGSETUP_FLAG | Alpha 1 | —
| — |
PCS-DEFN-PROGRAMDEFN_PROGRAM | Alpha 5 | The Data Mart Setup Program field contains the name of the program that provides the dimensions, members, and data selection parameters required by the data mart. | — |
PCS-COMMENTSCOMMENTS | Alpha 50 (Lower Case) | This field contains the text you enter for the comment to be associated with an asset. You can have multiple lines of comments for each comment type. | — |
Indexes (2)
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 |
|---|---|---|---|---|
PCSSET1 | TYPE | Primary | HR04.2, HR100, HR204, PA532 | |
PCSSET2 | DESCRIPTION, TYPE | KeyChange, Subset | Where (ACTIVE-FLAG = "A") And (SETUP-FLAG = "Y") | HR04.2 |
Relations
One to many (2) — child tables
Programs
Updated by (1)
- HR100 Lawson Delivered Files Purge