SIAFI is the Federal Government's Integrated Financial Administration System which is the main instrument to record, monitor and control the Federal Government's budget, financial and patrimonial execution.
The Financial Clearing Document is a subsystem of SIAFI that aims to allow the settlement phase of expenses payable and receivables arising from the activities of the Management Units, generating commitments for the realization phase and promoting the accounting effect of these actions by generating SIAFI Documents.
The Financial Clearing Document form is divided into two main sections where the fields for filling in the Document data and system messages are placed. They are:
Each Financial Clearing Document has a subset of tabs that is determined by the code entered in the Document Type field, completed in the Header section when the Financial Clearing Document is created. It is also the Document Type that determines whether the Financial Clearing Document is of a Payment or Receipt nature, which tabs are mandatory and which ones are not.
A given Financial Clearing Document can be composed of a subset of the following tabs:
ROUTINE | DESCRIPTION | Notes | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
FINA760.PRW | Financial Clearing Document Statuses | |||||||||||
FINA761.PRW | Financial Clearing Document | Sub-routines:
| ||||||||||
FINA762.PRW | Responsible Management Unit | |||||||||||
FINA763.PRW | Financial Programming | Sub-routine:
| ||||||||||
FINXSIAFI.PRW | Functions auxiliary to SIAFI |
Information
For more details on legislation, visit the Sao Paulo city hall link: Registration of Companies Outside the City
This form presents, details and allows you to allocate or undo the allocation of the values entered in the Financial Clearing Document to their respective Cost Centers.
Cost Center codes can be associated to the following items' values entered in the Financial Clearing Document that have not been cancelled and with a Status that affects the Cost Center by sum or subtraction:
1. Principal with Budget;
2. Principal without Budget;
3. Other Postings;
4. Charges;
5. Increases;
6. Expense to Cancel.
When the Financial Clearing Document is being edited, the items in which the Cost Center code is mandatory are listed in an "Items pending Cost Center information" section. The Cost Centers already entered are listed in another section that also displays the Financial Clearing Document items associated to the code of the Cost Center that consolidates them.
The Financial Clearing Document form is divided in two main sections containing the fields for entering the FCD's data and the system messages. They are:
1. the Header section presents data that identifies the current Financial Clearing Document. This data was entered at the document's creation;
2. the Tab section contains fields for relative information, that is, the FCD's value allocations to the respective Cost Centers.
Each Financial Clearing Document contains a subset of tabs determined by the code entered in the Type of Document field, filled in the Header section when the FCD is created. The Type of Document field also determines if the Financial Clearing Document is of Payment or Receipt nature, which tabs are mandatory and which of them are not.
The header fields' data is entered when the creation of the FCD is confirmed. After that, they cannot be edited.
The FCD's header is always presented with one of its tabs and is composed of the following fields:
Issuing MG Code - displays the code of the Management Unit that issues the current FCD.
Issuing MG Name - displays the name of the Management Unit that issues the current FCD.
Currency - displays the name and the symbol of the currency used in the Management Unit that issues the current FCD.
Year - displays the year when the current FCD was issued.
This information composes the identifier code for the current FCD.
Type of Document - displays the code of the current FCD's document type.
This information composes the identifier code for the FCD.
Title - displays the descriptive title corresponding to the code of the current FCD type.
FCD Number - displays the number of the current FCD.
FCD Number
This information composes the identifier code for the FCD.
When this field is empty, it means that the current FCD is a new document that is still not registered and that, for the Type of Document entered, this field is optional. In this case, the FCD number will be generated and displayed after the first registration of the FCD.
The Cost Center tab lists the Financial Clearing Document items to which a Cost Center code must be associated or is associated.
This tab is composed as follows.
Totalizers
Information presented by a set of fields that enter the values to associate and associated to Cost Center codes. It is composed of the following fields:
Cost Center to enter- presents the sum of the Financial Clearing Document items' values that affect the Cost Center and that have not been related to a Cost Center code, minus the values from the items already related and that need correction. It is subdivided in the following fields:
Sum Effect - displays the value installment of the Cost Center to Inform field when the items that compose it refer to Statuses with the indicator Effect on Cost Center set to "Sums".
Subtract Effect - displays the value installment of the Cost Center to Inform field when the items that compose it refer to Statuses with the indicator Effect on Cost Center set to "Subtracts".
Entered Cost Center - The system calculates it automatically as the Cost Center codes are corrected. It is the result of the subtraction between the sum of the items' values that affect Cost Center and were not related to a Cost Center code; and the values from the items already related and that need to be corrected. It is subdivided in the following fields:
Sum Effect - Automatically calculated by the system as the Cost Centers are corrected. It is the value installment from field Entered Cost Center that refers to the Status with the indicator Effect on Cost Center set to "Sums".
Subtract Effect - Automatically calculated by the system as the Cost Centers are corrected. It is the value installment from field Entered Cost Center that refers to the Status with the indicator Effect on Cost Center set to "Subtracts".
Items to enter
This presents a group of fields to enter information from the Cost Center to be associated to the FCD items that still need it. It is composed of the following fields:
The FCD items that still need to enter Cost Center are consolidated and displayed, grouped by tab, among with the fields for entering the Cost Center code.
Cost Center - The cost center that will be associated to the FCD items.
Reference Month - the month to which the Cost Center refers to.
Reference Year - the year to which the Cost Center refers to.
SIORG Code - the SIORG code to which the Cost Center refers to.
Benefitted MU - code of the MU benefitted by the Cost.
The system suggests that this field is filled with the FCD's Issuing MU code.
Items pending the Cost Center information
This lists the FCD items that still need a Cost Center code. It is composed of the following fields:
Tab Name - displays the FCD tab name where the Cost Center corresponding to the listed items' values must be entered.
The items in the following tabs need a Cost Center code:
1. Principal with Budget;
2. Principal with Budget - Anticipated Expense;
3. Principal without Budget;
4. Other Postings;
5. Other Postings - Patrimonial Schedule;
6. Charges;
7. Increases;
Status - status code of the items from the FCD tab that need a Cost Center.
Effect - automatically entered by the system with the Effect ("Sums" or "Subtracts") that the value of the FCD items apply on the Cost Center value.
Commitment - automatically entered by the system with the commitments entered for the FCD Status items to which a Cost Center is desired.
Sub-item - automatically entered by the system with the sub-items entered for the FCD Status items' commitments to which a Cost Center is desired.
Detailed Expense Nature - if the FCD Status demands NDD, this field is automatically entered by the system with the Commitment's ND and Sub-item when the item has both data; otherwise, you must enter it when mandatory.
Consolidated Item Value - the value of the FCD item needing Cost Center that took part in the Cost Center item composition. Automatically entered by the system using the sum of the FCD items values to which Cost Centers will be entered.
Value to Allocate - the difference between the FCD item value that needs a Cost Center and the Cost Center value already allocated to the item.
Total Cost - automatically calculated from the sum of the Cost Values entered by the user for each FCD item selected to compose the Cost Center item.
Entered Cost Centers
This relates the Cost Center items already associated to the FCD items' values. It is composed of the following fields:
These items' fields are blocked.
Cost Center - the Cost Center associated to the FCD items.
Reference - the month and the year to which the Cost Center refers.
Benefitted MU - the code of the MU benefitted by the Cost.
Cost Value - the sum of the values from the items that were associated to the referred Cost Center.
Items associated to the Cost Center - for each entered Cost Center, this tab lists the FCD items that are associated to that Cost Center in a table containing the following fields:
Status - Status code of the items associated to the Cost Center.
Effect - the effect ("sums" or "subtracts") that the FCD items values apply on the Cost Center Value.
Commitment - the code of the commitments entered for the items associated to the Cost Center.
Sub-item - code that details the information associated to the commitments of the FCD items associated to the Cost Center.
Detailed Expense Nature - code that details the nature of the expense of the FCD items associated to the Cost Center.
Status - the status held by the FCD items that compose the Cost Center item. This identifies if the FCD is already registered or if its cancellation has been requested, demanding an adjustment in the Cost Center item.
Consolidated Item Value - the value of the FCD items associated to the Cost Center.
Value to Allocate - the difference between the FCD item value that needs a Cost Center and the Cost Center value already allocated to the item.
Total Cost - it refers to the "Cost Value" field of the FCD item to the Relate Cost Center field that took part in the Cost Center item composition.
Field | SIORG |
Type | Numeric / Int |
Size | 6 |
Format | @999999 |
Title | Institutional Innovation and Organization System |
Description | Tree structure containing the Units list. |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | Yes |
Visual? | View |
Context | Actual |
Options | <Empty> |
When | <Empty> |
Relationship | <Empty> |
System Val. | <Empty> |
Help | SIORG |
Field | Cost Center |
Type | String |
Size | 11 |
Format | @! |
Title | Expense Nature |
Description | Information containing the Cost Center code. |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | Yes |
Visual? | View |
Context | Actual |
Options | <Empty> |
When | <Empty> |
Relationship | <Empty> |
System Val. | <Empty> |
Help | Cost Center Cd. |
Field | Expense Nature |
Type | Numeric / int |
Size | 8 |
Format | @E 9.9.99.99.99 |
Title | Expense Nature |
Description | Expense's budgeting classification. |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | Yes |
Visual? | View |
Context | Actual |
Options | <Empty> |
When | <Empty> |
Relationship | <Empty> |
System Val. | <Empty> |
Help | Budgeting Class. |
Data modelling, field creation in file SX3 – Fields:
Table SE3 Accounts Payable:
Field | E2_CODSERV |
Type | Character |
Size | 9 |
Decimal | 0 |
Format | @! |
Title | ISS Serv.Cd |
Description | ISS Service Code |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Actual |
Options | <empty> |
When | <empty> |
Relationship | <empty> |
System Val. | 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 Doublet |
Description | ISS CPOM Double Taxation |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Actual |
Options | <Empty> |
When | M->E2_MULTNAT != "1" |
Relationship | <Empty> |
System Val. | 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 | ISB With. Vl |
Description | Double t. ISS With. Vl |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | View |
Context | Actual |
Options | <Empty> |
When | <Empty> |
Relationship | <Empty> |
System Val. | <Empty> |
Help | E2_VRETBIS |
Accounts Receivable
Data modelling, fields creation in file SX3 – Fields:
Table SE1 Accounts Receivable:
Field | E1_CODSERV |
Type | Character |
Size | 9 |
Decimal | 0 |
Format | @! |
Title | ISS Serv.Cd |
Description | ISS Service Code |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Actual |
Options | <empty> |
When | <empty> |
Relationship | <empty> |
System Val. | 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 Value |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | Edit |
Context | Actual |
Options | <Empty> |
When | M->E1_MULTNAT != "1" |
Relationship | <Empty> |
System Val. | 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 | ISSB With. Value |
Description | Value withheld in ISS Double Taxation |
Level | 1 |
Used | Yes |
Mandatory | No |
Browse | No |
Visual? | View |
Context | Actual |
Options | <Empty> |
When | <Empty> |
Relationship | <Empty> |
System Val. | <Empty> |
Help | ISSB With. Value |
04. References
SIAFI - Complete Manual: http://manualsiafi.tesouro.gov.br/
TAB - Cost Center: http://manualsiafi.tesouro.gov.br/contas-a-pagar-e-a-receber/documento-habil/consultar-documento-habil/aba-dados-basicos/aba-centro-de-custo
SIORG: https://siorg.planejamento.gov.br/siorg-cidadao-webapp/apresentacao.jsf - WebService ; Data Structure http://dados.gov.br/dataset/siorg