UPG_SSF_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CS_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Field used to indicated wors exist in App Engine
3	SSF_EURO_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Apply Payments by Invoice
4	SSF_PRECONV_INV_ID	Character(22)	VARCHAR2(22) NOT NULL	Pre-conversion Invoice ID
5	SSF_AGREEMENT_NBR	Character(12)	VARCHAR2(12) NOT NULL	Agreement Number
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	SF_PMT_REF_NBR	Character(12)	VARCHAR2(12) NOT NULL	Reference Nbr
8	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
9	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
10	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
11	EC_AUTH_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Authentication Method BDT=Birthdate NID=National ID Number NOA=No Authentication PIN=PIN
12	EC_AUTH_KEY	Character(10)	VARCHAR2(10) NOT NULL	Authentication Key
13	AGREEMENT_TEXT	Long Character	CLOB	Agreement Text
14	AGREEMENT_DT	Date(10)	DATE	Agreement Date
15	SSF_LAST_AGR_NUM	Number(12,0)	DECIMAL(12) NOT NULL	Last Agreement Number
16	ITEM_NBR	Character(15)	VARCHAR2(15) NOT NULL	Item Nbr
17	AMT_REMAINING	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Remaining Amount of Payment
18	APPLIED_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Applied Amount
19	ITEM_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Item Amount
20	LINE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Line Amount
21	SSF_RECORD_CNT	Number(12,0)	DECIMAL(12) NOT NULL	Record Count
22	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit