The following reviews what should be defined in IDIF when creating an interface format to be used to load an external file using LMTD.
Define Interface Format (IDIF)#
- 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.
- Variable Name
- This field is not used for LMTD.
- 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+
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation