INT_CI_EXPOSURE_TRANSACTION_DT_TRANSACTION

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_ID BIGINT 8
2 EXPOSURE_ID BIGINT 8
3 TRANSACTION_CLAIM_ID BIGINT 8
4 TRANSACTION_CREATE_DATE TIMESTAMP 8
5 TRANSACTION_APPROVAL_DATE TIMESTAMP 8
6 TRANSACTION_APPROVAL_DATE_YEAR INTEGER 4
7 TRANSACTION_APPROVAL_DATE_QUARTER INTEGER 4
8 TRANSACTION_APPROVAL_DATE_MONTH INTEGER 4
9 TRANSACTION_APPROVAL_DATE_DAY INTEGER 4
10 TRANSACTION_APPROVAL_DATE_DAY_TYPE_ID INTEGER 4
11 TRANSACTION_APPROVAL_DATE_WEEK_TYPE_ID INTEGER 4
12 TRANSACTION_APPROVAL_DATE_MONTH_TYPE_ID INTEGER 4
13 TRANSACTION_APPROVAL_DATE_QUARTER_TYPE_ID INTEGER 4
14 TRANSACTION_APPROVAL_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
15 TRANSACTION_APPROVAL_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
16 TRANSACTION_APPROVAL_DATE_R12_MONTH_TYPE_ID INTEGER 4
17 TRANSACTION_APPROVAL_DATE_R13_MONTH_TYPE_ID INTEGER 4
18 TRANSACTION_APPROVAL_DATE_HALF_TYPE_ID INTEGER 4
19 TRANSACTION_PAYMENT_METHOD_ID BIGINT 8
20 TRANSACTION_PAYMENT_METHOD CHARACTER VARYING(256) 256
21 TRANSACTION_CREATE_DATE_YEAR INTEGER 4
22 TRANSACTION_CREATE_DATE_QUARTER INTEGER 4
23 TRANSACTION_CREATE_DATE_MONTH INTEGER 4
24 TRANSACTION_CREATE_DATE_DAY INTEGER 4
25 TRANSACTION_CREATE_DATE_DAY_TYPE_ID INTEGER 4
26 TRANSACTION_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
27 TRANSACTION_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
28 TRANSACTION_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
29 TRANSACTION_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
30 TRANSACTION_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
31 TRANSACTION_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
32 TRANSACTION_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
33 TRANSACTION_CREATE_DATE_HALF_TYPE_ID INTEGER 4
34 TRANSACTION_RECEIPT_DATE TIMESTAMP 8
35 TRANSACTION_RECEIPT_DATE_YEAR INTEGER 4
36 TRANSACTION_RECEIPT_DATE_QUARTER INTEGER 4
37 TRANSACTION_RECEIPT_DATE_MONTH INTEGER 4
38 TRANSACTION_RECEIPT_DATE_DAY INTEGER 4
39 TRANSACTION_RECEIPT_DATE_DAY_TYPE_ID INTEGER 4
40 TRANSACTION_RECEIPT_DATE_WEEK_TYPE_ID INTEGER 4
41 TRANSACTION_RECEIPT_DATE_MONTH_TYPE_ID INTEGER 4
42 TRANSACTION_RECEIPT_DATE_QUARTER_TYPE_ID INTEGER 4
43 TRANSACTION_RECEIPT_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
44 TRANSACTION_RECEIPT_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
45 TRANSACTION_RECEIPT_DATE_R12_MONTH_TYPE_ID INTEGER 4
46 TRANSACTION_RECEIPT_DATE_R13_MONTH_TYPE_ID INTEGER 4
47 TRANSACTION_RECEIPT_DATE_HALF_TYPE_ID INTEGER 4
48 TRANSACTION_CREATE_BY_USER_ID BIGINT 8
49 TRANSACTION_CREATE_BY_USER_NAME CHARACTER VARYING(181) 181
50 TRANSACTION_CREATE_BY_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
51 TRANSACTION_CREATE_BY_TEAM_ID BIGINT 8
52 TRANSACTION_CREATE_BY_TEAM_NAME CHARACTER VARYING(100) 100
53 TRANSACTION_CREATE_BY_GROUP_TYPE_ID BIGINT 8
54 TRANSACTION_CREATE_BY_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
55 TRANSACTION_CREATE_BY_USER_L1_TEAM_ID BIGINT 8
56 TRANSACTION_CREATE_BY_USER_L2_TEAM_ID BIGINT 8
57 TRANSACTION_CREATE_BY_USER_L3_TEAM_ID BIGINT 8
58 TRANSACTION_CREATE_BY_USER_L4_TEAM_ID BIGINT 8
59 TRANSACTION_CREATE_BY_USER_L5_TEAM_ID BIGINT 8
60 TRANSACTION_CREATE_BY_USER_L6_TEAM_ID BIGINT 8
61 TRANSACTION_CREATE_BY_USER_L7_TEAM_ID BIGINT 8
62 TRANSACTION_CREATE_BY_USER_L8_TEAM_ID BIGINT 8
63 TRANSACTION_CREATE_BY_USER_L9_TEAM_ID BIGINT 8
64 TRANSACTION_CREATE_BY_USER_L10_TEAM_ID BIGINT 8
65 TRANSACTION_CREATE_BY_USER_L11_TEAM_ID BIGINT 8
66 TRANSACTION_UPDATE_USER_ID BIGINT 8
67 TRANSACTION_UPDATE_USER_NAME CHARACTER VARYING(181) 181
68 TRANSACTION_UPDATE_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
69 TRANSACTION_UPDATE_TEAM_ID BIGINT 8
70 TRANSACTION_UPDATE_TEAM_NAME CHARACTER VARYING(100) 100
71 TRANSACTION_UPDATE_GROUP_TYPE_ID BIGINT 8
72 TRANSACTION_UPDATE_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
73 TRANSACTION_UPDATE_USER_L1_TEAM_ID BIGINT 8
74 TRANSACTION_UPDATE_USER_L2_TEAM_ID BIGINT 8
75 TRANSACTION_UPDATE_USER_L3_TEAM_ID BIGINT 8
76 TRANSACTION_UPDATE_USER_L4_TEAM_ID BIGINT 8
77 TRANSACTION_UPDATE_USER_L5_TEAM_ID BIGINT 8
78 TRANSACTION_UPDATE_USER_L6_TEAM_ID BIGINT 8
79 TRANSACTION_UPDATE_USER_L7_TEAM_ID BIGINT 8
80 TRANSACTION_UPDATE_USER_L8_TEAM_ID BIGINT 8
81 TRANSACTION_UPDATE_USER_L9_TEAM_ID BIGINT 8
82 TRANSACTION_UPDATE_USER_L10_TEAM_ID BIGINT 8
83 TRANSACTION_UPDATE_USER_L11_TEAM_ID BIGINT 8
84 TRANSACTION_PAYMENT_APPLICATION_ID BIGINT 8
85 TRANSACTION_PAYMENT_APPLICATION_NAME CHARACTER VARYING(256) 256
86 TRANSACTION_COST_TYPE_ID BIGINT 8
87 TRANSACTION_COST_TYPE_NAME CHARACTER VARYING(256) 256
88 TRANSACTION_COST_CATEGORY_ID BIGINT 8
89 TRANSACTION_COST_CATEGORY_NAME CHARACTER VARYING(256) 256
90 TRANSACTION_STATUS_ID BIGINT 8
91 TRANSACTION_STATUS_NAME CHARACTER VARYING(256) 256
92 TRANSACTION_SUB_TYPE_ID BIGINT 8
93 TRANSACTION_SUB_TYPE_NAME CHARACTER VARYING(256) 256
94 PAYEE_NAME_ID BIGINT 8
95 PAYEE_NAME CHARACTER VARYING(181) 181
96 RECOVERY_CATEGORY_ID BIGINT 8
97 RECOVERY_CATEGORY_NAME CHARACTER VARYING(256) 256
98 TRANSACTION_COMMENTS CHARACTER VARYING(255) 255
99 REMAINING_RESERVES NUMERIC(19,2) 19
100 FUTURE_PAYMENT NUMERIC(18,2) 19
101 PAID_AMOUNT NUMERIC(18,2) 19
102 OPEN_RECOVERY_RESERVES_AMOUNT NUMERIC(19,2) 19
103 GROSS_INCURRED_AMOUNT NUMERIC(20,2) 19
104 NET_INCURRED_AMOUNT NUMERIC(21,2) 19
105 CHEQUE_ID BIGINT 8
106 CHEQUE_PAYEE_NAME CHARACTER VARYING(255) 255
107 CHEQUE_RECIPIENT_NAME CHARACTER VARYING(255) 255
108 CHEQUE_RECIPIENT_ADDRESS CHARACTER VARYING(255) 255
109 CHEQUE_ACCOUNT_NAME CHARACTER VARYING(255) 255
110 CHEQUE_ACCOUNT_NUMBER CHARACTER VARYING(255) 255
111 CHEQUE_ACCOUNT_BANK_NAME CHARACTER VARYING(255) 255
112 CHEQUE_ACCOUNT_BSB CHARACTER VARYING(255) 255
113 CHEQUE_NUMBER CHARACTER VARYING(255) 255
114 CHEQUE_INVOICE_NUMBER CHARACTER VARYING(255) 255
115 CHEQUE_STATUS_ID BIGINT 8
116 CHECK_STATUS_NAME CHARACTER VARYING(256) 256
117 CHEQUE_CREATE_DATE TIMESTAMP 8
118 CHEQUE_CREATE_DATE_YEAR INTEGER 4
119 CHEQUE_CREATE_DATE_QUARTER INTEGER 4
120 CHEQUE_CREATE_DATE_MONTH INTEGER 4
121 CHEQUE_CREATE_DATE_DAY INTEGER 4
122 CHEQUE_CREATE_DATE_DAY_TYPE_ID INTEGER 4
123 CHEQUE_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
124 CHEQUE_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
125 CHEQUE_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
126 CHEQUE_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
127 CHEQUE_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
128 CHEQUE_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
129 CHEQUE_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
130 CHEQUE_CREATE_DATE_HALF_TYPE_ID INTEGER 4
131 CHEQUE_ISSUE_DATE TIMESTAMP 8
132 CHEQUE_ISSUE_DATE_YEAR INTEGER 4
133 CHEQUE_ISSUE_DATE_QUARTER INTEGER 4
134 CHEQUE_ISSUE_DATE_MONTH INTEGER 4
135 CHEQUE_ISSUE_DATE_DAY INTEGER 4
136 CHEQUE_ISSUE_DATE_DAY_TYPE_ID INTEGER 4
137 CHEQUE_ISSUE_DATE_WEEK_TYPE_ID INTEGER 4
138 CHEQUE_ISSUE_DATE_MONTH_TYPE_ID INTEGER 4
139 CHEQUE_ISSUE_DATE_QUARTER_TYPE_ID INTEGER 4
140 CHEQUE_ISSUE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
141 CHEQUE_ISSUE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
142 CHEQUE_ISSUE_DATE_R12_MONTH_TYPE_ID INTEGER 4
143 CHEQUE_ISSUE_DATE_R13_MONTH_TYPE_ID INTEGER 4
144 CHEQUE_ISSUE_DATE_HALF_TYPE_ID INTEGER 4
145 DAM_AMOUNT NUMERIC(18,2) 19
146 DAM_SETTLEMENT_AMOUNT NUMERIC(18,2) 19
147 GST_AMOUNT NUMERIC(18,2) 19
148 ITC_AMOUNT NUMERIC(18,2) 19
149 RECOVERIES_AMOUNT NUMERIC(18,2) 19
150 RECOVERY_RESERVES_AMOUNT NUMERIC(18,2) 19
151 RESERVES_AMOUNT NUMERIC(18,2) 19
152 TRANSACTION_AMOUNT NUMERIC(18,2) 19
153 GL_NET_INCURRED_AMOUNT NUMERIC(22,2) 19
154 NET_RECOVERY_AMOUNT NUMERIC(19,2) 19
155 TRANSACTION_LINE_ITEM_ID BIGINT 8
156 TRANSACTION_APPROVAL_STATUS_ID BIGINT 8
157 TRANSACTION_APPROVAL_STATUS_NAME CHARACTER VARYING(256) 256