PORECON – No description in the Lawson data dictionary
- System
- Purchase Order (PO)
- Prefix
PRN- Primary key
COMPANY,RUN-DATE,PROGRAM,AMOUNT-TYPE,PROC-LEVEL,GL-CATEGORY- Fields
- 10
- Updated by
- 4 programs
- Referenced by
- 0 programs
PORECON is a Lawson Purchase Order table (prefix PRN); no description in the lawson data dictionary. It is indexed by COMPANY, RUN-DATE, PROGRAM, AMOUNT-TYPE, PROC-LEVEL, GL-CATEGORY (PRNSET1); alternate indexes: PRNSET2. It is updated by IC233, IC234, PO135 and PO136. The table has 10 fields, 2 indexes and 0 documented relations.
About PORECON
No description in the Lawson data dictionary.
Fields (10)
Column = COBOL field name without the PRN- 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 |
|---|---|---|---|
#PRN-COMPANY PKCOMPANY | Numeric 4 | — | IC233, IC234, PO135, PO136 |
#PRN-RUN-DATE PKRUN_DATE | Numeric 8 (yyyymmdd) | — | IC233, IC234, PO135, PO136 |
#PRN-PROGRAM PKPROGRAM | Alpha 5 | — | IC233, IC234, PO135, PO136 |
#PRN-AMOUNT-TYPE PKAMOUNT_TYPE | Numeric 1 | — | IC233, IC234, PO135, PO136 |
#PRN-PROC-LEVEL PKPROC_LEVEL | Alpha 5 | — | IC233, IC234, PO135, PO136 |
#PRN-GL-CATEGORY PKGL_CATEGORY | Alpha 4 | — | IC233, IC234, PO135, PO136 |
#PRN-ACCT-UNIT SET2ACCT_UNIT | Alpha 15 | — | IC233, IC234, PO135, PO136 |
#PRN-ACCOUNT SET2ACCOUNT | Numeric 6 | — | IC233, IC234, PO135, PO136 |
#PRN-SUB-ACCT SET2SUB_ACCT | Numeric 4 | — | IC233, IC234, PO135, PO136 |
#PRN-BASE-AMTBASE_AMT | Signed 18.2 | — | IC233, IC234, PO135, PO136 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PRNSET1 |
| Primary | IC233, IC234, PO135, PO136 | |
PRNSET2 |
| — |