CREATE TABLE cst_transaction_lyrs_i_gt (
    TRANSACTION_ID            NUMBER(18, 0)     NOT NULL,
    REC_TRXN_ID               NUMBER(18, 0)     NOT NULL,
    DEP_TRXN_ID               NUMBER(18, 0)     NOT NULL,
    COST_ORG_ID               NUMBER(18, 0)     NOT NULL,
    COST_BOOK_ID              NUMBER(18, 0)     NOT NULL,
    VAL_UNIT_ID               NUMBER(18, 0) ,
    INVENTORY_ITEM_ID         NUMBER(18, 0)     NOT NULL,
    COST_TRANSACTION_TYPE     VARCHAR2(40)  ,
    COST_DATE                 TIMESTAMP(6)      NOT NULL,
    PERIOD_NAME               VARCHAR2(60)  ,
    QUANTITY                  NUMBER        ,
    QUANTITY_ONHAND           NUMBER        ,
    UOM_CODE                  VARCHAR2(120) ,
    POSTED_FLAG               VARCHAR2(20)  ,
    VAL_ONHAND_FLAG           VARCHAR2(4)   ,
    REC_ONHAND_AVAIL_FLAG     VARCHAR2(4)   ,
    REC_ONHAND                NUMBER        ,
    COST_METHOD_CODE          VARCHAR2(120) ,
    ROW_UPDATED_FLAG          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),
    TRANSACTION_ID            NUMBER(18, 0)     NOT NULL,
    REC_TRXN_ID               NUMBER(18, 0)     NOT NULL,
    DEP_TRXN_ID               NUMBER(18, 0)     NOT NULL,
    COST_ORG_ID               NUMBER(18, 0)     NOT NULL,
    COST_BOOK_ID              NUMBER(18, 0)     NOT NULL,
    VAL_UNIT_ID               NUMBER(18, 0) ,
    INVENTORY_ITEM_ID         NUMBER(18, 0)     NOT NULL,
    COST_TRANSACTION_TYPE     VARCHAR2(40)  ,
    COST_DATE                 TIMESTAMP(6)      NOT NULL,
    PERIOD_NAME               VARCHAR2(60)  ,
    QUANTITY                  NUMBER        ,
    QUANTITY_ONHAND           NUMBER        ,
    UOM_CODE                  VARCHAR2(120) ,
    POSTED_FLAG               VARCHAR2(20)  ,
    VAL_ONHAND_FLAG           VARCHAR2(4)   ,
    REC_ONHAND_AVAIL_FLAG     VARCHAR2(4)   ,
    REC_ONHAND                NUMBER        ,
    COST_METHOD_CODE          VARCHAR2(120) ,
    ROW_UPDATED_FLAG          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)
);
