PA_SP_MSG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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.
3	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Service Purchase Benefit Plan
4	SP_ID	Number(11,0)	DECIMAL(11) NOT NULL	Service Purchase ID
5	MSG_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	INSTALL_NBR	Number(3,0)	SMALLINT NOT NULL	Installment Number
8	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
9	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
10	ENTRY_REASON	Character(5)	VARCHAR2(5) NOT NULL	"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
11	SP_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Service Purchase Amount
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
14	SP_SYSTEM_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Service Purchase Source System AR=Receivables PA=Pension
15	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
16	SP_MSG_RESP	Character(2)	VARCHAR2(2) NOT NULL	Service Purchase Message Code Status 01=Request 02=Success-Pending 03=Success-Item 04=Error 05=Resend 06=Applied
17	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Number
18	EACCT_TRAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Service Purchase Tax Type O=Post-Tax R=Pre-Tax