AMTABLETAX – Asset Management Tax Table

System
Asset Management (AM)
Prefix
ATT
Primary key
TC-TABLE
Fields
6
Updated by
1 program
Referenced by
274 programs

AMTABLETAX is the Asset Management Tax Table table in Lawson Asset Management (prefix ATT). It is indexed by TC-TABLE (ATTSET1). It is updated by AM03.1 and referenced by AC160, AM115, AM117, AM12.1, AM12.2, AM125, AM145, AM15.1 and 266 more. The table has 6 fields, 1 index and 0 documented relations.

About AMTABLETAX

The Tax Table file stores optional tax credit table records that asset books use for calculating tax credits. A tax table record defines tax credit percentages and annual tax credit recapture percentages for up to twenty years.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
ATT-TC-TABLE PK
TC_TABLE
Alpha 10A user-defined tax credit table, which defines tax credit percentages and annual tax credit recapture percentages for up to twenty years. Asset books use tax credit tables to calculate tax credits.AM03.1
ATT-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)The description of the tax credit table.AM03.1
ATT-QUALIFY-PCT
QUALIFY_PCT
Signed 5.2The qualifying percentage defined for the tax credit table. This value identifies the percentage of an asset's depreciable basis that qualifies for a tax credit.AM03.1
ATT-TC-PERCENT
TC_PERCENT
Signed 5.2The tax credit percentage defined for the tax credit table. This value is applied to the qualifying percent to calculate the tax credit.AM03.1
ATT-BASIS-RED-PCT
BASIS_RED_PCT
Signed 5.2The basis reduction percentage defined for the tax credit table. This value is used to calculate an asset's depreciable basis.AM03.1
ATT-RECOVERY-PCT
RECOVERY_PCT
Signed 5.2 Occurs 20 Times ×20Each occurrence of this field identifies the percentage of the tax credit to recapture if an asset is disposed of before its service life is expired.AM03.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ATTSET1TC-TABLEPrimaryAC160, AM03.1, AM115, AM117, AM12.1, AM12.2, AM125, AM145 +22 more (list truncated in source)

Programs

Updated by (1)

Referenced by (274)