GM_PROPO_EC_VW2

(SQL View)
 Index Back

Proposal EDI Staging Table2

It is for outbound

SELECT 'PROPOSAL' , 0 , 'O' , %Substring(O.NAME ,1,40) , P.DESCR , O.ADDRESS1 , O.CITY , O.STATE , O.POSTAL , O.COUNTRY , %Substring(O.PHONE,1,12) , '415-967-8876' , '[email protected]' , %Substring(Q.NAME ,1,40) , R.DESCR , Q.ADDRESS1 , Q.CITY , Q.STATE , Q.POSTAL , Q.COUNTRY , %Substring(Q.PHONE ,1,12) , '415-942-8796' , '[email protected]' FROM PS_GM_PROPOSAL A , PS_PERSONAL_DATA O , PS_JOBCODE_TBL P , PS_JOB T , PS_PERSONAL_DATA Q , PS_JOBCODE_TBL R , PS_JOB U , PS_GM_PROP_SUBMISN S WHERE A.PROPOSAL_ID='JOY' AND (S.BUSINESS_UNIT=A.BUSINESS_UNIT AND S.PROPOSAL_ID=A.PROPOSAL_ID AND O.EMPLID=S.ADMIN_OFFICIAL) AND (O.EMPLID=T.EMPLID AND T.JOBCODE=P.JOBCODE) AND (Q.EMPLID=S.SIGN_OFFICIAL) AND (Q.EMPLID=U.EMPLID AND U.JOBCODE=R.JOBCODE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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)
2 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.
3 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
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
5 TITLE Character(35) VARCHAR2(35) NOT NULL Title
6 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
7 CITY3 Character(30) VARCHAR2(30) NOT NULL City
8 STATE3 Character(6) VARCHAR2(6) NOT NULL State
9 POSTAL3 Character(12) VARCHAR2(12) NOT NULL Postal Code
10 COUNTRY3 Character(3) VARCHAR2(3) NOT NULL Country
11 PHONE_DAY Character(12) VARCHAR2(12) NOT NULL Daytime Telephone
12 FAX_NUM Character(12) VARCHAR2(12) NOT NULL Fax Number
13 EMAILID2 Character(70) VARCHAR2(70) NOT NULL Email ID
14 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
15 TITLE_GR Character(56) VARCHAR2(56) NOT NULL Title
16 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
17 CITY4 Character(30) VARCHAR2(30) NOT NULL City
18 STATE4 Character(6) VARCHAR2(6) NOT NULL State
19 POSTAL4 Character(12) VARCHAR2(12) NOT NULL Postal Code
20 COUNTRY4 Character(3) VARCHAR2(3) NOT NULL Country
21 PHONE_EVE Character(12) VARCHAR2(12) NOT NULL Evening Telephone
22 PHONE_FAX Character(12) VARCHAR2(12) NOT NULL Fax Nbr
23 EMAILID3 Character(70) VARCHAR2(70) NOT NULL Email ID