CREATE TABLE ar_recon_summary_parameters (
    REQUEST_ID                      NUMBER(18, 0) ,
    RECON_SUMMARY_PARAM_ID          NUMBER(18, 0) ,
    REQUEST_NAME                    VARCHAR2(1600)    NOT NULL,
    LEDGER_ID                       NUMBER(18, 0)     NOT NULL,
    BU_ID                           NUMBER(18, 0) ,
    PERIOD_NAME                     VARCHAR2(60)      NOT NULL,
    PERIOD_START_DATE               DATE          ,
    PERIOD_END_DATE                 DATE          ,
    INCLUDE_ON_ACCOUNT_ITEM         VARCHAR2(4)   ,
    INCLUDE_INTERCOMPANY_TRX        VARCHAR2(4)   ,
    INCLUDE_UNAPP_UNID_RECEIPTS     VARCHAR2(4)   ,
    BALANCING_SEGMENT_FROM          VARCHAR2(100) ,
    BALANCING_SEGMENT_TO            VARCHAR2(100) ,
    COST_CENTRE_SEGMENT_FROM        VARCHAR2(100) ,
    COST_CENTRE_SEGMENT_TO          VARCHAR2(100) ,
    NATURAL_ACCOUNT_SEGMENT_FROM    VARCHAR2(100) ,
    NATURAL_ACCOUNT_SEGMENT_TO      VARCHAR2(100) ,
    INTERCOMPANY_SEGMENT_FROM       VARCHAR2(100) ,
    INTERCOMPANY_SEGMENT_TO         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),
    REQUEST_ID                      NUMBER(18, 0) ,
    RECON_SUMMARY_PARAM_ID          NUMBER(18, 0) ,
    REQUEST_NAME                    VARCHAR2(1600)    NOT NULL,
    LEDGER_ID                       NUMBER(18, 0)     NOT NULL,
    BU_ID                           NUMBER(18, 0) ,
    PERIOD_NAME                     VARCHAR2(60)      NOT NULL,
    PERIOD_START_DATE               DATE          ,
    PERIOD_END_DATE                 DATE          ,
    INCLUDE_ON_ACCOUNT_ITEM         VARCHAR2(4)   ,
    INCLUDE_INTERCOMPANY_TRX        VARCHAR2(4)   ,
    INCLUDE_UNAPP_UNID_RECEIPTS     VARCHAR2(4)   ,
    BALANCING_SEGMENT_FROM          VARCHAR2(100) ,
    BALANCING_SEGMENT_TO            VARCHAR2(100) ,
    COST_CENTRE_SEGMENT_FROM        VARCHAR2(100) ,
    COST_CENTRE_SEGMENT_TO          VARCHAR2(100) ,
    NATURAL_ACCOUNT_SEGMENT_FROM    VARCHAR2(100) ,
    NATURAL_ACCOUNT_SEGMENT_TO      VARCHAR2(100) ,
    INTERCOMPANY_SEGMENT_FROM       VARCHAR2(100) ,
    INTERCOMPANY_SEGMENT_TO         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_parameters PRIMARY KEY (RECON_SUMMARY_PARAM_ID, RECON_SUMMARY_PARAM_ID)
);
