The wixset table is created from the entries on the Company ID window and can contain multiple company profiles.
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 |