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      },
102      {
103        "id": 103534,
104        "createdBy": "videmo",
105        "createdAt": "2023-06-30T15:38:17.249Z",
106        "lastUpdatedBy": "videmo",
107        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
108        "label": "Customer Id Number",
109        "localizedLabels": [
110          {
111            "id": 103620,
112            "createdBy": "videmo",
113            "createdAt": "2023-06-30T15:38:17.249Z",
114            "lastUpdatedBy": "videmo",
115            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
116            "label": "Customer Id Number",
117            "version": 0,
118            "localeCd": "en-US"
119          }
120        ],
121        "name": "customer_id_number",
122        "columnName": "customer_id_number",
123        "dataType": "NUMERIC",
124        "precision": 32,
125        "scale": 0,
126        "required": false,
127        "primaryKeyField": false,
128        "unique": false,
129        "autoGenerated": false,
130        "systemReserved": false,
131        "displayIndex": 1,
132        "version": 0,
133        "readOnly": true,
134        "indexedForSearch": true,
135        "showTimeZone": false,
136        "ownerName": "business_transactions",
137        "masked": false
138      },
139      {
140        "id": 103535,
141        "createdBy": "videmo",
142        "createdAt": "2023-06-30T15:38:17.249Z",
143        "lastUpdatedBy": "videmo",
144        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
145        "label": "Primary Account Number",
146        "localizedLabels": [
147          {
148            "id": 103621,
149            "createdBy": "videmo",
150            "createdAt": "2023-06-30T15:38:17.249Z",
151            "lastUpdatedBy": "videmo",
152            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
153            "label": "Primary Account Number",
154            "version": 0,
155            "localeCd": "en-US"
156          }
157        ],
158        "name": "primary_account_number",
159        "columnName": "primary_account_number",
160        "dataType": "NUMERIC",
161        "precision": 32,
162        "scale": 0,
163        "required": false,
164        "primaryKeyField": false,
165        "unique": false,
166        "autoGenerated": false,
167        "systemReserved": false,
168        "displayIndex": 2,
169        "version": 0,
170        "readOnly": true,
171        "indexedForSearch": true,
172        "showTimeZone": false,
173        "ownerName": "business_transactions",
174        "masked": false
175      },
176      {
177        "id": 103536,
178        "createdBy": "videmo",
179        "createdAt": "2023-06-30T15:38:17.249Z",
180        "lastUpdatedBy": "videmo",
181        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
182        "label": "Transaction Date",
183        "localizedLabels": [
184          {
185            "id": 103622,
186            "createdBy": "videmo",
187            "createdAt": "2023-06-30T15:38:17.249Z",
188            "lastUpdatedBy": "videmo",
189            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
190            "label": "Transaction Date",
191            "version": 0,
192            "localeCd": "en-US"
193          }
194        ],
195        "name": "transaction_date",
196        "columnName": "transaction_date",
197        "dataType": "TIMESTAMP_WITH_TIME_ZONE",
198        "required": false,
199        "primaryKeyField": false,
200        "unique": false,
201        "autoGenerated": false,
202        "systemReserved": false,
203        "displayIndex": 3,
204        "version": 0,
205        "readOnly": true,
206        "indexedForSearch": true,
207        "showTimeZone": false,
208        "ownerName": "business_transactions",
209        "masked": false
210      },
211      {
212        "id": 103537,
213        "createdBy": "videmo",
214        "createdAt": "2023-06-30T15:38:17.249Z",
215        "lastUpdatedBy": "videmo",
216        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
217        "label": "Id",
218        "localizedLabels": [
219          {
220            "id": 103623,
221            "createdBy": "videmo",
222            "createdAt": "2023-06-30T15:38:17.249Z",
223            "lastUpdatedBy": "videmo",
224            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
225            "label": "Id",
226            "version": 0,
227            "localeCd": "en-US"
228          }
229        ],
230        "name": "id",
231        "columnName": "id",
232        "dataType": "STRING",
233        "length": 2,
234        "required": false,
235        "primaryKeyField": false,
236        "unique": false,
237        "autoGenerated": false,
238        "systemReserved": false,
239        "displayIndex": 4,
240        "version": 0,
241        "readOnly": true,
242        "indexedForSearch": true,
243        "showTimeZone": false,
244        "ownerName": "business_transactions",
245        "masked": false
246      },
247      {
248        "id": 103538,
249        "createdBy": "videmo",
250        "createdAt": "2023-06-30T15:38:17.249Z",
251        "lastUpdatedBy": "videmo",
252        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
253        "label": "Tran Desc",
254        "localizedLabels": [
255          {
256            "id": 103624,
257            "createdBy": "videmo",
258            "createdAt": "2023-06-30T15:38:17.249Z",
259            "lastUpdatedBy": "videmo",
260            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
261            "label": "Tran Desc",
262            "version": 0,
263            "localeCd": "en-US"
264          }
265        ],
266        "name": "tran_desc",
267        "columnName": "tran_desc",
268        "dataType": "STRING",
269        "length": 24,
270        "required": false,
271        "primaryKeyField": false,
272        "unique": false,
273        "autoGenerated": false,
274        "systemReserved": false,
275        "displayIndex": 5,
276        "version": 0,
277        "readOnly": true,
278        "indexedForSearch": true,
279        "showTimeZone": false,
280        "ownerName": "business_transactions",
281        "masked": false
282      },
283      {
284        "id": 103539,
285        "createdBy": "videmo",
286        "createdAt": "2023-06-30T15:38:17.249Z",
287        "lastUpdatedBy": "videmo",
288        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
289        "label": "Orig Tran Amt Cash",
290        "localizedLabels": [
291          {
292            "id": 103625,
293            "createdBy": "videmo",
294            "createdAt": "2023-06-30T15:38:17.249Z",
295            "lastUpdatedBy": "videmo",
296            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
297            "label": "Orig Tran Amt Cash",
298            "version": 0,
299            "localeCd": "en-US"
300          }
301        ],
302        "name": "orig_tran_amt_cash",
303        "columnName": "orig_tran_amt_cash",
304        "dataType": "NUMERIC",
305        "precision": 15,
306        "scale": 2,
307        "required": false,
308        "primaryKeyField": false,
309        "unique": false,
310        "autoGenerated": false,
311        "systemReserved": false,
312        "displayIndex": 6,
313        "version": 0,
314        "readOnly": true,
315        "indexedForSearch": true,
316        "showTimeZone": false,
317        "ownerName": "business_transactions",
318        "masked": false
319      },
320      {
321        "id": 103540,
322        "createdBy": "videmo",
323        "createdAt": "2023-06-30T15:38:17.249Z",
324        "lastUpdatedBy": "videmo",
325        "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
326        "label": "Tran Unique Id",
327        "localizedLabels": [
328          {
329            "id": 103626,
330            "createdBy": "videmo",
331            "createdAt": "2023-06-30T15:38:17.249Z",
332            "lastUpdatedBy": "videmo",
333            "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
334            "label": "Tran Unique Id",
335            "version": 0,
336            "localeCd": "en-US"
337          }
338        ],
339        "name": "tran_unique_id",
340        "columnName": "tran_unique_id",
341        "dataType": "STRING",
342        "length": 25,
343        "required": false,
344        "primaryKeyField": false,
345        "unique": false,
346        "autoGenerated": false,
347        "systemReserved": false,
348        "displayIndex": 7,
349        "version": 0,
350        "readOnly": true,
351        "indexedForSearch": true,
352        "showTimeZone": false,
353        "ownerName": "business_transactions",
354        "masked": false
355      }
356    ],
357    "readOnly": true,
358    "transactionDateFieldName": "transaction_date"
359  }
360]