TSE_JLN_SUS_TMP

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

3 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

4 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.

5 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier

6 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name

7 FIELD_VALUE_NEW Character(30) VARCHAR2(30) NOT NULL New field value
Prompt Table: %EDITTABLE

8 APPLY_2_ALL_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to designate that given SQL data criteria is to apply to all nodes on a given Po
Y/N Table Edit

9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

11 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
3	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
4	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
5	TSE_JOBID	Character(10)	VARCHAR2(10) NOT NULL	TSE Job Identifier
6	TSE_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	TSE Field Name
7	FIELD_VALUE_NEW	Character(30)	VARCHAR2(30) NOT NULL	New field value Prompt Table: %EDITTABLE
8	APPLY_2_ALL_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to designate that given SQL data criteria is to apply to all nodes on a given Po Y/N Table Edit
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular 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