12 Maintaining Tax Related Data - Synchro

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

Note: ORFM Release 14.1.3 does not support Synchro tax engine integration.

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 Synchro Tax Engine

Perform the following steps to install an updated set of rules from Synchro Tax Engine:

1. Create a separate Synchro schema in the same data base where RMS/ORFM is installed for importing the Synchro dump from Synchro.

2. Provide the following Grants for the new Synchro schema:

   • CREATE SESSION

   • UNLIMITED TABLESPACE

   • CREATE TABLE

   • CREATE PROCEDURE

   • CREATE TRIGGER

   • CREATE SEQUENCE

   • CREATE SYNONYM

   • CREATE VIEW

3. Create synonym for the following ORFM system in the newly created Synchro schema:

   • L10N_BR_TAX_CALL_REQ

   • L10N_BR_TAX_CALC_REQ_HEAD

   • L10N_BR_TAX_CALC_REQ_REG

   • L10N_BR_TAX_CALC_REQ_ITEM

   • L10N_BR_TAX_CALC_REQ_IT_TAX

   • L10N_BR_TAX_CALC_REQ_FREIGHT

   • L10N_BR_TAX_CALC_REQ_NV_PAIR

   • L10N_BR_TAX_CALC_REQ_CNAE

   • L10N_BR_BULK_ST_REQ

   • L10N_BR_FISCAL_QUERY_REQ

   • L10N_BR_FISCAL_REF_REQ_HEAD

   • L10N_BR_TAX_CALC_REQ_CONTRIB

   • L10N_BR_TAX_CALC_RES_HEAD

   • L10N_BR_TAX_CALC_RES_HD_TAX

   • L10N_BR_TAX_CALC_RES_ITEM

   • L10N_BR_TAX_CALC_RES_IT_TAX

   • L10N_BR_TAX_CALC_RES_FREIGHT

   • L10N_BR_FISCAL_QUERY_RES

   • L10N_BR_FISCAL_REF_RES_HEAD

4. Provide SELECT and REFERENCES Grants for the ORFM system to the new Synchro schema.

5. Provide INSERT, UPDATE, and DELETE Grants for the following ORFM system to the new Synchro schema:

   • L10N_BR_TAX_CALC_RES_HEAD

   • L10N_BR_TAX_CALC_RES_HD_TAX

   • L10N_BR_TAX_CALC_RES_ITEM

   • L10N_BR_TAX_CALC_RES_IT_TAX

   • L10N_BR_TAX_CALC_RES_FREIGHT

   • L10N_BR_FISCAL_QUERY_RES

   • L10N_BR_FISCAL_REF_RES_HEAD

6. Create synonym for the Synchro API in the RMS/ORFM Schema and provide EXECUTE Grant on the following object to RMS/ORFM schema:

   • ORT_SYN_TAX_CALL

Note: The set of tax rules in Synchro schema is normally created as part of implementation. If a dump with rules needs to be added the above steps must be followed.

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:

• 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_S_EXTAX_STG_RETAIL).

• l10n_br_fiscal_reclass_item_process_retail.ksh – This module picks the staged groups placed on L10N_BR_S_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_S_EXTAX_RES_RETAIL and L10N_BR_S_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_S_EXTAX_RES_RETAIL and L10N_BR_S_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_S_EXTAX_STG_RETAIL).

• l10n_br_refresh_extax_process_retail.ksh – This module picks the staged groups placed on L10N_BR_S_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_S_EXTAX_RES_RETAIL and L10N_BR_S_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_S_EXTAX_RES_RETAIL and L10N_BR_S_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 12-1 Retail Tax Flow

Figure 12-2 Cost Tax Flow

Figure 12-3 Cost Tax Flow Maintenance

Maintaining External Tax Information (L10N_BR_S_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 Synchro that the sales tax is moving from 10% to 12% in São 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_S_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

Synchro 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 Synchro.

The work is done in the L10N_BR_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-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 12-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_S_EXTAX_RES_RETAIL and L10N_BR_S_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

Synchro 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 Synchro.

The work is done in the L10N_BR_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-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 12-4 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_S_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_S_EXTAX_RES_RETAIL	Yes	No	No	No
L10N_BR_FISCAL_RECLASS	Yes	No	Yes	No
L10N_BR_S_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_S_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_S_EXTAX_STG_RETAIL).

Functional Area

Synchro 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 Synchro.

The work is done in the L10N_BR_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-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 12-6 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_S_EXTAX_STG_RETAIL	Yes	Yes	Yes	Yes
L10N_BR_S_EXTAX_RES_RETAIL	No	No	No	Yes
L10N_BR_S_EXTAX_RES_RETAIL_DET	No	No	No	Yes
V_BR_S_STORE	Yes	No	No	No
L10N_BR_ENTITY_CNAE_CODES	Yes	No	No	No
V_BR_S_PARTNER	Yes	No	No	No
V_BR_S_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_S_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
V_BR_ITEM_FISCAL_ATTRIB	Yes	No	No	No
V_BR_S_SUPS	Yes	No	No	No
V_BR_ITEM_COUNTRY_ATTRIBUTES	Yes	No	No	No

I/O Specification

Not applicable

10n_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

Synchro Integration

Module Affected

l10n_br_fiscal_loc_reclass_cost.ksh

Design Overview

The work is done in the L10N_BR_S_EXTAX_MAINT_SQL.RECLASS_LOC_COST package.

Scheduling Constraints

Table 12-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 12-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_S_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_S_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_S_EXTAX_RES_RETAIL and L10N_BR_S_EXTAX_RES_RETAIL_DET tables.

Functional Area

Synchro 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 Synchro.

