TXCALENDAR – VAT calendar header
- System
- Tax (TX)
- Prefix
TXA- Primary key
COMPANY,TAX-YEAR- Fields
- 2
- Updated by
- 1 program
- Referenced by
- 7 programs
TXCALENDAR is the VAT calendar header table in Lawson Tax (prefix TXA). It is indexed by COMPANY, TAX-YEAR (TXASET1). It is related 1:M to TXCALDTL. It is updated by TX08.1 and referenced by AP272, TX101, TX120, TX125, TX222, TX226 and TX301. The table has 2 fields, 1 index and 1 documented relation.
About TXCALENDAR
No description in the Lawson data dictionary.
Fields (2)
Column = COBOL field name without the TXA- 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 |
|---|---|---|---|
#TXA-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. | TX08.1 |
#TXA-TAX-YEAR PKTAX_YEAR | Numeric 4 | The tax year for which the calendar was defined. | TX08.1 |
Indexes (1)
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 |
|---|---|---|---|---|
TXASET1 |
| Primary | AP272, TX08.1, TX101, TX120, TX125, TX222, TX226, TX301 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Calendar Dtl | TXCALDTL |
|
Programs
Updated by (1)
- TX08.1 Tax Calendar Maintenance