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+