Version

Version of the format project; maintained by the format author

Initial value is 1.0; can have two digits for the minor version, such as 1.11

Module

Module in SAP Business One

Only available for GEP formats

Sales Opportunity

Sales

Purchasing

Business Partner

Banking

Inventory

MRP

Service

HR

Menu Name

Format name appearing in the menu

Only available for GEP formats

EU Sales Report

Author

Person or organization that created the format project

SAP

Compatible Version

Version of SAP Business One that supports the format

Choose the Browse button and specify the supported versions, one version per line.

8.81.300; 8.81.302

Last Changed By

Person or organization that last changed the format project

SAP

Last Changed On

Date on which the format project was last changed

6/11/2010 3:19 PM

Menu Path

Menu path of the format that is imported into SAP Business One

Only available for GEP formats

Financials/Financial Reports/Electronic Report/EU Sales Report

Show Welcome Step

Enable the welcome step of the EFM wizard in SAP Business One to be displayed

Only available for GEP formats

True

Name

Name of the format

EU Sales

Description

Description of the format

The report lists the goods and services sold by a company to customers in European Union countries, grouped by the country and tax ID of the customers.

Type

Type of the format

Generic Electronic File Format Project

Localization

Localization for the format is

United Kingdom

File Path

File path of the format

D:\Documents and Settings\All Users\My Documents\EU_Sales.gep

Name

Name of the mapping

Description

Description or purpose of the mapping

Script Type

Two types of script are allowed:

Functions

Click the ellipsis button in the field to write functions in the user script editor.

Syntax for calling a function defined in the user script: user:<Function Name>(<Parameter 1>, <Parameter 2>...)

Is System

Indicates whether the structure was generated by the tool (true)

True

Document Version

Version of the .rpt file in the format

1.1

Name

Name of the document

EU Sales Report

Type

Type of the document

RPT

Preview

Indicates whether users are allowed to preview the .rpt file in SAP Business One

True

Encoding

Encoding of the output file

UTF-8; iso-8859-1; gb2312

Fixed Line Length

Fixed length of line

0

Line Break

Element or character that forces a break in the line of a file

True

Name of the Output File

Name of the output file generated at runtime

de-eusales-1.0.xml

Always Generated

Indicates whether to generate output file in all the cases including when validation error occurs

False

Name

Name of the document

EU Sales Report

Description

Description of the document

Type

Type of the document

CSV (Comma delimited)

Is System

Indicates whether the structure was generated by the tool

True

Default Separator

Field separator

Tab, comma, space, semicolon

Default Escape Char.

Character preserves the literal meaning of a character used as either separator or enclosed character

“ (double quote), ‘ (single quote)

Target Namespace

Target namespace of the XML document

Empty string indicates the default name space.

Type

Node type

Field

Reference No.

Reference code or alias of the node. Use the reference code or alias to refer to the node in the function or the condition of another node.

LawsSet

Name

Name of the node

LawsSet

Description

Description of the node

Original Formatted Value

Original value formatted according to the format template in the .rpt file

IT

Original Value

Original value from the data source

IT

Further Information

Additional data about the Crystal Reports field node; for example, field information from the database

CINF.LawsSet

Formula Name

Formula from the.rpt file

{CINF.LawsSet}

Use Original Formatted Value

Indicates whether to use the original formatted value in the target document

False

Section Header

Indicates whether to output the section header to the format

Escape Character

The character preserves the literal meaning of a character used as either separator or enclosed character

a,b,”,”/a,b,’,’

“a””b”

“a’’b”

Separator

Field separator

Tab, comma, space, semicolon

Default value

Default value of the node that can accept value

Type

Node type

Reference No.

Reference code or alias of the node. Use the reference code or alias to refer to the node in the function or to the condition of another node.

Name

Name of the node

Description

Description of the node

Type

Node type

Element

Reference No.

Reference code or alias of the node. Use the reference code or alias to refer to the node in the function or to the condition of another node.

StrtNm4

Name

Name of the node

StrtNm

Description

Description of the node

Optional

Indicates whether the XML attribute node can be omitted in the document

True

Prefix

Declared prefix of the namespace to which this node belongs

XML Name

XML tag name in the XML document

StrtNm

XML Namespace

Namespace under which the XML node is defined

urn:iso:std:iso:20022:tech:xsd:pain.001.001.02

Default Value

Default value of the node that can accept value

Allow Null

Indicates whether the XML element can accept “null”. If you select “True” and the runtime value is null, the output is <element1 xsi:nil="true" />

True

Type

Node type

Reference No.

Reference code or alias of the node. Use the reference code or alias to refer to the node in the function or to the condition of another node.

Name

Name of the node

Description

Description of the node

Padding Character

Specify the character to be used to fill empty spaces of a field when its text is shorter than required length.

Space, Zero (0)

Length

Length of the field, including padding characters. To indicate indefinite length, specify a negative number.

8

Text Alignment

Indicates how text is aligned in the field

Left

Offset

Starting position of the field

1

Default Value

Default value of the node that can accept values

Include Line Break

Indicates whether to automatically include the line break at the end of the text

True

Description

Description of the connection