CREATE TABLE aca_pd_item_cost_int (
    INTERFACE_TABLE_UNIQUE_ID    NUMBER(18, 0) ,
    HAS_ERRORS                   NUMBER(1, 0)  ,
    BATCH_ID                     NUMBER(18, 0) ,
    BATCH_NUMBER                 VARCHAR2(160) ,
    PREPROCESS_THREAD_NUMBER     NUMBER(18, 0) ,
    THREAD_NUMBER                NUMBER(18, 0) ,
    BUNDLE_ID                    NUMBER(18, 0) ,
    PROCESS_STATUS               NUMBER        ,
    TRANSACTION_ID               NUMBER(18, 0) ,
    TRANSACTION_TYPE             VARCHAR2(40)  ,
    REQUEST_ID                   NUMBER(18, 0) ,
    LOAD_REQUEST_ID              NUMBER(18, 0) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    ITEM_NUMBER                  VARCHAR2(1200),
    INVENTORY_ITEM_ID            NUMBER(18, 0) ,
    ORGANIZATION_CODE            VARCHAR2(72)  ,
    ORGANIZATION_ID              NUMBER(18, 0) ,
    SOURCE_SYSTEM_ID             NUMBER(18, 0) ,
    SOURCE_SYSTEM_REFERENCE      VARCHAR2(1020),
    SOURCE_SYSTEM_CODE           VARCHAR2(120) ,
    ITEM_COST_ID                 NUMBER(18, 0) ,
    COST_SOURCE                  VARCHAR2(4)   ,
    CURRENCY_CODE                VARCHAR2(60)  ,
    MATERIAL_COST                NUMBER        ,
    LAST_CONTRACT_PRICE          NUMBER        ,
    INTERFACE_TABLE_UNIQUE_ID    NUMBER(18, 0) ,
    HAS_ERRORS                   NUMBER(1, 0)  ,
    BATCH_ID                     NUMBER(18, 0) ,
    BATCH_NUMBER                 VARCHAR2(160) ,
    PREPROCESS_THREAD_NUMBER     NUMBER(18, 0) ,
    THREAD_NUMBER                NUMBER(18, 0) ,
    BUNDLE_ID                    NUMBER(18, 0) ,
    PROCESS_STATUS               NUMBER        ,
    TRANSACTION_ID               NUMBER(18, 0) ,
    TRANSACTION_TYPE             VARCHAR2(40)  ,
    REQUEST_ID                   NUMBER(18, 0) ,
    LOAD_REQUEST_ID              NUMBER(18, 0) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    ITEM_NUMBER                  VARCHAR2(1200),
    INVENTORY_ITEM_ID            NUMBER(18, 0) ,
    ORGANIZATION_CODE            VARCHAR2(72)  ,
    ORGANIZATION_ID              NUMBER(18, 0) ,
    SOURCE_SYSTEM_ID             NUMBER(18, 0) ,
    SOURCE_SYSTEM_REFERENCE      VARCHAR2(1020),
    SOURCE_SYSTEM_CODE           VARCHAR2(120) ,
    ITEM_COST_ID                 NUMBER(18, 0) ,
    COST_SOURCE                  VARCHAR2(4)   ,
    CURRENCY_CODE                VARCHAR2(60)  ,
    MATERIAL_COST                NUMBER        ,
    LAST_CONTRACT_PRICE          NUMBER        
);
