WM_WO_TSK_SD

(SQL Table)
Index Back

WO Supplemental Data Store

WO Task Supplemental Data Store

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record
5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 SD_DATE_1 Date(10) DATE Date Field
7 SD_DATE_2 Date(10) DATE Date Field
8 SD_DATE_3 Date(10) DATE Date Field
9 SD_TIME_1 Time(15) TIMESTAMP Time Field
10 SD_TIME_2 Time(15) TIMESTAMP Time Field
11 SD_TEXT4_1 Character(4) VARCHAR2(4) NOT NULL Text
12 SD_TEXT4_2 Character(4) VARCHAR2(4) NOT NULL Text
13 SD_TEXT4_3 Character(4) VARCHAR2(4) NOT NULL Text
14 SD_TEXT4_4 Character(4) VARCHAR2(4) NOT NULL Text
15 SD_TEXT4_5 Character(4) VARCHAR2(4) NOT NULL Text
16 SD_TEXT20_1 Character(20) VARCHAR2(20) NOT NULL Text Field
17 SD_TEXT20_2 Character(20) VARCHAR2(20) NOT NULL Text Field
18 SD_TEXT20_3 Character(20) VARCHAR2(20) NOT NULL Text Field
19 SD_TEXT20_4 Character(20) VARCHAR2(20) NOT NULL Text Field
20 SD_TEXT20_5 Character(20) VARCHAR2(20) NOT NULL Text Field
21 SD_TEXT50_1 Character(50) VARCHAR2(50) NOT NULL Text Field
22 SD_TEXT50_2 Character(50) VARCHAR2(50) NOT NULL Text Field
23 SD_INT_1 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
24 SD_INT_2 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
25 SD_INT_3 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
26 SD_INT_4 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
27 SD_INT_5 Signed Number(10,0) DECIMAL(9) NOT NULL Integer
28 SD_NUM9_1 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
29 SD_NUM9_2 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
30 SD_NUM9_3 Signed Number(11,2) DECIMAL(9,2) NOT NULL Number
31 SD_NUM19_1 Signed Number(21,4) DECIMAL(19,4) NOT NULL Number
32 SD_NUM19_2 Signed Number(21,4) DECIMAL(19,4) NOT NULL Number