Lawson Insight Technical Documentation

                             ACHISTTAX FILE

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.

REFERENCED BY

BR02.3    BR120     BR121     BR122     BR123     BR140
BR151     BR152     BR156     BR420     BR521     TX101


UPDATED BY

BR20.1    BR20.2    BR20.3    BR20.4    BR20.5    BR46.1
BR46.2    BR46.4    BRIP.1    BR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HIT-OBJ-ID             Numeric 12                                BR20.1  BR20.2
Element: Obj Id        The object identifier is a number used    BR20.3  BR20.4
                       to  relate the invoice detail records to  BR20.5  BR46.1
                       the invoice header.  The object type  is  BR46.2  BR46.4
                       INVID in the OBJID data file.             BRIP.1

HIT-HDT-LINE-NBR       Numeric 6                                 BR20.1  BR20.2
Element: Hdt Line Nbr  The invoice line number associated with   BR20.3  BR20.4
                       this tax record.                          BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HIT-SEQ-NBR            Numeric 4                                 BR20.1  BR20.2
Element: Seq Nbr       An automatically assigned sequence        BR20.3  BR20.4
                       number.                                   BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HIT-TAX-CODE           Alpha 10                                  BR20.1  BR20.2
Element: Tax Code      The code representing specific tax        BR20.3  BR20.4
                       information.  This must be valid Tax      BR20.5  BR46.1
                       Code.                                     BR46.2  BR46.4
                                                                 BRIP.1

HIT-DESCRIPTION        Alpha 30  (Lower Case)                    BR20.1  BR20.2
Element: Description   The tax code description.                 BR20.3  BR20.4
                                                                 BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HIT-TAX-RATE           Percent 7.5  (Percent)                    BR20.1  BR20.2
Element: Chrg Rate     Charge rate by month.                     BR20.3  BR20.4
                                                                 BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HIT-TAX-AMT            Signed 18.2                               BR20.1  BR20.2
Element: Intl Amt      The tax amount calculated for the         BR20.3  BR20.4
                       invoice line.                             BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

HIT-TAX-LEVEL          Alpha 1                                   BR20.1  BR20.2
Element: Tax Level     The tax level sent from Vertex to         BR20.3  BR20.4
                       distinguish between GST and PST tax.      BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BRIP.1

                         ACHISTTAX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HITSET1   OBJ-ID                                                 BR02.3  BR120
          HDT-LINE-NBR                                           BR121   BR122
          SEQ-NBR                                                BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR300   BR420
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR521
                                                                 BRIP.1  TX101

                         ACHISTTAX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Achisthdr      ACHISTHDR    Required

                            HIT-OBJ-ID      -> HIH-OBJ-ID

                         ACHISTTAX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Txtaxtran      TXTAXTRAN

                            HIH-COMPANY     -> TXD-COMPANY
                            HIH-INVOICE     -> TXD-INVOICE
                            HIT-TAX-CODE    -> TXD-TAX-CODE
                                               TXD-PROD-TAX-CAT
                                               TXD-TRANS-IDENT