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