SuiteScript 2.0で保存検索に顧客レコードの住所サブレコード

適用

製品:  NetSuite 2023.1

 

 

シナリオ

顧客の内部IDを参考して住所サブレコードに保存検索のスクリプトを実行して、住所サブレコードの全ての値を返します。

解決策

 
search.create({ 
             type: "customer", 
   filters: 
   [ 
      ["internalid","anyof","16"] // 対象顧客の内部ID 
   ], 
   columns: 
   [ 
      search.createColumn({ 
         name: "internalid", 
         join: "Address", 
         label: "Internal ID" 
      }), 
      search.createColumn({ 
         name: "address", 
         join: "Address", 
         label: "Address" 
      }), 
      search.createColumn({ 
         name: "address1", 
         join: "Address", 
         label: "Address 1" 
      }), 
      search.createColumn({ 
         name: "address2", 
         join: "Address", 
         label: "Address 2" 
      }), 
      search.createColumn({ 
         name: "address3", 
         join: "Address", 
         label: "Address 3" 
      }), 
      search.createColumn({ 
         name: "addressinternalid", 
         join: "Address", 
         label: "Address Internal ID" 
      }), 
      search.createColumn({ 
         name: "addresslabel", 
         join: "Address", 
         label: "Address Label" 
      }), 
      search.createColumn({ 
         name: "addressphone", 
         join: "Address", 
         label: "Address Phone" 
      }), 
      search.createColumn({ 
         name: "addressee", 
         join: "Address", 
         label: "Addressee" 
      }), 
      search.createColumn({ 
         name: "attention", 
         join: "Address", 
         label: "Attention" 
      }), 
      search.createColumn({ 
         name: "city