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 |
|