『需要は無いとは思いますが・・・』のクチコミ掲示板

[demio2016]

一応自己利用の為に、ちょいと作成しましたのでアップしてみます。
イオンJMBカード（JMB WAON一体型/G.Gマーク付）新しい特典のご案内ついて
https://www.aeon.co.jp/information/2023/0131_01/
こちらのボーナスマイル商品購入等によるJALマイル記録簿の定義ファイルをアップしてみます。
10,000JALを目指して夫婦でトライしてみようかなと思い、達成状況確認の為に作成しました。

以下を適当に名前を付けて、k3xファイルで保存後、ご使用下さい。
###
### WIN桐 00
###
"区分","文字列","M1370",,,"しない","許可",,,"{1:""夫"",2:""妻""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,1,1,,,,,,,,1,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000",,,,-1,,"00,00,00,",,"00000000",,,,,
"WAON種別","文字列","M1370",,,"しない","許可",,,"{1:""イオン"",2:""モバイル"",3:""JAL""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,2,2,,,,,,,,2,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000",,,,-1,,"00,00,00,",,"00000000",,,,,
"ショッピングマイル","数値","M1370",,,"しない","許可",,,"{1:""100""/""会員"",2:""200""/""非会員""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,3,3,,,,,,,,3,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000",,,,-1,,"01,01,01,",,"00000000",,,,,
"利用年","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,4,4,,,,,,,,4,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用月","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,5,5,,,,,,,,5,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用日","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,6,6,,,,,,,,6,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用金額","通貨","M2005",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,7,7,,,,,,,,7,"M2005","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,"\","01,01,01,","A","00000000",,,,,
"ボーナスポイント","数値","M2640",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,8,8,,,,,,,,8,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"JALマイル","数値","M2005",,"#条件選択(#集合番号([WAON種別],[WAON種別])≠1,#切り捨て([利用金額]÷[ショッピングマイル],-1)×2+([ボーナスポイント]÷2),1,#切り捨て([利用金額]÷[ショッピングマイル],-1)+([ボーナスポイント]÷2))","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,9,9,,,,,,,,9,"M2005","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"マイル還元率％","数値","M2640",,"#四捨五入(([JALマイル]÷[利用金額])×100,2)","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,10,10,,,,,,,,10,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"目標マイル残","数値","M2323",,"#直前値([目標マイル残],400)-#直前値([JALマイル],[JALマイル])","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,11,11,,,,,,,,11,"M2323","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"目標達成率％","数値","M2640",,"#四捨五入(100×(#直前値([JALマイル],0)+[JALマイル])÷[目標マイル残],2)","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,12,12,,,,,,,,12,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"備考","文字列","M2958",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,13,13,,,,,,,,13,"M2958","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"00,00,00,","A","00000000",,,,,

書込番号：25220219

[沼さん]

