Trading partner table in ODBC trading partner database  Trade agreement table in ODBC trading partner database

Chapter 3: Trading Partner and Log Database Formats

Trade agreement table in non-ODBC trading partner database

The tradstat.dbf file contains trade agreement information for non-ODBC databases, as shown in Table 3-5.

Table 3-5: Trade agreement table in non-ODBC trading partner database

Name

Type

Width

Description

CUSTNO

Character

35

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

MAP_TRAN

Character

6

EDI transaction (message) identifier.

Outbound:

  • Transaction Set Identifier Code – ST 01

  • Message Type – UHH S009 0065

ST03

Character

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

Character

3

Direction/purpose of maps:

  • IN or OUT – Direction of Transaction Map

  • PRT – Print Map

  • CMP – Compliance Map

STAT

Character

1

Transaction mode:

  • T – Test

  • P – Production

  • D – Debug

  • I – Information

  • 1–9

  • Null

Outbound:

  • Indicator – ISA 15

  • TEST INDICATOR – UNB S005 0035

VERS

Character

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

Character

60

Name of the map.

MBOX_NAME

Character

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

Character

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

Character

30

File name of the trading partner mailbox that is used – if EDI Out is checked and only for this trade agreement

GS_NO

Character

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

Character

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

Character

6

Outbound – Service Code List Directory Version Number – UNB S001 0080

<filler>

Character

1

No longer used. (formerly DEL_CODE)

RCV_GSID

Character

35

Main code used to identify the group level override receiver on outbound maps. A value is this field overrides a value in the GSID field of the trading partner table.

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

Character

4

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

Outbound:

  • Interchange Receiver ID Qualifier – ISA 07

  • Interchange Recipient ID Code Qualifier – UNB S003 0007

RCV_IDCODE

Character

35

Main code used to identify the interchange level override receiver on outbound maps. A value in this field overrides the value in the ID_CODE field of the trading partner table.

Outbound:

  • Interchange Receiver ID Code – ISA 08

  • Interchange Receiver ID – UNB S003 0010

  • Receiving Facility – MSH 00005

  • File Receiving Facility – FHS 00071

  • Batch Receiving Facility – BHS 00085

ACK_RQSTD

Character

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

Character

1

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

Outbound:

  • 1 = 997 functional acknowledgement expected

  •     = 997 functional acknowledgement not expected

EDI_OUT

Character

1

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

  • 1 = map EDI data and pass it through

  •     = map EDI data but do not pass it through

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.

Outbound – Application Reference – UNB S005 0026

ACK_MSG

Character

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

Character

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

Character

14

(35 for Syntax 4)

Internal code used to identify the interchange level override sender on outbound 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

Character

35

Internal sub-code used to identify the interchange level override receiver on outbound 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

Character

1

Outbound – Processing Priority Code – UNB S005 0029

COMM_AGM

Character

35

Outbound – Interchange Agreement Identifier – UNB S005 0032

APP_PSWD

Character

14

Outbound – Application Password – UNG S008 0058

ASSOC_CODE

Character

6

Outbound – Association Assigned Code:

  • UNG S008 0057

  • UNH S009 0057

CNT_AG1

Character

3

Outbound – Controlling Agency, Coded:

  • UNG S004 0051

  • UNH S009 0051

CLIST_VER

Character

6

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

MSG_TYPE

Character

6

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

MSG_SUBID

Character

14

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

MSG_SUBVER

Character

3

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

MSG_SUBREL

Character

3

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

CNT_AG2

Character

3

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

MSG_IMPID

Character

14

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

MSG_IMPVER

Character

3

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

MSG_IMPREL

Character

3

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

CNT_AG3

Character

3

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

SCEN_ID

Character

14

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

SCEN_VER

Character

3

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

SCEN_REL

Character

3

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

CNT_AG4

Character

3

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

STD_TYPE

Character

2

The type of standard used in the map:

  • X X12 Standard

  • H HL7 Standard

  • E3 EDIFACT Standard, Syntax 3

  • E4 EDIFACT Standard, Syntax 4

APP_RCV_QL

Character

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

Numeric

10

Unique auto-increment field used to:

  • Update the gs_no control number

  • Prevent simultaneous update of the trade agreement (tradstat) table by multiple users



Copyright © 2004. Sybase Inc. All rights reserved. Trade agreement table in ODBC trading partner database

View this book as PDF