Retrieve a transaction type object by ID

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