ACCTLN_ERR_VW3

(SQL View)
 Index Back

TSE Vchr ln Edit Log


SELECT a.business_unit , a.voucher_id , a.voucher_line_num , a.distrib_line_num , a.tse_edit_type , a.tse_fieldname , a.message_set_nbr , a.message_nbr , a.message_parm , a.message_parm2 , a.message_parm3 FROM ps_tse_acctln_fld a WHERE 1 = 1 AND ((EXISTS ( SELECT 'X' FROM PS_DISTRIB_LINE b WHERE a.business_unit = b.business_unit AND a.voucher_id = b.voucher_id AND a.voucher_line_num = b.voucher_line_num AND a.distrib_line_num = b.distrib_line_num AND a.tse_proc_instance = b.process_instance)) OR (NOT EXISTS ( SELECT 'X' FROM PS_DISTRIB_LINE BB WHERE A.BUSINESS_UNIT = BB.BUSINESS_UNIT AND A.VOUCHER_ID = BB.VOUCHER_ID)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
5 TSE_EDIT_TYPE Character(1) VARCHAR2(1) NOT NULL TSE Edit Type
A=Application Edit
D=Date Range Edit
P=Prompt Table Edit
R=Required Field Edit
X=Translate Table Edit
Y=Yes/No Edit
6 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name
7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
8 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
9 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
10 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
11 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3