E-Journal Report Structure

This following tables list the report header for standard report, company report and company by location and cashier register.

Report <header> Structure

Table -6 Report Header Structure

Element Descriptions

<fiscalYear>

Current year of From Date.

<startDate>

First day in current year of From Date.

<endDate>

Last day in current year of To Date.

<curCode>

Current currency code setup in SPMS.

<dateCreated>

Current database date.

<timeCreated>

Current database time.

<softwareDesc>

Current software to generate E-Journal report.

<softwareVersion>

Current software version.

<softwareCompanyName>

Current company setup in SPMS

<auditfileVersion>

The XML version number to be displayed in E-Journal Report.

<userID>

Login user who generates E-Journal Report.

Report<company>Structure

Table -7 Company Report Header Structure

Element Descriptions

<companyName>

Get from Name under Company Entities Setup in OHC Administration.

<taxRegIdent>

Get from VAT registration number under Company Entities Setup in OHC Administration.

<customersSuppliers>

Customer details. Only customer who exists in the receipt period being selected from user interface.

<vatCodeDetails>

<standardVatCode>

All VAT configuration details are using in SPMS.

Standard VAT Code stated in norwegian-saf-t-standard-vat-codes.pdf. More details in section Standard Predefined Code 99 – Standard VAT Codes.

<periods>

<periodNumber>

Period number of the defined period. Period number is generated by sequence CNT_EJOURNAL_RUNNO from database.

<employees>

Employee who generate the receipt and trigger the event (refer to <event> node). Only employee who exists in the receipts period is selectable from user interface.

<articles>

Department and main department details. Only department and main department that exist in the receipts period is selectable from user interface.

<basics>

Main department ID for credit and debit department, and transaction code. With the mapping standard predefined code. See section Standard Predefined Code 04 — Article Group/Department Codesfor more information.

Report <company><location><cashregister> Structure

<registerID>

Company ID in Company Entities Setup in OHC Administration, combine with my computer name.

<regDesc>

Name in Company Entities Setup in OHC Administration.

<event>

Log record from LOG table. Only records that exist in the date period being selected from user interface.

<cashtransaction>

One <cashtransaction> per one receipt. Only receipts that exist in the receipts period being selected from user interface.

<nr>

Receipt number.

<transID>

Receipt number.

<transType>

Receipt type:

  • SALES

  • RETURN

  • PROFORMA

  • DELIVERY

Refers to section Standard Predefined Code 11 – Transaction Codes

<transAmntIn>

Total receipt amount including VAT tax.

<TransAmntEx>

Total receipt amount excluding VAT tax.

<amntTp>

An increase in revenue (such as sales) is to be marked as C.

While a decrease in revenue (such as returns) is to be marked as D.

<empID>

User who generates receipt.

<custSupID>

Customer account number.

<periodNumber>

Refer to <periods> in above table.

<transDate>

Receipt creation date.

<transTime>

Receipt creation time.

<invoiceID>

Delivery receipt number.

<rounding>

Rounding to 2 decimal places.

<signature>

Digital signature of receipt.

<keyVersion>

The version of the private/secret key.

<voidTransaction>

True = Void transaction

False = No

<vat>

VAT details of all transactions within each receipt.

<payment>

Payment details of receipt.

<ctLine>

All transactions of the receipt. Record is retrieved from POS table.

<nr>

Receipt number. Link to root <nr>.

<lineID>

POS_ID of the POS record.

<lineType>

Transaction type of the POS record.

  • POST

  • SALES

  • REFUND

  • DIS

  • VOID

Refers to section 2.4 Standard Predefined Code 11 – Transaction Codes.

<artGroupID>

Main department ID of the POS record.

<artID>

Department ID of the POS record.

<qnt>

Quantity of the POS record.

<lineAmntIn>

Amount of the POS record including VAT tax.

<lineAmntEx>

Amount of the POS record excluding VAT tax.

<amntTp>

An increase in revenue (such as sales) is to be marked as C.

While a decrease in revenue (such as returns) is to be marked as D.

<empID>

User who process this record.

<lineDate>

POS record creation date.

<lineTime>

POS record creation time.

<vat>

VAT details of the POS record.

<discount>

Discount details of the POS record