11 Maintaining Tax Related Data - TaxWeb

There are a number of tables in RMS that contain data provided by (or derived from) an external tax engine (TaxWeb Tax Rules).

This chapter covers the following topics:

Installing Rules from TaxWeb Tax Rules
Understanding the Integrated Batch Schedule
Maintaining External Tax Information (L10N_BR_T_EXTAX_MAINT)

Installing Rules from TaxWeb Tax Rules

Perform the following steps to install an updated set of rules from a TaxWeb Tax Rules:

Stop the WebLogic Server for the domain in which RTIL is deployed.
Copy the TaxWeb Tax Rules.jar files to WEBLOGIC_DOMAIN_HOME/lib.
Start the WebLogic Server for the domain in which RTIL is deployed.
After a new TaxWeb .jar is loaded and the RTIL WebLogic Server runs, set the L10N_BR_EXTAX_REFRESH_CONFIG.REFRESH_NEEDED to Y. This triggers updates to the tables in RMS that contain data provided by (or derived from) the external tax engine (like the TaxWeb Tax Rules).

Understanding the Integrated Batch Schedule

The integrated batch schedule process consists of the following:

Fiscal item reclassification Retail
Fiscal item reclassification Cost
Tax Law Changes Retail
Tax Law Changes Cost

Fiscal item reclassification Retail

This consists of the following:

fm_batch_freclass_sql.ksh – This module, execute all group of item in queue to reclassification. For items having their fiscal attributes changed (FM_FRECLASS_SCHEDULE).
l10n_br_fiscal_reclass_item_setup_retail.ksh – This module looks at all the valid item/location combinations in RMS for items having their fiscal attributes changed. It determines the unique fiscal attribute groups that cover all the item/locations combinations and puts the groups on a stage table (L10N_BR_T_EXTAX_STG_RETAIL).
l10n_br_fiscal_reclass_item_process_retail.ksh – This module picks the staged groups placed on L10N_BR_T_EXTAX_STG_RETAIL by l10n_br_fiscal_reclass_item_setup_retail.ksh and calls the external tax provider with them. The results of these calls are placed on the L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET tables.
l10n_br_fiscal_reclass_item_finish_retail.ksh – This module picks the group level tax call results that l10n_br_fiscal_reclass_item_process_retail.ksh placed on L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET, and explodes them back to the item/location level. It then uses the item/location level information to write tax information to GTAX_ITEM_ROLLUP and POS_MODS_TAX_INFO.
l10n_br_fiscal_loc_reclass_retail.ksh – This module allows for recalculation of tax based on the changed fiscal attribute for store/warehouse/partner/supplier entities.

Fiscal item reclassification Cost

This consists of the following:

l10n_br_fiscal_item_reclass_cost.ksh – This module creates cost changes for all item/supplier/origin country/location combinations that are affected by fiscal item reclassifications. The normal cost change processes update RMS with the new tax law information when necessary. If the default location is not ranged to an item being reclassified, the ITEM_COST_HEAD/DETAIL tables are handled directly.
l10n_br_fiscal_loc_reclass_cost.ksh – This module creates cost changes for store/warehouse/partner/supplier entities that are affected by fiscal item reclassifications.
l10n_br_exec_tax_recalc.ksh – This module picks the reclass for that day, processes reclass event, updates the item cost head/detail, and item supplier country location for the costs.
sccext – This needs to be run incase the cost change is to be done for vdate+1.

Item Cost for Non-Brazil Supplier

While computing the item cost, there is no need to make a tax call to tax rules engine if the supplier linked to an item is not a Brazilian Supplier. RMS checks the country of the supplier. RMS does not make a tax call to tax rules engine, and instead populates the item costing tables (Item_Cost_Head and Item_Cost_Detail) without any tax details for non-Brazilian suppliers.

There is no need to navigate to item costing screen in case supplier's country is not Brazil. The Negotiated Item Cost (NIC), Base Cost (BC), Extended Base Cost (EBC), and Inclusive Cost (IC) are calculated with zero tax values. The Delivery country is set to Brazil, and primary delivery country indicator is set to Y. The NIC static indicator is also set to Y. These defaults do not impact the cost calculations as there is no tax in this case.

RMS continues to make tax calls to the tax rules engine for Brazilian suppliers that is, suppliers for which the country on the supplier's primary address is set to Brazil. All values passed to tax rules engine for Cost computation must be in Brazilian Reais (BRL), irrespective of the supplier currency. If the supplier currency is BRL, then the values passed to tax rules engine and retrieved from tax rules engine are in BRL and can be stored in BRL in the RMS tables. In case the supplier operates in a currency other than BRL, then RMS converts the cost values into BRL using the currency conversion rates defined in RMS. These converted values are passed to tax rules engine which return values of cost components and taxes in BRL. These cost and tax values are converted back into the supplier currency before storing them in the database.

