Job Costs Master File

Import File: SVJC0001.CSV (Comma) or SVJC0001.TXT (Tab)
Warehouse File: SV_Job_Costs_IMP_WHSE
Destination File: SV_Job_Costs_WORK (SV000810)

*Indicates validated fields, and must contain data.

**Indicates validated, but can be left empty.

***Indicates validated for non-labor only (Cost Code: 1, 2, 4, 5).

****Indicates validated for labor only (Cost Code: 6, 7, 8, 9, 10).
____ Indicates assigned by Service Management or Microsoft Dynamics GP.
Italic Indicates assigned by Service Management, if empty.

To modify an existing Job Costs WORK record, fill in the proper values for the 'Service Call ID', 'Reference TRX Number', and 'Sequence Number' fields. To add new Job Costs WORK records, leave the 'Reference TRX Number' and 'Sequence Number' fields empty, the next available numbers will automatically be generated.

'Job Name' (10,J) is set to 'Location Name' (26,Z).
'Job Type' (11,K) is set to 'SERVICE'.
'Transaction Source' (21,U) is set to 'MANUAL'.
'Billing Amount' (22,V) is calculated per the Hours and Pay Rate.
'Dynamics Status' (27,AA) is set to 'OPEN'.
'Signature Status' (28,AB) is set to 'OPEN'.
'Batch Number' (29,AC) is set to 'IMPORTED'.

Tab Position (.txt file)	Excel Column (.csv file)	Field Name	Storage Type	Keyable	Storage
1	A	*Service Call ID	String	17	18
2	B	Call Invoice Number	String	17	18
3	C	User ID	String	15	16
4	D	Technician ID	String	15	16
5	E	Technician Team	String	15	16
6	F	** Reference TRX Number	String	17	18
7	G	*Customer Number	String	15	16
8	H	*Address Code	String	15	16
9	I	**Sequence Number	Long Integer	10	4
10	J	Job Name	String	30	32
11	K	Job Type	String	7	8
12	L	*Cost Code	Long Integer	8	4
13	M	Cost Code Description	String	30	32
14	N	Task Code	String	10	12
15	O	Document Type	Drop-Down List	0	2
16	P	Document Amount	Currency	17	10
17	Q	*Document Date	Date	8	4
18	R	Transaction Description	String	30	32
19	S	Billable Check Box	Check Box	1	2
20	T	Taxable	Check Box	1	2
21	U	Transaction Source	String	25	26
22	V	Billing Amount	Currency	14	10
23	W	***Vendor ID	String	15	16
24	X	Vendor Name	String	64	66
25	Y	**Equipment ID	String	10	12
26	Z	Equipment Type	String	30	32
27	AA	Dynamics Status	String	4	6
28	AB	Signature Status	String	4	6
29	AC	Batch Number	String	15	16
30	AD	Batch Source	String	15	16
31	AE	****TRX Hours/Units	Long Integer	6	4
32	AF	****Employee ID	String	15	16
33	AG	Employee Name	String	40	42
34	AH	Voucher Number - WORK	String	17	18
35	AI	OH Amount	Currency	14	10
36	AJ	Extended Cost	Currency	17	10
37	AK	***WS Extended Cost	Currency	14	10
38	AL	TRX QTY	Currency	17	10
39	AM	U Of M	String	8	10
40	AN	Item Number	String	30	32
41	AO	Item Description	String	50	52
42	AP	Unit Price	Currency	17	10
43	AQ	Job Title	String	6	8
44	AR	****Pay Record	String	6	8
45	AS	Pay Rate	Currency	14	10
46	AT	Billing Rate	Currency	14	10
47	AU	Add New Equipment Record	Check Box	1	2
48	AV	New Equipment ID	String	10	12
49	AW	Signature Model Number	String	20	22
50	AX	Signature Serial Number	String	40	42
51	AY	Manufacturer ID	String	15	16
52	AZ	Note Check Box	Check Box	1	2
53	BA	SV Language ID	Integer	2	2
54	BB	Base Currency ID	String	15	16
55	BC	Base Curr Conversion Factor	Currency	14	10
56	BD	Billing Currency ID	String	15	16
57	BE	Billing Curr Conversion Factor	Currency	14	10
58	BF	Local Currency ID	String	15	16
59	BG	Subcontractor Percent	Long Integer	6	4