このページのスレッド一覧(全1スレッド)![]()
- 「質問の絞込み」の未返信、未解決は最新1年、解決済みは全期間のクチコミを表示しています
一応自己利用の為に、ちょいと作成しましたのでアップしてみます。
イオン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",,,,,
2点
[桐]ですか・・・PC 98 で利用していました。
[日本語入力フロントプロセッサ(日本語入力FEP) [松茸] と 共に ・・・
懐かしい 追 吊られ ・・・板汚し御免なさい !
書込番号:25220256
1点
>沼さんさん
いえいえ、ご返信ありがとうございます。
桐V2辺りから現在まで使用を続けており、使い慣れたソフトなので、こんな感じで、ちょこちょこ使っています(笑)。
書込番号:25220303
1点
>The 1stさん
データベース桐は、可変長リレーショナルデータベースであり、シーケンシャルファイル形式のものです。
カード型データベースでは、当時アスキーの固定長ファイル形式の「The CARD」というものも有りました。
現在も個人的にはそうだと思っていますが、当時桐の使い易さが秀でていた時代です(笑)。
書込番号:25220823
1点
>demio2016さん
ありがとうございました。桐は5の時、表の複数人の編集は対応していなかった記憶がありましたが如何ですか?
書込番号:25220841
0点
>The 1stさん
シーケンシャルファイルの為、編集は排他処理となります。
複数で編集するとファイルが破損します。
書込番号:25221068 スマートフォンサイトからの書き込み
1点
書込番号:25220219の桐定義に誤りがありました。
早速の訂正ですm(_ _)m。
###
### 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
0点
再三の修正でお恥ずかしい限りです。
今度こそは大丈夫だと思います。
###
### 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
1点
最初|前の6件|次の6件|最後
クチコミ掲示板検索
新着ピックアップリスト
-
【欲しいものリスト】Abc
-
【欲しいものリスト】パソコン
-
【欲しいものリスト】エアコン
-
【Myコレクション】2026良コスパゲーミングPC(AMD)
-
【Myコレクション】2026良コスパゲーミングPC(インテル)
価格.comマガジン
注目トピックス
(パソコン)
