BatchRecord Datasource

The Batch Record datasource object can be configured to provide an interface to connect to external repositories by choosing the Batch Record server type at creation.

The Batch Record allows you to retrieve and work with batch records form various source systems such as AspenTech APRM/Batch.21 and OSIsoft’s PI-Batch. Retrieved Batch Production Records are stored in inmation’s Production Tracking Data Store.

Use Cases

Monitor the state of active batches and extend existing batch records by adding additional information.
Convert legacy batch production records into ISA-88 compliant batch records.

Quick Configuration

Datasource object can created in the I/O Model under a Connector.

Select a Connector object and right-click. Select Admin New External Interfaces Datasource.
Enter an Object Name in the Create Datasource Item wizard click Next.
In the Server Type select Batch Record, enter the BatchRecord Name and click Create.

The Server type cannot be changed after creation.

For a demonstration of how to configure the Batch Record Datasource and more information on it’s functionality please visit the following pages:

For information on how to install and use the PI-Bridge service, please visit:

Installation of PIBridge service

Object Properties

BatchRecord Name: The name of the batch record data source, in case the user did not enter an object name.

Interface

Selection of the batch interface.

ODBC Connection

ODBC connection parameters for batch records.

Datasource Name: The name of the ODBC datasource, which can be a DSN or a valid ODBC connection string (example: "driver={SQL Server Native Client 11.0}; server=someserver;uid=someuser;pwd=somepassword;"). The parameters of the connection string are defined by the used driver, which is identified by the DRIVER parameter. More information can be found here https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqldriverconnect-function and https://www.connectionstrings.com.

User Name: The user name of the ODBC Datasource (optional).

Password: The password of the ODBC Datasource (optional).

UTF-8 Conversion: Switch the UTF-8 Conversion on, if the database returns ASCII.

Code Page

