This chapter contains the following topics:
You generate block 0 registers and records to provide opening, identification, and reference information for the electronic files that you submit for FCont reporting.
The system writes records for block 0 registers when you run the Block 0 Generation program (R76B840) from the FCONT SPED Job Administrator program (P76B940).
The system reads these tables to obtain the data for block 0 registers:
Address Book Master (F0101)
Address Book - Who's Who (F0111)
Address by Date (F0116)
Address Book Inscription - BR (F76B140)
Legal Company Constants - BR (F76B010)
The system writes the data for block 0 registers in the following table:
SPED Process (F76B940)
SPED Process Detail (F76B943)
This table describes the contents of the registers for block 0:
| Registers | Description of Contents | Compliance and Occurrence |
|---|---|---|
| 0000
Flat File Opening and Company Identification |
Includes information about the date of the file and company information from the company address book record and related tables. | One only register 0000 must be present in the electronic file. |
The system generates the supported registers for block 0 when you run the SPED FCont - Generation program (R76B840). This program identifies the master information that will be used in block 0 and updates the F76B943 table with the UBE name, register type, line sequence and the text of the register type.
The system also generates a report that you use to verify the data generated. The report includes the most relevant information, whether registers were successfully generated, and the errors in the registers, if any. If an error exists, the system does not include any of the related records for the register. For example, if a register includes details about the records in another register, the system does not populate the fields for either register if an error exists for one or the other register. You can correct errors and rerun the report as many times as necessary to complete the file generation with no errors.
|
Note: To be able to see errors in registers, you must set up the UBE to show details. See Extracting and Reviewing Data for FCont |
You generate block I registers and records to provide general information, account balances and accounting journal information for the electronic files that you submit for FCont reporting. Multiple programs exist to populate the records for block I.
The system writes records for block I registers when you run the following programs:
Block I - General Information program (R76B841)
Block I - Account Balances program (R76B842)
Block I - Accounting Journal program (R76B843)
You use the FCONT SPED Job Administrator program (P76B940) to run these batch programs.
The system reads these tables to obtain the data for block I registers:
Business Unit Master (F0006)
Account Master (F0901)
Account Balances (F0902)
Account Ledger (F0911)
FCONT Account Ledger Operations (F76B835)
Legal Company Subsidiaries (F76B015)
Additional Account Information (F76B925)
The system writes the data for block I registers in the following table:
SPED Process (F76B940)
SPED Process Detail (F76B943)
Job Accounts (F76B955)
This table describes the contents of the registers for block I:
| Registers | Description of Contents | Compliance and Occurrence |
|---|---|---|
| I001
Block I Opening |
Includes a hard-coded value to indicate that records exist in the file. | This register must be present in the electronic file.
One record exists in this register. |
| I050
Chart of Accounts |
Includes account information including dates, level of the account, and referential account.
As the system processes accounts for this register, it saves the account data to the SPED Job Accounts - BR table so that the information can be used to validate data required for fields in this register and in other blocks registers. |
Multiple records can exist in this register. |
| I051
Referential Chart of Accounts |
Includes referential account information that you set up in the Referential Chart of Accounts program (P76B920). | Multiple records can exist in this register.
The system populates this register for analytical accounts only. Analytical accounts are those that have a value of A in field 4 of the I050 register. |
| I075
Standard Historic Table |
The system shows this register with no values. | The system shows this register with no values. |
| I100
Costs Center |
Includes information about the cost centers for the accounts informed on Register I051. | This register is mandatory.
Multiple records can exist in this register. |
| I150
Periodic Balances – Period Identification |
Includes the first and last calendar date for the quarter/year. | This register is mandatory. This register contains a single record. |
| I155
Periodic Balances Details |
Includes the initial balance, sum of the positive transactions, sum of the negative transactions, and the final account balance. | Multiple records can exist in this register.
The system includes records for each analytical account with a balance or that had transactions. |
| I200
Accounting Journal |
Includes information about all F0911 batches considered as journal entries for FCont generated for a date range defined in the job and the FCont journal entries operations (from UDC 76B/FA). | Multiple records can exist in this register. |
| I250
Journal Entry Lines |
Includes the details of posted journal entries identified in the I200 register for the ledger types identified in the Book Type Definition program (P76B935). | Multiple records can exist in this register. |
| I350
P/L Accounts Balances Before Closing – Date Identification |
Includes the last day of the processed quarter/year. | This register is mandatory. This register contains a single record. |
| I355
P/L Accounts Details Balances Before Closing |
Includes the accumulated Final Account Balance by PL account for the quarter/year indicated in register I350. These amounts are retrieved from F0902 table. | This register is mandatory. This register can include multiple records. |
| I990
Block I Closing |
Includes the total number of lines in the block. | This register must be present in the electronic file.
This register is generated by the Block 9 - Generation program (R76B846). |
The system generates the supported registers for block I when you run the SPED FCont - Block I - General Information program (R76B841). This program identifies the information about the chart of accounts and cost centers that you set up in the Account Master (F0901) and Brazilian Account Information (F76B925) tables. This program populates the registers for I001, I050, I051, I075 and I100.
|
Note: All accounts processed by this UBE must have account group code configured through P76B925 application. Otherwise, the accounts will not be informed on text files. |
The system generates the supported registers for block I when you run the SPED FCont - Block I - Account Balances program (R76B842). This program generates information about the beginning and ending PL balances. It populates the records for registers I150, I155, I350, and I355.
|
Note: Set the processing option for this program before running it from the SPED Job Administrator program. The processing option determines which registers to populate. |
Processing options enable you to specify default processing values.
Specify the register to generate. Values are:
Blank: Periodic Balances (Registers I150/I155). The system filters records by ledger type and generates accumulated positive and negative amounts for the accounts processed.
1: PL accounts Balances (Registers I350/I355). The system generates records for the PL account balances.
The system generates the supported registers for block I when you run the SPED FCont - Block I - Accounting Journal program (R76B843). This program generates information about journal entry batches and the journal entry lines of each batch. It populates the records for registers I200 and I250.
You generate block J registers and records to provide signatories information for the electronic files that you submit for FCont reporting.
The system writes records for block J registers when you run the Block J Signatories program (R76B844) from the FCONT SPED Job Administrator program (P76B940).
The system reads these tables to obtain the data for block J registers:
Account Master (F0901)
Brazilian Address Book (F76011)
Address Number Inscriptions (F76B140)
The system writes the data for block J registers in the following table:
SPED Process (F76B940)
SPED Process Detail (F76B943)
SPED Job Signatories (F76B945)
This table describes the contents of the registers for block J:
| Registers | Description of Contents | Compliance and Occurrence |
|---|---|---|
| J001
Block J Opening |
Includes a hard-coded value to indicate that records exist in the file. | This register must be present in the electronic file.
One record exists in this register. |
| J930
Bookkeeping Signatories identification |
Includes the signatory information for the SPED FCont electronic file. | Multiple registers can exist in the electronic file. |
| J990
Block J Closing |
Includes the total number of lines in the block. | This register must be present in the electronic file.
This register is generated by the Block 9 Generation program (R76B846). |
You generate block M registers and records to provide fiscal register information for the electronic files that you submit for FCont reporting.
The system writes records for block M registers when you run the Block M Fiscal Register program (R76B845) from the FCONT SPED Job Administrator program (P76B940).
The system reads these tables to obtain the data for block M registers:
Account Ledger (F0911)
FCONT Account Balances (F76B837)
The system writes the data for block M registers in the following table:
SPED Process (F76B940)
SPED Process Detail (F76B943)
FCONT Job Account Balances (F76B845)
Job Accounts (F76B955)
This table describes the contents of the registers for block M:
| Registers | Description of Contents | Compliance and Occurrence |
|---|---|---|
| M001
Block M Opening |
Includes a hard-coded value to indicate that records exist in the file. | This register must be present in the electronic file.
One record exists in this register. |
| M020
Juridic person qualification |
Indicates the qualification of Juridic Person (UDC 76B/JQ), to identify who manages the reference chart of accounts (used for registration I051). | This register must be present in the electronic file. |
| M025
Initial balances for recovered equity accounts |
Indicates the fiscal and corporate balances of recovered equity account (Assets, Liabilities and Equity) from immediately preceding period bookkeeping. | This register must be present in the electronic file. |
| M030
Assessment quarter identification |
Includes the calculation periods contained in FCont. | This register must be present in the electronic file. |
| M155
FCont quarter balances detail |
Includes the detail of the FCONT periodic balances from balance sheet accounts. | This register is mandatory. |
| M355
Income accounts detail balances before closing |
Indicates the balance references (corporate and fiscal) of income accounts before closure. | This register is mandatory. |
| M990
Block M Closing |
Includes the total number of lines in the block. | This register must be present in the electronic file.
This register is generated by the Block 9 - Generation program (R76B846). |
The system generates the supported registers for block M when you run the SPED FCont - Block M - Fiscal Register program (R76B845). This program generates information about the FCONT quarter balances detail and recovered adjustments for the SPED FCont file and generates the registers M001, M020, M025, M030, M155, and M355.
You generate block 9 registers and records to provide closing information for the electronic files that you submit for FCont reporting. In addition to the registers in block 9, the Block 9 Generation programs writes the data to the closing registers for blocks I, J, and M.
The system reads these tables to obtain the data for block 9 registers:
FCONT Jobs Accounts Balances (F76B845)
The system writes the data for block 9 registers in the following tables:
Text Processor Header (F007101)
Text Processor Detail (F007111)
FCONT Account Balances (F76B837)
SPED Job Output Detail (F76B943)
SPED Job Batches (F76B944)
SPED Job Signatories (F76B945)
This table describes the contents of the registers for block 9:
| Registers | Description of Contents | Compliance and Occurrence |
|---|---|---|
| 9001
Block 9 Opening |
Includes a hard-coded value to indicate that records exist in the file. | This register is mandatory.
One register exists in the electronic file. |
| 9900
Block 9 File Registers |
Includes information about the total number of records for each type in the flat file. | This register is mandatory.
Multiple registers can exist in the file. |
| 9990
Block 9 Closing |
Includes the total number of lines for block 9. | This register is mandatory.
One register exists in the electronic file. |
| 9999
Flat File Closing |
Includes the total number of lines for the electronic file. | This register is mandatory.
One register exists in the electronic file. |
The system generates the supported registers for block 9 when you run the SPED FCont - Block 9 - Generation program (R76B844). This program identifies the master information that will be used in block 9 and updates the F76B943 table with the UBE name, register type, line sequence and the text of the register type.