ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBG
1
1. Enter details representing your allocations (Matters) and additonal drop-downs (MatterOnSelects). NOTE: The red columns are required
2
2. The drop-downs next to the Matter field are called "OnSelects". The first OnSelect must be written as OnSelect1=<Entity Type Code> e.g. 'OnSelect1=Dept', the second OnSelect requires the EntityType Code only e.g. 'Project'
e.g. OnSelect1=Depte.g. Project (don't need the 'OnSelect1=')
3
3. Once the entries are complete copy the cells for each feed under the green blocks to the right
MatterOnSelect1MatterOnSelect2
Matter Feed (Copy all cells in this column from row 4 to a text file and save in UTF-8 format with filename: "Matter-<qa or prod>-<customercode>-yyyy-mm-dd-hhmm.txt")
MatterOnSelect Feed (Copy all cells in this column from row 2 to a text file and save in UTF-8 format with filename: "MatterOnSelect-<qa or prod>-<customercode>-yyyy-mm-dd-hhmm.txt")
4
MatterNumberClientNumberParentClientNumberClientNameMatterNameType
RouteIndependent
ClosedDate
GLAccount
Entity1Entity2Entity3
LanguageCode_639-1
LanguageCode_639-2
CurrencyCodeUDF1UDF2UDF3UDF4
UDF1PersonID
UDF2PersonID
UDF3PersonID
ExtraLineItemData1LegalValuesEntityTypeCode
MatterNumber|ClientNumber|ParentClientNumber|ClientName|MatterName|Type|RouteIndependent|ClosedDate|GLAccount|Entity1|Entity2|Entity3|LanguageCode_639-1|LanguageCode_639-2|CurrencyCode|UDF1|UDF2|UDF3|UDF4|UDF1PersonID|UDF2PersonID|UDF3PersonID|ExtraLineItemData1LegalValues|
MatterUniqueID|EntityTypeCode
5
|||||||||||||||||||||||
6
|||||||||||||||||||||||
7
|||||||||||||||||||||||
8
|||||||||||||||||||||||
9
|||||||||||||||||||||||
10
|||||||||||||||||||||||
11
|||||||||||||||||||||||
12
|||||||||||||||||||||||
13
|||||||||||||||||||||||
14
|||||||||||||||||||||||
15
|||||||||||||||||||||||
16
|||||||||||||||||||||||
17
|||||||||||||||||||||||
18
|||||||||||||||||||||||
19
|||||||||||||||||||||||
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100