Trade agreement table in ODBC trading partner database

CUSTNO

SQL_VARCHAR

35

Internal application identifier for the trading partner, used to link the trading partner (tp) table, trade agreement (tradstat) table, and the application data field that has the attribute “Trading Partner ID.”

MAP_TRAN

SQL_VARCHAR

6

EDI transaction (message) identifier.

Outbound:

• Transaction Set Identifier Code – ST 01

• Message Type – UHH S009 0065

ST03

SQL_VARCHAR

35

Value to be used as the third element in the transaction on outbound X12 processing.

Outbound – Implementation Convention Reference – ST 03

MAP_EXT

CHARACTER

8

Unique map identifier

DIR

SQL_VARCHAR

3

Direction/purpose of maps:

• IN or OUT – direction of Transaction Map

• PRT – print Map

• CMP – compliance Map

STAT

SQL_VARCHAR

1

Transaction mode:

• T – test

• P – production

• I – information

• D – debug

• 1–9

• Null

Outbound:

• Indicator – ISA 15

• TEST INDICATOR – UNB S005 0035

VERS

SQL_VARCHAR

12

Version of EDI Standard used in the map.

Outbound:

• Version/Release/Industry Identifier Code – GS 08

• Message Version Number – UNG S008 0052

• Message Release Number – UNG S008 0054

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 windows and reports. A value in this field overrides a value in the MBOX_NAME field of the trading partner table.

DEST

SQL_VARCHAR

100

Folder/ full-path directory name used to override the trading partner mailbox folder/ full-path directory name – if EDI Out is checked and only for this trade agreement. A value in this field overrides a value in the MAILBOX field of the trading partner table.

FILE

SQL_VARCHAR

30

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

14

Unique functional group control number used with tpkey in outbound maps to quickly retrieve trade agreement records once they have been found.

Outbound:

• Functional Group Header Control Number – GS 06

• GROUP REFERENCE NUMBER – UNG S004 0048

ISA_TYPE

SQL_VARCHAR

5

EDI standard used by this trading partner in this transaction/message.

Outbound:

• Interchange Control Version Number – ISA 12

• Syntax Identifier – UNB S001 0001 (Char 1–4)

• Syntax Version Number–UNB S001 0002 (Char 5)

SERV_CODE

SQL_VARCHAR

6

Outbound – Service Code List Directory Version Number – UNB S001 0080 (EDIFACT Syntax 4 only)

<filler>

SQL_VARCHAR

1

No longer used. (formerly DEL_CODE)

RCV_GSID

SQL_VARCHAR

35

Main code used to identify the group level override receiver on outbound maps.

Outbound:

• Application Receiver Code – GS 03

• Application Recipient ID – UNG S007 0044

• Receiving Application – MSH 00006

• File Receiving Application – FHS 00072

• Batch Receiving Application – BHS 00086

RCV_IDQUAL

SQL_VARCHAR

4

Qualifier that specifies the type of main code used to identify the interchange level override receiver on outbound maps.

Outbound:

• Interchange Receiver ID Qualifier – ISA 07

• Interchange Recipient ID Code Qualifier – UNB S003 0007

RCV_IDCODE

SQL_VARCHAR

35

Main code used to identify the interchange level override receiver on outbound maps.

Outbound:

• Interchange Receiver ID Code – ISA 08

• Interchange receiver ID – UNB S003 0010

• Receiving Application – MSH 00005

• File Receiving Application – FHS 00071

• Batch Receiving Application – BHS 00085

ACK_RQSTD

SQL_VARCHAR

1

Flag that specifies whether an X12 interchange-level TA1 acknowledgement is expected on outbound EDI maps:

• 1 = TA1 acknowledgement expected

•     = TA1 acknowledgement not expected

Outbound:

• Acknowledgement Requested – ISA 14

• ACKNOWLEDGEMENT REQUEST – UNB S005 0031

ACK_RQSTD2

SQL_VARCHAR

1

Flag that specifies whether an X12 group-level 997 functional acknowledgement is expected on outbound EDI maps:

• 1 = 997 functional acknowledgement expected

•    = 997 functional acknowledgement not expected

Outbound:

• Acknowledgement Requested – ISA 14

• ACKNOWLEDGEMENT REQUEST – UNB S005 0031

EDI_OUT

SQL_VARCHAR

1

Flag that specifies if inbound EDI data is to be passed through to a mailbox on inbound maps:

• 1 = map EDI data and pass it through

•     = map EDI data but do not pass it through

DAYS

SQL_VARCHAR

2

“Days” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement, on outbound maps.

HOURS

SQL_VARCHAR

2

“Hours” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement, on outbound maps.

MINUTES

SQL_VARCHAR

2

“Minutes” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement, on outbound maps.

SECONDS

SQL_VARCHAR

2

“Seconds” portion of the time period within which the trading partner expects to receive an interchange-level acknowledgement, on outbound maps.

APPL_REF

SQL_VARCHAR

14

Name of the application messages contained in the EDIFACT UNB envelope.

Outbound – Application Reference – UNB S005 0026

ACK_MSG

SQL_VARCHAR

1

Flag that specifies whether a message-level CONTRL segment (UCM) is generated in response to inbound EDIFACT messages.

• 1 = generate UCM

•     = do not generate UCM

ACK_INTCH

SQL_VARCHAR

1

Flag that specifies whether an interchange-level CONTRL segment (UCI) is generated in response to inbound Edifact messages.

• 1 = generate UCI

•     = do not generate UCI

Outbound – Acknowledgement Request – UNB S005 0031

RCVR_ROUTE

SQL_VARCHAR

14

(35 for Syntax 4)

Internal code used to identify the group level override receiver on outbound maps and override sender on inbound maps. (A value in this field overrides the value in the RCVR_ROUTE field of the trading partner table.)

Outbound – Interchange Receiver Internal ID – UNB S003 0014

RCVR_SUBID

SQL_VARCHAR

35

Internal sub-code used to identify the group level override receiver on outbound maps and override sender on inbound maps. (A value in this field overrides the value in the RCVR_SUBID field of the trading partner table.)

(EDIFACT Syntax 4 only)

Outbound – Interchange Receiver Internal Sub-ID – UNB S003 0046

PROC_PRIOR

SQL_VARCHAR

1

Outbound – Processing Priority Code – UNB S005 0029

COMM_AGM

SQL_VARCHAR

35

Outbound – Interchange Agreement Identifier – UNB S005 0032

APP_PSWD

SQL_VARCHAR

14

Outbound – Application Password – UNG S008 0058

ASSOC_CODE

SQL_VARCHAR

6

Outbound – Association Assigned Code:

• UNG S008 0057

• UNH S009 0057

CNT_AG1

SQL_VARCHAR

3

Outbound – Controlling Agency, Coded:

• UNG S004 0051

• UNH S009 0051

CLIST_VER

SQL_VARCHAR

6

Outbound – Code List Directory Version Number – UNH S009 0110(EDIFACT Syntax 4 only)

MSG_TYPE

SQL_VARCHAR

6

Outbound – Message Type Sub-Function Identifier – UNH S009 0113 (EDIFACT Syntax 4 only)

MSG_SUBID

SQL_VARCHAR

14

Outbound – Message Subset ID – UNH S016 0115 (EDIFACT Syntax 4 only)

MSG_SUBVER

SQL_VARCHAR

3

Outbound – Message Subset Version Number – UNH S016 0116 (EDIFACT Syntax 4 only)

MSG_SUBREL

SQL_VARCHAR

3

Outbound – Message Subset Release Number – UNH S016 0118 (EDIFACT Syntax 4 only)

CNT_AG2

SQL_VARCHAR

3

Outbound – Controlling Agency, Coded – UNH S016 0051 (EDIFACT Syntax 4 only)

MSG_IMPID

SQL_VARCHAR

14

Outbound – Message Implementation Guideline ID –UNH S017 0121 (EDIFACT Syntax 4 only)

MSG_IMPVER

SQL_VARCHAR

3

Outbound – Message Implementation Guideline Version Number – UNH S017 0122 (EDIFACT Syntax 4 only)

MSG_IMPREL

SQL_VARCHAR

3

Outbound – Message Implementation Guideline Release Number – UNH S017 0124 (EDIFACT Syntax 4 only)

CNT_AG3

SQL_VARCHAR

3

Outbound – Controlling Agency, Coded – UNH S017 0051 (EDIFACT Syntax 4 only)

SCEN_ID

SQL_VARCHAR

14

Outbound – Scenario ID – UNH S018 0127 (EDIFACT Syntax 4 only)

SCEN_VER

SQL_VARCHAR

3

Outbound – Scenario Version Number – UNH S018 0128 (EDIFACT Syntax 4 only)

SCEN_REL

SQL_VARCHAR

3

Outbound – Scenario Release Number – UNH S018 0130 (EDIFACT Syntax 4 only)

CNT_AG4

SQL_VARCHAR

3

Outbound – Controlling Agency, Coded – UNH S018 0051 (EDIFACT Syntax 4 only)

STD_TYPE

SQL_VARCHAR

2

The type of standard used in the map:

• X – X12 Standard

• H – L7 Standard

• E3 EDIFACT Standard, Syntax 3

• E4 EDIFACT Standard, Syntax 4

APP_RCV_QL

SQL_VARCHAR

4

Qualifier that specifies the type of main code used to identify the group level override receiver on outbound maps. A value in this field overrides the value in the APP_RCV_QL field of the trading partner table.

Outbound – Application Receiver ID/ID Code Qualifier – UNG S007 0007

TRADKEY

SQL_INTEGER

10

Unique auto-increment field used to:

• Update the gs_no control number

• Prevent simultaneous update of the Trade Agreement database (tradstat table) by multiple users