CREATE TABLE cst_operation_adj_txns (
    OPERATION_ADJ_TXN_ID        NUMBER(18, 0) ,
    OPERATION_TRANSACTION_ID    NUMBER(18, 0)     NOT NULL,
    WO_UPDATE_EVENT_TXN_ID      NUMBER(18, 0) ,
    BASE_TXN_TYPE_ID            NUMBER(18, 0)     NOT NULL,
    BASE_TXN_SOURCE_TYPE_ID     NUMBER(18, 0)     NOT NULL,
    BASE_TXN_ACTION_ID          NUMBER(18, 0)     NOT NULL,
    EFF_DATE                    TIMESTAMP(6)      NOT NULL,
    COST_DATE                   TIMESTAMP(6)  ,
    PERIOD_NAME                 VARCHAR2(60)  ,
    COST_ORG_ID                 NUMBER(18, 0) ,
    COST_BOOK_ID                NUMBER(18, 0) ,
    POSTED_FLAG                 VARCHAR2(4)       NOT NULL,
    COSTING_STATUS              VARCHAR2(4)   ,
    ACCOUNTING_STATUS           VARCHAR2(4)   ,
    CREATED_BY                  VARCHAR2(256)     NOT NULL,
    CREATION_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY             VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    JOB_DEFINITION_NAME         VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE      VARCHAR2(3600),
    OPERATION_ADJ_TXN_ID        NUMBER(18, 0) ,
    OPERATION_TRANSACTION_ID    NUMBER(18, 0)     NOT NULL,
    WO_UPDATE_EVENT_TXN_ID      NUMBER(18, 0) ,
    BASE_TXN_TYPE_ID            NUMBER(18, 0)     NOT NULL,
    BASE_TXN_SOURCE_TYPE_ID     NUMBER(18, 0)     NOT NULL,
    BASE_TXN_ACTION_ID          NUMBER(18, 0)     NOT NULL,
    EFF_DATE                    TIMESTAMP(6)      NOT NULL,
    COST_DATE                   TIMESTAMP(6)  ,
    POSTED_FLAG                 VARCHAR2(4)       NOT NULL,
    COSTING_STATUS              VARCHAR2(4)   ,
    ACCOUNTING_STATUS           VARCHAR2(4)   ,
    CREATED_BY                  VARCHAR2(256)     NOT NULL,
    CREATION_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY             VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    JOB_DEFINITION_NAME         VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE      VARCHAR2(3600),
    PERIOD_NAME                 VARCHAR2(60)  ,
    COST_ORG_ID                 NUMBER(18, 0) ,
    COST_BOOK_ID                NUMBER(18, 0) ,
    CONSTRAINT pk_cst_operation_adj_txns PRIMARY KEY (OPERATION_ADJ_TXN_ID, OPERATION_ADJ_TXN_ID)
);
