CREATE TABLE ar_recon_summary_ccid (
    LEDGER_ID                  NUMBER(18, 0)     NOT NULL,
    RECON_SUMMARY_CCID_ID      NUMBER(18, 0) ,
    REQUEST_ID                 NUMBER(18, 0) ,
    CODE_COMBINATION_ID        NUMBER(18, 0) ,
    CHART_OF_ACCOUNTS_ID       NUMBER(18, 0) ,
    BALANCING_SEGMENT          VARCHAR2(100) ,
    NATURAL_ACCOUNT_SEGMENT    VARCHAR2(100) ,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    JOB_DEFINITION_NAME        VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE     VARCHAR2(3600),
    LEDGER_ID                  NUMBER(18, 0)     NOT NULL,
    RECON_SUMMARY_CCID_ID      NUMBER(18, 0) ,
    REQUEST_ID                 NUMBER(18, 0) ,
    CODE_COMBINATION_ID        NUMBER(18, 0) ,
    CHART_OF_ACCOUNTS_ID       NUMBER(18, 0) ,
    BALANCING_SEGMENT          VARCHAR2(100) ,
    NATURAL_ACCOUNT_SEGMENT    VARCHAR2(100) ,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    JOB_DEFINITION_NAME        VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE     VARCHAR2(3600),
    CONSTRAINT pk_ar_recon_summary_ccid PRIMARY KEY (RECON_SUMMARY_CCID_ID, RECON_SUMMARY_CCID_ID)
);
