TSE_BCT_FLD

(SQL Table)
Index Back

BCT Transaction Error Log

Transaction errors table

# 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 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
13 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
14 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
15 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
16 LLS_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table.
17 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp