PMT_EXCEPT_TBL

(SQL Table)
Index Back

Payment exceptions

Log table for payment exceptions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
3 ERROR_CODE Character(10) VARCHAR2(10) NOT NULL Error Code
4 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)
5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
7 ERROR_DTTM DateTime(26) TIMESTAMP Error DateTime