Oracle® Retail Fiscal Management/RMS Brazil Localization Implementation Guide Release 14.1.3.1 E91382-02 |
|
![]() Previous |
![]() Next |
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:
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).
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:
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.
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_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.
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 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:
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 the TaxWeb Tax Rules.
The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.
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 |
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.
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.
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 |
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).
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.
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 |
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 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 |
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.
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.
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 L10N_BR_T_EXTAX_MAINT_SQL.FISCAL_LOC_RECLASS_EXTAX_SETUP package.
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 |
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 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 |
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_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.
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 |
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_T_EXTAX_MAINT_SQL package.
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 |
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.
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.
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 |
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_T_EXTAX_STG_RETAIL).
The work is done in the L10N_BR_T_EXTAX_MAINT_SQL package.
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 |
This module provides information about a snapshot of the stock position in RMS in table fm_stock_position.
This batch can be scheduled ad-hoc and there is any other batch dependency or prepost execution.
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 |
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
This batch can be scheduled ad-hoc and there is any other batch dependency or prepost execution.
This module creates a NF for inventory adjustment where there is some quantity discrepancy as result of general inventory process.
This batch can be scheduled ad-hoc and there is any other batch dependency or prepost execution.