Model Electroninc_Data_Interchange

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GTVSCOD	SQL Table	Default
GTVTRTP	SQL Table	Default
GXRETID	SQL Table	Default
GXRTPID	SQL Table	Default

Model View

Table GTVSCOD

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVSCOD_ELEMENT_ID	VARCHAR2(4)	No	*
GTVSCOD_CODE	VARCHAR2(8)	No	*
GTVSCOD_DESC	VARCHAR2(80)	No
GTVSCOD_STANDARD_IND	VARCHAR2(1)	No	*
GTVSCOD_ACTIVITY_DATE	DATE	No
GTVSCOD_USER_ID	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSCOD	Unique	GTVSCOD_ELEMENT_ID
PK_GTVSCOD	Unique	GTVSCOD_CODE
PK_GTVSCOD	Unique	GTVSCOD_STANDARD_IND

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVSCOD_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSCOD_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSCOD_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSCOD	Rely On
GTVSCOD_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSCOD	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSCOD	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSCOD	Rely On
GTVSCOD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVSCOD	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSCOD

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:07:000	04/02/2008 21:17:53:000

Source Code Comments

EDI STANDARD CODE VALIDATION TABLE: This table contains standard EDI codes based on element id and standards organization. This data is used to create cross references to various user defined codes that need to be sent in EDI transactions/messages.

