CREATE TABLE inv_balance_txns_int (
    TRANSACTION_INTERFACE_ID          NUMBER(18, 0) ,
    DOCUMENT_NUMBER                   NUMBER(18, 0) ,
    MESSAGE_CREATION_DATE             DATE          ,
    SOURCE_SYSTEM_ID                  NUMBER(18, 0) ,
    SOURCE_SYSTEM_NAME                VARCHAR2(320) ,
    SOURCE_SYSTEM_CODE                VARCHAR2(120) ,
    ORGANIZATION_ID                   NUMBER(18, 0) ,
    ORGANIZATION_NAME                 VARCHAR2(960) ,
    ORGANIZATION_CODE                 VARCHAR2(72)  ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0) ,
    ITEM_NUMBER                       VARCHAR2(1200),
    REVISION                          VARCHAR2(72)  ,
    SUBINVENTORY                      VARCHAR2(40)  ,
    LOCATOR_ID                        NUMBER(18, 0) ,
    LOCATOR_NAME                      VARCHAR2(1020),
    PARENT_LPN_ID                     NUMBER(18, 0) ,
    PARENT_LPN_NUMBER                 VARCHAR2(120) ,
    OUTERMOST_LPN_ID                  NUMBER(18, 0) ,
    OUTERMOST_LPN_NUMBER              VARCHAR2(120) ,
    LPN_DISCREPANCY_FLAG              VARCHAR2(4)   ,
    DISC_SUBINVENTORY                 VARCHAR2(40)  ,
    DISC_LOCATOR_ID                   NUMBER(18, 0) ,
    PRIMARY_UOM_QUANTITY              NUMBER        ,
    PRIMARY_UOM_CODE                  VARCHAR2(12)  ,
    PRIMARY_UNIT_OF_MEASURE           VARCHAR2(100) ,
    SECONDARY_UOM_QUANTITY            NUMBER        ,
    SECONDARY_UOM_CODE                VARCHAR2(12)  ,
    SECONDARY_UNIT_OF_MEASURE         VARCHAR2(100) ,
    OWNING_TRADING_PARTNER_TYPE       VARCHAR2(120) ,
    OWNING_ORGANIZATION_ID            NUMBER(18, 0) ,
    OWNING_ORGANIZATION_CODE          VARCHAR2(960) ,
    OWNING_ORGANIZATION_NAME          VARCHAR2(960) ,
    PRC_BU_NAME                       VARCHAR2(960) ,
    VENDOR_NAME                       VARCHAR2(960) ,
    VENDOR_NUMBER                     VARCHAR2(120) ,
    CONSIGNMENT_AGREEMENT_NUM         VARCHAR2(120) ,
    ACCOUNT_ALIAS_ID                  NUMBER(18, 0) ,
    ACCOUNT_ALIAS_NAME                VARCHAR2(1020),
    AGING_ONSET_DATE                  DATE          ,
    ROW_UPDATE_FLAG                   VARCHAR2(4)   ,
    ATTRIBUTE_CATEGORY                VARCHAR2(120) ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    ATTRIBUTE16                       VARCHAR2(600) ,
    ATTRIBUTE17                       VARCHAR2(600) ,
    ATTRIBUTE18                       VARCHAR2(600) ,
    ATTRIBUTE19                       VARCHAR2(600) ,
    ATTRIBUTE20                       VARCHAR2(600) ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_NUMBER6                 NUMBER        ,
    ATTRIBUTE_NUMBER7                 NUMBER        ,
    ATTRIBUTE_NUMBER8                 NUMBER        ,
    ATTRIBUTE_NUMBER9                 NUMBER        ,
    ATTRIBUTE_NUMBER10                NUMBER        ,
    ATTRIBUTE_TIMESTAMP1              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5              TIMESTAMP(6)  ,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)      NOT NULL,
    REQUEST_ID                        NUMBER(18, 0) ,
    JOB_DEFINITION_NAME               VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    PROCESSING_STATUS                 VARCHAR2(120) ,
    LOAD_REQUEST_ID                   NUMBER(18, 0) ,
    INV_LOT_SERIAL_NUM                VARCHAR2(120) ,
    ERROR_MESSAGE_CODE                VARCHAR2(200) ,
    ERROR_MESSAGE_TEXT                VARCHAR2(960) ,
    PRIMARY_ADJ_QUANTITY              NUMBER        ,
    SECONDARY_ADJ_QUANTITY            NUMBER        ,
    PRIMARY_SYSTEM_QUANTITY           NUMBER        ,
    SECONDARY_SYSTEM_QUANTITY         NUMBER        ,
    TXN_INTERFACE_GROUP_ID            NUMBER(18, 0) ,
    TRANSACTION_SOURCE_CODE           VARCHAR2(120) ,
    ITEM_LOT_CONTROL_CODE             VARCHAR2(120) ,
    ITEM_SERIAL_CONTROL_CODE          VARCHAR2(120) ,
    ITEM_REVISION_QTY_CONTROL_CODE    VARCHAR2(120) ,
    ITEM_UNIT_COST                    NUMBER        ,
    CURRENCY                          VARCHAR2(60)  ,
    COMMENTS                          VARCHAR2(960) ,
    ADJUSTMENT_PROCESSED_DATE         TIMESTAMP(6)  ,
    PRIMARY_POS_ADJ_QUANTITY          NUMBER        ,
    PRIMARY_NEG_ADJ_QUANTITY          NUMBER        ,
    SECONDARY_POS_ADJ_QUANTITY        NUMBER        ,
    SECONDARY_NEG_ADJ_QUANTITY        NUMBER        ,
    INV_STRIPING_CATEGORY             VARCHAR2(160) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    INV_PROJECT                       VARCHAR2(100) ,
    TASK_ID                           NUMBER(18, 0) ,
    INV_TASK                          VARCHAR2(400) ,
    COUNTRY_OF_ORIGIN_CODE            VARCHAR2(8)   ,
    COUNTRY_OF_ORIGIN_NAME            VARCHAR2(320) ,
    INV_RESERVED_ATTRIBUTE1           VARCHAR2(600) ,
    INV_RESERVED_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE1           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE3           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE4           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE5           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE6           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE7           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE8           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE9           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE10          VARCHAR2(600) ,
    TRANSACTION_INTERFACE_ID          NUMBER(18, 0) ,
    DOCUMENT_NUMBER                   NUMBER(18, 0) ,
    MESSAGE_CREATION_DATE             DATE          ,
    SOURCE_SYSTEM_ID                  NUMBER(18, 0) ,
    SOURCE_SYSTEM_NAME                VARCHAR2(320) ,
    SOURCE_SYSTEM_CODE                VARCHAR2(120) ,
    ORGANIZATION_ID                   NUMBER(18, 0) ,
    ORGANIZATION_NAME                 VARCHAR2(960) ,
    ORGANIZATION_CODE                 VARCHAR2(72)  ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0) ,
    ITEM_NUMBER                       VARCHAR2(1200),
    REVISION                          VARCHAR2(72)  ,
    SUBINVENTORY                      VARCHAR2(40)  ,
    LOCATOR_ID                        NUMBER(18, 0) ,
    LOCATOR_NAME                      VARCHAR2(1020),
    PRIMARY_UOM_QUANTITY              NUMBER        ,
    PRIMARY_UOM_CODE                  VARCHAR2(12)  ,
    PRIMARY_UNIT_OF_MEASURE           VARCHAR2(100) ,
    SECONDARY_UOM_QUANTITY            NUMBER        ,
    SECONDARY_UOM_CODE                VARCHAR2(12)  ,
    SECONDARY_UNIT_OF_MEASURE         VARCHAR2(100) ,
    OWNING_TRADING_PARTNER_TYPE       VARCHAR2(120) ,
    OWNING_ORGANIZATION_ID            NUMBER(18, 0) ,
    OWNING_ORGANIZATION_CODE          VARCHAR2(960) ,
    OWNING_ORGANIZATION_NAME          VARCHAR2(960) ,
    PRC_BU_NAME                       VARCHAR2(960) ,
    VENDOR_NAME                       VARCHAR2(960) ,
    VENDOR_NUMBER                     VARCHAR2(120) ,
    CONSIGNMENT_AGREEMENT_NUM         VARCHAR2(120) ,
    ACCOUNT_ALIAS_ID                  NUMBER(18, 0) ,
    ACCOUNT_ALIAS_NAME                VARCHAR2(1020),
    AGING_ONSET_DATE                  DATE          ,
    ATTRIBUTE_CATEGORY                VARCHAR2(120) ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    ATTRIBUTE16                       VARCHAR2(600) ,
    ATTRIBUTE17                       VARCHAR2(600) ,
    ATTRIBUTE18                       VARCHAR2(600) ,
    ATTRIBUTE19                       VARCHAR2(600) ,
    ATTRIBUTE20                       VARCHAR2(600) ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_NUMBER6                 NUMBER        ,
    ATTRIBUTE_NUMBER7                 NUMBER        ,
    ATTRIBUTE_NUMBER8                 NUMBER        ,
    ATTRIBUTE_NUMBER9                 NUMBER        ,
    ATTRIBUTE_NUMBER10                NUMBER        ,
    ATTRIBUTE_TIMESTAMP1              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP2              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP3              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP4              TIMESTAMP(6)  ,
    ATTRIBUTE_TIMESTAMP5              TIMESTAMP(6)  ,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)      NOT NULL,
    REQUEST_ID                        NUMBER(18, 0) ,
    JOB_DEFINITION_NAME               VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    PROCESSING_STATUS                 VARCHAR2(120) ,
    LOAD_REQUEST_ID                   NUMBER(18, 0) ,
    INV_LOT_SERIAL_NUM                VARCHAR2(120) ,
    ERROR_MESSAGE_CODE                VARCHAR2(200) ,
    ERROR_MESSAGE_TEXT                VARCHAR2(960) ,
    PRIMARY_ADJ_QUANTITY              NUMBER        ,
    SECONDARY_ADJ_QUANTITY            NUMBER        ,
    PRIMARY_SYSTEM_QUANTITY           NUMBER        ,
    SECONDARY_SYSTEM_QUANTITY         NUMBER        ,
    TXN_INTERFACE_GROUP_ID            NUMBER(18, 0) ,
    TRANSACTION_SOURCE_CODE           VARCHAR2(120) ,
    ITEM_LOT_CONTROL_CODE             VARCHAR2(120) ,
    ITEM_SERIAL_CONTROL_CODE          VARCHAR2(120) ,
    ITEM_REVISION_QTY_CONTROL_CODE    VARCHAR2(120) ,
    ITEM_UNIT_COST                    NUMBER        ,
    CURRENCY                          VARCHAR2(60)  ,
    COMMENTS                          VARCHAR2(960) ,
    ADJUSTMENT_PROCESSED_DATE         TIMESTAMP(6)  ,
    PRIMARY_POS_ADJ_QUANTITY          NUMBER        ,
    PRIMARY_NEG_ADJ_QUANTITY          NUMBER        ,
    SECONDARY_POS_ADJ_QUANTITY        NUMBER        ,
    SECONDARY_NEG_ADJ_QUANTITY        NUMBER        ,
    INV_STRIPING_CATEGORY             VARCHAR2(160) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    INV_PROJECT                       VARCHAR2(100) ,
    TASK_ID                           NUMBER(18, 0) ,
    INV_TASK                          VARCHAR2(400) ,
    COUNTRY_OF_ORIGIN_CODE            VARCHAR2(8)   ,
    COUNTRY_OF_ORIGIN_NAME            VARCHAR2(320) ,
    INV_RESERVED_ATTRIBUTE1           VARCHAR2(600) ,
    INV_RESERVED_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE1           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE3           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE4           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE5           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE6           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE7           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE8           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE9           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE10          VARCHAR2(600) ,
    PARENT_LPN_ID                     NUMBER(18, 0) ,
    PARENT_LPN_NUMBER                 VARCHAR2(120) ,
    OUTERMOST_LPN_ID                  NUMBER(18, 0) ,
    OUTERMOST_LPN_NUMBER              VARCHAR2(120) ,
    LPN_DISCREPANCY_FLAG              VARCHAR2(4)   ,
    DISC_SUBINVENTORY                 VARCHAR2(40)  ,
    DISC_LOCATOR_ID                   NUMBER(18, 0) ,
    ROW_UPDATE_FLAG                   VARCHAR2(4)   ,
    CONSTRAINT pk_inv_balance_txns_int PRIMARY KEY (TRANSACTION_INTERFACE_ID, TRANSACTION_INTERFACE_ID)
);