Navigate to the item costing screen and click Calculate Tax. The data is retrieved with zero taxes.

The data conversion scripts for non-Brazil supplier picks the items in Approved status and inserts the data as it is from dat files to tables.

The item costing will not be made and it is not a correct business scenario, when an item has a non-Brazil delivery country.

Tax Law Changes Retail

This consists of the following:

l10n_br_refresh_extax_setup_retail.ksh – This module obtains a list of fiscal attributes that have tax law changes scheduled against them since the last run. It then uses this information to determine what item/locations will be affected by those scheduled tax law changes. It determines the unique fiscal attribute groups that cover those item/locations combinations and puts the groups on a stage table (L10N_BR_T_EXTAX_STG_RETAIL).
l10n_br_refresh_extax_process_retail.ksh – This module picks the staged groups placed on L10N_BR_T_EXTAX_STG_RETAIL by l10n_br_refresh_extax_setup_retail.ksh and calls the external tax provider with them. The results of these calls are placed on the L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET tables.
l10n_br_refresh_extax_finish_retail.ksh – This module picks the group level tax call results that refresh_br_extax_process_retail.ksh placed on L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET and explodes them back to the item/location level. It then uses the item/location level information to write tax information to GTAX_ITEM_ROLLUP and POS_MODS_TAX_INFO.

Tax Law Changes Cost

This consists of the following:

l10n_br_refresh_extax_future_cost.ksh – This module obtains a list of fiscal attributes that have tax law changes scheduled against them since its last run. It then uses this information to determine what item/supplier/origin country/locations will be affected by those scheduled tax law changes. These item/supplier/origin country/location combinations are then used to create new cost changes on the date of their tax law changes. The normal cost change processes then take care of updating RMS with the new tax law information when necessary.

Program Flow

The basic flow of data from a triggering event to the RMS tables holding tax information is shown below. There are three diagrams, one for retail and two for cost.

Figure 11-1 Retail Tax Flow

Surrounding text describes Figure 11-1 .

Figure 11-2 Cost Tax Flow

Surrounding text describes Figure 11-2 .

Figure 11-3 Cost Tax Flow Maintenance

Surrounding text describes Figure 11-3 .

Maintaining External Tax Information (L10N_BR_T_EXTAX_MAINT)

The tables can be divided into two categories depending on whether they hold data related to retail tax or cost tax.

Retail Tables – GTAX_ITEM_ROLLUP and POS_MODS_TAX_INFO
Cost Tables – ITEM_SUPP_COUNTRY, ITEM_SUPP_COUNTRY_LOC, FUTURE_COST, ITEM_COST_HEAD, ITEM_COST_DETAIL

These tables can also be categorized by whether they hold the current state tax information or pending state tax information. The current state tables only get updated when the transaction effecting tax becomes active and that pending state tables get updated as soon as the transaction effecting tax becomes known. For example, when we understand from the TaxWeb Tax Rules that the sales tax is moving from 10% to 12% in San Paulo in two weeks, the pending state tables are updated as soon this information is known. The current state tables are not updated until two weeks from now when the rate change actually occurs.

Current State Tables – ITEM_SUPP_COUNTRY, ITEM_SUPP_COUNTRY_LOC, ITEM_COST_HEAD, ITEM_COST_DETAIL
Pending State Tables – GTAX_ITEM_ROLLUP, POS_MODS_TAX_INFO, FUTURE_COST

Since the tax information is stored in RMS tables, these tables have to contain the factors that determine how tax change is calculated.

The following factors drive retail tax recalculations:

Item tax attributes (including dimensions)
Location tax attributes/location address
Date

The following factors drive cost tax recalculations:

Item tax attributes (including dimensions)
Location tax attributes/location address
Supplier tax attributes/supplier address
Unit cost
Date

L10N_BR_T_EXTAX_MAINT_SQL uses data grouping to minimize the number of calls to an external tax engine.

The idea behind grouping is that it is the fiscal attributes that determine what the tax is, not the particular entity (many different items may all share the same fiscal attributes - same thing for suppliers and locations). The ITEM_LOC table might have 1 million rows on it, but there might only be 125,000 unique combinations of item fiscal attributes and location fiscal attributes between them. If that is the case, only 125,000 calls need to be made to the external tax engine instead of 1 million calls.