Columns Comments for GTVSCOD_ELEMENT_ID (# 1)

Source Code Comments

EDI STANDARD ELEMENT ID: The numeric identifier associated with the element as defined by the EDI Standards being used.

Columns Comments for GTVSCOD_CODE (# 2)

Source Code Comments

EDI CODE: The EDI Standard code value associated with the Standard being used.

Columns Comments for GTVSCOD_DESC (# 3)

Source Code Comments

EDI CODE DESCRIPTION: The description of the EDI Standard Code.

Columns Comments for GTVSCOD_STANDARD_IND (# 4)

Source Code Comments

EDI STANDARD: A one character code indicating which EDI Standards Organization the code comes from.

Columns Comments for GTVSCOD_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date the row was last updated.

Columns Comments for GTVSCOD_USER_ID (# 6)

Source Code Comments

USER ID: The last user that updated the row.

Table GTVTRTP

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVTRTP_CODE	VARCHAR2(2)	No	*
GTVTRTP_DESC	VARCHAR2(30)	No
GTVTRTP_ACTIVITY_DATE	DATE	No
GTVTRTP_USER_ID	VARCHAR2(30)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVTRTP	Unique	GTVTRTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GORSDAV	SQL Table	S10B80.GENERAL	Join
GXRETID	SQL Table	S10B80.GENERAL	Refer (no action)
GTVTRTP_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVTRTP_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVTRTP_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVTRTP	Rely On
GTVTRTP_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVTRTP	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVTRTP	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVTRTP	Rely On
GTVTRTP	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVTRTP	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVTRTP

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:38:000	04/02/2008 21:17:56:000

Source Code Comments

EDI Transaction Type Code Table.

Columns Comments for GTVTRTP_CODE (# 1)

Source Code Comments

EDI TRANSACTION TYPE CODE: The two character transaction type code assigned to an EDI Transaction/Message.

Columns Comments for GTVTRTP_DESC (# 2)

Source Code Comments

TRANSACTION TYPE DESCRIPTION: The description of the two character transaction type code.

Columns Comments for GTVTRTP_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: The date the column was last updated.

Columns Comments for GTVTRTP_USER_ID (# 4)

Source Code Comments

USER ID: The user id of the last user who updated the column.

Table GXRETID

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GXRETID_TRTP_CODE	VARCHAR2(2)	No	*
GXRETID_TRAN_ID	VARCHAR2(6)	No
GXRETID_STANDARD_IND	VARCHAR2(1)	No
GXRETID_EXTRACT_FILE_NAME	VARCHAR2(15)	No
GXRETID_ACTIVITY_DATE	DATE	No
GXRETID_USER_ID	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GXRETID_TRTP_CODE	GTVTRTP_CODE	GTVTRTP

Index

Index Name	Index Type	Column Name
GXRETID_KEY_INDEX	Unique	GXRETID_TRTP_CODE
GXRETID_KEY_INDEX	Unique	GXRETID_TRAN_ID
GXRETID_KEY_INDEX	Unique	GXRETID_STANDARD_IND

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_CHECKEDIVENDOR	Oracle Package Function	S10B80.BANINST1.FPKSUSP	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GXRETID_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GTVTRTP	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GXRETID

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:49:000	04/02/2008 21:17:54:000

Source Code Comments

EDI Transaction ID Table.

Columns Comments for GXRETID_TRTP_CODE (# 1)

Source Code Comments

EDI TRANSACTION TYPE: The unique two character code that identifies the category of EDI transactions/messages being sent.

Columns Comments for GXRETID_TRAN_ID (# 2)

Source Code Comments

EDI TRANSACTION ID: The three character EDI X12 transaction ID or the six character EDIFACT message ID.

Columns Comments for GXRETID_STANDARD_IND (# 3)

Source Code Comments

EDI STANDARD INDICATOR: A one character code designating the EDI standard that applies (X)12, (E)DIFACT.

Columns Comments for GXRETID_EXTRACT_FILE_NAME (# 4)

Source Code Comments

EDI EXTRACT FILE: The name of the flat file that is created by the Banner EDI process and fed to the EDI translator.

Columns Comments for GXRETID_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date the column was last updated.

Columns Comments for GXRETID_USER_ID (# 6)

Source Code Comments

USER ID: The user id of the last user who updated the column.

Table GXRTPID

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
GXRTPID_PIDM	NUMBER(8,0)	No
GXRTPID_PARTNER_ID	VARCHAR2(15)	No
GXRTPID_STANDARD_IND	VARCHAR2(1)	No
GXRTPID_TRTP_CODE	VARCHAR2(2)	No
GXRTPID_TRAN_ID	VARCHAR2(6)	No
GXRTPID_STATUS_IND	VARCHAR2(1)	No
GXRTPID_CTRL_NO	NUMBER(9,0)	No
GXRTPID_SEND_IND	VARCHAR2(1)	No
GXRTPID_ACTIVITY_DATE	DATE	No
GXRTPID_USER_ID	VARCHAR2(30)	No
GXRTPID_ATYP_CODE	VARCHAR2(2)	Yes
GXRTPID_ADDR_SEQNO	NUMBER(2,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GXRTPID_KEY_INDEX	Unique	GXRTPID_PIDM
GXRTPID_KEY_INDEX	Unique	GXRTPID_ATYP_CODE
GXRTPID_KEY_INDEX	Unique	GXRTPID_ADDR_SEQNO
GXRTPID_KEY_INDEX	Unique	GXRTPID_PARTNER_ID
GXRTPID_KEY_INDEX	Unique	GXRTPID_TRTP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
F_CHECKEDIVENDOR	Oracle Package Function	S10B80.BANINST1.FPKSUSP	Use (select)
GXRTPID	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GXRTPID_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GXRTPID

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:25:000	04/02/2008 21:17:56:000

Source Code Comments

EDI Trading Partner Table.

Columns Comments for GXRTPID_PIDM (# 1)

Source Code Comments

PIDM: The PIDM for whom the Trading Partner record is being created.

Columns Comments for GXRTPID_PARTNER_ID (# 2)

Source Code Comments

TRADING PARTNER ID: A unique ID assigned to the Trading Partner. This must match the id set up in the EDI Software.

Columns Comments for GXRTPID_STANDARD_IND (# 3)

Source Code Comments

EDI STANDARD INDICATOR: A one character code indicating the EDI Standard being used by the Trading Partner.

Columns Comments for GXRTPID_TRTP_CODE (# 4)

Source Code Comments

EDI TRANSACTION TYPE: The two character transaction type being set up for this trading partner. The value must be a valid type set up in GTVTRTP.

Columns Comments for GXRTPID_TRAN_ID (# 5)

Source Code Comments

EDI TRANSACTION ID: The EDI Transaction or Message being used by the Trading Partner.

Columns Comments for GXRTPID_STATUS_IND (# 6)

Source Code Comments

TRANSACTION STATUS INDICATOR: A one character code indicating the status of the transaction. A = Active, I = Inactive, T = Test.

Columns Comments for GXRTPID_CTRL_NO (# 7)

Source Code Comments

NEXT CONTROL #: The next control number available to be assigned to an EDI transaction or message of this type being sent for this Trading Partner.

Columns Comments for GXRTPID_SEND_IND (# 8)

Source Code Comments

SEND INDICATOR: A one character indicator specifying if the Trading Partner transaction or message is to be sent immediately (I) or in batch (B).

Columns Comments for GXRTPID_ACTIVITY_DATE (# 9)

Source Code Comments

ACTIVITY DATE: The date the column was last updated.

Columns Comments for GXRTPID_USER_ID (# 10)

Source Code Comments

USER ID: The user id of the last user who updated the column.

Columns Comments for GXRTPID_ATYP_CODE (# 11)

Source Code Comments

ADDRESS TYPE CODE: The specific address type code associated with the PIDM.

Columns Comments for GXRTPID_ADDR_SEQNO (# 12)

Source Code Comments

ADDRESS SEQUENCE NUMBER: The specific address sequence number associated with the PIDM and Address Type Code.

Link between GXRETID and GTVTRTP

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GXRETID and GTVTRTP (FK1_GXRETID_INV_GTVTRTP_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GXRETID	GXRETID_TRTP_CODE	GTVTRTP_CODE	GTVTRTP	(1,1)-(0,n)