CREATE TABLE inv_serial_item_controls (
    INVENTORY_ITEM_ID           NUMBER(18, 0),
    ORGANIZATION_ID             NUMBER(18, 0),
    AUTO_SERIAL_ALPHA_PREFIX    VARCHAR2(320),
    START_AUTO_SERIAL_NUMBER    VARCHAR2(320),
    NEXT_AUTO_SERIAL_NUMBER     VARCHAR2(320),
    CREATION_DATE               TIMESTAMP(6)     NOT NULL,
    CREATED_BY                  VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY             VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128),
    INVENTORY_ITEM_ID           NUMBER(18, 0),
    ORGANIZATION_ID             NUMBER(18, 0),
    AUTO_SERIAL_ALPHA_PREFIX    VARCHAR2(320),
    START_AUTO_SERIAL_NUMBER    VARCHAR2(320),
    NEXT_AUTO_SERIAL_NUMBER     VARCHAR2(320),
    CREATION_DATE               TIMESTAMP(6)     NOT NULL,
    CREATED_BY                  VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY             VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128),
    CONSTRAINT pk_inv_serial_item_controls PRIMARY KEY (INVENTORY_ITEM_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID)
);
