Data Types

About Data Types

Data Type reference table

About Data Types

Data Type is a property of Business-Document fields. The Data Type describes the physical structure of the data that these fields can contain. Each Data Type belongs to a Data Class and inherits the characteristics of that Data Class. In a Business-Document, the Data Class / Data Type combination that you assign to a field determines how to read/write the data in the field.

To read and write the values of data contained in fields, AccountingIntegrator Enabler must know how the data is physically structured. You define this level of detail via the Data Type property.

Data Types depend in turn on the Data Class - one of the properties of fields that generally describes what kind of data can be stored in them: for example, Integer or Date.

When AccountingIntegrator Rule Engine processes Mapping Rules, it applies the Data Type to make sure that the data contained in the source field is compatiblewith the expected value in the target field. If the source field contains inappropriate data, AccountingIntegrator Rule Engine rejects the associated Input-Event (whose structure is defined by this Business-Document). For example, if the Data Class is set to Numeric, and the segment field contains alphabetic characters, AccountingIntegrator Enabler rejects the associated Input-Event.

However, the Data Class only describes data generally. It does not describe the physical structure of data. For example, the Data Class Date indicates that data should be expressed using a date. However, by itself, the Data Class does not indicate which date format should be applied to the data. That type of information is specified via the Data Type.

Data Type Compatibility

During mapping, the Data Type used in the target field must be compatible with the Data Type used in the source field. During processing, AccountingIntegrator Rule Engine checks for Data Type compatibility in all language expressions. The Mapping Rule expression must produce the required Data Type in the target field.

Data Types are summarized in the following table:

Target field Data Type Source field Data Type

D (Date)

D, N (compatible length: six, seven or eight digits)

N (Numeric extended)

N, P, S

S (Signed numeric)

N, P, S

P (Packed numeric)

N, P, S

A (Alphanumeric)

Data Types: D, N, S, P, A

DN (Decimal Number) DN (compatible lengths and types : packed, signed, numeric), N, S, P

Data Type reference table

The possible Data Types depend on the Data Class. Each Data Type is also associated with a maximum value specified in the Business-Field Definition tab. The following table summarizes the possible values you can use in AccountingIntegrator Enabler.

Data Class Data Type Definition Field

Date

date [YYYYMMDD]

8 (indicates YYYYMMDD format)

date [YYMMDD]

6 (indicates YYMMDD format)

date [CYYMMDD]

7 (indicates CYYMMDD format)

Integer

signed [+/-9 999] (p)

28

Physical length and the extended length are both 28

numeric [9 999] (p)

28

Physical length and the extended length are both 28

packed [9 999+/-] (p)

28

Physical length is 15, that is (28/2+1) and the extended length is 28

String

alphanumeric (lg)

256

Decimal

DN signed

[+/-9 999.99]

28

Physical length and the extended length are both 28

DN numeric

[9 999.9999]

28

Physical length and the extended length are both 28

DN packed

[9 999.999 +/-]

28

Physical length is 15, that is (28/2+1) and the extended length is 28

Back to top

Related Links