TRX4090_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
3	END_DATE	Date(10)	DATE	End Date
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
6	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
9	ACCOUNTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Represents the unique alphanumeric identifier for treasury-specific accounting entries.
10	AS_OF_DATE	Date(10)	DATE	As of Date Default Value: %date
11	BEGIN_DT	Date(10)	DATE	Begin Date
12	END_DT	Date(10)	DATE	End Date
13	TR_APPV_STATUS	Character(2)	VARCHAR2(2) NOT NULL	An internal work field that indicates whether a given deal transaction has been approved by a reviewe 01=Authorized 02=Submitted 03=Pending Review 04=Deal Previewed 05=Deal Suspended 06=Deal Approved
14	FROM_DT	Date(10)	DATE	From Date
15	TO_DT	Date(10)	DATE	To Date
16	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
17	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
18	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
19	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
20	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code