Views: 90
OIM-CSVの検証
OIM-CSVで出力した電子インボイスをフォーミュラリンクベースで検証しました。
“documentType”: “https://xbrl.org/CR/2021-02-03/xbrl-csv” は、 “documentType”: “https://xbrl.org/2021/xbrl-csv”.に変更されました。
参考： https://www.xbrl.org/guidance/xbrl-csv-tutorial/#12-json-metadata .
(2022-03-12)
xBRL-GD
XBRL Granular Dataのインスタンス文書が、XMLだと76KB、CSVだと6KB、１割以下にサイズダウン。
| タクソノミ | xBRL/gl/plt/case-cen/gl-plt-2020-12-31.xsd |
| csvインスタンス | xBRL-CSV/xbrl-gl_ubl_example-metadata.json xBRL-CSV/xbrl-gl_ubl_example1.csv (6KB) |
| xBRLインスタンス | xBRL-CSV/xbrl-gl_ubl_example1.xml (76KB) |
OIM-CSV
gl_ubl_example1.csv
d1,d2,d3,cor-76,cor-79,cor-73,cen-81,cen-83,cen-84,cen-24,cen-35,cen-37,cen-38,cen-40,cen-46,cen-44,cen-50,cen-52,cen-53,cen-55,muc-4,muc-33,cor-22,cen-129,cen-131,cen-151,cen-152,cen-146,bus-143,cen-106,cen-109,cen-111,cen-112,cen-115,cen-116,cen-117,cen-118,cen-119 cG2,,,12115118,2015-01-09,380,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, cG2,eG16,,,,,30,Deb.10202.Fact.12115118,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, cG2,eG16,eG17,,,,,,NL57RABO0107307510,,,,,,,,,,,,,,,,,,,,,,,,,,,,, cG2,eG2,,,,,,,,urn:cen.eu:en16931:2017,,,,,,,,,,,,,,,,,,,,,,,,,,,, cG3,eG4,eG5,,,,,,,,Postbus7l,Velsen-Noord,1950AB,NL,,,,,,,,,,,,,,,,,,,,,,,, cG3,eG7,,,,,,,,,,,,,10202,ODIN59,,,,,,,,,,,,,,,,,,,,,, cG3,eG7,eG8,,,,,,,,,,,,,,POSTBUS367,HEEMSKERK,1960AJ,NL,,,,,,,,,,,,,,,,,, cG4,,,,,,,,,,,,,,,,,,,,iso4217:EUR,iso4217:EUR,,,,,,,,,,,,,,,, cG4,cG5,,,,,,,,,,,,,,,,,,,,,1,2,19.9,,,,,,,,,,,,, cG4,cG5,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5,eG29,,,,,,,,,,,,,,,,,,,,,,,,,9.95,,,,,,,,,, cG4,cG5,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,PATATFRITES10MM10KG,,,,,,,,, cG4,cG5.1,,,,,,,,,,,,,,,,,,,,,2,1,9.85,,,,,,,,,,,,, cG4,cG5.1,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.1,eG29,,,,,,,,,,,,,,,,,,,,,,,,,9.85,,,,,,,,,, cG4,cG5.1,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,PKAAS50PL.JONGBEL.1KG,,,,,,,,, cG4,cG5.2,,,,,,,,,,,,,,,,,,,,,3,1,8.29,,,,,,,,,,,,, cG4,cG5.2,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.2,eG29,,,,,,,,,,,,,,,,,,,,,,,,,8.29,,,,,,,,,, cG4,cG5.2,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,POTKETCHUP3LT,,,,,,,,, cG4,cG5.3,,,,,,,,,,,,,,,,,,,,,4,2,14.46,,,,,,,,,,,,, cG4,cG5.3,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.3,eG29,,,,,,,,,,,,,,,,,,,,,,,,,7.23,,,,,,,,,, cG4,cG5.3,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,FRITESSAUS3LRR,,,,,,,,, cG4,cG5.4,,,,,,,,,,,,,,,,,,,,,5,1,35,,,,,,,,,,,,, cG4,cG5.4,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.4,eG29,,,,,,,,,,,,,,,,,,,,,,,,,35,,,,,,,,,, cG4,cG5.4,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,KOFFIEBLIK3.5KGSNELF,,,,,,,,, cG4,cG5.5,,,,,,,,,,,,,,,,,,,,,6,1,35,,,,,,,,,,,,, cG4,cG5.5,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.5,eG29,,,,,,,,,,,,,,,,,,,,,,,,,35,,,,,,,,,, cG4,cG5.5,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,KOFFIE3.5KGBLIKSTAND,,,,,,,,, cG4,cG5.6,,,,,,,,,,,,,,,,,,,,,7,1,10.65,,,,,,,,,,,,, cG4,cG5.6,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.6,eG29,,,,,,,,,,,,,,,,,,,,,,,,,10.65,,,,,,,,,, cG4,cG5.6,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,SUIKERKLONT,,,,,,,,, cG4,cG5.7,,,,,,,,,,,,,,,,,,,,,8,1,1.55,,,,,,,,,,,,, cG4,cG5.7,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.7,eG29,,,,,,,,,,,,,,,,,,,,,,,,,1.55,,,,,,,,,, cG4,cG5.7,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,1KGULBLOKJES,,,,,,,,, cG4,cG5.8,,,,,,,,,,,,,,,,,,,,,9,3,14.37,,,,,,,,,,,,, cG4,cG5.8,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.8,eG29,,,,,,,,,,,,,,,,,,,,,,,,,4.79,,,,,,,,,, cG4,cG5.8,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,BLOCKNOTEA5,,,,,,,,, cG4,cG5.9,,,,,,,,,,,,,,,,,,,,,10,1,8.29,,,,,,,,,,,,, cG4,cG5.9,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.9,eG29,,,,,,,,,,,,,,,,,,,,,,,,,8.29,,,,,,,,,, cG4,cG5.9,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,CHIPSNATKLEINZAKJES,,,,,,,,, cG4,cG5.10,,,,,,,,,,,,,,,,,,,,,11,2,16.58,,,,,,,,,,,,, cG4,cG5.10,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.10,eG29,,,,,,,,,,,,,,,,,,,,,,,,,8.29,,,,,,,,,, cG4,cG5.10,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,CHIPSPAPKLEINEZAKJES,,,,,,,,, cG4,cG5.11,,,,,,,,,,,,,,,,,,,,,12,1,9.95,,,,,,,,,,,,, cG4,cG5.11,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.11,eG29,,,,,,,,,,,,,,,,,,,,,,,,,9.95,,,,,,,,,, cG4,cG5.11,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,TRKLPAKJESAPPELSAP,,,,,,,,, cG4,cG5.12,,,,,,,,,,,,,,,,,,,,,13,2,3.3,,,,,,,,,,,,, cG4,cG5.12,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.12,eG29,,,,,,,,,,,,,,,,,,,,,,,,,1.65,,,,,,,,,, cG4,cG5.12,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,PKCHOCOLADEMEL,,,,,,,,, cG4,cG5.13,,,,,,,,,,,,,,,,,,,,,14,1,10.8,,,,,,,,,,,,, cG4,cG5.13,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.21,,,,,,,,,,, cG4,cG5.13,eG29,,,,,,,,,,,,,,,,,,,,,,,,,10.8,,,,,,,,,, cG4,cG5.13,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,KRATBIER,,,,,,,,, cG4,cG5.14,,,,,,,,,,,,,,,,,,,,,15,1,3.9,,,,,,,,,,,,, cG4,cG5.14,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.14,eG29,,,,,,,,,,,,,,,,,,,,,,,,,3.9,,,,,,,,,, cG4,cG5.14,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,STATIEGELD,,,,,,,,, cG4,cG5.15,,,,,,,,,,,,,,,,,,,,,16,2,7.6,,,,,,,,,,,,, cG4,cG5.15,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.21,,,,,,,,,,, cG4,cG5.15,eG29,,,,,,,,,,,,,,,,,,,,,,,,,3.8,,,,,,,,,, cG4,cG5.15,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,BLEEK3X750ML,,,,,,,,, cG4,cG5.16,,,,,,,,,,,,,,,,,,,,,17,2,9.34,,,,,,,,,,,,, cG4,cG5.16,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.21,,,,,,,,,,, cG4,cG5.16,eG29,,,,,,,,,,,,,,,,,,,,,,,,,4.67,,,,,,,,,, cG4,cG5.16,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,WCPAPIER,,,,,,,,, cG4,cG5.17,,,,,,,,,,,,,,,,,,,,,18,1,18.63,,,,,,,,,,,,, cG4,cG5.17,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.21,,,,,,,,,,, cG4,cG5.17,eG29,,,,,,,,,,,,,,,,,,,,,,,,,18.63,,,,,,,,,, cG4,cG5.17,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,BALPENNEN50STBLAUW,,,,,,,,, cG4,cG5.18,,,,,,,,,,,,,,,,,,,,,19,6,102.12,,,,,,,,,,,,, cG4,cG5.18,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.18,eG29,,,,,,,,,,,,,,,,,,,,,,,,,17.02,,,,,,,,,, cG4,cG5.18,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,EMFRITUURVET,,,,,,,,, cG4,cG5.19,,,,,,,,,,,,,,,,,,,,,20,6,-109.98,,,,,,,,,,,,, cG4,cG5.19,cG19,,,,,,,,,,,,,,,,,,,,,,,S,0.06,,,,,,,,,,, cG4,cG5.19,eG29,,,,,,,,,,,,,,,,,,,,,,,,,18.33,,,,,,,,,, cG4,cG5.19,eG31,,,,,,,,,,,,,,,,,,,,,,,,,,FRITUURVET10KGRETOUR,,,,,,,,, cG4,eG22,,,,,,,,,,,,,,,,,,,,,,,,,,,,229.6,229.6,20.73,250.33,250.33,,,, cG4,eG23,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,183.23,10.99,S,0.06 cG4,eG23.1,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,46.37,9.74,S,0.21
メタデータ定義ファイル
xbrl-gl_ubl_example1-metadata.json
{
"documentInfo": {
"documentType": "https://xbrl.org/CR/2021-02-03/xbrl-csv",
"namespaces": {
"c": "http://www.xbrl.org/int/gl/cor/2020-12-31",
"b": "http://www.xbrl.org/int/gl/bus/2020-12-31",
"m": "http://www.xbrl.org/int/gl/muc/2020-12-31",
"e": "http://www.xbrl.org/int/gl/cen/2020-12-31",
"ns0": "http://www.xbrlglco.com",
"iso4217": "http://www.xbrl.org/2003/iso4217"
},
"taxonomy": [
"../xBRL/gl/plt/case-cen/gl-plt-2020-12-31.xsd"
]
},
"tableTemplates": {
"gl": {
"columns": {
"d1": {},
"d2": {},
"d3": {},
"cor-76": {
"dimensions": {
"concept": "c:cor-76"
}
},
"cor-79": {
"dimensions": {
"concept": "c:cor-79"
}
},
"cor-73": {
"dimensions": {
"concept": "c:cor-73"
}
},
"cen-81": {
"dimensions": {
"concept": "e:cen-81"
}
},
"cen-83": {
"dimensions": {
"concept": "e:cen-83"
}
},
"cen-84": {
"dimensions": {
"concept": "e:cen-84"
}
},
"cen-24": {
"dimensions": {
"concept": "e:cen-24"
}
},
"cen-35": {
"dimensions": {
"concept": "e:cen-35"
}
},
"cen-37": {
"dimensions": {
"concept": "e:cen-37"
}
},
"cen-38": {
"dimensions": {
"concept": "e:cen-38"
}
},
"cen-40": {
"dimensions": {
"concept": "e:cen-40"
}
},
"cen-46": {
"dimensions": {
"concept": "e:cen-46"
}
},
"cen-44": {
"dimensions": {
"concept": "e:cen-44"
}
},
"cen-50": {
"dimensions": {
"concept": "e:cen-50"
}
},
"cen-52": {
"dimensions": {
"concept": "e:cen-52"
}
},
"cen-53": {
"dimensions": {
"concept": "e:cen-53"
}
},
"cen-55": {
"dimensions": {
"concept": "e:cen-55"
}
},
"muc-4": {
"dimensions": {
"concept": "m:muc-4"
}
},
"muc-33": {
"dimensions": {
"concept": "m:muc-33"
}
},
"cor-22": {
"dimensions": {
"concept": "c:cor-22"
}
},
"cen-129": {
"dimensions": {
"concept": "e:cen-129"
}
},
"cen-131": {
"dimensions": {
"concept": "e:cen-131",
"unit": "iso4217:EUR"
}
},
"cen-151": {
"dimensions": {
"concept": "e:cen-151"
}
},
"cen-152": {
"dimensions": {
"concept": "e:cen-152"
}
},
"cen-146": {
"dimensions": {
"concept": "e:cen-146",
"unit": "iso4217:EUR"
}
},
"bus-143": {
"dimensions": {
"concept": "b:bus-143"
}
},
"cen-106": {
"dimensions": {
"concept": "e:cen-106",
"unit": "iso4217:EUR"
}
},
"cen-109": {
"dimensions": {
"concept": "e:cen-109",
"unit": "iso4217:EUR"
}
},
"cen-111": {
"dimensions": {
"concept": "e:cen-111",
"unit": "iso4217:EUR"
}
},
"cen-112": {
"dimensions": {
"concept": "e:cen-112",
"unit": "iso4217:EUR"
}
},
"cen-115": {
"dimensions": {
"concept": "e:cen-115",
"unit": "iso4217:EUR"
}
},
"cen-116": {
"dimensions": {
"concept": "e:cen-116",
"unit": "iso4217:EUR"
}
},
"cen-117": {
"dimensions": {
"concept": "e:cen-117",
"unit": "iso4217:EUR"
}
},
"cen-118": {
"dimensions": {
"concept": "e:cen-118"
}
},
"cen-119": {
"dimensions": {
"concept": "e:cen-119"
}
}
},
"dimensions": {
"c:d1": "$d1",
"c:d2": "$d2",
"c:d3": "$d3",
"period": "2007-06-01T00:00:00",
"entity": "ns0:XBRL GL Co."
}
}
},
"tables": {
"gl": {
"url": "xbrl-gl_ubl_example1.csv"
}
}
}
Arelleをコマンドラインで実行
arelleCmdLine.pyを使用して、loadFromOIMプラグインでOIM-CSVファイルを読み込む。
コマンドラインの実行オプションに -v を指定するとフォーミュラリンクベースでCSVファイルを検証できる。
–saveOIMinstanceパラメタを指定すると、saveLoadableOIMプラグインがOIM-CSVをXBRLインスタンス文書に変換する。
コマンドラインでの実行方法は、こちら。
python3 ~/Documents/GitHub/Arelle-master/arelleCmdLine.py –plugins ‘loadFromOIM|saveLoadableOIM’ -v -f xbrl-gl_ubl_example1-metadata.json –saveOIMinstance xbrl-gl_ubl_example1.xml –logFile xbrl-gl_ubl_example1.log –formulaVarSetExprResult
コマンドラインの実行オプションに -v と–formulaVarSetExprResultを指定するとログファイルに検証内容が出力される。
python3 ~/Documents/GitHub/Arelle-master/arelleCmdLine.py –plugins ‘loadFromOIM|saveLoadableOIM’ -v -f xbrl-gl_ubl_example1-metadata.json –logFile xbrl-gl_ubl_example1.log –formulaVarSetExprResult
–formulaVarSetExprResult指定時のログ
[info] Activation of plug-in Load From OIM successful, version 1.2. - loadFromOIM
[info] Activation of plug-in Save Loadable OIM successful, version 1.2. - saveLoadableOIM
[info] loaded in 1.15 secs at 2021-02-28T18:50:57 - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json
[] Formula xpath2 grammar initialized in 2.19 secs -
[formula:trace] Formula BR-CO-17
BR-CO-17
Expression: if (abs(sum( $VAT_CategoryTaxAmount )- sum( $VAT_CategoryTaxableAmount * $VAT_CategoryRate )) lt 1.0) then concat( 'BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( $VAT_CategoryTaxAmount )) else concat('BR-CO-17 = ERROR = VAT category tax amount (BT-117) ',sum ( $VAT_CategoryTaxAmount ),' != VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( $VAT_CategoryTaxableAmount * $VAT_CategoryRate ),' .')
Evaluated: if (abs(sum( [modelFact[8045, qname: e:cen-117, contextRef: c-90, unitRef: u-02, value: 10.99, xbrl-gl_ubl_example1-metadata.xbrl, line None]] )- sum( 183.23 * 0.06 )) lt 1.0) then concat( 'BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( [modelFact[8045, qname: e:cen-117, contextRef: c-90, unitRef: u-02, value: 10.99, xbrl-gl_ubl_example1-metadata.xbrl, line None]] )) else concat('BR-CO-17 = ERROR = VAT category tax amount (BT-117) ',sum ( [modelFact[8045, qname: e:cen-117, contextRef: c-90, unitRef: u-02, value: 10.99, xbrl-gl_ubl_example1-metadata.xbrl, line None]] ),' != VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( 183.23 * 0.06 ),' .')
Result: [['BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. 10.99']] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 50
[formula:trace] Formula BR-CO-17
BR-CO-17
Expression: if (abs(sum( $VAT_CategoryTaxAmount )- sum( $VAT_CategoryTaxableAmount * $VAT_CategoryRate )) lt 1.0) then concat( 'BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( $VAT_CategoryTaxAmount )) else concat('BR-CO-17 = ERROR = VAT category tax amount (BT-117) ',sum ( $VAT_CategoryTaxAmount ),' != VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( $VAT_CategoryTaxableAmount * $VAT_CategoryRate ),' .')
Evaluated: if (abs(sum( [modelFact[8061, qname: e:cen-117, contextRef: c-91, unitRef: u-02, value: 9.74, xbrl-gl_ubl_example1-metadata.xbrl, line None]] )- sum( 46.37 * 0.21 )) lt 1.0) then concat( 'BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( [modelFact[8061, qname: e:cen-117, contextRef: c-91, unitRef: u-02, value: 9.74, xbrl-gl_ubl_example1-metadata.xbrl, line None]] )) else concat('BR-CO-17 = ERROR = VAT category tax amount (BT-117) ',sum ( [modelFact[8061, qname: e:cen-117, contextRef: c-91, unitRef: u-02, value: 9.74, xbrl-gl_ubl_example1-metadata.xbrl, line None]] ),' != VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( 46.37 * 0.21 ),' .')
Result: [['BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. 9.74']] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 50
[formula:trace] Variable set BR-CO-17 evaluations: 2 x 4 - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 50
[formula:trace] Formula BR-CO-10
BR-CO-10
Expression: if (abs(sum( $invoiceLineNetAmount ) - sum( $sumOfInvoiceLineNetAmount )) lt 1.0) then concat('BR-CO-10 Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131). ',sum($invoiceLineNetAmount)) else concat('BR-CO-10 = ERROR = Sum of Invoice line net amount (BT-106) ',sum($sumOfInvoiceLineNetAmount),' != Σ Invoice line net amount (BT-131) ',sum($invoiceLineNetAmount),' .')
Evaluated: if (abs(sum( [modelFact[7197, qname: e:cen-131, contextRef: c-37, unitRef: u-02, value: 1.55, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7965, qname: e:cen-131, contextRef: c-85, unitRef: u-02, value: -109.98, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7517, qname: e:cen-131, contextRef: c-57, unitRef: u-02, value: 3.3, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7133, qname: e:cen-131, contextRef: c-33, unitRef: u-02, value: 10.65, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7453, qname: e:cen-131, contextRef: c-53, unitRef: u-02, value: 9.95, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6813, qname: e:cen-131, contextRef: c-13, unitRef: u-02, value: 9.85, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7261, qname: e:cen-131, contextRef: c-41, unitRef: u-02, value: 14.37, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6877, qname: e:cen-131, contextRef: c-17, unitRef: u-02, value: 8.29, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7645, qname: e:cen-131, contextRef: c-65, unitRef: u-02, value: 3.9, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7581, qname: e:cen-131, contextRef: c-61, unitRef: u-02, value: 10.8, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6749, qname: e:cen-131, contextRef: c-09, unitRef: u-02, value: 19.9, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7069, qname: e:cen-131, contextRef: c-29, unitRef: u-02, value: 35, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7901, qname: e:cen-131, contextRef: c-81, unitRef: u-02, value: 102.12, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7709, qname: e:cen-131, contextRef: c-69, unitRef: u-02, value: 7.6, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7389, qname: e:cen-131, contextRef: c-49, unitRef: u-02, value: 16.58, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7325, qname: e:cen-131, contextRef: c-45, unitRef: u-02, value: 8.29, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7005, qname: e:cen-131, contextRef: c-25, unitRef: u-02, value: 35, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7773, qname: e:cen-131, contextRef: c-73, unitRef: u-02, value: 9.34, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7837, qname: e:cen-131, contextRef: c-77, unitRef: u-02, value: 18.63, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6941, qname: e:cen-131, contextRef: c-21, unitRef: u-02, value: 14.46, xbrl-gl_ubl_example1-metadata.xbrl, line None]] ) - sum( [modelFact[8027, qname: e:cen-106, contextRef: c-89, unitRef: u-02, value: 229.6, xbrl-gl_ubl_example1-metadata.xbrl, line None]] )) lt 1.0) then concat('BR-CO-10 Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131). ',sum([modelFact[7197, qname: e:cen-131, contextRef: c-37, unitRef: u-02, value: 1.55, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7965, qname: e:cen-131, contextRef: c-85, unitRef: u-02, value: -109.98, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7517, qname: e:cen-131, contextRef: c-57, unitRef: u-02, value: 3.3, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7133, qname: e:cen-131, contextRef: c-33, unitRef: u-02, value: 10.65, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7453, qname: e:cen-131, contextRef: c-53, unitRef: u-02, value: 9.95, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6813, qname: e:cen-131, contextRef: c-13, unitRef: u-02, value: 9.85, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7261, qname: e:cen-131, contextRef: c-41, unitRef: u-02, value: 14.37, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6877, qname: e:cen-131, contextRef: c-17, unitRef: u-02, value: 8.29, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7645, qname: e:cen-131, contextRef: c-65, unitRef: u-02, value: 3.9, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7581, qname: e:cen-131, contextRef: c-61, unitRef: u-02, value: 10.8, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6749, qname: e:cen-131, contextRef: c-09, unitRef: u-02, value: 19.9, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7069, qname: e:cen-131, contextRef: c-29, unitRef: u-02, value: 35, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7901, qname: e:cen-131, contextRef: c-81, unitRef: u-02, value: 102.12, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7709, qname: e:cen-131, contextRef: c-69, unitRef: u-02, value: 7.6, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7389, qname: e:cen-131, contextRef: c-49, unitRef: u-02, value: 16.58, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7325, qname: e:cen-131, contextRef: c-45, unitRef: u-02, value: 8.29, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7005, qname: e:cen-131, contextRef: c-25, unitRef: u-02, value: 35, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7773, qname: e:cen-131, contextRef: c-73, unitRef: u-02, value: 9.34, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7837, qname: e:cen-131, contextRef: c-77, unitRef: u-02, value: 18.63, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6941, qname: e:cen-131, contextRef: c-21, unitRef: u-02, value: 14.46, xbrl-gl_ubl_example1-metadata.xbrl, line None]])) else concat('BR-CO-10 = ERROR = Sum of Invoice line net amount (BT-106) ',sum([modelFact[8027, qname: e:cen-106, contextRef: c-89, unitRef: u-02, value: 229.6, xbrl-gl_ubl_example1-metadata.xbrl, line None]]),' != Σ Invoice line net amount (BT-131) ',sum([modelFact[7197, qname: e:cen-131, contextRef: c-37, unitRef: u-02, value: 1.55, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7965, qname: e:cen-131, contextRef: c-85, unitRef: u-02, value: -109.98, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7517, qname: e:cen-131, contextRef: c-57, unitRef: u-02, value: 3.3, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7133, qname: e:cen-131, contextRef: c-33, unitRef: u-02, value: 10.65, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7453, qname: e:cen-131, contextRef: c-53, unitRef: u-02, value: 9.95, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6813, qname: e:cen-131, contextRef: c-13, unitRef: u-02, value: 9.85, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7261, qname: e:cen-131, contextRef: c-41, unitRef: u-02, value: 14.37, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6877, qname: e:cen-131, contextRef: c-17, unitRef: u-02, value: 8.29, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7645, qname: e:cen-131, contextRef: c-65, unitRef: u-02, value: 3.9, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7581, qname: e:cen-131, contextRef: c-61, unitRef: u-02, value: 10.8, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6749, qname: e:cen-131, contextRef: c-09, unitRef: u-02, value: 19.9, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7069, qname: e:cen-131, contextRef: c-29, unitRef: u-02, value: 35, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7901, qname: e:cen-131, contextRef: c-81, unitRef: u-02, value: 102.12, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7709, qname: e:cen-131, contextRef: c-69, unitRef: u-02, value: 7.6, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7389, qname: e:cen-131, contextRef: c-49, unitRef: u-02, value: 16.58, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7325, qname: e:cen-131, contextRef: c-45, unitRef: u-02, value: 8.29, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7005, qname: e:cen-131, contextRef: c-25, unitRef: u-02, value: 35, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7773, qname: e:cen-131, contextRef: c-73, unitRef: u-02, value: 9.34, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[7837, qname: e:cen-131, contextRef: c-77, unitRef: u-02, value: 18.63, xbrl-gl_ubl_example1-metadata.xbrl, line None], modelFact[6941, qname: e:cen-131, contextRef: c-21, unitRef: u-02, value: 14.46, xbrl-gl_ubl_example1-metadata.xbrl, line None]]),' .')
Result: [['BR-CO-10 Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131). 229.60']] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 33
[formula:trace] Variable set BR-CO-10 evaluations: 1 x 2 - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 33
[formula:trace] Variable set BR-CO-11 had no xpCtx.evaluations - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 42
[formula:trace] Variable set BR-CO-11 evaluations: 0 x 0 - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 42
[info] validated in 3.28 secs - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json
–formulaVarExpressionCode指定時のログ
[info] loaded in 1.15 secs at 2021-03-01T09:20:05 - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json
[] Formula xpath2 grammar initialized in 2.88 secs -
[formula:trace] Code select [ProgHeader(select,modelGeneralVariable[__742](('label', 'contextRef_VAT_CategoryTaxAmount'), ('select', '$VAT_CategoryTaxAmount/@contextRef'), ('bindAsSequence', 'false')))), variableRef('VAT_CategoryTaxAmount'), /[@QName(contextRef)]] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 71
[formula:trace] Code select [ProgHeader(select,modelGeneralVariable[__743](('label', 'VAT_CategoryTaxableAmount'), ('select', '//e:cen-116[@contextRef=$contextRef_VAT_CategoryTaxAmount]'), ('bindAsSequence', 'false')))), rootDescendant[QName(e:cen-116), predicate[@QName(contextRef), =[variableRef('contextRef_VAT_CategoryTaxAmount')]]]] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 72
[formula:trace] Code select [ProgHeader(select,modelGeneralVariable[__744](('label', 'VAT_CategoryRate'), ('select', '//e:cen-119[@contextRef=$contextRef_VAT_CategoryTaxAmount]'), ('bindAsSequence', 'false')))), rootDescendant[QName(e:cen-119), predicate[@QName(contextRef), =[variableRef('contextRef_VAT_CategoryTaxAmount')]]]] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 73
[formula:trace] Code test [ProgHeader(test,ModelTypedDimension[__821](('label', 'tD_1_cG4'), ('test', 'string(c:_1)="cG4"')))), string[QName(c:_1)], =['cG4']] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 112
[formula:trace] Code test [ProgHeader(test,ModelTypedDimension[__865](('label', 'tD_2_eG22'), ('test', 'string(c:_2)="eG22"')))), string[QName(c:_2)], =['eG22']] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 122
[info] validated in 4.13 secs - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json
–formulaVarExpressionResult指定時のログ
[info] Activation of plug-in Load From OIM successful, version 1.2. - loadFromOIM [info] Activation of plug-in Save Loadable OIM successful, version 1.2. - saveLoadableOIM [info] loaded in 1.16 secs at 2021-03-01T09:21:03 - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json [] Formula xpath2 grammar initialized in 2.63 secs - [formula:trace] General Variable contextRef_VAT_CategoryTaxAmount: select result [<arelle.ModelObject.ModelAttribute object at 0x10d04ceb8>] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 71 [formula:trace] General Variable VAT_CategoryTaxableAmount: select result [modelFact[8060, qname: e:cen-116, contextRef: c-91, unitRef: u-02, value: 46.37, xbrl-gl_ubl_example1-metadata.xbrl, line None]] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 72 [formula:trace] General Variable VAT_CategoryRate: select result [modelFact[8063, qname: e:cen-119, contextRef: c-91, unitRef: u-01, value: 0.21, xbrl-gl_ubl_example1-metadata.xbrl, line None]] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 73 [formula:trace] General Variable contextRef_VAT_CategoryTaxAmount: select result [<arelle.ModelObject.ModelAttribute object at 0x10d04c0a0>] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 71 [formula:trace] General Variable VAT_CategoryTaxableAmount: select result [modelFact[8044, qname: e:cen-116, contextRef: c-90, unitRef: u-02, value: 183.23, xbrl-gl_ubl_example1-metadata.xbrl, line None]] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 72 [formula:trace] General Variable VAT_CategoryRate: select result [modelFact[8047, qname: e:cen-119, contextRef: c-90, unitRef: u-01, value: 0.06, xbrl-gl_ubl_example1-metadata.xbrl, line None]] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 73 [info] validated in 4.05 secs - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json
–formulaVarExpressionSource指定時のログ
[info] Activation of plug-in Load From OIM successful, version 1.2. - loadFromOIM [info] Activation of plug-in Save Loadable OIM successful, version 1.2. - saveLoadableOIM [info] loaded in 1.18 secs at 2021-03-01T09:19:32 - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json [] Formula xpath2 grammar initialized in 3.01 secs - [formula:trace] Source select $VAT_CategoryTaxAmount/@contextRef - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 71 [formula:trace] Source select //e:cen-116[@contextRef=$contextRef_VAT_CategoryTaxAmount] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 72 [formula:trace] Source select //e:cen-119[@contextRef=$contextRef_VAT_CategoryTaxAmount] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 73 [formula:trace] Source test string(c:_1)="cG4" - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 112 [formula:trace] Source test string(c:_2)="eG22" - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 122 [info] validated in 4.06 secs - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json
–formulaVarsOrder指定時のログ
[info] Activation of plug-in Load From OIM successful, version 1.2. - loadFromOIM [info] Activation of plug-in Save Loadable OIM successful, version 1.2. - saveLoadableOIM [info] loaded in 1.24 secs at 2021-03-01T08:28:39 - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json [] Formula xpath2 grammar initialized in 2.20 secs - [formula:trace] Variable set BR-CO-10, variables order: [invoiceLineNetAmount, sumOfInvoiceLineNetAmount] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 33 [formula:trace] Variable set BR-CO-11, variables order: [documentLevelAllowanceAmount, sumOfAllowancesOnDocumentLevel] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 42 [formula:trace] Variable set BR-CO-17, variables order: [VAT_CategoryTaxAmount, contextRef_VAT_CategoryTaxAmount, VAT_CategoryTaxableAmount, VAT_CategoryRate] - ../xBRL/gl/plt/case-cen/gl-plt-2020-12-31-formula.xml 50 [formula:trace] Variable instances processing order: [instances:standard-output-instance, None] - xbrl-gl_ubl_example1-metadata.xbrl [info] validated in 3.31 secs - /Users/pontsoleil/xBRL-Alpha/xBRL-CSV/xbrl-gl_ubl_example1-metadata.json
検証画面
フォーミュラリンクベース
<?xml version="1.0"?> <!-- Generated by SAMBUICHI, Nobuyuki's shell script and edited with Visual Studio Code --> <link:linkbase xsi:schemaLocation="http://www.xbrl.org/2003/linkbase http://www.xbrl.org/2003/xbrl-linkbase-2003-12-31.xsd http://xbrl.org/2008/generic http://www.xbrl.org/2008/generic-link.xsd http://xbrl.org/2008/assertion/consistency http://www.xbrl.org/2008/consistency-assertion.xsd http://xbrl.org/2008/formula http://www.xbrl.org/2008/formula.xsd http://xbrl.org/2008/filter/tuple http://www.xbrl.org/2008/tuple-filter.xsd http://xbrl.org/2008/variable http://www.xbrl.org/2008/variable.xsd http://xbrl.org/2008/assertion/value http://www.xbrl.org/2008/value-assertion.xsd http://xbrl.org/2008/label http://www.xbrl.org/2008/generic-label.xsd http://xbrl.org/2008/reference http://www.xbrl.org/2008/generic-reference.xsd http://xbrl.org/2008/filter/dimension http://www.xbrl.org/2008/dimension-filter.xsd http://xbrl.org/2008/filter/concept http://www.xbrl.org/2008/concept-filter.xsd http://xbrl.org/2008/validation http://www.xbrl.org/2008/validation.xsd http://xbrl.org/2008/filter/relative http://www.xbrl.org/2008/relative-filter.xsd http://xbrl.org/2008/filter/general http://www.xbrl.org/2008/general-filter.xsd http://xbrl.org/2008/filter/period http://www.xbrl.org/2008/period-filter.xsd http://xbrl.org/2008/filter/match http://www.xbrl.org/2008/match-filter.xsd http://xbrl.org/2010/filter/concept-relation http://www.xbrl.org/2010/concept-relation-filter.xsd http://xbrl.org/2008/filter/segment-scenario http://www.xbrl.org/2008/segment-scenario-filter.xsd" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:e="http://www.xbrl.org/int/gl/cen/2020-12-31" xmlns:c="http://www.xbrl.org/int/gl/cor/2020-12-31" xmlns:cf="http://xbrl.org/2008/filter/concept" xmlns:df="http://xbrl.org/2008/filter/dimension" xmlns:formula="http://xbrl.org/2008/formula" xmlns:gen="http://xbrl.org/2008/generic" xmlns:variable="http://xbrl.org/2008/variable"> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2008/variable-set" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/variable.xsd#variable-set" /> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2008/variable-filter" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/variable.xsd#variable-filter" /> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2008/variable-set-filter" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/variable.xsd#variable-set-filter" /> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2008/element-reference" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/generic-reference.xsd#element-reference" /> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2008/element-label" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/generic-label.xsd#element-label" /> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2008/consistency-assertion-parameter" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/consistency-assertion.xsd#consistency-assertion-parameter" /> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2016/assertion-unsatisfied-severity" xlink:type="simple" xlink:href="http://www.xbrl.org/2016/assertion-severity.xsd#assertion-unsatisfied-severity" /> <link:arcroleRef arcroleURI="http://xbrl.org/arcrole/2008/consistency-assertion-formula" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/consistency-assertion.xsd#consistency-assertion-formula" /> <link:roleRef roleURI="http://www.xbrl.org/2008/role/reference" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/generic-reference.xsd#standard-reference" /> <link:roleRef roleURI="http://www.xbrl.org/2008/role/label" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/generic-label.xsd#standard-label" /> <link:roleRef roleURI="http://www.xbrl.org/2008/role/link" xlink:type="simple" xlink:href="http://www.xbrl.org/2008/generic-link.xsd#standard-link-role" /> <gen:link xlink:type="extended" xlink:role="http://www.xbrl.org/2008/role/link"> <!-- BR-CO-10 Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131). --> <formula:formula id="BR-CO-10" aspectModel="dimensional" implicitFiltering="true" value="if (abs(sum( $invoiceLineNetAmount ) - sum( $sumOfInvoiceLineNetAmount )) lt 1.0) then concat('BR-CO-10 Sum of Invoice line net amount (BT-106) = Σ Invoice line net amount (BT-131). ',sum($invoiceLineNetAmount)) else concat('BR-CO-10 = ERROR = Sum of Invoice line net amount (BT-106) ',sum($sumOfInvoiceLineNetAmount),' != Σ Invoice line net amount (BT-131) ',sum($invoiceLineNetAmount),' .')" source="formula:uncovered" xlink:type="resource" xlink:label="BR-CO-10"> <formula:aspects> <formula:concept> <formula:qname>c:cor-16</formula:qname> <!-- gl-cor:entryComment --> </formula:concept> </formula:aspects> </formula:formula> <!-- BR-CO-11 Sum of allowances on document level (BT-107) = Σ Document level allowance amount (BT-92). --> <formula:formula id="BR-CO-11" aspectModel="dimensional" implicitFiltering="true" value="if (abs($documentLevelAllowanceAmount - $sumOfAllowancesOnDocumentLevel) lt 1.0) then concat( 'BR-CO-11 Sum of allowances on document level (BT-107) = Σ Document level allowance amount (BT-92). ',sum($documentLevelAllowanceAmount)) else concat('BR-CO-11 = ERROR = Sum of allowances on document level (BT-107) ',sum($sumOfAllowancesOnDocumentLevel),' != Σ Document level allowance amount (BT-92) ',sum($documentLevelAllowanceAmount),' .')" source="formula:uncovered" xlink:type="resource" xlink:label="BR-CO-11"> <formula:aspects> <formula:concept> <formula:qname>c:cor-16</formula:qname> <!-- gl-cor:entryComment --> </formula:concept> </formula:aspects> </formula:formula> <!-- BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. --> <formula:formula id="BR-CO-17" aspectModel="dimensional" implicitFiltering="true" value="if (abs(sum( $VAT_CategoryTaxAmount )- sum( $VAT_CategoryTaxableAmount * $VAT_CategoryRate )) lt 1.0) then concat( 'BR-CO-17 VAT category tax amount (BT-117) = VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( $VAT_CategoryTaxAmount )) else concat('BR-CO-17 = ERROR = VAT category tax amount (BT-117) ',sum ( $VAT_CategoryTaxAmount ),' != VAT category taxable amount (BT-116) x (VAT category rate (BT-119) / 100), rounded to two decimals. ',sum( $VAT_CategoryTaxableAmount * $VAT_CategoryRate ),' .')" source="formula:uncovered" xlink:type="resource" xlink:label="BR-CO-17"> <formula:aspects> <formula:concept> <formula:qname>c:cor-16</formula:qname> <!-- gl-cor:entryComment --> </formula:concept> </formula:aspects> </formula:formula> <!-- variableArc --> <!-- BR-CO-10 --> <variable:variableArc name="invoiceLineNetAmount" order="10.01" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-10" xlink:to="invoiceLineNetAmount" /> <variable:variableArc name="sumOfInvoiceLineNetAmount" order="10.02" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-10" xlink:to="sumOfInvoiceLineNetAmount" /> <!-- BR-CO-11 --> <variable:variableArc name="documentLevelAllowanceAmount" order="10.01" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-11" xlink:to="documentLevelAllowanceAmount" /> <variable:variableArc name="sumOfAllowancesOnDocumentLevel" order="10.02" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-11" xlink:to="sumOfAllowancesOnDocumentLevel" /> <!-- BR-CO-17 --> <variable:variableArc name="VAT_CategoryTaxAmount" order="10.01" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-17" xlink:to="VAT_CategoryTaxAmount" /> <variable:variableArc name="contextRef_VAT_CategoryTaxAmount" order="10.02" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-17" xlink:to="contextRef_VAT_CategoryTaxAmount" /> <variable:variableArc name="VAT_CategoryTaxableAmount" order="10.03" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-17" xlink:to="VAT_CategoryTaxableAmount" /> <variable:variableArc name="VAT_CategoryRate" order="10.04" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-set" xlink:from="BR-CO-17" xlink:to="VAT_CategoryRate" /> <!-- generalVariable --> <!-- BR-CO-17 --> <variable:generalVariable id="contextRef_VAT_CategoryTaxAmount" bindAsSequence="false" select="$VAT_CategoryTaxAmount/@contextRef" xlink:type="resource" xlink:label="contextRef_VAT_CategoryTaxAmount" /> <variable:generalVariable id="VAT_CategoryTaxableAmount" bindAsSequence="false" select="//e:cen-116[@contextRef=$contextRef_VAT_CategoryTaxAmount]" xlink:type="resource" xlink:label="VAT_CategoryTaxableAmount" /> <variable:generalVariable id="VAT_CategoryRate" bindAsSequence="false" select="//e:cen-119[@contextRef=$contextRef_VAT_CategoryTaxAmount]" xlink:type="resource" xlink:label="VAT_CategoryRate" /> <!-- factVariable --> <!-- BR-CO-10 --> <variable:factVariable id="invoiceLineNetAmount" bindAsSequence="true" xlink:type="resource" xlink:label="invoiceLineNetAmount" /> <variable:factVariable id="sumOfInvoiceLineNetAmount" bindAsSequence="true" xlink:type="resource" xlink:label="sumOfInvoiceLineNetAmount" /> <!-- BR-CO-11 --> <variable:factVariable id="documentLevelAllowanceAmount" nils="true" bindAsSequence="true" xlink:type="resource" xlink:label="documentLevelAllowanceAmount" /> <variable:factVariable id="sumOfAllowancesOnDocumentLevel" nils="true" bindAsSequence="true" xlink:type="resource" xlink:label="sumOfAllowancesOnDocumentLevel" /> <!-- BR-CO-17 --> <variable:factVariable id="VAT_CategoryTaxAmount" nils="true" bindAsSequence="true" xlink:type="resource" xlink:label="VAT_CategoryTaxAmount" /> <!-- variableFilterArc --> <!-- BR-CO-10 --> <variable:variableFilterArc complement="false" cover="true" order="10.01" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="invoiceLineNetAmount" xlink:to="cNinvoiceLineNetAmount" /> <variable:variableFilterArc complement="false" cover="true" order="10.02" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="invoiceLineNetAmount" xlink:to="tD_1_cG4" /> <variable:variableFilterArc complement="false" cover="true" order="10.03" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="invoiceLineNetAmount" xlink:to="tD_2" /> <variable:variableFilterArc complement="false" cover="true" order="10.04" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="sumOfInvoiceLineNetAmount" xlink:to="cNsumOfInvoiceLineNetAmount" /> <variable:variableFilterArc complement="false" cover="true" order="10.05" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="sumOfInvoiceLineNetAmount" xlink:to="tD_1_cG4" /> <variable:variableFilterArc complement="false" cover="true" order="10.06" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="sumOfInvoiceLineNetAmount" xlink:to="tD_2_eG22" /> <!-- BR-CO-11 --> <variable:variableFilterArc complement="false" cover="true" order="11.01" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="documentLevelAllowanceAmount" xlink:to="cNdocumentLevelAllowanceAmount" /> <variable:variableFilterArc complement="false" cover="true" order="11.02" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="documentLevelAllowanceAmount" xlink:to="tD_1_cG4" /> <variable:variableFilterArc complement="false" cover="true" order="11.03" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="documentLevelAllowanceAmount" xlink:to="tD_2" /> <variable:variableFilterArc complement="false" cover="true" order="11.04" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="sumOfAllowancesOnDocumentLevel" xlink:to="cNsumOfAllowancesOnDocumentLevel" /> <variable:variableFilterArc complement="false" cover="true" order="11.05" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="sumOfAllowancesOnDocumentLevel" xlink:to="tD_1_cG4" /> <variable:variableFilterArc complement="false" cover="true" order="11.06" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="sumOfAllowancesOnDocumentLevel" xlink:to="tD_2_eG22" /> <!-- BR-CO-17 --> <variable:variableFilterArc complement="false" cover="true" order="17.01" xlink:type="arc" xlink:arcrole="http://xbrl.org/arcrole/2008/variable-filter" xlink:from="VAT_CategoryTaxAmount" xlink:to="cNVAT_CategoryTaxAmount" /> <!-- filter --> <!-- BR-CO-10 --> <cf:conceptName id="cNinvoiceLineNetAmount" xlink:type="resource" xlink:label="cNinvoiceLineNetAmount"> <cf:concept> <cf:qname>e:cen-131</cf:qname> </cf:concept> </cf:conceptName> <cf:conceptName id="cNsumOfInvoiceLineNetAmount" xlink:type="resource" xlink:label="cNsumOfInvoiceLineNetAmount"> <cf:concept> <cf:qname>e:cen-106</cf:qname> </cf:concept> </cf:conceptName> <df:typedDimension id="tD_1_cG4" test="string(c:_1)="cG4"" xlink:type="resource" xlink:label="tD_1_cG4"> <df:dimension> <df:qname>c:d1</df:qname> </df:dimension> </df:typedDimension> <df:typedDimension id="tD_2" xlink:type="resource" xlink:label="tD_2"> <df:dimension> <df:qname>c:d2</df:qname> </df:dimension> </df:typedDimension> <df:typedDimension id="tD_2_eG22" test="string(c:_2)="eG22"" xlink:type="resource" xlink:label="tD_2_eG22"> <df:dimension> <df:qname>c:d2</df:qname> </df:dimension> </df:typedDimension> <df:typedDimension id="tD_2_eG23" test="string(c:_2)="eG23"" xlink:type="resource" xlink:label="tD_2_eG23"> <df:dimension> <df:qname>c:d2</df:qname> </df:dimension> </df:typedDimension> <!-- BR-CO-11 --> <cf:conceptName id="cNdocumentLevelAllowanceAmount" xlink:type="resource" xlink:label="cNdocumentLevelAllowanceAmount"> <cf:concept> <cf:qname>e:cen-92</cf:qname> </cf:concept> </cf:conceptName> <cf:conceptName id="cNsumOfAllowancesOnDocumentLevel" xlink:type="resource" xlink:label="cNsumOfAllowancesOnDocumentLevel"> <cf:concept> <cf:qname>e:cen-107</cf:qname> </cf:concept> </cf:conceptName> <!-- BR-CO-17 --> <cf:conceptName id="cNVAT_CategoryTaxAmount" xlink:type="resource" xlink:label="cNVAT_CategoryTaxAmount"> <cf:concept> <cf:qname>e:cen-117</cf:qname> </cf:concept> </cf:conceptName> </gen:link> </link:linkbase>