The work is done in the L10N_BR_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-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 12-10 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_EXTAX_SEED_RET_STATUS	Yes	No	Yes	No
FM_SYSTEM_OPTIONS	Yes	No	No	No
L10N_BR_TAX_CALL_REQ	No	Yes	No	Yes
L10N_BR_TAX_CALC_REQ_HEAD	Yes	Yes	No	Yes
L10N_BR_S_EXTAX_STG_RETAIL	Yes	No	No	No
L10N_BR_EXTAX_SEED_RET_STATUS	Yes	No	No	No
L10N_BR_TAX_CALC_REQ_REG	No	Yes	No	No
L10N_BR_ENTITY_TAX_REGIME	Yes	Yes	No	No
VAT_CODES	Yes	No	No	No
COUNTRY_ATTRIB	Yes	No	No	No
L10N_BR_TAX_CALC_REQ_ITEM	No	Yes	No	Yes
L10N_BR_TAX_CALC_REQ_NV_PAIR	No	Yes	No	Yes
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	No	No	No
L10N_BR_S_EXTAX_RES_COST	No	Yes	No	No
L10N_BR_TAX_CALC_RES_HEAD	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_ITEM	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_IT_TAX	Yes	No	No	Yes
L10N_BR_S_EXTAX_RES_COST_DET	No	Yes	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

Synchro Integration

Module Affected

l10n_br_fiscal_loc_reclass_retail.ksh

Design Overview

The work is done in the RECLASS_LOC_RETAIL_SETUP, SEED_RETAIL_PROCESS, and RECLASS_LOC_RETAIL_FINISH functions of L10N_BR_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-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 12-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_S_RECLASS_ENTITY	Yes	No	No	No
L10N_BR_S_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

Synchro Integration

Module Affected

l10n_br_exec_tax_recalc.ksh

Design Overview

The work is done in the L10N_BR_S_EXEC_RECLASS_SQL package.

Scheduling Constraints

Table 12-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 12-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_S_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

Synchro 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_S_EXTAX_RES_RETAIL and L10N_BR_S_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 12-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 12-16 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_EXTAX_REFRESH_CONFIG	No	No	Yes	No
L10N_BR_S_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_S_EXTAX_RES_RETAIL	Yes	No	No	No
L10N_BR_S_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_S_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

Synchro 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_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-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 12-18 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_EXTAX_REFRESH_CONFIG	Yes	No	No	No
L10N_BR_EXTAX_REFRESH_COST	Yes	Yes	No	Yes
V_BR_S_STORE	Yes	No	No	No
L10N_BR_ENTITY_CNAE_CODES	Yes	No	No	No
V_BR_S_PARTNER	Yes	No	No	No
V_BR_S_WH	Yes	No	No	No
WH	Yes	No	No	No
V_BR_S_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_S_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_TAX_CALC_STAGE_RMS	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_IT_TAX	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_ITEM	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_HEAD	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
L10N_BR_S_EXTAX_STG_COST	Yes	No	No	No
COUNTRY_ATTRIB	Yes	No	No	No
FM_SYSTEM_OPTIONS	Yes	No	No	No
L10N_BR_S_EXTAX_STG_COST	Yes	No	No	No
L10N_BR_S_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_S_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_S_EXTAX_RES_RETAIL and L10N_BR_S_EXTAX_RES_RETAIL_DET tables.

Functional Area

Synchro 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_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-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 12-20 Tables Affected

Tables	Select	Insert	Update	Delete
VAT_CODES	Yes	No	No	No
L10N_BR_S_EXTAX_STG_RETAIL	Yes	No	No	No
L10N_BR_EXTAX_HELP_NV_PAIR	Yes	No	No	No
L10N_BR_S_EXTAX_RES_RETAIL	No	Yes	No	No
L10N_BR_S_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

Synchro 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_S_EXTAX_STG_RETAIL).

The work is done in the L10N_BR_S_EXTAX_MAINT_SQL package.

Scheduling Constraints

Table 12-21 Scheduling Constraints

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

Restart/Recovery

Not applicable

Key Tables Affected

Table 12-22 Tables Affected

Tables	Select	Insert	Update	Delete
L10N_BR_EXTAX_REFRESH_CONFIG	Yes	No	No	No
L10N_BR_EXTAX_REFRESH_RETAIL	Yes	Yes	No	Yes
L10N_BR_S_EXTAX_STG_RETAIL	No	Yes	Yes	Yes
L10N_BR_S_EXTAX_RES_RETAIL	No	No	No	Yes
L10N_BR_S_EXTAX_RES_RETAIL_DET	No	No	No	Yes
L10N_BR_TAX_CALC_STAGE_RMS	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_IT_TAX	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_ITEM	Yes	No	No	Yes
L10N_BR_TAX_CALC_RES_HEAD	Yes	No	No	Yes
L10N_BR_EXTAX_REFRESH_GTT	Yes	Yes	Yes	Yes
V_BR_ITEM_FISCAL_ATTRIB	Yes	No	No	No
V_BR_S_STORE	Yes	No	No	No
L10N_BR_ENTITY_CNAE_CODES	Yes	No	No	No
V_BR_S_PARTNER	Yes	No	No	No
V_BR_S_WH	Yes	No	No	No
WH	Yes	No	No	No
V_BR_S_SUPS	Yes	No	N	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_S_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_S_EXTAX_STG_RETAIL	Yes	No	No	No
L10N_BR_S_EXTAX_RES_RETAIL	No	Yes	No	No
L10N_BR_S_EXTAX_RES_RETAIL_DET	No	Yes	No	No
L10N_ATTRIB	Yes	No	No	No
L10N_ATTRIB_GROUP	Yes	No	No	No
EXT_ENTITY	Yes	No	No	No

I/O Specification

Not applicable