CA_SPNSR_FILE_U

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SPONSOR_ID	Character(15)	VARCHAR2(15) NOT NULL	SPONSOR_ID
3	LOC_REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Letter of Credit ID
4	LOC_DOC_ID	Character(30)	VARCHAR2(30) NOT NULL	Letter of Credit Document ID
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	CA_BEGIN_PERIOD	Date(10)	DATE	Begin Period
7	CA_END_PERIOD	Date(10)	DATE	End Period
8	AUTHORIZED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Authorized Amount
9	DISBURSED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Disbursed Amount
10	AVAILABLE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prepayment Available Amount
11	AMOUNT_1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
12	AMOUNT_2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
13	AMOUNT_3	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
14	LAST_RPT_DTTM	DateTime(26)	TIMESTAMP	Last reported date time
15	DOC_ID_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Loc Doc ID Status A=Active C=Closed I=Inactive O=Open P=Closing
16	EXPECTED_CLOSE_DT	DateTime(26)	TIMESTAMP	Expected Close Date
17	DATE1	Date(10)	DATE	Date
18	DATE2	Date(10)	DATE	Date
19	DATE3	Date(10)	DATE	Date
20	DESCR_LN1	Character(50)	VARCHAR2(50) NOT NULL	Description Line 1
21	DESCR_LN2	Character(50)	VARCHAR2(50) NOT NULL	Description Line 2
22	DESCR_LN3	Character(50)	VARCHAR2(50) NOT NULL	Description Line 3
23	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
24	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
25	DTTM_IMPORT	DateTime(26)	TIMESTAMP	Import From P6 Date/Time
26	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance