GM_EC_AWD2

(SQL Table)
Index Back

GM Award

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
9 FEDERAL_EIN_GM Character(30) VARCHAR2(30) NOT NULL Federal EIN
10 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID
14 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number
15 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CNTR_SRCH_VW

16 COUNT_2 Number(3,0) SMALLINT NOT NULL Count Work Field
17 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
18 BEGIN_DT Date(10) DATE Begin Date
19 END_DT Date(10) DATE End Date
20 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
21 NAME Character(50) VARCHAR2(50) NOT NULL Name
22 SUBMISSION_DATE Date(10) DATE Submission Date
23 LOC_FLAG Character(1) VARCHAR2(1) NOT NULL Letter of Credit
24 DESCR120 Character(120) VARCHAR2(120) NOT NULL Description