This page (revision-10) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 10 KB RForbes to previous LMTD INTERFACE FORMAT ==> DATA LOADER IDIF FORMAT
9 26-Nov-2021 10:22 10 KB RForbes to previous | to last Updates based on experiences
8 26-Nov-2021 10:22 9 KB RForbes to previous | to last
7 26-Nov-2021 10:22 9 KB RForbes to previous | to last
6 26-Nov-2021 10:22 9 KB JAiken to previous | to last
5 26-Nov-2021 10:22 9 KB JEscott to previous | to last
4 26-Nov-2021 10:22 9 KB JEscott to previous | to last
3 26-Nov-2021 10:22 8 KB JEscott to previous | to last
2 26-Nov-2021 10:22 8 KB JEscott to previous | to last
1 26-Nov-2021 10:22 2 KB JEscott to last

Page References

Incoming links Outgoing links
DATA LOADER IDIF FORMAT
DATA LOADER IDIF FORMAT

Version management

Difference between version and

At line 5 changed 15 lines
;[Code|??]:This field displays the user-defined Interface code.
;[Interface Type|??]:Please select Not Specified; this is not used for LMTD.
;[File Format|??]:Please select Not Specified; this is not used for LMTD.
;[Form Type|??]:Please select Not Specified; this is not used for LMTD.
;[Description|??]:This is a user-defined description.
;[File Name|??]:This field specifies the default file name.
;[File Creation Number|??]:This field is not used for LMTD.
;[Taxation Level|??]:Please select Not Specified; this is not used for LMTD.
;[Record Number|??]:The 'Rec#' column is always set to '1', unless defining header or trailer records.
;[Field Number|??]:This is a user-assigned number. For delimited files, the sequence of the field number is important, as it identifies each successive field.
;[Name|??]:This field is composed of two parts: a table alias and a column name. For example, DCO.COUNTRY_CODE is a valid field name for a DIF Data Loader interface format. The table alias must be a valid table alias for a Business Class in the HL system. The column name does not need to be valid.
;[XML Tag|??]:This not currently supported for LMTD.
;[Beginning Position|??]:If the source file data is 'Character Delimited', you must specify the Beginning position as '-1'.
;[Ending Position|??]:If the source file data is 'Character Delimited', you must specify the Ending position as '-1'.
;[Field Type|??]:This field is not used for LMTD; defaults to Char.
;[Code|INTERFACE_CODE]:This field displays the user-defined Interface code.
;[Interface Type|INTERFACE_TYPE]:Please select Not Specified; this is not used for LMTD.
;[File Format|FIELD_DELIMITER]:Please select Not Specified; this is not used for LMTD.
;[Form Type|FORM_TYPE]:Please select Not Specified; this is not used for LMTD.
;[Description|DESCRIPTION]:This is a user-defined description.
;[File Name|FILE_NAME]:This field specifies the default file name.
;[File Creation Number|FILE_CREATION_NUMBER]:This field is not used for LMTD.
;[Taxation Level|TAXATION_LEVEL]:Please select Not Specified; this is not used for LMTD.
;[Record Number|RECORD_NUMBER]:The 'Rec#' column is always set to '1', unless defining header or trailer records.
;[Field Number|FIELD_NUMBER]:This is a user-assigned number. For delimited files, the sequence of the field number is important, as it identifies each successive field.
;[Name|FIELD_NAME]:This field is composed of two parts: a table alias and a column name. For example, DCO.COUNTRY_CODE is a valid field name for a DIF Data Loader interface format. The table alias must be a valid table alias for a Business Class in the HL system. The column name does not need to be valid.
;[XML Tag|XML_TAG]:This not currently supported for LMTD.
;[Beginning Position|FIELD_START_BYTE]:If the source file data is 'Character Delimited', you must specify the Beginning position as '-1'.
;[Ending Position|FIELD_END_BYTE]:If the source file data is 'Character Delimited', you must specify the Ending position as '-1'.
;[Field Type|FIELD_TYPE]:This field is not used for LMTD; defaults to Char.
At line 21 changed 10 lines
;[Sort Sequence|??]:This field is not used for LMTD.
;[Format Mask|??]:This field is not used for LMTD.
;[Record Type|??]:Qualify Record, Header Record and Trailer Record are the only options available for LMTD purposes.
;[Record Identifier|??]:This field is not used for LMTD.
;[Constant Value|??]:This field allows you to load a constant value for a specified field.
;[Print Zero Rule|??]:This field is not used for LMTD.
;[XML Tag option|??]:This field is not used for LMTD.
;[Accum Option|??]:This field is not used for LMTD.
;[Total Option|??]:This field is not used for LMTD.
;[Derivation Expression|??]:Supported in release 4.07.14+
;[Sort Sequence|SORT_SEQUENCE]:This field is not used for LMTD.
;[Format Mask|FORMAT_MASK]:This field is not used for LMTD.
;[Record Type|RECORD_TYPE]:Qualify Record, Header Record and Trailer Record are the only options available for LMTD purposes.
;[Record Identifier|RECORD_IDENTIFIER]:This field is not used for LMTD.
;[Constant Value|CONSTANT_VALUE]:This field allows you to load a constant value for a specified field.
;[Print Zero Rule|PRINT_ZERO_RULE]:This field is not used for LMTD.
;[XML Tag option|XML_TAG_OPTION]:This field is not used for LMTD.
;[Accum Option|ACCUM_OPTION]:This field is not used for LMTD.
;[Total Option|TOTAL_OPTION]:This field is not used for LMTD.
;[Derivation Expression|DERIVATION_EXPRESSION]:Supported in release 4.07.14+
This page (revision-10) was last changed on 26-Nov-2021 10:22 by RForbesTop