TSE_DMND_VW_INV

(SQL View)
Index Back

TSE Demand Field Log View

08/28/04 PWF CN#IN890: Removed SCHED_LINE_NO

SELECT business_unit ,demand_source ,source_bus_unit ,order_no ,order_int_line_no ,sched_line_nbr ,inv_item_id ,demand_line_no ,tse_jobid ,tse_proc_instance ,tse_set_nbr ,tse_edit_type ,tse_fieldname ,message_set_nbr ,message_nbr ,message_parm ,message_parm2 ,message_parm3 FROM PS_TSE_DMND_FLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
10 TSE_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL TSE Run ID
11 TSE_SET_NBR Number(6,0) INTEGER NOT NULL TSE Set Number
12 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
13 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name
14 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
15 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
16 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
17 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2
18 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3