Trading partner table in ODBC trading partner database

The tp file contains trading partner information for ODBC databases as illustrated in Table 3-4.

**Table 3-4: Trading partner table in ODBC trading partner database**
Name	Type	Precision	Description
CUSTNO	SQL_VARCHAR	35	Internal application identifier for the trading partner, used to link the trading partner table (tp), trade agreement (tradstat) table, and the application data field that has the attribute Trading Partner ID
<filler>	SQL_VARCHAR	1	No longer used (formerly TYPE_OWNER)
NAME	SQL_VARCHAR	35	Internal application name for the trading partner
IDQUAL	SQL_VARCHAR	4	Qualifier that specifies the type of main code used to identify the interchange level default receiver on outbound maps and the interchange sender lookup value on inbound maps. (The value in this field will be overridden by a value in the RCV_IDQUAL field of the trade agreement table for outbound processing.) Outbound – Loads the contents of this field into the RECV_QUAL system variable, then loads RECV_QUAL into the following envelope fields: Interchange Receiver ID Qualifier – ISA 07 Interchange Recipient ID Code Qualifier –UNB S003 0007 Inbound – Loads the contents of this field into the SEND_QUAL system variable. When this field is used as part of the trading partner lookup, the program compares the contents of SEND_QUAL with the contents of the following envelope fields: Interchange Sender ID Qualifier – ISA 05 Interchange Sender ID Code Qualifier – UNB S002 0007
IDCODE	SQL_VARCHAR	35	Main code used to identify the interchange level default receiver on outbound maps and default sender on inbound maps. The value in this field is overridden by a value in the RCV_IDCODE field of the trade agreement table for outbound processing. Outbound – Loads the contents of this field into the RECV_CODE system variable, then loads RECV_CODE into the following envelope fields: Interchange Receiver ID Code – ISA 08 Interchange Receiver ID–UNB S003 0010 Receiving Facility – MSH 00005 File Receiving Facility – FHS 00071 Batch Receiving Facility – BHS 00085
IDCODE	SQL_VARCHAR	35	Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the SEND_CODE system variable loaded from these 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
AUTH_QUAL	SQL_VARCHAR	2	Qualifier that specifies the type of code used to authenticate the trading partner at the interchange level. If this field is blank, the program uses the value in the WIX_AUTH_QUAL field in the company table for outbound processing. Outbound – Loads the contents of this field into the AUTH_QUAL system variable, then loads AUTH_QUAL into this envelope field: Authorization Information Qualifier – ISA 01
AUTH_CODE	SQL_VARCHAR	10	Code used to authenticate the trading partner at the interchange level. If this field is blank, the program uses the value in the WIX_AUTH_CODE field in the company table for outbound processing. Outbound – Loads the contents of this field into the AUTH_CODE system variable, then loads AUTH_CODE into the following envelope fields: Authorization Information – ISA 02 Application Password – UNG S005 0058
SECU_QUAL	SQL_VARCHAR	2	Qualifier that specifies the type of code used to grant security clearance to the trading partner at the interchange level. If this field is blank, the program uses the value in the WIX_SECU_QUAL field in the company table for outbound processing. Outbound – Loads the contents of this field into the SECU_QUAL system variable, then loads SECU_QUAL into these envelope fields: Security Information Qualifier – ISA 03 Recipient Reference/Password Qualifier – UNB S005 0025
SECU_CODE	SQL_VARCHAR	10	Code used to grant security clearance to the trading partner at the interchange level. If this field is blank, the program uses the value in WIX_SECU_CODE field in the company table for outbound processing. Outbound – Loads the contents of this field into the SECU_CODE system variable, then loads SECU_CODE into these envelope fields: Security Information – ISA 04 Recipient Reference/Password – UNB S005 0022
GSID	SQL_VARCHAR	35	Main code used to identify the group level default receiver on outbound maps and default sender on inbound maps. Outbound – Loads the contents of this field into the APP_RECV_CODE system variable, then loads APP_RECV_CODE into the following envelope fields: Application Receiver’s Code – GS 03 Application Recipient ID – UNG S007 0044 Receiving Application – MSH 00006 File Receiving Application – FHS 00072 Batch Receiving Application – BHS 00086 Inbound – When this field is part of the trading partner lookup, the program compares contents of this field with the contents of the APP_SEND_CODE system variable, loaded from 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
SHIPQUAL	SQL_VARCHAR	2	Qualifier that specifies Ship To identification code of the trading partner. Outbound – Loads the contents of this field into the SYS_SHIPQUAL system variable, where it is available for use in mapping.
SHIPIDEN	SQL_VARCHAR	15	Ship To identification code of the trading partner. Outbound – Loads the contents of this field into the SYS_SHIPIDEN system variable, where it is available for use in mapping.
BILLQUAL	SQL_VARCHAR	2	Qualifier that specifies Bill To identification code of the trading partner. Outbound – Loads the contents of this field into the SYS_BILLQUAL system variable, where it is available for use in mapping.
BILLIDEN	SQL_VARCHAR	15	Bill To identification code of the trading partner. Outbound – Loads the contents of this field into the SYS_BILLIDEN system variable, where it is available for use in mapping.
ADDR1	SQL_VARCHAR	35	Street address at which the trading partner is located. Outbound – Loads the contents of this field into the SYS_ADDR1 system variable, where it is available for use in mapping.
ADDR2	SQL_VARCHAR	35	Additional street address at which the trading partner is located. Outbound – Loads the contents of this field into the SYS_ADDR2 system variable, where it is available for use in mapping.
CITY	SQL_VARCHAR	19	City in which the trading partner is located. Outbound – Loads the contents of this field into the SYS_CITY system variable, where it is available for use in mapping.
STATE	SQL_VARCHAR	15	State in which the trading partner is located. Outbound – Loads the contents of this field into the SYS_STATE system variable, where it is available for use in mapping.
COUNTRY	SQL_VARCHAR	25	Country in which the trading partner is located. Outbound – Loads the contents of this field into the SYS_COUNTRY system variable, where it is available for use in mapping.
ZIP	SQL_VARCHAR	9	Zip code at which the trading partner is located. Outbound – Loads the contents of this field into the SYS_ZIP system variable, where it is available for use in mapping.
CONTACT1	SQL_VARCHAR	35	Name of the trading partner contact. Outbound – Loads the contents of this field into the CONTACT1 system variable, where it is available for use in mapping.
TELEPHONE1	SQL_VARCHAR	22	Telephone number of the trading partner contact. Outbound – Loads the contents of this field into the TELEPHONE1 system variable, where it is available for use in mapping.
CONTACT2	SQL_VARCHAR	35	Name of an additional trading partner contact. Outbound – Loads the contents of this field into the CONTACT2 system variable, where it is available for use in mapping.
TELEPHONE2	SQL_VARCHAR	22	Telephone number of an additional trading partner contact. Outbound – Loads the contents of this field into the TELEPHONE2 system variable, where it is available for use in mapping.
ISA_IN_NO	SQL_VARCHAR	14	Interchange-level control reference number for inbound processing. Inbound – The program reads the incoming EDI envelope, performs a trading partner lookup to select the map to be run (using criteria specified by the user), writes an entry to the log, then the contents of these envelope fields into the INT_HEAD_NUM system variable: Interchange Control Number – ISA 13 Interchange Control Reference –UNB S004 0020 File Control ID – FHS 0077 The program then also stores the contents of INT_HEAD_NUM in an internal storage area. When the trading partner changes, the program loads the contents of the internal storage location into this field. Users can load an override value into this field on the Mailbox tab of the Trading Partner window.
ISA_OUT_NO	SQL_VARCHAR	14	Interchange-level control reference number for outbound processing. Outbound – The program first looks for a trade agreement match to select the map to be run. Once it finds a match, it increments the value in this field by 1, loads the field contents into the INT_HEAD_NUM system variable, then loads INT_HEAD_NUM into these envelope fields: Interchange Control Number – ISA 13 Interchange Control Reference–UNB S004 0020 File Control ID – FHS 0077 When the trading partner changes during processing, the program increments the value in this field by 1, loads the contents of the field into the INT_HEAD_NUM system variable, and loads INT_HEAD_NUM into the appropriate envelope field. Users can load an override value into this field on the Mailbox tab of the Trading Partner window.
SND_GSID	SQL_VARCHAR	35	Main code used to identify the group level override sender on outbound maps and group receiver lookup value on inbound maps. If this field is blank, the program uses the value in the WIX_IDQUAL field in the company table for outbound processing. Outbound – Loads the contents of this field into the 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 – When this field is part of the trading partner lookup, the program compares contents of this field with the contents of APP_RECV_CODE loaded from the following envelope fields: Application Receiver’s Code – GS 03 Application Recipient ID – UNG S007 0044 Receiving Application – MSH 00006 File Receiving Application – FHS 00072 Batch Receiving Application – BHS 00086
SND_IDQUAL	SQL_VARCHAR	4	Qualifier that specifies the type of main code used to identify the interchange level override sender on outbound maps and interchange receiver lookup value on inbound maps. If this field is blank, the program uses the value in the WIX_IDQUAL field of the company table for outbound processing. Outbound – Loads the contents of this field into the SEND_QUAL system variable, then loads SEND_QUAL into the following envelope fields: Interchange Sender ID Qualifier – ISA 05 Interchange Sender ID Code Qualifier – UNB S002 0007 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the RECV_QUAL system variable, loaded from the following envelope fields: Interchange Receiver ID Qualifier – ISA 07 Interchange Recipient ID Code Qualifier – UNB S003 0007
SND_IDCODE	SQL_VARCHAR	35	Main code used to identify the interchange level override sender on outbound maps and interchange receiver lookup value on inbound maps. If this field is blank, the program uses the value in the WIX_IDCODE field of the company table for outbound processing. Outbound – Loads the contents of this field into the SEND_CODE, then loads SEND_CODE into the following envelope fields: Interchange Sender ID Code – ISA 06 Interchange ID – UNB S002 0004 Sending Facility – MSH 00003 File Sending Facility – FHS 00069 Batch Sending Facility – BHS 00083 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of RECV_CODE, loaded from the following envelope fields: Interchange Receiver ID Code – ISA 08 Interchange Receiver ID – UNB S003 0010 Receiving Facility – MSH 00005 File Receiving Facility – FHS 00071 Batch Receiving Facility – BHS 00085
SUB_DELIMT	SQL_VARCHAR	3	Special character used by the trading partner to override the default X12 sub-element delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
ELE_DELIMT	SQL_VARCHAR	3	Special character used by the trading partner to override the default X12 element delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
SEG_DELIMT	SQL_VARCHAR	3	Special character used by the trading partner to override the default X12 segment delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
RELEASE_CH	SQL_VARCHAR	3	Special character used by the trading partner to override the default X12 release character. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
X12_REPEAT	SQL_VARCHAR	3	Special character used by the trading partner to override the default X12 repeat character. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. IfIf not, it uses a default value.
<filler>	SQL_VARCHAR	1	No longer used. (formerly DEL_CODE)
EDIF_SUBDL	SQL_VARCHAR	3	Special character used by the trading partner to override the default EDIFACT sub-element delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
EDIF_ELEDL	SQL_VARCHAR	3	Special character used by the trading partner to override the default EDIFACT element delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
EDIF_SEGDL	SQL_VARCHAR	3	Special character used by the trading partner to override the default EDIFACT segment delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
EDIF_RELCH	SQL_VARCHAR	3	Special character used by the trading partner to override the default EDIFACT release character. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
EDIF_REPEA	SQL_VARCHAR	3	Special character used by the trading partner to override the default EDIFACT repeat character. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
HL7_SEGDL	SQL_VARCHAR	3	Special character used by the trading partner to override the default HL7 segment delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
HL7_ELEDL	SQL_VARCHAR	3	Special character used by the trading partner to override the default HL7 element delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
HL7_SUBDL	SQL_VARCHAR	3	Special character used by the trading partner to override the default HL7 sub-element delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
HL7_SUBSUB	SQL_VARCHAR	3	Special character used by the trading partner to override the default HL7 component delimiter. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
HL7_RELCH	SQL_VARCHAR	3	Special character used by the trading partner to override the default HL7 release character. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
HL7_REPEAT	SQL_VARCHAR	3	Special character used by the trading partner to override the default HL7 repeat character. Outbound – If there is a value in this field, the program uses it to create outbound EDI data. If not, it uses a default value.
EXPORT_FLAG	SQL_VARCHAR	1	Special character used to designate that flagged trading partner records can be moved from one database to another.
MBOX_NAME	SQL_VARCHAR	35	Internal name of the trading partner mailbox – used only as a label on windows or reports. The value in this field can be overridden by a value in the MBOX_NAME field in the trade agreement table.
MAILBOX	SQL_VARCHAR	100	Full-path name of the trading partner mailbox folder, or directory. The value in this field can be overridden by a value in the dest field in the trade agreement table.
CURR_FMT	SQL_VARCHAR	1	Character used to indicate whether a period or comma is used as the decimal character C – comma decimal character D – period decimal character
POS_LTR	SQL_VARCHAR	1	Reserved for future use with packed decimal.
SNDR_ROUTE	SQL_VARCHAR	14 (35 for Syntax 4)	Internal code used to identify the interchange level override sender on outbound maps and interchange receiver lookup value on inbound maps. Outbound – Loads the contents of this field into the SNDR_ROUTE system variable, then loads SNDR_ROUTE into this envelope field: Interchange Sender Internal ID – UNB S002 0008 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the RCVR_ROUTE system variable, loaded from this envelope field: Interchange Receiver Internal ID – UNB S003 0014
SNDR_SUBID	SQL_VARCHAR	35	Internal sub-code used to identify the interchange level override sender on outbound maps and interchange receiver lookup value on inbound maps. (EDIFACT Syntax 4 only) Outbound – Loads the contents of this field into the SNDR_SUBID system variable, then loads SNDR_SUBID into this envelope field: Interchange Sender Internal Sub-ID – UNB S002 0042 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the RCVR_SUBID system variable, loaded from this envelope field: Interchange Receiver Internal Sub-ID – UNB S003 0046
RCVR_ROUTE	SQL_VARCHAR	14 (35 for Syntax 4)	Internal code used to identify the interchange level default receiver on outbound maps and interchange sender lookup value on inbound maps. Outbound – Loads the contents of this field into the RCVR_ROUTE system variable, and contents of RCVR_ROUTE into this envelope field: Interchange Receiver Internal ID – UNB S003 0014 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the SNDR_ROUTE system variable, loaded from this envelope field: Interchange Sender Internal ID – UNB S002 0008
RCVR_SUBID	SQL_VARCHAR	35	Internal sub-code used to identify the interchange level default receiver on outbound maps and interchange sender lookup value on inbound maps. Outbound – Loads the contents of this field into the RCVR_SUBID system variable, then loads RCVR_SUBID into this envelope field: Interchange Receiver Internal Sub-ID – UNB S003 0046 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the SNDR_SUBID system variable, loaded from this envelope field: Interchange Sender Internal Sub-ID-UNB S002 0042
APP_SND_QL	SQL_VARCHAR	4	Qualifier that specifies type of code used to identify the group level override sender on outbound maps and group receiver lookup value on inbound maps. Outbound – Loads the contents of this field into the APP_SEND_QUAL system variable, then loads APP_SEND_QUAL into this envelope field: Application Sender ID/ID Code Qualifier – UNG S006 0007 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the APP_RECV_QUAL system variable, loaded from this envelope field: Application Recipient ID/ID Code Qualifier – UNG S007 0007
APP_RCV_QL	SQL_VARCHAR	4	Qualifier that specifies the type of main code used to identify the group level default receiver on outbound maps and group sender lookup value on inbound maps. Outbound – Loads the contents of this field into the APP_RECV_QUAL system variable, then loads APP_RECV_QUAL into this envelope field: Application Recipient ID/ID Code Qualifier – UNG S007 0007 Inbound – When this field is part of the trading partner lookup, the program compares the contents of this field with the contents of the APP_SEND_QUAL system variable, loaded from this envelope field: Application Sender ID/ID Code Qualifier – UNG S006 0007
B_SEND_ID	SQL_VARCHAR	24	Batch sender ID
B_RECV_ID	SQL_VARCHAR	24	Batch receiver ID
BIN_NUMB	SQL_INTEGER	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
ACK_TYPE	SQL_VARCHAR	1	Acknowledgement flag
TPKEY	SQL_INTEGER	10	Unique auto-increment field used to: Update the ISA_IN_NO and ISA_OUT_NO control numbers Prevent simultaneous update of the trading partner database by multiple users