Table B-7 describes the information in the tradstat table in an ODBC database.
Field name |
Type |
Precision |
Notes |
|---|---|---|---|
CUSTNO |
SQL_VARCHAR |
35 |
Internal identification number for the trading partner |
MAP_TRAN |
SQL_VARCHAR |
6 |
EDI transaction (message) identifier. |
ST03 |
SQL_VARCHAR |
35 |
Value to be used as the third element in the transaction on outbound X.12 processing.. |
DIR |
SQL_VARCHAR |
3 |
Direction or purpose of maps: IN or OUT Direction of transaction map: PRT Print map: CMP Compliance map |
STAT |
SQL_VARCHAR |
1 |
Transaction mode: Test (T) or Production (P) |
VERS |
SQL_VARCHAR |
12 |
Version of the EDI Standard used in the map. |
TBCODE |
SQL_VARCHAR |
60 |
Name of the map. |
MBOX_NAME |
SQL_VARCHAR |
35 |
Name of the trading partner mailbox (used only as a label on screens and reports). |
DEST |
SQL_VARCHAR |
100 |
Folder/directory name (full-path) used to override the trading partner mailbox folder/ directory name (full-path). |
FILE |
SQL_VARCHAR |
File name of the trading partner mailbox that is used, if EDI Out is checked and only for this trade agreement. |
|
GS_NO |
SQL_VARCHAR |
9 |
Unique functional group control number used with TPKEY in outbound maps to quickly retrieve trade agreement records once they have been found. |
ISA_TYPE |
SQL_VARCHAR |
5 |
EDI standard used by this trading partner in this transaction/message. |
<filler> |
SQL_VARCHAR |
1 |
No longer used (former delete flag used for DOS maps). |
RCV_GSID |
Character |
35 |
Override code used to identify the trading partner as the receiver at the group level. |
RCV_IDQUAL |
Character |
4 |
Override qualifier that specifies the type of code used to identify the trading partner as the receiver at the interchange level. |
RCV_IDCODE |
Character |
35 |
Override code used to identify the trading partner as the receiver at the interchange level. |
ACK_RQSTD |
Character |
1 |
Flag that specifies whether a TA1 interchange-level acknowledgement is expected on outbound X.12 maps. |
ACK_RQSTD2 |
Character |
1 |
Flag that specifies whether a group-level functional acknowledgement is expected, only on outbound X12 maps. |
EDI_OUT |
Character |
1 |
Flag that specifies if inbound EDI data is to be passed through to a mailbox, only on inbound maps. |
DAYS |
Character |
2 |
“Days” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement. |
HOURS |
Character |
2 |
“Hours” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement. |
MINUTES |
Character |
2 |
“Minutes” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement. |
SECONDS |
Character |
2 |
“Seconds” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement. |
APPL_REF |
Character |
14 |
Name of the application messages contained in the EDIFACT UNB envelope. |
ACK_MSG |
Character |
1 |
Flag that specifies whether a message-level CONTRL segment (UCM) is generated in response to inbound EDIFACT messages. |
ACK_INTCH |
Character |
1 |
Flag that specifies whether an interchange-level CONTRL segment (UCI) is generated in response to inbound EDIFACT messages. |
TRADEKEY |
Numeric |
10 |
Unique auto-increment field. |
