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.
| 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-UNITACCT_UNIT | Alpha 15 | — | IC233, IC234, PO135, PO136 |
PRN-ACCOUNTACCOUNT | Numeric 6 | — | IC233, IC234, PO135, PO136 |
PRN-SUB-ACCTSUB_ACCT | Numeric 4 | — | IC233, IC234, PO135, PO136 |
PRN-BASE-AMTBASE_AMT | Signed 18.2 | — | IC233, IC234, PO135, PO136 |
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 |
|---|---|---|---|---|
PRNSET1 | COMPANY, RUN-DATE, PROGRAM, AMOUNT-TYPE, PROC-LEVEL, GL-CATEGORY | Primary | IC233, IC234, PO135, PO136 | |
PRNSET2 | COMPANY, RUN-DATE, ACCT-UNIT, ACCOUNT, SUB-ACCT, PROGRAM, AMOUNT-TYPE, PROC-LEVEL, GL-CATEGORY | — |