D Appendix: Default Tax Handling

The following process is the order in which the application gets the tax rule information. Once the application finds one or more tax rules, it stops looking:

1. Retrieves tax rules as defined by the Tax Group ID associated with Item, and Tax Authority IDs associated with sale location (usually the store).

2. Retrieves tax rules as defined by the Tax Group ID associated with Item's Department, and Tax Authority ID associated with sale location (usually the store).

3. Retrieves tax rule as defined by the Default Tax Group ID parameter and the Default Tax Authority ID parameter.

4. Creates tax rule based on the Default Tax Rate Parameter.

The defaults for the Tax Group ID and Tax Authority ID are:

• DefaultTaxAuthorityID = 111111111

• DefaultTaxGroupID = -1

The application uses these two parameters to read the default tax rule from the database. This works offline because the Derby database (which resides on the client) contains the tax rules.

The Default Tax Rate

The first choice for the default tax rate now resides in the Tax Rate Rule Table (RU_TX_RT). When you query this table (where Auth ID = 111111111), you receive the following:

Table D-1 Tax Rate Rule Table

ID_ATHY_TX	111111111
ID_GP_TX	-1
TY_TX	0
FLG_TX_HDY	0
AI_TX_RT_RU	1
CD_TYP	1
PE_TX	8.25
MO_TX	(null)
FL_TX_ABV_TH_MO	0
MO_TX_TH	0
MO_TXBL_MIN	(null)
MO_TXBL_MAX	(null)

The tax rate in this file is 8.25 percent.

The Default Tax Type Indicator (VAT)

For VAT, the tax type comes from the Tax Rule Group Table (RU_TX_GP) and resides in the Tax Rule Name (NM_RU_TX) column. When you query this table (where Auth ID = 111111111), you receive the following:

Table D-2 Tax Rule Group Table

ID_ATHY_TX	111111111
ID_GP_TX	-1
TY_TX	0
FLG_TX_HDY	0
NM_RU_TX	T
DE_RU_TX	Default Tax
AI_CMPND	0
FL_TX_GS_AMT	0
CD_CAL_MTH	1
CD_TX_RT_RU_USG	1
FL_TX_INC	1

The default tax type indicator for VAT items is T.