XSD Element Name | XSD Element Data Type | XSD Min Occurs | XSD Max Occurs | XSD Element Description | Mapping for FiscDocTaxRBO in RFM application. |
RFM's Table Name | RFM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RFM's Column Length | Is Column Required in RFM's API? | RFM's API Description |
document_number | varchar225 | 1 | 1 | Indicates the Fiscal document number. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
fiscal_document_date | xs:dateTime | 1 | 1 | Indicates the Fiscal Document Date. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
src_entity_code | varchar2250 | 0 | 1 | Indicates the Legal Entity Code for the source location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
src_entity_type | varchar2250 | 0 | 1 | Indicates the Entity Type of the source location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
src_addr_city_id | varchar210 | 0 | 1 | Indicates the City Id or Code of the source location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
src_federal_tax_reg_id | varchar2250 | 0 | 1 | Indicates the Federal Tax Registration Number of the source location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
SrcEcoClassCd | * | 0 | unbounded | Indicates the National economic classification code of the source location. | | | | | | |
SrcTaxContributor | * | 0 | unbounded | Description is not available. | | | | | | |
SrcDiffTaxRegime | * | 0 | unbounded | Indicates the Tax Regime of a Supplier (Source Scenario) which will enable to have a reduction in tax basis amount. | | | | | | |
src_is_income_range_eligible | varchar21 | 0 | 1 | Indicates whether the Supplier's income range (Source Scenario) is eligible for a reduction in tax basis. Possible values are "Y" or "N" | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No mapping column found in RFM. |
src_is_distr_a_manufacturer | varchar21 | 0 | 1 | (Source Scenario) Indicates whether the Distributor is a Manufacturer also. Possible values are "Y" or "N" | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
src_icms_simples_rate | number20_4 | 0 | 1 | (Source Scenario) Indicates the ICMS rate of a supplier participating in SIMPLES regime. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
src_is_rural_producer | varchar21 | 0 | 1 | Indicates whether the Source is a Rural Producer or not.Possible values are "Y" or "N" | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | Fill this description. |
src_is_simples_contributor | varchar21 | 0 | 1 | Indicates If the company is part of the 'SIMPLES' regime.Possible values are 'Y' or 'N' | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | Fill this description. |
SrcNameValPair | * | 0 | unbounded | Represents 1 to many Name Value Pair objects. | | | | | | |
dst_entity_code | varchar2250 | 0 | 1 | Indicates the Legal Entity Code of the destination location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
dst_entity_type | varchar2250 | 0 | 1 | Indicates the Entity Type of the destination location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
dst_addr_city_id | varchar210 | 0 | 1 | Indicates the City Id or Code of the destination location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
dst_federal_tax_reg_id | varchar2250 | 0 | 1 | Indicates the Federal Tax Registration Number of the destination location. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
DstEcoClassCd | * | 0 | unbounded | Indicates the National economic classification code of the destination location. | | | | | | |
DstDiffTaxRegime | * | 0 | unbounded | Indicates the Tax Regime of a Supplier (Destination Scenario) which will enable to have a reduction in tax basis amount. | | | | | | |
dst_is_income_range_eligible | varchar21 | 0 | 1 | (Destination Scenario)Indicates whether the Supplier's income range is eligible for a reduction in tax basis. Possible values are "Y" or "N" | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | Fill this description. |
dst_is_distr_a_manufacturer | varchar21 | 0 | 1 | (Destination Scenario)Indicates whether the Distributor is a Manufacturer also. Possible values are "Y" or "N" | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
dst_icms_simples_rate | number20_4 | 0 | 1 | (Destination Scenario) Indicates the ICMS rate of a supplier participating in SIMPLES regime. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | No column mapping found in RFM. |
DstTaxContributor | * | 0 | unbounded | Description is not available. | | | | | | |
DstNameValPair | * | 0 | unbounded | Represents 1 to many Name Value Pair objects. | | | | | | |
disc_merch_cost | number20_4 | 0 | 1 | Indicates the discounted merchandise cost. | fm_fiscal_doc_header | total_item_calc_value | NUMBER | 20,4 | No | It stores the cost of all merchandise of the fiscal document calculated by the system. |
total_cost | number20_4 | 0 | 1 | Indicates the total cost of the items. | fm_fiscal_doc_header | total_doc_calc_value | NUMBER | 20,4 | No | It stores the total value of the fiscal document calculated by the system. |
total_services_cost | number20_4 | 0 | 1 | Indicates the total services cost of the items. | fm_fiscal_doc_header | total_serv_calc_value | NUMBER | 20,4 | No | It stores the cost of all services of the fiscal document calculated by the system. |
calculation_status | varchar21 | 0 | 1 | Indicates the Mastersaf response status. W - Warning, E - Error, S - Success, I - With Inconclusive Rules AI - With Warning and Inconclusive Rules | fm_tax_call_hdr_res | CALCULATION_STATUS | VARCHAR2 | 1 | Yes | It holds the results coming from the external tax engine at the header level. |
LineItemTaxRBO:LineItemTaxRBO | * | 0 | unbounded | Represents 1 to many LineItemTaxRBO. | NA | NA | NA | NA | NA | NA |
Messages | * | 0 | unbounded | Description is not available. | | | | | | |
TaxDetRBO:TaxDetRBO | * | 0 | unbounded | Represents 1 to many TaxDetRBO. | NA | NA | NA | NA | NA | NA |
FreightRBO:FreightRBO | * | 0 | unbounded | Represents 1 to many FreightRBO. | NA | NA | NA | NA | NA | NA |
reduced_icms_tax | number20_4 | 0 | 1 | This column indicates the reduced ICMS Tax value for sales or transfers done to a free zone. | Fill application table name. | Fill table column name. | RIB or/and RSB or/and RSL | Fill column length. | Yes | Fill this description. |