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:
|
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:
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:
|
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:
|
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:
|
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:
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:
|
I990 |
1 |
REG |
Fixed value of I990. |
I990 |
2 |
QTD_LIN_I |
Total lines in Block I. |