00000 Current Code Page: Current Code Page.
00037 IBM EBCDIC US-Canada: IBM EBCDIC US-Canada.
00437 OEM United States: OEM United States.
00500 IBM EBCDIC International: IBM EBCDIC International.
00708 Arabic (ASMO 708): Arabic (ASMO 708).
00709 Arabic (ASMO-449+, BCON V4): Arabic (ASMO-449+, BCON V4).
00710 Arabic - Transparent Arabic: Arabic - Transparent Arabic.
00720 Arabic (Transparent ASMO); Arabic (DOS): Arabic (Transparent ASMO); Arabic (DOS).
00737 OEM Greek (formerly 437G); Greek (DOS): OEM Greek (formerly 437G); Greek (DOS).
00775 OEM Baltic; Baltic (DOS): OEM Baltic; Baltic (DOS).
00850 OEM Multilingual Latin 1; Western European (DOS): OEM Multilingual Latin 1; Western European (DOS).
00852 OEM Latin 2; Central European (DOS): OEM Latin 2; Central European (DOS).
00855 OEM Cyrillic (primarily Russian): OEM Cyrillic (primarily Russian).
00857 OEM Turkish; Turkish (DOS): OEM Turkish; Turkish (DOS).
00858 OEM Multilingual Latin 1 + Euro symbol: OEM Multilingual Latin 1 + Euro symbol.
00860 OEM Portuguese; Portuguese (DOS): OEM Portuguese; Portuguese (DOS).
00861 OEM Icelandic; Icelandic (DOS): OEM Icelandic; Icelandic (DOS).
00862 OEM Hebrew; Hebrew (DOS): OEM Hebrew; Hebrew (DOS).
00863 OEM French Canadian; French Canadian (DOS): OEM French Canadian; French Canadian (DOS).
00864 OEM Arabic; Arabic (864): OEM Arabic; Arabic (864).
00865 OEM Nordic; Nordic (DOS): OEM Nordic; Nordic (DOS).
00866 OEM Russian; Cyrillic (DOS): OEM Russian; Cyrillic (DOS).
00869 OEM Modern Greek; Greek, Modern (DOS): OEM Modern Greek; Greek, Modern (DOS).
00870 IBM EBCDIC Multilingual/ROECE (Latin 2); IBM EBCDIC Multilingual Latin 2: IBM EBCDIC Multilingual/ROECE (Latin 2); IBM EBCDIC Multilingual Latin 2.
00874 ANSI/OEM Thai (ISO 8859-11); Thai (Windows): ANSI/OEM Thai (ISO 8859-11); Thai (Windows).
00875 IBM EBCDIC Greek Modern: IBM EBCDIC Greek Modern.
00932 ANSI/OEM Japanese; Japanese (Shift-JIS): ANSI/OEM Japanese; Japanese (Shift-JIS).
00936 ANSI/OEM Simplified Chinese (PRC, Singapore); Chinese Simplified (GB2312): ANSI/OEM Simplified Chinese (PRC, Singapore); Chinese Simplified (GB2312).
00949 ANSI/OEM Korean (Unified Hangul Code): ANSI/OEM Korean (Unified Hangul Code).
00950 ANSI/OEM Traditional Chinese (Taiwan; Hong Kong SAR, PRC); Chinese Traditional (Big5): ANSI/OEM Traditional Chinese (Taiwan; Hong Kong SAR, PRC); Chinese Traditional (Big5).
01026 IBM EBCDIC Turkish (Latin 5): IBM EBCDIC Turkish (Latin 5).
01047 IBM EBCDIC Latin 1/Open System: IBM EBCDIC Latin 1/Open System.
01140 IBM EBCDIC US-Canada (037 + Euro symbol); IBM EBCDIC (US-Canada-Euro): IBM EBCDIC US-Canada (037 + Euro symbol); IBM EBCDIC (US-Canada-Euro).
01141 IBM EBCDIC Germany (20273 + Euro symbol); IBM EBCDIC (Germany-Euro): IBM EBCDIC Germany (20273 + Euro symbol); IBM EBCDIC (Germany-Euro).
01142 IBM EBCDIC Denmark-Norway (20277 + Euro symbol); IBM EBCDIC (Denmark-Norway-Euro): IBM EBCDIC Denmark-Norway (20277 + Euro symbol); IBM EBCDIC (Denmark-Norway-Euro).
01143 IBM EBCDIC Finland-Sweden (20278 + Euro symbol); IBM EBCDIC (Finland-Sweden-Euro): IBM EBCDIC Finland-Sweden (20278 + Euro symbol); IBM EBCDIC (Finland-Sweden-Euro).
01144 IBM EBCDIC Italy (20280 + Euro symbol); IBM EBCDIC (Italy-Euro): IBM EBCDIC Italy (20280 + Euro symbol); IBM EBCDIC (Italy-Euro).
01145 IBM EBCDIC Latin America-Spain (20284 + Euro symbol); IBM EBCDIC (Spain-Euro): IBM EBCDIC Latin America-Spain (20284 + Euro symbol); IBM EBCDIC (Spain-Euro).
01146 IBM EBCDIC United Kingdom (20285 + Euro symbol); IBM EBCDIC (UK-Euro): IBM EBCDIC United Kingdom (20285 + Euro symbol); IBM EBCDIC (UK-Euro).
01147 IBM EBCDIC France (20297 + Euro symbol); IBM EBCDIC (France-Euro): IBM EBCDIC France (20297 + Euro symbol); IBM EBCDIC (France-Euro).
01148 IBM EBCDIC International (500 + Euro symbol); IBM EBCDIC (International-Euro): IBM EBCDIC International (500 + Euro symbol); IBM EBCDIC (International-Euro).
01149 IBM EBCDIC Icelandic (20871 + Euro symbol); IBM EBCDIC (Icelandic-Euro): IBM EBCDIC Icelandic (20871 + Euro symbol); IBM EBCDIC (Icelandic-Euro).
01200 Unicode UTF-16, little endian byte order (BMP of ISO 10646); available only to managed applications: Unicode UTF-16, little endian byte order (BMP of ISO 10646); available only to managed applications.
01201 Unicode UTF-16, big endian byte order; available only to managed applications: Unicode UTF-16, big endian byte order; available only to managed applications.
01250 ANSI Central European; Central European (Windows): ANSI Central European; Central European (Windows).
01251 ANSI Cyrillic; Cyrillic (Windows): ANSI Cyrillic; Cyrillic (Windows).
01252 ANSI Latin 1; Western European (Windows): ANSI Latin 1; Western European (Windows).
01253 ANSI Greek; Greek (Windows): ANSI Greek; Greek (Windows).
01254 ANSI Turkish; Turkish (Windows): ANSI Turkish; Turkish (Windows).
01255 ANSI Hebrew; Hebrew (Windows): ANSI Hebrew; Hebrew (Windows).
01256 ANSI Arabic; Arabic (Windows): ANSI Arabic; Arabic (Windows).
01257 ANSI Baltic; Baltic (Windows): ANSI Baltic; Baltic (Windows).
01258 ANSI/OEM Vietnamese; Vietnamese (Windows): ANSI/OEM Vietnamese; Vietnamese (Windows).
01361 Korean (Johab): Korean (Johab).
10000 MAC Roman; Western European (Mac): MAC Roman; Western European (Mac).
10001 Japanese (Mac): Japanese (Mac).
10002 MAC Traditional Chinese (Big5); Chinese Traditional (Mac): MAC Traditional Chinese (Big5); Chinese Traditional (Mac).
10003 Korean (Mac): Korean (Mac).
10004 Arabic (Mac): Arabic (Mac).
10005 Hebrew (Mac): Hebrew (Mac).
10006 Greek (Mac): Greek (Mac).
10007 Cyrillic (Mac): Cyrillic (Mac).
10008 MAC Simplified Chinese (GB 2312); Chinese Simplified (Mac): MAC Simplified Chinese (GB 2312); Chinese Simplified (Mac).
10010 Romanian (Mac): Romanian (Mac).
10017 Ukrainian (Mac): Ukrainian (Mac).
10021 Thai (Mac): Thai (Mac).
10029 MAC Latin 2; Central European (Mac): MAC Latin 2; Central European (Mac).
10079 Icelandic (Mac): Icelandic (Mac).
10081 Turkish (Mac): Turkish (Mac).
10082 Croatian (Mac): Croatian (Mac).
12000 Unicode UTF-32, little endian byte order; available only to managed applications: Unicode UTF-32, little endian byte order; available only to managed applications.
12001 Unicode UTF-32, big endian byte order; available only to managed applications: Unicode UTF-32, big endian byte order; available only to managed applications.
20000 CNS Taiwan; Chinese Traditional (CNS): CNS Taiwan; Chinese Traditional (CNS).
20001 TCA Taiwan: TCA Taiwan.
20002 Eten Taiwan; Chinese Traditional (Eten): Eten Taiwan; Chinese Traditional (Eten).
20003 IBM5550 Taiwan: IBM5550 Taiwan.
20004 TeleText Taiwan: TeleText Taiwan.
20005 Wang Taiwan: Wang Taiwan.
20105 IA5 (IRV International Alphabet No. 5, 7-bit); Western European (IA5): IA5 (IRV International Alphabet No. 5, 7-bit); Western European (IA5).
20106 IA5 German (7-bit): IA5 German (7-bit).
20107 IA5 Swedish (7-bit): IA5 Swedish (7-bit).
20108 IA5 Norwegian (7-bit): IA5 Norwegian (7-bit).
20127 US-ASCII (7-bit): US-ASCII (7-bit).
20261 T.61: T.61.
20269 ISO 6937 Non-Spacing Accent: ISO 6937 Non-Spacing Accent.
20273 IBM EBCDIC Germany: IBM EBCDIC Germany.
20277 IBM EBCDIC Denmark-Norway: IBM EBCDIC Denmark-Norway.
20278 IBM EBCDIC Finland-Sweden: IBM EBCDIC Finland-Sweden.
20280 IBM EBCDIC Italy: IBM EBCDIC Italy.
20284 IBM EBCDIC Latin America-Spain: IBM EBCDIC Latin America-Spain.
20285 IBM EBCDIC United Kingdom: IBM EBCDIC United Kingdom.
20290 IBM EBCDIC Japanese Katakana Extended: IBM EBCDIC Japanese Katakana Extended.
20297 IBM EBCDIC France: IBM EBCDIC France.
20420 IBM EBCDIC Arabic: IBM EBCDIC Arabic.
20423 IBM EBCDIC Greek: IBM EBCDIC Greek.
20424 IBM EBCDIC Hebrew: IBM EBCDIC Hebrew.
20833 IBM EBCDIC Korean Extended: IBM EBCDIC Korean Extended.
20838 IBM EBCDIC Thai: IBM EBCDIC Thai.
20866 Russian (KOI8-R); Cyrillic (KOI8-R): Russian (KOI8-R); Cyrillic (KOI8-R).
20871 IBM EBCDIC Icelandic: IBM EBCDIC Icelandic.
20880 IBM EBCDIC Cyrillic Russian: IBM EBCDIC Cyrillic Russian.
20905 IBM EBCDIC Turkish: IBM EBCDIC Turkish.
20924 IBM EBCDIC Latin 1/Open System (1047 + Euro symbol): IBM EBCDIC Latin 1/Open System (1047 + Euro symbol).
20932 Japanese (JIS 0208-1990 and 0212-1990): Japanese (JIS 0208-1990 and 0212-1990).
20936 Simplified Chinese (GB2312); Chinese Simplified (GB2312-80): Simplified Chinese (GB2312); Chinese Simplified (GB2312-80).
20949 Korean Wansung: Korean Wansung.
21025 IBM EBCDIC Cyrillic Serbian-Bulgarian: IBM EBCDIC Cyrillic Serbian-Bulgarian.
21866 Ukrainian (KOI8-U); Cyrillic (KOI8-U): Ukrainian (KOI8-U); Cyrillic (KOI8-U).
28591 ISO 8859-1 Latin 1; Western European (ISO): ISO 8859-1 Latin 1; Western European (ISO).
28592 ISO 8859-2 Central European; Central European (ISO): ISO 8859-2 Central European; Central European (ISO).
28593 ISO 8859-3 Latin 3: ISO 8859-3 Latin 3.
28594 ISO 8859-4 Baltic: ISO 8859-4 Baltic.
28595 ISO 8859-5 Cyrillic: ISO 8859-5 Cyrillic.
28596 ISO 8859-6 Arabic: ISO 8859-6 Arabic.
28597 ISO 8859-7 Greek: ISO 8859-7 Greek.
28598 ISO 8859-8 Hebrew; Hebrew (ISO-Visual): ISO 8859-8 Hebrew; Hebrew (ISO-Visual).
28599 ISO 8859-9 Turkish: ISO 8859-9 Turkish.
28603 ISO 8859-13 Estonian: ISO 8859-13 Estonian.
28605 ISO 8859-15 Latin 9: ISO 8859-15 Latin 9.
29001 Europa 3: Europa 3.
38598 ISO 8859-8 Hebrew; Hebrew (ISO-Logical): ISO 8859-8 Hebrew; Hebrew (ISO-Logical).
50220 ISO 2022 Japanese with no halfwidth Katakana; Japanese (JIS): ISO 2022 Japanese with no halfwidth Katakana; Japanese (JIS).
50221 ISO 2022 Japanese with halfwidth Katakana; Japanese (JIS-Allow 1 byte Kana): ISO 2022 Japanese with halfwidth Katakana; Japanese (JIS-Allow 1 byte Kana).
50222 ISO 2022 Japanese JIS X 0201-1989; Japanese (JIS-Allow 1 byte Kana - SO/SI): ISO 2022 Japanese JIS X 0201-1989; Japanese (JIS-Allow 1 byte Kana - SO/SI).
50225 ISO 2022 Korean: ISO 2022 Korean.
50227 ISO 2022 Simplified Chinese; Chinese Simplified (ISO 2022): ISO 2022 Simplified Chinese; Chinese Simplified (ISO 2022).
50229 ISO 2022 Traditional Chinese: ISO 2022 Traditional Chinese.
50930 EBCDIC Japanese (Katakana) Extended: EBCDIC Japanese (Katakana) Extended.
50931 EBCDIC US-Canada and Japanese: EBCDIC US-Canada and Japanese.
50933 EBCDIC Korean Extended and Korean: EBCDIC Korean Extended and Korean.
50935 EBCDIC Simplified Chinese Extended and Simplified Chinese: EBCDIC Simplified Chinese Extended and Simplified Chinese.
50936 EBCDIC Simplified Chinese: EBCDIC Simplified Chinese.
50937 EBCDIC US-Canada and Traditional Chinese: EBCDIC US-Canada and Traditional Chinese.
50939 EBCDIC Japanese (Latin) Extended and Japanese: EBCDIC Japanese (Latin) Extended and Japanese.
51932 EUC Japanese: EUC Japanese.
51936 EUC Simplified Chinese; Chinese Simplified (EUC): EUC Simplified Chinese; Chinese Simplified (EUC).
51949 EUC Korean: EUC Korean.
51950 EUC Traditional Chinese: EUC Traditional Chinese.
52936 HZ-GB2312 Simplified Chinese; Chinese Simplified (HZ): HZ-GB2312 Simplified Chinese; Chinese Simplified (HZ).
54936 Windows XP and later: GB18030 Simplified Chinese (4 byte); Chinese Simplified (GB18030): Windows XP and later: GB18030 Simplified Chinese (4 byte); Chinese Simplified (GB18030).
57002 ISCII Devanagari: ISCII Devanagari.
57003 ISCII Bangla: ISCII Bangla.
57004 ISCII Tamil: ISCII Tamil.
57005 ISCII Telugu: ISCII Telugu.
57006 ISCII Assamese: ISCII Assamese.
57007 ISCII Odia: ISCII Odia.
57008 ISCII Kannada: ISCII Kannada.
57009 ISCII Malayalam: ISCII Malayalam.
57010 ISCII Gujarati: ISCII Gujarati.
57011 ISCII Punjabi: ISCII Punjabi.
65000 Unicode (UTF-7): Unicode (UTF-7).
65001 Unicode (UTF-8): Unicode (UTF-8).

