Company table in non-ODBC trading partner database

The wixset.dat file is a fixed-length sequential file that contains one record.

NoteWith non-ODBC, the user cannot create multiple company profiles.

This file is created from the internal wixset table, which the program creates from the entries on the Company window, when the map runs. The location for wixset.dat is the trading partner directory, but for outbound processing you can override this directory location at runtime using the -dw <directory> switch.

Table 3-1: Company table in non-ODBC trading partner database

Name

Type

Width

Description

WIX_COMPANY_NAME

Character

35

Internal application name for the company.

Inbound – Loads the contents of this field into the WIX_COMPANY_NAME system variable.

<filler>

Character

12

Not used.

WIX_GSID

Character

35

Main code used to identify the group level default sender on outbound maps – used only if the SND_GSID field in the trading partner file is blank.

  • Outbound– Loads the contents of this field into the WIX_GSID system variable. If the APP_SEND_CODE system variable is blank, the program loads WIX_GSID into APP_SEND_CODE, then loads APP_SEND_CODE into the following envelope fields:

    • Application Sender’s Code – GS 02

    • Application Sender ID – UNG S006 0040

    • Sending Application – MSH 00004

    • File Sending Application – FHS 00070

    • Batch Sending Application – BHS 00084

  • Inbound – Loads the contents of this field into the WIX_GSID system variable.

WIX_IDQUAL

Character

4

Qualifier that specifies the type of main code used to identify the interchange level default sender on outbound maps – used only if the SND_IDQUAL field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_IDQUAL system variable. If the SEND_QUAL system variable is blank, the program loads WIX_IDQUAL into SEND_QUAL, then loads SEND_QUAL into these envelope fields:

    • Interchange Sender ID Qualifier – ISA 05

    • Interchange Sender ID Code Qualifier – UNB S002 0007

  • Inbound – Loads the contents of this field into the WIX_IDQUAL system variable.

WIX_IDCODE

Character

35

Main code used to identify the interchange level default sender on outbound maps – used only if SND_IDCODE field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_IDCODE system variable. If the SEND_CODE system variable is blank, the program loads WIX_IDCODE into SEND_CODE, then loads SEND_CODE into the following envelope fields:

    • Interchange Sender ID Code – ISA 06

    • Interchange Sender ID – UNB S002 0004

    • Sending Facility – MSH 00003

    • File Sending Facility – FHS 00069

    • Batch Sending Facility – BHS 00083

  • Inbound – Loads the contents of this field into the WIX_IDCODE system variable.

WIX_AUTH_QUAL

Character

2

Qualifier that specifies the type of code used to authenticate the company at the interchange level – used only if the AUTH_QUAL field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_AUTH_QUAL system variable. If the AUTH_QUAL system variable is blank, the program loads WIX_AUTH_QUAL into AUTH_QUAL, then loads AUTH_QUAL into this envelope field:

    Authorization Information Qualifier – ISA 01

  • Inbound – Loads the contents of this field into the WIX_AUTH_QUAL system variable.

WIX_AUTH_CODE

Character

10

Code used to authenticate the company at the interchange level – used only if the AUTH_CODE field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_AUTH_CODE system variable. If the AUTH_CODE system variable is blank, the program loads WIX_AUTH_CODE into AUTH_CODE, then loads AUTH_CODE into this envelope field:

    Authorization Information Qualifier – ISA 02

  • Inbound – Loads the contents of this field into the WIX_AUTH_CODE system variable.

WIX_SECU_QUAL

Character

2

Qualifier that specifies the type of code used to grant the company security clearance at the interchange level – used only if the SECU_QUAL field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_SECU_QUAL system variable. If the SECU_QUAL system variable is blank, the program loads WIX_SECU_QUAL into SECU_QUAL, then loads SECU_QUAL into the following envelope fields:

    • Security Information Qualifier – ISA 03

    • Recipient Reference/Password Qualifier – UNB S005 0025

  • Inbound – Loads the contents of this field into the WIX_SECU_QUAL system variable.

WIX_SECU_CODE

Character

10

Code used to grant the company security clearance at the interchange level – used only if the SECU_CODE field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_SECU_CODE system variable. If the SECU_CODE system variable is blank, the program loads WIX_SECU_CODE into SECU_CODE, then loads SECU_CODE into the following envelope fields:

    • Security Information – ISA 04

    • Recipient Reference/Password – UNB S005 0022

  • Inbound – Loads the contents of this field into the WIX_SECU_CODE system variable.

WIX_SNDR_ROUTE

Character

14

(35 for Syntax 4)

Internal code used to identify the interchange level default sender on outbound maps – used only if the SNDR_ROUTE field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_SNDR_ROUTE system variable. If the SEND_REV_ROUTE system variable is blank, the program loads WIX_SNDR_ROUTE into SEND_REV_ROUTE, then loads SEND_REV_ROUTE into this envelope field:

    Interchange Sender Internal ID – UNB S002 0008

  • Inbound – Loads the contents of this field into the WIX_SNDR_ROUTE system variable.

WIX_SNDR_SUBID

Character

35

Internal sub-code used to identify the interchange level default sender on outbound maps – used only if the SNDR_SUBID field in the trading partner file is blank.

(EDIFACT Syntax 4 only)

  • Outbound – Loads the contents of this field into the WIX_SNDR_SUBID system variable. If the SNDR_SUBID system variable is blank, the program loads WIX_SNDR_SUBID into SNDR_SUBID, then loads SNDR_SUBID into this envelope field:

    Interchange Sender Internal Sub-ID – UNB S002 0042

  • Inbound – Loads the contents of this field into the WIX_SNDR_SUBID system variable.

WIX_APP_SND_QL

Character

4

Qualifier that specifies the type of main code used to identify the group level default sender on outbound maps – used only if the APP_SND_QL field in the trading partner file is blank.

  • Outbound – Loads the contents of this field into the WIX_APP_SND_QL system variable. If the APP_SEND_QUAL system variable is blank, the program loads WIX_APP_SND_QL into APP_SEND_QUAL, then loads APP_SEND_QUAL into this envelope field:

    Application Sender ID/ID Code Qualifier – UNG S006 0007

  • Inbound – Loads the contents of this field into the WIX_APP_SND_QL system variable.