/*
SQLyog Community v9.30 
MySQL - 5.5.8 : Database - ssp
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 `authassignment` */

DROP TABLE IF EXISTS `authassignment`;

CREATE TABLE `authassignment` (
  `itemname` varchar(64) NOT NULL,
  `userid` varchar(64) NOT NULL,
  `bizrule` text,
  `data` text,
  PRIMARY KEY (`itemname`,`userid`),
  CONSTRAINT `authassignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `authassignment` */

insert  into `authassignment`(`itemname`,`userid`,`bizrule`,`data`) values ('RBAC Manager','1',NULL,'N;'),('SSC Manager','1',NULL,'N;');

/*Table structure for table `authitem` */

DROP TABLE IF EXISTS `authitem`;

CREATE TABLE `authitem` (
  `name` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `description` text,
  `bizrule` text,
  `data` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `authitem` */

insert  into `authitem`(`name`,`type`,`description`,`bizrule`,`data`) values ('ApPaymentDtl',1,'',NULL,'N;'),('ApPaymentDtl:Admin',0,'',NULL,'N;'),('ApPaymentDtl:BatchDelete',0,'',NULL,'N;'),('ApPaymentDtl:CalculateKoAmt',0,'',NULL,'N;'),('ApPaymentDtl:Create',0,'',NULL,'N;'),('ApPaymentDtl:Delete',0,'',NULL,'N;'),('ApPaymentDtl:Transfer',0,'',NULL,'N;'),('ApPaymentDtl:Update',0,'',NULL,'N;'),('ApPaymentDtl:View',0,'',NULL,'N;'),('ApPaymentHdr',1,'',NULL,'N;'),('ApPaymentHdr:Admin',0,'',NULL,'N;'),('ApPaymentHdr:Confirm',0,'',NULL,'N;'),('ApPaymentHdr:Create',0,'',NULL,'N;'),('ApPaymentHdr:Delete',0,'',NULL,'N;'),('ApPaymentHdr:Update',0,'',NULL,'N;'),('ApPaymentHdr:UpdateCurrency',0,'',NULL,'N;'),('ApPaymentHdr:UpdateVendorInfo',0,'',NULL,'N;'),('ApPaymentHdr:View',0,'',NULL,'N;'),('ArDnDtl',1,'',NULL,'N;'),('ArDnDtl:Admin',0,'',NULL,'N;'),('ArDnDtl:BatchDelete',0,'',NULL,'N;'),('ArDnDtl:CalculateNetAmt',0,'',NULL,'N;'),('ArDnDtl:CalculateOdrAmt',0,'',NULL,'N;'),('ArDnDtl:Create',0,'',NULL,'N;'),('ArDnDtl:Delete',0,'',NULL,'N;'),('ArDnDtl:Update',0,'',NULL,'N;'),('ArDnDtl:UpdateInventory',0,'',NULL,'N;'),('ArDnDtl:UpdateItem',0,'',NULL,'N;'),('ArDnDtl:UpdateUOM',0,'',NULL,'N;'),('ArDnDtl:View',0,'',NULL,'N;'),('ArDnHdr',1,'',NULL,'N;'),('ArDnHdr:Admin',0,'',NULL,'N;'),('ArDnHdr:CalculateDiscAmt',0,'',NULL,'N;'),('ArDnHdr:CalculateDiscLocalAmt',0,'',NULL,'N;'),('ArDnHdr:CalculateNetAmt',0,'',NULL,'N;'),('ArDnHdr:CalculateNetLocalAmt',0,'',NULL,'N;'),('ArDnHdr:CalculateTaxAmt',0,'',NULL,'N;'),('ArDnHdr:CalculateTaxLocalAmt',0,'',NULL,'N;'),('ArDnHdr:Confirm',0,'',NULL,'N;'),('ArDnHdr:Create',0,'',NULL,'N;'),('ArDnHdr:Delete',0,'',NULL,'N;'),('ArDnHdr:Update',0,'',NULL,'N;'),('ArDnHdr:UpdateArea',0,'',NULL,'N;'),('ArDnHdr:UpdateBranchInfo',0,'',NULL,'N;'),('ArDnHdr:UpdateCurrency',0,'',NULL,'N;'),('ArDnHdr:UpdateCustomerInfo',0,'',NULL,'N;'),('ArDnHdr:UpdateTax',0,'',NULL,'N;'),('ArDnHdr:UpdateTerm',0,'',NULL,'N;'),('ArDnHdr:View',0,'',NULL,'N;'),('Area',1,'',NULL,'N;'),('Area:Admin',0,'',NULL,'N;'),('Area:BatchDelete',0,'',NULL,'N;'),('Area:Create',0,'',NULL,'N;'),('Area:Delete',0,'',NULL,'N;'),('Area:Update',0,'',NULL,'N;'),('ArPaymentDtl',1,'',NULL,'N;'),('ArPaymentDtl:Admin',0,'',NULL,'N;'),('ArPaymentDtl:BatchDelete',0,'',NULL,'N;'),('ArPaymentDtl:CalculateKoAmt',0,'',NULL,'N;'),('ArPaymentDtl:Create',0,'',NULL,'N;'),('ArPaymentDtl:Delete',0,'',NULL,'N;'),('ArPaymentDtl:Transfer',0,'',NULL,'N;'),('ArPaymentDtl:Update',0,'',NULL,'N;'),('ArPaymentDtl:View',0,'',NULL,'N;'),('ArPaymentHdr',1,'',NULL,'N;'),('ArPaymentHdr:Admin',0,'',NULL,'N;'),('ArPaymentHdr:Confirm',0,'',NULL,'N;'),('ArPaymentHdr:Create',0,'',NULL,'N;'),('ArPaymentHdr:Delete',0,'',NULL,'N;'),('ArPaymentHdr:Update',0,'',NULL,'N;'),('ArPaymentHdr:UpdateCurrency',0,'',NULL,'N;'),('ArPaymentHdr:UpdateCustomerInfo',0,'',NULL,'N;'),('ArPaymentHdr:View',0,'',NULL,'N;'),('Auth Assignments Manager',2,'Manages Role Assignments. RBAM required role.',NULL,'N;'),('Auth Items Manager',2,'Manages Auth Items. RBAM required role.',NULL,'N;'),('Authenticated',2,'Default role for users that are logged in. RBAC default role.','return !Yii::app()->getUser()->getIsGuest();','N;'),('AutoComplete',1,'',NULL,'N;'),('AutoComplete:AutocompleteSource',0,'',NULL,'N;'),('AutoComplete:FindAreaCode',0,'',NULL,'N;'),('AutoComplete:FindCurrencyCode',0,'',NULL,'N;'),('AutoComplete:FindCustomerCategory',0,'',NULL,'N;'),('AutoComplete:FindCustomerCode',0,'',NULL,'N;'),('AutoComplete:FindDivision',0,'',NULL,'N;'),('AutoComplete:FindItemCode',0,'',NULL,'N;'),('AutoComplete:FindItemGroup',0,'',NULL,'N;'),('AutoComplete:FindLocationCode',0,'',NULL,'N;'),('AutoComplete:FindPriceGroup',0,'',NULL,'N;'),('AutoComplete:FindPromotionGroup',0,'',NULL,'N;'),('AutoComplete:FindTermsCode',0,'',NULL,'N;'),('AutoComplete:FindUOMCode',0,'',NULL,'N;'),('AutoComplete:FindUser',0,'',NULL,'N;'),('AutoComplete:FindVendorCategory',0,'',NULL,'N;'),('Company',1,'',NULL,'N;'),('Company:Admin',0,'',NULL,'N;'),('Company:Create',0,'',NULL,'N;'),('Company:Update',0,'',NULL,'N;'),('Currency',1,'',NULL,'N;'),('Currency:Admin',0,'',NULL,'N;'),('Currency:BatchDelete',0,'',NULL,'N;'),('Currency:Create',0,'',NULL,'N;'),('Currency:Delete',0,'',NULL,'N;'),('Currency:Update',0,'',NULL,'N;'),('Currency:View',0,'',NULL,'N;'),('CurrencyRate',1,'',NULL,'N;'),('CurrencyRate:BatchDelete',0,'',NULL,'N;'),('CurrencyRate:Create',0,'',NULL,'N;'),('CurrencyRate:Delete',0,'',NULL,'N;'),('CurrencyRate:Update',0,'',NULL,'N;'),('Customer',1,'',NULL,'N;'),('Customer:Admin',0,'',NULL,'N;'),('Customer:BatchDelete',0,'',NULL,'N;'),('Customer:Create',0,'',NULL,'N;'),('Customer:Delete',0,'',NULL,'N;'),('Customer:Index',0,'',NULL,'N;'),('Customer:LoadImage',0,'',NULL,'N;'),('Customer:Update',0,'',NULL,'N;'),('Customer:View',0,'',NULL,'N;'),('CustomerBranch',1,'',NULL,'N;'),('CustomerBranch:BatchDelete',0,'',NULL,'N;'),('CustomerBranch:Create',0,'',NULL,'N;'),('CustomerBranch:Delete',0,'',NULL,'N;'),('CustomerBranch:Update',0,'',NULL,'N;'),('CustomerBranch:View',0,'',NULL,'N;'),('CustomerCategory',1,'',NULL,'N;'),('CustomerCategory:Admin',0,'',NULL,'N;'),('CustomerCategory:BatchDelete',0,'',NULL,'N;'),('CustomerCategory:Create',0,'',NULL,'N;'),('CustomerCategory:Delete',0,'',NULL,'N;'),('CustomerCategory:Update',0,'',NULL,'N;'),('CustomerContact',1,'',NULL,'N;'),('CustomerContact:BatchDelete',0,'',NULL,'N;'),('CustomerContact:Create',0,'',NULL,'N;'),('CustomerContact:Delete',0,'',NULL,'N;'),('CustomerContact:Update',0,'',NULL,'N;'),('CustomerContact:View',0,'',NULL,'N;'),('CustomerDivision',1,'',NULL,'N;'),('CustomerDivision:Assign',0,'',NULL,'N;'),('CustomerDivision:BatchDelete',0,'',NULL,'N;'),('CustomerDivision:Create',0,'',NULL,'N;'),('CustomerDivision:Delete',0,'',NULL,'N;'),('CustomerDivision:DeletePriceGroup',0,'',NULL,'N;'),('CustomerDivision:Update',0,'',NULL,'N;'),('CustomerDivision:ViewAssign',0,'',NULL,'N;'),('CustomerPriceGroup',1,'',NULL,'N;'),('CustomerPriceGroup:Admin',0,'',NULL,'N;'),('CustomerPriceGroup:Assign',0,'',NULL,'N;'),('CustomerPriceGroup:Create',0,'',NULL,'N;'),('CustomerPriceGroup:Delete',0,'',NULL,'N;'),('CustomerPriceGroup:Index',0,'',NULL,'N;'),('CustomerPriceGroup:Update',0,'',NULL,'N;'),('CustomerPriceGroup:UpdateViewByDivision',0,'',NULL,'N;'),('CustomerPriceGroup:View',0,'',NULL,'N;'),('CustomerPriceGroup:ViewAssign',0,'',NULL,'N;'),('CustomerPromotionGroup',1,'',NULL,'N;'),('CustomerPromotionGroup:Admin',0,'',NULL,'N;'),('CustomerPromotionGroup:Assign',0,'',NULL,'N;'),('CustomerPromotionGroup:Create',0,'',NULL,'N;'),('CustomerPromotionGroup:Delete',0,'',NULL,'N;'),('CustomerPromotionGroup:Index',0,'',NULL,'N;'),('CustomerPromotionGroup:Update',0,'',NULL,'N;'),('CustomerPromotionGroup:View',0,'',NULL,'N;'),('CustomerPromotionGroup:ViewAssign',0,'',NULL,'N;'),('DebtorTrans',1,'',NULL,'N;'),('DebtorTrans:Admin',0,'',NULL,'N;'),('DebtorTrans:UpdateCustomerInfo',0,'',NULL,'N;'),('Division',1,'',NULL,'N;'),('Division:Admin',0,'',NULL,'N;'),('Division:AssignCustomer',0,'',NULL,'N;'),('Division:AssignItem',0,'',NULL,'N;'),('Division:AssignLocation',0,'',NULL,'N;'),('Division:AssignUser',0,'',NULL,'N;'),('Division:BatchDelete',0,'',NULL,'N;'),('Division:Create',0,'',NULL,'N;'),('Division:DecrementLocationSequence',0,'',NULL,'N;'),('Division:Delete',0,'',NULL,'N;'),('Division:IncrementLocationSequence',0,'',NULL,'N;'),('Division:Update',0,'',NULL,'N;'),('Division:View',0,'',NULL,'N;'),('Division:ViewAssignCustomer',0,'',NULL,'N;'),('Division:ViewAssignItem',0,'',NULL,'N;'),('Division:ViewAssignLocation',0,'',NULL,'N;'),('Division:ViewAssignUser',0,'',NULL,'N;'),('DocumentApprove',1,'',NULL,'N;'),('DocumentApprove:Approve',0,'',NULL,'N;'),('DocumentApprove:TagView',0,'',NULL,'N;'),('DocumentNo',1,'',NULL,'N;'),('DocumentNo:Admin',0,'',NULL,'N;'),('DocumentNo:BatchDelete',0,'',NULL,'N;'),('DocumentNo:Create',0,'',NULL,'N;'),('DocumentNo:Delete',0,'',NULL,'N;'),('DocumentNo:GetLatestDocNumber',0,'',NULL,'N;'),('DocumentNo:Update',0,'',NULL,'N;'),('DoInvDtl',1,'',NULL,'N;'),('DoInvDtl:Admin',0,'',NULL,'N;'),('DoInvDtl:BatchDelete',0,'',NULL,'N;'),('DoInvDtl:CalculateNetAmt',0,'',NULL,'N;'),('DoInvDtl:CalculateOdrAmt',0,'',NULL,'N;'),('DoInvDtl:Create',0,'',NULL,'N;'),('DoInvDtl:Delete',0,'',NULL,'N;'),('DoInvDtl:GetPackingInfo',0,'',NULL,'N;'),('DoInvDtl:Transfer',0,'',NULL,'N;'),('DoInvDtl:Update',0,'',NULL,'N;'),('DoInvDtl:UpdateInventory',0,'',NULL,'N;'),('DoInvDtl:UpdateItem',0,'',NULL,'N;'),('DoInvDtl:UpdateUOM',0,'',NULL,'N;'),('DoInvDtl:View',0,'',NULL,'N;'),('DoInvHdr',1,'',NULL,'N;'),('DoInvHdr:Admin',0,'',NULL,'N;'),('DoInvHdr:AdminCashInvoice',0,'',NULL,'N;'),('DoInvHdr:AdminInvoice',0,'',NULL,'N;'),('DoInvHdr:AdminPicking',0,'',NULL,'N;'),('DoInvHdr:AdminShipment',0,'',NULL,'N;'),('DoInvHdr:CalculateDiscAmt',0,'',NULL,'N;'),('DoInvHdr:CalculateDiscLocalAmt',0,'',NULL,'N;'),('DoInvHdr:CalculateNetAmt',0,'',NULL,'N;'),('DoInvHdr:CalculateNetLocalAmt',0,'',NULL,'N;'),('DoInvHdr:CalculateTaxAmt',0,'',NULL,'N;'),('DoInvHdr:CalculateTaxLocalAmt',0,'',NULL,'N;'),('DoInvHdr:Confirm',0,'',NULL,'N;'),('DoInvHdr:Create',0,'',NULL,'N;'),('DoInvHdr:CreateCashInvoice',0,'',NULL,'N;'),('DoInvHdr:CreateInvoice',0,'',NULL,'N;'),('DoInvHdr:Delete',0,'',NULL,'N;'),('DoInvHdr:DeleteInvoiceWIP',0,'',NULL,'N;'),('DoInvHdr:DeletePicking',0,'',NULL,'N;'),('DoInvHdr:DeleteShipment',0,'',NULL,'N;'),('DoInvHdr:Invoice',0,'',NULL,'N;'),('DoInvHdr:InvoiceFrDeliveryOrder',0,'',NULL,'N;'),('DoInvHdr:InvoiceFrSalesOrder',0,'',NULL,'N;'),('DoInvHdr:Picking',0,'',NULL,'N;'),('DoInvHdr:PrintInvoice',0,'',NULL,'N;'),('DoInvHdr:Shipment',0,'',NULL,'N;'),('DoInvHdr:Shipping',0,'',NULL,'N;'),('DoInvHdr:Transfer',0,'',NULL,'N;'),('DoInvHdr:TransferView',0,'',NULL,'N;'),('DoInvHdr:Update',0,'',NULL,'N;'),('DoInvHdr:UpdateArea',0,'',NULL,'N;'),('DoInvHdr:UpdateBranchInfo',0,'',NULL,'N;'),('DoInvHdr:UpdateCashInvoice',0,'',NULL,'N;'),('DoInvHdr:UpdateCurrency',0,'',NULL,'N;'),('DoInvHdr:UpdateCustomerInfo',0,'',NULL,'N;'),('DoInvHdr:UpdateInvoice',0,'',NULL,'N;'),('DoInvHdr:UpdateTax',0,'',NULL,'N;'),('DoInvHdr:UpdateTerm',0,'',NULL,'N;'),('DoInvHdr:View',0,'',NULL,'N;'),('DoInvHdr:ViewCashInvoice',0,'',NULL,'N;'),('DoInvHdr:ViewInvoice',0,'',NULL,'N;'),('DoInvHdr:ViewPicking',0,'',NULL,'N;'),('DoInvHdr:ViewShipment',0,'',NULL,'N;'),('DoInvHdr:Void',0,'',NULL,'N;'),('GrPiDtl',1,'',NULL,'N;'),('GrPiDtl:Admin',0,'',NULL,'N;'),('GrPiDtl:BatchDelete',0,'',NULL,'N;'),('GrPiDtl:CalculateNetAmt',0,'',NULL,'N;'),('GrPiDtl:CalculateOdrAmt',0,'',NULL,'N;'),('GrPiDtl:Create',0,'',NULL,'N;'),('GrPiDtl:Delete',0,'',NULL,'N;'),('GrPiDtl:Transfer',0,'',NULL,'N;'),('GrPiDtl:Update',0,'',NULL,'N;'),('GrPiDtl:UpdateInventory',0,'',NULL,'N;'),('GrPiDtl:UpdateItem',0,'',NULL,'N;'),('GrPiDtl:UpdateUOM',0,'',NULL,'N;'),('GrPiDtl:View',0,'',NULL,'N;'),('GrPiHdr',1,'',NULL,'N;'),('GrPiHdr:Admin',0,'',NULL,'N;'),('GrPiHdr:AdminCashInvoice',0,'',NULL,'N;'),('GrPiHdr:AdminInvoice',0,'',NULL,'N;'),('GrPiHdr:Confirm',0,'',NULL,'N;'),('GrPiHdr:Create',0,'',NULL,'N;'),('GrPiHdr:CreateCashInvoice',0,'',NULL,'N;'),('GrPiHdr:CreateInvoice',0,'',NULL,'N;'),('GrPiHdr:Delete',0,'',NULL,'N;'),('GrPiHdr:Invoice',0,'',NULL,'N;'),('GrPiHdr:InvoiceFrGoodReceived',0,'',NULL,'N;'),('GrPiHdr:InvoiceFrPrchOdr',0,'',NULL,'N;'),('GrPiHdr:PrintInvoice',0,'',NULL,'N;'),('GrPiHdr:Transfer',0,'',NULL,'N;'),('GrPiHdr:TransferView',0,'',NULL,'N;'),('GrPiHdr:Update',0,'',NULL,'N;'),('GrPiHdr:UpdateArea',0,'',NULL,'N;'),('GrPiHdr:UpdateBranchInfo',0,'',NULL,'N;'),('GrPiHdr:UpdateCashInvoice',0,'',NULL,'N;'),('GrPiHdr:UpdateCurrency',0,'',NULL,'N;'),('GrPiHdr:UpdateInvoice',0,'',NULL,'N;'),('GrPiHdr:UpdateLocation',0,'',NULL,'N;'),('GrPiHdr:UpdateTax',0,'',NULL,'N;'),('GrPiHdr:UpdateTerm',0,'',NULL,'N;'),('GrPiHdr:UpdateVendorInfo',0,'',NULL,'N;'),('GrPiHdr:View',0,'',NULL,'N;'),('GrPiHdr:ViewCashInvoice',0,'',NULL,'N;'),('GrPiHdr:ViewInvoice',0,'',NULL,'N;'),('Guest',2,'Default role for users that are not logged in. RBAC default role.','return Yii::app()->getUser()->getIsGuest();','N;'),('Integration',1,'',NULL,'N;'),('Integration:SetExportedStatus',0,'',NULL,'N;'),('IntgNewspageRB',1,'',NULL,'N;'),('IntgNewspageRB:ExportSalesOrder',0,'',NULL,'N;'),('IntgNewspageRB:ExportSalesReturn',0,'',NULL,'N;'),('IntgNewspageRB:ImportConfirmedItems',0,'',NULL,'N;'),('IntgNewspageRB:PostOpenItemsToLucia',0,'',NULL,'N;'),('IntgUBSAccounting',1,'',NULL,'N;'),('IntgUBSAccounting:PostToDaccount',0,'',NULL,'N;'),('IntgUBSStockControl',1,'',NULL,'N;'),('IntgUBSStockControl:ExportInvoice',0,'',NULL,'N;'),('IntgUBSStockControl:ImportCustomers',0,'',NULL,'N;'),('IntgUBSStockControl:ImportItems',0,'',NULL,'N;'),('IntgUBSStockControl:ImportVendors',0,'',NULL,'N;'),('IntgUBSStockControl:TestUpload',0,'',NULL,'N;'),('Inventory',1,'',NULL,'N;'),('Inventory:Create',0,'',NULL,'N;'),('Inventory:Delete',0,'',NULL,'N;'),('Inventory:OpeningQuantity',0,'',NULL,'N;'),('Inventory:TestImage',0,'',NULL,'N;'),('Inventory:Update',0,'',NULL,'N;'),('Inventory:UpdateInventory',0,'',NULL,'N;'),('Inventory:UpdateItem',0,'',NULL,'N;'),('Item',1,'',NULL,'N;'),('Item:Admin',0,'',NULL,'N;'),('Item:BatchDelete',0,'',NULL,'N;'),('Item:Create',0,'',NULL,'N;'),('Item:Delete',0,'',NULL,'N;'),('Item:LoadImage',0,'',NULL,'N;'),('Item:Update',0,'',NULL,'N;'),('Item:View',0,'',NULL,'N;'),('ItemCost',1,'',NULL,'N;'),('ItemCost:Admin',0,'',NULL,'N;'),('ItemCost:BatchDelete',0,'',NULL,'N;'),('ItemCost:Create',0,'',NULL,'N;'),('ItemCost:Delete',0,'',NULL,'N;'),('ItemCost:Update',0,'',NULL,'N;'),('ItemCost:View',0,'',NULL,'N;'),('ItemDivision',1,'',NULL,'N;'),('ItemDivision:Admin',0,'',NULL,'N;'),('ItemDivision:Assign',0,'',NULL,'N;'),('ItemDivision:BatchDelete',0,'',NULL,'N;'),('ItemDivision:Create',0,'',NULL,'N;'),('ItemDivision:Delete',0,'',NULL,'N;'),('ItemDivision:Index',0,'',NULL,'N;'),('ItemDivision:Update',0,'',NULL,'N;'),('ItemDivision:View',0,'',NULL,'N;'),('ItemDivision:ViewAssign',0,'',NULL,'N;'),('ItemGroup',1,'',NULL,'N;'),('ItemGroup:Admin',0,'',NULL,'N;'),('ItemGroup:BatchDelete',0,'',NULL,'N;'),('ItemGroup:Create',0,'',NULL,'N;'),('ItemGroup:Delete',0,'',NULL,'N;'),('ItemGroup:Update',0,'',NULL,'N;'),('ItemPrice',1,'',NULL,'N;'),('ItemPrice:Admin',0,'',NULL,'N;'),('ItemPrice:BatchDelete',0,'',NULL,'N;'),('ItemPrice:Create',0,'',NULL,'N;'),('ItemPrice:Delete',0,'',NULL,'N;'),('ItemPrice:Update',0,'',NULL,'N;'),('ItemPrice:View',0,'',NULL,'N;'),('ItemUOM',1,'',NULL,'N;'),('ItemUOM:Admin',0,'',NULL,'N;'),('ItemUOM:BatchDelete',0,'',NULL,'N;'),('ItemUOM:Create',0,'',NULL,'N;'),('ItemUOM:Delete',0,'',NULL,'N;'),('ItemUOM:Update',0,'',NULL,'N;'),('ItemUOM:View',0,'',NULL,'N;'),('Location',1,'',NULL,'N;'),('Location:Admin',0,'',NULL,'N;'),('Location:BatchDelete',0,'',NULL,'N;'),('Location:Create',0,'',NULL,'N;'),('Location:Delete',0,'',NULL,'N;'),('Location:Update',0,'',NULL,'N;'),('MobileProfile',1,'',NULL,'N;'),('MobileProfile:Admin',0,'',NULL,'N;'),('MobileProfile:Delete',0,'',NULL,'N;'),('MobileProfile:Update',0,'',NULL,'N;'),('MobileSync',1,'',NULL,'N;'),('MobileSync:CheckRequirement',0,'',NULL,'N;'),('MobileSync:CreateMobileProfile',0,'',NULL,'N;'),('MobileSync:DeleteMobileDownload',0,'',NULL,'N;'),('MobileSync:GetMobileDbSchema',0,'',NULL,'N;'),('MobileSync:GetMobileDownload',0,'',NULL,'N;'),('MobileSync:GetMobileUpload',0,'',NULL,'N;'),('MobileSync:GetMobileUploadv2',0,'',NULL,'N;'),('MobileSync:StartSyncAll',0,'',NULL,'N;'),('MobileSync:StartSyncAllBackground',0,'',NULL,'N;'),('MobileSync:StartSyncItem',0,'',NULL,'N;'),('MobileSync:StartSyncItemBackground',0,'',NULL,'N;'),('MobileSync:TestStartSync',0,'',NULL,'N;'),('MobileSync:TestStartSyncBackground',0,'',NULL,'N;'),('MobileSync:TestTableData',0,'',NULL,'N;'),('PrchOdrDtl',1,'',NULL,'N;'),('PrchOdrDtl:Admin',0,'',NULL,'N;'),('PrchOdrDtl:BatchDelete',0,'',NULL,'N;'),('PrchOdrDtl:CalculateNetAmt',0,'',NULL,'N;'),('PrchOdrDtl:CalculateOdrAmt',0,'',NULL,'N;'),('PrchOdrDtl:Create',0,'',NULL,'N;'),('PrchOdrDtl:Delete',0,'',NULL,'N;'),('PrchOdrDtl:Update',0,'',NULL,'N;'),('PrchOdrDtl:UpdateInventory',0,'',NULL,'N;'),('PrchOdrDtl:UpdateItem',0,'',NULL,'N;'),('PrchOdrDtl:UpdateUOM',0,'',NULL,'N;'),('PrchOdrDtl:View',0,'',NULL,'N;'),('PrchOdrHdr',1,'',NULL,'N;'),('PrchOdrHdr:Admin',0,'',NULL,'N;'),('PrchOdrHdr:AdminMyPrchOdr',0,'',NULL,'N;'),('PrchOdrHdr:Confirm',0,'',NULL,'N;'),('PrchOdrHdr:Create',0,'',NULL,'N;'),('PrchOdrHdr:Delete',0,'',NULL,'N;'),('PrchOdrHdr:Index',0,'',NULL,'N;'),('PrchOdrHdr:Update',0,'',NULL,'N;'),('PrchOdrHdr:UpdateArea',0,'',NULL,'N;'),('PrchOdrHdr:UpdateBranchInfo',0,'',NULL,'N;'),('PrchOdrHdr:UpdateCurrency',0,'',NULL,'N;'),('PrchOdrHdr:UpdateMyPrchOrder',0,'',NULL,'N;'),('PrchOdrHdr:UpdateTax',0,'',NULL,'N;'),('PrchOdrHdr:UpdateTerm',0,'',NULL,'N;'),('PrchOdrHdr:UpdateVendorInfo',0,'',NULL,'N;'),('PrchOdrHdr:View',0,'',NULL,'N;'),('PriceGroup',1,'',NULL,'N;'),('PriceGroup:Admin',0,'',NULL,'N;'),('PriceGroup:AssignCustomer',0,'',NULL,'N;'),('PriceGroup:BatchDelete',0,'',NULL,'N;'),('PriceGroup:Create',0,'',NULL,'N;'),('PriceGroup:Delete',0,'',NULL,'N;'),('PriceGroup:Update',0,'',NULL,'N;'),('PriceGroup:View',0,'',NULL,'N;'),('PriceGroup:ViewAssignCustomer',0,'',NULL,'N;'),('PromotionDtl',1,'',NULL,'N;'),('PromotionDtl:Admin',0,'',NULL,'N;'),('PromotionDtl:BatchDelete',0,'',NULL,'N;'),('PromotionDtl:CalculateDiscAmt',0,'',NULL,'N;'),('PromotionDtl:Create',0,'',NULL,'N;'),('PromotionDtl:Delete',0,'',NULL,'N;'),('PromotionDtl:Update',0,'',NULL,'N;'),('PromotionDtl:UpdateItem',0,'',NULL,'N;'),('PromotionDtl:UpdateUOM',0,'',NULL,'N;'),('PromotionHdr',1,'',NULL,'N;'),('PromotionHdr:Admin',0,'',NULL,'N;'),('PromotionHdr:BatchDelete',0,'',NULL,'N;'),('PromotionHdr:Create',0,'',NULL,'N;'),('PromotionHdr:Delete',0,'',NULL,'N;'),('PromotionHdr:Index',0,'',NULL,'N;'),('PromotionHdr:Update',0,'',NULL,'N;'),('RBAC Manager',2,'Manages Auth Items and Role Assignments. RBAM required role.',NULL,'N;'),('Report',1,'',NULL,'N;'),('Report:ListCustomerReport',0,'',NULL,'N;'),('Report:PrintAgingReport',0,'',NULL,'N;'),('Report:PrintAreaSalesReport',0,'',NULL,'N;'),('Report:PrintCashInvoice',0,'',NULL,'N;'),('Report:PrintCashInvoiceListing',0,'',NULL,'N;'),('Report:PrintCreditInvoiceListing',0,'',NULL,'N;'),('Report:PrintCreditNote',0,'',NULL,'N;'),('Report:PrintCreditNoteListing',0,'',NULL,'N;'),('Report:PrintCustomersSalesReport',0,'',NULL,'N;'),('Report:PrintDebitNote',0,'',NULL,'N;'),('Report:PrintDebitNoteListing',0,'',NULL,'N;'),('Report:PrintDeliveryOrder',0,'',NULL,'N;'),('Report:PrintDeliveryOrderListing',0,'',NULL,'N;'),('Report:PrintDivisionSalesReport',0,'',NULL,'N;'),('Report:PrintInventoryWorksheet',0,'',NULL,'N;'),('Report:PrintPickingOrder',0,'',NULL,'N;'),('Report:PrintReturnReceipt',0,'',NULL,'N;'),('Report:PrintSalesInvoice',0,'',NULL,'N;'),('Report:PrintSalesOrder',0,'',NULL,'N;'),('Report:PrintSalesReturn',0,'',NULL,'N;'),('Report:PrintShipment',0,'',NULL,'N;'),('Report:PrintStockCard',0,'',NULL,'N;'),('Report:PrintStockCardReserved',0,'',NULL,'N;'),('Report:ViewSalesReports',0,'',NULL,'N;'),('RrCnDtl',1,'',NULL,'N;'),('RrCnDtl:Admin',0,'',NULL,'N;'),('RrCnDtl:BatchDelete',0,'',NULL,'N;'),('RrCnDtl:CalculateNetAmt',0,'',NULL,'N;'),('RrCnDtl:CalculateOdrAmt',0,'',NULL,'N;'),('RrCnDtl:Create',0,'',NULL,'N;'),('RrCnDtl:Delete',0,'',NULL,'N;'),('RrCnDtl:GetPackingInfo',0,'',NULL,'N;'),('RrCnDtl:Transfer',0,'',NULL,'N;'),('RrCnDtl:Update',0,'',NULL,'N;'),('RrCnDtl:UpdateInventory',0,'',NULL,'N;'),('RrCnDtl:UpdateItem',0,'',NULL,'N;'),('RrCnDtl:UpdateUOM',0,'',NULL,'N;'),('RrCnDtl:View',0,'',NULL,'N;'),('RrCnHdr',1,'',NULL,'N;'),('RrCnHdr:Admin',0,'',NULL,'N;'),('RrCnHdr:AdminCN',0,'',NULL,'N;'),('RrCnHdr:CalculateDiscAmt',0,'',NULL,'N;'),('RrCnHdr:CalculateDiscLocalAmt',0,'',NULL,'N;'),('RrCnHdr:CalculateNetAmt',0,'',NULL,'N;'),('RrCnHdr:CalculateNetLocalAmt',0,'',NULL,'N;'),('RrCnHdr:CalculateTaxAmt',0,'',NULL,'N;'),('RrCnHdr:CalculateTaxLocalAmt',0,'',NULL,'N;'),('RrCnHdr:CnFrReturnReceive',0,'',NULL,'N;'),('RrCnHdr:CnFrSalesReturn',0,'',NULL,'N;'),('RrCnHdr:Confirm',0,'',NULL,'N;'),('RrCnHdr:Create',0,'',NULL,'N;'),('RrCnHdr:CreateCN',0,'',NULL,'N;'),('RrCnHdr:Delete',0,'',NULL,'N;'),('RrCnHdr:DeleteCNWIP',0,'',NULL,'N;'),('RrCnHdr:GenerateCN',0,'',NULL,'N;'),('RrCnHdr:PrintCN',0,'',NULL,'N;'),('RrCnHdr:Transfer',0,'',NULL,'N;'),('RrCnHdr:TransferView',0,'',NULL,'N;'),('RrCnHdr:Update',0,'',NULL,'N;'),('RrCnHdr:UpdateArea',0,'',NULL,'N;'),('RrCnHdr:UpdateBranchInfo',0,'',NULL,'N;'),('RrCnHdr:UpdateCN',0,'',NULL,'N;'),('RrCnHdr:UpdateCurrency',0,'',NULL,'N;'),('RrCnHdr:UpdateCustomerInfo',0,'',NULL,'N;'),('RrCnHdr:UpdateTax',0,'',NULL,'N;'),('RrCnHdr:UpdateTerm',0,'',NULL,'N;'),('RrCnHdr:View',0,'',NULL,'N;'),('RrCnHdr:ViewCN',0,'',NULL,'N;'),('SalesOdrDtl',1,'',NULL,'N;'),('SalesOdrDtl:Admin',0,'',NULL,'N;'),('SalesOdrDtl:BatchDelete',0,'',NULL,'N;'),('SalesOdrDtl:CalculateNetAmt',0,'',NULL,'N;'),('SalesOdrDtl:CalculateOdrAmt',0,'',NULL,'N;'),('SalesOdrDtl:CalculateTaxAmt',0,'',NULL,'N;'),('SalesOdrDtl:Create',0,'',NULL,'N;'),('SalesOdrDtl:CreateFromPromotion',0,'',NULL,'N;'),('SalesOdrDtl:Delete',0,'',NULL,'N;'),('SalesOdrDtl:Update',0,'',NULL,'N;'),('SalesOdrDtl:UpdateInventory',0,'',NULL,'N;'),('SalesOdrDtl:UpdateItem',0,'',NULL,'N;'),('SalesOdrDtl:UpdateTax',0,'',NULL,'N;'),('SalesOdrDtl:UpdateUOM',0,'',NULL,'N;'),('SalesOdrDtl:View',0,'',NULL,'N;'),('SalesOdrHdr',1,'',NULL,'N;'),('SalesOdrHdr:Admin',0,'',NULL,'N;'),('SalesOdrHdr:AdminMySalesOdr',0,'',NULL,'N;'),('SalesOdrHdr:CalculateDiscAmt',0,'',NULL,'N;'),('SalesOdrHdr:CalculateDiscLocalAmt',0,'',NULL,'N;'),('SalesOdrHdr:CalculateNetAmt',0,'',NULL,'N;'),('SalesOdrHdr:CalculateNetLocalAmt',0,'',NULL,'N;'),('SalesOdrHdr:CalculateTaxAmt',0,'',NULL,'N;'),('SalesOdrHdr:CalculateTaxLocalAmt',0,'',NULL,'N;'),('SalesOdrHdr:Confirm',0,'',NULL,'N;'),('SalesOdrHdr:Create',0,'',NULL,'N;'),('SalesOdrHdr:Delete',0,'',NULL,'N;'),('SalesOdrHdr:Running',0,'',NULL,'N;'),('SalesOdrHdr:Update',0,'',NULL,'N;'),('SalesOdrHdr:UpdateArea',0,'',NULL,'N;'),('SalesOdrHdr:UpdateBranchInfo',0,'',NULL,'N;'),('SalesOdrHdr:UpdateCurrency',0,'',NULL,'N;'),('SalesOdrHdr:UpdateCustomerInfo',0,'',NULL,'N;'),('SalesOdrHdr:UpdateMySalesOrder',0,'',NULL,'N;'),('SalesOdrHdr:UpdateTax',0,'',NULL,'N;'),('SalesOdrHdr:UpdateTerm',0,'',NULL,'N;'),('SalesOdrHdr:View',0,'',NULL,'N;'),('SalesOdrHdr:Void',0,'',NULL,'N;'),('SalesRetDtl',1,'',NULL,'N;'),('SalesRetDtl:Admin',0,'',NULL,'N;'),('SalesRetDtl:BatchDelete',0,'',NULL,'N;'),('SalesRetDtl:CalculateNetAmt',0,'',NULL,'N;'),('SalesRetDtl:CalculateOdrAmt',0,'',NULL,'N;'),('SalesRetDtl:Create',0,'',NULL,'N;'),('SalesRetDtl:Delete',0,'',NULL,'N;'),('SalesRetDtl:Update',0,'',NULL,'N;'),('SalesRetDtl:UpdateItem',0,'',NULL,'N;'),('SalesRetDtl:UpdateUOM',0,'',NULL,'N;'),('SalesRetDtl:View',0,'',NULL,'N;'),('SalesRetHdr',1,'',NULL,'N;'),('SalesRetHdr:Admin',0,'',NULL,'N;'),('SalesRetHdr:CalculateDiscAmt',0,'',NULL,'N;'),('SalesRetHdr:CalculateDiscLocalAmt',0,'',NULL,'N;'),('SalesRetHdr:CalculateNetAmt',0,'',NULL,'N;'),('SalesRetHdr:CalculateNetLocalAmt',0,'',NULL,'N;'),('SalesRetHdr:CalculateTaxAmt',0,'',NULL,'N;'),('SalesRetHdr:CalculateTaxLocalAmt',0,'',NULL,'N;'),('SalesRetHdr:Confirm',0,'',NULL,'N;'),('SalesRetHdr:Create',0,'',NULL,'N;'),('SalesRetHdr:Update',0,'',NULL,'N;'),('SalesRetHdr:UpdateArea',0,'',NULL,'N;'),('SalesRetHdr:UpdateBranchInfo',0,'',NULL,'N;'),('SalesRetHdr:UpdateCurrency',0,'',NULL,'N;'),('SalesRetHdr:UpdateCustomerInfo',0,'',NULL,'N;'),('SalesRetHdr:UpdateTerm',0,'',NULL,'N;'),('SalesRetHdr:View',0,'',NULL,'N;'),('SalesTracking',1,'',NULL,'N;'),('SalesTracking:Track',0,'',NULL,'N;'),('SalesTracking:View',0,'',NULL,'N;'),('SalesTracking:ViewDeliveryTracking',0,'',NULL,'N;'),('Setting',1,'',NULL,'N;'),('Setting:ViewSalesSetting',0,'',NULL,'N;'),('Shelf',1,'',NULL,'N;'),('Shelf:Create',0,'',NULL,'N;'),('Shelf:Delete',0,'',NULL,'N;'),('Shelf:Update',0,'',NULL,'N;'),('ShelfAisle',1,'',NULL,'N;'),('ShelfAisle:Admin',0,'',NULL,'N;'),('ShelfAisle:Create',0,'',NULL,'N;'),('ShelfAisle:Delete',0,'',NULL,'N;'),('ShelfAisle:Update',0,'',NULL,'N;'),('ShelfBay',1,'',NULL,'N;'),('ShelfBay:Admin',0,'',NULL,'N;'),('ShelfBay:Create',0,'',NULL,'N;'),('ShelfBay:Delete',0,'',NULL,'N;'),('ShelfBay:Update',0,'',NULL,'N;'),('ShelfLevel',1,'',NULL,'N;'),('ShelfLevel:Admin',0,'',NULL,'N;'),('ShelfLevel:Create',0,'',NULL,'N;'),('ShelfLevel:Delete',0,'',NULL,'N;'),('ShelfLevel:Update',0,'',NULL,'N;'),('Site',1,'',NULL,'N;'),('Site:Captcha',0,'',NULL,'N;'),('Site:CCaptchaAction',0,'',NULL,'N;'),('Site:Contact',0,'',NULL,'N;'),('Site:CreateDefaultRole',0,'',NULL,'N;'),('Site:Error',0,'',NULL,'N;'),('Site:Index',0,'',NULL,'N;'),('Site:InventoryIndex',0,'',NULL,'N;'),('Site:Login',0,'',NULL,'N;'),('Site:Logout',0,'',NULL,'N;'),('Site:PurchaseIndex',0,'',NULL,'N;'),('Site:ReportsIndex',0,'',NULL,'N;'),('Site:SalesIndex',0,'',NULL,'N;'),('SSC Manager',2,'SSC Manager','','s:0:\"\";'),('StkAdjDtl',1,'',NULL,'N;'),('StkAdjDtl:BatchDelete',0,'',NULL,'N;'),('StkAdjDtl:CalculateAmt',0,'',NULL,'N;'),('StkAdjDtl:Create',0,'',NULL,'N;'),('StkAdjDtl:Delete',0,'',NULL,'N;'),('StkAdjDtl:Update',0,'',NULL,'N;'),('StkAdjDtl:UpdateInventory',0,'',NULL,'N;'),('StkAdjDtl:UpdateItem',0,'',NULL,'N;'),('StkAdjDtl:View',0,'',NULL,'N;'),('StkAdjHdr',1,'',NULL,'N;'),('StkAdjHdr:Admin',0,'',NULL,'N;'),('StkAdjHdr:Confirm',0,'',NULL,'N;'),('StkAdjHdr:Create',0,'',NULL,'N;'),('StkAdjHdr:Delete',0,'',NULL,'N;'),('StkAdjHdr:Transfer',0,'',NULL,'N;'),('StkAdjHdr:Update',0,'',NULL,'N;'),('StkAdjHdr:View',0,'',NULL,'N;'),('StkCountDtl',1,'',NULL,'N;'),('StkCountDtl:BatchDelete',0,'',NULL,'N;'),('StkCountDtl:Create',0,'',NULL,'N;'),('StkCountDtl:Delete',0,'',NULL,'N;'),('StkCountDtl:Update',0,'',NULL,'N;'),('StkCountDtl:UpdateInventory',0,'',NULL,'N;'),('StkCountDtl:UpdateItem',0,'',NULL,'N;'),('StkCountDtl:UpdateUOM',0,'',NULL,'N;'),('StkCountDtl:View',0,'',NULL,'N;'),('StkCountHdr',1,'',NULL,'N;'),('StkCountHdr:Admin',0,'',NULL,'N;'),('StkCountHdr:Confirm',0,'',NULL,'N;'),('StkCountHdr:Create',0,'',NULL,'N;'),('StkCountHdr:Update',0,'',NULL,'N;'),('StkCountHdr:View',0,'',NULL,'N;'),('StkIssueDtl',1,'',NULL,'N;'),('StkIssueDtl:CalculateAmt',0,'',NULL,'N;'),('StkIssueDtl:Create',0,'',NULL,'N;'),('StkIssueDtl:Delete',0,'',NULL,'N;'),('StkIssueDtl:Update',0,'',NULL,'N;'),('StkIssueDtl:UpdateInventory',0,'',NULL,'N;'),('StkIssueDtl:UpdateItem',0,'',NULL,'N;'),('StkIssueDtl:UpdateUOM',0,'',NULL,'N;'),('StkIssueDtl:View',0,'',NULL,'N;'),('StkIssueHdr',1,'',NULL,'N;'),('StkIssueHdr:Admin',0,'',NULL,'N;'),('StkIssueHdr:Confirm',0,'',NULL,'N;'),('StkIssueHdr:Create',0,'',NULL,'N;'),('StkIssueHdr:Delete',0,'',NULL,'N;'),('StkIssueHdr:Update',0,'',NULL,'N;'),('StkIssueHdr:View',0,'',NULL,'N;'),('StkTransferDtl',1,'',NULL,'N;'),('StkTransferDtl:BatchDelete',0,'',NULL,'N;'),('StkTransferDtl:CalculateAmt',0,'',NULL,'N;'),('StkTransferDtl:Create',0,'',NULL,'N;'),('StkTransferDtl:Delete',0,'',NULL,'N;'),('StkTransferDtl:Update',0,'',NULL,'N;'),('StkTransferDtl:UpdateFrInventory',0,'',NULL,'N;'),('StkTransferDtl:UpdateItem',0,'',NULL,'N;'),('StkTransferDtl:UpdateToInventory',0,'',NULL,'N;'),('StkTransferDtl:View',0,'',NULL,'N;'),('StkTransferHdr',1,'',NULL,'N;'),('StkTransferHdr:Admin',0,'',NULL,'N;'),('StkTransferHdr:Confirm',0,'',NULL,'N;'),('StkTransferHdr:Create',0,'',NULL,'N;'),('StkTransferHdr:Delete',0,'',NULL,'N;'),('StkTransferHdr:Update',0,'',NULL,'N;'),('StkTransferHdr:View',0,'',NULL,'N;'),('StockRotation',1,'',NULL,'N;'),('StockRotation:Create',0,'',NULL,'N;'),('StockRotation:Update',0,'',NULL,'N;'),('SystemSettings',1,'',NULL,'N;'),('SystemSettings:Admin',0,'',NULL,'N;'),('SystemSettings:BatchDelete',0,'',NULL,'N;'),('SystemSettings:Create',0,'',NULL,'N;'),('SystemSettings:Delete',0,'',NULL,'N;'),('SystemSettings:Update',0,'',NULL,'N;'),('TableLog',1,'',NULL,'N;'),('TableLog:CheckTableLog',0,'',NULL,'N;'),('Tax',1,'',NULL,'N;'),('Tax:Admin',0,'',NULL,'N;'),('Tax:BatchDelete',0,'',NULL,'N;'),('Tax:Create',0,'',NULL,'N;'),('Tax:Delete',0,'',NULL,'N;'),('Tax:Update',0,'',NULL,'N;'),('TaxGroup',1,'',NULL,'N;'),('TaxGroup:Admin',0,'',NULL,'N;'),('TaxGroup:BatchDelete',0,'',NULL,'N;'),('TaxGroup:Create',0,'',NULL,'N;'),('TaxGroup:Delete',0,'',NULL,'N;'),('TaxGroup:Update',0,'',NULL,'N;'),('TaxGroup:View',0,'',NULL,'N;'),('Terms',1,'',NULL,'N;'),('Terms:Admin',0,'',NULL,'N;'),('Terms:BatchDelete',0,'',NULL,'N;'),('Terms:Create',0,'',NULL,'N;'),('Terms:Delete',0,'',NULL,'N;'),('Terms:Update',0,'',NULL,'N;'),('TransferDetailsForm',1,'',NULL,'N;'),('TransferDetailsForm:UpdateCustomerInfo',0,'',NULL,'N;'),('TransferDetailsForm:UpdateVendorInfo',0,'',NULL,'N;'),('UOM',1,'',NULL,'N;'),('UOM:Admin',0,'',NULL,'N;'),('UOM:BatchDelete',0,'',NULL,'N;'),('UOM:Create',0,'',NULL,'N;'),('UOM:Delete',0,'',NULL,'N;'),('UOM:Update',0,'',NULL,'N;'),('UserDivision',1,'',NULL,'N;'),('UserDivision:Delete',0,'',NULL,'N;'),('Vendor',1,'',NULL,'N;'),('Vendor:Admin',0,'',NULL,'N;'),('Vendor:BatchDelete',0,'',NULL,'N;'),('Vendor:Create',0,'',NULL,'N;'),('Vendor:Delete',0,'',NULL,'N;'),('Vendor:LoadImage',0,'',NULL,'N;'),('Vendor:Update',0,'',NULL,'N;'),('Vendor:View',0,'',NULL,'N;'),('VendorBranch',1,'',NULL,'N;'),('VendorBranch:Admin',0,'',NULL,'N;'),('VendorBranch:BatchDelete',0,'',NULL,'N;'),('VendorBranch:Create',0,'',NULL,'N;'),('VendorBranch:Delete',0,'',NULL,'N;'),('VendorBranch:Index',0,'',NULL,'N;'),('VendorBranch:Update',0,'',NULL,'N;'),('VendorCategory',1,'',NULL,'N;'),('VendorCategory:Admin',0,'',NULL,'N;'),('VendorCategory:BatchDelete',0,'',NULL,'N;'),('VendorCategory:Create',0,'',NULL,'N;'),('VendorCategory:Delete',0,'',NULL,'N;'),('VendorCategory:Update',0,'',NULL,'N;'),('VendorContact',1,'',NULL,'N;'),('VendorContact:Admin',0,'',NULL,'N;'),('VendorContact:BatchDelete',0,'',NULL,'N;'),('VendorContact:Create',0,'',NULL,'N;'),('VendorContact:Delete',0,'',NULL,'N;'),('VendorContact:Index',0,'',NULL,'N;'),('VendorContact:Update',0,'',NULL,'N;'),('VendorDivision',1,'',NULL,'N;'),('VendorDivision:Assign',0,'',NULL,'N;'),('VendorDivision:BatchDelete',0,'',NULL,'N;'),('VendorDivision:Create',0,'',NULL,'N;'),('VendorDivision:Delete',0,'',NULL,'N;'),('VendorDivision:Update',0,'',NULL,'N;'),('VendorDivision:ViewAssign',0,'',NULL,'N;');

/*Table structure for table `authitemchild` */

DROP TABLE IF EXISTS `authitemchild`;

CREATE TABLE `authitemchild` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL,
  PRIMARY KEY (`parent`,`child`),
  KEY `child` (`child`),
  CONSTRAINT `authitemchild_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `authitemchild_ibfk_2` FOREIGN KEY (`child`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `authitemchild` */

insert  into `authitemchild`(`parent`,`child`) values ('SSC Manager','ApPaymentDtl'),('ApPaymentDtl','ApPaymentDtl:Admin'),('ApPaymentDtl','ApPaymentDtl:BatchDelete'),('ApPaymentDtl','ApPaymentDtl:CalculateKoAmt'),('ApPaymentDtl','ApPaymentDtl:Create'),('ApPaymentDtl','ApPaymentDtl:Delete'),('ApPaymentDtl','ApPaymentDtl:Transfer'),('ApPaymentDtl','ApPaymentDtl:Update'),('ApPaymentDtl','ApPaymentDtl:View'),('SSC Manager','ApPaymentHdr'),('ApPaymentHdr','ApPaymentHdr:Admin'),('ApPaymentHdr','ApPaymentHdr:Confirm'),('ApPaymentHdr','ApPaymentHdr:Create'),('ApPaymentHdr','ApPaymentHdr:Delete'),('ApPaymentHdr','ApPaymentHdr:Update'),('ApPaymentHdr','ApPaymentHdr:UpdateCurrency'),('ApPaymentHdr','ApPaymentHdr:UpdateVendorInfo'),('ApPaymentHdr','ApPaymentHdr:View'),('SSC Manager','ArDnDtl'),('ArDnDtl','ArDnDtl:Admin'),('ArDnDtl','ArDnDtl:BatchDelete'),('ArDnDtl','ArDnDtl:CalculateNetAmt'),('ArDnDtl','ArDnDtl:CalculateOdrAmt'),('ArDnDtl','ArDnDtl:Create'),('ArDnDtl','ArDnDtl:Delete'),('ArDnDtl','ArDnDtl:Update'),('ArDnDtl','ArDnDtl:UpdateInventory'),('ArDnDtl','ArDnDtl:UpdateItem'),('ArDnDtl','ArDnDtl:UpdateUOM'),('ArDnDtl','ArDnDtl:View'),('SSC Manager','ArDnHdr'),('ArDnHdr','ArDnHdr:Admin'),('ArDnHdr','ArDnHdr:CalculateDiscAmt'),('ArDnHdr','ArDnHdr:CalculateDiscLocalAmt'),('ArDnHdr','ArDnHdr:CalculateNetAmt'),('ArDnHdr','ArDnHdr:CalculateNetLocalAmt'),('ArDnHdr','ArDnHdr:CalculateTaxAmt'),('ArDnHdr','ArDnHdr:CalculateTaxLocalAmt'),('ArDnHdr','ArDnHdr:Confirm'),('ArDnHdr','ArDnHdr:Create'),('ArDnHdr','ArDnHdr:Delete'),('ArDnHdr','ArDnHdr:Update'),('ArDnHdr','ArDnHdr:UpdateArea'),('ArDnHdr','ArDnHdr:UpdateBranchInfo'),('ArDnHdr','ArDnHdr:UpdateCurrency'),('ArDnHdr','ArDnHdr:UpdateCustomerInfo'),('ArDnHdr','ArDnHdr:UpdateTax'),('ArDnHdr','ArDnHdr:UpdateTerm'),('ArDnHdr','ArDnHdr:View'),('SSC Manager','Area'),('Area','Area:Admin'),('Area','Area:BatchDelete'),('Area','Area:Create'),('Area','Area:Delete'),('Area','Area:Update'),('SSC Manager','ArPaymentDtl'),('ArPaymentDtl','ArPaymentDtl:Admin'),('ArPaymentDtl','ArPaymentDtl:BatchDelete'),('ArPaymentDtl','ArPaymentDtl:CalculateKoAmt'),('ArPaymentDtl','ArPaymentDtl:Create'),('ArPaymentDtl','ArPaymentDtl:Delete'),('ArPaymentDtl','ArPaymentDtl:Transfer'),('ArPaymentDtl','ArPaymentDtl:Update'),('ArPaymentDtl','ArPaymentDtl:View'),('SSC Manager','ArPaymentHdr'),('ArPaymentHdr','ArPaymentHdr:Admin'),('ArPaymentHdr','ArPaymentHdr:Confirm'),('ArPaymentHdr','ArPaymentHdr:Create'),('ArPaymentHdr','ArPaymentHdr:Delete'),('ArPaymentHdr','ArPaymentHdr:Update'),('ArPaymentHdr','ArPaymentHdr:UpdateCurrency'),('ArPaymentHdr','ArPaymentHdr:UpdateCustomerInfo'),('ArPaymentHdr','ArPaymentHdr:View'),('RBAC Manager','Auth Assignments Manager'),('RBAC Manager','Auth Items Manager'),('SSC Manager','AutoComplete'),('AutoComplete','AutoComplete:AutocompleteSource'),('AutoComplete','AutoComplete:FindAreaCode'),('AutoComplete','AutoComplete:FindCurrencyCode'),('AutoComplete','AutoComplete:FindCustomerCategory'),('AutoComplete','AutoComplete:FindCustomerCode'),('AutoComplete','AutoComplete:FindDivision'),('AutoComplete','AutoComplete:FindItemCode'),('AutoComplete','AutoComplete:FindItemGroup'),('AutoComplete','AutoComplete:FindLocationCode'),('AutoComplete','AutoComplete:FindPriceGroup'),('AutoComplete','AutoComplete:FindPromotionGroup'),('AutoComplete','AutoComplete:FindTermsCode'),('AutoComplete','AutoComplete:FindUOMCode'),('AutoComplete','AutoComplete:FindUser'),('AutoComplete','AutoComplete:FindVendorCategory'),('SSC Manager','Company'),('Company','Company:Admin'),('Company','Company:Create'),('Company','Company:Update'),('SSC Manager','Currency'),('Currency','Currency:Admin'),('Currency','Currency:BatchDelete'),('Currency','Currency:Create'),('Currency','Currency:Delete'),('Currency','Currency:Update'),('Currency','Currency:View'),('SSC Manager','CurrencyRate'),('CurrencyRate','CurrencyRate:BatchDelete'),('CurrencyRate','CurrencyRate:Create'),('CurrencyRate','CurrencyRate:Delete'),('CurrencyRate','CurrencyRate:Update'),('SSC Manager','Customer'),('Customer','Customer:Admin'),('Customer','Customer:BatchDelete'),('Customer','Customer:Create'),('Customer','Customer:Delete'),('Customer','Customer:Index'),('Customer','Customer:LoadImage'),('Customer','Customer:Update'),('Customer','Customer:View'),('SSC Manager','CustomerBranch'),('CustomerBranch','CustomerBranch:BatchDelete'),('CustomerBranch','CustomerBranch:Create'),('CustomerBranch','CustomerBranch:Delete'),('CustomerBranch','CustomerBranch:Update'),('CustomerBranch','CustomerBranch:View'),('SSC Manager','CustomerCategory'),('CustomerCategory','CustomerCategory:Admin'),('CustomerCategory','CustomerCategory:BatchDelete'),('CustomerCategory','CustomerCategory:Create'),('CustomerCategory','CustomerCategory:Delete'),('CustomerCategory','CustomerCategory:Update'),('SSC Manager','CustomerContact'),('CustomerContact','CustomerContact:BatchDelete'),('CustomerContact','CustomerContact:Create'),('CustomerContact','CustomerContact:Delete'),('CustomerContact','CustomerContact:Update'),('CustomerContact','CustomerContact:View'),('SSC Manager','CustomerDivision'),('CustomerDivision','CustomerDivision:Assign'),('CustomerDivision','CustomerDivision:BatchDelete'),('CustomerDivision','CustomerDivision:Create'),('CustomerDivision','CustomerDivision:Delete'),('CustomerDivision','CustomerDivision:DeletePriceGroup'),('CustomerDivision','CustomerDivision:Update'),('CustomerDivision','CustomerDivision:ViewAssign'),('SSC Manager','CustomerPriceGroup'),('CustomerPriceGroup','CustomerPriceGroup:Admin'),('CustomerPriceGroup','CustomerPriceGroup:Assign'),('CustomerPriceGroup','CustomerPriceGroup:Create'),('CustomerPriceGroup','CustomerPriceGroup:Delete'),('CustomerPriceGroup','CustomerPriceGroup:Index'),('CustomerPriceGroup','CustomerPriceGroup:Update'),('CustomerPriceGroup','CustomerPriceGroup:UpdateViewByDivision'),('CustomerPriceGroup','CustomerPriceGroup:View'),('CustomerPriceGroup','CustomerPriceGroup:ViewAssign'),('SSC Manager','CustomerPromotionGroup'),('CustomerPromotionGroup','CustomerPromotionGroup:Admin'),('CustomerPromotionGroup','CustomerPromotionGroup:Assign'),('CustomerPromotionGroup','CustomerPromotionGroup:Create'),('CustomerPromotionGroup','CustomerPromotionGroup:Delete'),('CustomerPromotionGroup','CustomerPromotionGroup:Index'),('CustomerPromotionGroup','CustomerPromotionGroup:Update'),('CustomerPromotionGroup','CustomerPromotionGroup:View'),('CustomerPromotionGroup','CustomerPromotionGroup:ViewAssign'),('SSC Manager','DebtorTrans'),('DebtorTrans','DebtorTrans:Admin'),('DebtorTrans','DebtorTrans:UpdateCustomerInfo'),('SSC Manager','Division'),('Division','Division:Admin'),('Division','Division:AssignCustomer'),('Division','Division:AssignItem'),('Division','Division:AssignLocation'),('Division','Division:AssignUser'),('Division','Division:BatchDelete'),('Division','Division:Create'),('Division','Division:DecrementLocationSequence'),('Division','Division:Delete'),('Division','Division:IncrementLocationSequence'),('Division','Division:Update'),('Division','Division:View'),('Division','Division:ViewAssignCustomer'),('Division','Division:ViewAssignItem'),('Division','Division:ViewAssignLocation'),('Division','Division:ViewAssignUser'),('SSC Manager','DocumentApprove'),('DocumentApprove','DocumentApprove:Approve'),('DocumentApprove','DocumentApprove:TagView'),('SSC Manager','DocumentNo'),('DocumentNo','DocumentNo:Admin'),('DocumentNo','DocumentNo:BatchDelete'),('DocumentNo','DocumentNo:Create'),('DocumentNo','DocumentNo:Delete'),('DocumentNo','DocumentNo:GetLatestDocNumber'),('DocumentNo','DocumentNo:Update'),('SSC Manager','DoInvDtl'),('DoInvDtl','DoInvDtl:Admin'),('DoInvDtl','DoInvDtl:BatchDelete'),('DoInvDtl','DoInvDtl:CalculateNetAmt'),('DoInvDtl','DoInvDtl:CalculateOdrAmt'),('DoInvDtl','DoInvDtl:Create'),('DoInvDtl','DoInvDtl:Delete'),('DoInvDtl','DoInvDtl:GetPackingInfo'),('DoInvDtl','DoInvDtl:Transfer'),('DoInvDtl','DoInvDtl:Update'),('DoInvDtl','DoInvDtl:UpdateInventory'),('DoInvDtl','DoInvDtl:UpdateItem'),('DoInvDtl','DoInvDtl:UpdateUOM'),('DoInvDtl','DoInvDtl:View'),('SSC Manager','DoInvHdr'),('DoInvHdr','DoInvHdr:Admin'),('DoInvHdr','DoInvHdr:AdminCashInvoice'),('DoInvHdr','DoInvHdr:AdminInvoice'),('DoInvHdr','DoInvHdr:AdminPicking'),('DoInvHdr','DoInvHdr:AdminShipment'),('DoInvHdr','DoInvHdr:CalculateDiscAmt'),('DoInvHdr','DoInvHdr:CalculateDiscLocalAmt'),('DoInvHdr','DoInvHdr:CalculateNetAmt'),('DoInvHdr','DoInvHdr:CalculateNetLocalAmt'),('DoInvHdr','DoInvHdr:CalculateTaxAmt'),('DoInvHdr','DoInvHdr:CalculateTaxLocalAmt'),('DoInvHdr','DoInvHdr:Confirm'),('DoInvHdr','DoInvHdr:Create'),('DoInvHdr','DoInvHdr:CreateCashInvoice'),('DoInvHdr','DoInvHdr:CreateInvoice'),('DoInvHdr','DoInvHdr:Delete'),('DoInvHdr','DoInvHdr:DeleteInvoiceWIP'),('DoInvHdr','DoInvHdr:DeletePicking'),('DoInvHdr','DoInvHdr:DeleteShipment'),('DoInvHdr','DoInvHdr:Invoice'),('DoInvHdr','DoInvHdr:InvoiceFrDeliveryOrder'),('DoInvHdr','DoInvHdr:InvoiceFrSalesOrder'),('DoInvHdr','DoInvHdr:Picking'),('DoInvHdr','DoInvHdr:PrintInvoice'),('DoInvHdr','DoInvHdr:Shipment'),('DoInvHdr','DoInvHdr:Shipping'),('DoInvHdr','DoInvHdr:Transfer'),('DoInvHdr','DoInvHdr:TransferView'),('DoInvHdr','DoInvHdr:Update'),('DoInvHdr','DoInvHdr:UpdateArea'),('DoInvHdr','DoInvHdr:UpdateBranchInfo'),('DoInvHdr','DoInvHdr:UpdateCashInvoice'),('DoInvHdr','DoInvHdr:UpdateCurrency'),('DoInvHdr','DoInvHdr:UpdateCustomerInfo'),('DoInvHdr','DoInvHdr:UpdateInvoice'),('DoInvHdr','DoInvHdr:UpdateTax'),('DoInvHdr','DoInvHdr:UpdateTerm'),('DoInvHdr','DoInvHdr:View'),('DoInvHdr','DoInvHdr:ViewCashInvoice'),('DoInvHdr','DoInvHdr:ViewInvoice'),('DoInvHdr','DoInvHdr:ViewPicking'),('DoInvHdr','DoInvHdr:ViewShipment'),('DoInvHdr','DoInvHdr:Void'),('SSC Manager','GrPiDtl'),('GrPiDtl','GrPiDtl:Admin'),('GrPiDtl','GrPiDtl:BatchDelete'),('GrPiDtl','GrPiDtl:CalculateNetAmt'),('GrPiDtl','GrPiDtl:CalculateOdrAmt'),('GrPiDtl','GrPiDtl:Create'),('GrPiDtl','GrPiDtl:Delete'),('GrPiDtl','GrPiDtl:Transfer'),('GrPiDtl','GrPiDtl:Update'),('GrPiDtl','GrPiDtl:UpdateInventory'),('GrPiDtl','GrPiDtl:UpdateItem'),('GrPiDtl','GrPiDtl:UpdateUOM'),('GrPiDtl','GrPiDtl:View'),('SSC Manager','GrPiHdr'),('GrPiHdr','GrPiHdr:Admin'),('GrPiHdr','GrPiHdr:AdminCashInvoice'),('GrPiHdr','GrPiHdr:AdminInvoice'),('GrPiHdr','GrPiHdr:Confirm'),('GrPiHdr','GrPiHdr:Create'),('GrPiHdr','GrPiHdr:CreateCashInvoice'),('GrPiHdr','GrPiHdr:CreateInvoice'),('GrPiHdr','GrPiHdr:Delete'),('GrPiHdr','GrPiHdr:Invoice'),('GrPiHdr','GrPiHdr:InvoiceFrGoodReceived'),('GrPiHdr','GrPiHdr:InvoiceFrPrchOdr'),('GrPiHdr','GrPiHdr:PrintInvoice'),('GrPiHdr','GrPiHdr:Transfer'),('GrPiHdr','GrPiHdr:TransferView'),('GrPiHdr','GrPiHdr:Update'),('GrPiHdr','GrPiHdr:UpdateArea'),('GrPiHdr','GrPiHdr:UpdateBranchInfo'),('GrPiHdr','GrPiHdr:UpdateCashInvoice'),('GrPiHdr','GrPiHdr:UpdateCurrency'),('GrPiHdr','GrPiHdr:UpdateInvoice'),('GrPiHdr','GrPiHdr:UpdateLocation'),('GrPiHdr','GrPiHdr:UpdateTax'),('GrPiHdr','GrPiHdr:UpdateTerm'),('GrPiHdr','GrPiHdr:UpdateVendorInfo'),('GrPiHdr','GrPiHdr:View'),('GrPiHdr','GrPiHdr:ViewCashInvoice'),('GrPiHdr','GrPiHdr:ViewInvoice'),('SSC Manager','Integration'),('Integration','Integration:SetExportedStatus'),('SSC Manager','IntgNewspageRB'),('IntgNewspageRB','IntgNewspageRB:ExportSalesOrder'),('IntgNewspageRB','IntgNewspageRB:ExportSalesReturn'),('IntgNewspageRB','IntgNewspageRB:ImportConfirmedItems'),('IntgNewspageRB','IntgNewspageRB:PostOpenItemsToLucia'),('SSC Manager','IntgUBSAccounting'),('IntgUBSAccounting','IntgUBSAccounting:PostToDaccount'),('SSC Manager','IntgUBSStockControl'),('IntgUBSStockControl','IntgUBSStockControl:ExportInvoice'),('IntgUBSStockControl','IntgUBSStockControl:ImportCustomers'),('IntgUBSStockControl','IntgUBSStockControl:ImportItems'),('IntgUBSStockControl','IntgUBSStockControl:ImportVendors'),('IntgUBSStockControl','IntgUBSStockControl:TestUpload'),('SSC Manager','Inventory'),('Inventory','Inventory:Create'),('Inventory','Inventory:Delete'),('Inventory','Inventory:OpeningQuantity'),('Inventory','Inventory:TestImage'),('Inventory','Inventory:Update'),('Inventory','Inventory:UpdateInventory'),('Inventory','Inventory:UpdateItem'),('SSC Manager','Item'),('Item','Item:Admin'),('Item','Item:BatchDelete'),('Item','Item:Create'),('Item','Item:Delete'),('Item','Item:LoadImage'),('Item','Item:Update'),('Item','Item:View'),('SSC Manager','ItemCost'),('ItemCost','ItemCost:Admin'),('ItemCost','ItemCost:BatchDelete'),('ItemCost','ItemCost:Create'),('ItemCost','ItemCost:Delete'),('ItemCost','ItemCost:Update'),('ItemCost','ItemCost:View'),('SSC Manager','ItemDivision'),('ItemDivision','ItemDivision:Admin'),('ItemDivision','ItemDivision:Assign'),('ItemDivision','ItemDivision:BatchDelete'),('ItemDivision','ItemDivision:Create'),('ItemDivision','ItemDivision:Delete'),('ItemDivision','ItemDivision:Index'),('ItemDivision','ItemDivision:Update'),('ItemDivision','ItemDivision:View'),('ItemDivision','ItemDivision:ViewAssign'),('SSC Manager','ItemGroup'),('ItemGroup','ItemGroup:Admin'),('ItemGroup','ItemGroup:BatchDelete'),('ItemGroup','ItemGroup:Create'),('ItemGroup','ItemGroup:Delete'),('ItemGroup','ItemGroup:Update'),('SSC Manager','ItemPrice'),('ItemPrice','ItemPrice:Admin'),('ItemPrice','ItemPrice:BatchDelete'),('ItemPrice','ItemPrice:Create'),('ItemPrice','ItemPrice:Delete'),('ItemPrice','ItemPrice:Update'),('ItemPrice','ItemPrice:View'),('SSC Manager','ItemUOM'),('ItemUOM','ItemUOM:Admin'),('ItemUOM','ItemUOM:BatchDelete'),('ItemUOM','ItemUOM:Create'),('ItemUOM','ItemUOM:Delete'),('ItemUOM','ItemUOM:Update'),('ItemUOM','ItemUOM:View'),('SSC Manager','Location'),('Location','Location:Admin'),('Location','Location:BatchDelete'),('Location','Location:Create'),('Location','Location:Delete'),('Location','Location:Update'),('SSC Manager','MobileProfile'),('MobileProfile','MobileProfile:Admin'),('MobileProfile','MobileProfile:Delete'),('MobileProfile','MobileProfile:Update'),('SSC Manager','MobileSync'),('MobileSync','MobileSync:CheckRequirement'),('MobileSync','MobileSync:CreateMobileProfile'),('MobileSync','MobileSync:DeleteMobileDownload'),('MobileSync','MobileSync:GetMobileDbSchema'),('MobileSync','MobileSync:GetMobileDownload'),('MobileSync','MobileSync:GetMobileUpload'),('MobileSync','MobileSync:GetMobileUploadv2'),('MobileSync','MobileSync:StartSyncAll'),('MobileSync','MobileSync:StartSyncAllBackground'),('MobileSync','MobileSync:StartSyncItem'),('MobileSync','MobileSync:StartSyncItemBackground'),('MobileSync','MobileSync:TestStartSync'),('MobileSync','MobileSync:TestStartSyncBackground'),('MobileSync','MobileSync:TestTableData'),('SSC Manager','PrchOdrDtl'),('PrchOdrDtl','PrchOdrDtl:Admin'),('PrchOdrDtl','PrchOdrDtl:BatchDelete'),('PrchOdrDtl','PrchOdrDtl:CalculateNetAmt'),('PrchOdrDtl','PrchOdrDtl:CalculateOdrAmt'),('PrchOdrDtl','PrchOdrDtl:Create'),('PrchOdrDtl','PrchOdrDtl:Delete'),('PrchOdrDtl','PrchOdrDtl:Update'),('PrchOdrDtl','PrchOdrDtl:UpdateInventory'),('PrchOdrDtl','PrchOdrDtl:UpdateItem'),('PrchOdrDtl','PrchOdrDtl:UpdateUOM'),('PrchOdrDtl','PrchOdrDtl:View'),('SSC Manager','PrchOdrHdr'),('PrchOdrHdr','PrchOdrHdr:Admin'),('PrchOdrHdr','PrchOdrHdr:AdminMyPrchOdr'),('PrchOdrHdr','PrchOdrHdr:Confirm'),('PrchOdrHdr','PrchOdrHdr:Create'),('PrchOdrHdr','PrchOdrHdr:Delete'),('PrchOdrHdr','PrchOdrHdr:Index'),('PrchOdrHdr','PrchOdrHdr:Update'),('PrchOdrHdr','PrchOdrHdr:UpdateArea'),('PrchOdrHdr','PrchOdrHdr:UpdateBranchInfo'),('PrchOdrHdr','PrchOdrHdr:UpdateCurrency'),('PrchOdrHdr','PrchOdrHdr:UpdateMyPrchOrder'),('PrchOdrHdr','PrchOdrHdr:UpdateTax'),('PrchOdrHdr','PrchOdrHdr:UpdateTerm'),('PrchOdrHdr','PrchOdrHdr:UpdateVendorInfo'),('PrchOdrHdr','PrchOdrHdr:View'),('SSC Manager','PriceGroup'),('PriceGroup','PriceGroup:Admin'),('PriceGroup','PriceGroup:AssignCustomer'),('PriceGroup','PriceGroup:BatchDelete'),('PriceGroup','PriceGroup:Create'),('PriceGroup','PriceGroup:Delete'),('PriceGroup','PriceGroup:Update'),('PriceGroup','PriceGroup:View'),('PriceGroup','PriceGroup:ViewAssignCustomer'),('SSC Manager','PromotionDtl'),('PromotionDtl','PromotionDtl:Admin'),('PromotionDtl','PromotionDtl:BatchDelete'),('PromotionDtl','PromotionDtl:CalculateDiscAmt'),('PromotionDtl','PromotionDtl:Create'),('PromotionDtl','PromotionDtl:Delete'),('PromotionDtl','PromotionDtl:Update'),('PromotionDtl','PromotionDtl:UpdateItem'),('PromotionDtl','PromotionDtl:UpdateUOM'),('SSC Manager','PromotionHdr'),('PromotionHdr','PromotionHdr:Admin'),('PromotionHdr','PromotionHdr:BatchDelete'),('PromotionHdr','PromotionHdr:Create'),('PromotionHdr','PromotionHdr:Delete'),('PromotionHdr','PromotionHdr:Index'),('PromotionHdr','PromotionHdr:Update'),('SSC Manager','Report'),('Report','Report:ListCustomerReport'),('Report','Report:PrintAgingReport'),('Report','Report:PrintAreaSalesReport'),('Report','Report:PrintCashInvoice'),('Report','Report:PrintCashInvoiceListing'),('Report','Report:PrintCreditInvoiceListing'),('Report','Report:PrintCreditNote'),('Report','Report:PrintCreditNoteListing'),('Report','Report:PrintCustomersSalesReport'),('Report','Report:PrintDebitNote'),('Report','Report:PrintDebitNoteListing'),('Report','Report:PrintDeliveryOrder'),('Report','Report:PrintDeliveryOrderListing'),('Report','Report:PrintDivisionSalesReport'),('Report','Report:PrintInventoryWorksheet'),('Report','Report:PrintPickingOrder'),('Report','Report:PrintReturnReceipt'),('Report','Report:PrintSalesInvoice'),('Report','Report:PrintSalesOrder'),('Report','Report:PrintSalesReturn'),('Report','Report:PrintShipment'),('Report','Report:PrintStockCard'),('Report','Report:PrintStockCardReserved'),('Report','Report:ViewSalesReports'),('SSC Manager','RrCnDtl'),('RrCnDtl','RrCnDtl:Admin'),('RrCnDtl','RrCnDtl:BatchDelete'),('RrCnDtl','RrCnDtl:CalculateNetAmt'),('RrCnDtl','RrCnDtl:CalculateOdrAmt'),('RrCnDtl','RrCnDtl:Create'),('RrCnDtl','RrCnDtl:Delete'),('RrCnDtl','RrCnDtl:GetPackingInfo'),('RrCnDtl','RrCnDtl:Transfer'),('RrCnDtl','RrCnDtl:Update'),('RrCnDtl','RrCnDtl:UpdateInventory'),('RrCnDtl','RrCnDtl:UpdateItem'),('RrCnDtl','RrCnDtl:UpdateUOM'),('RrCnDtl','RrCnDtl:View'),('SSC Manager','RrCnHdr'),('RrCnHdr','RrCnHdr:Admin'),('RrCnHdr','RrCnHdr:AdminCN'),('RrCnHdr','RrCnHdr:CalculateDiscAmt'),('RrCnHdr','RrCnHdr:CalculateDiscLocalAmt'),('RrCnHdr','RrCnHdr:CalculateNetAmt'),('RrCnHdr','RrCnHdr:CalculateNetLocalAmt'),('RrCnHdr','RrCnHdr:CalculateTaxAmt'),('RrCnHdr','RrCnHdr:CalculateTaxLocalAmt'),('RrCnHdr','RrCnHdr:CnFrReturnReceive'),('RrCnHdr','RrCnHdr:CnFrSalesReturn'),('RrCnHdr','RrCnHdr:Confirm'),('RrCnHdr','RrCnHdr:Create'),('RrCnHdr','RrCnHdr:CreateCN'),('RrCnHdr','RrCnHdr:Delete'),('RrCnHdr','RrCnHdr:DeleteCNWIP'),('RrCnHdr','RrCnHdr:GenerateCN'),('RrCnHdr','RrCnHdr:PrintCN'),('RrCnHdr','RrCnHdr:Transfer'),('RrCnHdr','RrCnHdr:TransferView'),('RrCnHdr','RrCnHdr:Update'),('RrCnHdr','RrCnHdr:UpdateArea'),('RrCnHdr','RrCnHdr:UpdateBranchInfo'),('RrCnHdr','RrCnHdr:UpdateCN'),('RrCnHdr','RrCnHdr:UpdateCurrency'),('RrCnHdr','RrCnHdr:UpdateCustomerInfo'),('RrCnHdr','RrCnHdr:UpdateTax'),('RrCnHdr','RrCnHdr:UpdateTerm'),('RrCnHdr','RrCnHdr:View'),('RrCnHdr','RrCnHdr:ViewCN'),('SSC Manager','SalesOdrDtl'),('SalesOdrDtl','SalesOdrDtl:Admin'),('SalesOdrDtl','SalesOdrDtl:BatchDelete'),('SalesOdrDtl','SalesOdrDtl:CalculateNetAmt'),('SalesOdrDtl','SalesOdrDtl:CalculateOdrAmt'),('SalesOdrDtl','SalesOdrDtl:CalculateTaxAmt'),('SalesOdrDtl','SalesOdrDtl:Create'),('SalesOdrDtl','SalesOdrDtl:CreateFromPromotion'),('SalesOdrDtl','SalesOdrDtl:Delete'),('SalesOdrDtl','SalesOdrDtl:Update'),('SalesOdrDtl','SalesOdrDtl:UpdateInventory'),('SalesOdrDtl','SalesOdrDtl:UpdateItem'),('SalesOdrDtl','SalesOdrDtl:UpdateTax'),('SalesOdrDtl','SalesOdrDtl:UpdateUOM'),('SalesOdrDtl','SalesOdrDtl:View'),('SSC Manager','SalesOdrHdr'),('SalesOdrHdr','SalesOdrHdr:Admin'),('SalesOdrHdr','SalesOdrHdr:AdminMySalesOdr'),('SalesOdrHdr','SalesOdrHdr:CalculateDiscAmt'),('SalesOdrHdr','SalesOdrHdr:CalculateDiscLocalAmt'),('SalesOdrHdr','SalesOdrHdr:CalculateNetAmt'),('SalesOdrHdr','SalesOdrHdr:CalculateNetLocalAmt'),('SalesOdrHdr','SalesOdrHdr:CalculateTaxAmt'),('SalesOdrHdr','SalesOdrHdr:CalculateTaxLocalAmt'),('SalesOdrHdr','SalesOdrHdr:Confirm'),('SalesOdrHdr','SalesOdrHdr:Create'),('SalesOdrHdr','SalesOdrHdr:Delete'),('SalesOdrHdr','SalesOdrHdr:Running'),('SalesOdrHdr','SalesOdrHdr:Update'),('SalesOdrHdr','SalesOdrHdr:UpdateArea'),('SalesOdrHdr','SalesOdrHdr:UpdateBranchInfo'),('SalesOdrHdr','SalesOdrHdr:UpdateCurrency'),('SalesOdrHdr','SalesOdrHdr:UpdateCustomerInfo'),('SalesOdrHdr','SalesOdrHdr:UpdateMySalesOrder'),('SalesOdrHdr','SalesOdrHdr:UpdateTax'),('SalesOdrHdr','SalesOdrHdr:UpdateTerm'),('SalesOdrHdr','SalesOdrHdr:View'),('SalesOdrHdr','SalesOdrHdr:Void'),('SSC Manager','SalesRetDtl'),('SalesRetDtl','SalesRetDtl:Admin'),('SalesRetDtl','SalesRetDtl:BatchDelete'),('SalesRetDtl','SalesRetDtl:CalculateNetAmt'),('SalesRetDtl','SalesRetDtl:CalculateOdrAmt'),('SalesRetDtl','SalesRetDtl:Create'),('SalesRetDtl','SalesRetDtl:Delete'),('SalesRetDtl','SalesRetDtl:Update'),('SalesRetDtl','SalesRetDtl:UpdateItem'),('SalesRetDtl','SalesRetDtl:UpdateUOM'),('SalesRetDtl','SalesRetDtl:View'),('SSC Manager','SalesRetHdr'),('SalesRetHdr','SalesRetHdr:Admin'),('SalesRetHdr','SalesRetHdr:CalculateDiscAmt'),('SalesRetHdr','SalesRetHdr:CalculateDiscLocalAmt'),('SalesRetHdr','SalesRetHdr:CalculateNetAmt'),('SalesRetHdr','SalesRetHdr:CalculateNetLocalAmt'),('SalesRetHdr','SalesRetHdr:CalculateTaxAmt'),('SalesRetHdr','SalesRetHdr:CalculateTaxLocalAmt'),('SalesRetHdr','SalesRetHdr:Confirm'),('SalesRetHdr','SalesRetHdr:Create'),('SalesRetHdr','SalesRetHdr:Update'),('SalesRetHdr','SalesRetHdr:UpdateArea'),('SalesRetHdr','SalesRetHdr:UpdateBranchInfo'),('SalesRetHdr','SalesRetHdr:UpdateCurrency'),('SalesRetHdr','SalesRetHdr:UpdateCustomerInfo'),('SalesRetHdr','SalesRetHdr:UpdateTerm'),('SalesRetHdr','SalesRetHdr:View'),('SSC Manager','SalesTracking'),('SalesTracking','SalesTracking:Track'),('SalesTracking','SalesTracking:View'),('SalesTracking','SalesTracking:ViewDeliveryTracking'),('SSC Manager','Setting'),('Setting','Setting:ViewSalesSetting'),('SSC Manager','Shelf'),('Shelf','Shelf:Create'),('Shelf','Shelf:Delete'),('Shelf','Shelf:Update'),('SSC Manager','ShelfAisle'),('ShelfAisle','ShelfAisle:Admin'),('ShelfAisle','ShelfAisle:Create'),('ShelfAisle','ShelfAisle:Delete'),('ShelfAisle','ShelfAisle:Update'),('SSC Manager','ShelfBay'),('ShelfBay','ShelfBay:Admin'),('ShelfBay','ShelfBay:Create'),('ShelfBay','ShelfBay:Delete'),('ShelfBay','ShelfBay:Update'),('SSC Manager','ShelfLevel'),('ShelfLevel','ShelfLevel:Admin'),('ShelfLevel','ShelfLevel:Create'),('ShelfLevel','ShelfLevel:Delete'),('ShelfLevel','ShelfLevel:Update'),('SSC Manager','Site'),('Site','Site:Captcha'),('Site','Site:CCaptchaAction'),('Site','Site:Contact'),('Site','Site:CreateDefaultRole'),('Site','Site:Error'),('Site','Site:Index'),('Site','Site:InventoryIndex'),('Site','Site:Login'),('Site','Site:Logout'),('Site','Site:PurchaseIndex'),('Site','Site:ReportsIndex'),('Site','Site:SalesIndex'),('SSC Manager','StkAdjDtl'),('StkAdjDtl','StkAdjDtl:BatchDelete'),('StkAdjDtl','StkAdjDtl:CalculateAmt'),('StkAdjDtl','StkAdjDtl:Create'),('StkAdjDtl','StkAdjDtl:Delete'),('StkAdjDtl','StkAdjDtl:Update'),('StkAdjDtl','StkAdjDtl:UpdateInventory'),('StkAdjDtl','StkAdjDtl:UpdateItem'),('StkAdjDtl','StkAdjDtl:View'),('SSC Manager','StkAdjHdr'),('StkAdjHdr','StkAdjHdr:Admin'),('StkAdjHdr','StkAdjHdr:Confirm'),('StkAdjHdr','StkAdjHdr:Create'),('StkAdjHdr','StkAdjHdr:Delete'),('StkAdjHdr','StkAdjHdr:Transfer'),('StkAdjHdr','StkAdjHdr:Update'),('StkAdjHdr','StkAdjHdr:View'),('SSC Manager','StkCountDtl'),('StkCountDtl','StkCountDtl:BatchDelete'),('StkCountDtl','StkCountDtl:Create'),('StkCountDtl','StkCountDtl:Delete'),('StkCountDtl','StkCountDtl:Update'),('StkCountDtl','StkCountDtl:UpdateInventory'),('StkCountDtl','StkCountDtl:UpdateItem'),('StkCountDtl','StkCountDtl:UpdateUOM'),('StkCountDtl','StkCountDtl:View'),('SSC Manager','StkCountHdr'),('StkCountHdr','StkCountHdr:Admin'),('StkCountHdr','StkCountHdr:Confirm'),('StkCountHdr','StkCountHdr:Create'),('StkCountHdr','StkCountHdr:Update'),('StkCountHdr','StkCountHdr:View'),('SSC Manager','StkIssueDtl'),('StkIssueDtl','StkIssueDtl:CalculateAmt'),('StkIssueDtl','StkIssueDtl:Create'),('StkIssueDtl','StkIssueDtl:Delete'),('StkIssueDtl','StkIssueDtl:Update'),('StkIssueDtl','StkIssueDtl:UpdateInventory'),('StkIssueDtl','StkIssueDtl:UpdateItem'),('StkIssueDtl','StkIssueDtl:UpdateUOM'),('StkIssueDtl','StkIssueDtl:View'),('SSC Manager','StkIssueHdr'),('StkIssueHdr','StkIssueHdr:Admin'),('StkIssueHdr','StkIssueHdr:Confirm'),('StkIssueHdr','StkIssueHdr:Create'),('StkIssueHdr','StkIssueHdr:Delete'),('StkIssueHdr','StkIssueHdr:Update'),('StkIssueHdr','StkIssueHdr:View'),('SSC Manager','StkTransferDtl'),('StkTransferDtl','StkTransferDtl:BatchDelete'),('StkTransferDtl','StkTransferDtl:CalculateAmt'),('StkTransferDtl','StkTransferDtl:Create'),('StkTransferDtl','StkTransferDtl:Delete'),('StkTransferDtl','StkTransferDtl:Update'),('StkTransferDtl','StkTransferDtl:UpdateFrInventory'),('StkTransferDtl','StkTransferDtl:UpdateItem'),('StkTransferDtl','StkTransferDtl:UpdateToInventory'),('StkTransferDtl','StkTransferDtl:View'),('SSC Manager','StkTransferHdr'),('StkTransferHdr','StkTransferHdr:Admin'),('StkTransferHdr','StkTransferHdr:Confirm'),('StkTransferHdr','StkTransferHdr:Create'),('StkTransferHdr','StkTransferHdr:Delete'),('StkTransferHdr','StkTransferHdr:Update'),('StkTransferHdr','StkTransferHdr:View'),('SSC Manager','StockRotation'),('StockRotation','StockRotation:Create'),('StockRotation','StockRotation:Update'),('SSC Manager','SystemSettings'),('SystemSettings','SystemSettings:Admin'),('SystemSettings','SystemSettings:BatchDelete'),('SystemSettings','SystemSettings:Create'),('SystemSettings','SystemSettings:Delete'),('SystemSettings','SystemSettings:Update'),('SSC Manager','TableLog'),('TableLog','TableLog:CheckTableLog'),('SSC Manager','Tax'),('Tax','Tax:Admin'),('Tax','Tax:BatchDelete'),('Tax','Tax:Create'),('Tax','Tax:Delete'),('Tax','Tax:Update'),('SSC Manager','TaxGroup'),('TaxGroup','TaxGroup:Admin'),('TaxGroup','TaxGroup:BatchDelete'),('TaxGroup','TaxGroup:Create'),('TaxGroup','TaxGroup:Delete'),('TaxGroup','TaxGroup:Update'),('TaxGroup','TaxGroup:View'),('SSC Manager','Terms'),('Terms','Terms:Admin'),('Terms','Terms:BatchDelete'),('Terms','Terms:Create'),('Terms','Terms:Delete'),('Terms','Terms:Update'),('SSC Manager','TransferDetailsForm'),('TransferDetailsForm','TransferDetailsForm:UpdateCustomerInfo'),('TransferDetailsForm','TransferDetailsForm:UpdateVendorInfo'),('SSC Manager','UOM'),('UOM','UOM:Admin'),('UOM','UOM:BatchDelete'),('UOM','UOM:Create'),('UOM','UOM:Delete'),('UOM','UOM:Update'),('SSC Manager','UserDivision'),('UserDivision','UserDivision:Delete'),('SSC Manager','Vendor'),('Vendor','Vendor:Admin'),('Vendor','Vendor:BatchDelete'),('Vendor','Vendor:Create'),('Vendor','Vendor:Delete'),('Vendor','Vendor:LoadImage'),('Vendor','Vendor:Update'),('Vendor','Vendor:View'),('SSC Manager','VendorBranch'),('VendorBranch','VendorBranch:Admin'),('VendorBranch','VendorBranch:BatchDelete'),('VendorBranch','VendorBranch:Create'),('VendorBranch','VendorBranch:Delete'),('VendorBranch','VendorBranch:Index'),('VendorBranch','VendorBranch:Update'),('SSC Manager','VendorCategory'),('VendorCategory','VendorCategory:Admin'),('VendorCategory','VendorCategory:BatchDelete'),('VendorCategory','VendorCategory:Create'),('VendorCategory','VendorCategory:Delete'),('VendorCategory','VendorCategory:Update'),('SSC Manager','VendorContact'),('VendorContact','VendorContact:Admin'),('VendorContact','VendorContact:BatchDelete'),('VendorContact','VendorContact:Create'),('VendorContact','VendorContact:Delete'),('VendorContact','VendorContact:Index'),('VendorContact','VendorContact:Update'),('SSC Manager','VendorDivision'),('VendorDivision','VendorDivision:Assign'),('VendorDivision','VendorDivision:BatchDelete'),('VendorDivision','VendorDivision:Create'),('VendorDivision','VendorDivision:Delete'),('VendorDivision','VendorDivision:Update'),('VendorDivision','VendorDivision:ViewAssign');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
