OEB_AR_DISTRIBUTIONS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 LINE_ID BIGINT 8
2 SOURCE_ID BIGINT 8
3 SOURCE_TABLE CHARACTER VARYING(10) 10
4 SOURCE_TYPE CHARACTER VARYING(30) 30
5 CODE_COMBINATION_ID BIGINT 8
6 AMOUNT_DR NUMERIC(18,2) 19
7 AMOUNT_CR NUMERIC(18,2) 19
8 ACCTD_AMOUNT_DR NUMERIC(18,2) 19
9 ACCTD_AMOUNT_CR NUMERIC(18,2) 19
10 CREATION_DATE TIMESTAMP 8
11 CREATED_BY BIGINT 8
12 LAST_UPDATED_BY BIGINT 8
13 LAST_UPDATE_DATE TIMESTAMP 8
14 LAST_UPDATE_LOGIN BIGINT 8
15 ORG_ID BIGINT 8
16 SOURCE_TABLE_SECONDARY CHARACTER VARYING(10) 10
17 SOURCE_ID_SECONDARY BIGINT 8
18 CURRENCY_CODE CHARACTER VARYING(15) 15
19 CURRENCY_CONVERSION_RATE NUMERIC(18,2) 19
20 CURRENCY_CONVERSION_TYPE CHARACTER VARYING(30) 30
21 CURRENCY_CONVERSION_DATE TIMESTAMP 8
22 TAXABLE_ENTERED_DR NUMERIC(18,2) 19
23 TAXABLE_ENTERED_CR NUMERIC(18,2) 19
24 TAXABLE_ACCOUNTED_DR NUMERIC(18,2) 19
25 TAXABLE_ACCOUNTED_CR NUMERIC(18,2) 19
26 TAX_LINK_ID BIGINT 8
27 THIRD_PARTY_ID BIGINT 8
28 THIRD_PARTY_SUB_ID BIGINT 8
29 REVERSED_SOURCE_ID BIGINT 8
30 TAX_CODE_ID BIGINT 8
31 LOCATION_SEGMENT_ID BIGINT 8
32 SOURCE_TYPE_SECONDARY CHARACTER VARYING(30) 30
33 TAX_GROUP_CODE_ID BIGINT 8
34 REF_CUSTOMER_TRX_LINE_ID BIGINT 8
35 REF_CUST_TRX_LINE_GL_DIST_ID BIGINT 8
36 REF_ACCOUNT_CLASS CHARACTER VARYING(30) 30
37 ACTIVITY_BUCKET CHARACTER VARYING(30) 30
38 REF_LINE_ID BIGINT 8
39 FROM_AMOUNT_DR NUMERIC(18,2) 19
40 FROM_AMOUNT_CR NUMERIC(18,2) 19
41 FROM_ACCTD_AMOUNT_DR NUMERIC(18,2) 19
42 FROM_ACCTD_AMOUNT_CR NUMERIC(18,2) 19
43 REF_MF_DIST_FLAG CHARACTER VARYING(1) 1
44 REF_DIST_CCID BIGINT 8
45 REF_PREV_CUST_TRX_LINE_ID BIGINT 8
46 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
47 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
48 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
49 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8