-- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `mainform_label` -- DROP TABLE IF EXISTS `mainform_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `mainform_label` ( `Language` varchar(20) NOT NULL, `Caption` varchar(70) DEFAULT NULL, `Help` varchar(20) DEFAULT NULL, `Languages` varchar(20) DEFAULT NULL, `Arabic` varchar(15) DEFAULT NULL, `English` varchar(15) DEFAULT NULL, `French` varchar(15) DEFAULT NULL, `Windows` varchar(15) DEFAULT NULL, `Tile` varchar(15) DEFAULT NULL, `f_Cascade` varchar(15) DEFAULT NULL, `Arrangeall` varchar(15) DEFAULT NULL, `Minimizedall` varchar(15) DEFAULT NULL, `Normalall` varchar(15) DEFAULT NULL, `File` varchar(15) DEFAULT NULL, `Printersetup` varchar(25) DEFAULT NULL, `Calender` varchar(15) DEFAULT NULL, `Utility` varchar(15) DEFAULT NULL, `Utility_hint` varchar(50) DEFAULT NULL, `f_EXIT` varchar(15) DEFAULT NULL, `TOOLS` varchar(15) DEFAULT NULL, `SearchUtility` varchar(20) DEFAULT NULL, `Navigator` varchar(15) DEFAULT NULL, `First` varchar(25) DEFAULT NULL, `Next` varchar(25) DEFAULT NULL, `Prior` varchar(25) DEFAULT NULL, `Last` varchar(25) DEFAULT NULL, `f_Delete` varchar(25) DEFAULT NULL, `f_Insert` varchar(25) DEFAULT NULL, `Cancel` varchar(25) DEFAULT NULL, `Post` varchar(25) DEFAULT NULL, `Edit` varchar(25) DEFAULT NULL, `Refresh` varchar(25) DEFAULT NULL, `Tabset` varchar(15) DEFAULT NULL, `Tabset (Alpha)` varchar(20) DEFAULT NULL, `Tabset (Numeric)` varchar(25) DEFAULT NULL, `A` varchar(1) DEFAULT NULL, `B` varchar(1) DEFAULT NULL, `C` varchar(1) DEFAULT NULL, `D` varchar(1) DEFAULT NULL, `E` varchar(1) DEFAULT NULL, `F` varchar(1) DEFAULT NULL, `G` varchar(1) DEFAULT NULL, `H` varchar(1) DEFAULT NULL, `I` varchar(1) DEFAULT NULL, `J` varchar(1) DEFAULT NULL, `K` varchar(1) DEFAULT NULL, `L` varchar(1) DEFAULT NULL, `M` varchar(1) DEFAULT NULL, `N` varchar(1) DEFAULT NULL, `O` varchar(1) DEFAULT NULL, `P` varchar(1) DEFAULT NULL, `Q` varchar(1) DEFAULT NULL, `R` varchar(1) DEFAULT NULL, `S` varchar(1) DEFAULT NULL, `T` varchar(1) DEFAULT NULL, `U` varchar(1) DEFAULT NULL, `V` varchar(1) DEFAULT NULL, `W` varchar(1) DEFAULT NULL, `X` varchar(1) DEFAULT NULL, `Y` varchar(1) DEFAULT NULL, `Z` varchar(1) DEFAULT NULL, `Z1` varchar(1) DEFAULT NULL, `Z2` varchar(1) DEFAULT NULL, `0` varchar(1) DEFAULT NULL, `1` varchar(1) DEFAULT NULL, `2` varchar(1) DEFAULT NULL, `3` varchar(1) DEFAULT NULL, `4` varchar(1) DEFAULT NULL, `5` varchar(1) DEFAULT NULL, `6` varchar(1) DEFAULT NULL, `7` varchar(1) DEFAULT NULL, `8` varchar(1) DEFAULT NULL, `9` varchar(1) DEFAULT NULL, `f_All` varchar(5) DEFAULT NULL, `Ranged` varchar(10) DEFAULT NULL, `View` varchar(15) DEFAULT NULL, `Toolbar` varchar(15) DEFAULT NULL, `Accounting` varchar(15) DEFAULT NULL, `Bottom` varchar(15) DEFAULT NULL, `Logoanimation` varchar(15) DEFAULT NULL, `Currency` varchar(15) DEFAULT NULL, `Currency_hint` varchar(50) DEFAULT NULL, `Costcenter` varchar(25) DEFAULT NULL, `Costcenter_hint` varchar(50) DEFAULT NULL, `Accounttype` varchar(20) DEFAULT NULL, `Accounttype_hint` varchar(50) DEFAULT NULL, `Ledger` varchar(15) DEFAULT NULL, `Ledger_hint` varchar(50) DEFAULT NULL, `Receipt` varchar(15) DEFAULT NULL, `Receipt_hint` varchar(50) DEFAULT NULL, `Payment` varchar(15) DEFAULT NULL, `Payment_hint` varchar(50) DEFAULT NULL, `Debitnote` varchar(15) DEFAULT NULL, `Debitnote_hint` varchar(50) DEFAULT NULL, `Creditnote` varchar(15) DEFAULT NULL, `Creditnote_hint` varchar(50) DEFAULT NULL, `Journal` varchar(15) DEFAULT NULL, `Journal_hint` varchar(50) DEFAULT NULL, `Budget` varchar(15) DEFAULT NULL, `Budget_hint` varchar(50) DEFAULT NULL, `Reportsoptions` varchar(20) DEFAULT NULL, `Reportsoptions_hint` varchar(50) DEFAULT NULL, `Contents` varchar(15) DEFAULT NULL, `SearchForhelpon` varchar(25) DEFAULT NULL, `Howtousehelp` varchar(25) DEFAULT NULL, `About` varchar(15) DEFAULT NULL, `RefreshData` varchar(20) DEFAULT NULL, `Advanced` varchar(20) DEFAULT NULL, `Savetobitmapfile` varchar(25) DEFAULT NULL, `Export` varchar(15) DEFAULT NULL, `Clipboard` varchar(15) DEFAULT NULL, `Excel` varchar(15) DEFAULT NULL, `Save` varchar(100) DEFAULT NULL, `Print` varchar(100) DEFAULT NULL, `Addd` varchar(100) DEFAULT NULL, `Search` varchar(100) DEFAULT NULL, `Pending` varchar(100) DEFAULT NULL, `CopyJV` varchar(100) DEFAULT NULL, `PaymentRequests` varchar(120) DEFAULT NULL, `ExportExcel` varchar(100) DEFAULT NULL, `Backgroundcolor` varchar(20) DEFAULT NULL, `ZoomIn` varchar(20) DEFAULT NULL, `ZoomOut` varchar(20) DEFAULT NULL, `ZoomUNdo` varchar(20) DEFAULT NULL, `Sendtoprinter` varchar(20) DEFAULT NULL, `Layoutoption` varchar(20) DEFAULT NULL, `Interfacelanguage` varchar(25) DEFAULT NULL, `Keyboard` varchar(15) DEFAULT NULL, `Justifieddirection` varchar(20) DEFAULT NULL, `Background` varchar(15) DEFAULT NULL, `Coolbar` varchar(15) DEFAULT NULL, `UP` varchar(10) DEFAULT NULL, `Fast_Print` varchar(20) DEFAULT NULL, `Search_field` varchar(20) DEFAULT NULL, `Search_text` varchar(20) DEFAULT NULL, `Ok` varchar(10) DEFAULT NULL, `Startrange` varchar(15) DEFAULT NULL, `Endrange` varchar(15) DEFAULT NULL, `Index_hint` varchar(50) DEFAULT NULL, `Alpha_hint` varchar(50) DEFAULT NULL, `AdTools` varchar(25) DEFAULT NULL, `UserManager` varchar(25) DEFAULT NULL, `Date` varchar(25) DEFAULT NULL, `Implementations` varchar(25) DEFAULT NULL, `Time` varchar(25) DEFAULT NULL, `User` varchar(25) DEFAULT NULL, `Report` varchar(25) DEFAULT NULL, `PrintedbyUser` varchar(25) DEFAULT NULL, `UserName` varchar(25) DEFAULT NULL, `FormName` varchar(25) DEFAULT NULL, `Category` varchar(25) DEFAULT NULL, `Company` varchar(25) DEFAULT NULL, `Year` varchar(25) DEFAULT NULL, `DateFromTo` varchar(25) DEFAULT NULL, `UserNameHint` varchar(35) DEFAULT NULL, `DateHint` varchar(35) DEFAULT NULL, `f_Update` varchar(25) DEFAULT NULL, `Employee` varchar(25) DEFAULT NULL, `Bonus` varchar(25) DEFAULT NULL, `Vacation` varchar(25) DEFAULT NULL, `Loan` varchar(25) DEFAULT NULL, `Attendance` varchar(25) DEFAULT NULL, `Generate` varchar(25) DEFAULT NULL, `Parameters` varchar(25) DEFAULT NULL, `EmployeeHint` varchar(35) DEFAULT NULL, `BonusHint` varchar(35) DEFAULT NULL, `VacationHint` varchar(35) DEFAULT NULL, `LoanHint` varchar(35) DEFAULT NULL, `AttendanceHint` varchar(35) DEFAULT NULL, `GenerateHint` varchar(35) DEFAULT NULL, `ReportHint` varchar(35) DEFAULT NULL, `ParametersHint` varchar(35) DEFAULT NULL, `CaptionPay` varchar(60) DEFAULT NULL, `CaptionInv` varchar(100) DEFAULT NULL, `Items` varchar(25) DEFAULT NULL, `Clients` varchar(25) DEFAULT NULL, `PurchaseOrder` varchar(25) DEFAULT NULL, `Purchases` varchar(25) DEFAULT NULL, `ReturnPurchase` varchar(25) DEFAULT NULL, `Production` varchar(25) DEFAULT NULL, `SalesOrd` varchar(25) DEFAULT NULL, `Delivery` varchar(25) DEFAULT NULL, `ReturnDelivery` varchar(25) DEFAULT NULL, `Sales` varchar(25) DEFAULT NULL, `RetSales` varchar(25) DEFAULT NULL, `ReturnSales` varchar(25) DEFAULT NULL, `Grouping` varchar(25) DEFAULT NULL, `Warehouse` varchar(25) DEFAULT NULL, `Area` varchar(25) DEFAULT NULL, `Salesmen` varchar(25) DEFAULT NULL, `Supplier` varchar(25) DEFAULT NULL, `PurOrder` varchar(25) DEFAULT NULL, `PurOrderhint` varchar(35) DEFAULT NULL, `Purchaseshint` varchar(35) DEFAULT NULL, `ReturnPur` varchar(25) DEFAULT NULL, `ReturnPurhint` varchar(35) DEFAULT NULL, `RMA` varchar(25) DEFAULT NULL, `RMAhint` varchar(35) DEFAULT NULL, `ReturnRMA` varchar(25) DEFAULT NULL, `RetRMA` varchar(25) DEFAULT NULL, `ReturnRMAhint` varchar(35) DEFAULT NULL, `Invoice` varchar(25) DEFAULT NULL, `Invoicehint` varchar(35) DEFAULT NULL, `SalesOrderhint` varchar(35) DEFAULT NULL, `Saleshint` varchar(35) DEFAULT NULL, `ReturnSaleshint` varchar(35) DEFAULT NULL, `Deliveryhint` varchar(35) DEFAULT NULL, `ReturnDel` varchar(25) DEFAULT NULL, `ReturnDelhint` varchar(35) DEFAULT NULL, `Transfer` varchar(25) DEFAULT NULL, `Transferhint` varchar(35) DEFAULT NULL, `Productionhint` varchar(35) DEFAULT NULL, `Adjustment` varchar(25) DEFAULT NULL, `Adjustmenthint` varchar(35) DEFAULT NULL, `ItemsHint` varchar(35) DEFAULT NULL, `ClientsHint` varchar(35) DEFAULT NULL, `Project` varchar(25) DEFAULT NULL, `ProjectHint` varchar(35) DEFAULT NULL, `WarehouseHint` varchar(35) DEFAULT NULL, `AreaHint` varchar(35) DEFAULT NULL, `CategoryHint` varchar(35) DEFAULT NULL, `GroupingHint` varchar(35) DEFAULT NULL, `SubGroupHint` varchar(35) DEFAULT NULL, `SuppliersHint` varchar(35) DEFAULT NULL, `SalesmenHint` varchar(35) DEFAULT NULL, `SubGroup` varchar(25) DEFAULT NULL, `Suppliers` varchar(25) DEFAULT NULL, `f_Range` varchar(10) DEFAULT NULL, `Dollar` varchar(2) DEFAULT NULL, `Charging` varchar(25) DEFAULT NULL, `FixedAssets` varchar(25) DEFAULT NULL, `FixedAssetshint` varchar(35) DEFAULT NULL, `Charginghint` varchar(35) DEFAULT NULL, `Additionalhint` varchar(35) DEFAULT NULL, `DataCOMHomePage` varchar(25) DEFAULT NULL, `Additional` varchar(25) DEFAULT NULL, `Outof` varchar(25) DEFAULT NULL, `ToExcel` varchar(25) DEFAULT NULL, `BudgetChart` varchar(25) DEFAULT NULL, `Chart1` varchar(25) DEFAULT NULL, `AccountTypeChart` varchar(25) DEFAULT NULL, `LedgerName` varchar(25) DEFAULT NULL, `LedgerNumber` varchar(25) DEFAULT NULL, `Debit` varchar(25) DEFAULT NULL, `Credit` varchar(25) DEFAULT NULL, `Balance` varchar(25) DEFAULT NULL, `Chart2` varchar(25) DEFAULT NULL, `LedgerChart` varchar(25) DEFAULT NULL, `GeneralLedger` varchar(25) DEFAULT NULL, `Group_Detail` varchar(25) DEFAULT NULL, `CurrencyChart` varchar(25) DEFAULT NULL, `Parity` varchar(25) DEFAULT NULL, `Rate` varchar(25) DEFAULT NULL, `Code` varchar(25) DEFAULT NULL, `CostcenterChart` varchar(25) DEFAULT NULL, `Name` varchar(25) DEFAULT NULL, `PrePayment` varchar(25) DEFAULT NULL, `PrvDataprint` varchar(30) DEFAULT NULL, `Transaction` varchar(100) DEFAULT NULL, `ListOfReports` varchar(100) DEFAULT NULL, `StatisticsReports` varchar(100) DEFAULT NULL, `Archive` varchar(100) DEFAULT NULL, `Sizes` varchar(25) DEFAULT NULL, `SizesHint` varchar(35) DEFAULT NULL, `ChangeDir` varchar(25) DEFAULT NULL, `Cascade` varchar(15) DEFAULT NULL, `EXIT` varchar(15) DEFAULT NULL, `Delete` varchar(25) DEFAULT NULL, `Insert` varchar(25) DEFAULT NULL, `All` varchar(5) DEFAULT NULL, `Update` varchar(25) DEFAULT NULL, `Range` varchar(10) DEFAULT NULL, `id` bigint(20) unsigned NOT NULL, `Banks` varchar(100) DEFAULT NULL, `FinancialAccounts` varchar(100) DEFAULT NULL, `PaymentRequest` varchar(100) DEFAULT NULL, `ChecksCollection` varchar(100) DEFAULT NULL, `Reconcilation` varchar(100) DEFAULT NULL, `Contra` varchar(20) DEFAULT NULL, `PurchaseJV` varchar(100) DEFAULT NULL, `SalesJV` varchar(100) DEFAULT NULL, `InvoicesAllocation` varchar(100) DEFAULT NULL, `StatementOfAccount` varchar(100) DEFAULT NULL, `FinancialReport` varchar(100) DEFAULT NULL, `DailyReport` varchar(100) DEFAULT NULL, `Aging` varchar(100) DEFAULT NULL, `ResultsPage` varchar(100) DEFAULT NULL, `ClearPage` varchar(100) DEFAULT NULL, `Cancell` varchar(100) DEFAULT NULL, `Preview` varchar(100) DEFAULT NULL, `ListOfTransaction` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `mainform_label` -- LOCK TABLES `mainform_label` WRITE; /*!40000 ALTER TABLE `mainform_label` DISABLE KEYS */; INSERT INTO `mainform_label` VALUES ('Arabic','3Ds - ICEC??? C???C?EE C??C?E','E????CE','C??UCE','??E?','???????','?????','???I??','E?C?E?','EEC??','E?E?E C???','E?U?? C???','C???? C??E???','???','??ICI C??EC?E','????C?E','?I?CE...','C?E??C? C?CI?CE','???C?','?I?CE','?I?CE C?E?E','???E C?E???','C????','C??C??','C??CE?','C??I??','???','??C?E','??UC?','??U','E?I??','???CO','E?I?I ??E','C??E?I?E','C????C?','C','E','E','E','?','?','I','I','?','?','?','?','O','?','?','?','U','?','U','?','?','?','?','?','?','?','?','?','0','1','2','3','4','5','6','7','8','9','C???','??II','???','?O??E C??I?CE','C???C?EE','C??I??','O?C?','C????E','OCOE C????CE','C????','OCOE C????C?','??? C???CE','OCOE ???C? C???CECE','C???CECE','OCOE C???CECE','???C? ?E?','OCOE ???C? C??E?','??? C?I??','OCOE ??? C?I??','?O?C? ??I ?I??','OCOE ?O?C? ??I ?I??','?O?C? ??I IC??','OCOE ?O?C? IC??','C????I','OCOE C????I C?????E','???C??E ?E???E','OCOE C????C??E C??E???E','C?E?C???','OCOE I?C?CE C?E?C???','C??????','E?E ?? C?E????CE','????E ??E??C? C?E????CE','?? C?O??E','???CO C??????CE','?E?I?E','??U ??? O??','??IC?','???EE??I','?????','Save','Print','Add','Search','Pending','Copy JV','Payment Requests','Export Excel','??? C?I???E','E?E??','E?U??','??UC? C????E','???C? C?? C??EC?E','I?C? C?O?? C?IC???','?UE ?C??E C?E?E??','???E C???CE??','?E? C??E?C?','C?I???E','?O??E C?O?C??','????','?EC?E ????E','IC?E C?E?E','?? C?E?E','???','C?EIC?E','C???C?E','?IE?C? I??? C????','?IE?C? ?I?I C?E?E ??E C?????','?I?CE C??????','?I?? C???C?','C?EC??I','E?E??','C???E','C???EII?','E????','?E??C C???EII?','??? C???EII?','??? C?OCOE','C???E','O??E','??E','C?EC??I ?? / C??',NULL,NULL,'E?I?E','??U?','??C??E','???','???','????','??ICE','C??I?I',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3Ds - ICEC??? ?I?? C??C???? :(','3Ds - ICEC??? ?IC?E C??IC??','C????C?','C??EC??','??E C??OE??','C??OE??CE','??E?? C??OE??','C???EC?','??E C??E??CE','C?E????','??E?? C?E????','C??E??CE','??E?? C??E??CE','??E?? C??E??CE','C?E????','C??I??','C?????E','??I?E? C??E??CE','C??????I','??E C??OE??','OCOE ??E C??OE??','OCOE C??OE??','??E?? C??OE??','OCOE ??E?? C??OE??','RMA','OCOE RMA','??E?? RMA','??E?? RMA','OCOE ??E?? RMA','?CE??E','OCOE C??CE??E','OCOE ??E C??E??CE','OCOE C??E??CE','OCOE ??E?? C??E??CE','OCOE C?E????','??E?? C?E????','OCOE ??E?? C?E????','C????','OCOE C????','OCOE C???EC?','C?E?I??','OCOE C?E?I??','OCOE C????C?','OCOE C??EC??','C??O???','OCOE C??O???','OCOE C??I??','OCOE C?????E','OCOE C???E','OCOE C?E????','OCOE C??????E C?????E','OCOE C??????I??','OCOE ??I?E? C??E??CE','?????E ????E','C??????I??','[...]','$','C???C???','C?????ICE C?ECEEE',NULL,NULL,NULL,'???E ICEC??? C??????E','??C??','?? ???','C?? ?????','??? C????C??E C?E?C??','C???? C?E?C??1','??? ??? C???CE C?E?C??','??? C???CE','??? C???CE','?I??','IC??','C????C??E','C???? C?E?C??2','??? C???CE C?E?C??','C???CE C??C?','C??????E/C?E????','??? C????E C?E?C??','??? C????E','??? C????E','C????','??? C???? C?E?C??','C????','C???E??CE','??? C??????CE ???EC?E','C????E','لائحة بالتقارير','التقارير الإحصائية','C???O??','C???C?CE','OCOE C???C?CE','EU??? C??C??E',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'البنوك','الحسابات المالية','طلب دفع','تحصيل الشكات','التصالح','المضاد','Purchase JV','Sales JV','فواتير التخصيص','كشف حساب','تقرير مالي','تقرير يومي','Aging','Results/Page','Clear Page','Cancel','Preview','List of Transaction'),('English','3Ds - DataCOM Accounting System','Help','Languages','Arabic','English','French','Windows','Tile','Cascade','Arrange All','Minimized All','Normal All','File','Printer Setup','Calender','Utility','Utility Application','Exit','Tools','Search Utility','Navigator','First (Ctrl+Home)','Next (PageDown)','Prior (PageUp)','Last (Ctrl+End)','Delete (Ctrl+Delete)','Insert (Insert)','Cancel (Esc)','Save','Edit','Refresh','Tabs range','Alpha range','Numeric range','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z',NULL,NULL,'0','1','2','3','4','5','6','7','8','9','All','Ranged','View','Toolbar','Accounting','Bottom','Logo','Currency','Currency Form','Costcenter','Costcenter Form','Account Type','Account Type Form','Ledger','Ledger Form','Receipt','Receipt Voucher Form','Payment.','Payment Voucher Form','Debit Note','Debit Note Form','Credit Note','Credit Note Form','Journal','Journal Voucher Form','Budget','Budget Form','Reports','Report Options Form','Contents','Search For Help On','How to use Help','About','Refresh Data','Advanced','Save to Bitmap file','Export','Clipboard','Excel','Save','Print','Add','Search','Pending','Copy JV','Payment Requests','Export Excel','Background Color','Zoom In','Zoom Out','Zoom Undo','Send To Printer','Layout Option','Interface Language','Keyboard','Justified Direction','Background','Coolbar','Up','Fast Print','Search Field','Search Text','OK','Start Range','End Range','Choose the desired index of the file','Set range according to the character','Administrator Tools','User Manager','Date','Implementations','Time','User','Report','Printed by User','User Name','Form Name','Category','Company','Year','Date From / To','User name','Date','Update','Employee','Bonus','Vacation','Loan','Attendance','Generate','Parameters','Employee','Bonus','Vacation','Loan','Attendance','Generate','Report','Parameters','3Ds - DataCOM Human Resources : (','3Ds - DataCOM Inventory','Items','Clients','Purchase Order','Purchases','Return Purchase','Production','Sales Order','Delivery','Return Delivery','Sales','Return Sales','Return Sales','Grouping','Warehouse','Area','Salesmen','Supplier','Purchase Order','Receipt Goods Form','Purchases Form','Return Pur.','Return Purchase Form','RMA','RMA Form','Return RMA','Return RMA','Return RMA Form','Invoice','Invoice Form','Sales Order Form','Sales Form','Return Sales Form','Delivery Form','Return Del.','Return Delivery Form','Transfer','Transfer Form','Production Form','Adjustment','Adjustment Form','Items Form','Clients Form','Project','Project Form','Warehouse Form','Area Form','Category Form','Grouping Form','SubGroup Form','Suppliers Form','Salesmen Form','SubGroup','Suppliers','[...]','$','Charging','Fixed Assets',NULL,NULL,NULL,'DataCOM Home Page','Additional','Out of','To Excel','Budget Chart','Chart1','Account Type Chart','Ledger Name','Ledger Number','Debit','Credit','Balance','Chart2','Ledger Chart','General Ledger','Group / Detail','Currency Chart','Parity','Rate','Code','Costcenter Chart','Name','Pre-Payment','Preview Data To be printed','Transaction','List of Reports','Statistics Reports','Archive','Sizes','Sizes Form','Change Directory',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,'Banks','Financial Accounts','Payment Request','Checks Collection','Reconcilation','Contra','Purchase JV','Sales JV','Invoices Allocation','Statement of Account','Financial Report','Daily Report','Aging','Results/Page','Clear Page','Cancel','Preview','List of Transaction'),('French','3Ds - DataCOM Comptabilité','Aide','Langues','Arabe','Anglais','Français','Fenêtre','Tile','Cascade','Arranger tous','Minimiser tous','Normaliser Tous','Fichier','Preparer l\'imprimante','Calendrier','Outils','Application des Outils','Sortie','Outils','Outils De Recherche','Navigateur','Premier (Ctrl+Home)','Suivant (Page Down)','Précédent (Page Up)','Dernier (Ctrl+End)','Effacer (Ctrl+Delete)','Insérer (Insert)','Annuler (Esc)','Sauver','Editer','Rafraichir','Tab du Rangée','Rangée Alphabetic','Rangée Numeric','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z',NULL,NULL,'0','1','2','3','4','5','6','7','8','9','Tous','Rangée','Vue','Règle','Comptabilité','Dernier','Logo','Devise','Forme du Devise','Job','Forme du Job','Type Compte','Forme de Type du compte','Plan Compt.','Forme du Plan Comptable','Reçu','Forme du Reçu','Paiement','Form du Paiement','Note Débit','Form du Note du Débit','Note Crédit','Form du Note du Crédit','Journal','Forme Fiches Comptables','Budget','Forme Budget','Rapports','Forme des Rapports','Contenu','Recherche pour Aider','Comment Utiliser L\'aide','A propos','Rafraichir','Avancée','Sauver Sous Bitmap','Exportation','Clipboard','Excel','Sauvegarder','Impression','Ajouter','Chercher','En Attendant','Copy JV','Demandes de Paiement','Exporter Excel','Couleur d\'origine','Gros plan','Vue d\'ensemble','Annuler Zoom','Imprimer','Option Du Plan','Langue de l\'interface','Clavier','Justifié Direction','Origine','Coolbar','Haut','Impression Rapide','Champ de Recherche','Text de Recherche','OK','Début du Rangeé','Fin du Rangeé','Choisir l\'index pour le fichier','Selectioner Limite Recherche /Caractère','Outils d\'administrateur','Directeur','Date','Mise en oeuvre','Temps','Utilisateur','Rapport','Imprimé par Utilisateur','Nom Utilisateur','Nom du Forme','Catégorie','Société','Année','Date Du / Au','Nom utilisateur','Date','Mise à jour','Employé','Prime','Vacances','Emprunt','Présence','Création','Paramètres','Employer','Prime','Vacance','Emprunt','Présence','Créé','Rapport','Paramètres','3Ds - DataCOM Ressource Humaine : (','3Ds - DataCOM Inventaire','Articles','Clients','Ordre d\'achat','Achats','Retour d\'achat','Production','Ord. du vente','Livraison','Retour du Livraison','Ventes','Ret. du Vente','Retour du Vente','Groupement','Entrepôt','Région','Vendeurs','Fournisseur','Ordre d\'Ach.','Forme de l\'ordre d\'achats','Forme d\'achats','Retour d\'ach.','Forme du Retour d\'achats','RMA','Forme du RMA','Retour du RMA','Retour RMA','Forme du Retour du RMA','Facture','Forme du facture','Forme Ordre Vente','Forme Ventes','Forme Retour vente','Forme du Livraison','Ret. du Liv.','Forme du Retour du Livraison','Transfert','Forme du Transfert','Forme de Production','Ajustement','Forme de l\'ajustement','Forme des Articles','Forme des Clients','Projet','Forme du Projet','Forme du Depôt','Forme de la Région','Forme de la Catégorie','Forme Du Groupe','Forme du SousGroupe','Forme des Fournisseurs','Forme des Vendeurs','SousGroupe','Fournisseurs','[...]','$','Chargement','Actif',NULL,NULL,NULL,'DataCOM Page Principale','Additionnel','Hors de','Vers Excel','Chart du Budget','Chart1','Chart des types comptes','Nom Compte','No. Compte','Débit','Crédit','Solde','Chart2','Chart du compte','Compte général','Groupe / détail','Chart du devise','Parité','Taux','Code','Chart du Job','Nom','Repayé','Aperçu Data pour Imprimer','Transaction','Liste Des Rapports','Statistiques Rapports','Archive','Mesure','Forme Des Mesures','Changer le Repertoire',NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,'Banques','Comptes Financiers','Demande De Paiement','Vérifie Collection','Réconciliation','Contra','Purchase JV','Sales JV','Factures Allocation','Relevé de Compte','Rapport Financier','Rapport Journalier','Vieillissement','Résultats/Page','Effacer la Page','Annuler','Aperçu','Liste des Transactions'),('Spanish',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Contabilidad',NULL,NULL,'Moneda',NULL,'De Centros De Coste',NULL,'Tipo De Cuenta',NULL,'Libro Mayor',NULL,'Recibo',NULL,'Pago',NULL,'Débito Nota',NULL,'Nota De Crédito',NULL,'Libro Diario',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Excel','Salvar','Impresión','Añadir','Buscar','Pendiente','Copiar JV','Solicitudes de Pago','Exportar Excel',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Clientela',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Área','Vendedor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Proyecto',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Proveedores',NULL,NULL,NULL,'Activos Fijos',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Transacción','Lista De Informes','Los Informes Estadísticos','Archivo',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'Bancos','Cuentas Financieras','Solicitud De Pago','Colección De Cheques','Reconciliación','Contra','Comprobante De Diario De Compras','JV Ventas','Las Facturas De Asignación','Estado de cuenta','Informe Financiero','Reporte Diario','Envejecimiento','Resultados/Página','Borrar Página','Cancelar','Avance','Lista de Transacciones'); /*!40000 ALTER TABLE `mainform_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-03 8:08:36 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `reportoptionsacc_label` -- DROP TABLE IF EXISTS `reportoptionsacc_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `reportoptionsacc_label` ( `Language` varchar(20) NOT NULL, `Caption` varchar(50) DEFAULT NULL, `Tab1` varchar(40) DEFAULT NULL, `Tab2` varchar(50) DEFAULT NULL, `Tab3` varchar(50) DEFAULT NULL, `Tab4` varchar(40) DEFAULT NULL, `Tab5` varchar(50) DEFAULT NULL, `Tab6` varchar(40) DEFAULT NULL, `Tab7` varchar(40) DEFAULT NULL, `Tab8` varchar(40) DEFAULT NULL, `Tab9` varchar(40) DEFAULT NULL, `Tab10` varchar(40) DEFAULT NULL, `Tab11` varchar(40) DEFAULT NULL, `Tab12` varchar(40) DEFAULT NULL, `Tab13` varchar(40) DEFAULT NULL, `Tab14` varchar(40) DEFAULT NULL, `Tab15` varchar(40) DEFAULT NULL, `Tab16` varchar(40) DEFAULT NULL, `Tab17` varchar(40) DEFAULT NULL, `S0` varchar(15) DEFAULT NULL, `S1` varchar(15) DEFAULT NULL, `S2` varchar(15) DEFAULT NULL, `S3` varchar(15) DEFAULT NULL, `S4` varchar(15) DEFAULT NULL, `Project` varchar(15) DEFAULT NULL, `PaperSize` varchar(25) DEFAULT NULL, `Orientation` varchar(25) DEFAULT NULL, `W` varchar(25) DEFAULT NULL, `L` varchar(25) DEFAULT NULL, `S0Hint` varchar(35) DEFAULT NULL, `S1Hint` varchar(35) DEFAULT NULL, `S2Hint` varchar(35) DEFAULT NULL, `S3Hint` varchar(35) DEFAULT NULL, `ProjHint` varchar(35) DEFAULT NULL, `CostcentHint` varchar(35) DEFAULT NULL, `PaperSizeHint` varchar(35) DEFAULT NULL, `OrientationHint` varchar(35) DEFAULT NULL, `WHint` varchar(35) DEFAULT NULL, `LHint` varchar(35) DEFAULT NULL, `Label0` varchar(15) DEFAULT NULL, `Label1` varchar(15) DEFAULT NULL, `Label1Hint` varchar(35) DEFAULT NULL, `Label2` varchar(15) DEFAULT NULL, `Label3` varchar(15) DEFAULT NULL, `Label4` varchar(15) DEFAULT NULL, `Label4Hint` varchar(35) DEFAULT NULL, `Label5` varchar(15) DEFAULT NULL, `Label5Hint` varchar(35) DEFAULT NULL, `T1_label0` varchar(15) DEFAULT NULL, `T2_label0` varchar(15) DEFAULT NULL, `T2_label1` varchar(15) DEFAULT NULL, `T2_label2` varchar(15) DEFAULT NULL, `T2_label3` varchar(15) DEFAULT NULL, `T2_label4` varchar(20) DEFAULT NULL, `T4_label0` varchar(20) DEFAULT NULL, `T4_label0Hint` varchar(35) DEFAULT NULL, `T4_label1` varchar(15) DEFAULT NULL, `T4_label1Hint` varchar(35) DEFAULT NULL, `T4_label2` varchar(15) DEFAULT NULL, `T4_label2Hint` varchar(35) DEFAULT NULL, `T4_label3` varchar(15) DEFAULT NULL, `T4_label3Hint` varchar(35) DEFAULT NULL, `T4_label4` varchar(15) DEFAULT NULL, `T4_label5` varchar(15) DEFAULT NULL, `T4_label6` varchar(15) DEFAULT NULL, `T5_label0` varchar(15) DEFAULT NULL, `T5_label0Hint` varchar(35) DEFAULT NULL, `T5_label1` varchar(15) DEFAULT NULL, `T5_label1Hint` varchar(35) DEFAULT NULL, `T6_label1` varchar(30) DEFAULT NULL, `T6_label1Hint` varchar(45) DEFAULT NULL, `T6_label2` varchar(25) DEFAULT NULL, `T6_label2Hint` varchar(35) DEFAULT NULL, `T6_label3` varchar(25) DEFAULT NULL, `T6_label4` varchar(25) DEFAULT NULL, `T6_label7` varchar(10) DEFAULT NULL, `T6_label8` varchar(10) DEFAULT NULL, `T6_label10` varchar(10) DEFAULT NULL, `T6_label11` varchar(10) DEFAULT NULL, `T7_label0` varchar(20) DEFAULT NULL, `T7_label1` varchar(25) DEFAULT NULL, `T7_label1Hint` varchar(35) DEFAULT NULL, `T7_label3` varchar(25) DEFAULT NULL, `T7_label3Hint` varchar(35) DEFAULT NULL, `T7_OrderbyHint` varchar(35) DEFAULT NULL, `T8_label0` varchar(25) DEFAULT NULL, `T9_label1` varchar(20) DEFAULT NULL, `T9_label1Hint` varchar(35) DEFAULT NULL, `T9_label2` varchar(20) DEFAULT NULL, `T9_label3` varchar(15) DEFAULT NULL, `T9_label4` varchar(15) DEFAULT NULL, `T9_label5` varchar(15) DEFAULT NULL, `T9_label6` varchar(15) DEFAULT NULL, `T9_label7` varchar(20) DEFAULT NULL, `T1_label1` varchar(10) DEFAULT NULL, `T1_label1Hint` varchar(35) DEFAULT NULL, `T1_label2Hint` varchar(35) DEFAULT NULL, `T1_label3` varchar(15) DEFAULT NULL, `T1_label3Hint` varchar(35) DEFAULT NULL, `T1_label4` varchar(15) DEFAULT NULL, `T1_label4Hint` varchar(35) DEFAULT NULL, `Label6` varchar(20) DEFAULT NULL, `T2_label5` varchar(20) DEFAULT NULL, `T6_label9` varchar(20) DEFAULT NULL, `T10_label0` varchar(30) DEFAULT NULL, `T12_label0` varchar(15) DEFAULT NULL, `T12_label1` varchar(15) DEFAULT NULL, `DetailDate` varchar(30) DEFAULT NULL, `DetailDateHint` varchar(35) DEFAULT NULL, `PrintCostCenter` varchar(30) DEFAULT NULL, `PrintCostCenterHint` varchar(45) DEFAULT NULL, `DetailCostCenter` varchar(30) DEFAULT NULL, `DetailCostCenterHint` varchar(45) DEFAULT NULL, `PrintProject` varchar(30) DEFAULT NULL, `PrintProjectHint` varchar(35) DEFAULT NULL, `DetailProject` varchar(30) DEFAULT NULL, `DetailProjectHint` varchar(35) DEFAULT NULL, `Tab1Hint` varchar(50) DEFAULT NULL, `Tab2Hint` varchar(50) DEFAULT NULL, `Tab3Hint` varchar(50) DEFAULT NULL, `Tab4Hint` varchar(50) DEFAULT NULL, `Tab5Hint` varchar(50) DEFAULT NULL, `Tab6Hint` varchar(50) DEFAULT NULL, `Tab7Hint` varchar(50) DEFAULT NULL, `Tab8Hint` varchar(50) DEFAULT NULL, `Tab9Hint` varchar(50) DEFAULT NULL, `Tab10Hint` varchar(50) DEFAULT NULL, `Tab11Hint` varchar(50) DEFAULT NULL, `Tab12Hint` varchar(50) DEFAULT NULL, `Tab13Hint` varchar(50) DEFAULT NULL, `Tab14Hint` varchar(50) DEFAULT NULL, `Tab15Hint` varchar(50) DEFAULT NULL, `Tab16Hint` varchar(50) DEFAULT NULL, `Tab17hint` varchar(50) DEFAULT NULL, `ColorLedgerDetail` varchar(25) DEFAULT NULL, `ColorLedgDetHint` varchar(35) DEFAULT NULL, `Orderby` varchar(25) DEFAULT NULL, `OrderbyHint` varchar(35) DEFAULT NULL, `CompteNum` varchar(25) DEFAULT NULL, `CompteName` varchar(25) DEFAULT NULL, `Folio` varchar(25) DEFAULT NULL, `FolioHint` varchar(35) DEFAULT NULL, `WithMonthlyCalc` varchar(25) DEFAULT NULL, `WithMonthlyCalcHint` varchar(35) DEFAULT NULL, `Receipts` varchar(25) DEFAULT NULL, `PrintDetailCV` varchar(25) DEFAULT NULL, `PrintDetCVHint` varchar(35) DEFAULT NULL, `Balance` varchar(25) DEFAULT NULL, `BalanceHint` varchar(35) DEFAULT NULL, `DebCred` varchar(25) DEFAULT NULL, `DebCredHint` varchar(35) DEFAULT NULL, `Grouponly` varchar(25) DEFAULT NULL, `GrouponlyHint` varchar(35) DEFAULT NULL, `SeperatePages` varchar(25) DEFAULT NULL, `SeperatePagesHint` varchar(35) DEFAULT NULL, `Border` varchar(25) DEFAULT NULL, `BorderHint` varchar(35) DEFAULT NULL, `Document` varchar(25) DEFAULT NULL, `f_Desc` varchar(25) DEFAULT NULL, `DescHint` varchar(35) DEFAULT NULL, `AgingUptodate` varchar(25) DEFAULT NULL, `AgingUptodateHint` varchar(35) DEFAULT NULL, `ImpSoldesZero` varchar(35) DEFAULT NULL, `ImpSoldesZeroHint` varchar(45) DEFAULT NULL, `ImpTransSansPay` varchar(35) DEFAULT NULL, `ImpTransSansPayHint` varchar(50) DEFAULT NULL, `PaySurJob` varchar(25) DEFAULT NULL, `PaySurJobHint` varchar(35) DEFAULT NULL, `Printall` varchar(25) DEFAULT NULL, `PrintallHint` varchar(35) DEFAULT NULL, `Detailed` varchar(25) DEFAULT NULL, `DetailedHint` varchar(35) DEFAULT NULL, `Detail` varchar(25) DEFAULT NULL, `DetailHint` varchar(35) DEFAULT NULL, `SubTotals` varchar(25) DEFAULT NULL, `SubTotalsHint` varchar(35) DEFAULT NULL, `Summary` varchar(25) DEFAULT NULL, `SummaryHint` varchar(35) DEFAULT NULL, `CurrentRate` varchar(25) DEFAULT NULL, `CurrentRateHint` varchar(35) DEFAULT NULL, `DocNumName` varchar(25) DEFAULT NULL, `Query1` varchar(25) DEFAULT NULL, `DatabaseAlias` varchar(25) DEFAULT NULL, `Chart` varchar(25) DEFAULT NULL, `New` varchar(25) DEFAULT NULL, `Save` varchar(25) DEFAULT NULL, `SaveAs` varchar(25) DEFAULT NULL, `f_Delete` varchar(25) DEFAULT NULL, `RetrieveQuery` varchar(25) DEFAULT NULL, `LedgerHint` varchar(35) DEFAULT NULL, `LedgerNameHint` varchar(35) DEFAULT NULL, `Base1Hint` varchar(35) DEFAULT NULL, `Base2Hint` varchar(35) DEFAULT NULL, `DateHint` varchar(35) DEFAULT NULL, `TrialetypeHint` varchar(45) DEFAULT NULL, `CurrencyHint` varchar(35) DEFAULT NULL, `CurDateHint` varchar(35) DEFAULT NULL, `DatabaseAliasHint` varchar(35) DEFAULT NULL, `ChartHint` varchar(35) DEFAULT NULL, `NewHint` varchar(35) DEFAULT NULL, `SaveHint` varchar(35) DEFAULT NULL, `SaveAsHint` varchar(35) DEFAULT NULL, `DeleteHint` varchar(35) DEFAULT NULL, `RetrieveQueryHint` varchar(35) DEFAULT NULL, `LedgerNum` varchar(25) DEFAULT NULL, `LedgerNumDocName` varchar(35) DEFAULT NULL, `Checks` varchar(25) DEFAULT NULL, `ChecksHint` varchar(35) DEFAULT NULL, `Bills` varchar(25) DEFAULT NULL, `BillsHint` varchar(35) DEFAULT NULL, `ChecksforCollections` varchar(30) DEFAULT NULL, `ChecksforPayments` varchar(30) DEFAULT NULL, `BillsforCollections` varchar(30) DEFAULT NULL, `BillsforPayments` varchar(30) DEFAULT NULL, `Aging` varchar(25) DEFAULT NULL, `DetailAging` varchar(25) DEFAULT NULL, `AgingandDetail` varchar(25) DEFAULT NULL, `f_All` varchar(25) DEFAULT NULL, `ReportsOptions` varchar(25) DEFAULT NULL, `Print` varchar(25) DEFAULT NULL, `Export` varchar(25) DEFAULT NULL, `ToExcel` varchar(25) DEFAULT NULL, `Period` varchar(25) DEFAULT NULL, `PrintBalanceZero` varchar(25) DEFAULT NULL, `PrintnotBalanced` varchar(25) DEFAULT NULL, `PrintBalanceZeroHint` varchar(35) DEFAULT NULL, `PrintnotBalancedHint` varchar(35) DEFAULT NULL, `Code` varchar(25) DEFAULT NULL, `CodeHint` varchar(35) DEFAULT NULL, `Name` varchar(25) DEFAULT NULL, `NameHint` varchar(35) DEFAULT NULL, `Ascending` varchar(25) DEFAULT NULL, `AscendingHint` varchar(35) DEFAULT NULL, `Descending` varchar(25) DEFAULT NULL, `DescendingHint` varchar(35) DEFAULT NULL, `Salesmen` varchar(25) DEFAULT NULL, `SalesmanCodeName` varchar(25) DEFAULT NULL, `BankReference` varchar(25) DEFAULT NULL, `UptoDate` varchar(25) DEFAULT NULL, `Preview` varchar(25) DEFAULT NULL, `Browse` varchar(25) DEFAULT NULL, `EditBankBillRef` varchar(25) DEFAULT NULL, `A3` varchar(25) DEFAULT NULL, `A4` varchar(25) DEFAULT NULL, `Custom` varchar(25) DEFAULT NULL, `Portrait` varchar(25) DEFAULT NULL, `LandScape` varchar(25) DEFAULT NULL, `QueryChart` varchar(25) DEFAULT NULL, `Tab5a` varchar(25) DEFAULT NULL, `Tab5aHint` varchar(35) DEFAULT NULL, `NetTotal` varchar(25) DEFAULT NULL, `AmountPaid` varchar(25) DEFAULT NULL, `AmountUnPaid` varchar(25) DEFAULT NULL, `Tab18` varchar(25) DEFAULT NULL, `Tab19` varchar(35) DEFAULT NULL, `GeneralReports` varchar(50) DEFAULT NULL, `ListOfSalesJV` varchar(100) DEFAULT NULL, `ListOfPurchaseJV` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `reportoptionsacc_label` -- LOCK TABLES `reportoptionsacc_label` WRITE; /*!40000 ALTER TABLE `reportoptionsacc_label` DISABLE KEYS */; INSERT INTO `reportoptionsacc_label` VALUES ('English','Apllication Options','Transaction JV','List of Transaction','Monthly Distribution/Budget Forecasting','Financial Summary',' List of Checks/Bills','Difference of Exchange','List of Ledger','Statement of Account','Trial Balance','Statement of Costcenter','Aging','Charging','Fixed Assets','Statement of Document','Query','Credit Limit Roster','Income Statement by Project','&Printer','Pre&view','&Browse','&Excel','Costcenter','Project','Paper Size','Orientation','W','L',NULL,NULL,NULL,NULL,'Project','Costcenter','Paper Size','Orientation','W','L','Date','Reference',NULL,'From','To','Currency',NULL,'Options',NULL,'Journal','Receipts','Payments','Debit Notes','Credit Notes','Ledger Name/Number','Account Type List',NULL,'Revenue',NULL,'Expenses',NULL,'Neutral',NULL,'Add >>','<< Remove','<< Remove All','Activity',NULL,'Collected',NULL,'Income Statement/Balance Sheet',NULL,'Difference of Exchange',NULL,'Income Statement','Balance Sheet','Rate','Parity','Opening','Closing','Print Balances By','New Page For Each Class',NULL,'Print Auxiliaries Account',NULL,NULL,'Value Date','Zero Balance',NULL,'Trial Balance','Debitors','Creditors','Clients','Suppliers','Debitors/Creditors','Type',NULL,NULL,'Check/Bill',NULL,'Force New Page',NULL,'Ledger Number/Name','Voucher','Close Year','Statement of Costcenter','Every','Days','Detailed Per Date','Detail Date','Print Costcenter','Print Cost Center','Detailed Costcenter','Detail Cost Center','Print Project','Print project','Detailed Project','Detail Project',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Color Ledger Detail','Color Ledger','Order by','Order by','Account No.','Account Name','Folio','Folio','With Monthly Calculation','With Monthly Calc','Receipts','Print Det&ail C/V','Print Det CV','Balance','Balance','Debit/Credit','DebCred','Group Only','Group only','Separate Pages','Seperate Pages','Border','Border','Document','Description','Desc.','Aging up to Date','Aging up to date','Print Soldes Zero','Print Solde Zero','Print Transaction Without Payment','Print transaction without paiement','Costcenter Payment','Costcenter payment','Print All','Print all','Detailed','Detailed','Detail','Detailed','Sub Totals',NULL,'Summary',NULL,'Current Rate',NULL,'Document Number/Name','Query','Database Alias','Chart','New','Save','Save as','Delete','Retrieve Query','Ledger','Ledger name','Base 1','Base2','Date','Triale type','Currency','Cur Date','Database Alias','Chart','New','Save','Save As','Delete','Retrieve Query','Ledger No.','Ledger No. or Document / Name','Checks','Checks','Bills','Bills','Checks for Collections','Checks for Payments','Bills for Collections','Bills for Payments','Aging','Detail Aging','Aging and Detail','All','Reports Options','Print','Export','To Excel','Period','Print Zero Balances','Print Non Zero Balances','Print balance zero','Print not Balanced','Code','Code','Name','Name','Ascending',NULL,'Descending',NULL,'Salesmen','Salesman Code / Name','Bank Reference','Up to Date','Preview','Browse','Edit Bank Bill Reference','A3','A4','Custom','Portrait','LandScape','Query Chart','Checks',NULL,'Net Total','Amount Paid','Amount UnPaid','Statement of...','Stmt of Current/Posted Accounts','General Reports','List of Sales JV','List of Purchase JV'),('Spanish',NULL,'Transacción JV','Lista de Transacción',NULL,NULL,NULL,NULL,'Lista de Ledger',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Informes Opciones',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Los Informes Generales','Lista de Ventas JV','Lista de Compra JV'); /*!40000 ALTER TABLE `reportoptionsacc_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 15:47:20 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `transactionjv_labels` -- DROP TABLE IF EXISTS `transactionjv_labels`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `transactionjv_labels` ( `Language` varchar(100) NOT NULL, `TransactionJournalVoucher` varchar(150) DEFAULT NULL, `Datee` varchar(100) DEFAULT NULL, `Reference` varchar(100) DEFAULT NULL, `Folio` varchar(100) DEFAULT NULL, `Fromm` varchar(100) DEFAULT NULL, `Too` varchar(100) DEFAULT NULL, `Options` varchar(100) DEFAULT NULL, `AllTypes` varchar(100) DEFAULT NULL, `Exclude` varchar(100) DEFAULT NULL, `CostcenterProject` varchar(100) DEFAULT NULL, `CheckBill` varchar(100) DEFAULT NULL, `PrintManualNo` varchar(100) DEFAULT NULL, `ForceNewPage` varchar(100) DEFAULT NULL, `WithMonthlyCalculation` varchar(100) DEFAULT NULL, `JournalListing` varchar(100) DEFAULT NULL, `Currency` varchar(100) DEFAULT NULL, `NGN` varchar(100) DEFAULT NULL, `USD` varchar(100) DEFAULT NULL, `Typee` varchar(100) DEFAULT NULL, `Amount` varchar(100) DEFAULT NULL, `ManualNo` varchar(100) DEFAULT NULL, `LedgerNameDescription` varchar(100) DEFAULT NULL, `LedgerNo` varchar(100) DEFAULT NULL, `Credit` varchar(100) DEFAULT NULL, `Debit` varchar(100) DEFAULT NULL, `PreparedBy` varchar(100) DEFAULT NULL, `ControlledBy` varchar(100) DEFAULT NULL, `ApprovedBy` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `transactionjv_labels` -- LOCK TABLES `transactionjv_labels` WRITE; /*!40000 ALTER TABLE `transactionjv_labels` DISABLE KEYS */; INSERT INTO `transactionjv_labels` VALUES ('Arabic','Transaction Journal Voucher','Date','Reference','Folio','From','To','Options','All Types','Exclude','Costcenter / Project','Check Bill','Print Manual No.','Force New Page','With Monthly Calculation','Journal Listing','Currency','NGN','USD','Type','Amount','Manual No.','Ledger Name / Description','Ledger No.','Credit','Debit','Prepared By','Controlled By','Approved By'),('English','Transaction Journal Voucher','Date','Reference','Folio','From','To','Options','All Types','Exclude','Costcenter / Project','Check Bill','Print Manual No.','Force New Page','With Monthly Calculation','Journal Listing','Currency','NGN','USD','Type','Amount','Manual No.','Ledger Name / Description','Ledger No.','Credit','Debit','Prepared By','Controlled By','Approved By'),('French','Bon de Commande de Transaction','Date','Référence','Folio','De','À','Options','Tous Les Types','Exclure','Centre de Coûts / Projet','Vérifier le Projet de Loi','Imprimer Manuel No.','Forcer Nouvelle Page','Avec Calcul Mensuel','Liste des Journaux','Devise','NGN','USD','Type','Montant','Numéro Manuel','Ledger Nom / Description','Ledger No.','Crédit','Débit','Preparé Par','Controlé Par','Approuvé Par'),('Spanish','Vale de Diario de Transacciones','Fecha','Referencia','Folio','De','A','Opciones','Todos Los Tipos','Excluir','Centro de Costos / Proyecto','La Cuenta','Imprimir No. de manual','Fuerza Nueva Página','Con el Cálculo Mensual','Diario','Moneda','NGN','USD','Tipo','Cantidad','Número Manual','Ledger Nombre / Descripción','Ledger No.','Crédito','Débito','Preparado Por','Controlado Por','Aprobado Por'); /*!40000 ALTER TABLE `transactionjv_labels` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 15:24:52 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `listofledger_label` -- DROP TABLE IF EXISTS `listofledger_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `listofledger_label` ( `Language` varchar(100) NOT NULL, `LedgerNumberName` varchar(120) DEFAULT NULL, `Fromm` varchar(100) DEFAULT NULL, `Too` varchar(100) DEFAULT NULL, `Options` varchar(100) DEFAULT NULL, `OrderBy` varchar(100) DEFAULT NULL, `NewPageForEachClass` varchar(100) DEFAULT NULL, `PrintAuxiliariesAccount` varchar(120) DEFAULT NULL, `LedgerNo` varchar(100) DEFAULT NULL, `LedgerName` varchar(100) DEFAULT NULL, `ListOfGeneralLedger` varchar(150) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `listofledger_label` -- LOCK TABLES `listofledger_label` WRITE; /*!40000 ALTER TABLE `listofledger_label` DISABLE KEYS */; INSERT INTO `listofledger_label` VALUES ('Arabic','Ledger Number / Name','From','To','Options','Order By','New Page For Each Class','Print Auxiliaries Account','Ledger No.','Ledger Name','List of General Ledger'),('English','Ledger Number / Name','From','To','Options','Order By','New Page For Each Class','Print Auxiliaries Account','Ledger No.','Ledger Name','List of General Ledger'),('French','Numéro / Nom du Grand Livre','De','À','Options','Commandé Par','Nouvelle Page Pour Chaque Classe','Imprimer Le Compte Auxiliaire','Numéro du Grand Livre','Nom du Livre','Liste des Livres'),('Spanish','Número / Nombre del Libro Mayor','De','A','Opciones','Ordenar Por','Nueva Página Para Cada Clase','Imprimir Cuenta Auxiliar','Número del Libro Mayor','Nombre del Libro Mayor','Lista del Libro Mayor'); /*!40000 ALTER TABLE `listofledger_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:32:09 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `listoftransaction_labels` -- DROP TABLE IF EXISTS `listoftransaction_labels`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `listoftransaction_labels` ( `Language` varchar(100) NOT NULL, `Voucher` varchar(100) DEFAULT NULL, `Receipts` varchar(100) DEFAULT NULL, `GroupBy` varchar(100) DEFAULT NULL, `Datee` varchar(100) DEFAULT NULL, `ValueDate` varchar(100) DEFAULT NULL, `Reference` varchar(100) DEFAULT NULL, `Nonee` varchar(50) DEFAULT NULL, `Salesman` varchar(100) DEFAULT NULL, `LedgerNo` varchar(100) DEFAULT NULL, `Payments` varchar(100) DEFAULT NULL, `Fromm` varchar(100) DEFAULT NULL, `Too` varchar(100) DEFAULT NULL, `Journal` varchar(100) DEFAULT NULL, `DebitNotes` varchar(100) DEFAULT NULL, `CreditNotes` varchar(100) DEFAULT NULL, `Alll` varchar(50) DEFAULT NULL, `Confirmed` varchar(100) DEFAULT NULL, `NotConfirmed` varchar(100) DEFAULT NULL, `LedgerNumberName` varchar(100) DEFAULT NULL, `SalesmanCodeDescription` varchar(100) DEFAULT NULL, `CollectionsPerSalesman` varchar(100) DEFAULT NULL, `Project` varchar(100) DEFAULT NULL, `Usee` varchar(100) DEFAULT NULL, `Costcenter` varchar(100) DEFAULT NULL, `CreditAccounts` varchar(100) DEFAULT NULL, `DebitAccounts` varchar(100) DEFAULT NULL, `Bothh` varchar(100) DEFAULT NULL, `ShowDescription` varchar(100) DEFAULT NULL, `ShowProjectCostcenterHeader` varchar(150) DEFAULT NULL, `ShowProjectCostcenterDetail` varchar(100) DEFAULT NULL, `ShowChecks` varchar(100) DEFAULT NULL, `ShowDetailedJV` varchar(120) DEFAULT NULL, `ShowOtherSide` varchar(120) DEFAULT NULL, `ListOfTransaction` varchar(120) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `listoftransaction_labels` -- LOCK TABLES `listoftransaction_labels` WRITE; /*!40000 ALTER TABLE `listoftransaction_labels` DISABLE KEYS */; INSERT INTO `listoftransaction_labels` VALUES ('Arabic','Voucher','Receipts','Group By','Date','Value Date','Reference','None','Salesman','Ledger No.','Payments','From','To','Journals','Debit Notes','Credit Notes','All','Confirmed','Not Confirmed','Ledger Number / Name','Salesman Code / Description','Collection Per Salesman','Project','use','Costcenter','Credit Accounts','Debit Accounts','Both','Show Description','Show Project / Costcenter (Header)','Show Project / Costcenter (Detail)','Show Checks','Show Detailed JV','Show Other Side','List of Transaction'),('English','Voucher','Receipts','Group By','Date','Value Date','Reference','None','Salesman','Ledger No.','Payments','From','To','Journals','Debit Notes','Credit Notes','All','Confirmed','Not Confirmed','Ledger Number / Name','Salesman Code / Description','Collection Per Salesman','Project','use','Costcenter','Credit Accounts','Debit Accounts','Both','Show Description','Show Project / Costcenter (Header)','Show Project / Costcenter (Detail)','Show Checks','Show Detailed JV','Show Other Side','List of Transaction'),('French','Bon','Recettes','Par Groupe','Date','Date de Valeur','Référence','Aucun','Vendeur','Ledger No.','Paiements','De','À','Journaux','Billets de Débit','Notes de Crédit','Tout','Confirmé','Pas Confirmé','Numéro / Nom du Grand Livre','Code / Description du Vendeur','Collection Par Vendeur','Projet','utilisation','Centre de Coûts','Comptes de Crédit','Comptes de Débit','Tous les Deux','Montrer la Description','Afficher le Projet / Centre de Coûts (En-Tête)','Afficher le Projet / Le Centre de Coûts (détail)','Afficher Les Chèques','Montrer JV Détaillée','Afficher Lautre Côté','Liste des Transactions'),('Spanish','Vale','Ingresos','Agrupar Por','Fecha','Valor de Fecha','Referencia','Ninguna','Vendedor','Sin Ledger','Pagos','De','A','Revistas','Notas Debito','Notas de Crédito','Todas','Confirmado','No Confirmado','Número / Nombre del Libro Mayor','Vendedor Código / Descripción','Colección Por Vendedor','Proyecto','utilizar','De Centros De Coste','Cuentas de Crédito','Cuentas de Débito','Ambos','Mostrar Descripcion','Mostrar Proyecto / Centro de Coste (Encabezado)','Mostrar Proyecto / Centro de Coste (Detalle)','Mostrar Cheques','Mostrar JV Detallada','Mostrar Otro Lado','Lista de Transacciones'); /*!40000 ALTER TABLE `listoftransaction_labels` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:31:06 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `dbtnote_label` -- DROP TABLE IF EXISTS `dbtnote_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `dbtnote_label` ( `Language` varchar(10) NOT NULL, `Tab1` varchar(60) DEFAULT NULL, `LabeL0` varchar(20) DEFAULT NULL, `Label1` varchar(20) DEFAULT NULL, `Label2` varchar(20) DEFAULT NULL, `Label3` varchar(20) DEFAULT NULL, `Label4` varchar(20) DEFAULT NULL, `Label5` varchar(20) DEFAULT NULL, `Label6` varchar(20) DEFAULT NULL, `Disp_3` varchar(20) DEFAULT NULL, `Disp_4` varchar(20) DEFAULT NULL, `Tab2` varchar(20) DEFAULT NULL, `Disp_2_1` varchar(20) DEFAULT NULL, `Disp_2_2` varchar(20) DEFAULT NULL, `Caption` varchar(25) DEFAULT NULL, `Project` varchar(15) DEFAULT NULL, `Folio` varchar(25) DEFAULT NULL, `RefHint` varchar(35) DEFAULT NULL, `JVRefHint` varchar(35) DEFAULT NULL, `FolioHint` varchar(35) DEFAULT NULL, `LedgerNumHint` varchar(35) DEFAULT NULL, `CurHint` varchar(35) DEFAULT NULL, `DescHint` varchar(35) DEFAULT NULL, `DateHint` varchar(35) DEFAULT NULL, `Amount1Hint` varchar(35) DEFAULT NULL, `AmountHint` varchar(35) DEFAULT NULL, `Amount2Hint` varchar(35) DEFAULT NULL, `DbtNoteNameHint` varchar(35) DEFAULT NULL, `CostcentHint` varchar(35) DEFAULT NULL, `ProjectHint` varchar(35) DEFAULT NULL, `Balance1Hint` varchar(35) DEFAULT NULL, `Balance2Hint` varchar(35) DEFAULT NULL, `ValueDate` varchar(100) DEFAULT NULL, `DebitNote` varchar(100) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `Tab1Hint` varchar(50) DEFAULT NULL, `Tab2Hint` varchar(50) DEFAULT NULL, `CostcenterHint` varchar(50) DEFAULT NULL, `TabProjHint` varchar(50) DEFAULT NULL, `DateFormat` varchar(25) DEFAULT NULL, `CreditAccount` varchar(120) DEFAULT NULL, `DebitAccount` varchar(120) DEFAULT NULL, `Reference` varchar(100) DEFAULT NULL, `JVRef` varchar(100) DEFAULT NULL, `Date` varchar(100) DEFAULT NULL, `Representative` varchar(100) DEFAULT NULL, `Curr` varchar(100) DEFAULT NULL, `ManualNo` varchar(100) DEFAULT NULL, `Remark` varchar(100) DEFAULT NULL, `Costcenter` varchar(100) DEFAULT NULL, `LedgerNo` varchar(100) DEFAULT NULL, `LedgerName` varchar(100) DEFAULT NULL, `Descr` varchar(100) DEFAULT NULL, `Amount` varchar(100) DEFAULT NULL, `DetailCode` varchar(100) DEFAULT NULL, `Name` varchar(100) DEFAULT NULL, `Per` varchar(100) DEFAULT NULL, `CheckNo` varchar(100) DEFAULT NULL, `Bank` varchar(100) DEFAULT NULL, `Debit` varchar(100) DEFAULT NULL, `Credit` varchar(100) DEFAULT NULL, `Balance` varchar(100) DEFAULT NULL, `DebitNoteVoucher` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `dbtnote_label` -- LOCK TABLES `dbtnote_label` WRITE; /*!40000 ALTER TABLE `dbtnote_label` DISABLE KEYS */; INSERT INTO `dbtnote_label` VALUES ('Arabic',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Project','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Value Date','Debit Note',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit Account','Debit Account','Reference','JV Ref','Date','Representative','Curr.','Manual No.','Remark','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Debit Note Voucher'),('English',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Project','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Value Date','Debit Note',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit Account','Debit Account','Reference','JV Ref','Date','Representative','Curr.','Manual No.','Remark','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Debit Note Voucher'),('French',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Projet','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Date de Valeur','Note de débit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Compte Créditeur','Compte de Débit','Référence','JV Ref','Date','Représentant','Devise','Manuel No.','Remarque','Centre de Coûts','Ledger No.','Nom Ledger','Desc.','Montant','Code d\'identification','Nom','Pour.','Vérifiez No.','Banque','Débit','Crédit','Équilibre','La Note de Débit Bon'),('Spanish',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Proyecto','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Valor de Fecha','Nota de débito',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Cuenta de Crédito','Cuenta de Debito','Referencia','Ref JV','Fecha','Representante','Moneda','Manual No.','Observación','De Centros De Coste','Ledger No.','Nombre Ledger','Desc.','Cantidad','Código detalle','Nombre','Por.','Marque el No.','Banco','Débito','Crédito','Equilibrar','Nota de Débito Vale'); /*!40000 ALTER TABLE `dbtnote_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:28:18 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `crdnote_label` -- DROP TABLE IF EXISTS `crdnote_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `crdnote_label` ( `Language` varchar(10) NOT NULL, `Tab1` varchar(70) DEFAULT NULL, `LabeL0` varchar(20) DEFAULT NULL, `Label1` varchar(20) DEFAULT NULL, `Label2` varchar(20) DEFAULT NULL, `Label3` varchar(20) DEFAULT NULL, `Label4` varchar(20) DEFAULT NULL, `Label5` varchar(20) DEFAULT NULL, `Label6` varchar(20) DEFAULT NULL, `Disp_3` varchar(20) DEFAULT NULL, `Disp_4` varchar(20) DEFAULT NULL, `Tab2` varchar(20) DEFAULT NULL, `Disp_2_1` varchar(20) DEFAULT NULL, `Disp_2_2` varchar(20) DEFAULT NULL, `Caption` varchar(25) DEFAULT NULL, `Project` varchar(15) DEFAULT NULL, `Folio` varchar(25) DEFAULT NULL, `RefHint` varchar(35) DEFAULT NULL, `JVRefHint` varchar(35) DEFAULT NULL, `FolioHint` varchar(35) DEFAULT NULL, `LedgerNumHint` varchar(35) DEFAULT NULL, `CurHint` varchar(35) DEFAULT NULL, `DescHint` varchar(35) DEFAULT NULL, `DateHint` varchar(35) DEFAULT NULL, `Amount1Hint` varchar(35) DEFAULT NULL, `AmountHint` varchar(35) DEFAULT NULL, `Amount2Hint` varchar(35) DEFAULT NULL, `CrdNoteNameHint` varchar(35) DEFAULT NULL, `CostcentHint` varchar(35) DEFAULT NULL, `ProjectHint` varchar(35) DEFAULT NULL, `Balance1Hint` varchar(35) DEFAULT NULL, `Balance2Hint` varchar(35) DEFAULT NULL, `ValueDate` varchar(100) DEFAULT NULL, `CreditNote` varchar(100) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `Tab1Hint` varchar(50) DEFAULT NULL, `Tab2Hint` varchar(50) DEFAULT NULL, `CostcenterHint` varchar(50) DEFAULT NULL, `TabProjHint` varchar(50) DEFAULT NULL, `DateFormat` varchar(25) DEFAULT NULL, `CreditAccount` varchar(120) DEFAULT NULL, `DebitAccount` varchar(120) DEFAULT NULL, `Reference` varchar(100) DEFAULT NULL, `JVRef` varchar(100) DEFAULT NULL, `Date` varchar(100) DEFAULT NULL, `Representative` varchar(100) DEFAULT NULL, `Curr` varchar(100) DEFAULT NULL, `ManualNo` varchar(100) DEFAULT NULL, `Remark` varchar(100) DEFAULT NULL, `Costcenter` varchar(100) DEFAULT NULL, `LedgerNo` varchar(100) DEFAULT NULL, `LedgerName` varchar(100) DEFAULT NULL, `Descr` varchar(100) DEFAULT NULL, `Amount` varchar(100) DEFAULT NULL, `DetailCode` varchar(100) DEFAULT NULL, `Name` varchar(100) DEFAULT NULL, `Per` varchar(100) DEFAULT NULL, `CheckNo` varchar(100) DEFAULT NULL, `Bank` varchar(100) DEFAULT NULL, `Debit` varchar(100) DEFAULT NULL, `Credit` varchar(100) DEFAULT NULL, `Balance` varchar(100) DEFAULT NULL, `CreditNoteVoucher` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `crdnote_label` -- LOCK TABLES `crdnote_label` WRITE; /*!40000 ALTER TABLE `crdnote_label` DISABLE KEYS */; INSERT INTO `crdnote_label` VALUES ('Arabic',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Project','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Value Date','Credit Note',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit Account','Debit Account','Reference','JV Ref','Date','Representative','Curr.','Manual No.','Remark','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Credit Note Voucher'),('English',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Project','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Value Date','Credit Note',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit Account','Debit Account','Reference','JV Ref','Date','Representative','Curr.','Manual No.','Remark','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Credit Note Voucher'),('French',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Projet','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Date de Valeur','Note de Crédit',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Compte Créditeur','Compte de Débit','Référence','JV Ref','Date','Représentant','Devise','Manuel No.','Remarque','Centre de Coûts','Ledger No.','Nom Ledger','Desc.','Montant','Code d\'identification','Nom','Pour.','Vérifiez No.','Banque','Débit','Crédit','Équilibre','Note de Crédit Bon'),('Spanish',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Proyecto','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Valor de Fecha','Nota de Crédito',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Cuenta de Crédito','Cuenta de Debito','Referencia','Ref JV','Fecha','Representante','Moneda','Manual No.','Observación','De Centros De Coste','Ledger No.','Nombre Ledger','Desc.','Cantidad','Código detalle','Nombre','Por.','Marque el No.','Banco','Débito','Crédito','Equilibrar','Nota de Crédito Vale'); /*!40000 ALTER TABLE `crdnote_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:27:48 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `receipt_label` -- DROP TABLE IF EXISTS `receipt_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `receipt_label` ( `Language` varchar(10) NOT NULL, `Tab1` varchar(20) DEFAULT NULL, `LabeL0` varchar(20) DEFAULT NULL, `Label1` varchar(20) DEFAULT NULL, `Label2` varchar(20) DEFAULT NULL, `Label3` varchar(20) DEFAULT NULL, `Label4` varchar(20) DEFAULT NULL, `Label5` varchar(20) DEFAULT NULL, `Label6` varchar(20) DEFAULT NULL, `Disp_3` varchar(20) DEFAULT NULL, `Disp_4` varchar(20) DEFAULT NULL, `Tab2` varchar(20) DEFAULT NULL, `Tab3` varchar(20) DEFAULT NULL, `Disp_1_1` varchar(20) DEFAULT NULL, `Disp_1_2` varchar(20) DEFAULT NULL, `Disp_1_3` varchar(20) DEFAULT NULL, `Disp_2_1` varchar(20) DEFAULT NULL, `Disp_2_2` varchar(20) DEFAULT NULL, `Label7` varchar(20) DEFAULT NULL, `Caption` varchar(25) DEFAULT NULL, `Project` varchar(15) DEFAULT NULL, `Costcenter` varchar(100) DEFAULT NULL, `LedgerNo` varchar(100) DEFAULT NULL, `LedgerName` varchar(100) DEFAULT NULL, `Descr` varchar(100) DEFAULT NULL, `Amount` varchar(100) DEFAULT NULL, `ValueDate` varchar(100) DEFAULT NULL, `DetailCode` varchar(100) DEFAULT NULL, `Name` varchar(100) DEFAULT NULL, `Per` varchar(100) DEFAULT NULL, `CheckNo` varchar(100) DEFAULT NULL, `Bank` varchar(100) DEFAULT NULL, `Debit` varchar(100) DEFAULT NULL, `Credit` varchar(100) DEFAULT NULL, `Balance` varchar(100) DEFAULT NULL, `Folio` varchar(25) DEFAULT NULL, `Date` varchar(100) DEFAULT NULL, `Representative` varchar(100) DEFAULT NULL, `Curr` varchar(100) DEFAULT NULL, `ManualNo` varchar(100) DEFAULT NULL, `Remark` varchar(100) DEFAULT NULL, `RefHint` varchar(35) DEFAULT NULL, `JVRefHint` varchar(35) DEFAULT NULL, `FolioHint` varchar(35) DEFAULT NULL, `LedgerNumHint` varchar(35) DEFAULT NULL, `CurHint` varchar(35) DEFAULT NULL, `RepHint` varchar(35) DEFAULT NULL, `DescHint` varchar(35) DEFAULT NULL, `DateHint` varchar(35) DEFAULT NULL, `Amount1Hint` varchar(35) DEFAULT NULL, `AmountHint` varchar(35) DEFAULT NULL, `Amount2Hint` varchar(35) DEFAULT NULL, `ReceiptNameHint` varchar(35) DEFAULT NULL, `CostcentHint` varchar(35) DEFAULT NULL, `ProjectHint` varchar(35) DEFAULT NULL, `Balance1Hint` varchar(35) DEFAULT NULL, `Balance2Hint` varchar(35) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `Tab1Hint` varchar(50) DEFAULT NULL, `Tab2Hint` varchar(50) DEFAULT NULL, `Tab3Hint` varchar(50) DEFAULT NULL, `CostcenterHint` varchar(50) DEFAULT NULL, `TabProjHint` varchar(50) DEFAULT NULL, `Checks` varchar(25) DEFAULT NULL, `ChecksHint` varchar(35) DEFAULT NULL, `FormatDate` varchar(25) DEFAULT NULL, `Receipt` varchar(100) DEFAULT NULL, `CreditAccount` varchar(120) DEFAULT NULL, `DebitAccount` varchar(120) DEFAULT NULL, `Reference` varchar(100) DEFAULT NULL, `JVRef` varchar(100) DEFAULT NULL, `ReceiptVoucher` varchar(100) DEFAULT NULL, `TheSumOf` varchar(100) DEFAULT NULL, `ReceivedFrom` varchar(100) DEFAULT NULL, `CheckedBy` varchar(100) DEFAULT NULL, `ReceivedBy` varchar(100) DEFAULT NULL, `AuthorizedBy` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `receipt_label` -- LOCK TABLES `receipt_label` WRITE; /*!40000 ALTER TABLE `receipt_label` DISABLE KEYS */; INSERT INTO `receipt_label` VALUES ('Arabic',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Project','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Value Date','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Folio','Date','Representative','Curr.','Manual No.','Remark',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Receipt','Credit Account','Debit Account','Reference','JV Ref','Receipt Voucher','The Sum of','Received From','Checked By','Received By','Authorized By'),('English',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Project','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Value Date','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Folio','Date','Representative','Curr.','Manual No.','Remark',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Receipt','Credit Account','Debit Account','Reference','JV Ref','Receipt Voucher','The Sum of','Received From','Checked By','Received By','Authorized By'),('French',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Projet','Centre de Coûts','Ledger No.','Nom Ledger','Desc.','Montant','Date de Valeur','Code d\'identification','Nom','Pour.','Vérifiez No.','Banque','Débit','Crédit','Équilibre','Folio','Date','Représentant','Devise','Manuel No.','Remarque',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Le Reçu','Compte Créditeur','Compte de Débit','Référence','JV Ref','Bon de Réception','La Somme de','Reçu de','Vérifié Par','Reçu Par','Autorisé Par'),('Spanish',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Proyecto','De Centros De Coste','Ledger No.','Nombre Ledger','Desc.','Cantidad','Valor de Fecha','Código detalle','Nombre','Por.','Marque el No.','Banco','Débito','Crédito','Equilibrar','Folio','Fecha','Representante','Moneda','Manual No.','Observación',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Recibo','Cuenta de Crédito','Cuenta de Debito','Referencia','Ref JV','Bono de Recibo','La Suma de','Recibido de','Revisado Por','Por Recibida','Autorizado Por'); /*!40000 ALTER TABLE `receipt_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:27:22 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `payment_label` -- DROP TABLE IF EXISTS `payment_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `payment_label` ( `Language` varchar(10) NOT NULL, `Tab1` varchar(20) DEFAULT NULL, `LabeL0` varchar(20) DEFAULT NULL, `Label1` varchar(20) DEFAULT NULL, `Label2` varchar(20) DEFAULT NULL, `Label3` varchar(20) DEFAULT NULL, `Label4` varchar(20) DEFAULT NULL, `Label5` varchar(20) DEFAULT NULL, `Label6` varchar(20) DEFAULT NULL, `Disp_3` varchar(20) DEFAULT NULL, `Disp_4` varchar(20) DEFAULT NULL, `Tab2` varchar(20) DEFAULT NULL, `Tab3` varchar(20) DEFAULT NULL, `Disp_1_1` varchar(20) DEFAULT NULL, `Disp_1_2` varchar(20) DEFAULT NULL, `Disp_1_3` varchar(20) DEFAULT NULL, `Disp_2_1` varchar(20) DEFAULT NULL, `Disp_2_2` varchar(20) DEFAULT NULL, `Label7` varchar(20) DEFAULT NULL, `Caption` varchar(25) DEFAULT NULL, `Project` varchar(15) DEFAULT NULL, `Folio` varchar(25) DEFAULT NULL, `RefHint` varchar(35) DEFAULT NULL, `JVRefHint` varchar(35) DEFAULT NULL, `FolioHint` varchar(35) DEFAULT NULL, `LedgerNumHint` varchar(35) DEFAULT NULL, `CurHint` varchar(35) DEFAULT NULL, `RepHint` varchar(35) DEFAULT NULL, `DescHint` varchar(35) DEFAULT NULL, `DateHint` varchar(35) DEFAULT NULL, `Amount1Hint` varchar(35) DEFAULT NULL, `AmountHint` varchar(35) DEFAULT NULL, `Amount2Hint` varchar(35) DEFAULT NULL, `PaymentNameHint` varchar(35) DEFAULT NULL, `CostcentHint` varchar(35) DEFAULT NULL, `ProjectHint` varchar(35) DEFAULT NULL, `Balance1Hint` varchar(35) DEFAULT NULL, `Balance2Hint` varchar(35) DEFAULT NULL, `Tab1Hint` varchar(50) DEFAULT NULL, `Tab2Hint` varchar(50) DEFAULT NULL, `Tab3Hint` varchar(50) DEFAULT NULL, `CostcenterHint` varchar(50) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `TabProjHint` varchar(50) DEFAULT NULL, `Checks` varchar(25) DEFAULT NULL, `ChecksHint` varchar(35) DEFAULT NULL, `Posted` varchar(25) DEFAULT NULL, `Vat` varchar(25) DEFAULT NULL, `CheckBtn` varchar(25) DEFAULT NULL, `PostedHint` varchar(35) DEFAULT NULL, `VatHint` varchar(35) DEFAULT NULL, `CheckBtnHint` varchar(35) DEFAULT NULL, `FormatDate` varchar(25) DEFAULT NULL, `Payment` varchar(100) DEFAULT NULL, `CreditAccount` varchar(120) DEFAULT NULL, `DebitAccount` varchar(120) DEFAULT NULL, `Reference` varchar(100) DEFAULT NULL, `JVRef` varchar(100) DEFAULT NULL, `Date` varchar(100) DEFAULT NULL, `Representative` varchar(100) DEFAULT NULL, `Curr` varchar(100) DEFAULT NULL, `ManualNo` varchar(100) DEFAULT NULL, `Remark` varchar(100) DEFAULT NULL, `Costcenter` varchar(100) DEFAULT NULL, `LedgerNo` varchar(100) DEFAULT NULL, `LedgerName` varchar(100) DEFAULT NULL, `Descr` varchar(100) DEFAULT NULL, `Amount` varchar(100) DEFAULT NULL, `ValueDate` varchar(100) DEFAULT NULL, `DetailCode` varchar(100) DEFAULT NULL, `Name` varchar(100) DEFAULT NULL, `Per` varchar(100) DEFAULT NULL, `CheckNo` varchar(100) DEFAULT NULL, `Bank` varchar(100) DEFAULT NULL, `Debit` varchar(100) DEFAULT NULL, `Credit` varchar(100) DEFAULT NULL, `Balance` varchar(100) DEFAULT NULL, `PaymentVoucher` varchar(100) DEFAULT NULL, `TheSumOf` varchar(100) DEFAULT NULL, `PaidTo` varchar(100) DEFAULT NULL, `CheckedBy` varchar(100) DEFAULT NULL, `PaidBy` varchar(100) DEFAULT NULL, `AuthorizedBy` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `payment_label` -- LOCK TABLES `payment_label` WRITE; /*!40000 ALTER TABLE `payment_label` DISABLE KEYS */; INSERT INTO `payment_label` VALUES ('Arabic','C?? C?I??','C?????','??? C???CE','C???I?E','C?EC??I','C??E?U','C?? C???CE','C?O??','C????E','C????I','O??CE/??ICE','C??OC???/C????C?','??? C?O??','E??','E C???E??C?','C????','C???EE C?????E','??? C???I','OCOE C?? C?I??','C??O???','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?U?C? C?OCOE','??? C?E?I??','??? C???C?E','??? ??? C????','?E? C?OCOE',NULL,'C?O??CE',NULL,'??U','C????E C???C?E','??C??E C?O??CE',NULL,NULL,NULL,'yyyy/mm/dd','Payment','Credit Account','Debit Account','Reference','JV Ref','Date','Representative','Curr.','Manual No.','Remark','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Value Date','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Payment Voucher','The Sum of','Paid To','Checked By','Paid By','Authorized By'),('English','Payment','Reference','Account No.','Representative','Date','Amount','Account Name','Description','Currency','Balance','Checks/Bills','Projects/Costcenters','Check No.','Bank','Value Date','Costcenter','Percentage','JV Ref.','Payment Form','Project','Folio','Enter Payment Reference','Enter Payment J.V. Reference','Enter Payment Folio','Enter Ledger Number','Enter Payment Currency','Enter Payment Representative','Enter Payment Description','Enter Payment Date',NULL,'Enter Amount',NULL,'Enter Payment Name','Enter Costcenter Code','Enter Project Code',NULL,NULL,NULL,NULL,NULL,NULL,'Close Form','Edit #','Insert #','Delete Record #','Open Form',NULL,'Checks',NULL,'Posted','VAT','Preview Checks',NULL,NULL,NULL,'dd/mm/yyyy','Payment','Credit Account','Debit Account','Reference','JV Ref','Date','Representative','Curr.','Manual No.','Remark','Costcent','Ledger No.','Ledger Name','Desc.','Amount','Value Date','Detail Code','Name','Per.','Check No.','Bank','Debit','Credit','Balance','Payment Voucher','The Sum of','Paid To','Checked By','Paid By','Authorized By'),('French','Paiement','Référence','No. Compte','Représentant','Date','Montant','Nom Compte','Description','Devise','Solde','Chèque/Billet','Projets/Jobes','No. Chèque','Banque','Date valeur','Job','Pourcentage','JV Réf.','Forme du Paiement','Projet','Folio','Entrer référence paiement','Entrer Référence JV paiement','Entrer Paiement Folio','Entrer No compte','Entrer Paiement devise','Entrer Paiement représentant','Entrer Description paiement','Entrer Date Paiement',NULL,'Entrer Montant',NULL,'Entrer nom paiement','Entrer code Job','Entrer Code projet',NULL,NULL,NULL,NULL,NULL,NULL,'Forme Fermée','Edit #','Insertion #','Effacer Record #','Forme ouverte',NULL,'Chèques',NULL,'Mémorisé','TVA','Voir Chèqyes',NULL,NULL,NULL,'dd/mm/yyyy','Paiement','Compte Créditeur','Compte de Débit','Référence','JV Ref','Date','Représentant','Devise','Manuel No.','Remarque','Centre de Coûts','Ledger No.','Nom Ledger','Desc.','Montant','Date de Valeur','Code d\'identification','Nom','Pour.','Vérifiez No.','Banque','Débit','Crédit','Équilibre','Bon de Paiement','La Somme de','Versée à','Vérifié Par','Payé Par','Autorisé Par'),('Spanish',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Proyecto','Folio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Pago','Cuenta de Crédito','Cuenta de Debito','Referencia','Ref JV','Fecha','Representante','Moneda','Manual No.','Observación','De Centros De Coste','Ledger No.','Nombre Ledger','Desc.','Cantidad','Valor de Fecha','Código detalle','Nombre','Por.','Marque el No.','Banco','Débito','Crédito','Equilibrar','Comprobante de Pago','La Suma de','Pagado Para','Revisado Por','Pagado Por','Autorizado Por'); /*!40000 ALTER TABLE `payment_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:26:55 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `journal_label` -- DROP TABLE IF EXISTS `journal_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `journal_label` ( `Language` varchar(10) NOT NULL, `Tab1` varchar(40) DEFAULT NULL, `LabeL0` varchar(20) DEFAULT NULL, `Label1` varchar(20) DEFAULT NULL, `Label2` varchar(20) DEFAULT NULL, `Label3` varchar(20) DEFAULT NULL, `Label4` varchar(20) DEFAULT NULL, `Label5` varchar(20) DEFAULT NULL, `Disp_1` varchar(20) DEFAULT NULL, `Disp_2` varchar(20) DEFAULT NULL, `Disp_3` varchar(20) DEFAULT NULL, `Disp_4` varchar(20) DEFAULT NULL, `Tab2` varchar(20) DEFAULT NULL, `Tab3` varchar(20) DEFAULT NULL, `Disp_1_1` varchar(20) DEFAULT NULL, `Disp_1_2` varchar(20) DEFAULT NULL, `Disp_1_3` varchar(20) DEFAULT NULL, `Disp_2_1` varchar(20) DEFAULT NULL, `Disp_2_2` varchar(20) DEFAULT NULL, `Tab4` varchar(20) DEFAULT NULL, `Disp_4_1` varchar(20) DEFAULT NULL, `Disp_5` varchar(20) DEFAULT NULL, `Caption` varchar(25) DEFAULT NULL, `Project` varchar(15) DEFAULT NULL, `Tab5` varchar(25) DEFAULT NULL, `Tab1Hint` varchar(50) DEFAULT NULL, `Tab2Hint` varchar(50) DEFAULT NULL, `Tab3Hint` varchar(50) DEFAULT NULL, `CostcentHint` varchar(50) DEFAULT NULL, `Tab4Hint` varchar(50) DEFAULT NULL, `Tab5Hint` varchar(50) DEFAULT NULL, `GenerateDate` varchar(25) DEFAULT NULL, `DuplicatecurrentJV` varchar(25) DEFAULT NULL, `RefHint` varchar(35) DEFAULT NULL, `DateHint` varchar(35) DEFAULT NULL, `TypeHint` varchar(35) DEFAULT NULL, `FolioHint` varchar(35) DEFAULT NULL, `TypeNameHint` varchar(35) DEFAULT NULL, `DescHint` varchar(35) DEFAULT NULL, `Amnt1_dbHint` varchar(35) DEFAULT NULL, `Amnt1_cdHint` varchar(35) DEFAULT NULL, `Balance1Hint` varchar(35) DEFAULT NULL, `Amnt2_dbHint` varchar(35) DEFAULT NULL, `Amnt2_cdHint` varchar(35) DEFAULT NULL, `Balance2Hint` varchar(35) DEFAULT NULL, `GenerateDateHint` varchar(35) DEFAULT NULL, `DuplicatecurrentJVHint` varchar(35) DEFAULT NULL, `D_C` varchar(25) DEFAULT NULL, `Formatdate` varchar(25) DEFAULT NULL, `Journal` varchar(25) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `Ledger` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `ProjectHint` varchar(35) DEFAULT NULL, `Checks` varchar(25) DEFAULT NULL, `ChecksHint` varchar(35) DEFAULT NULL, `CostcenterHint` varchar(35) DEFAULT NULL, `CostcenterNameHint` varchar(45) DEFAULT NULL, `TypeRef` varchar(100) DEFAULT NULL, `Remark` varchar(100) DEFAULT NULL, `ManualNo` varchar(100) DEFAULT NULL, `LedgerName` varchar(100) DEFAULT NULL, `Desc1` varchar(100) DEFAULT NULL, `NoRecords` varchar(150) DEFAULT NULL, `Perpage` varchar(120) DEFAULT NULL, `Page` varchar(100) DEFAULT NULL, `JournalVoucher` varchar(100) DEFAULT NULL, `PreparedBy` varchar(100) DEFAULT NULL, `ControlledBy` varchar(100) DEFAULT NULL, `ApprovedBy` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `journal_label` -- LOCK TABLES `journal_label` WRITE; /*!40000 ALTER TABLE `journal_label` DISABLE KEYS */; INSERT INTO `journal_label` VALUES ('Arabic','??? C????I C?????E','C?????','C????','C?EC??I','?????','?I??','IC??','??? C???CE','??? C???CE','C????E','C????I','O??CE/??ICE','C??OC???/C????C?','??? C?O??','E??','E C???E??C?','C????','C???EE C?????E','?????CE','C?O??','C??E?U','OCOE C????I C?????E','C??O???','??ICE C????I C?????E','?IIC? ??ICE C????I C?????E','???E C?O??CE / C???CE??','???E C????C?','?IIC? C?C??C?','???E C???I?E','???E ??ICE C????I C?????E','EC??I C?E?I?E','E??C? C???I C?????','?IIC? ???? C????I C?????E','?IIC? EC??I C????I','?IIC? ??? C????I','?IIC? ????? C????I','?IIC? ??? C????','?IIC? O?? C????I','?IIC? ????? ?O?C? ??I ?I?? 1','?IIC? ????? ?O?C? ??I IC?? 1','?IIC? C????C??E 1','?IIC? ????? ?O?C? ??I ?I?? 2','?IIC? ????? ?O?C? ??I IC?? 2','?IIC? C????C??E 2','?IIC? EC??I ??ICE','??CIE ?C??E','?/I','yyyy/mm/dd','C???I C?????','?U?C? C?OCOE','??? ??? C????','C???CE','??? C?E?I??','??? C???C?E','?E? C?OCOE','C??O???','C?O??CE','?IIC? C?O??CE','?IIC? CC????','??? C????','Type Ref.','Remark','Manual No.','Ledger Name','Desc1','No Records To View','Per Page','Page','Journal Voucher','Prepared By','Controlled By','Approved By'),('English','Transaction Journal Vouchers','Reference','Type','Date','Folio','Debit','Credit','Ledger No.','Ledger Desc.','Currency','Balance','Checks/Bills','Projects/Costcenters','Check No.','Bank','Value Date','Costcenter','Per.','Prefix','Description','Amount','Transaction Journal Form','Project','Generate J.V.','Transaction Journal Vouchers Page','Checks / Bills Page','Costcenters Page','Enter Costcenter','Prefix Page','Generate J.V. Page','Generate Date','Duplicate Current J.V.','Enter Journal Reference','Enter Journal Date','Enter Journal Type','Enter Journal Folio','Enter Type Name','Enter Journal Description','Enter Debit Amount 1','Enter Credit Amount 1','Enter Balance 1','Enter Debit Amount 2','Enter Credit Amount 2','Enter Balance 2','Enter Generate Date','Duplicate Current','D/C','dd/mm/yyyy','Journal','Close Form','Delete Record #','Ledger','Edit #','Insert #','Open Form','Project','Checks','Enter Cheks','Enter Costcenter','Costcenter Name','Type Ref.','Remark','Manual No.','Ledger Name','Desc1','No Records To View','Per Page','Page','Journal Voucher','Prepared By','Controlled By','Approved By'),('French','Fiches Comptables','Référence','Type','Date','Folio','Débit','Crédit','No. Compte','Desc. Compte','Devise','Solde','Chèque/Billet','Projets/Jobes','No. Chèque','Banque','Date Valeur','Job','Pour.','Préfix','Description','Montant','Forme de Fiche Comptable','Projet','Créer J.V.','Page des transactions Du journal des reçus','Chèque /page billets','Page du Job','Entrer Job','Page préfixe','Page générale des JV','Créer Date','Créer Actuel JV en double','Entrer référence du journal','Entrer date du journal','Entrer Type du Journal','Entrer Folio du journal','Entrer nom du Type','Entrer Description Du Journal','Entrer Montant Débit 1','Entrer Montant Crédit 1','Entrer Balance 1','Entrer Montant Débit 2','Entrer Montant Crédit 2','Entrer Balance 2','Entrer date Création','Dupplication Actuelle','D/C','dd/mm/yyyy','Journal','Forme Fermée','Effacer Record #','Compte','Edit #','Insertion #','Forme Ouverte','Projet','Chèques','Entrer Chèque','Entrer Job','Nom Job','Tapez Ref.','Remarque','Manual No.','Nom Ledger','Desc1','Aucun document à afficher','Par Page','Page','Journal Voucher','Preparé Par','Controlé Par','Approuvé Par'),('Spanish',NULL,'Referencia','Tipo','Fecha','Folio','Débito','Crédito','Ledger No.',NULL,'Moneda','Equilibrar',NULL,NULL,'Comprobar No.','Banco','Fecha Valor','Centro de Coste','Por.',NULL,'Descripción','Cantidad',NULL,'Proyecto',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'D/C',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tipo Ref.','Observación','Manual No.','Nombre Ledger','Desc1','No hay registros para ver','Por Página','Página','Documento Preliminar','Preparado Por','Controlado Por','Aprobado Por'); /*!40000 ALTER TABLE `journal_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:25:02 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `costcenter_label` -- DROP TABLE IF EXISTS `costcenter_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `costcenter_label` ( `Language` varchar(15) NOT NULL, `Caption` varchar(20) DEFAULT NULL, `Tab1` varchar(20) DEFAULT NULL, `Code` varchar(20) DEFAULT NULL, `Code_hint` varchar(25) DEFAULT NULL, `Name` varchar(20) DEFAULT NULL, `Name_hint` varchar(25) DEFAULT NULL, `Tab2` varchar(20) DEFAULT NULL, `Balance` varchar(25) DEFAULT NULL, `Grid_hint` varchar(25) DEFAULT NULL, `Debit` varchar(20) DEFAULT NULL, `Credit` varchar(20) DEFAULT NULL, `Tab1_hint` varchar(50) DEFAULT NULL, `Tab2_hint` varchar(50) DEFAULT NULL, `2d_to_3d` varchar(35) DEFAULT NULL, `Ledger_no_name` varchar(30) DEFAULT NULL, `Ledger_no` varchar(15) DEFAULT NULL, `Ledger_name` varchar(15) DEFAULT NULL, `FillLedger` varchar(25) DEFAULT NULL, `EmptyLedger` varchar(25) DEFAULT NULL, `Percentage` varchar(25) DEFAULT NULL, `Costcenter` varchar(25) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `f_Update` varchar(25) DEFAULT NULL, `CreationDate` varchar(100) DEFAULT NULL, `Parent` varchar(100) DEFAULT NULL, `Deactivate` varchar(100) DEFAULT NULL, `AddCostCenter` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `costcenter_label` -- LOCK TABLES `costcenter_label` WRITE; /*!40000 ALTER TABLE `costcenter_label` DISABLE KEYS */; INSERT INTO `costcenter_label` VALUES ('Arabic','OCOE C????C?','C????/C?C??','C????','CIIC? ??? ?I?I','C????','?IIC? C????','??? E?C??','C????I','?C??E ?? C????C?','?I??','IC??','??E C????E ??IIC? C???? ?C????','?U?C? C??OC??? ??? O?? ??? E?C??','??E?C? ?? E?IC? C?? E?CEE ?E?CI','??? C???CE /C????','??? C???CE','??? C???CE','???? C???CE','???U C???CE','C???EE C?????E','C????','?U?C? C?OCOE','?E? C?OCOE','??? ??? C????','??? C?E?I??','??? C???C?E','E?I?E','Creation Date','Parent','Deactivate','Add Costcenter'),('English','Costcenter Form','Code / Name','Code','Enter new code','Name','Enter name','Chart','Balance','List All Costcenter','Debit','Credit','This is the page where to enter code and name','Display the costcenter as chart','Change from 2D to 3D','Ledger No. / Name','Ledger No.','Ledger Name','Fill Ledger','Empty Ledger','Percentage','Costcenter','Close Form','Open Form','Delete Record #','Edit #','Insert #','Update','Creation Date','Parent','Deactivate','Add Costcenter'),('French','Forme des Jobes','Code / Nom','Code','Entrez noveau code','Nom','Entrez le nom','Chart','Solde','Liste des Jobes','Débit','Crédit','Cette page est pour entrer le code et le nom','Montrer le job en chart','Changer du 2D au 3D','No. Compte/Nom','No. Compte','Nom Compte','Remplir compte','Vider compte','Pourcentage','Job','Forme Fermée','Forme Ouverte','Registre Effacé #','Edit #','Insertion #','Mise à Jour','Date de Création','Parent','Inactif','Ajouter Centre de coûts'),('Spanish',NULL,NULL,'Código',NULL,'Nombre',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Fecha de Creación','Padre','Desactivar','Añadir centros de coste'); /*!40000 ALTER TABLE `costcenter_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:23:45 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `currency_label` -- DROP TABLE IF EXISTS `currency_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `currency_label` ( `LANGUAGE` varchar(10) NOT NULL, `CURFORM_CODE` varchar(100) DEFAULT NULL, `CURFORM_CODEHINT` varchar(25) DEFAULT NULL, `CURFORM_NAME` varchar(10) DEFAULT NULL, `CURFORM_NAMEHINT` varchar(25) DEFAULT NULL, `CURFORM_DATE` varchar(10) DEFAULT NULL, `CURFORM_DATEHINT` varchar(25) DEFAULT NULL, `CURFORM_RATE` varchar(10) DEFAULT NULL, `CURFORM_RATEHINT1` varchar(25) DEFAULT NULL, `CURFORM_PARITY` varchar(10) DEFAULT NULL, `CURFORM_PARITYHINT` varchar(25) DEFAULT NULL, `CURFORM_NATURE` varchar(20) DEFAULT NULL, `CURFORM_NATUREHINT` varchar(25) DEFAULT NULL, `CURFORM_MONTH` varchar(10) DEFAULT NULL, `CURFORM_MONTHHINT` varchar(25) DEFAULT NULL, `CURFORM_YEAR` varchar(10) DEFAULT NULL, `CURFORM_YEARHINT` varchar(25) DEFAULT NULL, `CURFORM_TAB1` varchar(20) DEFAULT NULL, `CURFORM_TAB1HINT` varchar(50) DEFAULT NULL, `CURFORM_TAB2` varchar(20) DEFAULT NULL, `CURFORM_TAB2HINT` varchar(50) DEFAULT NULL, `CURFORM_TAB3` varchar(20) DEFAULT NULL, `CURFORM_TAB3HINT` varchar(50) DEFAULT NULL, `CURFORM_CHART` varchar(15) DEFAULT NULL, `CURFORM_CHARTHINT` varchar(50) DEFAULT NULL, `CURFORM_CAPTION` varchar(50) DEFAULT NULL, `First_page` varchar(15) DEFAULT NULL, `Previous_page` varchar(15) DEFAULT NULL, `Next_page` varchar(15) DEFAULT NULL, `Last_page` varchar(15) DEFAULT NULL, `2d_to_3d` varchar(35) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `ArabicInformation` varchar(25) DEFAULT NULL, `Countryname` varchar(25) DEFAULT NULL, `Type` varchar(25) DEFAULT NULL, `CountrynameHint` varchar(35) DEFAULT NULL, `TypeHint` varchar(35) DEFAULT NULL, `Arabicname` varchar(25) DEFAULT NULL, `ArabicnameHint` varchar(35) DEFAULT NULL, `CurLessBase2` varchar(25) DEFAULT NULL, `ArabicCode` varchar(25) DEFAULT NULL, `CreationDate` varchar(100) DEFAULT NULL, `Currency` varchar(100) DEFAULT NULL, `MultiplierOf` varchar(100) DEFAULT NULL, `AddCurrency` varchar(100) DEFAULT NULL, PRIMARY KEY (`LANGUAGE`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `currency_label` -- LOCK TABLES `currency_label` WRITE; /*!40000 ALTER TABLE `currency_label` DISABLE KEYS */; INSERT INTO `currency_label` VALUES ('Arabic','C????','?IIC? ??? C????E','C????','?IIC? ??? C????E','C?EC??I','?IIC? EC??I C????E','??? C????E','?IIC? ??? C????E','??? C????E','?IIC? ??? C????E','?E??E C????E','?IIC? ?E??E C????E','O??','?IIC? O?? C????E','C???E','?IIC? ??E C????E','C???? \\ C????','??? ???E ?IIC? ??? C????','C???? /C????/C??E??E','??? C????E ??IIC? C???? ?C???? ?C??E??E','??? E?C?? ?????CE','?U?C? ??? ??? C????E ??? O?? ??? E?C??','??? E?C? C????E','??? E?C?? ?????CE','OCOE C????CE','C????E C?C???','C????E C??CE?E','C????E C?EC??E','C????E C?CI??E','??E?C? ?? E?IC? C?? E?CEE ?E?CI','?U?C? C?OCOE','?E? C?OCOE','??? ??? C????','??? C?E?I??','??? C???C?E','C??????CE EC???E?E','??? C?E?I','C?E????','?IIC? ??? C?E?I','?IIC? C????','C???? EC???E?','?IIC? C???? EC???E?','C????E < C????E C?EC??E (','C???? EC???E?','Creation Date','Currency','Multiplier of','Add Currency'),('English','Code','Input Currency Code','Name','Input Currency Name','Date','Input Currency Date','Rate','Input Currency Rate','Parity','Input Currency Parity','Currency Nature','Input Currency Nature','Month','Input Currency Month','Year','Input Currency Year','Rate / Parity','This is the page where to enter rate and parity','Code / Name / Nature','This page is where to enter Code, Name and Nature','Currency Chart','Display the currency rate or parity as chart','Currency Chart','Chart of Currencies','Currency Form','First Page','Previous Page','Next Page','Last Page','Change from 2D to 3D','Close Form','Open Form','Delete Record #','Edit #','Insert #','Arabic Information','Country Name','Type','Input Country Name','Input Type','Arabic Name','Input Arabic Name','Currency < Base2 (true)','Code','Creation Date','Currency','Multiplier of','Add Currency'),('French','Code','Entrez Devise Code','Nom','Entrez Devise Nom','Date','Entrez Devise Date','Taux','Entrez Devise Taux','Parité','Entrez Devise Parité','Nature devise','Entrez Devise Nature','Mois','Entrez Devise Mois','Année','Entrez Devise Année','Taux / Parité','Cette page est pour entrer le taux et la parité','Code / Nom / Nature','Page pour entrer le code , le nom et la nature','Chart de la Devise','Chart du Taux ou de la Parité','Devise Chart','Chart des devises','Forme des devises','Première Page','Page Précédente','Page Suivante','Dernière Page','Changer de 2D au 3D','Forme Fermée','Forme Ouverte','Registre Effacé #','Edit #','Insertion #','Information Arabe','Nom du Pays','Type','Entrer Nom Pays','EntrerType','Nom Arabe','Entrer Nom Arabe','Devise < Base2 (vrai)','Code','Date de Création','Devise','Multiplicateur de','Ajouter Devise'),('Spanish','Código',NULL,'Nombre',NULL,'Fecha',NULL,'Tarifa',NULL,'Paridad',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Fecha de Creación','Moneda','Multiplicador de','Añadir Moneda'); /*!40000 ALTER TABLE `currency_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:22:05 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `ledger_label` -- DROP TABLE IF EXISTS `ledger_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ledger_label` ( `Language` varchar(20) NOT NULL, `Tab1` varchar(55) DEFAULT NULL, `Tab1_hint` varchar(50) DEFAULT NULL, `Tab2` varchar(20) DEFAULT NULL, `Tab2_hint` varchar(55) DEFAULT NULL, `Tab3` varchar(20) DEFAULT NULL, `Tab3_hint` varchar(55) DEFAULT NULL, `Label1_type` varchar(10) DEFAULT NULL, `Label1_type_hint` varchar(30) DEFAULT NULL, `Label2_number` varchar(10) DEFAULT NULL, `Label2_number_hint` varchar(30) DEFAULT NULL, `Label3_name` varchar(10) DEFAULT NULL, `Label3_name_hint` varchar(30) DEFAULT NULL, `Label4_nature` varchar(10) DEFAULT NULL, `Label4_nature_hint` varchar(30) DEFAULT NULL, `Document` varchar(15) DEFAULT NULL, `CashTypeCode` varchar(100) DEFAULT NULL, `ProjectCodeName` varchar(100) DEFAULT NULL, `CostCenterCodeName` varchar(100) DEFAULT NULL, `Type` varchar(100) DEFAULT NULL, `Nature` varchar(100) DEFAULT NULL, `LedgerinactiveDate` varchar(100) DEFAULT NULL, `Currency` varchar(100) DEFAULT NULL, `Groupp` varchar(100) DEFAULT NULL, `RequireDetail` varchar(100) DEFAULT NULL, `Sequence` varchar(100) DEFAULT NULL, `Length` varchar(100) DEFAULT NULL, `Other` varchar(100) DEFAULT NULL, `Clients` varchar(100) DEFAULT NULL, `Suppliers` varchar(100) DEFAULT NULL, `Salesmen` varchar(100) DEFAULT NULL, `Student` varchar(100) DEFAULT NULL, `Code` varchar(100) DEFAULT NULL, `Name` varchar(100) DEFAULT NULL, `Document_hint` varchar(30) DEFAULT NULL, `Label6_Des` varchar(15) DEFAULT NULL, `Label6_des_hint` varchar(30) DEFAULT NULL, `Label11_balance` varchar(10) DEFAULT NULL, `Label9_debit` varchar(10) DEFAULT NULL, `Label10_credit` varchar(10) DEFAULT NULL, `Label8_ccode` varchar(20) DEFAULT NULL, `Label7_num` varchar(20) DEFAULT NULL, `Caption` varchar(30) DEFAULT NULL, `Stringfield2d_to_3d` varchar(35) DEFAULT NULL, `First_page` varchar(15) DEFAULT NULL, `Previous_page` varchar(15) DEFAULT NULL, `Next_page` varchar(15) DEFAULT NULL, `Last_page` varchar(15) DEFAULT NULL, `ChecksforCollections` varchar(35) DEFAULT NULL, `ChecksforPayments` varchar(35) DEFAULT NULL, `BillsforCollections` varchar(35) DEFAULT NULL, `BillsforPayments` varchar(35) DEFAULT NULL, `f_Group` varchar(25) DEFAULT NULL, `Detail` varchar(25) DEFAULT NULL, `Page` varchar(25) DEFAULT NULL, `PrintedDate` varchar(25) DEFAULT NULL, `Time` varchar(25) DEFAULT NULL, `Title` varchar(25) DEFAULT NULL, `Class` varchar(25) DEFAULT NULL, `CounterValueIn` varchar(30) DEFAULT NULL, `Closeform` varchar(25) DEFAULT NULL, `Openform` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `Cur` varchar(25) DEFAULT NULL, `NumberName` varchar(100) DEFAULT NULL, `Description` varchar(100) DEFAULT NULL, `CoNumberName` varchar(100) DEFAULT NULL, `AddLedger` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ledger_label` -- LOCK TABLES `ledger_label` WRITE; /*!40000 ALTER TABLE `ledger_label` DISABLE KEYS */; INSERT INTO `ledger_label` VALUES ('Arabic','C????/C????/C?C??/C??E??E/C????E/C?O??','??? C????E ?CIIC? E?C??? C???CE','????E C???CE','??? C????E ???? ????E C???CE','??? E?C? C?????E','??? C????E ???? ????E C???CE ???? E?C??','C????','CIIC? ??? C???CE','C????','CIIC? ??? C???CE','C?C??','CIIC? C?C??','C??E??E',NULL,'??E?I','رمز نوع النقدية','رمز المشروع / اسم','Costcenter Code / Name','Type','Nature','Ledger Inactive Date','Currency','Group','Require Detail','Sequence','Length','Other','Clients','Suppliers','Salesmen','Student','Code','Name','??? C?E? ?? ??CE ?? ?C?I','C?O??','CIIC? O?? C???CE','C????I','?I??','IC??','C????E','??? C???CE','E???? C???C?EE','??E?C? ?? E?I?? C?? E?CEE ?E?CI','C????E C?????','C????E C??CE?E','C????E C??C??E','C????E C??I??E','O??CE ??E????','O??CE ??I??','??ICE ??E????','??ICE ??I??','?????E','E????','C????E','EC??I C??EC?E','C???E','C???CE C??C?','C???','C????E C???CI?E','?U?C? C?OCOE','?E? C?OCOE','??? ??? C????','??? C?E?I??','??? C???C?E','C????E','الرقم \\ الاسم','الوصف','الرقم المشترك \\ الاسم','Add Ledger'),('English','Type/ Number/ Name/ Nature/ Currency/ Description','This page is to enter the ledger attribute','Status','This page is the ledger status','Status Chart','This page is to represent the status ledger in Chart','Type','Enter the type of account','No.','Enter the account number','Name','Enter the Name','Nature','Define the ledger','Document','Cash Type Code','Project Code / Name','Costcenter Code / Name','Type','Nature','Ledger Inactive Date','Currency','Group','Require Detail','Sequence','Length','Other','Clients','Suppliers','Salesmen','Student','Code','Name','Group Several ledger in one','Description','Enter Ledger Description','Balance','Debit','Credit','Currency','Ledger No.','General Ledger','Change from 2D to 3D','First Page','Previous Page','Next Page','Last Page','Checks for Collections','Checks for Payments','Bills for Collections','Bills for Payments','Group','Detail','Page','Printed Date','Time','General Ledger','Class','Counter Value in','Close Form','Open Form','Delete Record #','Edit #','Insert #','Cur.','Number / Name','Description','Co-Number / Name','Add Ledger'),('French','Type/ Numéro / Nom/ Nature/ Devise/ Description','Cette Page pour entrer les attirbues du compte','Status','Cette page pour le status du compte','Status en Chart','Cette page pour représenter le status en chart','Type','Entrer le type du compte','No.','Entrer le numéro du compte','Nom','Entrer le Nom','Nature','Définir le compte','Document','Type de Trésorerie Code','Code du Projet / Nom','Coût Code du Centre / Nom','Type','Nature','Ledger Inactif Date','Devise','Groupe','Détail Requis','Séquence','Longueur','Autre','Clients','Fournisseurs','Vendeur','Élève','Code','Nom','Grouper plusieurs comptes','Description','Entrer la description','Solde','Débit','Crédit','Devise','No. Compte','Plan Comptable','Changer du 2D au 3D','Première Page','Page Précédente','Page suivante','Dernière Page','Chèques pr Collection','Chèques pr Paiement','Billets pr Collection','Billets pr Paiement','Groupe','Détail','Page','Date d\'impression','Heures','Compte Général','Classe','Equivalent','Forme Fermée','Forme Ouverte','Registre Effacé #','Edit #','Insertion #','Dev.','Nombre / Nom','Description','Co-Numéro / Nom','Ajouter Ledger'),('Spanish',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Documento','Código Tipo de Caja','Código Proyecto / Nombre','Centro Costar Código / Nombre','Tipo','Naturaleza','Ledger Inactivo Fecha','Moneda','Grupo','Detalle Requerido','Secuencia','Longitud','Otro','Clientela','Proveedores','Vendedor','Estudiante','Código','Nombre',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Número / Nombre','Descripción','Co-Número / Nombre','Añadir Ledger'); /*!40000 ALTER TABLE `ledger_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:20:53 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprolebouquet -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `project_label` -- DROP TABLE IF EXISTS `project_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `project_label` ( `Language` varchar(15) NOT NULL, `Caption` varchar(20) DEFAULT NULL, `Tab1` varchar(20) DEFAULT NULL, `Code` varchar(20) DEFAULT NULL, `Code_hint` varchar(25) DEFAULT NULL, `Name` varchar(20) DEFAULT NULL, `Name_hint` varchar(25) DEFAULT NULL, `Tab1_hint` varchar(50) DEFAULT NULL, `Deactivate` varchar(20) DEFAULT NULL, `OpenForm` varchar(25) DEFAULT NULL, `DeleteRecordNo` varchar(25) DEFAULT NULL, `EditNo` varchar(25) DEFAULT NULL, `InsertNo` varchar(25) DEFAULT NULL, `CloseForm` varchar(25) DEFAULT NULL, `MainPage` varchar(100) DEFAULT NULL, `Detail` varchar(100) DEFAULT NULL, `CreationDate` varchar(100) DEFAULT NULL, `Email` varchar(100) DEFAULT NULL, `Parent` varchar(100) DEFAULT NULL, `People` varchar(100) DEFAULT NULL, `View` varchar(100) DEFAULT NULL, `Floor` varchar(100) DEFAULT NULL, `Smoking` varchar(100) DEFAULT NULL, `AddProject` varchar(100) DEFAULT NULL, PRIMARY KEY (`Language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `project_label` -- LOCK TABLES `project_label` WRITE; /*!40000 ALTER TABLE `project_label` DISABLE KEYS */; INSERT INTO `project_label` VALUES ('Arabic','OCOE C??OC ???','C????/C?C??','C????','CIIC? ??? ?I?I','C?C??','CIIC? C?C??','??E C????E ?CIIC? C???? ?C?C??','????I','?E? C?OCOE','??? ??? C????','??? C?E?I??','??? C???C?E','?U?C? C?OCOE','Main Page','Detail','Creation Date','Email','Parent','People','View','Floor','Smoking','Add Project'),('English','Project Form','Code / Name','Code','Enter new code','Name','Enter name','This is the page where to enter code and name','Deactivate','Open Form','Delete Record #','Edit #','Insert #','Close Form','Main Page','Detail','Creation Date','Email','Parent','People','View','Floor','Smoking','Add Project'),('French','Forme du Projet','Code / Nom','Code','Entrez noveau code','Nom','Entrez le nom','Cette page est pour entrer le code et le nom','Inactif','Forme Ouverte','Registre Effacé #','Edit #','Insertion #','Forme Fermée','Page d\'Accueil','Détail','Date de Création','Email','Parent','Gens','Vue','Sol','Fumeur','Ajouter un Projet'),('Spanish',NULL,NULL,'Código',NULL,'Nombre',NULL,NULL,'Desactivar',NULL,NULL,NULL,NULL,NULL,'Pagina Principal','Detalle','Fecha de Creación','Email','Padre','Gente','Ver','Piso','De Fumar','Agregar Proyecto'); /*!40000 ALTER TABLE `project_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2016-11-02 11:18:48 DROP TABLE IF EXISTS `accesslabelstpro`.`grouping_label`; CREATE TABLE `accesslabelstpro`.`grouping_label` ( `language` varchar(45) DEFAULT NULL, `Group_Code` varchar(45) DEFAULT NULL, `Group_Name` varchar(45) DEFAULT NULL, `Group_Commission` varchar(45) DEFAULT NULL, `Group_color` varchar(45), `Group_BelongsToGroup` varchar(45) DEFAULT NULL, `SendReceive_Reference` varchar(45) DEFAULT NULL, `Group_posted` varchar(45), `Group_Parent` varchar(45), `Group_discountPer` varchar(45) DEFAULT NULL, `Synchronized` varchar(45), `grouph_code` varchar(45) DEFAULT NULL, `Group_CreationDate` varchar(45) DEFAULT NULL, `inventory_ledger` varchar(45) DEFAULT NULL, `Charge_ledger` varchar(45) DEFAULT NULL, `Revenue_ledger` varchar(45) DEFAULT NULL, `Promotion_ledger` varchar(45) DEFAULT NULL, `Discount_Ledger` varchar(45) DEFAULT NULL, `Vat_ledger` varchar(45) DEFAULT NULL, `Group_Commission2` varchar(45) NOT NULL, `Parent_Code` varchar(45) DEFAULT NULL, `Owner_Branch` varchar(45) DEFAULT NULL, `group_length` varchar(45), `grouping_pricelist` varchar(45), `grouping_optionledger` varchar(45) DEFAULT NULL, `grouping_groupcode2` varchar(45) DEFAULT NULL, `grouping_ledgernumber2` varchar(45) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `accesslabelstpro`.`warehouse_label`; CREATE TABLE `accesslabelstpro`.`warehouse_label` ( `language` VARCHAR(45) NOT NULL, `creation_date` VARCHAR(45) NOT NULL, `code` VARCHAR(45) NOT NULL, `name` VARCHAR(45) NOT NULL, `transit` VARCHAR(45) NOT NULL, `type` VARCHAR(45) NOT NULL ) ENGINE = InnoDB; DROP TABLE IF EXISTS `accesslabelstpro`.`subgroup_label`; CREATE TABLE `accesslabelstpro`.`subgroup_label` ( `creation_date` VARCHAR(45), `code` VARCHAR(45), `name` VARCHAR(45), `group_code` VARCHAR(45), `parent` VARCHAR(45), `type` VARCHAR(45), `dimension` VARCHAR(45), `color` VARCHAR(45), `sub_order` VARCHAR(45), `language` VARCHAR(45) ) ENGINE = InnoDB; DROP TABLE IF EXISTS `accesslabelstpro`.`buttons_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `accesslabelstpro`.`buttons_label` ( `language` varchar(45) DEFAULT NULL, `buttonclear` varchar(45) DEFAULT NULL, `save` varchar(45) DEFAULT NULL, `print` varchar(45) DEFAULT NULL, `find` varchar(45) DEFAULT NULL, `clear` varchar(45) DEFAULT NULL, `results` varchar(45) DEFAULT NULL, `page` varchar(45) DEFAULT NULL, `check_button` varchar(45) DEFAULT NULL, `Add_button` varchar(45) DEFAULT NULL, `Load_items` varchar(45) DEFAULT NULL, `Submit_button` varchar(45) DEFAULT NULL, `remainchar` varchar(45) DEFAULT NULL, `excel` varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `buttons_label` -- LOCK TABLES `accesslabelstpro`.`buttons_label` WRITE; /*!40000 ALTER TABLE `buttons_label` DISABLE KEYS */; INSERT INTO `accesslabelstpro`.`buttons_label` VALUES ('English','Clear Page','Save','Print','Find','Clear','Results','Page','Check','Add','Load Items','Submit','Remaining Chars','excel'),('French','Page claire','Sauver','imprimer','Trouver','Claire','Resultats','Page','vérifier','Ajouter','Charger des éléments','Soumettre','Caractères restants','excel'); /*!40000 ALTER TABLE `buttons_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-08-17 13:45:07 DROP TABLE IF EXISTS `accesslabelstpro`.`category_label`; CREATE TABLE `accesslabelstpro`.`category_label` ( `language` varchar(45), `Category_Code` varchar(45) , `Category_name` varchar(45) , `Category_Price1` varchar(100) , `Category_Price2` varchar(100) , `Category_Price3` varchar(100) , `Category_Price4` varchar(100) , `Category_Price5` varchar(100) , `Category_Price6` varchar(100) , `Category_BelongsToGroup` varchar(100) , `Synchronized` varchar(100) , `Category_Posted` varchar(100) , `Category_CreationDate` varchar(100) , `Owner_Branch` varchar(100) , `category_length` varchar(100) ) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `accesslabelstpro`.`ledgergrp_label`; CREATE TABLE `accesslabelstpro`.`ledgergrp_label` ( `creation_date` VARCHAR(45) DEFAULT NULL, `code` VARCHAR(45), `name` VARCHAR(45), `project_code` VARCHAR(45), `language` VARCHAR(45) ) ENGINE = InnoDB; DROP TABLE IF EXISTS `accesslabelstpro`.`transactionsetup_label`; CREATE TABLE `accesslabelstpro`.`transactionsetup_label` ( `language` VARCHAR(45), `group_code` VARCHAR(45), `vat_account` VARCHAR(45), `chk_GeneralAccount` VARCHAR(45), `rawmat_account` VARCHAR(45), `currency` VARCHAR(45), `nonrawmat_account` VARCHAR(45), `rawmatttc_account` VARCHAR(45), `nonrawmatttc_account` VARCHAR(45), `disc_account` VARCHAR(45), `rawmat_account2` VARCHAR(45), `nonrawmat_account2` VARCHAR(45), `tips_account` VARCHAR(45), `export_account` VARCHAR(45), `stockcurrency` VARCHAR(45), `debit_account` VARCHAR(45), `credit_account` VARCHAR(45), `debit_account2` VARCHAR(45), `credit_account2` VARCHAR(45), `nonvatacc` VARCHAR(45), `vatacc` VARCHAR(45), `direct_stock` VARCHAR(45) ) ENGINE = InnoDB; insert into `accesslabelstpro`.ledgergrp_label(language,creation_date, code, name, project_code) values('English','Creation Date','Code','Name','Project Code'); insert into `accesslabelstpro`.ledgergro_label(language,creation_date, code, name, project_code) values('French','Date de Creation','Code','Nom','Code de Projet'); insert into `accesslabelstpro`.category_label(language, Category_Code, Category_name, Category_Price1, Category_Price2, Category_Price3, Category_Price4, Category_Price5, Category_Price6, Category_CreationDate)values('English','Code','Name','Selling Price','Selling Price','Selling Price','Selling Price','Selling Price', 'Selling Price','Creation Date'); insert into `accesslabelstpro`.category_label(language, Category_Code, Category_name, Category_Price1, Category_Price2, Category_Price3, Category_Price4, Category_Price5, Category_Price6,Category_CreationDate)values('French','Code','Nom','prix de vente','prix de vente','prix de vente','prix de vente','prix de vente', 'prix de vente','date de création'); insert into `accesslabelstpro`.subgroup_label(creation_date, code, name, group_code, parent, type, dimension, color, sub_order, language) values('Creation Date','Code','Name','Group Code','Parent','Type','Dimension','Color','order','English'); insert into `accesslabelstpro`.subgroup_label(creation_date, code, name, group_code, parent, type, dimension, color, sub_order, language) values('Date de Creation','Code','Nom','Codede Groupe','Parent','Type','Dimension','Couleur','ordre','French'); insert into `accesslabelstpro`.warehouse_label(language, creation_date, code, name, transit,type) values('English','Creation Date','Code','Name','Transit','type'); insert into `accesslabelstpro`.warehouse_label(language, creation_date, code, name, transit,type) values('French','Date de Creation','Code','Nom','Transit','type'); insert into `accesslabelstpro`.grouping_label(language,Group_CreationDate,Group_Code, Group_Name, Group_Commission, Group_discountPer,grouping_groupcode2,grouping_ledgernumber2 ,inventory_ledger,Revenue_ledger,Discount_Ledger,Charge_ledger,Promotion_ledger, Vat_ledger,grouping_pricelist) values('English','Creation Date','Code','Name','Commission','Discount','Copy Account Map From Similar Group','Map to a temporarly account', 'Inventory Acc','Revenue Acc','Discount Acc','Cost Acc','Promotion Acc', 'VAT on Purchase','Price List'); insert into `accesslabelstpro`.grouping_label(language,Group_CreationDate,Group_Code, Group_Name, Group_Commission, Group_discountPer,grouping_groupcode2,grouping_ledgernumber2 ,inventory_ledger,Revenue_ledger,Discount_Ledger,Charge_ledger,Promotion_ledger, Vat_ledger,grouping_pricelist) values('French','Date de Creation','Code','Nom','Commission','Reduction','Copier le plan de compte du groupe similaire','Carte sur un compte temporaire', 'Compte d\'inventaire','Revenue Acc ','Discount Acc','Cost Acc','Promotion Acc ', 'VAT sur l\'achat','Liste de prix'); insert into `accesslabelstpro`.transactionsetup_label( language,group_code,vat_account,chk_GeneralAccount,rawmat_account,currency,nonrawmat_account,rawmatttc_account, nonrawmatttc_account,disc_account,rawmat_account2,nonrawmat_account2,tips_account,export_account,stockcurrency, debit_account,credit_account,debit_account2,credit_account2,nonvatacc,vatacc,direct_stock ) values('English','Group','Vat Account','General Account','Raw Material','Currency','Non Raw Material','Raw Mat. TTC Inc','Non R.M. TTC Inc','Discount Account','Raw Material','Non Raw Material','Tips Account','Export Account','Currency','Debit Account','Credit Account' ,'Debit Account','Credit Account','Non Vatable Accounts','Vatable Accounts','Direct Stock'); insert into `accesslabelstpro`.transactionsetup_label( language,group_code,vat_account,chk_GeneralAccount,rawmat_account,currency,nonrawmat_account,rawmatttc_account, nonrawmatttc_account,disc_account,rawmat_account2,nonrawmat_account2,tips_account,export_account,stockcurrency, debit_account,credit_account,debit_account2,credit_account2,nonvatacc,vatacc,direct_stock ) values('French','Groupe','Compte vat','Compte General','Matière première','monnaie','Non Matière première','Matière première. TTC Inc','Non M.P. TTC Inc','Compte de réduction','Matière première',' Non Matière première','Compte de conseils','Exporter le compte','monnaie','Compte de débit','Compte créditeur' ,'Compte de débit','Compte créditeur','Comptes non vécus','Comptes immobiliers','Stock direct'); DROP TABLE IF EXISTS `accesslabelstpro`.`suppliers_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `accesslabelstpro`.`suppliers_label` ( `language` varchar(45) NOT NULL, `creationdate` varchar(45) DEFAULT NULL, `supplier_group` varchar(45) DEFAULT NULL, `code` varchar(45) DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `name_arabic` varchar(45) DEFAULT NULL, `representative` varchar(45) DEFAULT NULL, `description` varchar(45) DEFAULT NULL, `area` varchar(45) DEFAULT NULL, `vat` varchar(45) DEFAULT NULL, `vat_number` varchar(45) DEFAULT NULL, `vat_date` varchar(45) DEFAULT NULL, `currency` varchar(45) DEFAULT NULL, `credit_limit` varchar(45) DEFAULT NULL, `pay_terms` varchar(45) DEFAULT NULL, `project_code` varchar(45) DEFAULT NULL, `project_name` varchar(45) DEFAULT NULL, `costcenter` varchar(45) DEFAULT NULL, `check_approved` varchar(45) DEFAULT NULL, `check_sub` varchar(45) DEFAULT NULL, `checkexport` varchar(45) DEFAULT NULL, `check_local` varchar(45) DEFAULT NULL, `fax` varchar(45) DEFAULT NULL, `phone1` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `phone2` varchar(45) DEFAULT NULL, `homepage` varchar(45) DEFAULT NULL, `tab1` varchar(45) NOT NULL, `tab2` varchar(45) NOT NULL, `tab3` varchar(45) NOT NULL, `tab4` varchar(45) NOT NULL, `tab5` varchar(45) NOT NULL, `tab6` varchar(45) NOT NULL, `tab7` varchar(45) NOT NULL, `Title` varchar(45) NOT NULL, `First_Name` varchar(45) NOT NULL, `Father_Name` varchar(45) NOT NULL, `Last_Name` varchar(45) NOT NULL, `tel1` varchar(45) NOT NULL, `tel2` varchar(45) NOT NULL, `tel3` varchar(45) NOT NULL, `supp_email` varchar(45) NOT NULL, `reference` varchar(45) NOT NULL, `city1` varchar(45) NOT NULL, `city2` varchar(45) NOT NULL, `city3` varchar(45) NOT NULL, `city` varchar(45) NOT NULL, `state` varchar(45) NOT NULL, `country` varchar(45) NOT NULL, `address1` varchar(45) NOT NULL, `address2` varchar(45) NOT NULL, `address3` varchar(45) NOT NULL, `mother_company` varchar(45) NOT NULL, `reffered` varchar(45) NOT NULL, `owner` varchar(45) NOT NULL, `gcinumb` varchar(45) NOT NULL, `buisness_sec` varchar(45) NOT NULL, `buisness_des` varchar(45) NOT NULL, `buisness_type2` varchar(45) NOT NULL, `buisness_type3` varchar(45) NOT NULL, `item_code` varchar(45) NOT NULL, `item_desc` varchar(45) NOT NULL, PRIMARY KEY (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; INSERT INTO `accesslabelstpro`.`suppliers_label` (language, creationdate, supplier_group, code, name, name_arabic, representative, description, area, vat, vat_number, vat_date, currency, credit_limit, pay_terms, project_code, project_name, costcenter, check_approved, check_sub, checkexport, check_local, fax, phone1, email, phone2, homepage, tab1, tab2, tab3, tab4, tab5, tab6, tab7, Title, First_Name, Father_Name, Last_Name, tel1, tel2, tel3, supp_email, reference, city1, city2, city3, city, state, country, address1, address2, address3, mother_company, reffered, owner, gcinumb, buisness_sec, buisness_des, buisness_type2, buisness_type3, item_code, item_desc)VALUES ('English','Creation Date','Group','Code ','Name','Name (Arabic)','Representative','Description','Area','VAT',' Vat No',' Vat Date','Currency','Credit Limit ','Pay. Terms','Project Code','Name','Cost Center','Approved','Sub Contractor','Export ','Local','fax','phone 1','Email','phone 2','Home Page','Main Page','Contact','Other Info','Company','Others','Buisness Type','Items','Title','First Name','Father Name','Last Name','Telephone No','Telephone No 2','Telephone No 3','Email','Reference','City 1','City 2','City 3','City','State','Country','Address','Address 2','Address 3','Mother Company Code/Name','Referred by Title/Name','Owner Title/Name','GCI.No','Business Sector','Description','Business Type 2','Business Type 4','Item Code','Description'); INSERT INTO `accesslabelstpro`.`suppliers_label` (language, creationdate, supplier_group, code, name, name_arabic, representative, description, area, vat, vat_number, vat_date, currency, credit_limit, pay_terms, project_code, project_name, costcenter, check_approved, check_sub, checkexport, check_local, fax, phone1, email, phone2, homepage, tab1, tab2, tab3, tab4, tab5, tab6, tab7, Title, First_Name, Father_Name, Last_Name, tel1, tel2, tel3, supp_email, reference, city1, city2, city3, city, state, country, address1, address2, address3, mother_company, reffered, owner, gcinumb, buisness_sec, buisness_des, buisness_type2, buisness_type3, item_code, item_desc)VALUES ('French','Date de Creation','Groupe','Code ','Nom','nom (Arabic)','Representative','Description','Région','T.V.A.',' T.V.A. No',' T.V.A. Date','monnaie','Limite de crédit ','Conditions de paiement','Code de projet','Nom','Centre de coûts','Approuvé','Sous-contractant','Exportation ','Local','fax','phone 1','Email','phone 2','Page d\'accueil','Principale Page','Contact','autre Info','Compagnie','Autres','Type d\'entreprise','Articles','Titre','Prénom','Nom du père','Nom de famille','N°de téléphone','N°de téléphone 2','N°de téléphone3','Email','Reference','Ville 1','Ville 2','Ville 3','Ville','Etat','Pays','Adresse','Adresse 2','Adresse 3','Mère Société Code / Nom','Référé par Titre / Nom','Propriétaire Titre / Nom','GCI.No','Secteur d\'activité','Description','Type d\'entreprise 2','Type d\'entreprise 2 4','Code de l\'article','Description'); CREATE TABLE `accesslabelstpro`.`salesman_label` ( `language` VARCHAR(45), `creationdate` VARCHAR(45), `code` VARCHAR(45), `name` VARCHAR(45), `description` VARCHAR(45), `currency` VARCHAR(45), `credit_limit` VARCHAR(45), `manager` VARCHAR(45), `manager_ref` VARCHAR(45), `deactivate_date` VARCHAR(45), `bonus` VARCHAR(45), `commission` VARCHAR(45), `managercheck` VARCHAR(45), `address` VARCHAR(45), `sequenceprefix` VARCHAR(45), `area` VARCHAR(45), `warehouse` VARCHAR(45), `cash_account` VARCHAR(45), `fax` VARCHAR(45), `phone1` VARCHAR(45), `email` VARCHAR(45), `phone2` VARCHAR(45), `tab1` VARCHAR(45), `tab2` VARCHAR(45), `tab3` VARCHAR(45), `tab4` VARCHAR(45), `Title` VARCHAR(45), `First_Name` VARCHAR(45), `Father_Name` VARCHAR(45), `Last_Name` VARCHAR(45), `tel1` VARCHAR(45), `tel2` VARCHAR(45), `tel3` VARCHAR(45), `supp_email` VARCHAR(45), `reference` VARCHAR(45), `city1` VARCHAR(45), `city2` VARCHAR(45), `city3` VARCHAR(45), `Start_Date` VARCHAR(45), `End_Date` VARCHAR(45), `Target_Amount` VARCHAR(45), `Target_Commission` VARCHAR(45), `client_code` VARCHAR(45), `client_name` VARCHAR(45), PRIMARY KEY (`language`) ) ENGINE = InnoDB; INSERT INTO `accesslabelstpro`.`salesman_label` (language, creationdate, code, name, description, currency, credit_limit, manager, manager_ref, deactivate_date, bonus, commission, managercheck, address, sequenceprefix, area, warehouse, cash_account, fax, phone1, email, phone2, tab1, tab2, tab3, tab4, Title, First_Name, Father_Name, Last_Name, tel1, tel2, tel3, supp_email, reference, city1, city2, city3, Start_Date, End_Date, Target_Amount, Target_Commission,client_code,client_name )VALUES ('English','Creation Date','Code ','Name','Description','Currency','credit limit','Manager','Manager Ref',' Deactivate Date',' Bonus','Commission', 'Is Manager','Address','Sequenece Prefix','Area','warehouse','Cash Account','fax','phone 1','Email','phone 2','Main Page','Contact','Sales Commission','Sales Commission By Client', 'Title','First Name','Father Name','Last Name','Telephone No','Telephone No 2','Telephone No 3','Email','Reference','City 1','City 2','City 3', 'Start Date','End Date','Target Amount','Target Commission ','client code','Name'); INSERT INTO `accesslabelstpro`.`salesman_label` (language, creationdate, code, name, description, currency, credit_limit, manager, manager_ref, deactivate_date, bonus, commission, managercheck, address, sequenceprefix, area, warehouse, cash_account, fax, phone1, email, phone2, tab1, tab2, tab3, tab4, Title, First_Name, Father_Name, Last_Name, tel1, tel2, tel3, supp_email, reference, city1, city2, city3, Start_Date, End_Date, Target_Amount, Target_Commission,client_code,client_name )VALUES ('French','Date de Creation','Code ','Nom','Description','Monnaie','limite de crédit','Directeur','Directeur Ref',' date deactive',' prime','Commission', 'est Directeur','Adresse','Préfixe de séquence','region','entrepôt','Compte de trésorerie','fax','phone 1','Email','phone 2','Page principale','Contact','Commission de vente','Commission de vente par Client', 'Titre','Prénom','Nom du père','Nom de famille','N°de téléphone','N°de téléphone 2','N°de téléphone3','Email','Reference','Ville 1','Ville 2','Ville 3', 'Date de début','Date de fin','Montant cible','Commission cible ',' client Code ','nom'); -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprosiegwerk2 -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `clients_label` -- DROP TABLE IF EXISTS `accesslabelstpro`.`clients_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `accesslabelstpro`.`clients_label` ( `language` varchar(45) NOT NULL DEFAULT '', `creation_date` varchar(45) DEFAULT NULL, `deactivate_date` varchar(45) DEFAULT NULL, `client_group` varchar(45) DEFAULT NULL, `code` varchar(45) DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `namearabic` varchar(45) DEFAULT NULL, `description` varchar(45) DEFAULT NULL, `salesman` varchar(45) DEFAULT NULL, `projet` varchar(45) DEFAULT NULL, `costcenter` varchar(45) DEFAULT NULL, `checkacc` varchar(45) DEFAULT NULL, `currency` varchar(45) DEFAULT NULL, `customer_type` varchar(45) DEFAULT NULL, `legal_type` varchar(45) DEFAULT NULL, `discount` varchar(45) DEFAULT NULL, `credit_limit` varchar(45) DEFAULT NULL, `vat_date` varchar(45) DEFAULT NULL, `selling_price` varchar(45) DEFAULT NULL, `payement_type` varchar(200) DEFAULT NULL, `type1` varchar(45) DEFAULT NULL, `terms` varchar(45) DEFAULT NULL, `term2` varchar(45) DEFAULT NULL, `cl_mode` varchar(45) DEFAULT NULL, `tc` varchar(45) DEFAULT NULL, `frof_cisits` varchar(45) DEFAULT NULL, `commission` varchar(45) DEFAULT NULL, `discount_inv` varchar(45) DEFAULT NULL, `financialno` varchar(45) DEFAULT NULL, `profit_Center` varchar(45) DEFAULT NULL, `budgetlimit` varchar(45) DEFAULT NULL, `checkdueterm` varchar(45) DEFAULT NULL, `crlimit` varchar(45) DEFAULT NULL, `export` varchar(45) DEFAULT NULL, `sentmail` varchar(45) DEFAULT NULL, `vat` varchar(45) DEFAULT NULL, `wht` varchar(45) DEFAULT NULL, `showm` varchar(45) DEFAULT NULL, `matdate` varchar(45) DEFAULT NULL, `cl_local` varchar(45) DEFAULT NULL, `cashmode` varchar(45) DEFAULT NULL, `vatno` varchar(45) DEFAULT NULL, `whtper` varchar(45) DEFAULT NULL, `country` varchar(45) DEFAULT NULL, `state` varchar(45) DEFAULT NULL, `home_page` varchar(45) DEFAULT NULL, `phone1` varchar(45) DEFAULT NULL, `phone2` varchar(45) DEFAULT NULL, `phone3` varchar(45) DEFAULT NULL, `area` varchar(45) DEFAULT NULL, `bos` varchar(45) DEFAULT NULL, `fax` varchar(45) DEFAULT NULL, `technicalper` varchar(45) DEFAULT NULL, `technical_email` varchar(45) DEFAULT NULL, `address` varchar(45) DEFAULT NULL, `address2` varchar(45) DEFAULT NULL, `address3` varchar(45) DEFAULT NULL, `Title` varchar(45) DEFAULT NULL, `First_Name` varchar(45) DEFAULT NULL, `Father_Name` varchar(45) DEFAULT NULL, `Last_Name` varchar(45) DEFAULT NULL, `tel1` varchar(45) DEFAULT NULL, `tel2` varchar(45) DEFAULT NULL, `tel3` varchar(45) DEFAULT NULL, `reference` varchar(45) DEFAULT NULL, `city1` varchar(45) DEFAULT NULL, `city2` varchar(45) DEFAULT NULL, `city3` varchar(45) DEFAULT NULL, `seeling_group` varchar(45) DEFAULT NULL, `category` varchar(45) DEFAULT NULL, `sugroup` varchar(45) DEFAULT NULL, `items` varchar(45) DEFAULT NULL, `agent` varchar(45) DEFAULT NULL, `mother_company` varchar(45) DEFAULT NULL, `bussiness_type` varchar(45) DEFAULT NULL, `owner` varchar(45) DEFAULT NULL, `referredby` varchar(45) DEFAULT NULL, `sd1no` varchar(45) DEFAULT NULL, `assistant` varchar(45) DEFAULT NULL, `work_title` varchar(45) DEFAULT NULL, `warehouse` varchar(45) DEFAULT NULL, `home` varchar(45) DEFAULT NULL, `gcnumber` varchar(45) DEFAULT NULL, `archivefile` varchar(45) DEFAULT NULL, `invoicelanguage` varchar(45) DEFAULT NULL, `delivery` varchar(45) DEFAULT NULL, `majorstrenght` varchar(45) DEFAULT NULL, `weakness` varchar(45) DEFAULT NULL, `tips` varchar(45) DEFAULT NULL, `remark` varchar(45) DEFAULT NULL, `invoice_rounded` varchar(45) DEFAULT NULL, `product` varchar(45) DEFAULT NULL, `ratio` varchar(45) DEFAULT NULL, `start_date` varchar(45) DEFAULT NULL, `end_date` varchar(45) DEFAULT NULL, `business_sector` varchar(45) DEFAULT NULL, `business_type1` varchar(45) DEFAULT NULL, `business_type2` varchar(45) DEFAULT NULL, `business_type3` varchar(45) DEFAULT NULL, `tobcode` varchar(45) DEFAULT NULL, `multiple_sales` varchar(45) DEFAULT NULL, `clientip_startdate` varchar(45) DEFAULT NULL, `clientip_enddate` varchar(45) DEFAULT NULL, `lasttransdate` varchar(45) DEFAULT NULL, `periodbymonth` varchar(45) DEFAULT NULL, `installmonth` varchar(45) DEFAULT NULL, `techinicianname` varchar(45) DEFAULT NULL, `subscriber_name` varchar(45) DEFAULT NULL, `clientip` varchar(45) DEFAULT NULL, `clienttc` varchar(45) DEFAULT NULL, `clientip_category` varchar(45) DEFAULT NULL, `client_ipservice` varchar(45) DEFAULT NULL, `clientip_currency` varchar(45) DEFAULT NULL, `uploadip` varchar(45) DEFAULT NULL, `downloadip` varchar(45) DEFAULT NULL, `macip` varchar(45) DEFAULT NULL, `portip` varchar(45) DEFAULT NULL, `modemip` varchar(45) DEFAULT NULL, `projectip` varchar(45) DEFAULT NULL, `costcenterip` varchar(45) DEFAULT NULL, `reasonip` varchar(45) DEFAULT NULL, `collection_name` varchar(45) DEFAULT NULL, `subscriber_address` varchar(45) DEFAULT NULL, `tab1` varchar(45) DEFAULT NULL, `tab2` varchar(45) DEFAULT NULL, `tab3` varchar(45) DEFAULT NULL, `tab4` varchar(45) DEFAULT NULL, `tab5` varchar(45) DEFAULT NULL, `tab6` varchar(45) DEFAULT NULL, `tab7` varchar(45) DEFAULT NULL, `tab8` varchar(45) DEFAULT NULL, `tab9` varchar(45) DEFAULT NULL, `tab10` varchar(45) DEFAULT NULL, `tab11` varchar(45) DEFAULT NULL, `pobox` varchar(45) DEFAULT NULL, `amount_label` varchar(45) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, PRIMARY KEY (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `clients_label` -- LOCK TABLES `accesslabelstpro`.`clients_label` WRITE; /*!40000 ALTER TABLE `clients_label` DISABLE KEYS */; INSERT INTO `accesslabelstpro`.`clients_label` VALUES ('English','Creation Date','Deactivate Date','Group','Code','Name','Name (Arabic)','Description','Salesman','Prj','CostCenter','Check acc','Curency','Customer Type','Legal Type','Disc','Credit Limit','Vat Date','Selling price','Payment Type (A : After , B:Before, O: on delivery)','Type','Terms','Term 2','Mode','TC','Fr.Of Visits','Commission','Disc on Invoice','Financial No','Profi Center','Budget Limit','Check Due term','Show Cr. Limit ','Export','Sent Email','Vat','WHT','Show Mat. Date','Show Mat. Date','Local','Cash Mode','Vat N0','WHT %','Country','State','Home page','Phone 1','Phone 2','Phone 3','Area',NULL,'Po .Box','Technical Person','Technical Email','Address 1','Address 2','Address 3','Title','First Name','Farther Name','Last Name','Telephone No 1','Telephone No 2','Telephone No 3','Reference','City 1','City 2','City 3','Group','Category','SubGroup','Items','Agent','Mother Company','Bussiness Type','Owner','Referred By','SDI.No','Assistant','WorkTitle','Warehouse','Phone','GCI.No','Archive File No.','Invoice Language','Delivery','Major Strength','Weakness','Tips','Remark','Invoice Rounded','Product','ratio','Start Date','End Date','Business Sector','Business Type','Business Type 2','Business Type 3','T.O.B. Code','Multiple Sales',NULL,NULL,'Last Trans Date','Period By Month','Start Date* \r\nEnd Date \r\nLast Trans Date \r\n ','Technician Name','Subscriber Name','IP','Tc','Category','Service','Currency','Upload IP','Download IP','MAC Address','Port','Modem IP','Project','CostCenter','Reason Disabled','Collection Name','Subscriber Address','Main Page','Address','Selling Price','Contract','Company','Delivery','Others','Competitor','Activation','Business Sector','clientsIp','Po .Box','Amount','City','Email'),('French',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Show Cr. Limit ',NULL,NULL,NULL,'WHT','','Show Mat. Date','Local','Cash Mode','Vat N0','WHT %','Country','State','Home page','Phone','Phone 2','Phone 3','Area',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Po .Box',NULL,NULL,NULL); /*!40000 ALTER TABLE `clients_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-08-14 14:46:27 DROP TABLE IF EXISTS `accesslabelstpro`.`items_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `accesslabelstpro`.`items_label` ( `language` varchar(45) NOT NULL DEFAULT '', `code` varchar(45) DEFAULT NULL, `vat` varchar(45) DEFAULT NULL, `currency` varchar(45) DEFAULT NULL, `activedate` varchar(45) DEFAULT NULL, `inactivedate` varchar(45) DEFAULT NULL, `creationdate` varchar(45) DEFAULT NULL, `createdby` varchar(45) DEFAULT NULL, `longdesc` varchar(45) DEFAULT NULL, `item_group` varchar(45) DEFAULT NULL, `description_arabic` varchar(45) DEFAULT NULL, `subgroup` varchar(45) DEFAULT NULL, `description` varchar(45) DEFAULT NULL, `costcenter` varchar(45) DEFAULT NULL, `supplier` varchar(45) DEFAULT NULL, `project` varchar(45) DEFAULT NULL, `remark` varchar(45) DEFAULT NULL, `warehouse` varchar(45) DEFAULT NULL, `package` varchar(45) DEFAULT NULL, `lastprice` varchar(45) DEFAULT NULL, `minimumprice` varchar(45) DEFAULT NULL, `fixedcost` varchar(45) DEFAULT NULL, `category` varchar(45) DEFAULT NULL, `discount` varchar(45) DEFAULT NULL, `reducer` varchar(45) DEFAULT NULL, `retarder` varchar(45) DEFAULT NULL, `Gloss` varchar(45) DEFAULT NULL, `Adhesion` varchar(45) DEFAULT NULL, `Alkali` varchar(45) DEFAULT NULL, `Scuff` varchar(45) DEFAULT NULL, `Shade` varchar(45) DEFAULT NULL, `Strength` varchar(45) DEFAULT NULL, `Packing` varchar(45) DEFAULT NULL, `Viscositydirect` varchar(45) DEFAULT NULL, `Viscosityreduced` varchar(45) DEFAULT NULL, `name` varchar(45) DEFAULT NULL, `sellingprice` varchar(45) DEFAULT NULL, `qtyexist` varchar(45) DEFAULT NULL, `lastcostusd` varchar(45) DEFAULT NULL, `aubroupsupplier` varchar(45) DEFAULT NULL, `disporder` varchar(45) DEFAULT NULL, `minqty` varchar(45) DEFAULT NULL, `maxqty` varchar(45) DEFAULT NULL, `subseq` varchar(45) DEFAULT NULL, `avgcost` varchar(45) DEFAULT NULL, `wholeunit` varchar(45) DEFAULT NULL, `gweight` varchar(45) DEFAULT NULL, `netweight` varchar(45) DEFAULT NULL, `volume` varchar(45) DEFAULT NULL, `reverseprodu` varchar(45) DEFAULT NULL, `nonstock_item` varchar(45) DEFAULT NULL, `item_serialno` varchar(45) DEFAULT NULL, `evaluateqtyunit` varchar(45) DEFAULT NULL, `codeexp` varchar(45) DEFAULT NULL, `exp_ar` varchar(45) DEFAULT NULL, `exp_en` varchar(45) DEFAULT NULL, `exp_fr` varchar(45) DEFAULT NULL, `production` varchar(45) DEFAULT NULL, `ttcinclude` varchar(45) DEFAULT NULL, `print_item` varchar(45) DEFAULT NULL, `pack` varchar(45) DEFAULT NULL, `promotion` varchar(45) DEFAULT NULL, `color` varchar(45) DEFAULT NULL, `upload` varchar(45) DEFAULT NULL, `picture` varchar(45) DEFAULT NULL, `barcode1` varchar(45) DEFAULT NULL, `barcode2` varchar(45) DEFAULT NULL, `barcode3` varchar(45) DEFAULT NULL, `generate_barcode2` varchar(45) DEFAULT NULL, `Quantity` varchar(45) DEFAULT NULL, `additem_unit` varchar(45) DEFAULT NULL, `History` varchar(45) DEFAULT NULL, `Transfer` varchar(45) DEFAULT NULL, `modifyingsellpr` varchar(100) DEFAULT NULL, `lastcost` varchar(45) DEFAULT NULL, `sellingngn` varchar(45) DEFAULT NULL, `sellingusd` varchar(45) DEFAULT NULL, `attribute` varchar(45) DEFAULT NULL, `value` varchar(45) DEFAULT NULL, `unit` varchar(45) DEFAULT NULL, `quantityproduced` varchar(100) DEFAULT NULL, `item` varchar(45) DEFAULT NULL, `Cost` varchar(45) DEFAULT NULL, `Stage` varchar(45) DEFAULT NULL, `Barcode` varchar(45) DEFAULT NULL, `FromDate` varchar(45) DEFAULT NULL, `ToDate` varchar(45) DEFAULT NULL, `Qty` varchar(45) DEFAULT NULL, `reference` varchar(45) DEFAULT NULL, `NGN` varchar(45) DEFAULT NULL, `Chg` varchar(45) DEFAULT NULL, `QtyRet` varchar(45) DEFAULT NULL, `chg_r` varchar(45) DEFAULT NULL, `USD` varchar(45) DEFAULT NULL, `Price` varchar(45) DEFAULT NULL, `perunit` varchar(45) DEFAULT NULL, `warehousecode` varchar(45) DEFAULT NULL, `qty_producedin` varchar(45) DEFAULT NULL, `qtyproduceout` varchar(45) DEFAULT NULL, `qty_entered` varchar(45) DEFAULT NULL, `qtydelivered` varchar(45) DEFAULT NULL, `qty_sold` varchar(45) DEFAULT NULL, `qty_p_ordered` varchar(45) DEFAULT NULL, `qty_sordered` varchar(45) DEFAULT NULL, `qty_availabe` varchar(45) DEFAULT NULL, `rangefrom` varchar(45) DEFAULT NULL, `rangeto` varchar(45) DEFAULT NULL, `rebate` varchar(45) DEFAULT NULL, `Promotion_Qty` varchar(45) DEFAULT NULL, `description_french` varchar(45) DEFAULT NULL, `currency_item` varchar(45) DEFAULT NULL, `average_cost` varchar(45) DEFAULT NULL, `item_date` varchar(45) DEFAULT NULL, `wh` varchar(45) DEFAULT NULL, `expire` varchar(45) DEFAULT NULL, `discount_abr` varchar(45) DEFAULT NULL, `additem` varchar(45) DEFAULT NULL, `attribut_param` varchar(45) DEFAULT NULL, `search_att` varchar(45) DEFAULT NULL, `total` varchar(45) DEFAULT NULL, `tab1` varchar(45) DEFAULT NULL, `tab2` varchar(45) DEFAULT NULL, `tab3` varchar(45) DEFAULT NULL, `tab4` varchar(45) DEFAULT NULL, `tab5` varchar(45) DEFAULT NULL, `tab6` varchar(45) DEFAULT NULL, `tab7` varchar(45) DEFAULT NULL, `tab8` varchar(45) DEFAULT NULL, `tab9` varchar(45) DEFAULT NULL, `history_button` varchar(45) DEFAULT NULL, PRIMARY KEY (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `items_label` -- LOCK TABLES `accesslabelstpro`.`items_label` WRITE; /*!40000 ALTER TABLE `items_label` DISABLE KEYS */; INSERT INTO `accesslabelstpro`.`items_label` VALUES ('English','Code','Vat','Cur','Active','Inactive Date','Creation Date','Created by','Long Description','Group','Description(Arabic)','SubGroup','Description','CostCenter','Supplier','Project','Remark','Warehouse','Package','Last Cost Price','Minimum Price','Fixed Cost','Category','Discount','Reducer','Retarder','Gloss','Adhesion','Alkali','Scuff','Shade','Strength','Packing','Viscosity Direct','Viscosity Reduced','Name','Selling Price','Qty Exist','Last Cost USD','Subgroup Supplier','Disp Order','Min Quantity','Max Quantity','Sub Sequence','AVERAGE Cost(0) , FIFO (1) ,LIFO(2)','Whole Unit','G.Weight','Net Weight','Volume/Box','Reverse Production','Non Stock Item','Item with serial no','Evaluate Qty Unit','Code Export','Export EN','Export AR','Export FR','Production','TTC include','Print Item','Pack','Promotion','Color','Upload','Picture','BarCode 1','BarCode 2','BarCode 3','Generate Barcode 2','Quantity','additem_unit','History','Transfer','Modifying Selling Price (Retail)','Based on Last Cost','Selling Price NGN','Selling Price USD','Attribute','Value','Unit','Qty To Be Produced','Item','Cost','Stage','Barcode','From Date','To Date','Qty','Ref','NGN','Chg','Qty Ret','Chg R','USD','Price','/U','Warehouse Code','Quantity Produce in','Quantity Produce Out','Quantity Entered','Quantity Delivered','Quantity Sold','Quantity P Ordered','Quantity S Ordered','Quantity Available','Range From','Range To','Rebate','Promotion Qty','Description(French)','Currency','Average Cost','Date','Wh','Expire','Dis','Add Item Unit','Attribute Parameter','Search Attribute','Total','Main Page','Others','Selling Price','Attributes','Pack','Manufactured Code','Cost Price','Warehouse','Item Rebate','History'),('French','Code','T.V.A','devise','Active','Date d\'inactivité','Date de Creation','Créé par','Long Description','Groupe','Description(Arabic)','Sous-groupe','Description','Centre de coûts','Fournisseur','Projet','Remark','Entrepôt','Paquet','Dernier prix coût','Prix minimum','Coûts fixes','Catégorie','Remise','Réducteur','Retardateur','Brillant','Adhésion','Alcali','Érafler','Ombre','Force','Emballage','Viscosité directe','Viscosité réduite','Nom','Prix de vente','Qté existe','Dernier coût USD','Sous-groupe Fournisseur','Ordonnance Disp','Quantité minimale','Max Quantité','Sous-séquence','Coût moyen (0), FIFO (1), LIFO (2)','Unité entière','G.Poids','Poids net','Volume / Boîte','Production inversée','Article non stocké','Article avec numéro de série','Évaluer Qté Unité','Exportation de code','Export AN','Export AR','Export FR','Production','TTC comprend','Article imprimé','Pack','Promotion','couleur','Télécharger','Photo','BarCode 1','BarCode 2','BarCode 3','Générer le code à barres 2','Quantité',NULL,'Histoire','Transfert','Modification du prix de vente (détail)','Basé sur le dernier coût','Prix de vente NGN','Prix de vente USD','Attribut','Valeur','Unité','Qté à produire','Article','Coût','Étape','Barcode','De Date','à Date','Qty','Ref','NGN','Chg','Qty Ret','Chg R','USD','Prix','/U','Code d\'entrepôt','Quantité Produire en','Quantité Produire Out','Quantité saisie','Quantité livrée','Quantité vendue','Quantité P commandée','Quantité S commandée','Quantité disponible','Plage de','Portée vers','Rabais','Qte de promotion','Description(French)','Devise','Coût moyen','Date','Erpt','Expirer','rem','Ajouter un article','Paramètre d\'attribut','Attribut de recherche','Totale','Page d\'accueil','Autre','Prix de vente','Attributs','Pack','Code fabriqué','Prix de revient','Entrepôt','Remboursement d\'article','Histoire'); /*!40000 ALTER TABLE `items_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-08-17 14:15:50--- -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprosiegwerk2 -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `requested_item` -- DROP TABLE IF EXISTS `accesslabelstpro`.`requested_item`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `accesslabelstpro`.`requested_item` ( `language` varchar(45) NOT NULL, `reference` varchar(45) NOT NULL, `Find` varchar(45) NOT NULL, `Cancel` varchar(45) NOT NULL, `Refresh` varchar(45) NOT NULL, `Print` varchar(45) NOT NULL, `Excel` varchar(45) NOT NULL, `Details` varchar(45) NOT NULL, `showdetail` varchar(45) NOT NULL, `Warehouse` varchar(45) NOT NULL, `Datefr_to` varchar(45) NOT NULL, `Priority` varchar(45) NOT NULL, `Project` varchar(45) NOT NULL, `ItemCode_Desc` varchar(45) NOT NULL, `Status` varchar(45) NOT NULL, `Costcenter` varchar(45) NOT NULL, `Type` varchar(45) NOT NULL, `Shipping_met` varchar(45) NOT NULL, `Requestedby` varchar(45) NOT NULL, `Category` varchar(45) NOT NULL, `MSR` varchar(45) NOT NULL, `Refabr` varchar(45) NOT NULL, `Porder` varchar(45) NOT NULL, `GRN` varchar(45) NOT NULL, `Date` varchar(45) NOT NULL, `Reason` varchar(45) NOT NULL, `Confirmed` varchar(45) NOT NULL, `conf_date` varchar(45) NOT NULL, `appr_date` varchar(45) NOT NULL, `created_by` varchar(45) NOT NULL, `orderedby` varchar(45) NOT NULL, `approvedby` varchar(45) NOT NULL, `new_item` varchar(45) NOT NULL, `mainwarehouse` varchar(45) NOT NULL, `qty_exist` varchar(45) NOT NULL, `orderedqty` varchar(45) NOT NULL, `transqty` varchar(45) NOT NULL, `qty` varchar(45) NOT NULL, `unit` varchar(45) NOT NULL, `Transfer_req` varchar(45) NOT NULL, `title` varchar(45) NOT NULL, PRIMARY KEY (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `requested_item` -- LOCK TABLES `requested_item` WRITE; /*!40000 ALTER TABLE `requested_item` DISABLE KEYS */; INSERT INTO `requested_item` VALUES ('English','Reference','Find','Cancel','Refresh','Print','Excel','Details','Show Details','warehouse','Date From/To','Priority','Project','Item Code/Desc','Status','Costcenter','Type','Shipping Method','Requested By','Category','MSR','Ref','Porder','GRN','DATE','Reason','Confirmed','Confirmed Date','Approved Date','Created by','Ordered by','Approved by','New Item','Main Wh.','Exists.Qty','Ord. Qty','Trans.Qty','Qty','Unit','Transfer Req.','List of Pending Request Items'),('French','Reference','trouver','Annuler','Rafraîchir','Imprimer','Excel','Détails','Afficher les détails','entrepôt','Date de / à','Priorité','Projet','Code de l\'article / Desc','Statut','Centre de coûts','Type','Méthode d\'envoi','Demandé par','Catégorie','MSR','Ref','Porder','GRN','DATE','Raison','Confirmé','Date Confirmée','Date approuvée','Créé par','Commander par','Approuvé par','Nouvel article','Enpt principal','Existe Quantité','Quantité commandée','Trans.Qty','Qty','Unite','Transfert Req.','Liste des éléments de demande en attente'); /*!40000 ALTER TABLE `requested_item` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-09-11 7:38:11 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprosiegwerk2 -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `transferrequest_label` -- DROP TABLE IF EXISTS `accesslabelstpro`.`transferrequest_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `accesslabelstpro`.`transferrequest_label` ( `language` varchar(45) NOT NULL, `Reference` varchar(45) DEFAULT NULL, `Project` varchar(45) DEFAULT NULL, `Warehouse` varchar(45) DEFAULT NULL, `Date` varchar(45) DEFAULT NULL, `from_date` varchar(45) DEFAULT NULL, `to_date` varchar(45) DEFAULT NULL, `Driver_Name` varchar(45) DEFAULT NULL, `Vehicle_No` varchar(45) DEFAULT NULL, `Remark` varchar(45) DEFAULT NULL, `Item` varchar(45) DEFAULT NULL, `Description` varchar(45) DEFAULT NULL, `Packaging_Nbr` varchar(45) DEFAULT NULL, `nb_of_unit` varchar(45) DEFAULT NULL, `qty` varchar(45) DEFAULT NULL, `Unit` varchar(45) DEFAULT NULL, `qtyexist` varchar(45) DEFAULT NULL, `batchnb` varchar(45) DEFAULT NULL, `heatnb` varchar(45) DEFAULT NULL, `From_warehouse` varchar(45) DEFAULT NULL, `to_warehouse` varchar(45) DEFAULT NULL, `Price` varchar(45) DEFAULT NULL, `totalamount` varchar(45) DEFAULT NULL, `save` varchar(45) DEFAULT NULL, `cancel` varchar(45) DEFAULT NULL, `clear_page` varchar(45) DEFAULT NULL, `pending` varchar(45) DEFAULT NULL, `search` varchar(45) DEFAULT NULL, PRIMARY KEY (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `transferrequest_label` -- LOCK TABLES `transferrequest_label` WRITE; /*!40000 ALTER TABLE `transferrequest_label` DISABLE KEYS */; INSERT INTO `transferrequest_label` VALUES ('English','Reference','Project','Warehouse','Date','From','To','Driver Name','Vehivle No','Remark','Item','Description','Packaging Nbr','Nb Of Unit','Qty','Unit','Qty.Exits','Batch No','Heat No','From Wh.','To Wh.','Price','Total Amount','Save','Cancel','Clear Page','Pending','Search'); /*!40000 ALTER TABLE `transferrequest_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-09-11 8:52:10 -- MySQL dump 10.13 -- -- Host: localhost Database: accesslabelstprosiegwerk2 -- ------------------------------------------------------ -- Server version 5.1.22-rc-community /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `transfer_label` -- DROP TABLE IF EXISTS `transfer_label`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `transfer_label` ( `language` varchar(45) NOT NULL, `Reference` varchar(45) DEFAULT NULL, `Project` varchar(45) DEFAULT NULL, `Warehouse` varchar(45) DEFAULT NULL, `Date` varchar(45) DEFAULT NULL, `from_date` varchar(45) DEFAULT NULL, `to_date` varchar(45) DEFAULT NULL, `Driver_Name` varchar(45) DEFAULT NULL, `Vehicle_No` varchar(45) DEFAULT NULL, `Remark` varchar(45) DEFAULT NULL, `Item` varchar(45) DEFAULT NULL, `Description` varchar(45) DEFAULT NULL, `Packaging_Nbr` varchar(45) DEFAULT NULL, `nb_of_unit` varchar(45) DEFAULT NULL, `qty` varchar(45) DEFAULT NULL, `Unit` varchar(45) DEFAULT NULL, `qtyexist` varchar(45) DEFAULT NULL, `batchnb` varchar(45) DEFAULT NULL, `heatnb` varchar(45) DEFAULT NULL, `From_warehouse` varchar(45) DEFAULT NULL, `to_warehouse` varchar(45) DEFAULT NULL, `Price` varchar(45) DEFAULT NULL, `totalamount` varchar(45) DEFAULT NULL, `save` varchar(45) DEFAULT NULL, `cancel` varchar(45) DEFAULT NULL, `clear_page` varchar(45) DEFAULT NULL, `pending` varchar(45) DEFAULT NULL, `search` varchar(45) DEFAULT NULL, `load_label` varchar(45) DEFAULT NULL, `sumscan` varchar(45) DEFAULT NULL, `lastitem` varchar(45) DEFAULT NULL, `excel_import` varchar(45) DEFAULT NULL, `Barcode` varchar(45) DEFAULT NULL, `load_request` varchar(45) DEFAULT NULL, `page` varchar(45) DEFAULT NULL, `perpage` varchar(45) DEFAULT NULL, `record_to_view` varchar(45) DEFAULT NULL, PRIMARY KEY (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `transfer_label` -- LOCK TABLES `transfer_label` WRITE; /*!40000 ALTER TABLE `transfer_label` DISABLE KEYS */; INSERT INTO `transfer_label` VALUES ('English','Reference','Project','Warehouse','Date','From','To','Driver Name','Vehivle No','Remark','Item','Description','Packaging Nbr','Nb Of Unit','Qty','Unit','Qty.Exits','Batch No','Heat No','From Wh.','To Wh.','Price','Total Amount','Save','Cancel','Clear Page','Pending','Search', 'Load', 'Sum Scan', 'Last Item', 'Import Excel', 'Barcode', 'Load Request', 'Page', 'Per page', 'View Records'); /*!40000 ALTER TABLE `transfer_label` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-09-11 8:52:10