Sambuichi Peofessional Engineers Office
-
XML Schema validation
Views: 87 Contents XML Schema Design for Audit Data Collection XML schema validation XML schema design patterns Chinese background GB/T 24589.2
-
ISO 21378 data types and transformation
Views: 86以下は、ISO PC 295 WG1会議（2017年5月）にて発表した資料です。修正が必要な箇所もありますが、基本方針はこれで良いと考えています。残念ながらデータ型の議論を深めることができませんでした。 ORACLE Character String Datatypes in ORACLE NUMBER Datatype in ORACLE The NUMBER datatype stores fixed and floating-point numbers. Numbers of virtually any magnitude can be stored and are guaranteed portable among different systems operating Oracle Database, up to 38 digits of precision. Numbers can be stored in a NUMBER column: Positive numbers in the range 1 x 10-130 to 9.99…9 x 10125 with up to 38 significant digits Negative numbers from -1 x 10-130 to 9.99…99 x 10125 with up to 38 significant digits Zero Positive and negative infinity (generated only by importing from an Oracle Database, Version 5) If a precision is not specified, […]
-
](https://www.sambuichi.jp/wp-content/uploads/2013/10/6a74fabe5a7d88b4db6bb9841eaaaac9-222x160.png)
XBRL GL instance viewing service[Prototype](3/3)
Views: 114Viewing XBRL GL instance by period and/or account number Three steps （１）A browser side javascript program calls PHP program at server side to process request based on period and/or account number passed with an arguments of jQuery’s ajax. （２）A PHP program generate a query based on arguments and generate <table> then returns generated page to the browser. （３）A web browser displays a result from the server.
-
](https://www.sambuichi.jp/wp-content/uploads/2013/10/16d62a82cb285a8d7b90444957bf34c9-222x160.png)
XBRL GL instance viewing service[Prototype](2/3)
Views: 115Store XBRL GL instance documents in database In order to calculate summary for period and/or account numbers, we store contents of XBRL GL instance documents. In this case, we use PostgreSQL database after processed by PHP’s XML DOM functions.
-
](https://www.sambuichi.jp/wp-content/uploads/2013/10/ca1617cc3e0cd572d73aa663a99a60e51-222x160.png)
XBRL GL Instance Viewing Service [Prototype](1/3)
Views: 162XBRL GL Instance Viewing Service These are prototype services for viewing XBRL GL instance documents generated by accounting softwares. (You can find source programs at the GitHub site..) 1. iphix sample(XBRL 2.1) http://www.sambuichi.jp/xbrlgl/index.html Original file location http://gl.iphix.net/files.htm 2. PCA (XBRL 2.0a) 2.1 View of document structure of XBRL GL instance for each entry http://www.sambuichi.jp/xbrlgl/pca.html 2.2 View of journal entry by entered slip http://www.sambuichi.jp/xbrlgl/journal_entry.html 2.3 View of summary by month and/or chart of accounts. These documents are stored in database. http://www.sambuichi.jp/xbrlgl/list.html
Got any book recommendations?
