The following tables define the defaults for the message set properties for the TDS Format for each of the industry standard messages that you can define. For more information about the TDS Format, see TDS Format message set properties and TDS Mnemonics.
Property | Messaging standard = User Defined Text | Messaging Standard = SWIFT | Messaging standard = ACORD AL3 |
---|---|---|---|
Group Indicator | Empty | <CR><LF>: | Empty |
Group Terminator | Empty | <CR><LF>- | Empty |
Delimiter | Empty | <CR><LF>: | Empty |
Suppress Absent Element Delimiters | End of Type | End of Type | End of Type |
Tag Data Separator | Empty | : | Empty |
Length of Tag | Empty | Empty | Empty |
Default CCSID | 367 | 37 | 367 |
Trim on input | No Trim | Trim Both | No Trim |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
Escape Character | Chosen | Chosen | Chosen |
Quote character | Not chosen | Not chosen | Not chosen |
Reserved Characters | Empty | Empty | Empty |
Decimal Point | . | , | . |
Packed decimal positive code | C | Not applicable | Not applicable |
Strict Numeric Checking | Cleared | Selected | Selected |
Derive sign from logical type | Selected | Not applicable | Not applicable |
Default byte order | Big Endian | Not applicable | Not applicable |
Default packed decimal byte order | Big Endian | Not applicable | Not applicable |
Default float format | S390 | Not applicable | Not applicable |
Text boolean true value | 1 | 1 | Y |
Text boolean false value | 0 | 0 | N |
Text boolean null value | 0 | 0 | N |
Binary boolean true value | 00000001 | Not applicable | Not applicable |
Binary boolean false value | 00000000 | Not applicable | Not applicable |
Binary boolean null value | 00000000 | Not applicable | Not applicable |
Derive default dateTime format from logical type | Chosen | Chosen | Chosen |
Use default DateTime Format1 | Not chosen, but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen | Not chosen, but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen | Not chosen, but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen |
Start of century for 2 digit years | 53 | 80 | 53 |
Days in First Week of Year | Use Broker Locale | Use Broker Locale | Use Broker Locale |
First Day of Week | Use Broker Locale | Use Broker Locale | Use Broker Locale |
Strict Datetime Checking | Selected | Selected | Selected |
Time Zone | Use Broker Locale | Use Broker Locale | Use Broker Locale |
Daylight Savings Time | Cleared | Cleared | Cleared |
Use input UTC format on output | Cleared | Cleared | Cleared |
Output policy for missing elements | UseDefaultValue | UseDefaultValue | UseDefaultValue |
Derive default length from logical type | Selected | Selected | Selected |
Property | Messaging standard = EDIFACT | Messaging Standard = X12 | Messaging standard = TLOG |
---|---|---|---|
Group Indicator | Empty | Empty | Empty |
Group Terminator | <EDIFACT_GROUP_TERM> | <X12_GROUP_TERM> | Empty |
Delimiter | <EDIFACT_CS> | <X12_CS> | : |
Suppress Absent Element Delimiters | End of Type | End of Type | End of Type |
Tag Data Separator | <EDIFACT_TAGDATA_SEP> | Empty | Empty: |
Length of Tag | Empty | Empty | Empty |
Default CCSID | 367 | 367 | 367 |
Trim on input | Trim Both | Trim Both | No Trim |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
Escape Character | Chosen - <EDIFACT_ESC_CHAR> | Chosen | Chosen |
Quote character | Not chosen | Not chosen | Not chosen |
Reserved Characters | <EDIFACT_ESC_CHAR> |
Empty | Empty |
Decimal Point | <EDIFACT_DEC_NOTATION> | . | . |
Packed decimal positive code | Not applicable | Not applicable | Not applicable |
Strict Numeric Checking | Selected | Selected | Cleared |
Derive sign from logical type | Not applicable | Not applicable | Not applicable |
Default byte order | Not applicable | Not applicable | Not applicable |
Default packed decimal byte order | Not applicable | Not applicable | Not applicable |
Default float format | Not applicable | Not applicable | Not applicable |
Text boolean true value | 1 | 1 | 1 |
Text boolean false value | 0 | 0 | 0 |
Text boolean null value | 0 | 0 | 0 |
Binary boolean true value | Not applicable | Not applicable | Not applicable |
Binary boolean false value | Not applicable | Not applicable | Not applicable |
Binary boolean null value | Not applicable | Not applicable | Not applicable |
Derive default dateTime format from logical type | Chosen | Chosen | Chosen |
Use default DateTime Format1 | Not chosen, but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen | Not chosen, but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen | Not chosen, but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen |
Start of century for 2 digit years | 53 | 53 | 53 |
Days in First Week of Year | Use Broker Locale | Use Broker Locale | Use Broker Locale |
First Day of Week | Use Broker Locale | Use Broker Locale | Use Broker Locale |
Strict Datetime Checking | Selected | Selected | Selected |
Time Zone | Use Broker Locale | Use Broker Locale | Use Broker Locale |
Daylight Savings Time | Cleared | Cleared | Cleared |
Use input UTC format on output | Cleared | Cleared | Cleared |
Output policy for missing elements | UseDefaultValue | UseDefaultValue | UseDefaultValue |
Derive default length from logical type | Selected | Selected | Selected |
Property | Messaging standard = HL7 | ![]() ![]() |
![]() ![]() |
---|---|---|---|
Group Indicator | Empty | Empty | Empty: |
Group Terminator | <CR> | Empty | Empty |
Delimiter | <HL7_FS> | , | Empty |
Suppress Absent Element Delimiters | End of Type | Never | End of Type |
Tag Data Separator | <HL7_FS> | Empty | Empty |
Length of Tag | Empty | Empty | Empty |
Default CCSID | 367 | 367 | 850 |
Trim on input | No Trim | No Trim | Trim Padding Chars |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
Escape Character | Chosen | Not chosen | Chosen |
Quote character | Not chosen | Chosen - " | Not chosen |
Reserved Characters | Empty | , |
Empty |
Decimal Point | . | . | . |
Packed decimal positive code | Not applicable | C | C |
Strict Numeric Checking | Cleared | Cleared | Cleared |
Derive sign from logical type | Not applicable | Selected | Selected |
Default byte order | Not applicable | Big Endian | Big Endian |
Default packed decimal byte order | Not applicable | Big Endian | Big Endian |
Default float format | Not applicable | S390 | S390 |
Text boolean true value | 1 | 1 | 1 |
Text boolean false value | 0 | 0 | 0 |
Text boolean null value | 0 | 0 | 0 |
Binary boolean true value | Not applicable | 00000001 | 00000001 |
Binary boolean false value | Not applicable | 00000000 | 00000000 |
Binary boolean null value | Not applicable | 00000000 | 00000000 |
Derive default dateTime format from logical type | Not chosen | Chosen | Chosen |
Use default DateTime Format1 | Chosen - yyyy-MM-dd'T'HH:mm:ssZZZ | Not chosen - but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen | Not chosen - but yyyy-MM-dd'T'HH:mm:ssZZZ if chosen |
Start of century for 2 digit years | 53 | 53 | 53 |
Days in First Week of Year | Use Broker Locale | Use Broker Locale | Use Broker Locale |
First Day of Week | Use Broker Locale | Use Broker Locale | Use Broker Locale |
Strict Datetime Checking | Selected | Selected | Selected |
Time Zone | Use Broker Locale | Use Broker Locale | Use Broker Locale |
Daylight Savings Time | Cleared | Cleared | Cleared |
Use input UTC format on output | Cleared | Cleared | Cleared |
Output policy for missing elements | UseDefaultValue | UseDefaultValue | UseDefaultValue |
Derive default length from logical type | Selected | Selected | Selected |
Property | Messaging standard = User Defined Text | Messaging standard = SWIFT | Messaging standard = ACORD AL3 |
---|---|---|---|
Data Element Separation | Fixed Length | Tagged Delimited | Fixed Length AL3 |
Group Indicator | Empty | <CR><LF>: | Empty |
Group Terminator | Empty | <CR><LF>- | Empty |
Delimiter | Empty | <CR><LF>: | not applicable |
Suppress Absent Element Delimiters | End of Type | End of Type | End of Type |
Observe Element Length | Selected | Cleared | Selected |
Tag Data Separator | Empty | : | Empty |
Length of Tag | Empty | Empty | Empty |
Length of Encoded Length | not applicable | not applicable | not applicable |
Extra Chars in Encoded Length | not applicable | not applicable | not applicable |
Property | Messaging standard = EDIFACT | Messaging standard = X12 | Messaging standard = TLOG |
---|---|---|---|
Data Element Separation | All Elements Delimited | All Elements Delimited | |
Group Indicator | Empty | Empty | |
Group Terminator | <EDIFACT_GROUP_TERM> | <X12_GROUP_TERM> | |
Delimiter | <EDIFACT_CS> | <X12_CS> | |
Suppress Absent Element Delimiters | End of Type | End of Type | |
Observe Element Length | Cleared | Cleared | Cleared |
Tag Data Separator | <EDIFACT_DATA_SEP> | Empty | Empty |
Length of Tag | Empty | Empty | Empty |
Length of Encoded Length | not applicable | not applicable | not applicable |
Extra Chars in Encoded Length | not applicable | not applicable | not applicable |
Property | Messaging standard = HL7 | Messaging standard = CSV | Messaging standard = User Defined Mixed |
---|---|---|---|
Data Element Separation | All Elements Delimited | All Elements Delimited | Fixed Length |
Group Indicator | Empty | Empty: | Empty |
Group Terminator | <CR> | Empty | Empty |
Delimiter | <HL7_FS> | , | Empty |
Suppress Absent Element Delimiters | End of Type | Never | End of Type |
Observe Element Length | Cleared | Cleared | Selected |
Tag Data Separator | <HL7_FS> | not applicable | Empty |
Length of Tag | Empty | not applicable | Empty |
Length of Encoded Length | not applicable | not applicable | not applicable |
Extra Chars in Encoded Length | not applicable | not applicable | not applicable |