Oracle® Retail POS Suite 14.1/Merchandising 14.1 Implementation Guide Release 14.1 E59307-03 |
|
Previous |
Next |
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:
Retrieves tax rules as defined by the Tax Group ID associated with Item, and Tax Authority IDs associated with sale location (usually the store).
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).
Retrieves tax rule as defined by the Default Tax Group ID parameter and the Default Tax Authority ID parameter.
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 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.
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.