Batch Data Source: The name of the batch data source as it is defined in AspenTech’s APRM configuration.

Batch Area: The name of the batch area as it is defined in AspenTech’s APRM configuration.

Completion Code: The code taken from 'PM_STATUS' of the APRM Batch Record, which indicates the final stage of completion. The default value is 20. Please note: in case a different code shall set the unit batch complete, in the Field Configuration a Header Filed Option has to be configured which maps the Source Field 'PM_STATUS' to the target field 'Batch Status' with direct field processing.

Max. Count: The maximum number of batches which are fetched from APRM in a single call.

PI Connection

Compound for PI connection parameters.

Host Name or IP: The hostname or IP address of the PI-Bridge.

Port: The port number of the PI-Bridge.

Username: Username for PI connection.

Password: Password for PI connection.

Timeout: Value in seconds for the communication timeout. After this time the communication to the remote component is considered to be unavailable and the connection will be terminated. Re-connection will be attempted periodically.

Debug: Switch the debug mode on.

Batch Data Interface

PI-Batch SDK: Batch Data will be acquired from a PI Server using the PI-Batch SDK.
PI-AF Event Frames: Batch Data will be acquired from a PI Server using an asset framework server and event frames (the AF server must be properly configured in case this option is used).

PI-Server: Name of the PI server.

PI-AF-Server: The name of the PI-AF-Server which will be used for the connection. If set this setting overwrites the PI-Server setting above, enforces the PI-AF SDK to be used for the calls.

PI-AF-Database: The name of the PI-AF-Database which will be used if the PI-AF-Server is specified.

Suppress Snapshot: Suppresses the last value in timeseries fetched near-time.

Diagnostics

Compound for PI-Bridge Diagnostics.

Bridge Connected: The date and time the PI-Bridge was recently connected.

Bridge Open Since: The duration the PI-Bridge is open.

Bridge Version: The version number of the PI-Bridge being used.

Bridge Service: The service name of the PI-Bridge being used.

Bridge Display Name: The service display name of the PI-Bridge being used.

Library Version: The PI-Bridge Lua library version being used.

.Net Version: The .NET version determined on the host computer.

PI-SDK Version: The determined PI-SDK Version.

PI Server Names: The resolved PI Server Names.

PI-AF-SDK Version: The determined PI-AF-SDK Version.

External Tags: The batch data record is compiled of item values read from an external OPC data source.

Unit Configuration

Compound for the unit configuration for batch records.

Unit Options

Array for batch unit configuration.

Source Unit: The unit identifier which is used in the source system.

Unit Asset Code: If the unit asset code is configured the batch data for this unit will be transferred to Asset Effectiveness.

Unit Description: The human readable description for this unit.

ISA-95 Target Object: Select the ISA-95 object, which is assigned to the Unit Batch.

Staging Target

Development: Batchrecords will be inserted into the tables, which are defined as development targets.
Qualification: Batchrecords will be inserted into the tables, which are defined as qualification targets.
Production: Batchrecords will be inserted into the tables, which are defined as production targets.

Active: When switched off, it is allowed to exclude certain configured units from being processed.

History Fetches: When switched off, it is allowed to exclude certain configured units from being included in refetches of historical batch data.

Product Filter: Allows to specify a certain filter for the product name. Products which do not match the filter criteria will be discarded.

Tag Configuration

Compound for additional tag configuration for batch records.

Header Options

Header Options.

Acquisition Mode

The acquisition mode defines how the value for this tag will be fetched.

Tag Name Parameter

Compound for tag name parameters.

Tag Name: The external identifier to read the value from the interface.

Object Path Parameter

Compound for object path parameters.

Object Path: The inmation object which will deliver the value.

Alias Name: The pseudo name to extent the batch header or unit fields.

Selection Field: Optionally enter a batch characteristic field name which works as a selector for the tag. This can be used to read from different tags in cases there are multiple products with multiple quantity tags or the like.

Selection Value: In case the Selection Field is set, this value must be set to one of the possible contents of the batch characteristic given in the selection.

Unit Options

Compound for tag unit options.

Acquisition Mode

The acquisition mode defines how the value for this tag will be fetched.

Tag Name Parameter

Compound for tag name parameters.

Tag Name: The external identifier to read the value from the interface.

Object Path Parameter

Compound for object path parameters.

Object Path: The inmation object which will deliver the value.

Alias Name: The pseudo name to extent the batch header or unit fields.

Source Unit: The unit identifier which is used in the source system.

Selection Field: Optionally enter a batch characteristic field name which works as a selector for the tag. This can be used to read from different tags in cases there are multiple products with multiple quantity tags or the like.

Selection Value: In case the Selection Field is set, this value must be set to one of the possible contents of the batch characteristic given in the selection.

Field Configuration

Compound for the field configuration for batch records.

Header Field Options

Header Field Options.

Source Field: The name of the source field.

Target Field

