Accounting Books XML File

The XML file includes header and legal entity sections, and sections that are specific to accounting books.

Note: See Information in the XML File Common to the Five Accounting Sections for information on the header and legal entity sections.

These sections are specific to accounting books.

1. ZOiS: This section includes information on the accounts used in the general ledger transactions that are eligible for processing. For each account, the system includes a ZOiS section. The account information included in this section are:

   • Account number and description

   • Account type

   • Account category (the group that the account is included in) and description of the account category

   • Group category code and description of the group category

   • Debit balance (positive amount) at the start date of the reporting period

   • Credit balance (negative amount) at the start date of the reporting period

   • Difference between the closing debit balance and opening debit balance (turnover debit amount)

   • Year-To-Date debit balance as of the reporting end date

   • Difference between the closing credit balance and opening credit balance (turnover credit amount)

   • Year-To-Date credit balance as of the reporting end date

   • Net debit balance for the reporting period

   • Net credit balance for the reporting period

2. Dziennik: Each posted transaction (document) in the Account Ledger table (F0911) has a Dziennik section in the XML file. The transaction details included in this section are:

   • Sequence number

   • Concatenation of batch type, batch number, document type, and document number

   • Journal entry description

   • Subledger document number and document type

     This is the document number and document type of the transaction (for example, accounts receivable and accounts payable transaction) that resulted in the journal entry.

   • Actual transaction date (for example, sales date or purchase date)

   • Journal entry creation and posting date

   • User identification of the person who created the subleger transaction

   • Transaction description

   • Total amount in the journal entry

3. DziennikCtrl: This section includes the following:

   • Total number of transactions (documents) in the reporting period

   • Sum of the transaction amount of all the documents in the reporting period

4. KontoZapis: For each transaction detail line (document line) in the Account Ledger table (F0911), the system prints a KontoZapis section in the XML file. The document line information included in this section are:

   • Sequence number

   • Concatenation of batch type, batch number, document type, and document number

   • Debit account number

   • Debit amount

   • Credit account number

   • Credit amount

5. KontoZapisCtrl: This section includes the following:

   • Total number of document lines for all the documents in the reporting period

   • Sum of the debit amounts of all the document lines in the reporting period

   • Sum of the credit amounts of all the document lines in the reporting period