GetPoints

Input XML Tags

XML Tag	Column Name	Data Type	Nullable	Definition
comcorp	5 digit field	INT UNSIGNED	N	Five digit accounting corp number assigned to each corp
house	6 character field	CHAR(6)	N	House number. Numeric only
optn	short	short	N	Option. Vaild Values 1,7,8 (1=read task code table, use for WIP orders, 7=read T/C problem code table, 8=read SRO problem code table)
outletgroup				outletgroup beginning delimiter
outlet				outlet beginning delimiter
wo_outlet	2 digit field	SHORT	N	Outlet number. Valid Values: 1-60
taskcode group				taskcodegroup beginning delimiter
taskcode				taskcode beginning delimiter
wo_taskcode	2 character field	CHAR(2)	N	task code associated with this charge level.
wo_taskcount	1 character field	CHAR(2)	N	task code count used for custom codes 11,22,33,44,55 valid values are 1-9
/taskcode				taskcode ending delimiter
/taskcode group				taskcodegroup ending delimiter
/outlet				outlet ending delimiter
/outletgroup				outletgroup ending delimiter

XML Tag	Column Name	Data Type	Nullable	Definition
comcorp	5 digit field	INT UNSIGNED	N	Five digit accounting corp number assigned to each corp
house	6 character field	CHAR(6)	N	House number. Numeric only
cust	2 character field	CHAR(2)	N	Customer number. Numeric values only.
outletgroup				outletgroup beginning delimiter
outlet				outlet beginning delimiter
wo_outlet	2 digit field	SHORT	N	Outlet number. Valid Values: 1-60
taskcodegroup				taskcodegroup beginning delimiter
taskcode				taskcode beginning delimiter
wo_taskcode	2 digit numeric	CHAR(2)	N	This field is populated with the task code associated with the rate code defined in Director maintenance
wo_pts	short	short	N	This field is populated with the points associated with the wo_tasks set in director maintenance option 20
taskcode				taskcode ending delimiter
/taskcodegroup				taskcodegroup ending delimiter
subtotal wo_pts	short	short	N	this field is populated with the total points of the outlet
outlet_hours	6 character field	CHAR(6)	N	this field is populated with the total hours of the outlet
/outlet				outlet ending delimiter
/outletgroup				outletgroup ending delimiter
total wo_pts	short	short	N	this field is populated with the total points of the entire account including the travel points
total_travel	short	short	N	this field is populated with the travel points
total_hours	6 character field	CHAR(6)	N	this field is populated with the total hours of the entire account including the travel points