CREATE TABLE cst_rc_stg_143_dyd (
    TRANSACTION_ID                NUMBER(18, 0)    NOT NULL,
    REC_TRXN_ID                   NUMBER(18, 0)    NOT NULL,
    DEP_TRXN_ID                   NUMBER(18, 0)    NOT NULL,
    COST_ELEMENT_ID               NUMBER(18, 0)    NOT NULL,
    EXPENSE_POOL_ID               NUMBER(18, 0)    NOT NULL,
    EFF_DATE                      TIMESTAMP(6)     NOT NULL,
    TRANSACTION_COST_ID           NUMBER(18, 0)    NOT NULL,
    COST_ORG_ID                   NUMBER(18, 0),
    COST_BOOK_ID                  NUMBER(18, 0),
    INVENTORY_ITEM_ID             NUMBER(18, 0),
    VAL_UNIT_ID                   NUMBER(18, 0),
    COST_DATE                     TIMESTAMP(6) ,
    BASE_TXN_TYPE_ID              NUMBER(18, 0),
    COST_SOURCE                   VARCHAR2(120),
    COST_REFERENCE                VARCHAR2(400),
    BASE_TXN_ACTION_ID            NUMBER(18, 0),
    BASE_TXN_SOURCE_TYPE_ID       NUMBER(18, 0),
    COST_TRANSACTION_TYPE         VARCHAR2(40) ,
    ADDITIONAL_PROCESSING_CODE    VARCHAR2(960),
    COST_COMPONENT_CODE           VARCHAR2(120),
    QUANTITY                      NUMBER       ,
    UOM_CODE                      VARCHAR2(100),
    UNIT_COST                     NUMBER       ,
    CURRENCY_CODE                 VARCHAR2(120)    NOT NULL,
    ADJUSTMENT_FLAG               VARCHAR2(4)      NOT NULL,
    POSTED_FLAG                   VARCHAR2(4)  ,
    REQUEST_ID                    NUMBER(18, 0),
    PERPAVG_COST_ID               NUMBER(18, 0),
    STD_COST_ID                   NUMBER(18, 0),
    TRANSACTION_ID                NUMBER(18, 0)    NOT NULL,
    REC_TRXN_ID                   NUMBER(18, 0)    NOT NULL,
    DEP_TRXN_ID                   NUMBER(18, 0)    NOT NULL,
    COST_ELEMENT_ID               NUMBER(18, 0)    NOT NULL,
    EXPENSE_POOL_ID               NUMBER(18, 0)    NOT NULL,
    EFF_DATE                      TIMESTAMP(6)     NOT NULL,
    TRANSACTION_COST_ID           NUMBER(18, 0)    NOT NULL,
    COST_ORG_ID                   NUMBER(18, 0),
    COST_BOOK_ID                  NUMBER(18, 0),
    INVENTORY_ITEM_ID             NUMBER(18, 0),
    VAL_UNIT_ID                   NUMBER(18, 0),
    COST_DATE                     TIMESTAMP(6) ,
    BASE_TXN_TYPE_ID              NUMBER(18, 0),
    COST_SOURCE                   VARCHAR2(120),
    COST_REFERENCE                VARCHAR2(400),
    BASE_TXN_ACTION_ID            NUMBER(18, 0),
    BASE_TXN_SOURCE_TYPE_ID       NUMBER(18, 0),
    COST_TRANSACTION_TYPE         VARCHAR2(40) ,
    ADDITIONAL_PROCESSING_CODE    VARCHAR2(960),
    COST_COMPONENT_CODE           VARCHAR2(120),
    QUANTITY                      NUMBER       ,
    UOM_CODE                      VARCHAR2(100),
    UNIT_COST                     NUMBER       ,
    CURRENCY_CODE                 VARCHAR2(120)    NOT NULL,
    ADJUSTMENT_FLAG               VARCHAR2(4)      NOT NULL,
    POSTED_FLAG                   VARCHAR2(4)  ,
    REQUEST_ID                    NUMBER(18, 0),
    PERPAVG_COST_ID               NUMBER(18, 0),
    STD_COST_ID                   NUMBER(18, 0)
);
