AP_INV_STAT_RES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
2	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
3	PYMNT_SELCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Selection Status C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid Default Value: N
4	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
5	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
6	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
7	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
8	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
10	ERROR_MESSAGE	Character(254)	VARCHAR2(254) NOT NULL	For Standard Journal (SJE)