Retrieve a transaction type by name

Shell - curl
1

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