CREATE TABLE `app_1_movart` (
	`MADMOV` DATE NULL DEFAULT NULL,
	`MANMOV` INT(11) NULL DEFAULT '0',
	`MANRIG` SMALLINT(6) NULL DEFAULT '0',
	`MATIP` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MATMCOD` CHAR(2) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MAARCOD1` CHAR(15) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MATCMCOD` CHAR(3) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MATCMTIP` CHAR(2) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MACFX` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MACLI` CHAR(7) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MAUNIT` CHAR(2) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MADER` DECIMAL(8,3) NULL DEFAULT '0.000',
	`MAQMOV` DECIMAL(13,4) NULL DEFAULT '0.0000',
	`MAVALUN` DECIMAL(16,6) NULL DEFAULT '0.000000',
	`MASCO1` DECIMAL(6,2) NULL DEFAULT '0.00',
	`MASCO2` DECIMAL(6,2) NULL DEFAULT '0.00',
	`MAIMPON` DECIMAL(16,6) NULL DEFAULT '0.000000',
	`MAIMPOS` DECIMAL(15,6) NULL DEFAULT '0.000000',
	`MAPIU` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MAASCOD` CHAR(3) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MACOLLI` SMALLINT(6) NULL DEFAULT '0',
	`MATARA` DECIMAL(7,3) NULL DEFAULT '0.000',
	`MA_IMB` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MALDMOV` DATE NULL DEFAULT NULL,
	`MALNMOV` INT(11) NULL DEFAULT '0',
	`MALNRIG` SMALLINT(6) NULL DEFAULT '0',
	`MALPREL` DECIMAL(13,4) NULL DEFAULT '0.0000',
	`MASCOCF1` DECIMAL(6,2) NULL DEFAULT '0.00',
	`MASCOCF2` DECIMAL(6,2) NULL DEFAULT '0.00',
	`MAOPER` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MAPROV` CHAR(3) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MASCASSA` DECIMAL(6,2) NULL DEFAULT '0.00',
	`MAPROM` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_GVUOTI` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MASCOQNT` SMALLINT(6) NULL DEFAULT '0',
	`MAORDIMP` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MATMCODS` CHAR(2) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG1` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG2` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG3` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG4` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG5` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG6` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG7` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`MA_MVFLG8` CHAR(1) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`_ID_MOVART` INT(11) NOT NULL AUTO_INCREMENT,
	`_II_SQLUSR` CHAR(15) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`_II_SQLTMS` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
	`_II_SQLREC` CHAR(10) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`_IK_SQLCHK` CHAR(5) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	`_IK_SQLSEQ` CHAR(14) NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	PRIMARY KEY (`_ID_MOVART`) USING BTREE,
	INDEX `KC_MOVART01` (`MADMOV`, `MANMOV`, `MANRIG`) USING BTREE,
	INDEX `KC_MOVART02` (`MATMCOD`, `MAARCOD1`, `MADMOV`, `MANMOV`, `MANRIG`) USING BTREE,
	INDEX `KC_MOVART03` (`MATMCOD`, `MATCMTIP`, `MAARCOD1`, `MADMOV`, `MANMOV`, `MANRIG`) USING BTREE,
	INDEX `KC_MOVART04` (`MATMCOD`, `MATCMTIP`, `MAARCOD1`, `MADMOV`, `MANMOV`, `MANRIG`) USING BTREE,
	INDEX `KC_MOVART05` (`MATMCOD`, `MACFX`, `MACLI`, `MADMOV`, `MANMOV`, `MANRIG`, `MAARCOD1`) USING BTREE,
	INDEX `KC_MOVART06` (`MATMCOD`, `MATCMTIP`, `MACFX`, `MACLI`, `MAARCOD1`, `MADMOV`, `MANMOV`) USING BTREE,
	INDEX `KC_MOVART07` (`MATMCOD`, `MALDMOV`, `MALNMOV`, `MALNRIG`) USING BTREE,
	INDEX `KT_MADMOV` (`MADMOV`) USING BTREE,
	INDEX `KT_MANMOV` (`MANMOV`) USING BTREE,
	INDEX `KT_MANRIG` (`MANRIG`) USING BTREE,
	INDEX `KT_MATIP` (`MATIP`) USING BTREE,
	INDEX `KT_MATMCOD` (`MATMCOD`) USING BTREE,
	INDEX `KT_MAARCOD1` (`MAARCOD1`) USING BTREE,
	INDEX `KT_MATCMTIP` (`MATCMTIP`) USING BTREE,
	INDEX `KT_MACFX` (`MACFX`) USING BTREE,
	INDEX `KT_MACLI` (`MACLI`) USING BTREE,
	INDEX `KT_MAQMOV` (`MAQMOV`) USING BTREE,
	INDEX `KT_MALDMOV` (`MALDMOV`) USING BTREE,
	INDEX `KT_MALNMOV` (`MALNMOV`) USING BTREE,
	INDEX `KT_MALNRIG` (`MALNRIG`) USING BTREE,
	INDEX `KT_MALPREL` (`MALPREL`) USING BTREE,
	INDEX `KT_MATMCODS` (`MATMCODS`) USING BTREE,
	INDEX `KT__II_SQLTMS` (`_II_SQLTMS`) USING BTREE,
	INDEX `KT__II_SQLREC` (`_II_SQLREC`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=Aria
ROW_FORMAT=FIXED
AUTO_INCREMENT=9787654
;