Block I Registers for SPED Accounting

The system writes records for block I registers in the electronic file that you send for SPED accounting reporting when you run the programs for block I from the SPED Job Administrator program (P76B940). Block I includes account journal information, such as the chart of accounts and account balances.

The system reads these tables to obtain the data for block I registers:

Address Book Master (F0101)
Address Book Brazilian Tag Table (F76011)
Address Book Inscription- BR (F76B140)
Legal Company - Subsidiaries (F76B015)
Account Master (F0901)
Account Balances (F0902)
Account Ledger (F0911)
Referential Chart of Account - BR (F76B920)
Brazilian Account Information (F76B925)
SPED Job Accounts - BR (F76B955)
Related Accounts (F76B927)
SPED Book Type Definition (F76B935)
SPED Book Type Relation (F76B936)
SPED Book Ledger Types (F76B937)
SPED Job Hash Codes (F76B947)
Ato Cotepe Header Blocks Template (F76B0730)
Ato Cotepe Detail Blocks Template (F76B0731)
SPED Jobs - BR (F76B940)

You run these programs from the SPED Job Administrator program to populate the registers for block I:

Programs	Description
Block I - General Information (R76B954).	This program generates information about books and auxiliary books; and opening terms. It populates the records for registers I001, I010, I012, I015, and I130. The system generates the register for I120, but does not populate the fields.
Block I - Open: Chart of Accounts & Cost Center (R76B955).	This program generates information about the chart of accounts and cost centers that you set up in the Account Master (F0901) and Brazilian Account Information (F76B925) tables. The system uses the values in this register to determine the opening and balance sheet values used in registers in block J. This program populates the registers for I050, I051, I052, and I053. Note: Set the processing options for this program before running it from the SPED Execution program.
Block I - Balances/PL Balances (R76B960).	This program generates information about the beginning and ending PL balances. It populates the records for registers I150, I155, I157, I350, and I355. Note: Set the processing option for this program before running it from the SPED Execution program. The processing option determines which registers to populate.
Block I - Accounting Journal (R76B965).	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.
Block I - Daily Balances (R76B970).	This program generates information about daily balances. It populates the records for registers I300 and I310.
Block I - Auxiliary Ledger - Blank Registers (R76B950).	This program generates the I500, I510, I550, I555 registers, but populates only certain fields with hard-coded values.

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 block.	One only register I001 must exist in the electronic file.
I010 Accounting Bookkeeping Identification	Includes a value from the SPED Book Type Definition table (F76B035) to define the type of book.	One only register I010 must be present in the electronic file.
I012 Daily Auxiliary Books	Includes information about auxiliary books, including the hash code that you obtain from the fiscal authority.	For book types R or B, the system generates one register 012 for each associated auxiliary book. For book types A or Z the system generates one unique register with the parent book ID information. The system does not populate this register for book type G.
I015 Accounts ID from Resumed Bookkeeping Referred to the Auxiliary Bookkeeping	Includes the account ID for the auxiliary books as specified in the Book Type Definition program (P76B935).	Multiple registers I015 can exist for each record in the I012 register. The system populates these records only when the book type in register I010 is R, A, or Z.
I020 Additional Fields	The system does not generate this register.	The system does not generate this register.
I030 Opening Term	Includes company information from the address book tables (F0101, F76011 and F76B140), and book information that you set up in the Book Type Definition program.	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 block I and block J 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.
I052 Agglutination Codes Indicator	Includes the agglutination code for each analytical account, which is the OBJ.SUB of the parent account from the immediate superior level.	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.
I053 Related Accounts	Includes information about the related account that you set in the form Related Accounts Revisions in the Brazil Account Information (P76B925).	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 does not generate this register.	The system does not generate this register.
I100 Costs Center	Includes information about the cost centers for the accounts.	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 month.	This register is mandatory. This register contains a single record.
I151
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.
I157 Chart of Accounts Balance Forwards Amounts	Includes the account code, the cost center code, the balance forward from the previous chart of accounts and whether the balance is debit or credit. This information is not provided by JD Edwards EnterpriseOne and is entered manually.	This register is optional. Multiple records can exist in this register.
I200 Accounting Journal	Includes information about all F0911 batches generated for a date range defined in the job.	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.
I300 Daily Balances – Data Identification	Includes the journal entries from the F0911 table.	This register includes multiple records. The system generates a I300 register for each transaction date found in the F0911 for the reporting month.
I310 Daily Balances Details	Includes daily balance details for the G/L date identified in register I300. The report accumulates amounts for each transaction date and account.	Multiple records can exist in this register.
I350 P/L Accounts Balances Before Closing – Date Identification	Includes the last day of the processed month.	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 month indicated in register I350. These amounts are retrieved from F0902 table.	This register can include multiple records.
I500 Auxiliary General Ledger Book Printing / Visualization Parameters with Configurable Layout	The system generates the register and populates the first field with the value of REG.	This register must be present in the electronic file if the book type is Z. One register is generated for the file.
I510 Auxiliary General Ledger Book Fields Definition with Configurable layout	The system generates the register and populates the first field with the value of REG.	This register must be present in the electronic file if the book type is Z. Multiple registers can exist in the electronic file.
I550 Auxiliary General Ledger Book Details with Configurable Layout	The system generates the register and populates the first field with the value of REG.	This register must be present in the electronic file if the book type is Z. Multiple registers can exist in the electronic file.
I555 Auxiliary General Ledger Totals with configurable Layout	The system generates the register and populates the first field with the value of REG.	This register is optional. Multiple registers can exist in the electronic file.
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 (R76B995).