GTVSCOD GTVTRTP GXRETID GXRTPID

Model Electronic Data Interchange


Model Label : Banner General Electronic Data Interchange (EDI)
Path : Default Folder/B70/General/Electronic_Data_Interchange

List of Objects

Object Name Object Type Layer Name
GTVSCOD TABLE Default
GTVTRTP TABLE Default
GXRETID TABLE Default
GXRTPID TABLE Default

Comments

Model View

''

Table GTVSCOD

Schema Name GENERAL
Label GTVSCOD
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSCOD_ELEMENT_ID GTVSCOD_ELEMENT_ID VARCHAR2(4) No *
GTVSCOD_CODE GTVSCOD_CODE VARCHAR2(8) No *
GTVSCOD_DESC GTVSCOD_DESC VARCHAR2(80) No
GTVSCOD_STANDARD_IND GTVSCOD_STANDARD_IND VARCHAR2(1) No *
GTVSCOD_ACTIVITY_DATE GTVSCOD_ACTIVITY_DATE DATE No
GTVSCOD_USER_ID 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 SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.FTMUOMS.FTVUOMS.FTVUOMS_SCOD_CODE_EDIFACT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.FTMUOMS.FTVUOMS.FTVUOMS_SCOD_CODE_X12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.FTMFOBS.FTVFOBS.FTVFOBS_SCOD_CODE_X12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.FTMFOBS.FTVFOBS.FTVFOBS_SCOD_CODE_EDIFACT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.FTMFOBS.FTVFOBS.FTVFOBS_SCOD_CODE_EDIFACT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.FTMUOMS.FTVUOMS.FTVUOMS_SCOD_CODE_EDIFACT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.FTVFTRM.FTVFTRM.FTVFTRM_SCOD_CODE_EDIFACT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GUACURR.GTVCURR.GTVCURR_SCOD_CODE_ISO Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.FTVFTRM.FTVFTRM.FTVFTRM_SCOD_CODE_X12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.FTMUOMS.FTVUOMS.FTVUOMS_SCOD_CODE_X12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.FTMFOBS.FTVFOBS.FTVFOBS_SCOD_CODE_X12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.FTVFTRM.FTVFTRM.FTVFTRM_SCOD_CODE_EDIFACT Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.FTVFTRM.FTVFTRM.FTVFTRM_SCOD_CODE_X12 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.GUACURR.GTVCURR.GTVCURR_SCOD_CODE_ISO Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.STVNATN.STVNATN.STVNATN_SCOD_CODE_ISO Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.STVNATN.STVNATN.STVNATN_SCOD_CODE_ISO Use(select )
GTVSCOD_C Package cursor S4B70.BANINST1.GB_GTVSCOD Rely on ()
GTVSCOD_C Package cursor S4B70.BANINST1.GB_GTVSCOD Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSCOD Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVSCOD Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSCOD Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVSCOD Rely on ()
GTVSCOD Forms DataBlock BANNER7_FORMS.GTVSCOD Rely on () Use(insert,update,delete,select )
GTVSCOD Forms DataBlock BANNER7_FORMS_10G.GTVSCOD Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVSCOD INDEX S4B70."GENERAL" Rely on ()

Comments

Source Code Comments

EDI STANDARD CODE VALIDATION TABLE: This table contains the standard EDI codes based on element id and standards organization. Data in this table 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

Schema Name GENERAL
Label GTVTRTP
Server name S4B70
Creation Date 09/29/2003 12:04:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVTRTP_CODE GTVTRTP_CODE VARCHAR2(2) No *
GTVTRTP_DESC GTVTRTP_DESC VARCHAR2(30) No
GTVTRTP_ACTIVITY_DATE GTVTRTP_ACTIVITY_DATE DATE No
GTVTRTP_USER_ID 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
GTVTRTP SYNONYM S4B70.PUBLIC Rely on ()
GXRETID TABLE S4B70."GENERAL" Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.FEREDIC.FEREDIC.FEREDIC_TRANS_TYPE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.FEREDIC.FEREDIC.FEREDIC_TRANS_TYPE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GXRETID.GXRETID.GXRETID_TRTP_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GXRETID.GXRETID.GXRETID_TRTP_CODE Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS.GXATPID.GXRTPID Use(select )
POST-QUERY Forms Trigger BANNER7_FORMS_10G.GXATPID.GXRTPID Use(select )
GTVTRTP_C Package cursor S4B70.BANINST1.GB_GTVTRTP Rely on ()
GTVTRTP_C Package cursor S4B70.BANINST1.GB_GTVTRTP Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVTRTP Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVTRTP Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVTRTP Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVTRTP Rely on ()
GTVTRTP Forms DataBlock BANNER7_FORMS.GTVTRTP Rely on () Use(insert,update,delete,select )
GTVTRTP Forms DataBlock BANNER7_FORMS_10G.GTVTRTP Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GTVTRTP INDEX S4B70."GENERAL" Rely on ()

Comments

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

