Table B-5 describes the information included in the tp table. This table is in an ODBC database.
Field name |
Type |
Precision |
Notes |
|---|---|---|---|
CUST NO |
SQL_VARCHAR |
35 |
Internal identifier for the trading partner. |
<filler> |
1 |
Not used |
|
NAME |
SQL_VARCHAR |
35 |
Internal name for the trading partner. |
IDQUAL |
SQL_VARCHAR |
4 |
Qualifier that specifies the type of code used to identify the trading partner at the interchange level—as receiver on outbound maps and sender on inbound maps.. |
IDCODE |
SQL_VARCHAR |
35 |
Code used to identify the trading partner at the interchange level—as the receiver on outbound maps and the sender on inbound maps.. |
AUTH_QUAL |
SQL_VARCHAR |
2 |
Qualifier that specifies the type of code used to authenticate the trading partner at the interchange level. |
AUTH_CODE |
SQL_VARCHAR |
10 |
Code used to authenticate the trading partner at the interchange level. |
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.. |
SECU_CODE |
SQL_VARCHAR |
10 |
Code used to grant security clearance to the trading partner at the interchange level. |
GSID |
SQL_VARCHAR |
35 |
Code used to identify the trading partner at the functional group level—as the receiver on outbound maps and as the sender on inbound maps. |
SHIPQUAL |
SQL_VARCHAR |
2 |
Qualifier that specifies ship-to identification code of the trading partner. |
SHIPIDEN |
SQL_VARCHAR |
15 |
Ship-to identification code of the trading partner. |
BILLQUAL |
SQL_VARCHAR |
2 |
Qualifier that specifies bill-to identification code of the trading partner. |
BILLIDEN |
SQL_VARCHAR |
15 |
Bill-to identification code of the trading partner. |
ADDR1 |
SQL_VARCHAR |
35 |
Street address at which the trading partner is located. |
ADDR2 |
SQL_VARCHAR |
35 |
Additional street address at which the trading partner is located. |
CITY |
SQL_VARCHAR |
19 |
City in which the trading partner is located. |
STATE |
SQL_VARCHAR |
15 |
State in which the trading partner is located. |
COUNTRY |
SQL_VARCHAR |
25 |
Country in which the trading partner is located. |
ZIP |
SQL_VARCHAR |
9 |
Zip code at which the trading partner is located. |
CONTACT1 |
SQL_VARCHAR |
35 |
Name of the trading partner contact. |
TELEPHONE1 |
SQL_VARCHAR |
22 |
Telephone number of the trading partner contact. |
CONTACT2 |
SQL_VARCHAR |
35 |
Name of an additional trading partner contact. |
TELEPHONE2 |
SQL_VARCHAR |
22 |
Telephone number of an additional trading partner contact. |
ISA_IN_NO |
SQL_VARCHAR |
9 |
Interchange-level control reference number for inbound processing |
ISA_OUT_NO |
SQL_VARCHAR |
9 |
Interchange-level control reference number for outbound processing. |
SND_GSID |
SQL_VARCHAR |
35 |
Code used to identify the company at the functional group level—as the sender on outbound maps and as the receiver on inbound maps |
SND_IDQUAL |
SQL_VARCHAR |
4 |
Qualifier that specifies the type of code used to identify the trading partner at the interchange level—as the sender on outbound maps and as the receiver on inbound maps. |
SND_IDCODE |
SQL_VARCHAR |
35 |
Code used to identify the trading partner at the interchange level—as the sender on outbound maps and as the receiver on inbound maps. |
SUB_DELIMT |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default X.12 subelement delimiter. |
ELE_DELIMT |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default X.12 element delimiter. |
SEG_DELIMT |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default X.12 segment delimiter. |
RELEASE_CH |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default X.12 release character. |
X12_REPEAT |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default X.12 repeat character. |
<filler> |
SQL_VARCHAR |
1 |
Not used. (former delete flag for DOS maps) |
EDIF_SUBDL |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default EDIFACT subelement delimiter. |
EDIF_ELEDL |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default EDIFACT element delimiter. |
EDIF_SEGDL |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default EDIFACT segment delimiter. |
EDIF_RELCH |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default EDIFACT release character. |
EDIF_REPEA |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default EDIFACT repeat character. |
HL7_SEGDL |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default HL7 segment delimiter. |
HL7_ELEDL |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default HL7 element delimiter. |
HL7_SUBDL |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default HL7 subelement delimiter. |
HL7_SUBSUB |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default HL7 component delimiter. |
HL7_RELCH |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default HL7 release character. |
HL7_REPEAT |
SQL_VARCHAR |
3 |
Special character used by the trading partner to override the default HL7 repeat character. |
EXPORT_FLG |
SQL_VARCHAR |
1 |
Special character used to designate that flagged trading partner records 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 screens or reports). |
MAILBOX |
SQL_VARCHAR |
100 |
Full-path name of the trading partner mailbox folder, or directory. |
CURR_FMT |
SQL_VARCHAR |
1 |
Character used to indicate whether a period (D) or comma (C) is used as the decimal character. |
POS_LTR |
SQL_VARCHAR |
1 |
Reserved for future use with packed decimal. |
TPKEY |
Numeric |
10 |
Unique auto-increment field |
