GM_AWD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	INSTID	Character(5)	VARCHAR2(5) NOT NULL	Institution ID
5	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.
6	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID
7	BEGIN_DT	Date(10)	DATE	Begin Date
8	END_DT	Date(10)	DATE	End Date
9	CERTIFY_OFFICIAL	Character(11)	VARCHAR2(11) NOT NULL	Certifying Official
10	SUBMISSION_DATE	Date(10)	DATE	Submission Date
11	INFO_FLD1	Character(30)	VARCHAR2(30) NOT NULL	Information Field 1
12	AMOUNT_1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
13	AMOUNT_2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
14	AMOUNT_3	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
15	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)
16	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.
17	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
18	AS_OF_DATE	Date(10)	DATE	As of Date
19	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
20	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
21	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
22	LOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Letter of Credit
23	REF_AWD_NUMBER	Character(25)	VARCHAR2(25) NOT NULL	Reference Award Number
24	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field
25	COUNT_2	Number(3,0)	SMALLINT NOT NULL	Count Work Field
26	AMT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
27	AMT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
28	AMT3	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
29	AMT4	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
30	AMT5	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
31	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
32	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
33	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
34	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
35	FA_RATE_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	FA_RATE_PCT
36	FA_BASE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	F&A Base Amount
37	AMOUNT_APPLIED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Applied
38	FULL_REVIEW	Character(1)	VARCHAR2(1) NOT NULL	Full Review
39	AMT_REMAIN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remaining Amount
40	AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Remaining
41	AMT_FORECAST	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Forecasted Amount
42	AMT_RECOG	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Recognized Amount