TSE_BICOMBO_FLD

(SQL Table)
Index Back

TSE BI Combo Edit 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 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
13 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
14 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
15 ACCT_ENTRY_TYPE Character(3) VARCHAR2(3) NOT NULL Account Entry Type
16 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
17 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
18 LINE_DST_SEQ_NUM Number(3,0) SMALLINT NOT NULL Revenue Sequence Number
19 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority