Company identification (wixset)

The wixset table is created from the entries on the Company ID window and can contain multiple company profiles.

Table B-3: wixset table

Field name

Type

Precision

Notes

RECORD_NO

SQL_SMALLINT

4

Unique identifier used to create multiple profiles for the company.

GSID

SQL_VARCHAR

35

Code used to identify the company at the group level - as the sender on outbound maps and the receiver on inbound maps. Used only if the SND_GSID field in the trading partner table or file is blank.

NAME

SQL_VARCHAR

35

Internal name for the company.

IDQUAL

SQL_VARCHAR

4

Qualifier that specifies the type of code used to identify the company at the interchange level – as the sender on outbound maps and the receiver on inbound maps. This field is used only if the SND_IDQUAL field in the trading partner table or file is blank.

IDCODE

SQL_VARCHAR

35

Code used to identify the company at the interchange level—as the sender on outbound maps and the receiver on inbound maps. This field is used only if the SND_IDCODE field in the trading partner table or file is blank.

AUTH_QUAL

SQL_VARCHAR

2

Qualifier that specifies the type of code used to authenticate the company at the interchange level.

AUTH_CODE

SQL_VARCHAR

10

Code used to authenticate the company at the interchange level.

SECU_QUAL

SQL_VARCHAR

2

Qualifier that specifies the type of code used to grant the company security clearance at the interchange level.

SECU_CODE

SQL_VARCHAR

10

Code used to grant the company security clearance as the receiver at the interchange level