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.
UPDATED BY
BR02.3 BR120 BR121 BR122 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HIT-OBJ-ID
Element: 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
BRIP.1
HIT-HDT-LINE-NBR
Element: 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
BRIP.1
HIT-SEQ-NBR
Element: 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
BRIP.1
HIT-TAX-CODE
Element: 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
BRIP.1
HIT-DESCRIPTION
Element: 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
BRIP.1
HIT-TAX-RATE
Element: Chrg 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
BRIP.1
HIT-TAX-AMT
Element: Intl 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
BRIP.1
HIT-TAX-LEVEL
Element: 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
BRIP.1


ACHISTTAX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HITSET1 OBJ-ID
HDT-LINE-NBR
SEQ-NBR
BR02.3 BR120
BR121 BR122
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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR Required
HIT-OBJ-ID->HIH-OBJ-ID


ACHISTTAX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:10:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.