The following batches are called by this package:

l10n_br_fiscal_item_reclass_cost.ksh
l10n_br_fiscal_reclass_item_finish_retail.ksh
l10n_br_fiscal_reclass_item_setup_retail.ksh
l10n_br_fiscal_loc_reclass_cost.ksh
l10n_br_fiscal_reclass_item_process_retail.ksh
l10n_br_fiscal_loc_reclass_retail.ksh
l10n_br_exec_tax_recalc.ksh
l10n_br_refresh_extax_finish_retail.ksh
l10n_br_refresh_extax_future_cost.ksh
l10n_br_refresh_extax_process_retail.ksh
l10n_br_refresh_extax_setup_retail.ksh

l10n_br_fiscal_item_reclass_cost.ksh

This module creates cost changes for all item/supplier/origin country/location combinations that are affected by fiscal item reclassifications. The normal cost change processes will then take care of updating RMS with the new tax law information when necessary. If the default location is not ranged to an item being reclassified, the ITEM_COST_HEAD/DETAIL tables are handled directly.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_fiscal_item_reclass_cost.ksh

Design Overview

This batch stores and maintains data that comes from the external tax engine like the TaxWeb Tax Rules.

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 11-1 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	l10n_br_fiscal_reclass_item_finish_retail.ksh
Post-Processing	l10n_br_exec_tax_recalc.ksh
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-2 Tables Affected

Tables	Select	Insert	Update	Delete
GTAX_COST_CHANGE_GTT	Yes	Yes	Yes	No
L10N_BR_FISCAL_RECLASS	Yes	No	No	No
ITEM_SUPP_COUNTRY_LOC	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
ADDR	Yes	No	No	No
FUTURE COST TABLES	Yes	Yes	Yes	Yes
ITEM_COST_HEAD	Yes	Yes	Yes	No
MV_L10N_ENTITY	Yes	No	No	No
COUNTRY_ATTRIB	Yes	No	No	No
ITEM_SUPP_COUNTRY	Yes	No	No	No
ITEM_COST_DETAIL	Yes	Yes	Yes	No
SYSTEM_OPTIONS	Yes	No	No	No
SUPS	Yes	No	No	No
COST_SUSP_SUP_HEAD	No	Yes	No	No
COST_SUSP_SUP_DETAIL_LOC	No	Yes	No	No
COST_EVENT_RUN_TYPE_CONFIG	Yes	No	No	No
COST_EVENT	No	Yes	No	No
ITEM_COST_DETAILS	No	No	No	Yes
STORE	Yes	No	No	No
WH	Yes	No	No	No
partner	Yes	No	No	No
L10N_TAX_OBJECT_CONFIG	Yes	No	No	No
VAT_ITEM	Yes	No	No	No

I/O Specification

Not applicable

l10n_br_fiscal_reclass_item_finish_retail.ksh

This module picks up the group level tax call results that l10n_br_fiscal_reclass_item_process_retail.ksh places on L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET and explodes them back to the item/location level. It then uses the item/location level information to write tax information to GTAX_ITEM_ROLLUP and POS_MODS_TAX_INFO tables.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_fiscal_reclass_item_finish_retail.ksh

Design Overview

This batch stores and maintains data that comes from the external tax engine like the TaxWeb Tax Rules.

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 11-3 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	l10n_br_fiscal_reclass_item_process_retail.ksh
Post-Processing	l10n_br_fiscal_item_reclass_cost.ksh
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-4 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_T_EXTAX_HELP_RTL_GTT	Yes	Yes	No	No
ITEM_LOC	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
ITEM_SUPP_COUNTRY	Yes	No	No	No
ITEM_SUPP_COUNTRY_DIM	Yes	No	No	No
L10N_BR_T_EXTAX_RES_RETAIL	Yes	No	No	No
L10N_BR_FISCAL_RECLASS	Yes	No	Yes	No
L10N_BR_T_EXTAX_DEST_GRP_HELP	Yes	No	No	No
V_BR_ITEM_FISCAL_ATTRIB	Yes	No	No	No
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	No	No	No
ITEM_LOC	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
V_PACKSKU_QTY	Yes	No	No	No
GTAX_ITEM_ROLLUP	No	Yes	Yes	No
POS_MODS_TAX_INFO	No	Yes	Yes	No
L10N_BR_T_EXTAX_RES_RETAIL_DET	Yes	No	No	No
L10N_BR_FISCAL_RECLASS_NV	Yes	No	No	No
L10N_ATTRIB	Yes	No	No	No
L10N_ATTRIB_GROUP	Yes	No	No	No
EXT_ENTITY	Yes	No	No	No
ITEM_COUNTRY_L10N_EXT	No	Yes	Yes	No

