INT_WCOM_TRANSACTIONS_CC

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 TRANSACTION_ID BIGINT 8
3 CLAIMNUMBER CHARACTER VARYING(40) 40
4 APPROVAL_DATE TIMESTAMP 8
5 TRANSACTION_CREATE_DATE TIMESTAMP 8
6 SC_GLSERVICEACKTIME TIMESTAMP 8
7 TRANSACTION_TYPE CHARACTER VARYING(50) 50
8 UPDATETIME TIMESTAMP 8
9 PAID_DATE TIMESTAMP 8
10 TRANSACTION_DATE TIMESTAMP 8
11 TRANSACTION_MONTH INTEGER 4
12 APPQTR INTEGER 4
13 APPMTH INTEGER 4
14 APPHALF NUMERIC(11,0) 19
15 COST_CATEGORY_CODE CHARACTER VARYING(50) 50
16 COST_CATEGORY_NAME CHARACTER VARYING(256) 256
17 COST_CATEGORY_ID BIGINT 8
18 COST_TYPE_NAME CHARACTER VARYING(256) 256
19 COST_TYPE_ID BIGINT 8
20 TRANCOUNTER BIGINT 8
21 TRANSACTION_LINE_ITEM_ID BIGINT 8
22 SC_PAYMENTTYPECODE CHARACTER VARYING(6) 6
23 MAJOR_PAYMENT_TYPE_NAME CHARACTER VARYING(256) 256
24 MAJOR_PAYMENT_TYPE_ID BIGINT 8
25 MINOR_PAYMENT_SUB_TYPE_NAME CHARACTER VARYING(256) 256
26 MINOR_PAYMENT_SUB_TYPE_ID BIGINT 8
27 MINOR_PAYMENT_TYPE_NAME CHARACTER VARYING(256) 256
28 MINOR_PAYMENT_TYPE_ID BIGINT 8
29 NO_OF_DAYS_PAID BIGINT 8
30 NO_OF_HOURS_PAID BIGINT 8
31 NO_OF_MINUTES_PAID BIGINT 8
32 NO_OF_WEEKS_PAID BIGINT 8
33 START_DATE TIMESTAMP 8
34 END_DATE TIMESTAMP 8
35 WCTRANSACTIONTYPE_NAME CHARACTER VARYING(256) 256
36 TRANSACTION_STATUS_NAME CHARACTER VARYING(256) 256
37 TRANSACTION_AMOUNT NUMERIC(18,2) 19
38 APPROVALDATE_TRANSACTIONSET TIMESTAMP 8
39 LOADCOMMANDID BIGINT 8
40 BATCHDATE CHARACTER VARYING(1) 1
41 GROSS_RESERVE NUMERIC(20,2) 19
42 PAYMENT_COUNT INTEGER 4
43 PAID_AMOUNT NUMERIC(18,2) 19
44 SC_ITCAMOUNT NUMERIC(18,2) 19
45 IAM_AMOUNT NUMERIC(18,2) 19
46 ITC_PERCENT BIGINT 8
47 SC_DAMAMOUNT NUMERIC(18,2) 19
48 OFFSETAMOUNT NUMERIC(18,2) 19
49 TOTAL_RECOVERIES_AMOUNT NUMERIC(18,2) 19
50 GENERIC_RECOVERIES_AMOUNT NUMERIC(18,2) 19
51 OPEN_RECOVERY_RESERVES_AMOUNT NUMERIC(19,2) 19
52 REMAINING_RESERVES_AMOUNT NUMERIC(20,2) 19
53 RECOVERY_RESERVE_MOVEMENT_AMOUNT NUMERIC(20,2) 19
54 PAID_AMOUNT_2X NUMERIC(18,2) 19
55 RECOVERY_REFUND NUMERIC(18,2) 19
56 PAYTYPE CHARACTER VARYING(10) 10
57 PAYTYPE1 CHARACTER VARYING(20) 20
58 PAYTYPE2 CHARACTER VARYING(8) 8
59 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3