IBM BJ0NJML Integration Guide - Page 114

Format of Interface Tables Restricted Columns The HASLD field, which is an internal system column, is excluded from all object structures. Do not include this column in any object structure that is associated with an interface table. The LANGCODE field is also excluded from the predefined object structures. Integration Processing Columns The following table shows the columns that are used in the interface table sequencing, retrieval, and processing. Some columns are in either the interface queue tables or the interface tables; some are in both places. Column Name IFACENAME TRANSID TRANSSEQ EXTSYSNAME ACTION IMPORTMESSAGE TRANSLANGUAGE MESSAGEID IFACETBNAME Interface Queue Tables? Yes Yes No Yes Yes Yes (used inbound only) Yes Yes (used outbound only) Yes (used outbound only) Interface Tables? No Yes Yes No No No No No No IFACENAME Column The IFACENAME column in the interface queue table contains the name of the enterprise service or the publish channel that is used in a transaction. The IFACENAME column is populated in the outbound transactions. For inbound transactions, the external system must populate the column with the enterprise service name or the publish channel name that corresponds to the row that is inserted into an interface table. TRANSID Column The TRANSID column in an interface queue table is a sequential number that uniquely identifies an integration transaction. The TRANSID and the interface table name, identifies a unique transaction. The interface queue table can contain one record with a TRANSID value. The corresponding interface table can have one or more records with the TRANSID, depending on the number of records that are written to that interface table as part of that enterprise service or the publish channel. 100 Integration Guide