I/O Specification

Not applicable

l10n_br_fiscal_reclass_item_setup_retail.ksh

This module looks at all the valid item/location combinations in RMS for items having their fiscal attributes changed. It determines the unique fiscal attribute groups that cover all the item/locations combinations and puts the groups on a stage table (L10N_BR_T_EXTAX_STG_RETAIL).

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_fiscal_reclass_item_setup_retail.ksh

Design Overview

This batch stores and maintains data that comes from the external tax engine like the TaxWeb Tax Rules.

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 11-5 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	None
Post-Processing	l10n_br_fiscal_reclass_item_process_retail.ksh
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-6 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_T_EXTAX_STG_RETAIL	Yes	Yes	Yes	Yes
L10N_BR_T_EXTAX_RES_RETAIL	No	No	No	Yes
L10N_BR_T_EXTAX_RES_RETAIL_DET	No	No	No	Yes
V_BR_T_STORE	Yes	No	No	No
L10N_BR_ENTITY_CNAE_CODES	Yes	No	No	No
V_BR_T_PARTNER	Yes	No	No	No
V_BR_T_WH	Yes	No	No	No
WH	Yes	No	No	No
L10N_BR_SUP_TAX_REGIME	Yes	No	No	No
ADDR	Yes	No	No	No
COUNTRY_TAX_JURISDICTION	Yes	No	No	No
COUNTRY	Yes	No	No	No
STATE	Yes	No	No	No
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	Yes	Yes	Yes
L10N_BR_T_EXTAX_DEST_GRP_HELP	Yes	Yes	Yes	Yes
EXT_ENTITY	Yes	No	No	No
L10N_ATTRIB_GROUP	Yes	No	No	No
L10N_ATTRIB	Yes	No	No	No
L10N_BR_FISCAL_RECLASS	Yes	Yes	No	No
ITEM_LOC	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
ITEM_SUPP_COUNTRY	Yes	No	No	No
ITEM_SUPP_COUNTRY_DIM	Yes	No	No	No
V_PACKSKU_QTY	Yes	No	No	No
L10N_BR_TAX_CALL_STAGE_ROUTING	Yes	No	No	No
V_BR_ITEM_FISCAL_ATTRIB	Yes	No	No	No
V_BR_T_SUPS	Yes	No	No	No
V_BR_ITEM_COUNTRY_ATTRIBUTES	Yes	No	No	No

I/O Specification

Not applicable

l10n_br_fiscal_loc_reclass_cost.ksh

This module deals with processing cost logic of an entity fiscal entity reclassification. This consists of identifying the effected item/supp/country/loc rows, creating the new cost_tax_recalc records and sending them to the cost engine. This logic is preformed when the fiscal entity reclass is initially created.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_fiscal_loc_reclass_cost.ksh

Design Overview

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL.FISCAL_LOC_RECLASS_COST package.

Scheduling Constraints

Table 11-7 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Daily
Scheduling Considerations	Phase 1
Pre-Processing	l10n_br_fiscal_loc_reclass_retail.ksh
Post-Processing	None
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-8 Tables Affected

Tables	Select	Insert	Update	Delete
COST_TAX_RECALC	Yes	Yes	No	No
ITEM_COST_HEAD	Yes	No	No	No
COUNTRY_ATTRIB	Yes	No	No	No
MV_L10N_ENTITY	Yes	No	No	No
ITEM_SUPP_COUNTRY_LOC	Yes	No	Yes	No
ITEM_SUPP_COUNTRY	No	No	No	No
L10N_BR_T_RECLASS_ENTITY	Yes	No	Yes	No
COST_EVENT	No	Yes	No	No

I/O Specification

Not applicable

l10n_br_fiscal_reclass_item_process_retail.ksh

This module picks the staged groups placed on L10N_BR_T_EXTAX_STG_RETAIL by l10n_br_fiscal_reclass_item_setup_retail.ksh and calls the external tax provider with them. The results of these calls are placed in the L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET tables.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_fiscal_reclass_item_process_retail.ksh

Design Overview

This batch stores and maintains data that comes from the external tax engine like the TaxWeb Tax Rules.

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 11-9 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	l10n_br_fiscal_reclass_item_setup_retail.ksh
Post-Processing	l10n_br_fiscal_reclass_item_finish_retail.ksh
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-10 Tables Affected

Tables	Select	Insert	Update	Delete
RETAIL_SERVICE_REPORT_URL	Yes	No	No	No

I/O Specification

Not applicable

l10n_br_fiscal_loc_reclass_retail.ksh

This batch job deals with processing retail logic of an entity fiscal entity reclassification. This consists of identifying the effected item/loc rows, calling the tax engine, and updating POS_MODS_TAX_INFO and GTAX_ITEM_ROLLUP. This logic is performed when the fiscal entity reclass is initially created.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_fiscal_loc_reclass_retail.ksh

Design Overview

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL.FISCAL_LOC_RECLASS_EXTAX_SETUP package.

Scheduling Constraints

Table 11-11 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Daily
Scheduling Considerations	Phase 1
Pre-Processing	None
Post-Processing	l10n_br_fiscal_loc_reclass_cost.ksh
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-12 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_FISCAL_RECLASS	Yes	No	No	No
ITEM_LOC	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
V_PACKSKU_QTY	Yes	No	No	No
L10N_BR_T_RECLASS_ENTITY	Yes	No	No	No
L10N_BR_T_EXTAX_STG_RETAIL	No	Yes	No	No
ITEM_SUPP_COUNTRY	Yes	No	No	No
GTAX_ITEM_ROLLUP	Yes	Yes	No	No
ITEM_SUPP_COUNTRY_DIM	Yes	No	No	No

I/O Specification

Not applicable

l10n_br_exec_tax_recalc.ksh

This batch job deals with executing fiscal entity reclass transactions. This logic is performed on the effective date of the fiscal entity reclassification. his consists of updating the cost fields on ITEM_SUPP_COUNTRY_LOC, ITEM_SUPP_COUNTRY and updating the localization extension tables with the new fiscal attribute values.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_exec_tax_recalc.ksh

Design Overview

The work is done in the L10N_BR_T_EXEC_RECLASS_SQL package.

Scheduling Constraints

Table 11-13 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Daily
Scheduling Considerations	Phase 3
Pre-Processing	l10n_br_fiscal_item_reclass_cost.ksh
Post-Processing	sccext.pc
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-14 Tables Affected

Tables	Select	Insert	Update	Delete
COST_TAX_RECALC	Yes	No	Yes	Yes
ITEM_COST_HEAD	Yes	No	No	No
COUNTRY_ATTRIB	Yes	No	No	No
MV_L10N_ENTITY	Yes	No	No	No
ITEM_SUPP_COUNTRY_LOC	Yes	No	Yes	No
ITEM_SUPP_COUNTRY	No	No	No	No
STORE_L10N_EXT	Yes	Yes	Yes	No
L10N_BR_T_RECLASS_ENTITY	Yes	No	No	No
WH_L10N_EXT	Yes	Yes	Yes	No
PARTNER_L10N_EXT	Yes	Yes	Yes	No
SUPS_L10N_EXT	Yes	Yes	Yes	No
L10N_BR_RECLASS_ENTITY_NV	Yes	No	No	No
L10N_ATTRIB	Yes	No	No	No
L10N_ATTRIB_GROUP	Yes	No	No	No
EXT_ENTITY	Yes	No	No	No
ITEM_COST_HEAD	Yes	Yes	Yes	No
ITEM_COST_DETAIL	Yes	Yes	Yes	Yes

I/O Specification

Not applicable

l10n_br_refresh_extax_finish_retail.ksh

This module writes the group level tax call results to GTAX_ITEM_ROLLUP and POS_MODS_TAX_INFO tables.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_refresh_extax_finish_retail.ksh

Design Overview

This module picks the group level tax call results that l10n_br_refresh_extax_process_retail.ksh places on L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET tables and explodes them back to the item/location level. It then uses the item/location level information to write tax information to GTAX_ITEM_ROLLUP and POS_MODS_TAX_INFO tables.

Scheduling Constraints

Table 11-15 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	l10n_br_refresh_extax_process_retail.ksh
Post-Processing	None
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-16 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_EXTAX_REFRESH_CONFIG	No	No	Yes	No
L10N_BR_T_EXTAX_HELP_RTL_GTT	Yes	Yes	No	No
ITEM_LOC	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
ITEM_SUPP_COUNTRY	Yes	No	No	No
ITEM_SUPP_COUNTRY_DIM	Yes	No	No	No
L10N_BR_T_EXTAX_RES_RETAIL	Yes	No	No	No
L10N_BR_T_EXTAX_DEST_GRP_HELP	Yes	No	No	No
V_BR_ITEM_FISCAL_ATTRIB	Yes	No	No	No
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	No	No	No
V_PACKSKU_QTY	Yes	No	No	No
GTAX_ITEM_ROLLUP	No	Yes	Yes	No
POS_MODS_TAX_INFO	No	Yes	Yes	No
L10N_BR_T_EXTAX_RES_RETAIL_DET	Yes	No	No	No
V_BR_ITEM_COUNTRY_ATTRIBUTES	Yes	No	No	No

