HOGR_GL_ROLL

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 USER_GL_ACCT CHARACTER VARYING(7) 7
3 EFFT_DATE CHARACTER VARYING(10) 10
4 EXPY_DATE CHARACTER VARYING(10) 10
5 MAINT_DATE CHARACTER VARYING(10) 10
6 CCID CHARACTER VARYING(10) 10
7 OPERATOR_ID CHARACTER VARYING(8) 8
8 INPUT_GL_CC CHARACTER VARYING(7) 7
9 ROLLUP_GL_CC CHARACTER VARYING(7) 7
10 ROLLUP_GL_AC CHARACTER VARYING(43) 43
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8