POIACAL – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PIC
Primary key
CAL-NAME, YEAR
Fields
7
Updated by
1 program
Referenced by
2 programs

POIACAL is a Lawson Purchase Order table (prefix PIC); no description in the lawson data dictionary. It is indexed by CAL-NAME, YEAR (PICSET1). It is updated by POA4.1 and referenced by POA1.1 and POA3.1. The table has 7 fields, 1 index and 0 documented relations.

About POIACAL

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the PIC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PIC-CAL-NAME PK
CAL_NAME		Alpha 20—POA4.1
PIC-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.POA4.1
PIC-BEG-DATE
BEG_DATE		Numeric 8 (yyyymmdd)The beginning date in a range of dates.POA4.1
PIC-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.POA4.1
PIC-NBR-OF-PERIODS
NBR_OF_PERIODS		Numeric 3—POA4.1
PIC-PERIOD
PERIOD		Numeric 2 Occurs 53 Times ×53This is the current accounting period. This field is updated by Period Closing (GL199).—
PIC-PER-END-DATE
PER_END_DATE		Numeric 8 (yyyymmdd) Occurs 53 Times ×53Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).POA4.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PICSET1CAL-NAME, YEARPrimaryPOA1.1, POA3.1, POA4.1

Programs

Updated by (1)

Referenced by (2)