Histórico da Página

...

...

...

04. USAGE PROCEDURE

When accessing routine FISA300, the main process screen appears. In the menu located on the left, the routines related to the calculation, detailed later are listed:

...

• EFD ICMS/IPI - Taxpayer Guidance Manual - Layout 013
• ICMS/IPI EFD - Practical Guide v. 3.0.1
• EFD ICMS/IPI - Tax Bookkeeping Tutorial of ICMS-IPI EFD for taxpayers of the DF
• Tax SPED

06. TABLES

...

In the purchases: If the service is set to "EP" (B1_MEPLES = 1 or Blank), i.e. ISS due at the provider's site, the ISS will be considered due in the municipality of the document supplier (A2_COD_MUN).

If the service is set to "LES" (B1_MEPLES = 2), i.e. ISS due at the service execution site, the fields F1_ESTPRES and F1_INCISS will first be evaluated, which can be entered when typing the incoming document. If these fields are filled in, the ISS will be considered due in the municipality defined there. Otherwise, the ISS will be considered due in the municipality of SIGAMAT (M0_CODMUN).

In the provisions: If the service is configured as "EP" (B1_MEPLES = 1 or Blank), i.e. ISS due at the provider's site, the ISS will be considered due in the municipality of SIGAMAT (M0_CODMUN).

If the service is set to "LES" (B1_MEPLES = 2), i.e. ISS due at the service execution site, the fields F2_ESTPRES and F2_MUNPRES will first be evaluated, filled in through the fields C5_ESTPRES and C5_MUNPRES on the sales order. If these fields are filled in, the ISS will be considered due in the municipality defined there. Otherwise, the ISS will be considered due in the municipality of the billing customer (A1_COD_MUN).

...

In purchases
The withholding of the ISS at the source in documents for services received will be identified using the ISS Withheld field (FT_RECISS) of the Tax Record item (SFT table). If it is set to option "2", then the ISS will be considered withheld. Otherwise, the system will not consider the withholding. 

Important: In purchases, the withholding will be recognized in the period in which the posting/payment of the tax document bill occurs. This means that the purchases with withholding in the source will only be booked in block B in the period in which the service is paid, not necessarily in the period of issue of the document.

In the provisions

The withholding of the ISS at the source in documents for services provided will be identified using the ISS Withheld field (FT_RECISS) of the Tax Record item (SFT table). If it is set to option "1", then the ISS will be considered withheld. Otherwise, the system will not consider the withholding. 

Important: In the provisions, the withholding will be recognized in the period of issue of the tax document, not according to the receipt.

...

If you set the MV_SPDBIFE parameter to 2, the system will consider the date of issue for the presentation of the contracted service invoices to a foreign supplier in their own form documents with ISS withholding by the receiver, ignoring the presentation by the payment date.

08. DICTIONARY UPDATES

...

