CONTENTS
01. OVERVIEW
EFD ICMS/IPI - Calculation of Reimbursement or Complement of ICMS Withheld by Tax Substitution or Advanced
By the publication of "COTEPE/ICMSAct No. 44/2018" and of "Digital Tax Bookkeeping Practical Guide - EFD-ICMS/IPI", from version 3.0.2 onwards, new records of "Complementary Information about outflow operations of goods subject to tax substitution" were instituted, for the purpose of calculating the complement or reimbursement of ICMS withheld by tax substitution (ICMS-ST), or paid in advance:
Record | Description |
C180 | Complementary information about inflow operations of goods subject to tax substitution (code 01, 1B, 04 and 55) |
C186 | Complementary information about inflow return operations of goods subject to tax substitution (code 01, 1B, 04 and 55). |
C185 | Complementary information about outflow operations of goods subject to tax substitution (code 01, 1B, 04 and 55) |
C186 | Complementary information about inflow return operations of goods subject to tax substitution (code 01, 1B, 04 and 55). |
C330 | Complementary information about outflow operations of goods subject to tax substitution (code 02) |
C380 | Complementary information about outflow operations of goods subject to tax substitution (code 02) |
C430 | Complementary information about outflow operations of goods subject to tax substitution (code 02, 2D and 60) |
C480 | Complementary information about outflow operations of goods subject to tax substitution (code 02, 2D and 60) |
C810 | Electronic tax receipt document items – SAT (CF-E-SAT) (code 59) |
C815 | Complementary information about outflow operations of goods subject to tax substitution (CF-E-SAT) (code 59) |
C870 | Electronic tax receipt document items – SAT (CF-E-SAT) (code 59) |
C880 | Complementary information about outflow operations of goods subject to tax substitution (CF-E-SAT) (code 59) |
H030 | Complementary information of inventory of goods subject to the tax substitution system |
1250 | Consolidated information about ICMS complementation, reimbursement and restitution balances |
1255 | Consolidated information about ICMS complementation, reimbursement and restitution balances by reason |
TOTVS presents, for the Microsiga Protheus product line, the routine ICMS-ST Complement and Reimbursement Calculation (FISA302). It was developed using tax regulation premises and, besides generating data to be displayed in the new EFD ICMS/IPI records, the routine presents the estimated calculated values of the tax to be reimbursed and/or complemented, for checking purposes. It also offers resources to check the values in accordance with calculation estimates by the system.
02. IMPLEMENTATION PROCEDURE
Data Dictionary and Update Package
1. In Configurator (SIGACFG), access Environments/Register/Menu (CFGX013). Enter the new menu option according to the following instructions:
Menu | SIGAFIS |
Sub-menu | Miscellaneous |
Routine Name | EFD/ICMS/IPI Reimbursement Calculation |
Program | FISA302 |
Module | Tax Records |
Type | Protheus |
03. PROCEDURE
You can access this routine through the name FISA302 or through the menu of module Tax Records, in Miscellaneous / Calculations.
When you access the routine, the main process screen appears. The menu located on the left lists the routines related to the calculation and generation of the file in question, detailed later, and, on the right side, the calculations already made are listed:
Click View to display the results of the calculation selected. On this screen, besides the calculated totals, you can view the calculated result for each calculation rule (related to code table 5.7 available per each state) and, for each rule, the transaction that composed the value calculated for reimbursement or complement, entered in inflow averages used to obtain the values.
Click Delete to delete the calculation selected. Be mindful that the ending balances of the period are also deleted:
Initial Balances
These records, for the new reason of inventory '06', must refer to the date immediately before the start of the period in which EFD ICMS/IPI is being presented. Example: When sending Tax SPED related to January/2021, the record H005 and children necessarily refer to 12/31/2020 and contain the quantities and initial averages for the calculation of values to be reimbursed and complemented for the current period.
The values for composing these records, in reason for inventory '06', are obtained through table CIL (ICMSST Res. Periodic Balances) and also of Inventory Record (generally obtained through report Inventory Model P7 - MATR460), as already traditionally done for other Block H presentation reasons.
Load Periodic Balances (automatic load)
This is an enabling routine, the use of which is directly connected to stock closings of the period immediately before the one in which the reimbursement is entered in the system. As mentioned above, the quantity of each product found in the inventory on the date desired is captured and the routine processes the previous inflows to compose the averages for each product, creating a record in table CIL with the quantity and initial averages calculated, and field CIL_TPREG filled out with the value '1'.
Manual Load
If you cannot execute the process above for any reason, you can still load each product manually. In this case, you must enter the quantity found in inventory and the initial averages that you may calculate manually from the incoming invoices that composed such quantity, given that field CIL_TPREG is filled out with the value '2'.
Field Descriptions
Product – Code of the product
Initial Qty – Initial quantity of the product
Final Qty – Final quantity of the product
Record Type
- Initial Balance - Automatic = Records automatically generated by option Load Periodic Balances (automatic load).
- Initial Balance - Manual = Records manually registered. Only this option allows editing values.
- Calculation Balance = Records automatically generated by performing the Calculation for the next period.
Total Initial Value of Own ICMS – Enter the initial value of Own ICMS for the period
Total Final Value of Own ICMS – Final value of Own ICMS for the period, arrived at by calculation
Initial Unit Value of Own ICMS – Enter the average initial unit value of Own ICMS for the period
Final Unit Value of Own ICMS – Average final unit value of Own ICMS, arrived at by calculation
Total Initial Value of ICMS ST – Enter the initial value of ICMS ST for the period
Total Final Value of ICMS ST – Final value of ICMS ST for the period, arrived at by calculation
Initial Unit Value of ICMS ST – Enter the average initial unit value of ICMS ST for the period
Final Unit Value of ICMS ST – Average final unit value of ICMS ST, arrived at by calculation
Total Initial Value of FECP – Enter the initial value of FECP ST for the period
Total Final Value of FECP – Final value of FECP ST for the period, arrived at by calculation
Initial Unit Value of FECP – Enter the average initial unit value of FECP ST for the period
Final Unit Value of FECP – Average final unit value of FECP ST, arrived at by calculation
Total Initial Value of ICMS ST CB – Enter the initial value of ICMS ST Calculation Base for the period
Total Final Value of ICMS ST CB – Final value of ICMS ST Calculation Base for the period, arrived at by calculation
Initial Unit Value of ICMS ST CB – Enter the average initial unit value of ICMS ST Calculation Base for the period
Final Unit Value of ICMS ST CB – Average final unit value of ICMS ST Calculation Base, arrived at by calculation
Deleting in Batches
This option deletes, for all products, the initial load balances (records with field Record Tp filled out with options Initial Balance - Automatic and, alternatively, Initial Balance - Manual), in the period entered.
Rules
The processing of the calculation analyzes inflow and outflow transactions in the period selected, for calculating values to be reimbursed and complemented, besides updating stock balances for each product moved. The definition of which transactions to calculate or not is a combination of CFOP (Tax Code of Operations and Provisions) with CST (Tax Status Code) of each transaction.
Therefore, the purpose of this routine is to grant the user control over transactions that must be taken to the calculation or not, through the configuration of CFOPs and its CSTs. When you first access the routine, a default automatic load of this definition is executed.
Example of register: Indicate that tax transactions with CFOP 5102 and with any CST listed on the grid are used in the calculation process.
Fields:
CFOP - Enter the CFOP that must be used in the processing of the Calculation routine.
Taxable Event Not Performed - Enter whether outflow transactions with this CFOP are classified as Deemed Taxable Event Not Performed.
CST - Enter the CSTs that, along with the CFOP registered above, must be used in the calculation process.
Load
Calculation of Reimbursement / Complement
The routine Calculation of Reimbursement or Complement of ICMS Withheld by Tax Substitution or Advanced, from the initial balances of each product (Initial Balances Register), processes the operations of the period by adopting the weighted moving average cost method, always following Rules Register definitions.
Each transaction is chronologically booked in a single line. Every day, all inflow transactions are calculated, followed by the returns of purchases and sales, and finally, outflow transactions in accordance with legal provisions. The only exception to this chronology is due to return operations that occur on the same day of their original operation, because the returns must annul the effects of the original operation and you can only identify the values to be reimbursed or complemented of an operation after their processing.
Regarding the order of transactions in the same day, inflow transactions and any returns are analyzed before outflow transactions. All calculated transactions update the physical and financial balance of the product. Regarding reimbursement/complement, outflow transactions may or may not generate tax complement or reimbursement.
At the end of processing, the routine presents, for the period analyzed, the estimated tax values to be reimbursed or complemented, besides transferring the calculated final balance of each product to the initial balance of the following period.
Enter the period for processing:
If you enter a period already previously processed, the question below is displayed. If you confirm the reprocessing, the existing records of the period entered are deleted and reprocessed.
Main screen with the result of the calculation process:
View
You can check the calculation result by legal framework:
Delete
Deletes all calculation records in the period selected.
Checking Report
For purposes of checking calculated values, you can extract a detailed report, as a spreadsheet, of each product transaction in the period selected.
Parameters for report generation:
From Year/Month - Enter the Reference Year/Month for selecting records.
Transaction - Printing
1 - Summ. Year/Month - Display summarized report
2 - Summ. Rule - Display summarized report and also display the framework and rule in use.
3 - Detailed - Display detailed report.
Creating the ST Restitution File
After calculating the Reimbursement, you can create the .TXT file.
Locate the ST MG Restitution option, created below the new File Creation structure, and fill out parameters as requested.
Parameters for generation
- Calculation Year/Month - Enter the calculation period. Ex: 2021/02
- File Purpose Code - Enter the Purpose in accordance with the application offered by SEF MG.
- Framework Code - In accordance with Table 5.7 - Code of Reasons for ICMS ST Complementation and Restitution.
- Create File - Enables file creation in Consolidated or Detailed form.
- Target File Directory - Enter the location in which to save the files created by this routine.
- Target File Name - Enter the name of the file to be created.
During the file creation process, a progress screen is displayed as shown below
At the end of file creation, an information screen is displayed with the process status, which may indicate the file was successfully created or not created.
Example of file with layout of purpose 4.
Example of file with layout of purpose 5.
04. FAQ
Can there be items with generic product codes?
The requirement and bookkeeping method of this record are defined by the home state of the taxpayer, as instructed by the ICMS/IPI Bookkeeping Practical Guide.
Below is an example of the behavior of a state with a proprietary ICMS ST reimbursement and/or complement calculation system:
The code used cannot be duplicated or attributed to different items. You must identify goods that underwent changes in their basic characteristics with different codes. Item discrimination must indicate precisely the item at issue, different breakdowns for the same item or generic breakdowns (such as "various inflows", "various outflows", "goods for resale", etc.) being forbidden.
05. TABLES
To expand, click here...
Data Dictionary
Table CIF - ICMSST Re. Reas. Detail Code
Key | Name | Mode | Pyme |
CIF | ICMSST Re. Reas. Detail Code | Shared | Yes |
Fields
Field | CIF_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System branch |
Used | No |
Required | No |
Browser | No |
Context | Real |
Ownership | View |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CIF_CODIGO |
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | Code |
Description | Code of table 5.7 |
Used | Yes |
Required | Yes |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 02 |
Field | CIF_DESCRV |
Type | Character |
Size | 150 |
Decimal | 0 |
Format | @! |
Title | Description |
Description | Description of code |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 03 |
Field | CIF_DTINI |
Type | Date |
Size | 8 |
Decimal | 0 |
Title | Start date |
Description | Start of effective date |
Used | Yes |
Required | Yes |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 04 |
Field | CIF_DTFIM |
Type | Date |
Size | 8 |
Decimal | 0 |
Title | End Date |
Description | Final effective date |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 05 |
Indexes
Index | CIF |
Order | 1 |
Key | CIF_FILIAL + CIF_CODIGO + DTOS(CIF_DTINI) |
Description | Code + Start Date |
Display Search | Yes |
Table CIG - Total Reimbursement Calc.
Key | Name | Mode | Pyme |
CIG | Total Reimbursement Calc. | Exclusive | Yes |
Fields
Field | CIG_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System Branch |
Used | No |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CIG_PERIOD |
Type | Character |
Size | 6 |
Decimal | 0 |
Format | @! |
Title | Year/Month |
Description | Year/Month of Calculation |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 02 |
Field | CIG_IDAPUR |
Type | Character |
Size | 36 |
Decimal | 0 |
Format | @! |
Title | Calculation ID |
Description | ID of Calculation |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | View |
Order | 03 |
Field | CIG_VCREDI |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Val. Credit |
Description | Vl. Own ICMS Credit |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 04 |
Field | CIG_VRESSA |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Reimb. Value |
Description | Value of Reimbursement |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 05 |
Field | CIG_REFECP |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | FC Reim. Val |
Description | FECP Reimbursement Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 06 |
Field | CIG_VCMPL |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Complem. Val. |
Description | ICMS Complement Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 07 |
Field | CIG_VCMFCP |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | FC Comp. Val. |
Description | FECP Complement Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 08 |
Indexes
Index | CIG |
Order | 1 |
Key | CIG_FILIAL + CIG_PERIOD |
Description | Year/Month |
Display Search | Yes |
Index | CIG |
Order | 2 |
Key | CIG_FILIAL + CIG_IDAPUR |
Description | Calculation ID |
Display Search | Yes |
Table CIH - Framework Reimb. Calc.
Key | Name | Mode | Pyme |
CIH | Framework Reimb. Calc. | Exclusive | Yes |
Fields
Field | CIH_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System Branch |
Used | No |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CIH_PERIOD |
Type | Character |
Size | 6 |
Decimal | 0 |
Format | @R 9999/99 |
Title | Year/Month |
Description | Year/Month of Calculation |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 02 |
Field | CIH_IDAPUR |
Type | Character |
Size | 36 |
Decimal | 0 |
Format | @! |
Title | Calculation ID |
Description | Calculation ID |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | View |
Order | 03 |
Field | CIH_ENQLEG |
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | Legal Fra. |
Description | Legal Framework |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 04 |
Field | CIH_VCREDI |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | ICM Cred Val |
Description | Own ICMS Cred Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 05 |
Field | CIH_VRESSA |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Reimb. Val |
Description | Value of Reimbursement |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 06 |
Field | CIH_REFECP |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | FCP Re. Val. |
Description | FECP Reimbursement Val. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 07 |
Field | CIH_VCOMPL |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Compl. Val. |
Description | Complement Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 08 |
Field | CIH_VCMFCP |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | FCP Com. Val. |
Description | FECP Complement Val. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 09 |
Field | CIH_REGRA |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Rule |
Description | Calculation Rule |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 10 |
Indexes
Index | CIH |
Order | 1 |
Key | CIH_FILIAL + CIH_PERIOD + CIH_ENQLEG + CIH_REGRA |
Description | Year/Month + Legal Fra. + Rule |
Display Search | Yes |
Index | CIH |
Order | 2 |
Key | CIH_FILIAL + CIH_IDAPUR |
Description | Calculation ID |
Display Search | Yes |
Table CII - Item Breakd. Reimb. Calc.
Key | Name | Mode | Pyme |
CII | Item Breakd. Reimb. Calc. | Exclusive | Yes |
Fields
Field | CII_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System Branch |
Used | No |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CII_PERIOD |
Type | Character |
Size | 6 |
Decimal | 0 |
Format | @R 9999/99 |
Title | Year/Month |
Description | Year/Month of Calculation |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 02 |
Field | CII_LIVRO |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Record |
Description | Tax Record Number |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 03 |
Field | CII_IDAPUR |
Type | Character |
Size | 36 |
Decimal | 0 |
Format | @! |
Title | Calculation ID |
Description | Calculation ID |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 04 |
Field | CII_NFISCA |
Type | Character |
Size | 9 |
Decimal | 0 |
Format | @! |
Title | Invoice |
Description | Invoice |
Used | Yes |
Required | No |
Browser | Yes |
System Val. | ExistCpo("SFT", M->CII_TPMOV + M->CII_NFISCA, 1) |
Context | Real |
Ownership | Edit |
Order | 05 |
Field | CII_SERIE |
Type | Character |
Size | 3 |
Decimal | 0 |
Format | @! |
Title | Series |
Description | Invoice Series |
Used | Yes |
Required | No |
Browser | Yes |
System Val. | ExistCpo("SFT", M->CII_TPMOV + M->CII_NFISCA + M->CII_SERIE, 1) |
Context | Real |
Ownership | Edit |
Order | 06 |
Field | CII_PARTIC |
Type | Character |
Size | 6 |
Decimal | 0 |
Format | @! |
Title | Participant |
Description | Participant Code |
Used | Yes |
Required | No |
Browser | Yes |
Val. System | ExistCpo("SA1") |
Context | Real |
Ownership | Edit |
Order | 07 |
Field | CII_LOJA |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Store |
Description | Participant's Store |
Used | Yes |
Required | No |
Browser | Yes |
Val. System | ExistCpo("SA1", M->CII_PARTIC + M->CII_LOJA) |
Context | Real |
Ownership | Edit |
Order | 08 |
Field | CII_DTMOV |
Type | Date |
Size | 8 |
Decimal | 0 |
Title | Transact. Date |
Description | Date of Transaction |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 09 |
Field | CII_TPMOV |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Trans Type |
Description | Type of Transaction |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 10 |
Field | CII_ESPECI |
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | Inv Kind |
Description | Invoice Kind |
Used | Yes |
Required | No |
Browser | Yes |
System Val. | EXISTCPO("SX5", "42" + M->CII_ESPECI) |
Context | Real |
Ownership | Edit |
Order | 11 |
Field | CII_ITEM |
Type | Character |
Size | 4 |
Decimal | 0 |
Format | @! |
Title | Inv Item |
Description | Invoice Item |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 12 |
Field | CII_PRODUT |
Type | Character |
Size | 30 |
Decimal | 0 |
Format | @! |
Title | Product |
Description | Product Code |
Used | Yes |
Required | No |
Browser | Yes |
Val. System | ExistCpo("SB1") |
Context | Real |
Ownership | Edit |
Order | 13 |
Field | CII_CST |
Type | Character |
Size | 3 |
Decimal | 0 |
Format | @! |
Title | CST |
Description | CST of ICMS |
Used | Yes |
Required | No |
Browser | Yes |
Val. System | ExistCpo("SX5", "S2" + M->CII_CST) |
Context | Real |
Ownership | Edit |
Order | 14 |
Field | CII_CFOP |
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | CFOP |
Description | Oper/Provis. Tax Code |
Used | Yes |
Required | No |
Browser | Yes |
Val. System | ExistCpo("SX5", "13"+M->CII_CFOP) |
Context | Real |
Ownership | Edit |
Order | 15 |
Field | CII_ENQLEG |
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | Legal Fra. |
Description | Legal Fra. |
Used | Yes |
Required | No |
Browser | Yes |
System Val. | ExistCpo("CIF") |
Context | Real |
Ownership | Edit |
Order | 16 |
Field | CII_QTDMOV |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Quantity |
Description | Quantity of Transaction |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 17 |
Field | CII_UNID |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Unit |
Description | Measurement Unit |
Used | Yes |
Required | No |
Browser | Yes |
System Val. | ExistCpo("SAH") |
Context | Real |
Ownership | Edit |
Order | 18 |
Field | CII_VUNIT |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Unit Value |
Description | Unit Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 19 |
Field | CII_ICMEFS |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Out Eff ICM |
Description | Outflow Effective ICMS |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 20 |
Field | CII_VUCRED |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999,999,999.999999 |
Title | Cred Unit Val |
Description | ICMS Cred Unit Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 21 |
Field | CII_MUBST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Ba. Un. Avg. |
Description | ST Base Unit Average |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 22 |
Field | CII_MUVSTF |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP ST Avg. |
Description | ST and FECP Average Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 23 |
Field | CII_MUVSF |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Sto.FCP Avg. |
Description | Stock FECP ST Average Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 24 |
Field | CII_VUREST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Rest. Avg. |
Description | ST and FECP Rest. Avg. Val. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 25 |
Field | CII_VURTFC |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP Rest.Un. |
Description | FCP Restitution Unit Val. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 26 |
Field | CII_VUCST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST.FC Compl. |
Description | ST and FCP Compl. Unit. Val. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 27 |
Field | CII_VUCFC |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP Com.Unit |
Description | FECP Complement Unit |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 28 |
Field | CII_CODRES |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Resp. Code |
Description | Responsible Party Code |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 29 |
Field | CII_ICMEFE |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Inf Eff ICM |
Description | Inflow Effective ICMS |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 30 |
Field | CII_BURET |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Prev. Wthh.Un.B |
Description | Previously Wthh. Un. B |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 31 |
Field | CII_VURET |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP Pd.Un.V. |
Description | Previously Paid Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 32 |
Field | CII_VURFCP |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | F.Pr.Pd.Un.V |
Description | FECP previously paid unit value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 33 |
Field | CII_NUMDA |
Type | Character |
Size | 20 |
Decimal | 0 |
Format | @!! |
Title | Doc Number |
Description | Number of Collection |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 34 |
Field | CII_CODDA |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Coll. Model |
Description | Collection Model |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 35 |
Field | CII_MUCRED |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Cred. Avg. V. |
Description | ICM Credit Average Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 36 |
Field | CII_QTDSLD |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Balance Qty |
Description | Stock Balance Quantity |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 37 |
Field | CII_VCREDI |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ICM Cred Val |
Description | Own ICMS Cred Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 38 |
Field | CII_VRESSA |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Reimb. Val. |
Description | Reimbursement Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 39 |
Field | CII_VREFCP |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP Reimb.V. |
Description | FECP Reimbursement Val. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 40 |
Field | CII_VCMPL |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Compl. Val. |
Description | Complement Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 41 |
Field | CII_VCMFCP |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP Comp. V. |
Description | FECP Complement Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 42 |
Field | CII_TPREG |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Record Type |
Description | Type of Record |
Used | Yes |
Required | No |
Browser | No |
Val. System | Belong("1") |
Context | Real |
Ownership | View |
Order | 43 |
Field | CII_PDV |
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | PDV Number |
Description | PDV Number |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | Edit |
Order | 44 |
Field | CII_REGRA |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Code |
Description | Code of table 5.7 |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 45 |
Field | CII_ORDEM |
Type | Character |
Size | 9 |
Decimal | 0 |
Format | @! |
Title | Order |
Description | Order |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 46 |
Field | CII_TIPO |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Invoice Type |
Description | Invoice Type |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | Edit |
Order | 47 |
Field | CII_SPED |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Generate SPED |
Description | Define whether to Generate in SPED |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | Edit |
Order | 48 |
Field | CII_VUNCON |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | C. Unit Val. |
Description | Convention Unit Value |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 49 |
Indexes
Index | CII |
Order | 1 |
Key | CII_FILIAL + CII_PERIOD + CII_LIVRO + CII_TPMOV + CII_SERIE + CII_NFISCA + CII_PARTIC + CII_LOJA + CII_ITEM + CII_PRODUT |
Description | Year/Month + Record + Trans Type + Series + Invoice+ Participant + Store |
Display Search | Yes |
Index | CII |
Order | 2 |
Key | CII_FILIAL + CII_TPMOV + CII_SERIE + CII_NFISCA + CII_PARTIC + CII_LOJA + CII_ITEM + CII_PRODUT |
Description | Trans Type + Series + Invoice + Participant + Store + Inv Item + Prod |
Display Search | Yes |
Index | CII |
Order | 3 |
Key | CII_FILIAL + CII_IDAPUR |
Description | Calculation ID |
Display Search | Yes |
Index | CII |
Order | 4 |
Key | CII_FILIAL + CII_PERIOD + CII_PRODUT |
Description | Year/Month + Product |
Display Search | Yes |
Index | CII |
Order | 5 |
Key | CII_FILIAL + CII_PERIOD + CII_ENQLEG + CII_REGRA |
Description | Year/Month + Legal Fram. + Code |
Display Search | Yes |
Table CIJ - Framework Header
Key | Name | Mode | Pyme |
CIJ | Framework Header | Exclusive | Yes |
Fields
Field | CIJ_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System Branch |
Used | No |
Required | No |
Browser | No |
Context | Real |
Ownership | Edit |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CIJ_IDTAB |
Type | Character |
Size | 36 |
Decimal | 0 |
Format | @! |
Title | Table ID |
Description | Unique Identifier |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | View |
Order | 02 |
Field | CIJ_CFOP |
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | CFOP |
Description | Operation Tax Code |
Used | Yes |
Required | No |
Browser | Yes |
System Val. | ExistCpo("SX5", "13" + FWFLDGET("CIJ_CFOP")) .AND. ExistChav("CIJ", FWFLDGET("CIJ_CFOP"), 2) |
Context | Real |
Ownership | Edit |
Stand. Query | 13 |
Order | 03 |
Field | CIJ_DECFOP |
Type | Character |
Size | 60 |
Decimal | 0 |
Format | @! |
Title | Description |
Description | CFOP Description |
Used | Yes |
Required | No |
Browser | No |
Default Init. | IIF(!INCLUI, POSICIONE("SX5", 1, XFILIAL("SX5") + "13" + CIJ->CIJ_CFOP, "X5DESCRI()"), "") |
Context | Virtual |
Ownership | View |
Order | 04 |
Field | CIJ_FATGER |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Taxable Event |
Description | Taxable Event Indicator |
Used | Yes |
Required | No |
Browser | Yes |
Options | 1=Yes, 2=No |
Default Init. | '2' |
System Val. | Belong("12") |
Context | Real |
Ownership | Edit |
Order | 05 |
Field | CIJ_RESSAR |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Reimbursement |
Description | Consider f/ Reimbursement |
Used | Yes |
Required | No |
Browser | Yes |
Options | 1=Yes, 2=No |
Default Init. | '1' |
System Val. | Belong("12") |
Context | Real |
Ownership | Edit |
Order | 06 |
Indexes
Index | CIJ |
Order | 1 |
Key | CIJ_FILIAL + CIJ_IDTAB |
Description | Table ID |
Display Search | Yes |
Index | CIJ |
Order | 2 |
Key | CIJ_FILIAL + CIJ_CFOP |
Description | CFOP |
Display Search | Yes |
Table CIK - Item Framework
Key | Name | Mode | Pyme |
CIK | Item Framework | Exclusive | Yes |
Fields
Field | CIK_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System Branch |
Used | No |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CIK_CSTICM |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | ICMS CST |
Description | CST of ICMS |
Used | Yes |
Required | No |
Browser | Yes |
Val. System | ExistCpo("SX5", "S2" + M->CIK_CSTICM) |
Context | Real |
Ownership | Edit |
Cons. Default | S2 |
Order | 02 |
Field | CIK_DESCST |
Type | Character |
Size | 60 |
Decimal | 0 |
Format | @! |
Title | Description |
Description | ICMS CST Description |
Used | Yes |
Required | No |
Browser | Yes |
Default Init. | IIF(!INCLUI, POSICIONE("SX5", 1, XFILIAL("SX5") + "S2" + CIK->CIK_CSTICM, "X5DESCRI()"), "") |
Context | Virtual |
Ownership | View |
Order | 03 |
Field | CIK_IDTAB |
Type | Character |
Size | 36 |
Decimal | 0 |
Format | @! |
Title | Table ID |
Description | CIJ Table Identifier |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | View |
Order | 04 |
Indexes
Index | CIK |
Order | 1 |
Key | CIK_FILIAL + CIK_IDTAB + CIK_CSTICM |
Description | Table ID + ICMS CST |
Display Search | Yes |
Table CIL - ICMSST Re. Periodic Balance
Key | Name | Mode | Pyme |
CIL | ICMSST Re. Periodic Balance | Exclusive | Yes |
Fields
Field | CIL_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System Branch |
Used | No |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CIL_PERIOD |
Type | Character |
Size | 6 |
Decimal | 0 |
Format | @R 9999/99 |
Title | Year/Month |
Description | Year/Month of Processing |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 02 |
Field | CIL_IDAPUR |
Type | Character |
Size | 36 |
Decimal | 0 |
Format | @! |
Title | Calculation ID |
Description | Calculation identifier |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | Edit |
Order | 03 |
Field | CIL_PRODUT |
Type | Character |
Size | 15 |
Decimal | 0 |
Format | @! |
Title | Product |
Description | Product Code |
Used | Yes |
Required | Yes |
Browser | Yes |
Val. System | ExistCpo("SB1") |
Context | Real |
Ownership | Edit |
Cons. Default | SB1 |
Field Group | 030 - Product Size |
Order | 04 |
Field | CIL_DESPRO |
Type | Character |
Size | 30 |
Decimal | 0 |
Format | @! |
Title | Product Desc. |
Description | Product Description |
Used | Yes |
Required | No |
Browser | No |
Default Init. | IIF(!INCLUI, POSICIONE("SB1", 1, xFilial("SB1") + CIL->CIL_PRODUT, "B1_DESC"), "") |
Context | Virtual |
Ownership | View |
Order | 05 |
Field | CIL_QTDSLD |
Type | Numeric |
Size | 16 |
Decimal | 2 |
Format | @E 9,999,999,999,999.99 |
Title | Initial Qty |
Description | Initial Balance Qty |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 06 |
Field | CIL_QTDFIM |
Type | Numeric |
Size | 16 |
Decimal | 2 |
Format | @E 9,999,999,999,999.99 |
Title | Final Qty |
Description | Final Balance Qty |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Order | 07 |
Field | CIL_TPREG |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Record Type |
Description | Type of Record |
Used | Yes |
Required | No |
Browser | No |
Options | 1=Initial Balance - Automatic; 2=Initial Balance - Manual; 3=Calculation Balance |
Val. System | Belong("123") |
Context | Real |
Ownership | View |
Order | 08 |
Field | CIL_TICM |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Ini.Tot.Val |
Description | OP ICMS Initial Total Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 09 |
Field | CIL_TFICM |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Fin.Tot.Val |
Description | OP ICMS Final Total Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Order | 10 |
Field | CIL_MICM |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Ini.Avg.Val |
Description | ICMS Initial Unit Avg. Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 11 |
Field | CIL_MFICM |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | Final Avg.Val |
Description | ICMS Final Unit Avg. Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Order | 12 |
Field | CIL_TUST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST Ini.Tot. V. |
Description | ST ICMS Initial Total Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 13 |
Field | CIL_TFST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST Fin.Tot. V. |
Description | ST ICMS Final Total Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Order | 14 |
Field | CIL_MUST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST Ini.Avg. V. |
Description | ICMS ST Ini. Unit Avg. V. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 15 |
Field | CIL_MFST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST Fin.Avg. V. |
Description | ICMS ST Fin. Unit Avg. V. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Order | 16 |
Field | CIL_TIFC |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FC Ini.Tot. V. |
Description | FECP Initial Total Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 17 |
Field | CIL_TFFC |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FC Fin.Tot. V. |
Description | FECP Final Total Val |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Order | 18 |
Field | CIL_MIFC |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP In.Avg. V |
Description | FECP Initial Unit Avg. V. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 19 |
Field | CIL_MFFC |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | FCP Fi.Avg. V |
Description | FECP Final Unit Avg. V. |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Order | 20 |
Field | CIL_TIBCST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST CB I T V |
Description | ST CB Initial Total V. |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | Edit |
Order | 21 |
Field | CIL_TFBCST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST CB F T V |
Description | ICMS ST CB Final Total Val. |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | View |
Order | 22 |
Field | CIL_MUBCST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST CB I U V |
Description | ST CB Initial Unit V. |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | Edit |
Order | 23 |
Field | CIL_MFBCST |
Type | Numeric |
Size | 16 |
Decimal | 6 |
Format | @E 999999999,999999 |
Title | ST CB F U V |
Description | ICMS ST CB Final Unit Val. |
Used | Yes |
Required | No |
Browser | No |
Context | Real |
Ownership | View |
Order | 24 |
Field | CIL_SPED |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | SPED |
Description | Define whether to generate SPED |
Used | Yes |
Required | No |
Browser | No |
Options | 1=Generate SPED; 2=Do Not Generate SPED |
Context | Real |
Ownership | Edit |
Order | 25 |
CIL Indexes
Index | CIL |
Order | 1 |
Key | CIL_FILIAL + CIL_PERIOD + CIL_PRODUT |
Description | Year/Month + Product |
Display Search | Yes |
Index | CIL |
Order | 2 |
Key | CIL_FILIAL + CIL_IDAPUR |
Description | Calculation ID |
Display Search | Yes |
Table CIM - Rules Register
Key | Name | Mode | Pyme |
CIM | Rules Register | Exclusive | Yes |
Fields
Field | CIM_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Title | Branch |
Description | System Branch |
Used | No |
Required | No |
Browser | Yes |
Context | Real |
Ownership | View |
Field Group | 033 - Branch Size |
Order | 01 |
Field | CIM_CODIGO |
Type | Character |
Size | 5 |
Decimal | 0 |
Format | @! |
Title | Code |
Description | Code of table 5.7 |
Used | Yes |
Required | Yes |
Browser | Yes |
Val. System | ExistCPO("CIF") |
Context | Real |
Ownership | Edit |
Cons. Default | CIF |
Order | 02 |
Field | CIM_REGRA |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Calc. Rule |
Description | Calculation Rule |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 03 |
Field | CIM_DESCRI |
Type | Character |
Size | 150 |
Decimal | 0 |
Format | @! |
Title | Rule Descr. |
Description | Rule Description |
Used | Yes |
Required | No |
Browser | Yes |
Context | Real |
Ownership | Edit |
Order | 04 |
Indexes
Index | CIM |
Order | 1 |
Key | CIM_FILIAL + CIM_REGRA |
Description | Calc. Rule |
Display Search | Yes |
Important:
The size of fields that have group may vary depending on the environment used.