RF_SO_LINE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number.
4	ACTIVITY_CODE	Character(8)	VARCHAR2(8) NOT NULL	Activity Code which identifies the specific Activities which will be performed as part of Service Orders. Prompt Table: RF_ACT_CODE_VW3
5	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
6	APPROVAL_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field specifies whether the approval is required for the activity. N=No Y=Yes
7	EST_SERVICE_TIME	Number(8,2)	DECIMAL(7,2) NOT NULL	Estimated time that it will take to perform a service.
8	DISPLAY_ORDER	Number(3,0)	SMALLINT NOT NULL	Display order for ordering items in a list - web style
9	APPROVED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to determine if approval is required for this inventory item. A=Approved P=Pending
10	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
11	APPROVAL_DT	Date(10)	DATE	Date of Approval
12	SOACTIVITY_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Service Order Activity (line) Status. CAN=Canceled CLO=Closed COM=Completed OAC=Accepted OER=En Route OHA=Hold Assignment OHC=Hold Customer OHP=Hold Part OOS=On Site OPA=Assigned ORJ=Rejected Default Value: OHA
13	SOACT_PRIORITY	Character(3)	VARCHAR2(3) NOT NULL	The priority of the service order activity (a.k.a. line). HIH=High LOW=Low NOR=Normal URG=Urgent
14	START_DT	Date(10)	DATE	Start date field to store start date value.
15	START_TIME	Time(15)	TIMESTAMP	Start of Shift
16	END_DT	Date(10)	DATE	This field stores the end date values.
17	END_TIME	Time(15)	TIMESTAMP	End of Shift
18	EST_START_DT	Date(10)	DATE	Estimated date that a service activity will be started.
19	EST_START_TIME	Time(15)	TIMESTAMP	Estimated time that a service activity will be started.
20	EST_END_DT	Date(10)	DATE	Estimated date that a service activity will be finished.
21	EST_END_TIME	Time(15)	TIMESTAMP	Estimated time that a service activity will be finished.
22	ACT_START_DATE	Date(10)	DATE	Actual start date recorded for a service activity.
23	ACT_START_TIME	Time(15)	TIMESTAMP	Actual start time recorded for a service activity.
24	ACT_END_DATE	Date(10)	DATE	Actual end date recorded for a service activity.
25	ACT_END_TIME	Time(15)	TIMESTAMP	Actual end time recorded for a service activity.
26	COMPLETION_DATE	Date(10)	DATE	Completion Date
27	TOTAL_ACT_TIME	Number(8,2)	DECIMAL(7,2) NOT NULL	This field is used to store the total actual time.
28	BILLABLE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This is used to determine of the item under consideration is billable or not. N=No Y=Yes Y/N Table Edit
29	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
30	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
31	MATERIAL_HDR	Character(8)	VARCHAR2(8) NOT NULL	Header ID used when recording item usage on a service order.
32	LINE_OID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Line Object ID
33	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
34	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
35	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
36	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
37	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
38	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
39	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RF_PROVIDER_GRP