Table B-6 describes the fields in the tradstat.dbf file.
Field name |
Type |
Width |
Notes |
|---|---|---|---|
CUSTNO |
Character |
35 |
Internal identification number for the trading partner |
MAP_TRAN |
Character |
6 |
EDI transaction (message) identifier. |
ST03 |
Character |
35 |
Value to be used as the third element in the transaction on outbound X.12 processing.. |
DIR |
Character |
3 |
Direction or purpose of maps: IN or OUT Direction of transaction map: PRT Print map: CMP Compliance map |
STAT |
Character |
1 |
Transaction mode: Test (T) or Production (P) |
VERS |
Character |
12 |
Version of the EDI Standard used in the map. |
TBCODE |
Character |
60 |
Code used to authenticate the company at the interchange level. |
MBOX NAME |
Character |
35 |
Qualifier that specifies the type of code used to grant the company security clearance at the interchange level. |
DEST |
Character |
100 |
Code used to grant the company security clearance as the receiver at the interchange level. |
FILE |
Character |
30 |
File name of the trading partner mailbox that is used. |
GS_NO |
Character |
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 |
Character |
5 |
EDI standard used by this trading partner in this transaction/message. |
<filler> |
Character |
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 X.12 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. |
