INDEX
APUISSBLB - ISS Calculation - ICMS/IPI EFD - Block B
...
01. OVERVIEW
The Digital Tax Bookkeeping – ICMS/IPI EFD is an integral part of the SPED project, referred to in Decree No. 6,022 of January 22, 2007, which seeks to promote the integration of the federal, state, and Federal District tax authority through standardization, rationalization, and sharing of digital tax information, as well as integrating the whole process related to tax bookkeeping, with the replacement of the documents in a physical environment (paper) by electronic documents with legal validity for all purposes. Through ICMS/IPI EFD, and to simplify processes and reduce ancillary obligations imposed on taxpayers, the taxpayer must present, in digital form, with transmission via the Internet, the records of the tax documents of the bookkeeping and the respective statements of calculation of the IPI and ICMS taxes of each period of calculation, as well as other information of economic and fiscal interest.
Decree No. 39,789/2019 establishes the ICMS/IPI EFD for ICMS and ISS taxpayers established in the Federal District, in a mandatory way for taxable events that occurred from July 1, 2019. By this date, these taxpayers must carry out the delivery of the Electronic Tax Record – (LFE).
The digital ICMS-IPI EFD file will be generated by the DF taxpayers according to the specifications of the Taxpayer Guidance Manual, published by Cotepe Act No. 44/2018 and the Practical Guide (Layout 13 - valid from January 1, 2019), made available by the Brazilian Federal Revenue Service.
The Digital Tax Bookkeeping – ICMS/IPI EFD, from the date of its obligation, automatically replaces the bookkeeping of the Tax Records presented:
...
Decree No. 26,529 of 2006, which provided for the presentation of the Electronic Tax Record (LFE), is hereby revoked.
Among the changes presented in Layout 13 of the Practical Guide is the inclusion of a new block of records (Block B - ISS Bookkeeping and Calculation), which is in force from the calculation period of January 2019, exclusive to taxpayers of the Federal District. The structure of the new block contains records from the inflow and outflow tax bookkeeping, as well as records that demonstrate the calculation of the tax, related to the operations and services rendered by the taxpayer.
The following manual demonstrates the necessary steps for the parameterization and use of the new routine of ISS calculation - ICMS/IPI EFD Block B, developed for the Microsiga Protheus line, and that is a mandatory step for the correct generation of Block B by taxpayers of the Federal District.
02. DEPLOYMENT PROCEDURE
| Aviso |
|---|
|
For this implementation, in addition to the application of the update package (patch), customers operating in version 11 (under extended warranty) or releases before 12.1.25 must run the UPDDISTR compatibility tool with the data dictionary differential package (SDFBRA.txt), available in versions 11.80, 12.1.17, 12.1.23 via the link: |
...
...
For further information about the UPDDISTR, refer to Dictionary and database updater - UPDDISTR. |
...
03. SETUP PROCEDURE
MENU CONFIGURATION
- In the Configuration Tool (SIGACFG) access Environments/Register/Menu (CFGX013). Enter the new menu option according to the following instructions:
Menu | SIGAFIS |
|---|
Sub-menu | Miscellaneous |
Routine Name | ISS calculation - ICMS/IPI EFD - Block B |
Program | FISA300 |
Module | All |
Type | Protheus |
...
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: 
Image Removed
Image Added
TRANSACTION OF FINANCIAL INSTITUTION
This routine should include the transactions related to the provision of services by financial institutions based on the Accounting Plan of the National Financial System Institutions (COSIF), made available by the Central Bank of Brazil. The revenues included in this routine will serve as input for the generation of the B350 record (SERVICES PROVIDED BY FINANCIAL INSTITUTIONS). This record must demonstrate all revenues related to services (COSIF classification 7.1.7.00.00-9), even if not included in the Annex to Complementary Statute no. 116/2003. Only benefits covered by Service Invoices should be removed from these revenues.
Existing transactions will be displayed on the right side, with options for adding new records, as well as changing and deleting existing records:
Image Added Image Removed
This routine (FISA093) feeds the CLL - ISS Financial Institutions table, which is currently used in the Electronic Tax Record (LFE).
REGISTRATION OF A SINGLE PROFESSIONAL COMPANY
This routine should be used to record the information of each professional (partners, qualified employees, and unqualified employees) of the single professional company. The information entered through it will be presented in record B510 (SINGLE PROFESSIONAL - EMPLOYEES AND PARTNERS).
The records of professionals already registered will be displayed on the right side, with options to add new records, as well as editing and deleting existing records: Image Removed
Image Added
The indication of qualification or not of a professional is given through the fields Qual. St. Dt and Qual. End Dt. If the calculation is carried out for a period between the contents of these 2 fields, or in a period longer than Qual. St. Dt. and with Qual. End Dt. blank, the professional will be considered qualified for calculating.
REGISTRATION OF MONTHLY VALUES OF SINGLE PROFESSIONAL ISS
The ISS of the Single Professional Company is calculated from a pre-established value which is paid according to the number of partners and/or qualified employees of the company. Table 4.6.1 from RFB contains the monthly amount due by a trained professional in the DF. In this way, the calculation takes place by the monthly value multiplied by the number of professionals qualified in the period.
Through this routine, therefore, the monthly amount due by a qualified professional must be entered per municipality. The information entered in it will be considered by record B500 (CALCULATION OF THE ISS OF SINGLE PROFESSIONAL COMPANY)
The records already registered will be displayed on the right side, with options for adding new records, as well as changing and deleting existing records: Image Removed
Image Added
CITY REGISTRATION
It is the routine already existing in Protheus (FISA010) for handling data of cities (table CC2), inserted in this menu to facilitate its access.
The cities already registered will be displayed on the right side, with options for adding new records, as well as changing and deleting existing records: Image Removed
Image Added
CALCULATION
This routine aims to calculate the local ISS to be collected (referring to the taxpayer's benefits), as well as the ISS replacement (withheld by the taxpayer as service recipient), by the municipality, taking as a basis the tax bookkeeping of services provided and received in the period and the entries made in the auxiliary routines described above. Using the calculation routine, it is also possible to make manual entries of deduction of the amount of the calculated tax, plus the generation of bills in the Financial module to collect the tax, as well as the accounting of the generated bills.
The calculations already performed are displayed on the right side, with options for calculating new periods, as well as changing, viewing, and deleting existing calculations. The "Other Actions" button also has features for generating and accounting for bills: Image Removed
Image Added
To perform the calculation of a new period or redo the existing calculation of a certain period, you must click on the "Calculate" button. The branch for which you wish to perform the calculation will be requested, and then the initial parameters screen will be displayed:
Image Added Image Removed
Enter the desired period. If the question "Select Branch ?" is set to "Yes", it is possible to select all branches that will participate in the processing. It is important to note that, in this case, the calculation will be consolidated in the logged-in branch, that is, the one selected by clicking the "Calculate" button. Otherwise, only the logged-in branch will be considered in the processing.
If a period already calculated is selected, the routine will present the following warning, and it will be up to the user to proceed with the processing or not. If the "Yes" option is chosen, the existing calculation will be deleted before the period is reprocessed:
Image Added Image Removed
At the end of the processing, the message that the processing has been completed successfully will be displayed. When you confirm this screen, the screen containing the newly performed calculation will be displayed. At the top of the screen, the calculated values are displayed, detailed by the municipality. The bottom of the screen provides a demonstration of the detailed calculation by service code:
Image Added Image Removed
The field "Status", in the calculation grid by the municipality, indicates the status of the generation of the bills for each municipality calculated, where:
Image Added Image Removed
To view the breakdown of the calculation of a given municipality, as well as to make deductions of the calculated tax, it is necessary to double-click on the row of the desired municipality. The routine will then display a screen detailing the calculation of the Local ISS, the ISS Replacement, and the ISS of a Single Professional Company, separated by tabs at the top of the screen: Image Removed
Image Added
Local ISS Tab
Rows 001 to 008 demonstrate the formation of the tax calculation base. Rows 009 to 012 demonstrate the formation of the value of the tax calculated to collect. By double clicking on row 011 - Total Deductions, the routine allows the inclusion of manual entries to deduct the calculated value of the ISS to collect: Image Removed
Image Added
The deductions already entered for the calculation are displayed, as well as options for adding new entries and changing and deleting existing entries. When selecting the "Add" option, the following fields must be filled in: Image Removed
Image Added
When confirming the inclusion of the record and closing the deduction entry screen, row 011 - Total deductions will now display the total deductions entered for the calculation in question.
ISS Replacement tab
Row 101 shows the total ISS withheld in the taxpayer's purchases as a service recipient. In the same way as in the Local ISS tab, by double-clicking on row 102 - Total Deduction Value, it is possible to make manual entries to deduct the calculated amount of ISS replacement to collect: Image Removed
Image Added
Row 103 shows the total amount of ISS replacement to collect, with the deductions, entered already reduced.
Single Professional ISS Tab
Row 201 - Monthly Revenue allows you to enter the value that will be transmitted to field 02-VL_REC of record B500 (CALCULATION OF SINGLE PROFESSIONAL COMPANY ISS). To do this, simply click on the Value column and enter the desired value:
Image Added Image Removed
Rows 202 to 204 demonstrate the values entered through the routines Single Professional Company Registration and Registration of Monthly Values of Single Professional ISS. Just like in the other tabs, by double-clicking on row 205 - Total Deduction Value, it is possible to make manual entries to deduct the amount calculated. Row 206 shows the total value of Single Professional ISS to collect, with the deductions entered already reduced.
GENERATION AND ACCOUNTING OF BILLS PAYABLE
On the Home screen of routine FISA300, by clicking "Calculation" in the side menu, the calculations already performed will be displayed on the right side. Click on the calculation of the period for which you want to generate the bills. On the "Other Actions" button, the following options are available:
- Generate Bills
- Generate Bills and Book
- Booking
Image AddedImage Removed
Generate Bills
When you select this option, the selected calculation screen appears. In it, the upper part, as previously described, the detailed calculation by the municipality is shown. At the bottom, the ISS types calculated for the selected municipality are displayed (Local ISS and Single Professional ISS).
| Nota |
|---|
|
| Bills will not be generated for the ISS replacement, as it is understood that these have already been generated in the Financial module at the time of withholding tax. |
The bills will be generated for all municipalities evaluated and listed, but separately for each municipality. For this, the user must click on the desired municipality and, on the lower grid, for each type of tax calculated for the municipality, fill in the fields: Prefix, Supplier, Store, Due Date, and Nature. Filled in the fields for all municipalities, click the "Confirm" button: Image Removed
Image Added
After performing the generation process, the newly generated bills will be displayed on the screen (table SE2) with the display option in the Financial module: Image Removed
Image Added
The routine returns to the home screen. When entering the calculation again, it is possible to observe that the status indicator of the generation of calculation bills is now green, indicating bills generated, but not yet booked: Image Removed
Image Added
Supplier's Suggestion, Financial Nature, and Bill's Due Date
To facilitate the generation of bills, the City Record Breakdown was created in the city's file. In this section, it will be defined which Supplier (SA2) represents the city, and which Financial Nature (SED) should be considered in the generation of the Bill Payable (SE2). This information will be suggested on the screen cited above, but it can be edited if necessary.
The bill's due date will be suggested according to the configuration of the fields and Day Type (CC2_TPDIA) and ISS Coll. Day (CC2_DTRECO) of the Cities File (CC2), but it can also be edited if necessary.
Booking
On the Home screen of routine FISA300, when you select the calculation and choose the "Book" option, the selected calculation screen appears. Just click on "Confirm" to book the generated bills.
| Nota |
|---|
|
To book the bills, before confirming the operation, go to "Other Actions" and "Settings". Make sure that the question "Display Accounting Entry? is set to "Yes". It is also necessary to have the following Standard Entries registered: 750 - ISS Calculation - |
...
Inclusion 751 - ISS Calculation - Reversal |
When viewing the calculation again, the caption will be blue, indicating the accounting of the bills generated by the calculation: Image Removed
Image Added
Generate Bills and Book
The bill generation and accounting actions described above will be carried out in a single process.
...
06. TABLES
Alias | Description |
|---|
F1N | ISS Calculation |
F1O | Detailed ISS Calculation |
F1P | Centralized ISS Calculation |
F1Q | Deductions of ISS Calculation |
F1R | ISS Calculation Bills |
F1S | Single Professional Company |
F1T | City Detail |
F1U | Monthly Values for Single Prof. ISS. |
07. FREQUENTLY ASKED QUESTIONS
...
1) Who should book service invoices taxed by the ISS in block B?
ISS taxpayers domiciled in the Federal District should generate block B considering a taxable event occurred from July 1st, 2019, with the first delivery expected in August 2019.
2) Which ICMS/IPI EFD profile should I use?
All taxpayers domiciled in the Federal District must use profile A.
3) What is the meaning of the concept of "EP" and "LES" in the system?
In the system, "EP" means Provider's Site, while "LES" means the Service Execution Location.
This configuration is done in the product registration, using the Service Exec. field (B1_MEPLES). Option "1" indicates EP, and option "2" indicates LES. If this field is empty, "EP" will be adopted as default.
4) How does the system define where the ISS is due?
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).
5) Tax documents with ISS due in another municipality should be stated in block B?
Yes; however, these service invoices will be booked as exempt/untaxed, that is, the values of these invoices will not be considered for the generation of the calculation record B470.
6) How to book a combined tax document in block B?
As provided in the Tax Bookkeeping Tutorial of ICMS-IPI EFD for taxpayers of the Federal District, the related documents, that is, that register, in the same document, the sale of goods and the provision of services subject to the ISS, must be carried in blocks B and C. In block C, the entries should be made regularly in records C100 and children, also using a valid combination of CST and CFOP for the services. On the other hand, only the services must be booked in block B, that is, the accounting value booked must correspond only to the services contained in the document.
7) How does the system identify withholding at the ISS source?
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.
8) Record B470 (Calculation Record) was not generated, how should I proceed?
In this case, it is most likely that the Block B calculation routine (FISA300) has not been processed for the selected branch. You must make sure that you have processed block B properly before processing the Tax SPED.
9) How does the system identify if the site is not an ICMS taxpayer?
The site will be considered as a NON-ICMS Taxpayer if:
...
If any of the above three hypotheses is true, it will be considered as a non-ICMS taxpayer; otherwise, it will be considered as an ICMS taxpayer.
10) My documents with templates 55 and/or 65 are being booked in block C. Is that a mistake?
No. As provided in the Tax Bookkeeping Tutorial of ICMS-IPI EFD for taxpayers of the DF (item 3.11.01), if the declarant is a taxpayer of the ICMS (see FAQ 9), the documents must be entered in both blocks, taking care to inform CFOP and CST consistent with the situation in the C block records. If the declarant is not an ICMS taxpayer, the documents will be booked only in block B. This rule applies to both provisions and purchases.
11) How to determine the ISS using as a taxable event the date of issue, for service invoices received from abroad?
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
...
| 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 |
|
...
