GM_PROP_EDI_REQ

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)

4 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.

5 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table: GM_PROP_BU_SRCH

7 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
Prompt Table: GM_PROP_ID_SRCH

8 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
Prompt Table: GM_PROP_VN_SRCH

9 AS_OF_DATE Date(10) DATE As of Date

10 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
Prompt Table: GM_SP_FORM3_VW

11 ECOUTGETFLDS_SW Character(1) VARCHAR2(1) NOT NULL Get File Fields SW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
4	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
5	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: GM_PROP_BU_SRCH
7	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID Prompt Table: GM_PROP_ID_SRCH
8	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID Prompt Table: GM_PROP_VN_SRCH
9	AS_OF_DATE	Date(10)	DATE	As of Date
10	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification Prompt Table: GM_SP_FORM3_VW
11	ECOUTGETFLDS_SW	Character(1)	VARCHAR2(1) NOT NULL	Get File Fields SW