AR_SP_INTFC_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Service Purchase Benefit Plan
3	SP_ID	Number(11,0)	DECIMAL(11) NOT NULL	Service Purchase ID
4	MSG_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
5	MESSAGE_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	Message Sequence
6	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Number
7	EDIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a group has been edited for valid values and control total balance. This field is populated automatically during online data entry and during the Receivables update process. E=Edited N=Not Edited Default Value: N
8	SP_MSG_CD	Character(3)	VARCHAR2(3) NOT NULL	Service Purchase Message Code CNL=Cancel Item CRT=Create Open Item GBA=Goal Balance Attained PAY=Pay an Item REV=Reversal of Payment RFD=Refund Item
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
12	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
13	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
14	MESSAGE_PARM4	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 4