1. Localizations for Brazil Implementation Guide
  2. Registers and Fields for Block I

Registers and Fields for Block I

Block I gives the information about accounting journals, which includes bookkeeping, auxiliary books, accounts specific data, periodic and daily balances, and accounting journals of the company. Registers in the block are:

  • Register I001: Block I opening.

  • Register I050: Chart of accounts.

  • Register I051: Referential chart of accounts.

    Only analytical accounts appear in this register.

  • Register I075: Standard historic table.

    The system does not generate this register.

  • Register I100: Cost centers.

  • Register I150: Periodic balances - Periodic identification.

  • Register I155: Periodic balances details.

  • Register I200: Accounting journal.

  • Register I250: Journal entry lines.

  • Register I350: P/L accounts balance before closing - Date identification.

  • Register I355: P/L accounts details before closing.

  • Register I990: Block I closing.

This table describes the fields in each register of Block I:

Register Number

Field Number

Field Name

Description

I001

1

REG

Fixed value of I001.

I001

2

IND_DAD

Movement indicator. Values are:

  • 0: Block with data reported.

  • 1: Block without data reported.

I050

1

REG

Fixed value of I050.

I050

2

DT_ALT

The inclusion or change date from F0901.UPMJ. If the value for UPMJ is greater than the first period reported, the system overwrites it with the first day of the range date entered by the user in the extraction program (P76B940).

I050

3

COD_NAT

Account group code assigned to the account in the P76B925 program. The account group code can be 01, 02, 03, 04, 05, or 09 (validated against UDC (76B/GA).

I050

4

IND_CTA

Account type indicator. Values are:

  • S: Resumed (Sintetica) (accounts group).

  • A: Analytic (account).

If the posting edit code for the account is N, then the system populates the value S. Otherwise, A is populated.

I050

5

NÍVEL

Account level from F0901.GMLDA.

I050

6

COD_CTA

The MCU.OBJ.SUB (GL account) for each reported account.

I050

7

COD_CTA_SUP

The parent account for the accounts in field 6.

I050

8

CTA

Account name from F0901 DL01.

I051

1

REG

Fixed value of I051.

I051

2

COD_ENT _REF

The code from UDC 76B/RA that identifies the entity responsible for the referential chart of accounts.

I051

3

COD_CCUS

Cost center code from F0901 MCU.

I051

4

COD_CTA_REF

The referential account code that you associated to a GL account number in the P76B926 program.

I100

1

REG

Fixed value of I100.

I100

2

DT_ALT

The inclusion or change date from F0006.UPMJ. If UPMJ is greater than the first period reported, it will be overridden with the first day of the range date entered by the user in the extraction program P76B940.

I100

3

COD_CCUS

Account cost center code from F0911.MCU.

I100

4

CCUS

Costs center name from F0006.DLO1.

I150

1

REG

Fixed value of I150.

I150

2

DT_INI

The first calendar day of the quarter/year being processed, as entered in the P76B940 program.

I150

3

DT_FIN

The last calendar day of the quarter/year being processed, as entered in the P76B940 program.

I155

1

REG

Fixed value of I155.

I155

2

COD_CTA

Analytic account code from MCU.OBJ.SUB.

I155

3

COD_CCUS

Account cost center code.

I155

4

VL_SLD_INI

Beginning periodic balance value calculated from the balances in the F0902 table.

If several lines of the File are considered, the amounts will be summed. Amounts will always be positive.

I155

5

IND_DC_INI

Beginning balance status indicator. Values are:

  • D: Debtor. Amount in the VL_SLD_INI field is positive.

  • C: Creditor. Amount in the VL_SLD_INI field is negative.

I155

6

VL_DEB

Periodic debit total value from F0911.GLAA. It is the sum of all positive transactions impacting the account noted in item analytic account code of this register.

I155

7

VL_CRED

Periodic credit total value from F0911.GLAA. It is the sum of all negative transactions impacting the amount noted in item analytic account code of this register.

If no balances exist, the system populates this field with zeros.

I155

8

VL_SLD_FIN

Balance amount for the period.

If no balances exist, the system populates this field with zeros.

I155

9

IND_DC_FIN

Final balance status indicator. Values are:

  • D: Debtor.

  • C: Creditor.

I200

1

REG

Fixed value of I200.

I200

2

NUM_LCTO

Concatenates the batch number, batch type, GL date, document type and number from the F0911 table.

I200

3

DT_LCTO

Indicates the G/L date, from the F0911 table.

I200

4

VL_LCTO

The sum of all positive amounts of the journal entries for the batch and G/L date.

I200

5

IND_LCTO

Journal type indicator from F76B835.B76FCAO (values from UDC 76B/FA). Values are:

  • EF: Fiscal Close Journal Entries

  • F: Regarded Journal Entries

  • IF: Adjustment Journal Entry (Beginning Balance Fiscal)

  • IS: Adjustment Journal Entry (Beginning Balance Corporate)

  • TF: Fiscal Balance Transfer

  • TR: Difference Transfer Journals

  • TS: Corporate Balance Transfer

  • X: Disregarded Journal Entries

I250

1

REG

Fixed value of I250.

I250

2

COD_CTA

Analytic account code from MCU.OBJ.SUB.

I250

3

COD_CCUS

Account cost center code from F0911.MCU.

I250

4

VL_DC

Total amount for the account. It is the sum of all amounts for the account included in the document type and number, which is entered in NUM_ARQ.

I250

5

IND_DC

Journal entry line nature. Values are:

  • D: Debtor.

  • C: Creditor.

If the amount resulted to populate amount in Journal entry Line Amount (item 4) is negative then the value will be C else, D.

I250

6

NUM_ARQ

Document number and document type from the F0911 table.

I250

7

COD_HIST_PAD

Standard historic code.

The system does not populate this field.

I250

8

HIST

Journal entry description from F0911.GLEXA.

I250

9

COD_PART

Participant company number for the journal entry line from F0911. Applicable only if the account is related to a participant company.

I350

1

REG

Fixed value of I350

I350

2

DT_RES

Date of P/L assessment. Last day of the processed quarter/year. Format is DDMMYYYY.

I355

1

REG

Fixed value of I355.

I355

2

COD_CTA

P/L analytical account code from MCU.OBJ.SUB.

I355

3

COD_CCUS

Account cost center code (MCU).

I355

4

VL_CTA

Ending balance amount before the closing accounting journal.

I355

5

IND_DC

Ending balance status indicator. Values are:

  • D: Debtor.

  • C: Creditor.

I990

1

REG

Fixed value of I990.

I990

2

QTD_LIN_I

Total lines in Block I.