TXCALDTL – VAT calendar detail

System
Tax (TX)
Prefix
TXB
Primary key
COMPANY, TAX-YEAR, TAX-PERIOD
Fields
5
Updated by
2 programs
Referenced by
7 programs

TXCALDTL is the VAT calendar detail table in Lawson Tax (prefix TXB). It is indexed by COMPANY, TAX-YEAR, TAX-PERIOD (TXBSET1). It is updated by TX08.1 and TX120 and referenced by AP272, TX101, TX125, TX130, TX222, TX226 and TX301. The table has 5 fields, 1 index and 0 documented relations.

About TXCALDTL

No description in the Lawson data dictionary.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
TXB-COMPANY PK
COMPANY		Numeric 4Identifies 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
TXB-TAX-YEAR PK
TAX_YEAR		Numeric 4The tax year for which the calendar was defined.TX08.1
TXB-TAX-PERIOD PK
TAX_PERIOD		Numeric 2The tax period of the specified year.TX08.1
TXB-PER-END-DATE
PER_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).TX08.1
TXB-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 1 Open
  • 2 Reported
  • 3 Closed
TX08.1, TX120

Indexes (1)

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

IndexKeysFlagsConditionUsed in
TXBSET1COMPANY, TAX-YEAR, TAX-PERIODPrimaryAP272, TX08.1, TX101, TX120, TX125, TX130, TX222, TX226 +1 more

Programs

Updated by (2)

Referenced by (7)