· 5 years ago · Jul 13, 2020, 10:36 AM
1{
2 "name": "liv-inv-list",
3 "title": "LIV Invoice Posting Result",
4 "search": {
5 "url": "",
6 "filters": []
7 },
8 "table": {
9 "name": "liv-inv-list",
10 "paging": true,
11 "search": true,
12 "sortable": true,
13 "checkBoxCol": true,
14 "hideColumn": true,
15 "pageSizeOptions": [
16 10,
17 25,
18 50,
19 100
20 ],
21 "export": {
22 "name": "Liv Posting",
23 "url": "/api/invoices"
24 },
25 "columns": [
26 {
27 "header": "Company Code",
28 "field": "companyCode",
29 "sort": true,
30 "export": true,
31 "hidden": false,
32 "defaultOrder": 1,
33 "active": true,
34 "others": "{}"
35 },
36 {
37 "header": "Vendor Name",
38 "field": "vendorName",
39 "displayMode": 1,
40 "sort": true,
41 "export": true,
42 "hidden": false,
43 "defaultOrder": 2,
44 "active": true,
45 "others": "{}"
46 },
47 {
48 "header": "Vendor Branch Code",
49 "field": "vendorBranchCode",
50 "sort": true,
51 "export": true,
52 "hidden": false,
53 "defaultOrder": 3,
54 "active": true,
55 "others": "{}"
56 },
57 {
58 "header": "LIV Doc Date",
59 "field": "invoiceDate",
60 "type": "date",
61 "pattern": "DD/MM/YYYY",
62 "sort": true,
63 "export": true,
64 "hidden": false,
65 "defaultOrder": 4,
66 "active": true,
67 "others": "{}"
68 },
69 {
70 "header": "Invoice No.",
71 "field": "externalId",
72 "sort": true,
73 "export": true,
74 "hidden": false,
75 "defaultOrder": 5,
76 "requiredColumn": true,
77 "active": true,
78 "others": "{}"
79 },
80 {
81 "header": "Amount (Inc. Tax)",
82 "field": "invoiceTotal",
83 "sortField": "total",
84 "type": "number",
85 "pattern": "#,###.00",
86 "sort": true,
87 "export": true,
88 "hidden": false,
89 "defaultOrder": 6,
90 "active": true,
91 "others": "{}"
92 },
93 {
94 "header": "Reference 1",
95 "field": "referenceField1",
96 "type": "text",
97 "displayMode": 1,
98 "sort": true,
99 "export": true,
100 "hidden": false,
101 "defaultOrder": 7,
102 "active": true,
103 "others": "{}"
104 },
105 {
106 "header": "FI Doc",
107 "field": "buyerPostingDetail.FIDocNumber",
108 "sort": false,
109 "export": true,
110 "hidden": false,
111 "defaultOrder": 8,
112 "active": true,
113 "others": "{}"
114 },
115 {
116 "header": "Company Name",
117 "field": "companyName",
118 "displayMode": 1,
119 "sort": true,
120 "export": true,
121 "hidden": false,
122 "active": true,
123 "others": "{}"
124 },
125 {
126 "header": "Company Branch Code",
127 "field": "companyBranchCode",
128 "sort": true,
129 "export": true,
130 "hidden": false,
131 "active": true,
132 "others": "{}"
133 },
134 {
135 "header": "Company Branch Name",
136 "field": "companyBranchName",
137 "displayMode": 1,
138 "sort": true,
139 "export": true,
140 "hidden": false,
141 "active": true,
142 "others": "{}"
143 },
144 {
145 "header": "Company Tax ID",
146 "field": "companyTaxNumber",
147 "sort": true,
148 "export": true,
149 "hidden": false,
150 "active": true,
151 "others": "{}"
152 },
153 {
154 "header": "Business Place",
155 "field": "businessPlace",
156 "displayMode": 1,
157 "sort": false,
158 "export": true,
159 "hidden": false,
160 "active": true,
161 "others": "{}"
162 },
163 {
164 "header": "Vendor Code",
165 "field": "vendorNumber",
166 "sort": true,
167 "export": true,
168 "hidden": false,
169 "active": true,
170 "others": "{}"
171 },
172 {
173 "header": "Vendor Tax ID",
174 "field": "vendorTaxNumber",
175 "sort": true,
176 "export": true,
177 "hidden": false,
178 "active": true,
179 "others": "{}"
180 },
181 {
182 "header": "PO No.",
183 "field": "purchaseOrderHeaderNumber",
184 "sort": false,
185 "export": true,
186 "hidden": false,
187 "active": true,
188 "others": "{}"
189 },
190 {
191 "header": "Payment Due date",
192 "field": "dueDate",
193 "sortField": "paymentDate",
194 "type": "date",
195 "pattern": "DD/MM/YYYY",
196 "sort": true,
197 "export": true,
198 "hidden": false,
199 "active": true,
200 "others": "{}"
201 },
202 {
203 "header": "Posting Date",
204 "field": "buyerPostingDate",
205 "sortField": "buyerPostingDate",
206 "type": "date",
207 "pattern": "DD/MM/YYYY",
208 "sort": true,
209 "export": true,
210 "hidden": false,
211 "active": true,
212 "others": "{}"
213 },
214 {
215 "header": "Posting Status",
216 "field": "buyerPostingStatus",
217 "sortField": "buyerPostingStatus",
218 "sort": false,
219 "export": true,
220 "hidden": false,
221 "active": true,
222 "others": "{}"
223 },
224 {
225 "header": "Posting Message",
226 "field": "buyerPostingDetail.message",
227 "displayMode": 2,
228 "sort": false,
229 "export": true,
230 "hidden": false,
231 "active": true,
232 "others": "{}"
233 },
234 {
235 "header": "FI Doc Year",
236 "field": "buyerPostingDetail.FIDocFiscalYear",
237 "sort": false,
238 "export": true,
239 "hidden": false,
240 "active": true,
241 "others": "{}"
242 },
243 {
244 "header": "Doc Header Text",
245 "field": "customisedFields.LIV.FIDocHeaderText",
246 "displayMode": 1,
247 "sort": false,
248 "export": true,
249 "hidden": false,
250 "active": true,
251 "others": "{}"
252 },
253 {
254 "header": "LIV Doc",
255 "field": "buyerPostingDetail.LIVDocNumber",
256 "sort": false,
257 "export": true,
258 "hidden": false,
259 "active": true,
260 "others": "{}"
261 },
262 {
263 "header": "Sub Total",
264 "field": "subTotal",
265 "sortField": "subTotal",
266 "type": "number",
267 "pattern": "#,###.00",
268 "sort": true,
269 "export": true,
270 "hidden": false,
271 "active": true,
272 "others": "{}"
273 },
274 {
275 "header": "Tax Total",
276 "field": "vatTotal",
277 "sortField": "vatTotal",
278 "type": "number",
279 "pattern": "#,###.00",
280 "sort": true,
281 "export": true,
282 "hidden": false,
283 "active": true,
284 "others": "{}"
285 },
286 {
287 "header": "Reference 2",
288 "field": "referenceField2",
289 "displayMode": 1,
290 "sort": true,
291 "export": true,
292 "hidden": false,
293 "active": true,
294 "others": "{}"
295 },
296 {
297 "header": "Reference 3",
298 "field": "referenceField3",
299 "displayMode": 1,
300 "sort": true,
301 "export": true,
302 "hidden": false,
303 "active": true,
304 "others": "{}"
305 },
306 {
307 "header": "Reference 4",
308 "field": "referenceField4",
309 "displayMode": 1,
310 "sort": true,
311 "export": true,
312 "hidden": false,
313 "active": true,
314 "others": "{}"
315 },
316 {
317 "header": "Reference 5",
318 "field": "referenceField5",
319 "displayMode": 1,
320 "sort": true,
321 "export": true,
322 "hidden": false,
323 "active": true,
324 "others": "{}"
325 },
326 {
327 "header": "Transfer VAT Message",
328 "field": "customisedFields.vatTransfer.messageText",
329 "displayMode": 2,
330 "sort": false,
331 "export": true,
332 "hidden": false,
333 "active": true,
334 "others": "{}"
335 },
336 {
337 "header": "Transfer VAT Doc",
338 "field": "customisedFields.vatTransfer.accountingDocumentNumber",
339 "sort": false,
340 "export": true,
341 "hidden": false,
342 "active": true,
343 "others": "{}"
344 },
345 {
346 "header": "Transfer VAT Doc Year",
347 "field": "customisedFields.vatTransfer.fiscalYear",
348 "sort": false,
349 "export": true,
350 "hidden": false,
351 "active": true,
352 "others": "{}"
353 },
354 {
355 "header": "Transfer VAT Status",
356 "field": "vatTransferStatus",
357 "sort": false,
358 "export": true,
359 "hidden": false,
360 "active": true,
361 "others": "{}"
362 },
363 {
364 "header": "Transfer VAT Date",
365 "field": "vatTransferUpdatedDate",
366 "type": "date",
367 "pattern": "DD/MM/YYYY",
368 "sort": false,
369 "export": true,
370 "hidden": false,
371 "active": true,
372 "others": "{}"
373 }
374 ]
375 },
376 "form": {
377 "sections": [
378 {
379 "fields": [
380 {
381 "modelName": "liv-inv-list",
382 "fieldId": 102,
383 "fieldIndex": 1,
384 "title": "Invoice No.",
385 "key": "invoiceNumbers",
386 "controlType": "autocomplete",
387 "type": "api",
388 "active": true,
389 "id": 102,
390 "required": false,
391 "apiUrl": "/api/invoices?page=1&pageSize=20&postingStatusNotIn=PENDING&invoiceNumbers=",
392 "displayField": "externalId"
393 },
394 {
395 "modelName": "liv-inv-list",
396 "fieldId": 103,
397 "fieldIndex": 2,
398 "title": "Vendor Name",
399 "key": "vendorName",
400 "controlType": "textbox",
401 "type": "text",
402 "active": true,
403 "id": 103,
404 "required": false
405 },
406 {
407 "modelName": "liv-inv-list",
408 "fieldId": 104,
409 "fieldIndex": 3,
410 "title": "LIV Posting Date",
411 "key": "invoicePostingIsUpdatedDate",
412 "controlType": "textbox",
413 "type": "date",
414 "active": true,
415 "id": 104,
416 "required": false
417 },
418 {
419 "modelName": "liv-inv-list",
420 "fieldId": 105,
421 "fieldIndex": 4,
422 "title": "Status",
423 "key": "postingStatus",
424 "controlType": "dropdown",
425 "type": "option",
426 "active": true,
427 "id": 105,
428 "required": false,
429 "options": [
430 {
431 "text": "Success",
432 "value": "SUCCESS"
433 },
434 {
435 "text": "Fail",
436 "value": "FAILED"
437 }
438 ]
439 },
440 {
441 "modelName": "liv-inv-list",
442 "fieldId": 106,
443 "fieldIndex": 5,
444 "title": "PO No.",
445 "key": "purchaseOrderNumber",
446 "controlType": "textbox",
447 "type": "text",
448 "active": true,
449 "id": 106,
450 "required": false
451 },
452 {
453 "modelName": "liv-inv-list",
454 "fieldId": 107,
455 "fieldIndex": 6,
456 "title": "Company Code",
457 "key": "companyCodes",
458 "controlType": "textbox",
459 "type": "text",
460 "active": true,
461 "id": 107,
462 "required": false
463 },
464 {
465 "modelName": "liv-inv-list",
466 "fieldId": 108,
467 "fieldIndex": 7,
468 "title": "Vendor Code",
469 "key": "vendorCodes",
470 "controlType": "textbox",
471 "type": "text",
472 "active": true,
473 "id": 108,
474 "required": false
475 },
476 {
477 "modelName": "liv-inv-list",
478 "fieldId": 109,
479 "fieldIndex": 8,
480 "title": "Reference No.1",
481 "key": "referenceField1",
482 "controlType": "textbox",
483 "type": "text",
484 "active": true,
485 "id": 109,
486 "required": false
487 }
488 ]
489 }
490 ]
491 }
492 }