I/O Specification

Not applicable

l10n_br_refresh_extax_future_cost.ksh

This module obtains a list of fiscal attributes that have tax law changes scheduled against them since its last run.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_refresh_extax_future_cost.ksh

Design Overview

This module obtains a list of fiscal attributes that have tax law changes scheduled against them since its last run. It then uses this information to determine what item/supplier/origin country/locations are affected by those scheduled tax law changes. These item/supplier/origin country/location combinations are then used to create new cost changes on the date of their tax law changes. The normal cost change processes then take care of updating RMS with the new tax law information when necessary.

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 11-17 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	None
Post-Processing	None
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-18 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_EXTAX_REFRESH_CONFIG	Yes	No	No	No
L10N_BR_T_TAX_CALL_RES_FSC_CNT	Yes	No	No	Yes
L10N_BR_EXTAX_REFRESH_COST	Yes	Yes	No	Yes
V_BR_T_STORE	Yes	No	No	No
L10N_BR_ENTITY_CNAE_CODES	Yes	No	No	No
V_BR_T_PARTNER	Yes	No	No	No
V_BR_T_WH	Yes	No	No	No
WH	Yes	No	No	No
V_BR_T_SUPS	Yes	No	No	No
L10N_BR_SUP_TAX_REGIME	Yes	No	No	No
ADDR	Yes	No	No	No
COUNTRY_TAX_JURISDICTION	Yes	No	No	No
COUNTRY	Yes	No	No	No
STATE	Yes	No	No	No
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	Yes	Yes	Yes
L10N_BR_T_EXTAX_DEST_GRP_HELP	Yes	Yes	Yes	Yes
L10N_ATTRIB	Yes	No	No	No
L10N_ATTRIB_GROUP	Yes	No	No	No
EXT_ENTITY	Yes	No	No	No
L10N_BR_T_TAX_CALL_STG_FSC_FDN	Yes	Yes	No	Yes
L10N_BR_TAX_CALL_STAGE_ROUTING	Yes	Yes	No	Yes
RETAIL_SERVICE_REPORT_URL	Yes	No	No	No
L10N_BR_T_TAX_CALL_STAGE_RMS	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_TAXCNTR	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_SRVCPRD	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ECO_CLS	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ITM_RL	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ITM_TAX	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ITM	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ECO	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_FIS_ENTITY	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ITEM	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_NAME_VALUE	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ORDER	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ORDER_EXP	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ORDER_INFO	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_REGIME	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_FSC_FND	Yes	No	No	Yes
L10N_BR_EXTAX_REFRESH_GTT	Yes	Yes	No	Yes
GTAX_COST_CHANGE_GTT	Yes	Yes	Yes	No
ITEM_MASTER	Yes	No	No	No
ITEM_SUPP_COUNTRY_LOC	Yes	No	No	No
COST_SUSP_SUP_HEAD	No	Yes	No	No
COST_SUSP_SUP_DETAIL_LOC	No	Yes	No	No
COST_EVENT_COST_CHG	Yes	Yes	No	No
COST_EVENT	Yes	Yes	No	No
COST_EVENT_RESULT	Yes	No	No	No
COST_EVENT_RUN_TYPE_CONFIG	Yes	No	No	No
L10N_BR_FISCAL_RECLASS_NV	Yes	No	No	No
L10N_BR_FISCAL_RECLASS	Yes	No	No	No
VAT_CODES	Yes	No	No	No
COUNTRY_ATTRIB	Yes	No	No	No
FM_SYSTEM_OPTIONS	Yes	No	No	No
L10N_BR_T_EXTAX_STG_COST	Yes	No	No	No
L10N_BR_T_EXTAX_RES_COST	No	Yes	No	No
V_BR_ITEM_FISCAL_ATTRIB	Yes	No	No	No
ITEM_SUPPLIER	Yes	No	No	No
ITEM_LOC	Yes	No	No	No
COST_EVENT_DEAL	Yes	No	No	No
COST_EVENT_RESULT	No	Yes	No	No

I/O Specification

Not applicable

l10n_br_refresh_extax_process_retail.ksh

