Retrieve all transaction types

Shell - curl
1

200
application/json
1[
2  {
3    "id": 103401,
4    "createdBy": "videmo",
5    "createdAt": "2023-06-30T15:38:17.241Z",
6    "lastUpdatedBy": "videmo",
7    "lastUpdatedAt": "2023-06-30T15:38:17.241Z",
8    "label": "Business Transactions",
9    "localizedLabels": [
10      {
11        "id": 103618,
12        "createdBy": "videmo",
13        "createdAt": "2023-06-30T15:38:17.246Z",
14        "lastUpdatedBy": "videmo",
15        "lastUpdatedAt": "2023-06-30T15:38:17.246Z",
16        "label": "Business Transactions",
17        "version": 0,
18        "localeCd": "en-US"
19      }
20    ],
21    "name": "business_transactions",
22    "dataStoreName": "FINANCE_STORE",
23    "dataStoreDefaultSchemaName": "finance",
24    "tableName": "business_transactions",
25    "systemReserved": false,
26    "version": 0,
27    "dataStoreAssignedTimeZone": "Etc/UTC",
28    "solutionName": "sas_visual_investigator_default",
29    "solutionLabel": "SAS Visual Investigator",
30    "fromObjectName": "business_account",
31    "toObjectName": "business_customers",
32    "fromObjJoinCondition": {
33      "type": "Conditional",
34      "leftOperand": {
35        "type": "FieldRef",
36        "objectName": "business_account",
37        "fieldName": "primary_account_number"
38      },
39      "rightOperands": [
40        {
41          "type": "FieldRef",
42          "objectName": "^RELATION^",
43          "fieldName": "primary_account_number"
44        }
45      ],
46      "operator": "EQ"
47    },
48    "toObjJoinCondition": {
49      "type": "Conditional",
50      "leftOperand": {
51        "type": "FieldRef",
52        "objectName": "^RELATION^",
53        "fieldName": "customer_id_number"
54      },
55      "rightOperands": [
56        {
57          "type": "FieldRef",
58          "objectName": "business_customers",
59          "fieldName": "customer_id_number"
60        }
61      ],
62      "operator": "EQ"
63    },
64    "fields": [
65      {
66        "id": 103533,
67        "createdBy": "videmo",
68        "createdAt": "2023-06-30T15:38:17.248Z",
69        "lastUpdatedBy": "videmo",
70        "lastUpdatedAt": "2023-06-30T15:38:17.248Z",
71        "label": "Transaction Id",
72        "localizedLabels": [
73          {
74            "id": 103619,
75            "createdBy": "videmo",
76            "createdAt": "2023-06-30T15:38:17.248Z",
77            "lastUpdatedBy": "videmo",
78            "lastUpdatedAt": "2023-06-30T15:38:17.248Z",
79            "label": "Transaction Id",
80            "version": 0,
81            "localeCd": "en-US"
82          }
83        ],
84        "name": "transaction_id",
85        "columnName": "transaction_id",
86        "dataType": "STRING",
87        "length": 14,
88        "required": true,
89        "primaryKeyField": true,
90        "unique": false,
91        "autoGenerated": false,
92        "systemReserved": false,
93        "displayIndex": 0,
94        "version": 0,
95        "primaryKeySeqNo": 1,
96        "readOnly": true,
97        "indexedForSearch": true,
98        "showTimeZone": false,
99        "ownerName": "business_transactions",
100        "masked": false,
101        "primaryKeyUserSelected": false
102      },
103      {
104        "id": 103534,
105        "createdBy": "videmo",
106        "createdAt": "2023-06-30T15:38:17.249Z",
107        "lastUpdatedBy": "videmo",
108        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
109        "label": "Customer Id Number",
110        "localizedLabels": [
111          {
112            "id": 103620,
113            "createdBy": "videmo",
114            "createdAt": "2023-06-30T15:38:17.249Z",
115            "lastUpdatedBy": "videmo",
116            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
117            "label": "Customer Id Number",
118            "version": 0,
119            "localeCd": "en-US"
120          }
121        ],
122        "name": "customer_id_number",
123        "columnName": "customer_id_number",
124        "dataType": "NUMERIC",
125        "precision": 32,
126        "scale": 0,
127        "required": false,
128        "primaryKeyField": false,
129        "unique": false,
130        "autoGenerated": false,
131        "systemReserved": false,
132        "displayIndex": 1,
133        "version": 0,
134        "readOnly": true,
135        "indexedForSearch": true,
136        "showTimeZone": false,
137        "ownerName": "business_transactions",
138        "masked": false,
139        "primaryKeyUserSelected": false
140      },
141      {
142        "id": 103535,
143        "createdBy": "videmo",
144        "createdAt": "2023-06-30T15:38:17.249Z",
145        "lastUpdatedBy": "videmo",
146        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
147        "label": "Primary Account Number",
148        "localizedLabels": [
149          {
150            "id": 103621,
151            "createdBy": "videmo",
152            "createdAt": "2023-06-30T15:38:17.249Z",
153            "lastUpdatedBy": "videmo",
154            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
155            "label": "Primary Account Number",
156            "version": 0,
157            "localeCd": "en-US"
158          }
159        ],
160        "name": "primary_account_number",
161        "columnName": "primary_account_number",
162        "dataType": "NUMERIC",
163        "precision": 32,
164        "scale": 0,
165        "required": false,
166        "primaryKeyField": false,
167        "unique": false,
168        "autoGenerated": false,
169        "systemReserved": false,
170        "displayIndex": 2,
171        "version": 0,
172        "readOnly": true,
173        "indexedForSearch": true,
174        "showTimeZone": false,
175        "ownerName": "business_transactions",
176        "masked": false,
177        "primaryKeyUserSelected": false
178      },
179      {
180        "id": 103536,
181        "createdBy": "videmo",
182        "createdAt": "2023-06-30T15:38:17.249Z",
183        "lastUpdatedBy": "videmo",
184        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
185        "label": "Transaction Date",
186        "localizedLabels": [
187          {
188            "id": 103622,
189            "createdBy": "videmo",
190            "createdAt": "2023-06-30T15:38:17.249Z",
191            "lastUpdatedBy": "videmo",
192            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
193            "label": "Transaction Date",
194            "version": 0,
195            "localeCd": "en-US"
196          }
197        ],
198        "name": "transaction_date",
199        "columnName": "transaction_date",
200        "dataType": "TIMESTAMP_WITH_TIME_ZONE",
201        "required": false,
202        "primaryKeyField": false,
203        "unique": false,
204        "autoGenerated": false,
205        "systemReserved": false,
206        "displayIndex": 3,
207        "version": 0,
208        "readOnly": true,
209        "indexedForSearch": true,
210        "showTimeZone": false,
211        "ownerName": "business_transactions",
212        "masked": false,
213        "primaryKeyUserSelected": false
214      },
215      {
216        "id": 103537,
217        "createdBy": "videmo",
218        "createdAt": "2023-06-30T15:38:17.249Z",
219        "lastUpdatedBy": "videmo",
220        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
221        "label": "Id",
222        "localizedLabels": [
223          {
224            "id": 103623,
225            "createdBy": "videmo",
226            "createdAt": "2023-06-30T15:38:17.249Z",
227            "lastUpdatedBy": "videmo",
228            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
229            "label": "Id",
230            "version": 0,
231            "localeCd": "en-US"
232          }
233        ],
234        "name": "id",
235        "columnName": "id",
236        "dataType": "STRING",
237        "length": 2,
238        "required": false,
239        "primaryKeyField": false,
240        "unique": false,
241        "autoGenerated": false,
242        "systemReserved": false,
243        "displayIndex": 4,
244        "version": 0,
245        "readOnly": true,
246        "indexedForSearch": true,
247        "showTimeZone": false,
248        "ownerName": "business_transactions",
249        "masked": false,
250        "primaryKeyUserSelected": false
251      },
252      {
253        "id": 103538,
254        "createdBy": "videmo",
255        "createdAt": "2023-06-30T15:38:17.249Z",
256        "lastUpdatedBy": "videmo",
257        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
258        "label": "Tran Desc",
259        "localizedLabels": [
260          {
261            "id": 103624,
262            "createdBy": "videmo",
263            "createdAt": "2023-06-30T15:38:17.249Z",
264            "lastUpdatedBy": "videmo",
265            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
266            "label": "Tran Desc",
267            "version": 0,
268            "localeCd": "en-US"
269          }
270        ],
271        "name": "tran_desc",
272        "columnName": "tran_desc",
273        "dataType": "STRING",
274        "length": 24,
275        "required": false,
276        "primaryKeyField": false,
277        "unique": false,
278        "autoGenerated": false,
279        "systemReserved": false,
280        "displayIndex": 5,
281        "version": 0,
282        "readOnly": true,
283        "indexedForSearch": true,
284        "showTimeZone": false,
285        "ownerName": "business_transactions",
286        "masked": false,
287        "primaryKeyUserSelected": false
288      },
289      {
290        "id": 103539,
291        "createdBy": "videmo",
292        "createdAt": "2023-06-30T15:38:17.249Z",
293        "lastUpdatedBy": "videmo",
294        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
295        "label": "Orig Tran Amt Cash",
296        "localizedLabels": [
297          {
298            "id": 103625,
299            "createdBy": "videmo",
300            "createdAt": "2023-06-30T15:38:17.249Z",
301            "lastUpdatedBy": "videmo",
302            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
303            "label": "Orig Tran Amt Cash",
304            "version": 0,
305            "localeCd": "en-US"
306          }
307        ],
308        "name": "orig_tran_amt_cash",
309        "columnName": "orig_tran_amt_cash",
310        "dataType": "NUMERIC",
311        "precision": 15,
312        "scale": 2,
313        "required": false,
314        "primaryKeyField": false,
315        "unique": false,
316        "autoGenerated": false,
317        "systemReserved": false,
318        "displayIndex": 6,
319        "version": 0,
320        "readOnly": true,
321        "indexedForSearch": true,
322        "showTimeZone": false,
323        "ownerName": "business_transactions",
324        "masked": false,
325        "primaryKeyUserSelected": false
326      },
327      {
328        "id": 103540,
329        "createdBy": "videmo",
330        "createdAt": "2023-06-30T15:38:17.249Z",
331        "lastUpdatedBy": "videmo",
332        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
333        "label": "Tran Unique Id",
334        "localizedLabels": [
335          {
336            "id": 103626,
337            "createdBy": "videmo",
338            "createdAt": "2023-06-30T15:38:17.249Z",
339            "lastUpdatedBy": "videmo",
340            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
341            "label": "Tran Unique Id",
342            "version": 0,
343            "localeCd": "en-US"
344          }
345        ],
346        "name": "tran_unique_id",
347        "columnName": "tran_unique_id",
348        "dataType": "STRING",
349        "length": 25,
350        "required": false,
351        "primaryKeyField": false,
352        "unique": false,
353        "autoGenerated": false,
354        "systemReserved": false,
355        "displayIndex": 7,
356        "version": 0,
357        "readOnly": true,
358        "indexedForSearch": true,
359        "showTimeZone": false,
360        "ownerName": "business_transactions",
361        "masked": false,
362        "primaryKeyUserSelected": false
363      }
364    ],
365    "readOnly": true,
366    "transactionDateFieldName": "transaction_date"
367  }
368]