ACHISTTAX – Invoice Tax Detail

System: AC Billing Revenue (BR)
Prefix: HIT
Primary key: OBJ-ID, HDT-LINE-NBR, SEQ-NBR
Fields: 8
Updated by: 10 programs
Referenced by: 12 programs

ACHISTTAX is the Invoice Tax Detail table in Lawson AC Billing Revenue (prefix HIT). It is indexed by OBJ-ID, HDT-LINE-NBR, SEQ-NBR (HITSET1). It is related 1:1 to ACHISTHDR and 1:M to TXTAXTRAN. It is updated by BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR300, BR46.1, BR46.2 and 2 more and referenced by BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 and 4 more. The table has 8 fields, 1 index and 2 documented relations.

About ACHISTTAX

This file stores the tax detail for each taxable line or transaction on the invoice (ACHISTDTL). The ACHISTDTL will store the overall tax amount for the transaction or line. The ACHISTTAX will store the transactions tax detail which can contain up to eight different tax codes and tax amounts. This file is maintained by BR invoice creation and edit programs BR19, BR20, BR120, and BR121. Invoice history can be printed by running BR420.

Fields (8)

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

Field / column	Type	Description & values	Updated by
`HIT-OBJ-ID` PK OBJ_ID	Numeric 12	The object identifier is a number used to relate the invoice detail records to the invoice header. The object type is INVID in the OBJID data file.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIT-HDT-LINE-NBR` PK HDT_LINE_NBR	Numeric 6	The invoice line number associated with this tax record.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIT-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIT-TAX-CODE` TAX_CODE	Alpha 10	The code representing specific tax information. This must be valid Tax Code.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIT-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The tax code description.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIT-TAX-RATE` TAX_RATE	Percent 7.5 (Percent)	Charge rate by month.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIT-TAX-AMT` TAX_AMT	Signed 18.2	The tax amount calculated for the invoice line.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more
`HIT-TAX-LEVEL` TAX_LEVEL	Alpha 1	The tax level sent from Vertex to distinguish between GST and PST tax.	BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4 +1 more

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`HITSET1`	`OBJ-ID`, `HDT-LINE-NBR`, `SEQ-NBR`	Primary		BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +14 more

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Achisthdr	ACHISTHDR	Required		`HIT-OBJ-ID` → `HIH-OBJ-ID`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Txtaxtran	TXTAXTRAN			`HIH-COMPANY` → `TXD-COMPANY`, `HIH-INVOICE` → `TXD-INVOICE`, `HIT-TAX-CODE` → `TXD-TAX-CODE`, → `TXD-PROD-TAX-CAT`, → `TXD-TRANS-IDENT`

Programs

Updated by (10)

BR20.1 Invoice Edit Contract
BR20.2 Invoice Edit Line
BR20.3 Invoice Edit Activity
BR20.4 Invoice Edit Activity and Account Category
BR20.5 Invoice Edit Transaction
BR300 Invoice Purge
BR46.1 Bill in Advance
BR46.2 Transfer Invoice Transaction
BR46.4 Split Transfer
BRIP.1 Invoice Print Program

Referenced by (12)

BR02.3 Retainer Invoice Entry
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR156 Maintenance Quote
BR420 Billing Invoice Report
BR521 Billing Import
TX101 Journal File Create