This module picks the staged groups placed in the L10N_BR_T_EXTAX_STG_RETAIL table by l10n_br_refresh_extax_setup_retail.ksh and calls the external tax provider with them. The results of these calls are placed on the L10N_BR_T_EXTAX_RES_RETAIL and L10N_BR_T_EXTAX_RES_RETAIL_DET tables.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_refresh_extax_process_retail.ksh

Design Overview

This module picks the staged groups placed in the staging table by l10n_br_refresh_extax_setup_retail.ksh and calls the external tax provider with them. The results of these calls are placed on the staging tables.

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 11-19 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	l10n_br_refresh_extax_setup_retail.ksh
Post-Processing	l10n_br_refresh_extax_finish_retail.ksh
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-20 Tables Affected

Tables	Select	Insert	Update	Delete
RETAIL_SERVICE_REPORT_URL	Yes	No	No	No
L10N_BR_TAX_CALL_STAGE_ROUTING	Yes	No	No	No
VAT_CODES	Yes	No	No	No
L10N_BR_T_EXTAX_STG_RETAIL	Yes	No	No	No
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	No	No	No
L10N_BR_T_EXTAX_RES_RETAIL	No	Yes	No	No
L10N_BR_T_EXTAX_RES_RETAIL_DET	No	Yes	No	No

I/O Specification

Not applicable

l10n_br_refresh_extax_setup_retail.ksh

This module obtains a list of fiscal attributes that have tax law changes scheduled against them since the last run.

Functional Area

TaxWeb Tax Rules Integration

Module Affected

l10n_br_refresh_extax_setup_retail.ksh

Design Overview

This module obtains a list of fiscal attributes that have tax law changes scheduled against them since the last run. It then uses this information to determine what item/locations are affected by those scheduled tax law changes. It determines the unique fiscal attribute groups that cover those item/locations combinations and puts the groups on a stage table (L10N_BR_T_EXTAX_STG_RETAIL).

The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 11-21 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Adhoc
Scheduling Considerations	Phase 1
Pre-Processing	Not applicable
Post-Processing	l10n_br_refresh_extax_process_retail.ksh
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-22 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_EXTAX_REFRESH_CONFIG	Yes	No	No	No
L10N_BR_T_TAX_CALL_RES_FSC_CNT	Yes	No	No	No
L10N_BR_EXTAX_REFRESH_RETAIL	Yes	Yes	No	Yes
L10N_BR_T_EXTAX_STG_RETAIL	Yes	Yes	No	Yes
L10N_BR_T_EXTAX_RES_RETAIL	No	No	No	Yes
L10N_BR_T_EXTAX_RES_RETAIL_DET	No	No	No	Yes
L10N_BR_T_TAX_CALL_STG_FSC_FDN	Yes	Yes	No	Yes
L10N_BR_TAX_CALL_STAGE_ROUTING	Yes	Yes	No	No
RETAIL_SERVICE_REPORT_URL	Yes	No	No	No
L10N_BR_T_TAX_CALL_STAGE_RMS	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_TAXCNTR	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_SRVCPRD	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ECO_CLS	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ITM_RL	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ITM_TAX	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_ITM	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ECO	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_FIS_ENTITY	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ITEM	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_NAME_VALUE	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ORDER	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ORDER_EXP	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_ORDER_INFO	Yes	No	No	Yes
L10N_BR_T_TAX_STAGE_REGIME	Yes	No	No	Yes
L10N_BR_T_TAX_CALL_RES_FSC_FND	Yes	No	No	Yes
L10N_BR_EXTAX_REFRESH_GTT	Yes	Yes	Yes	Yes
V_BR_ITEM_FISCAL_ATTRIB	Yes	No	No	No
V_BR_T_STORE	Yes	No	No	No
L10N_BR_ENTITY_CNAE_CODES	Yes	No	No	No
V_BR_T_PARTNER	Yes	No	No	No
V_BR_T_WH	Yes	No	No	No
WH	Yes	No	No	No
V_BR_T_SUPS	Yes	No	No	No
L10N_BR_SUP_TAX_REGIME	Yes	No	No	No
ADDR	Yes	No	No	No
COUNTRY_TAX_JURISDICTION	Yes	No	No	No
COUNTRY	Yes	No	No	No
STATE	Yes	No	No	No
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	Yes	Yes	Yes
L10N_BR_T_EXTAX_DEST_GRP_HELP	Yes	Yes	Yes	Yes
ITEM_MASTER	Yes	No	No	No
ITEM_LOC	Yes	No	No	No
ITEM_SUPP_COUNTRY	Yes	No	No	No
ITEM_SUPP_COUNTRY_DIM	Yes	No	No	No
V_PACKSKU_QTY	Yes	No	No	No
VAT_CODES	Yes	No	No	No
L10N_BR_T_TAX_CALL_RES_FSC_CNT	No	No	No	Yes
L10N_BR_TAX_CALL_STAGE_ROUTING	No	No	No	Yes
L10N_ATTRIB	Yes	No	No	No
L10N_ATTRIB_GROUP	Yes	No	No	No
EXT_ENTITY	Yes	No	No	No

