OEB_AP_ACCOUNTING_EVENTS_ALL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACCOUNTING_EVENT_ID BIGINT 8
2 EVENT_TYPE_CODE CHARACTER VARYING(30) 30
3 ACCOUNTING_DATE TIMESTAMP 8
4 EVENT_NUMBER BIGINT 8
5 EVENT_STATUS_CODE CHARACTER VARYING(30) 30
6 SOURCE_TABLE CHARACTER VARYING(30) 30
7 SOURCE_ID BIGINT 8
8 CREATION_DATE TIMESTAMP 8
9 CREATED_BY BIGINT 8
10 LAST_UPDATE_DATE TIMESTAMP 8
11 LAST_UPDATED_BY BIGINT 8
12 LAST_UPDATE_LOGIN BIGINT 8
13 PROGRAM_UPDATE_DATE TIMESTAMP 8
14 PROGRAM_ID BIGINT 8
15 PROGRAM_APPLICATION_ID BIGINT 8
16 REQUEST_ID BIGINT 8
17 ORG_ID BIGINT 8
18 CANNOT_ACCOUNT_FLAG CHARACTER VARYING(1) 1
19 AX_ACCOUNTED_FLAG CHARACTER VARYING(1) 1
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8