TSE_STG_FLD

(SQL Table)
Index Back

TSE Staging Area Field Log

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
2 TSE_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL TSE Run ID
3 TSE_SET_NBR Number(6,0) INTEGER NOT NULL TSE Set Number
4 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
5 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name
6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
8 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
9 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
10 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID
13 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
14 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
17 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
18 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
19 STAGED_NUM Number(3,0) SMALLINT NOT NULL Staged Number
20 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
21 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
22 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
23 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence