2022
Database Script : MYSQL |
create table `IntacctDB`.`dbAccount` (`AccountID` varchar(100) NOT NULL , `AccountName` text NOT NULL , `BillingStreet` text , `BillingPostalCode` numeric(20) , `AnnualRevenue` decimal(30,2) , `CreatedDate` date , `LastModifiedDate` datetime , `NumberOfOfficeLocations` int , PRIMARY KEY (`AccountID`) ); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000001','ABC Softwares','B-405, Ginger street','411027','500000.00','2010-10-26','2010-10-26 00:00:00','5'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000002','DEF Softwares\r\n','3000 Town Center, Suite 2850, Southfield, MI','411027','100000.00','2010-10-26','2010-10-26 00:00:00','6'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000003','Alfa Softwares','Burlington, MA\r\n','411027','700000.00','2010-10-26','2010-10-26 00:00:00','2'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000004','Cognizant Technologies','566 St. Kilda Road,Melbourne','411028','500000.00','2010-11-02','2010-11-02 10:22:00','56'); insert into `dbaccount` (`AccountID`, `AccountName`, `BillingStreet`, `BillingPostalCode`, `AnnualRevenue`, `CreatedDate`, `LastModifiedDate`, `NumberOfOfficeLocations`) values('000000005','Infosys Technologies','3326 160th Avenue SE, Suite 300, Bellevue, WA','411028','700000.00','2010-11-02','2010-11-02 10:23:00','90'); |
Click on [X] icon on Start_state to delete the default control flow from Start_State to End_state.