Expandir
title Tables, fields, indexes, and triggers
Table Key Name Mode Pyme F1N ISS Calculation Exclusive Yes    Fields  Field F1N_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browse No Context Real Ownership View Fields Group 033 - Branch Size Order 01   Field F1N_LEGEND Type Character Length 15 Decimal 0 Format @BMP Title Status Description Status Used Yes Mandatory No Browse No Default Init. IIF(!INCLUI, FSA300LEG(F1N->F1N_STATUS), "") Context Virtual Ownership View Order 02   Field F1N_ID Type Character Length 36 Decimal 0 Format @! Title ID Description Identifier Used Yes Mandatory No Browse No Default Init. FWUUID("F1N") Context Real Ownership View Order 03   Field F1N_STATUS Type Character Length 1 Decimal 0 Format @! Title Status Description Status Used Yes Mandatory No Browse No Options 1=Calculated; 2=Bill Generated; 3=Bill Generated and Booked; 4=Partial booking/bill Context Real Ownership View Order 04   Field F1N_IDAPUR Type Character Length 36 Decimal 0 Format @! Title Calc. ID Description Calculation ID Used Yes Mandatory No Browse No Context Real Ownership View Order 05   Field F1N_UF Type Character Length 2 Decimal 0 Format @! Title State Description Federative Unit Used Yes Mandatory Yes Browser No Val. System Vazio() .OR. ExistCpo("SX5", "12" + FwFldGet("F1N_UF")) Stand. Query 12 Field Group 010 - State Order 06   Field F1N_CODMUN Type Character Length 5 Decimal 0 Format @! Title City Description City Code Used Yes Mandatory Yes Browser Yes Val. System Vazio() .OR. ExistCpo("CC2", FwFldGet("F1N_UF") + FwFldGet("F1N_CODMUN")) Context Real Ownership Edit Default Cons. CC2 Order 07   Field F1N_MUN Type Character Length 60 Decimal 0 Format @! Title City Description City Description Used Yes Mandatory No Browser No Default Init. IIF(!INCLUI, Posicione("CC2", 1, xFilial("CC2") + F1N->F1N_UF + F1N->F1N_CODMUN, "CC2->CC2_MUN"), "") Context Virtual Ownership View Order 08   Field F1N_ISSPRO Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Local ISS Description Local ISS Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 09   Field F1N_ISSSUB Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Repl. ISS Description ISS Replacement Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 10   Field F1N_ISSUNI Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Sing. ISS Description Single Professionals' ISS Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 11   Field F1N_DEDPRP Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Local Ded. Description Local ISS Deduction Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 12   Field F1N_DEDSUB Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Repl. Ded. Description Replacement ISS Deductions Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 13   Field F1N_DEDUNI Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Sing. Ded. Description Single Professionals' ISS Ded. Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 14   Field F1N_RECUNI Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Sing. Revenue Description Single Professionals' Revenue Used Yes Mandatory No Browser No Order 15   Field F1N_QTDUNI Type Numeric Length 14 Decimal 0 Format @E 99,999,999,999,999 Title Sing. Qty. Description Single Professional Qty. Used Yes Mandatory No Browser No Context Real Ownership Edit Order 16   Field F1N_VLFUNI Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Vl. Sing. Fixed Description Single Professional Monthly Vl. Used Yes Mandatory No Browser No Context Real Ownership Edit Order 17   Indexes Index F1N Order 1 Key F1N_FILIAL + F1N_ID Description ID   Index F1N Order 2 Key F1N_FILIAL + F1N_UF + F1N_CODMUN Description State + City Display Search Yes   Index F1N Order 3 Key F1N_FILIAL + F1N_IDAPUR Description Calc. ID Display Search Yes   Table Key Name Mode Pyme F1O Detailed ISS Calculation Exclusive Yes   Fields Field F1O_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browser Yes Context Real Ownership Edit Field Group 033 - Branch Size Order 01   Field F1O_ID Type Character Length 36 Decimal 0 Format @! Title ID Description Identifier Used Yes Mandatory No Browser No Default Init. FWUUID("F1O") Context Real Ownership Edit Order 02   Field F1O_IDAPUR Type Character Length 36 Decimal 0 Format @! Title Calculation ID Description Calculation ID Used Yes Mandatory No Browser No Context Real Ownership Edit Order 03   Field F1O_CODISS Type Character Length 9 Decimal 0 Format @9 Title Service Code Description Service Code Used Yes Mandatory No Browser Yes Val. System Vazio() .OR. ExistCpo("SX5", "60" + M->F1O_CODISS) Context Real Ownership Edit Stand. Query 60 Field Group 023 – ISS Service Code Order 04   Field F1O_SERV Type Character Length 60 Decimal 0 Format @! Title Service Description Service Description Used Yes Mandatory No Browser No Default Init. IIF(!INCLUI, Posicione("SX5", 1, xFilial("SX5") + "60" + F1O->F1O_CODISS, "X5DESCRI()"), "") Context Virtual Ownership View Order 05   Field F1O_VLCONT Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Accounting Value Description Accounting Value Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 06   Field F1O_MATTER Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Mat. Third P. Description Third-Party Material Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 07   Field F1O_MATPRO Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Mat. Proprietary Description Proprietary material Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 08   Field F1O_SUBEMP Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Sub-cont. Description Value of sub-contractors Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 09   Field F1O_VLISEN Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Exempt Vl. Description Exempt Operations Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 10   Field F1O_VLOUTR Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Other Vl. Description Other Value Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 11   Field F1O_BSCALC Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Calc Base Description Calculation Base Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 12   Field F1O_BSRETP Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Prov. Withh. Description Calculation Bs. of Prov. Withh. Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 13   Field F1O_ISSDES Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Highl. ISS Description Value of Highlighted ISS Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 14   Field F1O_ISRETP Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Pr. With. ISS Description Withheld ISS - Provisions Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 15   Field F1O_ISRETA Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Purc. With. ISS Description Withheld ISS - Purchases Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 16   Indexes Index F1O Order 1 Key F1O_FILIAL + F1O_ID Description ID Display Search Yes   Index F1O Order 2 Key F1O_FILIAL + F1O_IDAPUR + F1O_CODISS Description Calculation ID + Service Code Display Search Yes   Table Key Name Mode Pyme F1P Centralized ISS Calculation Exclusive Yes    Fields Field F1P_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browser Yes Context Real Ownership View Field Group 033 - Branch Size Order 01   Field F1P_ID Type Character Length 36 Decimal 0 Format @! Title ID Description Table ID Used Yes Mandatory No Browser No Default Init. FWUUID("F1P") Context Real Ownership Edit Order 02   Field F1P_DTINI Type Date Length 8 Decimal 0 Title Start Date Description Calculation start date Used Yes Mandatory Yes Browser Yes Context Real Ownership Edit Order 03   Field F1P_DTFIM Type Date Length 8 Decimal 0 Title End Date Description Calculation end date Used Yes Mandatory Yes Browser Yes Context Real Ownership Edit Order 04   Indexes Index F1P Order 1 Key F1P_FILIAL + F1P_ID Description ID   Index F1P Order 2 Key F1P_FILIAL + DTOS(F1P_DTINI) + DTOS(F1P_DTFIM) Description Start Date + End Date Display Search Yes   Table Key Name Mode Pyme F1Q Deductions of ISS Calculation Exclusive Yes   Fields Field F1Q_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browser No Context Real Ownership View Field Group 033 - Branch Size Order 01     Field F1Q_ID Type Character Length 36 Decimal 0 Format @! Title ID Description Identifier Used Yes Mandatory No Browser No Default Init. FWUUID("F1Q") Context Real Ownership View Order 02     Field F1Q_IDAPUR Type Character Length 36 Decimal 0 Format @! Title Calc. ID Description Calculation ID. Used Yes Mandatory No Browser No Context Real Ownership Edit Order 03     Field F1Q_TPDED Type Character Length 1 Decimal 0 Format @! Title Deduction Tp. Description Deduction type Used Yes Mandatory Yes Browser Yes Options 0=Compensation of the overcharged ISS; 1=Tax benefit by culture incentive; 2=Administrative decision; 9=Others Context Real Ownership Edit Order 04     Field F1Q_VLDED Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Vl. Deduction Description Deduction value Used Yes Mandatory Yes Browser Yes Context Real Ownership Edit Order 05     Field F1Q_NUMPRO Type Character Length 10 Decimal 0 Format @! Title Process No. Description Process Number Used Yes Mandatory No Browser Yes Val. System Vazio() .OR. ExistCpo("CCF", FwFldGet("F1Q_NUMPRO")) Context Real Ownership Edit Stand. Query CCF Field Group 088 - Referenced Process Order 06     Field F1Q_ORIPRO Type Character Length 1 Decimal 0 Format @! Title Proc. Src. Description Process Source Used Yes Mandatory No Browser Yes Options 0=Sefin; 1=Federal Justice; 2=State Justice; 9=Others Context Real Ownership Edit Order 07     Field F1Q_DESPRO Type Character Length 100 Decimal 0 Format @! Title Proc. Descr. Description Process Description Used Yes Mandatory No Browser No Context Real Ownership Edit Order 08     Field F1Q_CODOBS Type Character Length 60 Decimal 0 Format @! Title Note Code Description Note Code Used Yes Mandatory Yes Browser No Val. System Vazio() .OR. ExistCpo("CCE", FwFldGet("F1Q_CODOBS")) Context Real Ownership Edit Stand. Query CCE Order 09     Field F1Q_INDOBR Type Character Length 1 Decimal 0 Format @! Title Oblig. Indic. Description Obligation indicator Used Yes Mandatory Yes Browser Yes Options 0=Local ISS; 1=Replacement ISS (due for service acquisitions); 2=Single Professionals' ISS Context Real Ownership Edit Order 10   Indexes Index F1Q Order 1 Key F1Q_FILIAL + F1Q_ID Description ID Display Search Yes   Index F1Q Order 2 Key F1Q_FILIAL + F1Q_IDAPUR Description Calc. ID Display Search Yes     Table Key Name Mode Pyme F1R ISS Calculation Bills Exclusive Yes   Fields Field F1R_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browser No Context Real Ownership View Field Group 033 - Branch Size Order 01     Field F1R_ID Type Character Length 36 Decimal 0 Format @! Title ID Description Identifier Used Yes Mandatory Yes Browser No Default Init. FWUUID("F1R") Context Real Ownership View Order 02     Field F1R_IDAPUR Type Character Length 36 Decimal 0 Format @! Title Calc. ID Description Calculation ID Used Yes Mandatory Yes Browser No Context Real Ownership View Order 03     Field F1R_LEGEND Type Character Length 15 Decimal 0 Format @BMP Title Status Description Status Used Yes Mandatory No Browser No Default Init. IIF(!INCLUI, FSA300LEG(F1R->F1R_STATUS), "") Context Virtual Ownership View Order 04     Field F1R_TPIMP Type Character Length 2 Decimal 0 Format @! Title Tax Tp. Description Tax Type Used Yes Mandatory Yes Browser Yes Options 01=Local ISS ; 02=ISS replacement ; 03= Single Professional Company ISS Context Real Ownership Edit Order 05     Field F1R_PREFIX Type Character Length 3 Decimal 0 Format @! Title Prefix Description Bill Prefix Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 06     Field F1R_NUM Type Character Length 9 Decimal 0 Format @! Title Bill No. Description Bill Number Used Yes Mandatory No Browser Yes Context Real Ownership Edit Field Group 018 - Incoming/Outgoing document Order 07     Field F1R_PARC Type Character Length 1 Decimal 0 Format @! Title Installment Description Bill Installment Used Yes Mandatory No Browser Yes Context Real Ownership Edit Field Group 011 - Installment Order 08     Field F1R_TIPO Type Character Length 3 Decimal 0 Format @! Title Type Description Bill Type Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 09     Field F1R_FORN Type Character Length 6 Decimal 0 Format @! Title Supplier Description Supplier Used Yes Mandatory No Browser Yes Val. System vazio() .OR. ExistCpo("SA2", FwFldGet("F1R_FORN")) Context Real Ownership Edit Stand. Query SA2 Triggers Yes Field Group 001 - Customer or supplier code Order 10     Field F1R_LOJA Type Character Length 2 Decimal 0 Format @! Title Store Description Store Used Yes Mandatory No Browser Yes Val. System Vazio() .OR. ExistCpo("SA2", FwFldGet("F1R_FORN") + FwFldGet("F1R_LOJA")) Context Real Ownership Edit Triggers Yes Field Group 002 - Customer/Supplier Store Order 11     Field F1R_DFORN Type Character Length 40 Decimal 0 Format @! Title Corporate Name Description Corporate Name Used Yes Mandatory No Browser No Default Init. IIF(!INCLUI, Posicione("SA2", 1, xFilial("SA2") + F1R->F1R_FORN + F1R->F1R_LOJA, "SA2->A2_NOME"), "") Context Virtual Ownership View Order 12     Field F1R_VALOR Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Amount Description Bill Value Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 13     Field F1R_VENCTO Type Date Length 8 Decimal 0 Title Due Date Description Due Date Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 14     Field F1R_NATURE Type Character Length 10 Decimal 0 Format @! Title Nature Description Financial Class Used Yes Mandatory No Browser No Val. System Vazio() .OR. existcpo("SED") Context Real Ownership Edit Stand. Query SED Triggers Yes Order 15     Field F1R_DNATU Type Character Length 30 Decimal 0 Format @! Title Nat. Desc. Description Nature Description Used Yes Mandatory No Browser No Default Init. IIF(!INCLUI .AND. !Empty(F1R->F1R_NATURE), Posicione("SED", 1, xFilial("SED") + F1R->F1R_NATURE, "SED->ED_DESCRIC"), "") Context Virtual Ownership View Order 16     Field F1R_STATUS Type Character Length 1 Decimal 0 Format @! Title Status Description Status Used Yes Mandatory No Browser No Options 1=Not generated; 2=Bill generated; 3=Bill generated and booked Context Real Ownership Edit Order 17   Indexes Index F1R Order 1 Key F1R_FILIAL + F1R_ID + F1R_IDAPUR Description ID + Calc ID Display Search Yes   Index F1R Order 2 Key F1R_FILIAL + F1R_IDAPUR Description Calc. ID Display Search Yes   Triggers Field F1R_FORN Sequence 001 Domain Acct. F1R_DFORN Type P - Primary Rule SA2->A2_NOME Position S Alias SA2 Order 1 Key xFilial("SA2") + FwFldGet("F1R_FORN") + FwFldGet("F1R_LOJA") Condition .T. Owner Yes   Field F1R_LOJA Sequence 001 Domain Acct. F1R_DFORN Type P - Primary Rule SA2->A2_NOME Position S Alias SA2 Order 1 Key xFilial("SA2") + FwFldGet("F1R_FORN") + FwFldGet("F1R_LOJA") Condition .T. Owner Yes   Field F1R_NATURE Sequence 001 Domain Acct. F1R_DNATU Type P - Primary Rule SED->ED_DESCRIC Position S Alias SED Order 1 Key xFilial("SED") + FwFldGet("F1R_NATURE") Condition .T. Owner Yes     Table Key Name Mode Pyme F1S Single Professional Company Exclusive Yes   Fields Field F1S_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browser No Context Real Ownership View Field Group 033 - Branch Size Order 01     Field F1S_ID Type Character Length 36 Decimal 0 Format @! Title ID Description Identifier Used Yes Mandatory No Browser No Default Init. FWUUID("F1S") Context Real Ownership View Order 02     Field F1S_ESCOL Type Character Length 1 Decimal 0 Format @! Title Educ. Ind. Description Indicator of education Used Yes Mandatory Yes Browser Yes Options 0=Undergraduate; 1=High School Context Real Ownership Edit Order 03     Field F1S_PARSOC Type Character Length 1 Decimal 0 Format @! Title Par. Part. Ind. Description Indicator of Particip. in Partnership Used Yes Mandatory Yes Browser Yes Options 0=Partner; 1=Not a partner Context Real Ownership Edit Order 04     Field F1S_CPF Type Character Length 11 Decimal 0 Format @R 999.999.999-99 Title CPF Description SSN Reg. No. Used Yes Mandatory Yes Browser Yes Val. System VAZIO() .OR. Cgc(FwFldGet("F1S_CPF")) Context Real Ownership Edit Order 05     Field F1S_NOME Type Character Length 100 Decimal 0 Format @! Title Name Description Name of the Professional Used Yes Mandatory Yes Browser Yes Context Real Ownership Edit Order 06     Field F1S_INIHAB Type Date Length 8 Decimal 0 Title Qual. St. Dt. Description Qualification Start Date Used Yes Mandatory Yes Browser Yes Context Real Ownership Edit Order 07     Field F1S_FIMHAB Type Date Length 8 Decimal 0 Title Qual. End Dt. Description Qualification End Date Used Yes Mandatory No Browser Yes Context Real Ownership Edit Order 08       Indexes Index F1S Order 1 Key F1S_FILIAL + F1S_ID Description ID   Index F1S Order 2 Key F1S_FILIAL + F1S_CPF Description CPF Display Search Yes     Table Key Name Mode Pyme F1T City Detail Shared Yes   Fields Field F1T_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browser No Context Real Ownership View Field Group 033 - Branch Size Order 01     Field F1T_UF Type Character Length 2 Decimal 0 Format @! Title State Description Federative Unit Used Yes Mandatory No Browser No Default Init. IIF(!INCLUI, Posicione("SA2", 1, xFilial("SA2") + F1T->F1T_FORN + F1T->F1T_LOJA, "SA2->A2_NOME"), "") Context Real Ownership Edit Field Group 010 - State Order 02     Field F1T_CODMUN Type Character Length 5 Decimal 0 Format @! Title City Code Description City Code Used Yes Mandatory No Browser No Context Real Ownership Edit Order 03     Field F1T_FORN Type Character Length 6 Decimal 0 Format @! Title Supplier Description Supplier Used Yes Mandatory No Browser No Val. System Vazio() .OR. ExistCpo("SA2", FwFldGet("F1T_FORN")) Context Real Ownership Edit Stand. Query SA2 Triggers Yes Field Group 001 - Customer or supplier code Order 04     Field F1T_LOJA Type Character Length 2 Decimal 0 Format @! Title Store Description Supplier Store Used Yes Mandatory No Browser No Val. System Vazio() .OR. ExistCpo("SA2", M->F1T_FORN + M->F1T_LOJA) Context Real Ownership Edit Triggers Yes Field Group 002 - Customer/Supplier Store Order 05     Field F1T_DFORN Type Character Length 40 Decimal 0 Format @! Title Corporate Name Description Corporate Name Used Yes Mandatory No Browser No Default Init. IIF(!INCLUI, Posicione("SA2", 1, xFilial("SA2") + F1T->F1T_FORN + F1T->F1T_LOJA, "SA2->A2_NOME"), "") Context Virtual Ownership View Order 06     Field F1T_NATURE Type Character Length 10 Decimal 0 Format @! Title Nature Description Financial Class Used Yes Mandatory No Browser No Val. System Vazio() .OR. ExistCpo("SED", FwFldGet("F1T_NATURE")) Context Real Ownership Edit Stand. Query SED Triggers Yes Order 07     Field F1T_DNATUR Type Character Length 30 Decimal 0 Format @! Title Nat. Desc. Description Nature Description Used Yes Mandatory No Browser Yes Default Init. IIF(!INCLUI .AND. !Empty(F1T->F1T_NATURE), Posicione("SED", 1, xFilial("SED") + F1T->F1T_NATURE, "SED->ED_DESCRIC"), "") Context Virtual Ownership View Order 08       Indexes Index F1T Order 1 Key F1T_FILIAL + F1T_UF + F1T_CODMUN Description State + City Code Display Search Yes   Triggers Field F1T_FORN Sequence 001 Domain Acct. F1T_LOJA Type P - Primary Rule Iif(Empty(FwFldGet("F1T_FORN")), "", SA2->A2_LOJA) Position S Alias SA2 Order 1 Key xFilial("SA2") + FwFldGet("F1T_FORN") Condition .T. Owner Yes   Field F1T_FORN Sequence 002 Domain Acct. F1T_DFORN Type P - Primary Rule Iif(Empty(FwFldGet("F1T_FORN")), "", SA2->A2_NOME) Position S Alias SA2 Order 1 Key xFilial("SA2") + FwFldGet("F1T_FORN") Condition .T. Owner Yes   Field F1T_LOJA Sequence 001 Domain Acct. F1T_DFORN Type P - Primary Rule Iif(Empty(FwFldGet("F1T_FORN")), "", SA2->A2_NOME) Position S Alias SA2 Order 1 Key xFilial("SA2") + FwFldGet("F1T_FORN") + FwFldGet("F1T_LOJA") Condition .T. Owner Yes   Field F1T_NATURE Sequence 001 Domain Acct. F1T_DNATUR Type P - Primary Rule Iif(Empty(FwFldGet("F1T_NATURE")), "", SED->ED_DESCRIC) Position S Alias SED Order 1 Key xFilial("SED") + FwFldGet("F1T_NATURE") Condition .T. Owner Yes     Table Key Name Mode Pyme F1U Monthly Values for Single Prof. ISS. Shared Yes   Fields Field F1U_FILIAL Type Character Length 8 Decimal 0 Title Branch Description System Branch Used No Mandatory No Browser Yes Context Real Ownership Edit Field Group 033 - Branch Size Order 01     Field F1U_UF Type Character Length 2 Decimal 0 Format @! Title State Description State Used Yes Mandatory Yes Browser Yes Val. System Vazio() .OR. ExistCpo("SX5", "12" + FwFldGet("F1U_UF")) Context Real Ownership Edit Stand. Query 12 Triggers Yes Field Group 010 - State Order 02     Field F1U_DUF Type Character Length 100 Decimal 0 Format @! Title Description Description State Description Used Yes Mandatory No Browser Yes Default Init. IIF(!INCLUI, Posicione("SX5", 1, xFilial("SX5") + "12" + F1U->F1U_UF , "X5DESCRI()"), "") Context Virtual Ownership View Browse Init. Posicione("SX5", 1, xFilial("SX5") + "12" + F1U->F1U_UF , "X5DESCRI()") Order 03     Field F1U_CODMUN Type Character Length 5 Decimal 0 Format @! Title City Description City Code Used Yes Mandatory Yes Browser Yes Val. System Vazio() .OR. ExistCpo("CC2", FwFldGet("F1U_UF") + FwFldGet("F1U_CODMUN")) Context Real Ownership Edit Stand. Query CC2 Triggers Yes Order 04     Field F1U_DMUNIC Type Character Length 100 Decimal 0 Format @! Title Description Description City Description Used Yes Mandatory No Browser Yes Default Init. IIF(!INCLUI, Posicione("CC2", 1, xFilial("CC2") + F1U->F1U_UF + F1U->F1U_CODMUN, "CC2_MUN"), "") Context Virtual Ownership View Browse Init. Posicione("CC2", 1, xFilial("CC2") + F1U->F1U_UF + F1U->F1U_CODMUN, "CC2_MUN") Order 05     Field F1U_DTINI Type Date Length 8 Decimal 0 Title Start Date Description Start of effective term Used Yes Mandatory Yes Browser Yes Context Real Ownership Edit Order 06     Field F1U_DTFIM Type Date Length 8 Decimal 0 Title End Date Description End of effective term Used Yes Mandatory No Browser Yes Val. System Vazio() .OR. FwFldGet("F1U_DTFIM") >= FwFldGet("F1U_DTINI") Context Real Ownership Edit Order 07     Field F1U_VALOR Type Numeric Length 14 Decimal 2 Format @E 99,999,999,999.99 Title Amount Description ISS monthly value Used Yes Mandatory Yes Browser Yes Val. System Vazio() .OR. Positivo() Context Real Ownership Edit Order 08   Indexes Index F1U Order 1 Key F1U_FILIAL + F1U_UF + F1U_CODMUN + DTOS(F1U_DTINI) Description State + City + Start Date Display Search Yes   Triggers Field F1U_CODMUN Sequence 001 Domain Acct. F1U_DMUNIC Type P - Primary Rule Iif(Empty(FwFldGet("F1U_CODMUN")), "", CC2->CC2_MUN) Position S Alias CC2 Order 1 Key xFilial("CC2") + FwFldGet("F1U_UF") + FwFldGet("F1U_CODMUN") Condition .T. Owner Yes   Field F1U_UF Sequence 001 Domain Acct. F1U_DUF Type P - Primary Rule Iif(Empty(FwFldGet("F1U_UF")), "", X5DESCRI()) Position S Alias SX5 Order 1 Key xFilial("SX5") + "12" + FwFldGet("F1U_UF") Condition .T. Owner Yes   Parameters Var Name MV_SPDBIFE Type 1 - Character Content Description Indicate how the taxable event of block B will be considered for services received from abroad, Decree no. 25,508/2005, 1=Posting, 2=Issue. If blank, Posting   Example 2