I/O Specification

Not applicable

fm_stock_position.ksh

This module provides information about a snapshot of the stock position in RMS in table fm_stock_position.

Functional Area

Stock

Module Affected

fm_stock_position.ksh

Design Overview

This batch can be scheduled ad-hoc and there is any other batch dependency or prepost execution.

Figure 11-4 Stock Position - Main Flow

Scheduling Constraints

Table 11-23 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Ad-hoc
Scheduling Considerations	Ad-hoc
Pre-Processing	Not applicable
Post-Processing	Not applicable
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-24 Tables Affected

Tables	Select	Insert	Update	Delete
WH	Yes	No	No	No
STORE	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
ITEM_LOC_SOH	Yes	No	No	No
PACKITEM_BREAKOUT	Yes	No	No	No
FM_SYSTEM_OPTIONS	Yes	No	No	No
FM_FISCAL_DOC_HEADER	Yes	No	No	No
FM_FISCAL_DOC_DETAIL	Yes	No	No	No
TSFHEAD	Yes	No	No	No
FM_STOCK_POSITION	Yes	Yes	No	No

fmmanifest.ksh

This module is to send to SEFAZ some NFes that were previously rejected during IRL NFe reception process. It will be process NFes with status:

305- REFUSED BY DISAGREEMENT
306- REFUSED AUTOMATICALLY AFTER PRE-VALIDATION
6- REFUSED RECEIVING
802- PHYSICAL RECEIVING REFUSED

Functional Area

NFe Integration

Module Affected

fmmanifest.ksh

Design Overview

This batch can be scheduled ad-hoc and there is any other batch dependency or prepost execution.

Scheduling Constraints

Table 11-25 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Ad-hoc
Scheduling Considerations	Ad-hoc
Pre-Processing	Not applicable
Post-Processing	Not applicable
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-26 Tables Affected

Tables	Select	Insert	Update	Delete
FM_IRL_STATUS	Yes	No	No	No
FM_IRL_HEADER	Yes	No	No	No
FM_FISCAL_DOC_HEADER	Yes	No	No	No
FM_UTILIZATION_ATTRIBUTES	Yes	No	No	No
FM_STG_NFE	Yes	Yes	No	No

fm_generate_nf_stkcount.ksh

This module creates a NF for inventory adjustment where there is some quantity discrepancy as result of general inventory process.

Functional Area

NFe Integration

Module Affected

fm_generate_nf_stkcount.ksh

Design Overview

This batch can be scheduled ad-hoc and there is any other batch dependency or prepost execution.

Scheduling Constraints

Table 11-27 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Ad-hoc
Scheduling Considerations	Ad-hoc
Pre-Processing	Not applicable
Post-Processing	Not applicable
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-28 Tables Affected

Tables	Select	Insert	Update	Delete
FM_SYSTEM_OPTIONS	Yes	No	No	No
FM_FISCAL_DOC_HEADER	No	Yes	No	No
FM_FISCAL_DOC_DETAIL	No	Yes	No	No
FM_TRAN_DATA_HISTORY	No	Yes	No	No
FM_FISCAL_UTILIZATION	Yes	Yes	No	No
FM_UTIL_ADJUST_REASON	Yes	No	No	No
FM_STG_ADJUST_DTL	Yes	No	No	No

fm_reprocess_nf_status_f.ksh

This module reprocesses all NFe with status F (Post Sefaz Approve Error) to A (Approved).

Functional Area

NFe Integration

Module Affected

fm_reprocess_nf_status_f.ksh

Design Overview

This batch can be scheduled ad-hoc and there is any other batch dependency or prepost execution.

Scheduling Constraints

Table 11-29 Scheduling Constraints

Schedule Information	Description
Processing Cycle	Ad-hoc
Scheduling Considerations	Ad-hoc
Pre-Processing	Not applicable
Post-Processing	Not applicable
Threading Scheme	Not applicable

Restart/Recovery

Not applicable

Key Tables Affected

Table 11-30 Tables Affected

Tables	Select	Insert	Update	Delete
FM_FISCAL_DOC_HEADER	Yes	No	Yes	No
FM_SCHEDULE	Yes	No	Yes	No