Schema Name GENERAL
Label GXRETID
Server name S4B70
Creation Date 09/29/2003 12:04:37:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GXRETID_TRTP_CODE GXRETID_TRTP_CODE VARCHAR2(2) No *
GXRETID_TRAN_ID GXRETID_TRAN_ID VARCHAR2(6) No
GXRETID_STANDARD_IND GXRETID_STANDARD_IND VARCHAR2(1) No
GXRETID_EXTRACT_FILE_NAME GXRETID_EXTRACT_FILE_NAME VARCHAR2(15) No
GXRETID_ACTIVITY_DATE GXRETID_ACTIVITY_DATE DATE No
GXRETID_USER_ID 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
check_files C/C++ Function [F:\BANNER\C\FEPOEXT.PC] Use()
open_flat_file C/C++ Function [F:\BANNER\C\FEPOEXT.PC] Use()
sel_extract_file C/C++ Function [F:\BANNER\C\FEPOEXT.PC] Use(select )
sel_gxretid C/C++ Function [F:\BANNER\C\FEPOEXT.PC] Use(select )
GXRETID SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.GXATPID.GXRTPID.GXRTPID_TRAN_ID Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GXATPID.GXRTPID.GXRTPID_TRAN_ID Use(select )
GXRETID_GR Forms Record Group BANNER7_FORMS.GXATPID Use(select )
GXRETID_GR Forms Record Group BANNER7_FORMS_10G.GXATPID Use(select )
F_CHECKEDIVENDOR Package function S4B70.BANINST1.FPKSUSP Rely on ()
GXRETID Forms DataBlock BANNER7_FORMS.GXRETID Rely on () Use(insert,update,delete,select )
GXRETID Forms DataBlock BANNER7_FORMS_10G.GXRETID Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GXRETID_KEY_INDEX INDEX S4B70."GENERAL" Rely on ()
GTVTRTP TABLE S4B70."GENERAL" Refer( No Action )

Comments

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

Schema Name GENERAL
Label GXRTPID
Server name S4B70
Creation Date 09/29/2003 12:04:37:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GXRTPID_PIDM GXRTPID_PIDM NUMBER(8,0) No
GXRTPID_PARTNER_ID GXRTPID_PARTNER_ID VARCHAR2(15) No
GXRTPID_STANDARD_IND GXRTPID_STANDARD_IND VARCHAR2(1) No
GXRTPID_TRTP_CODE GXRTPID_TRTP_CODE VARCHAR2(2) No
GXRTPID_TRAN_ID GXRTPID_TRAN_ID VARCHAR2(6) No
GXRTPID_STATUS_IND GXRTPID_STATUS_IND VARCHAR2(1) No
GXRTPID_CTRL_NO GXRTPID_CTRL_NO NUMBER(9,0) No
GXRTPID_SEND_IND GXRTPID_SEND_IND VARCHAR2(1) No
GXRTPID_ACTIVITY_DATE GXRTPID_ACTIVITY_DATE DATE No
GXRTPID_USER_ID GXRTPID_USER_ID VARCHAR2(30) No
GXRTPID_ATYP_CODE GXRTPID_ATYP_CODE VARCHAR2(2) Yes
GXRTPID_ADDR_SEQNO 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
do_edi C/C++ Function [F:\BANNER\C\FGRACTG.PC] Use()
lock_edi_table C/C++ Function [F:\BANNER\C\FGRACTG.PC] Use()
sel_gxrtpid C/C++ Function [F:\BANNER\C\FGRACTG.PC] Use(select )
update_gxrtpid C/C++ Function [F:\BANNER\C\FGRACTG.PC] Use(update )
GXRTPID SYNONYM S4B70.PUBLIC Rely on ()
GET_CONTROL_NUM Forms Trigger BANNER7_FORMS.FPAERSD Use(select )
GET_CONTROL_NUM Forms Trigger BANNER7_FORMS_10G.FPAERSD Use(select )
KEY-COMMIT Forms Trigger BANNER7_FORMS.FPAERSD Use(update )
KEY-COMMIT Forms Trigger BANNER7_FORMS_10G.FPAERSD Use(update )
DELETE_EDI_TP Forms Procedure BANNER7_FORMS.FTMVEND Use(delete )
DELETE_EDI_TP Forms Procedure BANNER7_FORMS_10G.FTMVEND Use(delete )
DELETE_EDI_TP_ADDR Forms Procedure BANNER7_FORMS.FTMVEND Use(delete )
DELETE_EDI_TP_ADDR Forms Procedure BANNER7_FORMS_10G.FTMVEND Use(delete )
SELECT_TP Forms Function BANNER7_FORMS.FTMVEND Use(select )
SELECT_TP Forms Function BANNER7_FORMS_10G.FTMVEND Use(select )
SELECT_TP_ADDR Forms Function BANNER7_FORMS.FTMVEND Use(select )
SELECT_TP_ADDR Forms Function BANNER7_FORMS_10G.FTMVEND Use(select )
GXRTPID Forms DataBlock BANNER7_FORMS.GXQTPID Rely on () Use(insert,update,delete,select )
GXRTPID Forms DataBlock BANNER7_FORMS_10G.GXQTPID Rely on () Use(insert,update,delete,select )
GXRTPID Forms DataBlock BANNER7_FORMS_10G.GXATPID Rely on () Use(insert,update,delete,select )
GXRTPID Forms DataBlock BANNER7_FORMS.GXATPID Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GXRTPID_KEY_INDEX INDEX S4B70."GENERAL" Rely on ()

Comments

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

Caller : GXRETID
Called : GTVTRTP

Link List

Link Type Link Project
Refer( No Action ) Link Foreign Key Between GXRETID and GTVTRTP GENERAL

Link Foreign Key Between GXRETID and GTVTRTP

Caller : GXRETID
Called : GTVTRTP
Link Type : Refer( No Action )
Link : Link Foreign Key Between GXRETID and GTVTRTP

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)

Comments