GM_EC_FORM272 (SQL View)	Index Back
Grants jetform form This is for jetform to know which form it is going to print out.

GM_EC_FORM272

(SQL View)

Grants jetform form

This is for jetform to know which form it is going to print out.

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , BUSINESS_UNIT , CONTRACT_NUM , 'SF272' , PRINTER_PATH , BEGIN_DT , ' ' , PREVIEW_FLAG FROM PS_GM_AWD2_RUN_CNT

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

5 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

6 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

7 PRINTER_PATH Character(80) VARCHAR2(80) NOT NULL Printer Path

8 AS_OF_DATE Date(10) DATE As of Date

9 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

10 PREVIEW_FLAG Character(1) VARCHAR2(1) NOT NULL Preview

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
6	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
7	PRINTER_PATH	Character(80)	VARCHAR2(80) NOT NULL	Printer Path
8	AS_OF_DATE	Date(10)	DATE	As of Date
9	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
10	PREVIEW_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preview