/TMF/D_SERVICOS - Utilities information by item
Utilities information by item information is stored in SAP table /TMF/D_SERVICOS.
It is part of development package /TMF/CTR in software component FIN-TMF-BR. This development package consists of objects that can be grouped under "Tax Management Framework Brazil: Central Tax Repository".
It is part of development package /TMF/CTR in software component FIN-TMF-BR. This development package consists of objects that can be grouped under "Tax Management Framework Brazil: Central Tax Repository".
Fields for table /TMF/D_SERVICOS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| EMPRESA | Company Code | X | /TMF/DE_EMPRESA | CHAR | 8 | |
| FILIAL | Branch | X | /TMF/DE_FILIAL | CHAR | 8 | |
| COD_MOD | Code of tax document model | X | /TMF/DE_COD_MOD | CHAR | 4 | |
| NUM_DOC | Tax document number | X | /TMF/DE_NUM_DOC | CHAR | 18 | |
| SER | Tax document series | X | /TMF/DE_SER | CHAR | 8 | |
| NUM_ITEM | Item Number | X | /TMF/DE_NUM_ITEM | CHAR | 6 | |
| DT_DOC | Document Date | X | /TMF/DE_DT_DOC | CHAR | 16 | |
| COD_MUN | City Code | /TMF/DE_COD_MUN | CHAR | 14 | ||
| NRO_ORD | Sequential Order Number | /TMF/DE_NRO_ORD | CHAR | 18 | ||
| SER_CONV | Agreement Series | /TMF/DE_SER_CONV | CHAR | 6 | ||
| SUB | Fiscal Document Subseries Number | /TMF/DE_SUB | CHAR | 6 | ||
| IND_REC | Indicator of composition of income received in the period | /TMF/DE_IND_REC | CHAR | 4 | ||
| COD_SIT | Code of tax document situation | /TMF/DE_COD_SIT | CHAR | 4 | ||
| COD_PART | [OBSOLETE] Participant Code | CHAR | 120 | |||
| COD_CONS | Code of the class of energy consumption | /TMF/DE_COD_CONS | CHAR | 4 | ||
| DT_APUR | Calculation date | /TMF/DE_DT_APUR | CHAR | 16 | ||
| COD_AUTH | Authentication Code | /TMF/DE_COD_AUTH | CHAR | 64 | ||
| NUM_TEL | [OBSOLETE]: Use field NUM_UNIDADE_CONSUMIDORA to report info | CHAR | 24 | |||
| REF_DOC_ITEM | NF item reference | /TMF/DE_REF_DOC_ITEM | CHAR | 18 | ||
| QTD_CONS_DOC | Consolidated Documents Quantity | /TMF/DE_QTD_CONS_DOC | INT4 | 4 | ||
| VL_SERV_DOC | Value of ICMS taxed services | /TMF/DE_VL_SERV_DOC | DEC | 13 | ||
| VL_SERV_NT_DOC | Value of ICMS untaxed services | /TMF/DE_VL_SERV_NT_DOC | DEC | 13 | ||
| VL_TERC_DOC | Values charged on behalf of third party | /TMF/DE_VL_TERC_DOC | DEC | 13 | ||
| UF_COD_MUN | UF from COD_MUN | /TMF/DE_UF_COD_MUN | CHAR | 4 | ||
| COD_CLASS | Classification code of the service item | /TMF/DE_COD_CLASS | CHAR | 8 | ||
| COD_ITEM | Item Code | /TMF/DE_COD_ITEM | CHAR | 120 | ||
| DESCR_COMPL | Complementary description | /TMF/DE_DESCR_COMPL | CHAR | 510 | ||
| QTD | Amount | /TMF/DE_QTD | DEC | 13 | ||
| QTD_CONTRATADA | Contracted amount | /TMF/DE_QTD_CONTRATADA | DEC | 13 | ||
| QTD_FORNECIDA | Supplied amount | /TMF/DE_QTD_FORNECIDA | DEC | 13 | ||
| UNID | Base Unit of Measure | /TMF/DE_UNID | CHAR | 12 | ||
| CFOP | CFOP (Tax code of operation and installment) | /TMF/DE_CFOP | CHAR | 8 | ||
| VL_ITEM | Item Value | /TMF/DE_VL_ITEM | DEC | 13 | ||
| VL_DESC | Value of Items Commercial Discount | /TMF/DE_VL_DESC | DEC | 13 | ||
| VL_DA | Value of incidental expenses | /TMF/DE_VL_DA | DEC | 13 | ||
| VL_OPR | Operation Value | /TMF/DE_VL_OPR | DEC | 13 | ||
| VL_OPR_ISENTO | Exempt operation value | /TMF/DE_VL_OPR_ISENTO | DEC | 13 | ||
| VL_OUTRAS | Other Values | /TMF/DE_VL_OUTRAS | DEC | 13 | ||
| VL_RED_BC | ICMS Reduced base | /TMF/DE_VL_RED_BC | DEC | 13 | ||
| CST_ICMS | Fiscal Situation Code | /TMF/DE_CST_ICMS | CHAR | 6 | ||
| ALIQ_ICMS | ICMS Aliquot | /TMF/DE_ALIQ_ICMS | DEC | 13 | ||
| VL_BC_ICMS | ICMS Base Accumulated Value | /TMF/DE_VL_BC_ICMS | DEC | 13 | ||
| VL_ICMS | ICMS Accumulated Value | /TMF/DE_VL_ICMS | DEC | 13 | ||
| VL_BC_ICMS_UF | ICMS Base Accumulated Value | /TMF/DE_VL_BC_ICMS | DEC | 13 | ||
| VL_ICMS_UF | ICMS Accumulated Value | /TMF/DE_VL_ICMS | DEC | 13 | ||
| CST_PIS | Tax Situation Code related to PIS/PASEP | /TMF/DE_CST_PIS | CHAR | 4 | ||
| ALIQ_PIS | PIS/PASEP Tax Rate (%) | /TMF/DE_ALIQ_PIS | DEC | 13 | ||
| VL_BC_PIS | Value of Calculation Basis of PIS/PASEP | /TMF/DE_VL_BC_PIS | DEC | 13 | ||
| VL_PIS | PIS/PASEP Value | /TMF/DE_VL_PIS | DEC | 13 | ||
| CST_COFINS | Tax Situation Code related to COFINS | /TMF/DE_CST_COFINS | CHAR | 4 | ||
| ALIQ_COFINS | COFINS Tax Rate (%) | /TMF/DE_ALIQ_COFINS | DEC | 13 | ||
| VL_BC_COFINS | Value of Calculation Basis for COFINS | /TMF/DE_VL_BC_COFINS | DEC | 13 | ||
| VL_COFINS | COFINS Value | /TMF/DE_VL_COFINS | DEC | 13 | ||
| COD_CTA | Account Code (Chart) | /TMF/DE_COD_CTA_PLN | CHAR | 200 | ||
| COD_OBS | Observation Code | /TMF/DE_COD_OBS | CHAR | 12 | ||
| COD_AUTH_REG_CAD | Authentication Code of Register - Master data | /TMF/DE_COD_AUTH_REG_CAD | CHAR | 64 | ||
| COD_AUTH_REG_CAB | Authentication Code of Register - Header data | /TMF/DE_COD_AUTH_REG_CAB | CHAR | 64 | ||
| COD_AUTH_REG_ITM | Authentication Code of Register - Item data | /TMF/DE_COD_AUTH_REG_ITM | CHAR | 64 | ||
| COD_FORN | Service or supply code | /TMF/DE_COD_FORN | CHAR | 20 | ||
| NRO_FATURA | Invoice Number | /TMF/DE_NRO_FATURA | CHAR | 60 | ||
| NRO_TEL_PRINCIPAL | Main Phone Number | /TMF/DE_NRO_TEL_PRINCIPAL | CHAR | 24 | ||
| NRO_CONTRATO | Contract Number | /TMF/DE_NRO_CONTRATO | CHAR | 30 | ||
| QTD_FATURADA | Billed Quantity | /TMF/DE_QTD_FATURADA | DEC | 13 | ||
| IND_DESC_JUD | Judicial Discount Indicator | /TMF/DE_IND_DESC_JUD | CHAR | 2 | ||
| TP_ISENCAO_REDUCAO | Exemption Type/Calculation Basis Reduction | /TMF/DE_TP_ISENCAO_REDUCAO | CHAR | 4 | ||
| TP_INFORMACAO | Information Type | /TMF/DE_TP_INFORMACAO | CHAR | 2 | ||
| TP_CLIENTE | Customer Type | /TMF/DE_TP_CLIENTE | CHAR | 4 | ||
| SUBCLASSE_CONSUMO | Consumption Subclass | /TMF/DE_SUBCLASSE_CONSUMO | CHAR | 4 | ||
| CNPJ_EMITENTE | Issuer CNPJ | /TMF/DE_CNPJ_EMITENTE | CHAR | 28 | ||
| VL_TOTAL_FATURA_DOC | Invoice Total Value | /TMF/DE_VL_TOTAL_FATURA_DOC | DEC | 13 | ||
| DT_LEIT_ANT | Previous Reading Date | /TMF/DE_DT_LEIT_ANT | CHAR | 16 | ||
| DT_LEIT_ATU | Current Reading Date | /TMF/DE_DT_LEIT_ATU | CHAR | 16 | ||
| CANCELADO | Canceled Document Indicator | /TMF/DE_CANCELADO | CHAR | 2 | ||
| VL_FORN | Supplied amount | /TMF/DE_QTD_FORNECIDA | DEC | 13 | ||
| VL_BC_ICMS_ST | Average Unit Value of ICMS ST Base Calculation | /TMF/DE_VL_BC_ICMS_ST | DEC | 13 | ||
| VL_ICMS_ST | ICMS Value for Substitui��o Tribut�ria | /TMF/DE_VL_ICMS_ST | DEC | 13 | ||
| CONS | Total Consumption in kWh | /TMF/DE_CONS | INT4 | 4 | ||
| FASE_UTILIZACAO | Phase or Type of Use | /TMF/DE_FASE_UTILIZACAO | CHAR | 2 | ||
| GRUPO_TENSAO | Voltage Group | /TMF/DE_GRUPO_TENSAO | CHAR | 4 | ||
| TARIFA_APLICADA | Applied Fee | /TMF/DE_TARIFA_APLICADA | DEC | 13 | ||
| INFORMACOES_ADICIONAIS | Additional Info | /TMF/DE_INFORMACOES_ADICIONAIS | CHAR | 60 | ||
| CNPJ_CPF_DEST | Individual (CPF) or Legal Person (CNPJ) Identification | /TMF/DE_CPF_CNPJ | CHAR | 28 | ||
| IE_DEST | State Tax Number | /TMF/DE_IE | CHAR | 36 | ||
| ENDE_DEST | Address | /TMF/DE_END | CHAR | 120 | ||
| NUMERO_DEST | Address Number | /TMF/DE_NUM | CHAR | 20 | ||
| COMPL_DEST | Complement | /TMF/DE_COMPL | CHAR | 120 | ||
| CEP_DEST | Zip Code | /TMF/DE_CEP | CHAR | 20 | ||
| BAIRRO_DEST | District | /TMF/DE_BAIRRO | CHAR | 120 | ||
| DESC_MUN_DEST | City | /TMF/DE_DESC_MUNICIPIO | CHAR | 80 | ||
| UF_DEST | UF | /TMF/DE_UF | CHAR | 4 | ||
| FONE_DEST | Phone Number | /TMF/DE_TELEFONE | CHAR | 24 | ||
| RAZAO_SOCIAL_DEST | Company or Person Name | /TMF/DE_RAZAO_SOCIAL | CHAR | 510 | ||
| NUM_UNIDADE_CONSUMIDORA | Telephone Number or Consumer Account Number | /TMF/DE_NUM_UNIDADECONSUMIDORA | CHAR | 24 | ||
| COD_SIT_CONV | Code of agreement document situation | /TMF/DE_COD_SIT_CONV | CHAR | 2 | ||
| NRO_CONTRATO_ITEM | Item Contract Number | /TMF/DE_NRO_CONTRATO_ITEM | CHAR | 30 | ||
| IND_OPER | Operation Type Indicator | /TMF/DE_IND_OPER | CHAR | 2 | ||
| PCO_CATEGORY | Tax Category | /TMF/DE_PCO_CATEGORY | CHAR | 2 | ||
| CATEGORIA_CFOP | Material CFOP Category | /TMF/DE_CATEGORIA_CFOP | CHAR | 4 |