WM_WO_DWNTME

#	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	RQMT_LN_NBR	Number(5,0)	INTEGER NOT NULL	Requirement Line Number Default Value: 1
5	REASON_DOWNTIME	Character(10)	VARCHAR2(10) NOT NULL	Downtime Reason Prompt Table: WM_DWNTME_RSN Set Control Field: BUSINESS_UNIT_AM
6	PLAN_STARTDT	Date(10)	DATE	Planned Start Date
7	PLAN_ENDDT	Date(10)	DATE	Planned End Date
8	PLAN_DUE_TIME	Time(15)	TIMESTAMP	Planned Due Time
9	PLAN_START_TIME	Time(15)	TIMESTAMP	Planned Due Time
10	EST_DOWN_HOURS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Estimated DownTime Hours
11	ACTL_START_DT	Date(10)	DATE	Actual Start Date
12	ACTL_START_TIME	Time(15)	TIMESTAMP	Actual Start Time
13	ACTL_END_DT	Date(10)	DATE	Actual End Date
14	ACTL_END_TIME	Time(15)	TIMESTAMP	Actual End Time
15	DOWN_HOURS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Downtime Hours
16	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser
17	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %Datetime