LEADER 01667nam 2200541Ia 450 001 9910458149803321 005 20200520144314.0 010 $a1-60780-893-5 035 $a(CKB)2560000000010640 035 $a(EBL)535957 035 $a(OCoLC)645095134 035 $a(SSID)ssj0000673201 035 $a(PQKBManifestationID)11399155 035 $a(PQKBTitleCode)TC0000673201 035 $a(PQKBWorkID)10643625 035 $a(PQKB)10148430 035 $a(MiAaPQ)EBC535957 035 $a(Au-PeEL)EBL535957 035 $a(CaPaEBR)ebr10391196 035 $a(EXLCZ)992560000000010640 100 $a20100806d2010 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aJapan$b[electronic resource] $emoney & banking 205 $a2nd ed. 210 $aPetaluma, Calif. $cWorld Trade Press$dc2010 215 $a1 online resource (20 p.) 300 $aDescription based upon print version of record. 330 $aMoney is a primary need when you're on the road and has the potential to cause major stress. Get the upper hand with this informative report on currency, traveler's checks, money wiring, ATMs, banks, and credit cards in Japan. 517 3 $aJapan money & banking 517 3 $aJapan money and banking 606 $aBanks and banking$zJapan 606 $aMoney$zJapan 608 $aElectronic books. 615 0$aBanks and banking 615 0$aMoney 676 $a332.1 676 $a332.4 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910458149803321 996 $aJapan$9260276 997 $aUNINA LEADER 05040nam 2200685 a 450 001 9910456998903321 005 20200520144314.0 010 $a1-283-34958-2 010 $a9786613349583 010 $a1-84968-237-2 035 $a(CKB)2550000000036797 035 $a(EBL)950602 035 $a(OCoLC)797916717 035 $a(SSID)ssj0000524087 035 $a(PQKBManifestationID)11376345 035 $a(PQKBTitleCode)TC0000524087 035 $a(PQKBWorkID)10545544 035 $a(PQKB)10913567 035 $a(MiAaPQ)EBC950602 035 $a(CaSebORM)9781849682367 035 $a(PPN)228023009 035 $a(Au-PeEL)EBL950602 035 $a(CaPaEBR)ebr10477269 035 $a(CaONFJC)MIL334958 035 $a(EXLCZ)992550000000036797 100 $a20110707d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMastering SQL queries for SAP Business One$b[electronic resource] $eutilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business /$fGordon Du 205 $a1st edition 210 $aBirmingham, U.K. $cPackt Enterprise Pub.$d2011 215 $a1 online resource (352 p.) 300 $aIncludes index. 311 $a1-84968-236-4 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables 327 $aImportant table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 2:Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders 327 $aStep 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 3:Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement 327 $aDISTINCT-duplicated records can be removedTOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report 327 $aORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge 327 $aCase 4-D1: Balance of production for a month 330 $aUtilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook 606 $aSmall business$xManagement$xComputer programs 606 $aSQL (Computer program language) 608 $aElectronic books. 615 0$aSmall business$xManagement$xComputer programs. 615 0$aSQL (Computer program language) 676 $a005.75/85 676 $a650.0285 676 $a658.02/2 700 $aDu$b Gordon$0976641 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910456998903321 996 $aMastering SQL queries for SAP Business One$92224804 997 $aUNINA