Start Time: Start Time.
End Time: End Time.
Product Name: Product Name.
Product Eng. Unit: Product Eng. Unit.
Product Setpoint: Product Setpoint.
Product Actual: Product Actual.
Master Recipe Version: Master Recipe Version.
Educt Name: Educt Name.
Educt Eng. Unit: Educt Eng. Unit.
Educt Setpoint: Educt Setpoint.
Educt Actual: Educt Actual.
Product Code: Product Code.
Educt Code: Educt Code.
Control Recipe Name: Control Recipe Name.
Master Recipe Name: Master Recipe Name.
Batch ID: Batch ID.
Batch Number: Batch Number.
Recipe Type: Recipe Type.
Batch Status: Batch Status.
Material Type: Material Type.
Material Type Code: Material Type Code.
Unique Batch ID: Unique Batch ID.
Unit Name: Unit Name.
Unit Asset Code: Unit Asset Code.
Production Version: Production Version.
Equipment Active: Must return true or false in order to determine equipment active state.
Equipment State: Must return one of the standardized OMAC states for the equipment.
ERP Order: Must return the ERP order ident for the batch.
MES Batch ID: Must return the MES Batch ID in case different than the equipment batch ident.
Batch ERP Order Number: Batch ERP Order Number.
Batch ERP ID: Batch ERP ID.
Batch MES ID: Batch MES ID.
Batch Size: Batch Size.
Batch Size Eng. Unit: Batch Size Eng. Unit.
Campaign ID: Campaign ID.
Campaign MES ID: Campaign MES ID.
Campaign ERP ID: Campaign ERP ID.
Campaign ERP Order Number: Campaign ERP Order Number.
Campaign Size: Campaign Size.
Campaign Size Eng. Unit: Campaign Size Eng. Unit.
Shift Code: Shift Code.
Shift Name: Shift Name.
Custom Measurement: Custom Measurement.
Custom Timestamp: Custom Timestamp.
Custom State: Custom State.
Custom Quality: Custom Quality.
Sample Size: The amount of material taken for the sample.
Sample Type: The type of sample pulled. There are no standard codes defined. Examples: Receiving Sample, Online Sample, Lab Sample.
Sample Pull Reason: The reason the sample was pulled.
Sample Expiration: The date the sample expires.
Sample Physical Asset ID: A reference to a physical asset element that is associated with the sample.
Sample SOP Reference: The standard operating procedure (SOP) that is associated with the sample pull.
Sample Test: The tests on the sample.
Sample Test Code: The test procedure used.
Sample Test Name: The name associated with the test performed.
Sample Test Result: The result from a sample test.
Sample Test Disposition: An indication if the test results were acceptable. No standard identifiers defined. Example: Pass, Fail.
Sample Analysis Used: The statistical sampling analysis used to determine the result. No standard CodeType is defined. Example: Average, Minimum, Maximum.
Sample Test Result Expiration: The date and time that the sample test results expire.
Sample Result: The actual value or values returned from the test.
Sample Expected Results: The expected value or values returned from the test.
Sample Document: A JSON document according to B2MML.
Operation ID: Operation ID.
Operation Name: Operation Name.
Lot ID: Lot ID.
Material Definition ID: Material Definition ID.
Waste Actual: Waste Actual.
Waste Code: Waste Code.
Waste Eng. Unit: Waste Eng. Unit.
Waste Name: Waste Name.
Waste Setpoint: Waste Setpoint.
Reinsert Actual: Reinsert Actual.
Reinsert Code: Reinsert Code.
Reinsert Eng. Unit: Reinsert Eng. Unit.
Reinsert Name: Reinsert Name.
Reinsert Setpoint: Reinsert Setpoint.
Down-Time: Down-Time.
Down-Time Eng. Unit: Down-Time Eng. Unit.
BPR Extension Time: BPR Extension Time.
BPR Extension Time Eng. Unit: BPR Extension Time Eng. Unit.
BPR Extension Prohibited: BPR Extension Prohibited.
Annotation Prohibited: Annotation Prohibited.
Cleaning Actual: Cleaning Actual.
Cleaning Code: Cleaning Code.
Cleaning Eng. Unit: Cleaning Eng. Unit.
Cleaning Name: Cleaning Name.
Cleaning Setpoint: Cleaning Setpoint.
Down-Time Cause: Down-Time Cause.
Energy Consumption: Energy Consumption.
Energy Consumption Eng. Unit: Energy Consumption Eng. Unit.
Energy Consumption Limit: Energy Consumption Limit.
Energy Consumption Cost: Energy Consumption Cost.
Energy Consumption Cost Currency: Energy Consumption Cost Currency.
Batch Control ID: Batch Control ID.
Batch Source ID: Batch Source ID.
Batch System ID: Batch System ID.
Source Vendor: Source Vendor.
Source Product: Source Product.
Source Interface: Source Interface.
Source Datasource: Source Datasource.
Source Timestamp: Source Timestamp.
Scheduled Start Time: Scheduled Start Time.
Scheduled End Time: Scheduled End Time.
Source Batch Datasource: Source Batch Datasource.
Source Batch Area: Source Batch Area.
Source Timezone: Source Timezone.
Source Local Time: Source Local Time.
Record Type: S88 Record Type.
Unit Description: Batch Unit Description.
Runtime: The runtime of a distinct batch, procedure, operation etc.
Operation Sequence: Operation Sequence Number.
Operation Instance: Operation Instance Number.
Operator Name: Operator Name, responsible for Batch, Procedure, Operation etc.
Phase ID: Phase ID.
Phase Instance: Phase Instance Number.
Phase Name: Phase Name.
Phase Sequence: Phase Sequence Number.
Unit Procedure ID: Unit Procedure ID.
Unit Procedure Instance: Unit Procedure Instance Number.
Unit Procedure Name: Unit Procedure Name.
Unit Procedure Sequence: Unit Procedure Sequence Number.
Eventnumber: Eventnumber.
Eventtime: Eventtime.
Data Acquisition Type: Data Acquisition Type.
Acquisition Type: Specifies the acquisition type of the batch record. Can be one of 'Historical Data', 'Actual Data' and 'Real-Time Data'.
Blowout Datetime: Blowout Datetime.
Capping Start Datetime: Capping Start Datetime.
CIP Datetime: CIP Datetime.
Cleaning State: Cleaning State.
Control Recipe Expiration Datetime: Control Recipe Expiration Datetime.
Control Recipe Number: Control Recipe Number.
Control Recipe Version: Control Recipe Version.
Custom Mode: Custom Mode.
Filling End Datetime: Filling End Datetime.
Filling Start Datetime: Filling Start Datetime.
Format: Format.
MES Cleaning Order ID: MES Cleaning Order ID.
MES Order ID: MES Order ID.
Printer State: Printer State.
Product Count Bad: Product Count Bad.
Product Count Good: Product Count Good.
Product Actual: Product Actual.
Product Setpoint: Product Setpoint.
Product Weight: Product Weight.
Signature: Signature.
SIP Datetime: SIP Datetime.
SIP Temperature: SIP Temperature.
Speed Actual: Speed Actual.
Speed Setpoint: Speed Setpoint.
Stop Code: Stop Code.
Stop Downstream Cause: Stop Downstream Cause.
Stop Reason: Stop Reason.
Stop Upstream Cause: Stop Upstream Cause.
Unit: Unit.
Critical Process Parameter: Critical Process Parameter.
Critical Process Parameter (Aggregate): A Critical Process Parameter which has been aggregated based on a collected disting time series.
Equipment ID: Identifies an Equipment uniquely within a Procedure, Unit Procedure or Operation.
Equipment Name: Holds the Equipment Name used within a Procedure, Unit Procedure or Operation.
Equipment Phase ID: Identifies the current Equipment Phase.
Equipment Phase Instance: The instance number of the current Equipment Phase.
Equipment Phase Name: The textual name of the current Equipment Phase.
Equipment Phase Sequence Number: The sequence number of the current Equipment Phase.
Equipment Step ID: Identifies the current Equipment Step within the current Equipment Phase.
Equipment Step Name: The textual name of the current Equipment Step within the current Equipment Phase.
Equipment Step Instance: The instance number of the current Equipment Step within the current Equipment Phase.
Equipment Step Sequence Number: The sequence number of the current Equipment Step within the current Equipment Phase.
Equipment Phase Parallelism ID: The parallelism ID for a particular Equipment Phase within the current Recipe Phase or Operation. The ID identifies the Recipe "Swim Lane" this Equipment is associated with.
Yield: Yield.
Yield Count: Yield as count.
Yield Volume: Yield as volume.
Reject: Reject.
Reject Count: Reject Count.
Reject Volume: Reject Volume.
Duration: Duration.
Process Duration: Process Duration.
Holding Time: Holding Time.
Weight: Weight.
Length: Length.

Unit Field Options

Unit Field Options.

Source Field: The name of the source field.

Target Field

Start Time: Start Time.
End Time: End Time.
Product Name: Product Name.
Product Eng. Unit: Product Eng. Unit.
Product Setpoint: Product Setpoint.
Product Actual: Product Actual.
Master Recipe Version: Master Recipe Version.
Educt Name: Educt Name.
Educt Eng. Unit: Educt Eng. Unit.
Educt Setpoint: Educt Setpoint.
Educt Actual: Educt Actual.
Product Code: Product Code.
Educt Code: Educt Code.
Control Recipe Name: Control Recipe Name.
Master Recipe Name: Master Recipe Name.
Batch ID: Batch ID.
Batch Number: Batch Number.
Recipe Type: Recipe Type.
Batch Status: Batch Status.
Material Type: Material Type.
Material Type Code: Material Type Code.
Unique Batch ID: Unique Batch ID.
Unit Name: Unit Name.
Unit Asset Code: Unit Asset Code.
Production Version: Production Version.
Equipment Active: Must return true or false in order to determine equipment active state.
Equipment State: Must return one of the standardized OMAC states for the equipment.
ERP Order: Must return the ERP order ident for the batch.
MES Batch ID: Must return the MES Batch ID in case different than the equipment batch ident.
Batch ERP Order Number: Batch ERP Order Number.
Batch ERP ID: Batch ERP ID.
Batch MES ID: Batch MES ID.
Batch Size: Batch Size.
Batch Size Eng. Unit: Batch Size Eng. Unit.
Campaign ID: Campaign ID.
Campaign MES ID: Campaign MES ID.
Campaign ERP ID: Campaign ERP ID.
Campaign ERP Order Number: Campaign ERP Order Number.
Campaign Size: Campaign Size.
Campaign Size Eng. Unit: Campaign Size Eng. Unit.
Shift Code: Shift Code.
Shift Name: Shift Name.
Custom Measurement: Custom Measurement.
Custom Timestamp: Custom Timestamp.
Custom State: Custom State.
Custom Quality: Custom Quality.
Sample Size: The amount of material taken for the sample.
Sample Type: The type of sample pulled. There are no standard codes defined. Examples: Receiving Sample, Online Sample, Lab Sample.
Sample Pull Reason: The reason the sample was pulled.
Sample Expiration: The date the sample expires.
Sample Physical Asset ID: A reference to a physical asset element that is associated with the sample.
Sample SOP Reference: The standard operating procedure (SOP) that is associated with the sample pull.
Sample Test: The tests on the sample.
Sample Test Code: The test procedure used.
Sample Test Name: The name associated with the test performed.
Sample Test Result: The result from a sample test.
Sample Test Disposition: An indication if the test results were acceptable. No standard identifiers defined. Example: Pass, Fail.
Sample Analysis Used: The statistical sampling analysis used to determine the result. No standard CodeType is defined. Example: Average, Minimum, Maximum.
Sample Test Result Expiration: The date and time that the sample test results expire.
Sample Result: The actual value or values returned from the test.
Sample Expected Results: The expected value or values returned from the test.
Sample Document: A JSON document according to B2MML.
Operation ID: Operation ID.
Operation Name: Operation Name.
Lot ID: Lot ID.
Material Definition ID: Material Definition ID.
Waste Actual: Waste Actual.
Waste Code: Waste Code.
Waste Eng. Unit: Waste Eng. Unit.
Waste Name: Waste Name.
Waste Setpoint: Waste Setpoint.
Reinsert Actual: Reinsert Actual.
Reinsert Code: Reinsert Code.
Reinsert Eng. Unit: Reinsert Eng. Unit.
Reinsert Name: Reinsert Name.
Reinsert Setpoint: Reinsert Setpoint.
Down-Time: Down-Time.
Down-Time Eng. Unit: Down-Time Eng. Unit.
BPR Extension Time: BPR Extension Time.
BPR Extension Time Eng. Unit: BPR Extension Time Eng. Unit.
BPR Extension Prohibited: BPR Extension Prohibited.
Annotation Prohibited: Annotation Prohibited.
Cleaning Actual: Cleaning Actual.
Cleaning Code: Cleaning Code.
Cleaning Eng. Unit: Cleaning Eng. Unit.
Cleaning Name: Cleaning Name.
Cleaning Setpoint: Cleaning Setpoint.
Down-Time Cause: Down-Time Cause.
Energy Consumption: Energy Consumption.
Energy Consumption Eng. Unit: Energy Consumption Eng. Unit.
Energy Consumption Limit: Energy Consumption Limit.
Energy Consumption Cost: Energy Consumption Cost.
Energy Consumption Cost Currency: Energy Consumption Cost Currency.
Batch Control ID: Batch Control ID.
Batch Source ID: Batch Source ID.
Batch System ID: Batch System ID.
Source Vendor: Source Vendor.
Source Product: Source Product.
Source Interface: Source Interface.
Source Datasource: Source Datasource.
Source Timestamp: Source Timestamp.
Scheduled Start Time: Scheduled Start Time.
Scheduled End Time: Scheduled End Time.
Source Batch Datasource: Source Batch Datasource.
Source Batch Area: Source Batch Area.
Source Timezone: Source Timezone.
Source Local Time: Source Local Time.
Record Type: S88 Record Type.
Unit Description: Batch Unit Description.
Runtime: The runtime of a distinct batch, procedure, operation etc.
Operation Sequence: Operation Sequence Number.
Operation Instance: Operation Instance Number.
Operator Name: Operator Name, responsible for Batch, Procedure, Operation etc.
Phase ID: Phase ID.
Phase Instance: Phase Instance Number.
Phase Name: Phase Name.
Phase Sequence: Phase Sequence Number.
Unit Procedure ID: Unit Procedure ID.
Unit Procedure Instance: Unit Procedure Instance Number.
Unit Procedure Name: Unit Procedure Name.
Unit Procedure Sequence: Unit Procedure Sequence Number.
Eventnumber: Eventnumber.
Eventtime: Eventtime.
Data Acquisition Type: Data Acquisition Type.
Acquisition Type: Specifies the acquisition type of the batch record. Can be one of 'Historical Data', 'Actual Data' and 'Real-Time Data'.
Blowout Datetime: Blowout Datetime.
Capping Start Datetime: Capping Start Datetime.
CIP Datetime: CIP Datetime.
Cleaning State: Cleaning State.
Control Recipe Expiration Datetime: Control Recipe Expiration Datetime.
Control Recipe Number: Control Recipe Number.
Control Recipe Version: Control Recipe Version.
Custom Mode: Custom Mode.
Filling End Datetime: Filling End Datetime.
Filling Start Datetime: Filling Start Datetime.
Format: Format.
MES Cleaning Order ID: MES Cleaning Order ID.
MES Order ID: MES Order ID.
Printer State: Printer State.
Product Count Bad: Product Count Bad.
Product Count Good: Product Count Good.
Product Actual: Product Actual.
Product Setpoint: Product Setpoint.
Product Weight: Product Weight.
Signature: Signature.
SIP Datetime: SIP Datetime.
SIP Temperature: SIP Temperature.
Speed Actual: Speed Actual.
Speed Setpoint: Speed Setpoint.
Stop Code: Stop Code.
Stop Downstream Cause: Stop Downstream Cause.
Stop Reason: Stop Reason.
Stop Upstream Cause: Stop Upstream Cause.
Unit: Unit.
Critical Process Parameter: Critical Process Parameter.
Critical Process Parameter (Aggregate): A Critical Process Parameter which has been aggregated based on a collected disting time series.
Equipment ID: Identifies an Equipment uniquely within a Procedure, Unit Procedure or Operation.
Equipment Name: Holds the Equipment Name used within a Procedure, Unit Procedure or Operation.
Equipment Phase ID: Identifies the current Equipment Phase.
Equipment Phase Instance: The instance number of the current Equipment Phase.
Equipment Phase Name: The textual name of the current Equipment Phase.
Equipment Phase Sequence Number: The sequence number of the current Equipment Phase.
Equipment Step ID: Identifies the current Equipment Step within the current Equipment Phase.
Equipment Step Name: The textual name of the current Equipment Step within the current Equipment Phase.
Equipment Step Instance: The instance number of the current Equipment Step within the current Equipment Phase.
Equipment Step Sequence Number: The sequence number of the current Equipment Step within the current Equipment Phase.
Equipment Phase Parallelism ID: The parallelism ID for a particular Equipment Phase within the current Recipe Phase or Operation. The ID identifies the Recipe "Swim Lane" this Equipment is associated with.
Yield: Yield.
Yield Count: Yield as count.
Yield Volume: Yield as volume.
Reject: Reject.
Reject Count: Reject Count.
Reject Volume: Reject Volume.
Duration: Duration.
Process Duration: Process Duration.
Holding Time: Holding Time.
Weight: Weight.
Length: Length.

