OEB_AR_CASH_RECEIPT_HISTORY_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CASH_RECEIPT_HISTORY_ID BIGINT 8
2 CASH_RECEIPT_ID BIGINT 8
3 STATUS CHARACTER VARYING(30) 30
4 TRX_DATE TIMESTAMP 8
5 AMOUNT NUMERIC(18,2) 19
6 FIRST_POSTED_RECORD_FLAG CHARACTER VARYING(1) 1
7 POSTABLE_FLAG CHARACTER VARYING(1) 1
8 FACTOR_FLAG CHARACTER VARYING(1) 1
9 GL_DATE TIMESTAMP 8
10 CURRENT_RECORD_FLAG CHARACTER VARYING(1) 1
11 BATCH_ID BIGINT 8
12 ACCOUNT_CODE_COMBINATION_ID BIGINT 8
13 REVERSAL_GL_DATE TIMESTAMP 8
14 REVERSAL_CASH_RECEIPT_HIST_ID BIGINT 8
15 FACTOR_DISCOUNT_AMOUNT NUMERIC(18,2) 19
16 BANK_CHARGE_ACCOUNT_CCID BIGINT 8
17 POSTING_CONTROL_ID BIGINT 8
18 REVERSAL_POSTING_CONTROL_ID BIGINT 8
19 GL_POSTED_DATE TIMESTAMP 8
20 REVERSAL_GL_POSTED_DATE TIMESTAMP 8
21 LAST_UPDATE_LOGIN BIGINT 8
22 ACCTD_AMOUNT NUMERIC(18,2) 19
23 ACCTD_FACTOR_DISCOUNT_AMOUNT NUMERIC(18,2) 19
24 CREATED_BY BIGINT 8
25 CREATION_DATE TIMESTAMP 8
26 EXCHANGE_DATE TIMESTAMP 8
27 EXCHANGE_RATE NUMERIC(18,2) 19
28 EXCHANGE_RATE_TYPE CHARACTER VARYING(30) 30
29 LAST_UPDATE_DATE TIMESTAMP 8
30 PROGRAM_APPLICATION_ID BIGINT 8
31 PROGRAM_ID BIGINT 8
32 PROGRAM_UPDATE_DATE TIMESTAMP 8
33 REQUEST_ID BIGINT 8
34 LAST_UPDATED_BY BIGINT 8
35 PRV_STAT_CASH_RECEIPT_HIST_ID BIGINT 8
36 CREATED_FROM CHARACTER VARYING(30) 30
37 REVERSAL_CREATED_FROM CHARACTER VARYING(30) 30
38 ATTRIBUTE1 CHARACTER VARYING(150) 150
39 ATTRIBUTE2 CHARACTER VARYING(150) 150
40 ATTRIBUTE3 CHARACTER VARYING(150) 150
41 ATTRIBUTE4 CHARACTER VARYING(150) 150
42 ATTRIBUTE5 CHARACTER VARYING(150) 150
43 ATTRIBUTE6 CHARACTER VARYING(150) 150
44 ATTRIBUTE7 CHARACTER VARYING(150) 150
45 ATTRIBUTE8 CHARACTER VARYING(150) 150
46 ATTRIBUTE9 CHARACTER VARYING(150) 150
47 ATTRIBUTE10 CHARACTER VARYING(150) 150
48 ATTRIBUTE11 CHARACTER VARYING(150) 150
49 ATTRIBUTE12 CHARACTER VARYING(150) 150
50 ATTRIBUTE13 CHARACTER VARYING(150) 150
51 ATTRIBUTE14 CHARACTER VARYING(150) 150
52 ATTRIBUTE15 CHARACTER VARYING(150) 150
53 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
54 NOTE_STATUS CHARACTER VARYING(30) 30
55 ORG_ID BIGINT 8
56 MRC_POSTING_CONTROL_ID CHARACTER VARYING(2000) 2000
57 MRC_GL_POSTED_DATE CHARACTER VARYING(2000) 2000
58 MRC_REVERSAL_GL_POSTED_DATE CHARACTER VARYING(2000) 2000
59 MRC_ACCTD_AMOUNT CHARACTER VARYING(2000) 2000
60 MRC_ACCTD_FACTOR_DISC_AMOUNT CHARACTER VARYING(2000) 2000
61 MRC_EXCHANGE_DATE CHARACTER VARYING(2000) 2000
62 MRC_EXCHANGE_RATE CHARACTER VARYING(2000) 2000
63 MRC_EXCHANGE_RATE_TYPE CHARACTER VARYING(2000) 2000
64 EVENT_ID BIGINT 8
65 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
66 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
67 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
68 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8