[桐]ですか・・・PC 98 で利用していました。
[日本語入力フロントプロセッサ（日本語入力FEP） [松茸] と 共に ・・・

懐かしい 追 吊られ ・・・板汚し御免なさい ！

書込番号：25220256

[demio2016]

＞沼さんさん
いえいえ、ご返信ありがとうございます。
桐V2辺りから現在まで使用を続けており、使い慣れたソフトなので、こんな感じで、ちょこちょこ使っています（笑）。

書込番号：25220303

[The 1st]

その頃はカード型データベースですか？

書込番号：25220477

[demio2016]

＞The 1stさん
データベース桐は、可変長リレーショナルデータベースであり、シーケンシャルファイル形式のものです。
カード型データベースでは、当時アスキーの固定長ファイル形式の「The CARD」というものも有りました。
現在も個人的にはそうだと思っていますが、当時桐の使い易さが秀でていた時代です（笑）。

書込番号：25220823

[The 1st]

＞demio2016さん
ありがとうございました。桐は5の時、表の複数人の編集は対応していなかった記憶がありましたが如何ですか？

書込番号：25220841

[demio2016]

＞The 1stさん
シーケンシャルファイルの為、編集は排他処理となります。
複数で編集するとファイルが破損します。

書込番号：25221068　スマートフォンサイトからの書き込み

[demio2016]

書込番号：25220219の桐定義に誤りがありました。
早速の訂正ですｍ（＿　＿）ｍ。

###
### WIN桐 00
###
"区分","文字列","M1370",,,"しない","許可",,,"{1:""夫"",2:""妻""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,1,1,,,,,,,,1,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"00,00,00,","A","00000000",,,,,
"WAON種別","文字列","M1370",,,"しない","許可",,,"{1:""イオン"",2:""モバイル"",3:""JAL""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,2,2,,,,,,,,2,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"00,00,00,","A","00000000",,,,,
"ショッピングマイル","数値","M1370",,,"しない","許可",,,"{1:""100""/""会員"",2:""200""/""非会員""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,3,3,,,,,,,,3,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"利用年","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,4,4,,,,,,,,4,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用月","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,5,5,,,,,,,,5,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用日","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,6,6,,,,,,,,6,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用金額","通貨","M2005",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,7,7,,,,,,,,7,"M2005","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,"\","01,01,01,","A","00000000",,,,,
"ボーナスポイント","数値","M2640",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,8,8,,,,,,,,8,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"JALマイル","数値","M2005",,"#条件選択(#集合番号([WAON種別],[WAON種別])≠1,#切り捨て([利用金額]÷[ショッピングマイル],-1)×2+([ボーナスポイント]÷2),1,#切り捨て([利用金額]÷[ショッピングマイル],-1)+([ボーナスポイント]÷2))","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,9,9,,,,,,,,9,"M2005","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"マイル還元率％","数値","M2640",,"#四捨五入(([JALマイル]÷[利用金額])×100,2)","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,10,10,,,,,,,,10,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"目標マイル残","数値","M2323",,"#直前値([目標マイル残],400)-[JALマイル]","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,11,11,,,,,,,,11,"M2323","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"目標達成率％","数値","M2640",,"#四捨五入(100×(400-[目標マイル残])÷400,3)","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,12,12,,,,,,,,12,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,2,,"01,01,01,","A","00000000",,,,,
"備考","文字列","M2958",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,13,13,,,,,,,,13,"M2958","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"00,00,00,","A","00000000",,,,,

書込番号：25221259

[demio2016]

再三の修正でお恥ずかしい限りです。
今度こそは大丈夫だと思います。

###
### WIN桐 00
###
"区分","文字列","M1370",,,"しない","許可",,,"{1:""夫"",2:""妻""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,1,1,,,,,,,,1,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"00,00,00,","A","00000000",,,,,
"WAON種別","文字列","M1370",,,"しない","許可",,,"{1:""イオン"",2:""モバイル"",3:""JAL""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,2,2,,,,,,,,2,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"00,00,00,","A","00000000",,,,,
"ショッピングマイル","数値","M1370",,,"しない","許可",,,"{1:""100""/""会員"",2:""200""/""非会員""}010",,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,3,3,,,,,,,,3,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"利用年","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,4,4,,,,,,,,4,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用月","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,5,5,,,,,,,,5,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用日","整数","M1370",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,6,6,,,,,,,,6,"M1370","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"02,01,01,","A","00000000",,,,,
"利用金額","通貨","M2005",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,7,7,,,,,,,,7,"M2005","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,"\","01,01,01,","A","00000000",,,,,
"ボーナスポイント","数値","M2640",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,8,8,,,,,,,,8,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"JALマイル","数値","M2005",,"#条件選択(#集合番号([WAON種別],[WAON種別])≠1,#切り捨て([利用金額]÷[ショッピングマイル],-1)×2+([ボーナスポイント]÷2),1,#切り捨て([利用金額]÷[ショッピングマイル],-1)+([ボーナスポイント]÷2))","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,9,9,,,,,,,,9,"M2005","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"マイル還元率％","数値","M2640",,"#四捨五入(([JALマイル]÷[利用金額])×100,2)","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,10,10,,,,,,,,10,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"目標マイル残","数値","M2323",,"#直前値([目標マイル残],400)-#切り捨て([利用金額]÷[ショッピングマイル],-1)-([ボーナスポイント]÷2)","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,11,11,,,,,,,,11,"M2323","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"01,01,01,","A","00000000",,,,,
"目標達成率％","数値","M2640",,"#四捨五入(100×(400-[目標マイル残])÷400,3)","しない","許可",,,,,,,,,,"許可","許可",,,"計算",,,,,,,0,,0,,12,12,,,,,,,,12,"M2640","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,2,,"01,01,01,","A","00000000",,,,,
"備考","文字列","M2958",,,"しない","許可",,,,,,,,,,"許可","許可",,,"基本",,,,,,,0,,0,,13,13,,,,,,,,13,"M2958","する",,,",,,0,00000000","00000000",,,",,,0,00000000","00000000","0,0,00000000","0,0,00000000",,-1,,"00,00,00,","A","00000000",,,,,

書込番号：25221763