...
Illustrative flowchart (city A = Barueri, city B = São Paulo)
Aviso |
---|
Make sure that the municipality where the service invoice is being issued is included in this obligation and that it requires CPOM. |
...
Table SE2 Accounts Payable:
• E2_CODSERV
Field | E2_CODSERV |
Type | Character |
Size | 9 |
Decimal | 0 |
Format | @! |
Title | ISS Serv Code |
Description | ISS Service Code |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Real |
Options | <empty> |
When | <empty> |
Relation | <empty> |
Val. System | ExistCpo("SX5","60"+AllTrim(M→E2_CODSERV)) .and. Fa050Nat2() |
Help | E2_CODSERV |
Field | E2_BTRISS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | ISS Double Taxation |
Description | ISS CPOM Double Taxation |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Real |
Options | <Empty> |
When | M->E2_MULTNAT != "1" |
Relationship | <Empty> |
Val. System | Positivo() .and. IIF(M->E2_TIPO="PR" .and. M->E2_ISSBTR > 0,.F.,.T.) |
Help | E2_BTRISS |
Field | E2_VRETBIS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Vl. ISBWithh. |
Description | Vl. ISS Double Tax Withholding |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | View |
Context | Real |
Options | <Empty> |
When | <Empty> |
Relation | <Empty> |
Val. System | <Empty> |
Help | E2_VRETBIS |
Data modeling, fields creation in file SX3 - Fields:
Table SE1 Accounts Receivable:
Field | E1_CODSERV |
Type | Character |
Size | 9 |
Decimal | 0 |
Format | @! |
Title | ISS Serv Code |
Description | ISS Service Code |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Real |
Options | <empty> |
When | <empty> |
Relation | <empty> |
Val. System | ExistCpo("SX5","60"+AllTrim(M→E1_CODSERV)) .and. Fa040Natur() |
Help | E1_CODSERV |
Field | E1_BTRISS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | ISS Double Taxation |
Description | ISS Double Taxation Amount |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Real |
Options | <Empty> |
When | M->E1_MULTNAT != "1" |
Relation | <Empty> |
Val. System | positivo() .and. m->e1_iss < m->e1_valor .and. IIF(m->e1_tipo="PR" .and. m->e1_iss > 0,.F.,.T.) .and. fa040valor() |
Help | ISS Double Taxation |
Field | E1_VRETBIS |
Type | Numeric |
Size | 14 |
Decimal | 2 |
Format | @E 99,999,999,999.99 |
Title | Value Wt. ISSB |
Description | Amount withheld in ISS double taxation |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | View |
Context | Real |
Options | <Empty> |
When | <Empty> |
Relation | <Empty> |
Val. System | <Empty> |
Help | Value Wt. ISSB |