Pythonを介して財務報告ファイルを作成する
Pythonベースのアプリケーション内の1.03または2.2形式のXBRLおよびOFX要求または応答ファイルを含む財務レポート形式の作成。
.NET経由のPythonの場合はAspose.Finance は機能が豊富で、拡張可能で、使いやすい財務レポートの作成と処理APIです。開発者は、XBRLインスタンスを最初から簡単に作成できるだけでなく、スキーマ参照、コンテキスト、ユニット、アイテム、脚注リンク、役割参照、および アークロールリファレンス。 APIは、コンテキストなどの各機能に関連するクラスを提供します。開発者はContextPeriod、ContextEntity、Contextを使用できます。 さらに、APIは、1.03または2.2形式のOpen Financial Exchange（OFX）形式の要求/応答の作成もサポートしています。
アイテムを追加してXBRLファイルを作成
XBRLファイルを作成し、ドキュメントにアイテムを追加するためのプロセスは、XbrlDocumentクラスインスタンスを作成することです。 SchemaRefクラス、上記の関連するコンテキストクラス、Conceptクラスなどの適切なAPIクラスを使用して、アイテムに関連する設定を準備します。最後に、Itemクラスのプロパティを定義して初期化し、saveメソッドを呼び出してXBRLファイルをディスクに作成します。
Pythonアイテムを追加してXBRLファイルを作成するコード
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| xbrlDoc = XbrlDocument() | |
| xbrlInstances = xbrlDoc.xbrl_instances | |
| xbrlInstance = xbrlInstances[xbrlInstances.add()] | |
| schemaRefs = xbrlInstance.schema_refs | |
| schemaRefs.add(os.path.join(sourceDir, "schema.xsd"), "example", "http://example.com/xbrl/taxonomy") | |
| schema = schemaRefs[0] | |
| contextPeriod = ContextPeriod(datetime(2020,1,1), datetime(2020,2,10)) | |
| contextEntity = ContextEntity("exampleIdentifierScheme", "exampleIdentifier") | |
| context = Context(contextPeriod, contextEntity) | |
| xbrlInstance.contexts.append(context) | |
| unit = Unit(UnitType.MEASURE) | |
| unit.measure_qualified_names.append(QualifiedName("USD", "iso4217", "http://www.xbrl.org/2003/iso4217")) | |
| xbrlInstance.units.append(unit) | |
| fixedAssetsConcept = schema.get_concept_by_name("fixedAssets") | |
| if fixedAssetsConcept is not None: | |
| item = Item(fixedAssetsConcept) | |
| item.context_ref = context | |
| item.unit_ref = unit | |
| item.precision = 4 | |
| item.value = "1444" | |
| xbrlInstance.facts.append(item) | |
| xbrlDoc.save(os.path.join(outputDir, "dochavingItem.xbrl")) |
OFXリクエストファイルとレスポンスファイルを作成する
OFXファイルを生成するために、APIはOfxRequestDocumentクラスとOfxResponseDocumentクラスを提供し、開発者は簡単に OFXリクエストを作成 および1.03形式と2.2形式の両方の応答ファイル。 OfxRequestDocumentプロパティを初期化するために、APIはSignonRequest、FinancialInstitution、StatementTransactionRequestクラスなどの他のクラスも提供します。同様に、OfxResponseDocumentプロパティを初期化するために、APIはSignonResponse、StatementTransactionResponse、StatementTransactionなどのサポートクラスを提供します。以下は、関連する適切なクラスを使用した両方の場合のコードスニペットです。
PythonOFXリクエストドキュメントを生成するコード
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ofxResponseDoc = OfxResponseDocument() | |
| ofxResponseDoc.signon_response_message_set_v1 = SignonResponseMessageSetV1() | |
| signonResponse = SignonResponse() | |
| ofxResponseDoc.signon_response_message_set_v1.signon_response = signonResponse | |
| signonResponse.status = Status() | |
| signonResponse.status.code = "0" | |
| signonResponse.status.severity = SeverityEnum.INFO | |
| signonResponse.status.message = "SUCCESS" | |
| signonResponse.server_date = "20200611" | |
| signonResponse.profile_update_date = "20200611" | |
| fi = FinancialInstitution() | |
| fi.organization = "aspose" | |
| fi.financial_institution_id = "1" | |
| signonResponse.financial_institution = fi | |
| signonResponse.session_cookie = "11111111111111111" | |
| ofxResponseDoc.bank_response_message_set_v1 = BankResponseMessageSetV1() | |
| stmtTransResponse = StatementTransactionResponse() | |
| ofxResponseDoc.bank_response_message_set_v1.statement_transaction_responses.append(stmtTransResponse) | |
| stmtTransResponse.transaction_unique_id = "829631324" | |
| stmtTransResponse.status = Status() | |
| stmtTransResponse.status.code = "0" | |
| stmtTransResponse.status.severity = SeverityEnum.INFO | |
| stmtTransResponse.statement_response = StatementResponse() | |
| stmtTransResponse.statement_response.currency = CurrencyEnum.USD | |
| stmtTransResponse.statement_response.bank_account_from = BankAccount() | |
| stmtTransResponse.statement_response.bank_account_from.bank_id = "1111111" | |
| stmtTransResponse.statement_response.bank_account_from.account_id = "1111111111111" | |
| stmtTransResponse.statement_response.bank_account_from.account_type = AccountEnum.CHECKING | |
| stmtTransResponse.statement_response.bank_transaction_list = BankTransactionList() | |
| stmtTransResponse.statement_response.bank_transaction_list.start_date = "20200601000000" | |
| stmtTransResponse.statement_response.bank_transaction_list.end_date = "20200611000000" | |
| transaction1 = StatementTransaction() | |
| transaction1.transaction_type = TransactionEnum.DEBIT | |
| transaction1.posted_date = "20200611000000" | |
| transaction1.transaction_amount = "-12" | |
| transaction1.financial_institution_transaction_id = "1111111111111111111111111" | |
| transaction1.name = "bbbbbbbbbbbbbbbbbbbbbbb" | |
| transaction2 = StatementTransaction() | |
| transaction2.transaction_type = TransactionEnum.CREDIT | |
| transaction2.posted_date = "20200611000000" | |
| transaction2.transaction_amount = "22222.11" | |
| transaction2.financial_institution_transaction_id = "2222222222222222222222222222" | |
| transaction2.name = "wwwwwwwwwwwwwwwwwwwwwwww" | |
| stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction1) | |
| stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction2) | |
| stmtTransResponse.statement_response.ledger_balance = LedgerBalance() | |
| stmtTransResponse.statement_response.ledger_balance.balance_amount = "+2222.42" | |
| stmtTransResponse.statement_response.ledger_balance.date_as_of = "20200611000000" | |
| stmtTransResponse.statement_response.available_balance = AvailableBalance() | |
| stmtTransResponse.statement_response.available_balance.balance_amount = "+222222.42" | |
| stmtTransResponse.statement_response.available_balance.date_as_of = "20200611000000" | |
| ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.xml"), OfxVersionEnum.V2X) | |
| ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.sgml"), OfxVersionEnum.V1X) |
PythonOFX応答ドキュメントを生成するコード
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ofxResponseDoc = OfxResponseDocument() | |
| ofxResponseDoc.signon_response_message_set_v1 = SignonResponseMessageSetV1() | |
| signonResponse = SignonResponse() | |
| ofxResponseDoc.signon_response_message_set_v1.signon_response = signonResponse | |
| signonResponse.status = Status() | |
| signonResponse.status.code = "0" | |
| signonResponse.status.severity = SeverityEnum.INFO | |
| signonResponse.status.message = "SUCCESS" | |
| signonResponse.server_date = "20200611" | |
| signonResponse.profile_update_date = "20200611" | |
| fi = FinancialInstitution() | |
| fi.organization = "aspose" | |
| fi.financial_institution_id = "1" | |
| signonResponse.financial_institution = fi | |
| signonResponse.session_cookie = "11111111111111111" | |
| ofxResponseDoc.bank_response_message_set_v1 = BankResponseMessageSetV1() | |
| stmtTransResponse = StatementTransactionResponse() | |
| ofxResponseDoc.bank_response_message_set_v1.statement_transaction_responses.append(stmtTransResponse) | |
| stmtTransResponse.transaction_unique_id = "829631324" | |
| stmtTransResponse.status = Status() | |
| stmtTransResponse.status.code = "0" | |
| stmtTransResponse.status.severity = SeverityEnum.INFO | |
| stmtTransResponse.statement_response = StatementResponse() | |
| stmtTransResponse.statement_response.currency = CurrencyEnum.USD | |
| stmtTransResponse.statement_response.bank_account_from = BankAccount() | |
| stmtTransResponse.statement_response.bank_account_from.bank_id = "1111111" | |
| stmtTransResponse.statement_response.bank_account_from.account_id = "1111111111111" | |
| stmtTransResponse.statement_response.bank_account_from.account_type = AccountEnum.CHECKING | |
| stmtTransResponse.statement_response.bank_transaction_list = BankTransactionList() | |
| stmtTransResponse.statement_response.bank_transaction_list.start_date = "20200601000000" | |
| stmtTransResponse.statement_response.bank_transaction_list.end_date = "20200611000000" | |
| transaction1 = StatementTransaction() | |
| transaction1.transaction_type = TransactionEnum.DEBIT | |
| transaction1.posted_date = "20200611000000" | |
| transaction1.transaction_amount = "-12" | |
| transaction1.financial_institution_transaction_id = "1111111111111111111111111" | |
| transaction1.name = "bbbbbbbbbbbbbbbbbbbbbbb" | |
| transaction2 = StatementTransaction() | |
| transaction2.transaction_type = TransactionEnum.CREDIT | |
| transaction2.posted_date = "20200611000000" | |
| transaction2.transaction_amount = "22222.11" | |
| transaction2.financial_institution_transaction_id = "2222222222222222222222222222" | |
| transaction2.name = "wwwwwwwwwwwwwwwwwwwwwwww" | |
| stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction1) | |
| stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction2) | |
| stmtTransResponse.statement_response.ledger_balance = LedgerBalance() | |
| stmtTransResponse.statement_response.ledger_balance.balance_amount = "+2222.42" | |
| stmtTransResponse.statement_response.ledger_balance.date_as_of = "20200611000000" | |
| stmtTransResponse.statement_response.available_balance = AvailableBalance() | |
| stmtTransResponse.statement_response.available_balance.balance_amount = "+222222.42" | |
| stmtTransResponse.statement_response.available_balance.date_as_of = "20200611000000" | |
| ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.xml"), OfxVersionEnum.V2X) | |
| ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.sgml"), OfxVersionEnum.V1X) |