USE inventory;

CREATE TABLE `penerimaan_po_temp` (
	`ID_PO_DETIL` INT(11) NULL DEFAULT NULL COMMENT 'id_po_detil',
	`ID_PB` INT(11) NOT NULL DEFAULT '0' COMMENT 'id penerimaan barang',
	`BARANG` INT(11) NULL DEFAULT NULL COMMENT 'id barang',
	`JUMLAH_PESAN` DECIMAL(10,2) NOT NULL,
	`BONUS` DECIMAL(10,2) NOT NULL,
	`JUMLAH_TERIMA` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '0',
	`TERIMA_BONUS` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`MASA_BERLAKU` DATE NULL DEFAULT NULL,
	`NO_BATCH` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',
	`ONGKIR` DECIMAL(10,0) NOT NULL,
	`STATUS` INT(11) NULL DEFAULT '1' COMMENT '1-PROSE, 2-FINAL',
	INDEX `STATUS` (`STATUS`) USING BTREE,
	INDEX `ID_PO_DETIL` (`ID_PO_DETIL`) USING BTREE,
	INDEX `ID_PB_DETIL` (`ID_PB`) USING BTREE,
	INDEX `BARANG` (`BARANG`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
