Oracle® Retail Fiscal Management/RMS Brazil Localization Implementation Guide Release 14.1.3 E83329-02 |
|
Previous |
Next |
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:
Perform the following steps to install an updated set of rules from Synchro Tax Engine:
Create a separate Synchro schema in the same data base where RMS/ORFM is installed for importing the Synchro dump from Synchro.
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
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
Provide SELECT and REFERENCES Grants for the ORFM system to the new Synchro schema.
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
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. |
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
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.
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.
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.
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.
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.
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:
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.
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.
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 |
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.
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.
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 |
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).
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.
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 |
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.
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 |
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.
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.
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 |
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.
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.
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 |
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.
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 |
This module writes the group level tax call results to GTAX_ITEM_ROLLUP and POS_MODS_TAX_INFO tables.
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.
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 |
This module obtains a list of fiscal attributes that have tax law changes scheduled against them since its last run.
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.
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 |
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.
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.
This module obtains a list of fiscal attributes that have tax law changes scheduled against them since the last run.
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.
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 |