INT_CI_TRANSACTION

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TRANSACTION_ID BIGINT 8
2 TRANSACTION_EXPOSURE_ID BIGINT 8
3 TRANSACTION_PAYMENT_APPLICATION_ID BIGINT 8
4 COST_TYPE_ID BIGINT 8
5 COST_CATEGORY_ID BIGINT 8
6 RECOVERY_CATEGORY_ID BIGINT 8
7 TRANSACTION_STATUS_ID BIGINT 8
8 TRANSACTION_SUB_TYPE_ID BIGINT 8
9 TRANSACTION_CREATE_BY_USER_ID BIGINT 8
10 TRANSACTION_UPDATE_USER_ID BIGINT 8
11 TRANSACTION_LINE_ITEM_ID BIGINT 8
12 TRANSACTION_CREATE_DATE TIMESTAMP 8
13 TRANSACTION_CLAIM_ID BIGINT 8
14 TRANSACTION_CREATE_DATE_LBL CHARACTER VARYING(30) 30
15 TRANSACTION_CREATE_DATE_ID INTEGER 4
16 TRANSACTION_COMMENTS CHARACTER VARYING(255) 255
17 TRANSACTION_RECEIPT_DATE TIMESTAMP 8
18 TRANSACTION_RECEIPT_DATE_LBL CHARACTER VARYING(30) 30
19 TRANSACTION_RECEIPT_DATE_ID INTEGER 4
20 TRANSACTION_APPROVAL_DATE TIMESTAMP 8
21 TRANSACTION_APPROVAL_DATE_LBL CHARACTER VARYING(30) 30
22 TRANSACTION_APPROVAL_DATE_ID INTEGER 4
23 TRANSACTION_CHEQUE_CREATE_DATE TIMESTAMP 8
24 TRANSACTION_CHEQUE_CREATE_DATE_LBL CHARACTER VARYING(30) 30
25 TRANSACTION_CHEQUE_CREATE_DATE_ID INTEGER 4
26 TRANSACTION_CHEQUE_ISSUE_DATE TIMESTAMP 8
27 TRANSACTION_CHEQUE_ISSUE_DATE_LBL CHARACTER VARYING(30) 30
28 TRANSACTION_CHEQUE_ISSUE_DATE_ID INTEGER 4
29 PAYEE_NAME_ID BIGINT 8
30 PAYEE_NAME CHARACTER VARYING(181) 181
31 TRANSACTION_APPROVAL_STATUS_ID BIGINT 8
32 TRANSACTION_CHEQUE_STATUS_ID BIGINT 8
33 TRANSACTION_PAYMENT_METHOD_ID BIGINT 8
34 CHEQUE_ID BIGINT 8
35 CHEQUE_PAYEE_NAME CHARACTER VARYING(255) 255
36 CHEQUE_RECIPIENT_NAME CHARACTER VARYING(255) 255
37 CHEQUE_RECIPIENT_ADDRESS CHARACTER VARYING(255) 255
38 CHEQUE_ACCOUNT_NAME CHARACTER VARYING(255) 255
39 CHEQUE_ACCOUNT_NUMBER CHARACTER VARYING(255) 255
40 CHEQUE_ACCOUNT_BANK_NAME CHARACTER VARYING(255) 255
41 CHEQUE_ACCOUNT_BSB CHARACTER VARYING(255) 255
42 CHEQUE_NUMBER CHARACTER VARYING(255) 255
43 CHEQUE_INVOICE_NUMBER CHARACTER VARYING(255) 255
44 CHEQUE_STATUS_ID BIGINT 8
45 CHEQUE_CREATE_DATE TIMESTAMP 8
46 CHEQUE_ISSUE_DATE TIMESTAMP 8
47 SC_RECEIPTREFERENCENUMBER1 CHARACTER VARYING(60) 60
48 PAYMENT_COUNT INTEGER 4
49 DAM_AMOUNT NUMERIC(18,2) 19
50 DAM_SETTLEMENT_AMOUNT NUMERIC(18,2) 19
51 GST_AMOUNT NUMERIC(18,2) 19
52 ITC_AMOUNT NUMERIC(18,2) 19
53 TRANSACTION_AMOUNT NUMERIC(18,2) 19
54 TAX_AMOUNT NUMERIC(18,2) 19
55 RESERVES_AMOUNT NUMERIC(18,2) 19
56 REMAINING_RESERVES NUMERIC(19,2) 19
57 FUTURE_PAYMENT NUMERIC(18,2) 19
58 PAID_AMOUNT NUMERIC(18,2) 19
59 RECOVERIES_AMOUNT NUMERIC(18,2) 19
60 RECOVERY_RESERVES_AMOUNT NUMERIC(18,2) 19
61 OPEN_RECOVERY_RESERVES_AMOUNT NUMERIC(19,2) 19
62 GROSS_INCURRED_AMOUNT NUMERIC(20,2) 19
63 NET_INCURRED_AMOUNT NUMERIC(21,2) 19
64 GL_NET_INCURRED_AMOUNT NUMERIC(22,2) 19
65 NET_RECOVERY_AMOUNT NUMERIC(19,2) 19
66 EXCESS_RECOVERY_RESERVE_AMOUNT NUMERIC(18,2) 19
67 EXCESS_RECOVERY_AMOUNT NUMERIC(18,2) 19
68 SALVAGE_RECOVERY_RESERVE_AMOUNT NUMERIC(18,2) 19
69 SALVAGE_RECOVERY_AMOUNT NUMERIC(18,2) 19
70 DEBT_RECOVERY_RESERVE_AMOUNT NUMERIC(18,2) 19
71 DEBT_RECOVERY_AMOUNT NUMERIC(18,2) 19
72 LOSS_ADJUSTER_AMOUNT NUMERIC(18,2) 19
73 TRANSACTION_UPDATE_DATE TIMESTAMP 8
74 TRANSACTION_UPDATE_DATE_LBL CHARACTER VARYING(30) 30
75 TRANSACTION_UPDATE_DATE_ID INTEGER 4
76 COST_CATEGORY_TYPE_CODE CHARACTER VARYING(50) 50
77 TRANSACTION_TYPE_CODE CHARACTER VARYING(50) 50