Lawson Insight Technical Documentation |
|
ACHISTTAX
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 BR140 BR420
BR521
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
Object The object identifier is a number used BR20.3 BR20.4
Identification 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: Sequence NumbeAn 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 The tax rate defined for the tax code. 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 BR140 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR300 BR420
BR46.1 BR46.2
BR46.4 BR521
BRIP.1
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
|