Product Options

Allows to classify products.

Main Product: Allows to reclassify products to be the main product.

Side Products: Allows to reclassify regular products to side products.

Waste Products: Allows to reclassify regular products to waste product.

Educt Options

Allows to classify educts.

Cleaning Educts: Allows to reclassify regular educts to materials used for cleaning.

Reinsert Educts: Allows to reclassify regular educts to reinserted educts.

Timestamp Options

Compound for timestamp parameters.

Local Timestamp: If this is checked it is assumed that the datasource provides timestamps as local time, if unchecked UTC timestamps are assumed.

Timestamp

Defines how to interpret the timestamp.

Default: The timestamp format of the source data is yyyy-MM-dd HH:mm:ss.

ISO8601: The timestamp format of the source data is yyyy-MM-ddTHH:mm:ss.

POSIX Milliseconds: The timestamp format of the source data is numerical POSIX milliseconds.

POSIX Seconds: The timestamp format of the source data is numerical POSIX seconds.

Excel: Timestamps are supplied in numerical Excel datetime format.

Custom Options

Compound for timestamp format 'custom' parameters.

Custom Format: A string format mask specifying the interpretation of the timestamp. For Example "%d.%m.%Y %H:%M" for "01.12.2016 17:00" (q.v. http://www.boost.org/doc/libs/1_41_0/doc/html/date_time/date_time_io.html). In case you use ISO8601-compliant timestamps, this format does not need to be specified.

Custom Script Options

Compound for timestamp 'custom script' parameter.

Custom Script: The custom script, which is required to return the timestamp in numerical POSIX millisecond format.

Annotations and Extensions

Define the permission for users to add annotations and extensions to the Batch Production Record.

Annotations Permitted: Users may add annotations to the Batch Production Record.

Extensions Permitted: Users may extent the Batch Production Record with additional data.

Extensions Time Limit: The time span in which annotations and extensions can be applied to the Batch Production Record with respect to ist machine level completion state. Note: fractional days such as 0.5 are valid entries.

Other Options

Compound for additional options.

Final Script: This script will be executed after the data has been processed for a particular batch document.

Asset Effectiveness Staging

Compound for asset effectiveness staging.

Staging Computer: The name of the staging computer of asset effectiveness.

ODBC Connection

The ODBC connection parameters.

Datasource Name: The name of the ODBC datasource, which can be a DSN or a valid ODBC connection string (example: "driver={SQL Server Native Client 11.0}; server=someserver;uid=someuser;pwd=somepassword;"). The parameters of the connection string are defined by the used driver, which is identified by the DRIVER parameter. More information can be found here https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqldriverconnect-function and https://www.connectionstrings.com.

User Name: The user name of the ODBC Datasource (optional).

Password: The password of the ODBC Datasource (optional).

UTF-8 Conversion: Switch the UTF-8 Conversion on, if the database returns ASCII.

Code Page

00000 Current Code Page: Current Code Page.
00037 IBM EBCDIC US-Canada: IBM EBCDIC US-Canada.
00437 OEM United States: OEM United States.
00500 IBM EBCDIC International: IBM EBCDIC International.
00708 Arabic (ASMO 708): Arabic (ASMO 708).
00709 Arabic (ASMO-449+, BCON V4): Arabic (ASMO-449+, BCON V4).
00710 Arabic - Transparent Arabic: Arabic - Transparent Arabic.
00720 Arabic (Transparent ASMO); Arabic (DOS): Arabic (Transparent ASMO); Arabic (DOS).
00737 OEM Greek (formerly 437G); Greek (DOS): OEM Greek (formerly 437G); Greek (DOS).
00775 OEM Baltic; Baltic (DOS): OEM Baltic; Baltic (DOS).
00850 OEM Multilingual Latin 1; Western European (DOS): OEM Multilingual Latin 1; Western European (DOS).
00852 OEM Latin 2; Central European (DOS): OEM Latin 2; Central European (DOS).
00855 OEM Cyrillic (primarily Russian): OEM Cyrillic (primarily Russian).
00857 OEM Turkish; Turkish (DOS): OEM Turkish; Turkish (DOS).
00858 OEM Multilingual Latin 1 + Euro symbol: OEM Multilingual Latin 1 + Euro symbol.
00860 OEM Portuguese; Portuguese (DOS): OEM Portuguese; Portuguese (DOS).
00861 OEM Icelandic; Icelandic (DOS): OEM Icelandic; Icelandic (DOS).
00862 OEM Hebrew; Hebrew (DOS): OEM Hebrew; Hebrew (DOS).
00863 OEM French Canadian; French Canadian (DOS): OEM French Canadian; French Canadian (DOS).
00864 OEM Arabic; Arabic (864): OEM Arabic; Arabic (864).
00865 OEM Nordic; Nordic (DOS): OEM Nordic; Nordic (DOS).
00866 OEM Russian; Cyrillic (DOS): OEM Russian; Cyrillic (DOS).
00869 OEM Modern Greek; Greek, Modern (DOS): OEM Modern Greek; Greek, Modern (DOS).
00870 IBM EBCDIC Multilingual/ROECE (Latin 2); IBM EBCDIC Multilingual Latin 2: IBM EBCDIC Multilingual/ROECE (Latin 2); IBM EBCDIC Multilingual Latin 2.
00874 ANSI/OEM Thai (ISO 8859-11); Thai (Windows): ANSI/OEM Thai (ISO 8859-11); Thai (Windows).
00875 IBM EBCDIC Greek Modern: IBM EBCDIC Greek Modern.
00932 ANSI/OEM Japanese; Japanese (Shift-JIS): ANSI/OEM Japanese; Japanese (Shift-JIS).
00936 ANSI/OEM Simplified Chinese (PRC, Singapore); Chinese Simplified (GB2312): ANSI/OEM Simplified Chinese (PRC, Singapore); Chinese Simplified (GB2312).
00949 ANSI/OEM Korean (Unified Hangul Code): ANSI/OEM Korean (Unified Hangul Code).
00950 ANSI/OEM Traditional Chinese (Taiwan; Hong Kong SAR, PRC); Chinese Traditional (Big5): ANSI/OEM Traditional Chinese (Taiwan; Hong Kong SAR, PRC); Chinese Traditional (Big5).
01026 IBM EBCDIC Turkish (Latin 5): IBM EBCDIC Turkish (Latin 5).
01047 IBM EBCDIC Latin 1/Open System: IBM EBCDIC Latin 1/Open System.
01140 IBM EBCDIC US-Canada (037 + Euro symbol); IBM EBCDIC (US-Canada-Euro): IBM EBCDIC US-Canada (037 + Euro symbol); IBM EBCDIC (US-Canada-Euro).
01141 IBM EBCDIC Germany (20273 + Euro symbol); IBM EBCDIC (Germany-Euro): IBM EBCDIC Germany (20273 + Euro symbol); IBM EBCDIC (Germany-Euro).
01142 IBM EBCDIC Denmark-Norway (20277 + Euro symbol); IBM EBCDIC (Denmark-Norway-Euro): IBM EBCDIC Denmark-Norway (20277 + Euro symbol); IBM EBCDIC (Denmark-Norway-Euro).
01143 IBM EBCDIC Finland-Sweden (20278 + Euro symbol); IBM EBCDIC (Finland-Sweden-Euro): IBM EBCDIC Finland-Sweden (20278 + Euro symbol); IBM EBCDIC (Finland-Sweden-Euro).
01144 IBM EBCDIC Italy (20280 + Euro symbol); IBM EBCDIC (Italy-Euro): IBM EBCDIC Italy (20280 + Euro symbol); IBM EBCDIC (Italy-Euro).
01145 IBM EBCDIC Latin America-Spain (20284 + Euro symbol); IBM EBCDIC (Spain-Euro): IBM EBCDIC Latin America-Spain (20284 + Euro symbol); IBM EBCDIC (Spain-Euro).
01146 IBM EBCDIC United Kingdom (20285 + Euro symbol); IBM EBCDIC (UK-Euro): IBM EBCDIC United Kingdom (20285 + Euro symbol); IBM EBCDIC (UK-Euro).
01147 IBM EBCDIC France (20297 + Euro symbol); IBM EBCDIC (France-Euro): IBM EBCDIC France (20297 + Euro symbol); IBM EBCDIC (France-Euro).
01148 IBM EBCDIC International (500 + Euro symbol); IBM EBCDIC (International-Euro): IBM EBCDIC International (500 + Euro symbol); IBM EBCDIC (International-Euro).
01149 IBM EBCDIC Icelandic (20871 + Euro symbol); IBM EBCDIC (Icelandic-Euro): IBM EBCDIC Icelandic (20871 + Euro symbol); IBM EBCDIC (Icelandic-Euro).
01200 Unicode UTF-16, little endian byte order (BMP of ISO 10646); available only to managed applications: Unicode UTF-16, little endian byte order (BMP of ISO 10646); available only to managed applications.
01201 Unicode UTF-16, big endian byte order; available only to managed applications: Unicode UTF-16, big endian byte order; available only to managed applications.
01250 ANSI Central European; Central European (Windows): ANSI Central European; Central European (Windows).
01251 ANSI Cyrillic; Cyrillic (Windows): ANSI Cyrillic; Cyrillic (Windows).
01252 ANSI Latin 1; Western European (Windows): ANSI Latin 1; Western European (Windows).
01253 ANSI Greek; Greek (Windows): ANSI Greek; Greek (Windows).
01254 ANSI Turkish; Turkish (Windows): ANSI Turkish; Turkish (Windows).
01255 ANSI Hebrew; Hebrew (Windows): ANSI Hebrew; Hebrew (Windows).
01256 ANSI Arabic; Arabic (Windows): ANSI Arabic; Arabic (Windows).
01257 ANSI Baltic; Baltic (Windows): ANSI Baltic; Baltic (Windows).
01258 ANSI/OEM Vietnamese; Vietnamese (Windows): ANSI/OEM Vietnamese; Vietnamese (Windows).
01361 Korean (Johab): Korean (Johab).
10000 MAC Roman; Western European (Mac): MAC Roman; Western European (Mac).
10001 Japanese (Mac): Japanese (Mac).
10002 MAC Traditional Chinese (Big5); Chinese Traditional (Mac): MAC Traditional Chinese (Big5); Chinese Traditional (Mac).
10003 Korean (Mac): Korean (Mac).
10004 Arabic (Mac): Arabic (Mac).
10005 Hebrew (Mac): Hebrew (Mac).
10006 Greek (Mac): Greek (Mac).
10007 Cyrillic (Mac): Cyrillic (Mac).
10008 MAC Simplified Chinese (GB 2312); Chinese Simplified (Mac): MAC Simplified Chinese (GB 2312); Chinese Simplified (Mac).
10010 Romanian (Mac): Romanian (Mac).
10017 Ukrainian (Mac): Ukrainian (Mac).
10021 Thai (Mac): Thai (Mac).
10029 MAC Latin 2; Central European (Mac): MAC Latin 2; Central European (Mac).
10079 Icelandic (Mac): Icelandic (Mac).
10081 Turkish (Mac): Turkish (Mac).
10082 Croatian (Mac): Croatian (Mac).
12000 Unicode UTF-32, little endian byte order; available only to managed applications: Unicode UTF-32, little endian byte order; available only to managed applications.
12001 Unicode UTF-32, big endian byte order; available only to managed applications: Unicode UTF-32, big endian byte order; available only to managed applications.
20000 CNS Taiwan; Chinese Traditional (CNS): CNS Taiwan; Chinese Traditional (CNS).
20001 TCA Taiwan: TCA Taiwan.
20002 Eten Taiwan; Chinese Traditional (Eten): Eten Taiwan; Chinese Traditional (Eten).
20003 IBM5550 Taiwan: IBM5550 Taiwan.
20004 TeleText Taiwan: TeleText Taiwan.
20005 Wang Taiwan: Wang Taiwan.
20105 IA5 (IRV International Alphabet No. 5, 7-bit); Western European (IA5): IA5 (IRV International Alphabet No. 5, 7-bit); Western European (IA5).
20106 IA5 German (7-bit): IA5 German (7-bit).
20107 IA5 Swedish (7-bit): IA5 Swedish (7-bit).
20108 IA5 Norwegian (7-bit): IA5 Norwegian (7-bit).
20127 US-ASCII (7-bit): US-ASCII (7-bit).
20261 T.61: T.61.
20269 ISO 6937 Non-Spacing Accent: ISO 6937 Non-Spacing Accent.
20273 IBM EBCDIC Germany: IBM EBCDIC Germany.
20277 IBM EBCDIC Denmark-Norway: IBM EBCDIC Denmark-Norway.
20278 IBM EBCDIC Finland-Sweden: IBM EBCDIC Finland-Sweden.
20280 IBM EBCDIC Italy: IBM EBCDIC Italy.
20284 IBM EBCDIC Latin America-Spain: IBM EBCDIC Latin America-Spain.
20285 IBM EBCDIC United Kingdom: IBM EBCDIC United Kingdom.
20290 IBM EBCDIC Japanese Katakana Extended: IBM EBCDIC Japanese Katakana Extended.
20297 IBM EBCDIC France: IBM EBCDIC France.
20420 IBM EBCDIC Arabic: IBM EBCDIC Arabic.
20423 IBM EBCDIC Greek: IBM EBCDIC Greek.
20424 IBM EBCDIC Hebrew: IBM EBCDIC Hebrew.
20833 IBM EBCDIC Korean Extended: IBM EBCDIC Korean Extended.
20838 IBM EBCDIC Thai: IBM EBCDIC Thai.
20866 Russian (KOI8-R); Cyrillic (KOI8-R): Russian (KOI8-R); Cyrillic (KOI8-R).
20871 IBM EBCDIC Icelandic: IBM EBCDIC Icelandic.
20880 IBM EBCDIC Cyrillic Russian: IBM EBCDIC Cyrillic Russian.
20905 IBM EBCDIC Turkish: IBM EBCDIC Turkish.
20924 IBM EBCDIC Latin 1/Open System (1047 + Euro symbol): IBM EBCDIC Latin 1/Open System (1047 + Euro symbol).
20932 Japanese (JIS 0208-1990 and 0212-1990): Japanese (JIS 0208-1990 and 0212-1990).
20936 Simplified Chinese (GB2312); Chinese Simplified (GB2312-80): Simplified Chinese (GB2312); Chinese Simplified (GB2312-80).
20949 Korean Wansung: Korean Wansung.
21025 IBM EBCDIC Cyrillic Serbian-Bulgarian: IBM EBCDIC Cyrillic Serbian-Bulgarian.
21866 Ukrainian (KOI8-U); Cyrillic (KOI8-U): Ukrainian (KOI8-U); Cyrillic (KOI8-U).
28591 ISO 8859-1 Latin 1; Western European (ISO): ISO 8859-1 Latin 1; Western European (ISO).
28592 ISO 8859-2 Central European; Central European (ISO): ISO 8859-2 Central European; Central European (ISO).
28593 ISO 8859-3 Latin 3: ISO 8859-3 Latin 3.
28594 ISO 8859-4 Baltic: ISO 8859-4 Baltic.
28595 ISO 8859-5 Cyrillic: ISO 8859-5 Cyrillic.
28596 ISO 8859-6 Arabic: ISO 8859-6 Arabic.
28597 ISO 8859-7 Greek: ISO 8859-7 Greek.
28598 ISO 8859-8 Hebrew; Hebrew (ISO-Visual): ISO 8859-8 Hebrew; Hebrew (ISO-Visual).
28599 ISO 8859-9 Turkish: ISO 8859-9 Turkish.
28603 ISO 8859-13 Estonian: ISO 8859-13 Estonian.
28605 ISO 8859-15 Latin 9: ISO 8859-15 Latin 9.
29001 Europa 3: Europa 3.
38598 ISO 8859-8 Hebrew; Hebrew (ISO-Logical): ISO 8859-8 Hebrew; Hebrew (ISO-Logical).
50220 ISO 2022 Japanese with no halfwidth Katakana; Japanese (JIS): ISO 2022 Japanese with no halfwidth Katakana; Japanese (JIS).
50221 ISO 2022 Japanese with halfwidth Katakana; Japanese (JIS-Allow 1 byte Kana): ISO 2022 Japanese with halfwidth Katakana; Japanese (JIS-Allow 1 byte Kana).
50222 ISO 2022 Japanese JIS X 0201-1989; Japanese (JIS-Allow 1 byte Kana - SO/SI): ISO 2022 Japanese JIS X 0201-1989; Japanese (JIS-Allow 1 byte Kana - SO/SI).
50225 ISO 2022 Korean: ISO 2022 Korean.
50227 ISO 2022 Simplified Chinese; Chinese Simplified (ISO 2022): ISO 2022 Simplified Chinese; Chinese Simplified (ISO 2022).
50229 ISO 2022 Traditional Chinese: ISO 2022 Traditional Chinese.
50930 EBCDIC Japanese (Katakana) Extended: EBCDIC Japanese (Katakana) Extended.
50931 EBCDIC US-Canada and Japanese: EBCDIC US-Canada and Japanese.
50933 EBCDIC Korean Extended and Korean: EBCDIC Korean Extended and Korean.
50935 EBCDIC Simplified Chinese Extended and Simplified Chinese: EBCDIC Simplified Chinese Extended and Simplified Chinese.
50936 EBCDIC Simplified Chinese: EBCDIC Simplified Chinese.
50937 EBCDIC US-Canada and Traditional Chinese: EBCDIC US-Canada and Traditional Chinese.
50939 EBCDIC Japanese (Latin) Extended and Japanese: EBCDIC Japanese (Latin) Extended and Japanese.
51932 EUC Japanese: EUC Japanese.
51936 EUC Simplified Chinese; Chinese Simplified (EUC): EUC Simplified Chinese; Chinese Simplified (EUC).
51949 EUC Korean: EUC Korean.
51950 EUC Traditional Chinese: EUC Traditional Chinese.
52936 HZ-GB2312 Simplified Chinese; Chinese Simplified (HZ): HZ-GB2312 Simplified Chinese; Chinese Simplified (HZ).
54936 Windows XP and later: GB18030 Simplified Chinese (4 byte); Chinese Simplified (GB18030): Windows XP and later: GB18030 Simplified Chinese (4 byte); Chinese Simplified (GB18030).
57002 ISCII Devanagari: ISCII Devanagari.
57003 ISCII Bangla: ISCII Bangla.
57004 ISCII Tamil: ISCII Tamil.
57005 ISCII Telugu: ISCII Telugu.
57006 ISCII Assamese: ISCII Assamese.
57007 ISCII Odia: ISCII Odia.
57008 ISCII Kannada: ISCII Kannada.
57009 ISCII Malayalam: ISCII Malayalam.
57010 ISCII Gujarati: ISCII Gujarati.
57011 ISCII Punjabi: ISCII Punjabi.
65000 Unicode (UTF-7): Unicode (UTF-7).
65001 Unicode (UTF-8): Unicode (UTF-8).

Main Table: The fully qualified target table to insert the main product asset effectiveness record for production.

Additional Table: The fully qualified additional table to insert additional product records for production.

Main Product SQL: The SQL merge command which will be used to insert the main product record into the target table.

Additional Product SQL: The SQL merge command which will be used to insert additional educts and products into the target table.

Sequence Complete SQL: The SQL statement, which will be issued after the main product and the additional products have been merged.

Suppress Incomplete Mergesets: Ensures that the Asset Effectiveness Mergeset contains complete information. In case, the Unit Asset Code, the BatchID or the Timestamp portion is missing in the System Unique BatchID, the Mergeset will not be transmitted.

History Settings

Compound for history settings of the batch record object.

Maximum Depth: The maximum number of days of the batch history.

Oldest Batch ID: The oldest Batch ID, which has been acquired by the datasource.

Timestamp: The timestamp of the start time of the oldest BatchID.

Diagnostics

Diagnostics.

Process State: Shows the current processing state of the object.

Recent Batch ID: The recently processed Batch ID.

Recent Acquisition: The datetime of the recent acquisition.

Recent Data: The recently processed Data.

Active Batches: This table shows the data of the active batches.

Recent AE Event: The time when the most recent Asset Effectiveness event was raised.

Recent AE Event Content: The payload attribute content of the most recent Asset Effectiveness event.

Recent PT Event: The time when the most recent Production Tracking event was raised.

Recent PT Event Content: The payload attribute content of the most recent Production Tracking event.

Time Slice Usage: The percentage of time of the configured Time Slice value, which is used for processing active batches. In case the value is close to the maximum of 100% a larger value for Time Slice should be considered.

Operation Mode

Configuration: No data acquisition or analytics will be processed.
One Shot: The data acquisition will be executed once to test the connection and the returned data.
Test: The data acquisition will run on schedule but indicate to the analytics task that no further processing shall be executed.
Production: The data acquisition runs under regular conditions and provides data analytics.
Dropzone Integration: The data is received from a dropzone datasource. This object must be configured as target object of the dropzone.

Reload: Forces the object to reload the code-behind. Does not reset the state.

Statistics: The object will output statistics in form of a historizing variable tree.

Debug: Additional debug messages will be generated in the event log. It is advised to not use this option in production mode.

Time Slice: The period in which running batches are updated. The remaining time will be used for backward and forward operations.