INCALENDAR – Intrastat Calendar
- System
- Tax (TX)
- Prefix
INL- Primary key
COMPANY,TAX-YEAR,TAX-PERIOD- Fields
- 6
- Updated by
- 2 programs
- Referenced by
- 0 programs
INCALENDAR is the Intrastat Calendar table in Lawson Tax (prefix INL). It is indexed by COMPANY, TAX-YEAR, TAX-PERIOD (INLSET1); alternate indexes: INLSET2 and INLSET3. It is updated by IN08.1 and IN120. The table has 6 fields, 3 indexes and 0 documented relations.
About INCALENDAR
No description in the Lawson data dictionary.
Fields (6)
Column = COBOL field name without the INL- 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 |
|---|---|---|---|
#INL-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | IN08.1 |
#INL-TAX-YEAR PKTAX_YEAR | Numeric 4 | The tax year for which the calendar was defined. | IN08.1 |
#INL-TAX-PERIOD PKTAX_PERIOD | Numeric 2 | The tax period of the specified year. | IN08.1 |
#INL-PER-END-DATEPER_END_DATE | Numeric 8 (yyyymmdd) | Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE). | IN08.1 |
#INL-PER-NAMEPER_NAME | Alpha 15 (Lower Case) | The period name. | IN08.1 |
#INL-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction.
| IN08.1, IN120 |
Indexes (3)
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 |
|---|---|---|---|---|
INLSET1 |
| Primary | IN08.1, IN120 | |
INLSET2 |
| Subset | Where STATUS = 1 | IN120 |
INLSET3 |
| Subset | Where STATUS = 2 | IN120 |