Table_Name | Column_Name | Data Type | Data Length |
|---|---|---|---|
C1_BI_BILL_VW | ILM_DT | DATE | 10 |
C1_BI_BILL_VW | ILM_ARCH_SW | CHAR | 1 |
C1_BI_BILLED_USAGE_VW | ILM_DT | DATE | 10 |
C1_BI_BILLED_USAGE_VW | ILM_ARCH_SW | CHAR | 1 |
C1_BI_FTGL_MONTHLY_A | ACCOUNTING_MONTH | NUMBER | 6 |
C1_BI_FTGL_MONTHLY_A | BEGIN_ACCOUNTING_DT | DATE | 10 |
C1_BI_FTGL_MONTHLY_A | CIS_DIVISION | CHAR | 5 |
C1_BI_FTGL_MONTHLY_A | CUST_CL_CD | CHAR | 8 |
C1_BI_FTGL_MONTHLY_A | DST_ID | CHAR | 10 |
C1_BI_FTGL_MONTHLY_A | FT_GL_AMT | NUMBER | 15 |
C1_BI_FTGL_MONTHLY_A | FT_GL_CNT | NUMBER | 10 |
C1_BI_FTGL_MONTHLY_A | FT_GL_CREDIT_AMT | NUMBER | 15 |
C1_BI_FTGL_MONTHLY_A | FT_GL_DEBIT_AMT | NUMBER | 15 |
C1_BI_FTGL_MONTHLY_A | FT_GL_REV_AMT | NUMBER | 15 |
C1_BI_FTGL_MONTHLY_A | FT_GL_TAX_AMT | NUMBER | 15 |
C1_BI_FTGL_MONTHLY_A | FT_TYPE_FLG | CHAR | 2 |
C1_BI_FTGL_MONTHLY_A | GL_ACCT | VARC | 254 |
C1_BI_FTGL_MONTHLY_A | GL_DIVISION | CHAR | 5 |
C1_BI_FTGL_MONTHLY_A | RS_CD | CHAR | 8 |
C1_BI_FTGL_MONTHLY_A | SA_TYPE_CD | CHAR | 8 |
C1_BI_FTGL_MONTHLY_A | STATISTIC_AMT | NUMBER | 15 |
C1_BI_FT_MONTHLY_A | ACCOUNTING_MONTH | NUMBER | 6 |
C1_BI_FT_MONTHLY_A | BEGIN_ACCOUNTING_DT | DATE | 10 |
C1_BI_FT_MONTHLY_A | CIS_DIVISION | CHAR | 5 |
C1_BI_FT_MONTHLY_A | CUR_AMT | NUMBER | 15 |
C1_BI_FT_MONTHLY_A | CUST_CL_CD | CHAR | 8 |
C1_BI_FT_MONTHLY_A | FT_CNT | NUMBER | 10 |
C1_BI_FT_MONTHLY_A | FT_GL_REV_AMT | NUMBER | 15 |
C1_BI_FT_MONTHLY_A | FT_GL_TAX_AMT | NUMBER | 15 |
C1_BI_FT_MONTHLY_A | FT_OTHER_AMT | NUMBER | 15 |
C1_BI_FT_MONTHLY_A | FT_TYPE_FLG | CHAR | 2 |
C1_BI_FT_MONTHLY_A | GL_DIVISION | CHAR | 5 |
C1_BI_FT_MONTHLY_A | RS_CD | CHAR | 8 |
C1_BI_FT_MONTHLY_A | SA_TYPE_CD | CHAR | 8 |
C1_BI_FT_MONTHLY_A | TOT_AMT | NUMBER | 15 |
C1_BI_WOPROC_VW | ACCT_ID | CHAR | 10 |
C1_BI_WOPROC_VW | ACTIVE_WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | ARS_AT_END | NUMBER | 15,2 |
C1_BI_WOPROC_VW | ARS_AT_START | NUMBER | 15,2 |
C1_BI_WOPROC_VW | ARS_DIFF | NUMBER | 15,2 |
C1_BI_WOPROC_VW | CANCL_SYS_WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | CANCL_USER_WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | COMMENTS | VARCHAR | 254 |
C1_BI_WOPROC_VW | COMPL_WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | CRE_DTTM | DTTM | 10 |
C1_BI_WOPROC_VW | CURRENCY_CD | CHAR | 3 |
C1_BI_WOPROC_VW | EFF_WO_EVT_TYP_CD | CHAR | 12 |
C1_BI_WOPROC_VW | EFF_WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | INACTIVE_WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | INEFF_WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | NEXT_WO_EVT_TRIGGER_DT | DATE | 10 |
C1_BI_WOPROC_VW | NEXT_WO_EVT_TYP_CD | CHAR | 12 |
C1_BI_WOPROC_VW | PER_ID | CHAR | 10 |
C1_BI_WOPROC_VW | UNCOLL_PROC_DUR | NUMBER | 5 |
C1_BI_WOPROC_VW | UNCOLL_PROC_ID | CHAR | 10 |
C1_BI_WOPROC_VW | UNCOLL_PROC_STAT_FLG | CHAR | 4 |
C1_BI_WOPROC_VW | WO_CNTL_CD | CHAR | 20 |
C1_BI_WOPROC_VW | WO_PROC_ACT_SA_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | WO_PROC_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | WO_PROC_COMPL_DT | DATE | 10 |
C1_BI_WOPROC_VW | WO_PROC_INACT_SA_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | WO_PROC_TMPL_CD | CHAR | 12 |
C1_BI_WOPROC_VW | WO_PROC_TOT_SA_CNT | NUMBER | 9 |
C1_BI_WOPROC_VW | WO_STATUS_FLG | CHAR | 2 |
C1_BI_WOPROC_VW | WO_STAT_RSN_FLG | CHAR | 2 |
C1_CIS_DIV_RTYP | OVRD_WEB_DEBIT_ACCT_VAL_ALG_CD | CHAR | 12 |
C1_CS_REQ | C1_CREATED_BY_USER | CHAR | 8 |
C1_CS_REQ | C1_FINAL_DTTM | DATE | 26 |
C1_CS_REQ | C1_FINAL_USER | CHAR | 8 |
C1_OFFCYC_BGEN_ADJ | SEQNO | NUMBER | 5 |
C1_OFFCYC_BGEN_BCHG | SEQNO | NUMBER | 5 |
C1_OFFCYC_BGEN_BSEG | BO_XML_DATA_AREA | XMLTYPE | 1073741824 |
C1_OFFCYC_BGEN_BSEG | BSEG_CLASS_FLG | CHAR | 4 |
C1_OFFCYC_BGEN_BSEG | BSEG_ID | CHAR | 12 |
C1_OFFCYC_BGEN_BSEG | OFFCYC_BGEN_ID | CHAR | 12 |
C1_OFFCYC_BGEN_BSEG | VERSION | NUMBER | 5 |
C1_OFFCYC_BGEN_SA | SEQNO | NUMBER | 5 |
C1_PER_CONTDET | CONTACT_EXT_ID | VARC | 254 |
C1_PER_SS_PAYOPT | PER_PAY_OPT_NAME | VARC | 254 |
CI_APAY_CLR_STG | PRENOTE_SW | CHAR | 1 |
CI_APAY_RT_TYPE | WEB_DEBIT_ACCT_VAL_ALG_CD | CHAR | 12 |
CI_APAY_SRC | PRENOTE_TENDER_TYPE_CD | CHAR | 4 |
CI_CC_TYPE | BUS_OBJ_CD | CHAR | 30 |
X1_BI_CASE_VW | ILM_DT | DATE | 10 |
X1_BI_CASE_VW | ILM_ARCH_SW | CHAR | 1 |