CREATE TABLE fla_lease_asset_serials (
    ASSET_SERIAL_ID              NUMBER(18, 0),
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    ASSET_NUMBER                 VARCHAR2(120)    NOT NULL,
    LEASE_DETAIL_ID              NUMBER(18, 0)    NOT NULL,
    LEASE_ID                     NUMBER(18, 0)    NOT NULL,
    EMPLOYEE_ID                  NUMBER(18, 0),
    INSTALL_SITE_ID              NUMBER(18, 0),
    SERIAL_NUMBER                VARCHAR2(320),
    SERIAL_STATUS_CODE           VARCHAR2(120),
    DATA_SOURCE_CODE             VARCHAR2(120),
    PARENT_RECORD_ID             NUMBER(18, 0),
    CHANGE_TYPE_CODE             VARCHAR2(120)    NOT NULL,
    CHANGED_IN_VERSION_NUM       NUMBER(9, 0)     NOT NULL,
    SYSTEM_ORIGIN_REFERENCE_1    VARCHAR2(120),
    SYSTEM_ORIGIN_REFERENCE_2    VARCHAR2(120),
    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),
    ATTRIBUTE_CATEGORY           VARCHAR2(120),
    ATTRIBUTE_CHAR1              VARCHAR2(600),
    ATTRIBUTE_CHAR2              VARCHAR2(600),
    ATTRIBUTE_CHAR3              VARCHAR2(600),
    ATTRIBUTE_CHAR4              VARCHAR2(600),
    ATTRIBUTE_CHAR5              VARCHAR2(600),
    ATTRIBUTE_CHAR6              VARCHAR2(600),
    ATTRIBUTE_CHAR7              VARCHAR2(600),
    ATTRIBUTE_CHAR8              VARCHAR2(600),
    ATTRIBUTE_CHAR9              VARCHAR2(600),
    ATTRIBUTE_CHAR10             VARCHAR2(600),
    ATTRIBUTE_CHAR11             VARCHAR2(600),
    ATTRIBUTE_CHAR12             VARCHAR2(600),
    ATTRIBUTE_CHAR13             VARCHAR2(600),
    ATTRIBUTE_CHAR14             VARCHAR2(600),
    ATTRIBUTE_CHAR15             VARCHAR2(600),
    ATTRIBUTE_NUMBER1            NUMBER       ,
    ATTRIBUTE_NUMBER2            NUMBER       ,
    ATTRIBUTE_NUMBER3            NUMBER       ,
    ATTRIBUTE_NUMBER4            NUMBER       ,
    ATTRIBUTE_NUMBER5            NUMBER       ,
    ATTRIBUTE_DATE1              DATE         ,
    ATTRIBUTE_DATE2              DATE         ,
    ATTRIBUTE_DATE3              DATE         ,
    ATTRIBUTE_DATE4              DATE         ,
    ATTRIBUTE_DATE5              DATE         ,
    ASSET_SERIAL_ID              NUMBER(18, 0),
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    ASSET_NUMBER                 VARCHAR2(120)    NOT NULL,
    LEASE_DETAIL_ID              NUMBER(18, 0)    NOT NULL,
    LEASE_ID                     NUMBER(18, 0)    NOT NULL,
    EMPLOYEE_ID                  NUMBER(18, 0),
    INSTALL_SITE_ID              NUMBER(18, 0),
    SERIAL_NUMBER                VARCHAR2(320),
    DATA_SOURCE_CODE             VARCHAR2(120),
    PARENT_RECORD_ID             NUMBER(18, 0),
    CHANGE_TYPE_CODE             VARCHAR2(120)    NOT NULL,
    CHANGED_IN_VERSION_NUM       NUMBER(9, 0)     NOT NULL,
    SYSTEM_ORIGIN_REFERENCE_1    VARCHAR2(120),
    SYSTEM_ORIGIN_REFERENCE_2    VARCHAR2(120),
    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),
    ATTRIBUTE_CATEGORY           VARCHAR2(120),
    ATTRIBUTE_CHAR1              VARCHAR2(600),
    ATTRIBUTE_CHAR2              VARCHAR2(600),
    ATTRIBUTE_CHAR3              VARCHAR2(600),
    ATTRIBUTE_CHAR4              VARCHAR2(600),
    ATTRIBUTE_CHAR5              VARCHAR2(600),
    ATTRIBUTE_CHAR6              VARCHAR2(600),
    ATTRIBUTE_CHAR7              VARCHAR2(600),
    ATTRIBUTE_CHAR8              VARCHAR2(600),
    ATTRIBUTE_CHAR9              VARCHAR2(600),
    ATTRIBUTE_CHAR10             VARCHAR2(600),
    ATTRIBUTE_CHAR11             VARCHAR2(600),
    ATTRIBUTE_CHAR12             VARCHAR2(600),
    ATTRIBUTE_CHAR13             VARCHAR2(600),
    ATTRIBUTE_CHAR14             VARCHAR2(600),
    ATTRIBUTE_CHAR15             VARCHAR2(600),
    ATTRIBUTE_NUMBER1            NUMBER       ,
    ATTRIBUTE_NUMBER2            NUMBER       ,
    ATTRIBUTE_NUMBER3            NUMBER       ,
    ATTRIBUTE_NUMBER4            NUMBER       ,
    ATTRIBUTE_NUMBER5            NUMBER       ,
    ATTRIBUTE_DATE1              DATE         ,
    ATTRIBUTE_DATE2              DATE         ,
    ATTRIBUTE_DATE3              DATE         ,
    ATTRIBUTE_DATE4              DATE         ,
    ATTRIBUTE_DATE5              DATE         ,
    SERIAL_STATUS_CODE           VARCHAR2(120),
    CONSTRAINT pk_fla_lease_asset_serials PRIMARY KEY (ASSET_SERIAL_ID, ASSET_SERIAL_ID)
);
