TSE_MISC_FLD

(SQL Table)
Index Back

TSE Vchr Misc Chrg Edit Log

# 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 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
4 TSE_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL TSE Run ID
5 TSE_SET_NBR Number(6,0) INTEGER NOT NULL TSE Set Number
6 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
7 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name
8 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
9 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
12 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
13 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
14 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3