-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 16, 2020 at 01:04 PM
-- Server version: 5.7.31
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `asianhar_opp`
--

-- --------------------------------------------------------

--
-- Table structure for table `0p4_gl_transaction`
--

CREATE TABLE `0p4_gl_transaction` (
  `gl_transaction_id` int(11) NOT NULL,
  `object` varchar(1024) NOT NULL,
  `pk` int(11) NOT NULL,
  `parent_object` varchar(1024) DEFAULT NULL,
  `parent_pk` int(11) DEFAULT NULL,
  `document_type` varchar(150) DEFAULT NULL,
  `transaction_no` varchar(50) DEFAULT NULL,
  `sub_transaction_no` varchar(50) DEFAULT NULL,
  `date` datetime NOT NULL,
  `description` text,
  `chart_of_account_id` int(11) NOT NULL,
  `gl_code` varchar(50) DEFAULT NULL,
  `gl_name` varchar(1024) DEFAULT NULL,
  `match_type` varchar(1024) DEFAULT NULL,
  `match_number` varchar(1024) DEFAULT NULL,
  `credit` decimal(16,4) DEFAULT NULL,
  `debit` decimal(16,4) DEFAULT NULL,
  `amount` decimal(16,4) DEFAULT NULL,
  `local_credit` decimal(16,4) DEFAULT NULL,
  `local_debit` decimal(16,4) DEFAULT NULL,
  `local_amount` decimal(16,4) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `supplier_name` varchar(150) DEFAULT NULL,
  `customer_name` varchar(150) DEFAULT NULL,
  `type` varchar(150) DEFAULT NULL,
  `reference_no` varchar(1024) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `sales_type` enum('LOCAL SALES','OVERSEA SALES') DEFAULT NULL,
  `exchange_rate` decimal(16,4) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `opening` tinyint(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `0p4_gl_transaction`
--

INSERT INTO `0p4_gl_transaction` (`gl_transaction_id`, `object`, `pk`, `parent_object`, `parent_pk`, `document_type`, `transaction_no`, `sub_transaction_no`, `date`, `description`, `chart_of_account_id`, `gl_code`, `gl_name`, `match_type`, `match_number`, `credit`, `debit`, `amount`, `local_credit`, `local_debit`, `local_amount`, `supplier_id`, `customer_id`, `supplier_name`, `customer_name`, `type`, `reference_no`, `item_id`, `currency_id`, `sales_type`, `exchange_rate`, `department_id`, `created_by`, `created_at`, `updated_by`, `updated_at`, `opening`) VALUES
(161653, 'app\\modules\\sale\\models\\Invoice', 6721, 'app\\modules\\sale\\models\\Invoice', 6721, 'INVOICE', 'IN-1912/00627', NULL, '2019-12-31 00:00:00', 'DEBIT', 209, '63007', 'TRADE DEBTORS', 'INVOICE', 'IN-1912/00627', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 536, NULL, 'MPH BOOKSTORES SDN BHD -  AIRPORT', 'AR', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-13 10:11:57', NULL, NULL, NULL),
(161654, 'app\\modules\\sale\\models\\InvoiceItems', 56581, 'app\\modules\\sale\\models\\Invoice', 6721, 'INVOICE', 'IN-1912/00627', NULL, '2019-12-31 00:00:00', 'CREDIT', 4, '12010-010', 'CREDIT SALES - PLUS', 'INVOICE', 'IN-1912/00627', 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, 536, NULL, 'MPH BOOKSTORES SDN BHD -  AIRPORT', 'AR', NULL, 3368, 2, NULL, 1.0000, NULL, 1, '2020-10-13 10:11:58', NULL, NULL, NULL),
(100910, 'app\\modules\\sale\\models\\VendorCreditNote', 1, 'app\\modules\\sale\\models\\VendorCreditNote', 1, 'CREDIT NOTE', 'DN 19-12-001', NULL, '2019-12-30 00:00:00', '', 220, '67001', 'TRADE CREDITORS', 'CREDIT NOTE', 'DN 19-12-001', 0.0000, 808661.0000, 808661.0000, 0.0000, 30729.1180, 30729.1180, 216, NULL, 'MITSUBISHI PENCIL CO LTD - YEN', NULL, 'AP', NULL, NULL, 5, NULL, 0.0380, NULL, 1, '2020-10-12 21:21:15', NULL, NULL, NULL),
(100911, 'app\\modules\\sale\\models\\VendorCreditNote', 2, 'app\\modules\\sale\\models\\VendorCreditNote', 2, 'CREDIT NOTE', 'DN 19-12-002', NULL, '2019-12-30 00:00:00', '', 220, '67001', 'TRADE CREDITORS', 'CREDIT NOTE', 'DN 19-12-002', 0.0000, 2942643.0000, 2942643.0000, 0.0000, 111820.4340, 111820.4340, 216, NULL, 'MITSUBISHI PENCIL CO LTD - YEN', NULL, 'AP', NULL, NULL, 5, NULL, 0.0380, NULL, 1, '2020-10-12 21:21:15', NULL, NULL, NULL),
(90551, 'app\\modules\\sale\\models\\Costing', 108, 'app\\modules\\sale\\models\\Costing', 108, 'COSTING', 'PD-1912/006', NULL, '2019-12-23 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1912/006', 440.0000, 0.0000, -440.0000, 440.0000, 0.0000, -440.0000, 235, NULL, 'PROFILE LABEL (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90543, 'app\\modules\\sale\\models\\Costing', 100, 'app\\modules\\sale\\models\\Costing', 100, 'COSTING', 'PD-1912/005', NULL, '2019-12-17 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1912/005', 1416.6200, 0.0000, -1416.6200, 1416.6200, 0.0000, -1416.6200, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90552, 'app\\modules\\sale\\models\\Costing', 109, 'app\\modules\\sale\\models\\Costing', 109, 'COSTING', 'PD-1912/003', NULL, '2019-12-10 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1912/003', 751.2000, 0.0000, -751.2000, 751.2000, 0.0000, -751.2000, 239, NULL, 'QC PRINTING (J) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90526, 'app\\modules\\sale\\models\\Costing', 83, 'app\\modules\\sale\\models\\Costing', 83, 'COSTING', 'PD-1911/013', NULL, '2019-11-27 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/013', 2288.0000, 0.0000, -2288.0000, 2288.0000, 0.0000, -2288.0000, 198, NULL, 'GL PRINTING SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90532, 'app\\modules\\sale\\models\\Costing', 89, 'app\\modules\\sale\\models\\Costing', 89, 'COSTING', 'PD-1911/011', NULL, '2019-11-22 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/011', 450.0000, 0.0000, -450.0000, 450.0000, 0.0000, -450.0000, 211, NULL, 'MAJOR HARVEST SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90550, 'app\\modules\\sale\\models\\Costing', 107, 'app\\modules\\sale\\models\\Costing', 107, 'COSTING', 'PD-1911/012', NULL, '2019-11-22 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/012', 990.0000, 0.0000, -990.0000, 990.0000, 0.0000, -990.0000, 235, NULL, 'PROFILE LABEL (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90527, 'app\\modules\\sale\\models\\Costing', 84, 'app\\modules\\sale\\models\\Costing', 84, 'COSTING', 'PD-1911/014', NULL, '2019-11-21 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/014', 3397.5700, 0.0000, -3397.5700, 3397.5700, 0.0000, -3397.5700, 203, NULL, 'HESHENPLAS PACKAGING INDUSTRIES & TRADING SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90549, 'app\\modules\\sale\\models\\Costing', 106, 'app\\modules\\sale\\models\\Costing', 106, 'COSTING', 'PD-1911/010', NULL, '2019-11-20 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/010', 440.0000, 0.0000, -440.0000, 440.0000, 0.0000, -440.0000, 235, NULL, 'PROFILE LABEL (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90542, 'app\\modules\\sale\\models\\Costing', 99, 'app\\modules\\sale\\models\\Costing', 99, 'COSTING', 'PD-1911/009', NULL, '2019-11-15 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/009', 3603.9300, 0.0000, -3603.9300, 3603.9300, 0.0000, -3603.9300, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90565, 'app\\modules\\sale\\models\\Costing', 122, 'app\\modules\\sale\\models\\Costing', 122, 'COSTING', 'PD-1911/008', NULL, '2019-11-13 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/008', 5203.0000, 0.0000, -5203.0000, 5203.0000, 0.0000, -5203.0000, 264, NULL, 'YANTA PLASTIC INDUSTRY SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90531, 'app\\modules\\sale\\models\\Costing', 88, 'app\\modules\\sale\\models\\Costing', 88, 'COSTING', 'PD-1911/006', NULL, '2019-11-12 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/006', 677.6000, 0.0000, -677.6000, 677.6000, 0.0000, -677.6000, 205, NULL, 'JB YEW SENG STATIONERY SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90564, 'app\\modules\\sale\\models\\Costing', 121, 'app\\modules\\sale\\models\\Costing', 121, 'COSTING', 'PD-1911/005', NULL, '2019-11-12 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/005', 340.5600, 0.0000, -340.5600, 340.5600, 0.0000, -340.5600, 253, NULL, 'EXCEL SOLIDPAC INDUSTRIES SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90562, 'app\\modules\\sale\\models\\Costing', 119, 'app\\modules\\sale\\models\\Costing', 119, 'COSTING', 'PD-1911/003', NULL, '2019-11-06 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/003', 6800.0000, 0.0000, -6800.0000, 6800.0000, 0.0000, -6800.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90548, 'app\\modules\\sale\\models\\Costing', 105, 'app\\modules\\sale\\models\\Costing', 105, 'COSTING', 'PD-1911/001', NULL, '2019-11-01 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/001', 957.0000, 0.0000, -957.0000, 957.0000, 0.0000, -957.0000, 235, NULL, 'PROFILE LABEL (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90530, 'app\\modules\\sale\\models\\Costing', 87, 'app\\modules\\sale\\models\\Costing', 87, 'COSTING', 'PD-1910/015', NULL, '2019-10-30 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/015', 374.4000, 0.0000, -374.4000, 374.4000, 0.0000, -374.4000, 205, NULL, 'JB YEW SENG STATIONERY SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90547, 'app\\modules\\sale\\models\\Costing', 104, 'app\\modules\\sale\\models\\Costing', 104, 'COSTING', 'PD-1910/016', NULL, '2019-10-30 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/016', 594.0000, 0.0000, -594.0000, 594.0000, 0.0000, -594.0000, 235, NULL, 'PROFILE LABEL (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90529, 'app\\modules\\sale\\models\\Costing', 86, 'app\\modules\\sale\\models\\Costing', 86, 'COSTING', 'PD-1910/014', NULL, '2019-10-29 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/014', 244.6000, 0.0000, -244.6000, 244.6000, 0.0000, -244.6000, 205, NULL, 'JB YEW SENG STATIONERY SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90563, 'app\\modules\\sale\\models\\Costing', 120, 'app\\modules\\sale\\models\\Costing', 120, 'COSTING', 'PD-1911/007', NULL, '2019-10-25 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1911/007', 1020.0000, 0.0000, -1020.0000, 1020.0000, 0.0000, -1020.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90541, 'app\\modules\\sale\\models\\Costing', 98, 'app\\modules\\sale\\models\\Costing', 98, 'COSTING', 'PD-1910/013', NULL, '2019-10-24 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/013', 688.7100, 0.0000, -688.7100, 688.7100, 0.0000, -688.7100, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90553, 'app\\modules\\sale\\models\\Costing', 110, 'app\\modules\\sale\\models\\Costing', 110, 'COSTING', 'PD-1910/009', NULL, '2019-10-16 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/009', 230.0000, 0.0000, -230.0000, 230.0000, 0.0000, -230.0000, 243, NULL, 'S & J BAR CODE SDN BHD ', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90540, 'app\\modules\\sale\\models\\Costing', 97, 'app\\modules\\sale\\models\\Costing', 97, 'COSTING', 'PD-1910/008', NULL, '2019-10-15 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/008', 663.3000, 0.0000, -663.3000, 663.3000, 0.0000, -663.3000, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90546, 'app\\modules\\sale\\models\\Costing', 103, 'app\\modules\\sale\\models\\Costing', 103, 'COSTING', 'PD-1910/011', NULL, '2019-10-15 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/011', 990.0000, 0.0000, -990.0000, 990.0000, 0.0000, -990.0000, 235, NULL, 'PROFILE LABEL (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90539, 'app\\modules\\sale\\models\\Costing', 96, 'app\\modules\\sale\\models\\Costing', 96, 'COSTING', 'PD-1910/005', NULL, '2019-10-09 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/005', 832.0000, 0.0000, -832.0000, 832.0000, 0.0000, -832.0000, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90538, 'app\\modules\\sale\\models\\Costing', 95, 'app\\modules\\sale\\models\\Costing', 95, 'COSTING', 'PD-1910/004', NULL, '2019-10-07 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/004', 2714.5400, 0.0000, -2714.5400, 2714.5400, 0.0000, -2714.5400, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90544, 'app\\modules\\sale\\models\\Costing', 101, 'app\\modules\\sale\\models\\Costing', 101, 'COSTING', 'PD-1910/003', NULL, '2019-10-01 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1910/003', 198.0000, 0.0000, -198.0000, 198.0000, 0.0000, -198.0000, 230, NULL, 'PTM LABELS SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90537, 'app\\modules\\sale\\models\\Costing', 94, 'app\\modules\\sale\\models\\Costing', 94, 'COSTING', 'PD-1909/011', NULL, '2019-09-30 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1909/011', 1416.9300, 0.0000, -1416.9300, 1416.9300, 0.0000, -1416.9300, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90561, 'app\\modules\\sale\\models\\Costing', 118, 'app\\modules\\sale\\models\\Costing', 118, 'COSTING', 'PD-1909/009', NULL, '2019-09-24 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1909/009', 1400.0000, 0.0000, -1400.0000, 1400.0000, 0.0000, -1400.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90528, 'app\\modules\\sale\\models\\Costing', 85, 'app\\modules\\sale\\models\\Costing', 85, 'COSTING', 'PD-1909/007', NULL, '2019-09-19 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1909/007', 249.6000, 0.0000, -249.6000, 249.6000, 0.0000, -249.6000, 205, NULL, 'JB YEW SENG STATIONERY SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90535, 'app\\modules\\sale\\models\\Costing', 92, 'app\\modules\\sale\\models\\Costing', 92, 'COSTING', 'PD-1909/003', NULL, '2019-09-11 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1909/003', 721.3100, 0.0000, -721.3100, 721.3100, 0.0000, -721.3100, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:30', NULL, NULL, NULL),
(90536, 'app\\modules\\sale\\models\\Costing', 93, 'app\\modules\\sale\\models\\Costing', 93, 'COSTING', 'PD-1909/004', NULL, '2019-09-11 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1909/004', 800.0000, 0.0000, -800.0000, 800.0000, 0.0000, -800.0000, 221, NULL, 'MULTI-PAC ENTERPRISE SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:30', NULL, NULL, NULL),
(90545, 'app\\modules\\sale\\models\\Costing', 102, 'app\\modules\\sale\\models\\Costing', 102, 'COSTING', 'PD-1909/005', NULL, '2019-09-10 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1909/005', 462.0000, 0.0000, -462.0000, 462.0000, 0.0000, -462.0000, 235, NULL, 'PROFILE LABEL (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:38', NULL, NULL, NULL),
(90560, 'app\\modules\\sale\\models\\Costing', 117, 'app\\modules\\sale\\models\\Costing', 117, 'COSTING', 'PD-1905/015', NULL, '2019-05-08 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1905/015', 2600.0000, 0.0000, -2600.0000, 2600.0000, 0.0000, -2600.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90556, 'app\\modules\\sale\\models\\Costing', 113, 'app\\modules\\sale\\models\\Costing', 113, 'COSTING', 'PD-1905/014', NULL, '2019-05-06 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1905/014', 1000.0000, 0.0000, -1000.0000, 1000.0000, 0.0000, -1000.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90555, 'app\\modules\\sale\\models\\Costing', 112, 'app\\modules\\sale\\models\\Costing', 112, 'COSTING', 'PD-1905/004', NULL, '2019-04-30 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1905/004', 100.0000, 0.0000, -100.0000, 100.0000, 0.0000, -100.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90559, 'app\\modules\\sale\\models\\Costing', 116, 'app\\modules\\sale\\models\\Costing', 116, 'COSTING', 'PD-1905/018', NULL, '2019-04-18 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1905/018', 1900.0000, 0.0000, -1900.0000, 1900.0000, 0.0000, -1900.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90557, 'app\\modules\\sale\\models\\Costing', 114, 'app\\modules\\sale\\models\\Costing', 114, 'COSTING', 'PD-1905/016', NULL, '2019-04-16 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1905/016', 800.0000, 0.0000, -800.0000, 800.0000, 0.0000, -800.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90558, 'app\\modules\\sale\\models\\Costing', 115, 'app\\modules\\sale\\models\\Costing', 115, 'COSTING', 'PD-1905/017', NULL, '2019-04-16 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1905/017', 1980.0000, 0.0000, -1980.0000, 1980.0000, 0.0000, -1980.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90554, 'app\\modules\\sale\\models\\Costing', 111, 'app\\modules\\sale\\models\\Costing', 111, 'COSTING', 'PD-1904/006', NULL, '2019-04-05 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1904/006', 140.0000, 0.0000, -140.0000, 140.0000, 0.0000, -140.0000, 244, NULL, 'SINCHOR MARKETING (M) SDN BHD', NULL, 'AP', NULL, NULL, 2, NULL, 1.0000, NULL, 1, '2020-10-12 20:38:39', NULL, NULL, NULL),
(90534, 'app\\modules\\sale\\models\\Costing', 91, 'app\\modules\\sale\\models\\Costing', 91, 'COSTING', 'PD-1901/002', NULL, '2019-01-04 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1901/002', 19359520.0000, 0.0000, -19359520.0000, 735661.7600, 0.0000, -735661.7600, 216, NULL, 'MITSUBISHI PENCIL CO LTD - YEN', NULL, 'AP', NULL, NULL, 5, NULL, 0.0380, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL),
(90533, 'app\\modules\\sale\\models\\Costing', 90, 'app\\modules\\sale\\models\\Costing', 90, 'COSTING', 'PD-1812/005', NULL, '2018-11-16 00:00:00', 'DEBIT', 220, '67001', 'TRADE CREDITORS', 'COSTING', 'PD-1812/005', 17687456.0000, 0.0000, -17687456.0000, 654435.8720, 0.0000, -654435.8720, 216, NULL, 'MITSUBISHI PENCIL CO LTD - YEN', NULL, 'AP', NULL, NULL, 5, NULL, 0.0370, NULL, 1, '2020-10-12 20:38:29', NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `0p4_gl_transaction`
--
ALTER TABLE `0p4_gl_transaction`
  ADD PRIMARY KEY (`gl_transaction_id`),
  ADD KEY `gl_code` (`gl_code`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `0p4_gl_transaction`
--
ALTER TABLE `0p4_gl_transaction`
  MODIFY `gl_transaction_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=165781;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
