Trading partner file in non-ODBC trading partner database

The customer.dbf file contains trading partner information for non-ODBC databases as shown in Table 3-3.

**Table 3-3: Trading partner file in non-ODBC trading partner database**
Name	Type	Width	Description
CUSTNO	Character	35	Internal application identifier for the trading partner, used to link the trading partner table (customer.dbf), trade agreement (tradstat.dbf) table, and the application data field that has the attribute “Trading Partner ID”.
<filler>	Numeric	1	No longer used (formerly TYPE_OWNER).
NAME	Character	35	Internal application name for the trading partner.
IDQUAL	Character	4	Qualifier that specifies the type of main code used to identify the interchange level default receiver on outbound maps. (The value in this field is 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_EQUAL system variable, then loads RECV_EQUAL into these envelope fields: Interchange Receiver ID Qualifier – ISA 07 Interchange Recipient ID Code Qualifier – UNB S003 0007
IDCODE	Character	35	Main code used to identify the interchange level default receiver on outbound 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
AUTH_QUAL	Character	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 of the company file 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	Character	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 of the company file 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 S008 0058
SECU_QUAL	Character	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 of the company file for outbound processing. Outbound – Loads the contents of this field into the SECU_QUAL system variable, then loads SECU_QUAL into the following envelope fields: Security Information Qualifier – ISA 03 Recipient Reference/Password Qualifier – UNB S005 0025
SECU_CODE	Character	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 the WIX_SECU_CODE field of the company file 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	Character	35	Main code used to identify the group level default receiver on outbound maps and the group sender lookup value on inbound maps. The value in this field is overridden by a value in the RCV_GSID field of the trade agreement table for outbound processing. 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 the 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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	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	Character	14	Interchange-level control reference number for inbound processing. Inbound – To eliminate unnecessary processing time, the program updates this field only when the trading partner changes. The program reads the incoming EDI envelope, performs a trading partner lookup to select the map to 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 00077 The program also stores the contents of the INT_HEAD_NUM system variable in an internal storage location at this time. 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 General tab of the Trading Partner window.
ISA_OUT_NO	Character	14	Interchange-level control reference number for outbound processing. Outbound – To eliminate unnecessary updates during processing, the program updates the value in this field initially and then only when the trading partner changes. The program performs the internal update when it looks for a trade agreement match to select the map to be run. When it finds a match, it increments the value in this field by 1, loads the contents of the field 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 00077 Whenever the trading partner changes during processing, the program again 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 General tab of the Trading Partner window.
SND_GSID	Character	35	Main code used to identify the group level override receiver on outbound maps and the group receiver lookup value on inbound maps. If this field is blank, the program uses the value in the WIX_IDQUAL field of the company file for outbound processing. Outbound – Loads the contents of this field into the APP_SEND_CODE system variable, 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 the contents of this field with the contents of the APP_RECV_CODE system variable, 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	Character	4	Qualifier that specifies the type of main code used to identify the interchange level override sender on outbound maps. If this field is blank, the program uses the value in the WIX_IDQUAL field of the company file 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
SND_IDCODE	Character	35	Main code used to identify the interchange level override sender on outbound maps. (If this field is blank, the program uses the value in the WIX_IDCODE field of the company file for outbound processing.) Outbound – Loads the contents of this field into the SEND_CODE system variable, 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
SUB_DELIMT	Character	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 X12 data. If not, it uses a default value.
ELE_DELIMT	Character	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 X12 data. If not, it uses a default value.
SEG_DELIMT	Character	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 X12 data. If not, it uses a default value.
RELEASE_CH	Character	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 X12 data. If not, it uses a default value.
X12_REPEATS	Character	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 X12 data. If not, it uses a default value.
<filler>	Character	1	No longer used. (formerly DEL_CODE)
EDIF_SUBDL	Character	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 EDIFACT data. If not, it uses a default value.
EDIF_ELEDL	Character	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 EDIFACT data. If not, it uses a default value.
EDIF_SEGDL	Character	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 EDIFACT data. If not, it uses a default value.
EDIF_RELCH	Character	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 EDIFACT data. If not, it uses a default value.
EDIF_REPEA	Character	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 EDIFACT data. If not, it uses a default value.
HL7_SEGDL	Character	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 HL7 data. If not, it uses a default value.
HL7_ELEDL	Character	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 HL7 data. If not, it uses a default value.
HL7_SUBDL	Character	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 HL7 data. If not, it uses a default value.
HL7_SUBSUB	Character	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 HL7 data. If not, it uses a default value.
HL7_RELCH	Character	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 HL7 data. If not, it uses a default value.
HL7_REPEAT	Character	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 HL7 data. If not, it uses a default value.
EXPORT_FLAG	Character	1	Special character used to designate that flagged trading partner records can be moved from one database to another.
MBOX_NAME	Character	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	Character	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	Character	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	Character	1	Reserved for future use with packed decimal.
SNDR_ROUTE	Character	14 (35 for Syntax 4)	Internal code used to identify the interchange level override sender on outbound maps. Outbound – Loads the contents of this field into the SEND_REV_ROUTE system variable, then loads SEND_REV_ROUTE into this envelope field: Interchange Sender Internal ID – UNB S002 0008
SNDR_SUBID	Character	35	Internal sub-code used to identify the interchange level override sender on outbound 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
RCVR_ROUTE	Character	14 (35 for Syntax 4)	Internal code used to identify the interchange level default receiver on outbound maps. Outbound – Loads the contents of this field into the RCVR_ROUTE system variable, then loads RCVR_ROUTE into this envelope field: Interchange Receiver Internal ID – UNB S003 0014
RCVR_SUBID	Character	35	Internal sub-code used to identify the interchange level default receiver on outbound maps. (EDIFACT Syntax 4 only) 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
APP_SND_QL	Character	4	Qualifier that specifies the type of main code used to identify the group level override sender on outbound maps. (If this field is blank, the program uses the value in the WIX_APP_SND_QL field of the company file for outbound processing.) 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
APP_RCV_QL	Character	4	Qualifier that specifies the type of main code used to identify the group level default receiver on outbound maps. (The value in this field will be overridden by a value in the app_rcv_ql field of the trade agreement table for outbound processing.) 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
B_SEND_ID	Character	24	Batch sender ID
BIN_NUMB	Integer	6	Bin number
PROC_NUMB	Character	10	Processing control number
SERV_QUAL	Character	2	Service provider ID qualifier
SERV_ID	Character	15	Service provider ID
SOFT_ID	Character	10	Software/vendor ID
ACK_TYPE	Character	1	Acknowledgement flag
TPKEY	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