Table 3-2: Company table in ODBC trading
partner database
Name
|
Type
|
Precision
|
Description
|
|---|
RECORD_NO
|
SQL_SMALLINT
|
4
|
Unique identifier used to create multiple
profiles for the company.
|
GSID
|
SQL_VARCHAR
|
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 table is blank.
Outbound – Loads the contents
of this field into the WIX_IDQUAL system variable. If the APP_SEND_CODE
system variable is blank, the program loads WIX_IDQUAL
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_IDQUAL system variable.
|
NAME
|
SQL_VARCHAR
|
35
|
Internal application name for the company.
Inbound – Loads the contents of this field into the WIX_COMPANY_NAME
system variable.
|
IDQUAL
|
SQL_VARCHAR
|
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 table 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 the
following envelope fields:
Inbound – Loads the contents of this field
into the WIX_IDQUAL system variable.
|
IDCODE
|
SQL_VARCHAR
|
35
|
Main code used to identify the interchange
level default sender on outbound maps – used only if the SND_IDCODE field
in the trading partner table 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.
|
AUTH_QUAL
|
SQL_VARCHAR
|
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 table 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.
|
AUTH_CODE
|
SQL_VARCHAR
|
10
|
Code used to authenticate the company
at the interchange level, used only if the AUTH_CODE field
in the trading partner table 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.
|
SECU_QUAL
|
SQL_VARCHAR
|
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 table 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:
Inbound – Loads the contents of this field
into the WIX_SECU_QUAL system variable.
|
SECU_CODE
|
SQL_VARCHAR
|
10
|
Code used to grant the company security
clearance at the interchange level – used only if the SECU_CODE field
in the trading partner table is blank.
Outbound – Loads the contents
of this field into the WIX_SECU_CODE. 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:
Inbound – Loads the contents of this field
into the WIX_SECU_CODE system variable.
|
SNDR_ROUTE
|
SQL_VARCHAR
|
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 table 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.
|
SNDR_SUBID
|
SQL_VARCHAR
|
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 table 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.
|
APP_SND_QL
|
SQL_VARCHAR
|
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 table 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 and 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.
|
B_SEND_ID
|
SQL_VARCHAR
|
24
|
Batch sender ID
|
BIN_NUMB
|
SQL_SMALLINT
|
6
|
Bin number
|
PROC_NUMB
|
SQL_VARCHAR
|
10
|
Processing control number
|
SERV_QUAL
|
SQL_VARCHAR
|
2
|
Service provider ID qualifier
|
SERV_ID
|
SQL_VARCHAR
|
15
|
Service provider ID
|
SOFT_ID
|
SQL_VARCHAR
|
10
|
Software/vendor ID
|
