Google Apps Script試行錯誤 Blog: 1月 2020

2020年1月31日金曜日

LanguageApp.translateで英文中の単語ごとに翻訳したい

Practice makes the impossible possible

を

練習　作ります　その　不可能な　可能

のように単語ごとに翻訳したい。

半角スペースをsplitしてfor文で作ってもいいけれど
LanguageApp.translateを実行する回数が多くなる。

半角スペースではなく\nで区切ってやると一気に翻訳できた。

コード.gs

function myFunction() {
  var str = "Practice\nmakes\nthe\nimpossible\npossible";
  var translate = LanguageApp.translate(str, "en", "ja");
  Logger.log(translate);
}

実行結果

練習
作ります
その
不可能な
可能

テーブル内でクリックしたセルの位置を知りたい

テーブル内の何行目、何列目のセルをクリックしたか知りたい

これで取得できそう

ELEMENT.parentNode.rowIndex
ELEMENT.cellIndex

コード.gs

function doGet() {
  return HtmlService.createHtmlOutputFromFile("index");
}

意訳

この機能がやること
指定したHTMLファイルを表示する

index.html

<!DOCTYPE html>
<html>

<head>
<style>
table {
  border-collapse: collapse;
}

th, td {
  border: solid 1px lightgray;
  width: 120px;
}
</style>
</head>

<body>
<div id="mainDiv"></div>

<script>
function elem(id) {
  return document.getElementById(id);
}

function create(tag) {
  return document.createElement(tag);
}

createElements()

function createElements() {
  var table = create('table');
  var tbody = create('tbody');
  var cols = 3;
  var rows = 4;

  for(var i = 0; i < rows; i++) {
    var tr = create('tr');
    for(var j = 0; j < cols; j++) {
      var td = create('td');
      td.textContent = i + "-" + j;
      td.onclick = function(e) { 
        var col = this.cellIndex;
        var row = this.parentNode.rowIndex;
        alert([row, col]);
      }
      
      tr.appendChild(td);
      tbody.appendChild(tr);
    }

    var main_div = elem('mainDiv');
    table.appendChild(tbody);
    main_div.appendChild(table);
  }
}

</script>
</body>
</html>

参考

HTMLTableRowElement.rowIndex
https://developer.mozilla.org/ja/docs/Web/API/HTMLTableRowElement/rowIndex

HTMLTableCellElement
https://developer.mozilla.org/en-US/docs/Web/API/HTMLTableCellElement

Data Studio（データポータル）で使用できる関数

計算フィールドの数式内で使用できる関数のリスト

ここに書かれていた
https://support.google.com/datastudio/table/6379764

SalesforceのAPIでアクセストークンを取得したい（ユーザ名,パスワード）

アクセストークンを取得する方法はいくつかあるらしい
OAuth によるアプリケーションの認証

今回はユーザ名とパスワードを使ってアクセストークンの取得を試してみました
OAuth 2.0 ユーザ名パスワードフロー

接続アプリケーションを作成する方法はこちら
SalesforceのAPIを利用するために接続アプリケーションを作成したい

公式ページにも書かれていますが必要な場合にのみ使用しましょう

警告この OAuth 認証フローでは、ユーザのログイン情報がやりとりされます。この認証フローは、必要な場合にのみ使用してください。更新トークンは発行されません。

重要 Salesforce コミュニティでは、OAuth 2.0 のユーザ名パスワード認証フローはサポートされていません。

しかし、必要な場合がどんな場合かまでは書かれていないので、そこは自己判断になる。

コード.gs

var client_id = "コンシューマ鍵";
var client_secret = "コンシューマの秘密";
var username = "ユーザ名";
var password = "パスワード";

function authorization() {
  var url = "https://login.salesforce.com/services/oauth2/token";
  var options = {
      "method" : "POST",
      "payload" : {
      "grant_type": "password",
      "client_id": client_id, 
      "client_secret": client_secret, 
      "username": username, 
      "password": password
    }
  }
  var response = UrlFetchApp.fetch(url, options);
  Logger.log(response);
}

関連記事

必要な場合がわからないので、別の方法で試した方法も書き残しておきます。
接続アプリケーションを作成したい
接続アプリケーションを作成したい（Lightning）

参考

OAuth によるアプリケーションの認証
https://help.salesforce.com/articleView?id=remoteaccess_authenticate.htm&type=5

OAuth 2.0 ユーザ名パスワードフロー
https://help.salesforce.com/articleView?id=remoteaccess_oauth_username_password_flow.htm&type=5

ユーザ名パスワード OAuth 認証フローについて
https://developer.salesforce.com/docs/atlas.ja-jp.api_rest.meta/api_rest/intro_understanding_username_password_oauth_flow.htm

Salesforce APIで接続アプリケーションのIP制限の緩和を設定したい

IP制限を設定できる項目があったので備忘録として書き残しておきます。

① 歯車アイコンから「設定」を選択します
② アプリケーションを選択します
③ 接続アプリケーションを管理するを選択します
④ 対象のアプリケーションの「編集」をクリックします

IP制限の緩和のセレクトボックスで選択できました。

参考

接続アプリケーションの IP 制限の緩和および IP の継続的な適用
https://help.salesforce.com/articleView?id=connected_app_continuous_ip.htm&type=5

Salesforce APIでSOQL クエリを実行したい

サンプルコードを実行するの「SOQL クエリを実行する」
をGASでやってみます。

事前準備

接続アプリケーションを作成して
アクセストークンなどのデータをスクリプトのプロパティに保存しておく

手順は以下のブログに書きました。

SalesforceでAPIを使うために接続アプリケーションを作成したい
Salesforceで接続アプリケーションを作成したい（Lightningの方で）

コード.gs

function getData() {
  var options = {
    "method" : "GET",
    "headers" : {
      "Authorization": "Bearer " + getProp("access_token")
    }
  }
  var url = getProp("instance_url") + "/services/data/v20.0/query?q=SELECT+name+from+Account";// SOQL クエリを実行する
  var response = UrlFetchApp.fetch(url, options);
  Logger.log(response);
}

function getProp(key) {
  return PropertiesService.getScriptProperties().getProperty(key);
}

getData()を実行すると、以下のような結果が返ってきました。

実行結果

{
  "totalSize": 4,
  "done": true,
  "records": [{
    "attributes": {
      "type": "Account",
      "url": "/services/data/v20.0/sobjects/Account/0012w000004AAufAAG"
    },
    "Name": "（サンプル）Service Cloud トライアル株式会社"
  }, {
    "attributes": {
      "type": "Account",
      "url": "/services/data/v20.0/sobjects/Account/0012w000004AAugAAG"
    },
    "Name": "（サンプル）グローバル鋼機株式会社"
  }, {
    "attributes": {
      "type": "Account",
      "url": "/services/data/v20.0/sobjects/Account/0012w000004AAuhAAG"
    },
    "Name": "（サンプル）セールスサイクル株式会社"
  }, {
    "attributes": {
      "type": "Account",
      "url": "/services/data/v20.0/sobjects/Account/0012w000004AAuiAAG"
    },
    "Name": "（サンプル）谷町工業株式会社"
  }]
}

参考

サンプルコードを実行する > SOQL クエリを実行する
https://developer.salesforce.com/docs/atlas.ja-jp.222.0.api_rest.meta/api_rest/quickstart_code.htm

Salesforce APIで項目のリストを取得したい

サンプルコードを実行するの「項目のリストを取得する」
をGASでやってみます。

コード.gs

function getData() {
  var options = {
    "method" : "GET",
    "headers" : {
      "Authorization": "Bearer " + getProp("access_token")
    }
  }
  var url = getProp("instance_url") + "/services/data/v47.0/sobjects/Account/describe/";// 項目のリストを取得する
  var response = UrlFetchApp.fetch(url, options);
  Logger.log(response);
  create_file(response);
}

function getProp(key) {
  return PropertiesService.getScriptProperties().getProperty(key);
}

function create_file(json) {
  var content_type = "application/json";
  var file_name = "salesforce sobjects Account";
  var blob = Utilities.newBlob("", content_type, file_name);
  var file = blob.setDataFromString(json, "UTF-8");
  var url = DriveApp.createFile(file).getUrl();
  Logger.log(url);
}

getData()を実行すると、以下のような結果が返ってきました。
Logger.logでは出しきれなかったので
create_file()という関数を作って
GoogleドライブにJSONファイルを出力しました。

実行結果

{
  "actionOverrides": [],
  "activateable": false,
  "childRelationships": [{
    "cascadeDelete": false,
    "childSObject": "AcceptedEventRelation",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Account",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ChildAccounts",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "AccountChangeEvent",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AccountContactRole",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "AccountContactRoles",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "AccountContactRoleChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AccountFeed",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Feeds",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AccountHistory",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Histories",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AccountPartner",
    "deprecatedAndHidden": false,
    "field": "AccountFromId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "AccountPartnersFrom",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AccountPartner",
    "deprecatedAndHidden": false,
    "field": "AccountToId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "AccountPartnersTo",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AccountShare",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Shares",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "ActivityHistory",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ActivityHistories",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "ActivityHistory",
    "deprecatedAndHidden": false,
    "field": "PrimaryAccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AgentWork",
    "deprecatedAndHidden": false,
    "field": "WorkItemId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Asset",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Assets",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Asset",
    "deprecatedAndHidden": false,
    "field": "AssetProvidedById",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ProvidedAssets",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Asset",
    "deprecatedAndHidden": false,
    "field": "AssetServicedById",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ServicedAssets",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "AssetChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "AssetChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AssetProvidedById",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "AssetChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AssetServicedById",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AttachedContentDocument",
    "deprecatedAndHidden": false,
    "field": "LinkedEntityId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "AttachedContentDocuments",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "AttachedContentNote",
    "deprecatedAndHidden": false,
    "field": "LinkedEntityId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "AttachedContentNotes",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Attachment",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Attachments",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "AuthorizationFormConsent",
    "deprecatedAndHidden": false,
    "field": "ConsentGiverId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "AuthorizationFormConsents",
    "restrictedDelete": true
  }, {
    "cascadeDelete": false,
    "childSObject": "AuthorizationFormConsentChangeEvent",
    "deprecatedAndHidden": false,
    "field": "ConsentGiverId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Case",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Cases",
    "restrictedDelete": true
  }, {
    "cascadeDelete": false,
    "childSObject": "CaseChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "CollaborationGroupRecord",
    "deprecatedAndHidden": false,
    "field": "RecordId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "RecordAssociatedGroups",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "CombinedAttachment",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "CombinedAttachments",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Contact",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Contacts",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "ContactChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "ContactRequest",
    "deprecatedAndHidden": false,
    "field": "WhatId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ContactRequests",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "ContentDistribution",
    "deprecatedAndHidden": false,
    "field": "RelatedRecordId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "ContentDocumentLink",
    "deprecatedAndHidden": false,
    "field": "LinkedEntityId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ContentDocumentLinks",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "ContentVersion",
    "deprecatedAndHidden": false,
    "field": "FirstPublishLocationId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Contract",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Contracts",
    "restrictedDelete": true
  }, {
    "cascadeDelete": false,
    "childSObject": "ContractChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "DeclinedEventRelation",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "DuplicateRecordItem",
    "deprecatedAndHidden": false,
    "field": "RecordId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "DuplicateRecordItems",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "EmailMessage",
    "deprecatedAndHidden": false,
    "field": "RelatedToId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Emails",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "EntitySubscription",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "FeedSubscriptionsForEntity",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Event",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Event",
    "deprecatedAndHidden": false,
    "field": "WhatId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Events",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "EventChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "EventChangeEvent",
    "deprecatedAndHidden": false,
    "field": "WhatId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "EventRelation",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "EventRelation",
    "deprecatedAndHidden": false,
    "field": "RelationId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "EventRelations",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "EventRelationChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "EventRelationChangeEvent",
    "deprecatedAndHidden": false,
    "field": "RelationId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "EventWhoRelation",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "FeedComment",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "FeedItem",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "FlowRecordRelation",
    "deprecatedAndHidden": false,
    "field": "RelatedRecordId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Lead",
    "deprecatedAndHidden": false,
    "field": "ConvertedAccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "LeadChangeEvent",
    "deprecatedAndHidden": false,
    "field": "ConvertedAccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "LiveChatTranscript",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "LiveChatTranscripts",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "LiveChatTranscriptChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Note",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Notes",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "NoteAndAttachment",
    "deprecatedAndHidden": false,
    "field": "ParentId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "NotesAndAttachments",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "OpenActivity",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "OpenActivities",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "OpenActivity",
    "deprecatedAndHidden": false,
    "field": "PrimaryAccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Opportunity",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Opportunities",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "OpportunityChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "OpportunityPartner",
    "deprecatedAndHidden": false,
    "field": "AccountToId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "OpportunityPartnersTo",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Order",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Orders",
    "restrictedDelete": true
  }, {
    "cascadeDelete": false,
    "childSObject": "OrderChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "OutgoingEmail",
    "deprecatedAndHidden": false,
    "field": "RelatedToId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Partner",
    "deprecatedAndHidden": false,
    "field": "AccountFromId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "PartnersFrom",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Partner",
    "deprecatedAndHidden": false,
    "field": "AccountToId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "PartnersTo",
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "PendingServiceRouting",
    "deprecatedAndHidden": false,
    "field": "WorkItemId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "ProcessInstance",
    "deprecatedAndHidden": false,
    "field": "TargetObjectId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ProcessInstances",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "ProcessInstanceHistory",
    "deprecatedAndHidden": false,
    "field": "TargetObjectId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "ProcessSteps",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Quote",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "RecordAction",
    "deprecatedAndHidden": false,
    "field": "RecordId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "RecordActions",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "RecordActionHistory",
    "deprecatedAndHidden": false,
    "field": "ParentRecordId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "RecordActionHistories",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "Task",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "Task",
    "deprecatedAndHidden": false,
    "field": "WhatId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Tasks",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "TaskChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "TaskChangeEvent",
    "deprecatedAndHidden": false,
    "field": "WhatId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "TaskRelation",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "TaskRelation",
    "deprecatedAndHidden": false,
    "field": "RelationId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "TaskRelations",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "TaskRelationChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "TaskRelationChangeEvent",
    "deprecatedAndHidden": false,
    "field": "RelationId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "TaskWhoRelation",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": true,
    "childSObject": "TopicAssignment",
    "deprecatedAndHidden": false,
    "field": "EntityId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "TopicAssignments",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "UndecidedEventRelation",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "User",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": "Users",
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "UserChangeEvent",
    "deprecatedAndHidden": false,
    "field": "AccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }, {
    "cascadeDelete": false,
    "childSObject": "UserRole",
    "deprecatedAndHidden": false,
    "field": "PortalAccountId",
    "junctionIdListNames": [],
    "junctionReferenceTo": [],
    "relationshipName": null,
    "restrictedDelete": false
  }],
  "compactLayoutable": true,
  "createable": true,
  "custom": false,
  "customSetting": false,
  "deepCloneable": false,
  "defaultImplementation": null,
  "deletable": true,
  "deprecatedAndHidden": false,
  "extendedBy": null,
  "extendsInterfaces": null,
  "feedEnabled": true,
  "fields": [{
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 18,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": true,
    "inlineHelpText": null,
    "label": "取引先 ID",
    "length": 18,
    "mask": null,
    "maskType": null,
    "name": "Id",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "tns:ID",
    "sortable": true,
    "type": "id",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": false,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": false,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "削除",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "IsDeleted",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:boolean",
    "sortable": true,
    "type": "boolean",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 18,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "マスタレコード ID",
    "length": 18,
    "mask": null,
    "maskType": null,
    "name": "MasterRecordId",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": ["Account"],
    "relationshipName": "MasterRecord",
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "tns:ID",
    "sortable": true,
    "type": "reference",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 765,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "Name",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": "switchablepersonname",
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先名",
    "length": 255,
    "mask": null,
    "maskType": null,
    "name": "Name",
    "nameField": true,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先 種別",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "Type",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [{
      "active": true,
      "defaultValue": false,
      "label": "アナリスト",
      "validFor": null,
      "value": "アナリスト"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "競合",
      "validFor": null,
      "value": "競合"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "顧客",
      "validFor": null,
      "value": "顧客"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "インテグレータ",
      "validFor": null,
      "value": "インテグレータ"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "投資者",
      "validFor": null,
      "value": "投資者"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "パートナー",
      "validFor": null,
      "value": "パートナー"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "報道関係者",
      "validFor": null,
      "value": "報道関係者"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "見込み客",
      "validFor": null,
      "value": "見込み客"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "再販業者",
      "validFor": null,
      "value": "再販業者"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "その他",
      "validFor": null,
      "value": "その他"
    }],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "picklist",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 18,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "親取引先 ID",
    "length": 18,
    "mask": null,
    "maskType": null,
    "name": "ParentId",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": ["Account"],
    "relationshipName": "Parent",
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": true,
    "soapType": "tns:ID",
    "sortable": true,
    "type": "reference",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 765,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": "plaintextarea",
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "町名・番地(請求先)",
    "length": 255,
    "mask": null,
    "maskType": null,
    "name": "BillingStreet",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "textarea",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "市区郡(請求先)",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "BillingCity",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 240,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "都道府県(請求先)",
    "length": 80,
    "mask": null,
    "maskType": null,
    "name": "BillingState",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 60,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "郵便番号(請求先)",
    "length": 20,
    "mask": null,
    "maskType": null,
    "name": "BillingPostalCode",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 240,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "国(請求先)",
    "length": 80,
    "mask": null,
    "maskType": null,
    "name": "BillingCountry",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "緯度(請求先)",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "BillingLatitude",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 18,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 15,
    "searchPrefilterable": false,
    "soapType": "xsd:double",
    "sortable": true,
    "type": "double",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "経度(請求先)",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "BillingLongitude",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 18,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 15,
    "searchPrefilterable": false,
    "soapType": "xsd:double",
    "sortable": true,
    "type": "double",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "BillingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "Billing Geocode Accuracy",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "BillingGeocodeAccuracy",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [{
      "active": true,
      "defaultValue": false,
      "label": "住所",
      "validFor": null,
      "value": "Address"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "NearAddress",
      "validFor": null,
      "value": "NearAddress"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "ブロック",
      "validFor": null,
      "value": "Block"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "町名・番地",
      "validFor": null,
      "value": "Street"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "ExtendedZip",
      "validFor": null,
      "value": "ExtendedZip"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "郵便番号",
      "validFor": null,
      "value": "Zip"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "近隣",
      "validFor": null,
      "value": "Neighborhood"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "市区町村",
      "validFor": null,
      "value": "City"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "郡",
      "validFor": null,
      "value": "County"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "都道府県",
      "validFor": null,
      "value": "State"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "不明",
      "validFor": null,
      "value": "Unknown"
    }],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": true,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "picklist",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": false,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "住所(請求先)",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "BillingAddress",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": true,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "urn:address",
    "sortable": false,
    "type": "address",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 765,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": "plaintextarea",
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "町名・番地(納入先)",
    "length": 255,
    "mask": null,
    "maskType": null,
    "name": "ShippingStreet",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "textarea",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "市区郡(納入先)",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "ShippingCity",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 240,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "都道府県(納入先)",
    "length": 80,
    "mask": null,
    "maskType": null,
    "name": "ShippingState",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 60,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "郵便番号(納入先)",
    "length": 20,
    "mask": null,
    "maskType": null,
    "name": "ShippingPostalCode",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 240,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "国(納入先)",
    "length": 80,
    "mask": null,
    "maskType": null,
    "name": "ShippingCountry",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "緯度(納入先)",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "ShippingLatitude",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 18,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 15,
    "searchPrefilterable": false,
    "soapType": "xsd:double",
    "sortable": true,
    "type": "double",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "経度(納入先)",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "ShippingLongitude",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 18,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 15,
    "searchPrefilterable": false,
    "soapType": "xsd:double",
    "sortable": true,
    "type": "double",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": "ShippingAddress",
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "Shipping Geocode Accuracy",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "ShippingGeocodeAccuracy",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [{
      "active": true,
      "defaultValue": false,
      "label": "住所",
      "validFor": null,
      "value": "Address"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "NearAddress",
      "validFor": null,
      "value": "NearAddress"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "ブロック",
      "validFor": null,
      "value": "Block"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "町名・番地",
      "validFor": null,
      "value": "Street"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "ExtendedZip",
      "validFor": null,
      "value": "ExtendedZip"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "郵便番号",
      "validFor": null,
      "value": "Zip"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "近隣",
      "validFor": null,
      "value": "Neighborhood"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "市区町村",
      "validFor": null,
      "value": "City"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "郡",
      "validFor": null,
      "value": "County"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "都道府県",
      "validFor": null,
      "value": "State"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "不明",
      "validFor": null,
      "value": "Unknown"
    }],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": true,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "picklist",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": false,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "住所(納入先)",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "ShippingAddress",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": true,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "urn:address",
    "sortable": false,
    "type": "address",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": "Phone numbers are a great way to call people on phones.  Phones are what we call our pocket computers even though we use them for games, selfies, and facebook.",
    "label": "取引先 電話",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "Phone",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "phone",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先 Fax",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "Fax",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "phone",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先番号",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "AccountNumber",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 765,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "Web サイト",
    "length": 255,
    "mask": null,
    "maskType": null,
    "name": "Website",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "url",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 765,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": "imageurl",
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "写真の URL",
    "length": 255,
    "mask": null,
    "maskType": null,
    "name": "PhotoUrl",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "url",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 60,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "産業コード",
    "length": 20,
    "mask": null,
    "maskType": null,
    "name": "Sic",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "業種",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "Industry",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [{
      "active": true,
      "defaultValue": false,
      "label": "01 農業",
      "validFor": null,
      "value": "01 農業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "02 林業",
      "validFor": null,
      "value": "02 林業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "03 漁業（水産養殖業を除く）",
      "validFor": null,
      "value": "03 漁業（水産養殖業を除く）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "04 水産養殖業",
      "validFor": null,
      "value": "04 水産養殖業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "05 鉱業、採石業、砂利採取業",
      "validFor": null,
      "value": "05 鉱業、採石業、砂利採取業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "06 総合工事業",
      "validFor": null,
      "value": "06 総合工事業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "07 職別工事業（設備工事業を除く）",
      "validFor": null,
      "value": "07 職別工事業（設備工事業を除く）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "08 設備工事業",
      "validFor": null,
      "value": "08 設備工事業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "09 食料品製造業",
      "validFor": null,
      "value": "09 食料品製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "10 飲料・たばこ・飼料製造業",
      "validFor": null,
      "value": "10 飲料・たばこ・飼料製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "11 繊維工業",
      "validFor": null,
      "value": "11 繊維工業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "12 木材・木製品製造業（家具を除く）",
      "validFor": null,
      "value": "12 木材・木製品製造業（家具を除く）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "13 家具・装備品製造業",
      "validFor": null,
      "value": "13 家具・装備品製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "14 パルプ・紙・紙加工品製造業",
      "validFor": null,
      "value": "14 パルプ・紙・紙加工品製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "15 印刷・同関連業",
      "validFor": null,
      "value": "15 印刷・同関連業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "16 化学工業",
      "validFor": null,
      "value": "16 化学工業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "17 石油製品・石炭製品製造業",
      "validFor": null,
      "value": "17 石油製品・石炭製品製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "18 プラスチック製品製造業（別掲を除く）",
      "validFor": null,
      "value": "18 プラスチック製品製造業（別掲を除く）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "19 ゴム製品製造業",
      "validFor": null,
      "value": "19 ゴム製品製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "20 なめし革・同製品・毛皮製造業",
      "validFor": null,
      "value": "20 なめし革・同製品・毛皮製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "21 窯業・土石製品製造業",
      "validFor": null,
      "value": "21 窯業・土石製品製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "22 鉄鋼業",
      "validFor": null,
      "value": "22 鉄鋼業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "23 非鉄金属製造業",
      "validFor": null,
      "value": "23 非鉄金属製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "24 金属製品製造業",
      "validFor": null,
      "value": "24 金属製品製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "25 はん用機械器具製造業",
      "validFor": null,
      "value": "25 はん用機械器具製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "26 生産用機械器具製造業",
      "validFor": null,
      "value": "26 生産用機械器具製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "27 業務用機械器具製造業",
      "validFor": null,
      "value": "27 業務用機械器具製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "28 電子部品・デバイス・電子回路製造業",
      "validFor": null,
      "value": "28 電子部品・デバイス・電子回路製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "29 電気機械器具製造業",
      "validFor": null,
      "value": "29 電気機械器具製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "30 情報通信機械器具製造業",
      "validFor": null,
      "value": "30 情報通信機械器具製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "31 輸送用機械器具製造業",
      "validFor": null,
      "value": "31 輸送用機械器具製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "32 その他の製造業",
      "validFor": null,
      "value": "32 その他の製造業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "33 電気業",
      "validFor": null,
      "value": "33 電気業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "34 ガス業",
      "validFor": null,
      "value": "34 ガス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "35 熱供給業",
      "validFor": null,
      "value": "35 熱供給業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "36 水道業",
      "validFor": null,
      "value": "36 水道業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "37 通信業",
      "validFor": null,
      "value": "37 通信業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "38 放送業",
      "validFor": null,
      "value": "38 放送業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "39 情報サービス業",
      "validFor": null,
      "value": "39 情報サービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "40 インターネット附随サービス業",
      "validFor": null,
      "value": "40 インターネット附随サービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "41 映像・音声・文字情報制作業",
      "validFor": null,
      "value": "41 映像・音声・文字情報制作業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "42 鉄道業",
      "validFor": null,
      "value": "42 鉄道業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "43 道路旅客運送業",
      "validFor": null,
      "value": "43 道路旅客運送業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "44 道路貨物運送業",
      "validFor": null,
      "value": "44 道路貨物運送業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "45 水運業",
      "validFor": null,
      "value": "45 水運業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "46 航空運輸業",
      "validFor": null,
      "value": "46 航空運輸業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "47 倉庫業",
      "validFor": null,
      "value": "47 倉庫業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "48 運輸に附帯するサービス業",
      "validFor": null,
      "value": "48 運輸に附帯するサービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "49 郵便業（信書便事業を含む）",
      "validFor": null,
      "value": "49 郵便業（信書便事業を含む）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "50 各種商品卸売業",
      "validFor": null,
      "value": "50 各種商品卸売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "51 繊維・衣服等卸売業",
      "validFor": null,
      "value": "51 繊維・衣服等卸売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "52 飲食料品卸売業",
      "validFor": null,
      "value": "52 飲食料品卸売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "53 建築材料、鉱物・金属材料等卸売業",
      "validFor": null,
      "value": "53 建築材料、鉱物・金属材料等卸売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "54 機械器具卸売業",
      "validFor": null,
      "value": "54 機械器具卸売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "55 その他の卸売業",
      "validFor": null,
      "value": "55 その他の卸売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "56 各種商品小売業",
      "validFor": null,
      "value": "56 各種商品小売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "57 織物・衣服・身の回り品小売業",
      "validFor": null,
      "value": "57 織物・衣服・身の回り品小売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "58 飲食料品小売業",
      "validFor": null,
      "value": "58 飲食料品小売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "59 機械器具小売業",
      "validFor": null,
      "value": "59 機械器具小売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "60 その他の小売業",
      "validFor": null,
      "value": "60 その他の小売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "61 無店舗小売業",
      "validFor": null,
      "value": "61 無店舗小売業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "62 銀行業",
      "validFor": null,
      "value": "62 銀行業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "63 協同組織金融業",
      "validFor": null,
      "value": "63 協同組織金融業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "64 貸金業、クレジットカード業等非預金信用機関",
      "validFor": null,
      "value": "64 貸金業、クレジットカード業等非預金信用機関"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "65 金融商品取引業、商品先物取引業",
      "validFor": null,
      "value": "65 金融商品取引業、商品先物取引業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "66 補助的金融業等",
      "validFor": null,
      "value": "66 補助的金融業等"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "67 保険業（保険媒介代理業、保険サービス業を含む）",
      "validFor": null,
      "value": "67 保険業（保険媒介代理業、保険サービス業を含む）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "68 不動産取引業",
      "validFor": null,
      "value": "68 不動産取引業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "69 不動産賃貸業・管理業",
      "validFor": null,
      "value": "69 不動産賃貸業・管理業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "70 物品賃貸業",
      "validFor": null,
      "value": "70 物品賃貸業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "71 学術・開発研究機関",
      "validFor": null,
      "value": "71 学術・開発研究機関"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "72 専門サービス業（他に分類されないもの）",
      "validFor": null,
      "value": "72 専門サービス業（他に分類されないもの）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "73 広告業",
      "validFor": null,
      "value": "73 広告業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "74 技術サービス業",
      "validFor": null,
      "value": "74 技術サービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "75 宿泊業",
      "validFor": null,
      "value": "75 宿泊業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "76 飲食店",
      "validFor": null,
      "value": "76 飲食店"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "77 持ち帰り・配達飲食サービス業",
      "validFor": null,
      "value": "77 持ち帰り・配達飲食サービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "78 洗濯・理容・美容・浴場業",
      "validFor": null,
      "value": "78 洗濯・理容・美容・浴場業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "79 その他の生活関連サービス業",
      "validFor": null,
      "value": "79 その他の生活関連サービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "80 娯楽業",
      "validFor": null,
      "value": "80 娯楽業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "81 学校教育",
      "validFor": null,
      "value": "81 学校教育"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "82 その他の教育、学習支援業",
      "validFor": null,
      "value": "82 その他の教育、学習支援業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "83 医療業",
      "validFor": null,
      "value": "83 医療業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "84 保健衛生",
      "validFor": null,
      "value": "84 保健衛生"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "85 社会保険・社会福祉・介護事業",
      "validFor": null,
      "value": "85 社会保険・社会福祉・介護事業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "86 郵便局",
      "validFor": null,
      "value": "86 郵便局"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "87 協同組合（他に分類されないもの）",
      "validFor": null,
      "value": "87 協同組合（他に分類されないもの）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "88 廃棄物処理業",
      "validFor": null,
      "value": "88 廃棄物処理業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "89 自動車整備業",
      "validFor": null,
      "value": "89 自動車整備業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "90 機械等修理業（別掲を除く）",
      "validFor": null,
      "value": "90 機械等修理業（別掲を除く）"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "91 職業紹介・労働者派遣業",
      "validFor": null,
      "value": "91 職業紹介・労働者派遣業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "92 その他の事業サービス業",
      "validFor": null,
      "value": "92 その他の事業サービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "93 政治・経済・文化団体",
      "validFor": null,
      "value": "93 政治・経済・文化団体"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "94 宗教",
      "validFor": null,
      "value": "94 宗教"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "95 その他のサービス業",
      "validFor": null,
      "value": "95 その他のサービス業"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "96 外国公務",
      "validFor": null,
      "value": "96 外国公務"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "97 国家公務",
      "validFor": null,
      "value": "97 国家公務"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "98 地方公務",
      "validFor": null,
      "value": "98 地方公務"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "99 分類不能の産業",
      "validFor": null,
      "value": "99 分類不能の産業"
    }],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "picklist",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "年間売上",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "AnnualRevenue",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 18,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:double",
    "sortable": true,
    "type": "currency",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 8,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "従業員数",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "NumberOfEmployees",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:int",
    "sortable": true,
    "type": "int",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "会社形態",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "Ownership",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [{
      "active": true,
      "defaultValue": false,
      "label": "上場",
      "validFor": null,
      "value": "上場"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "非上場",
      "validFor": null,
      "value": "非上場"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "子会社",
      "validFor": null,
      "value": "子会社"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "その他",
      "validFor": null,
      "value": "その他"
    }],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "picklist",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 60,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "株式コード",
    "length": 20,
    "mask": null,
    "maskType": null,
    "name": "TickerSymbol",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": false,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 96000,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": "plaintextarea",
    "filterable": false,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先 説明",
    "length": 32000,
    "mask": null,
    "maskType": null,
    "name": "Description",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": false,
    "type": "textarea",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先 評価",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "Rating",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [{
      "active": true,
      "defaultValue": false,
      "label": "見込み有り",
      "validFor": null,
      "value": "見込み有り"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "将来的に見込み有り",
      "validFor": null,
      "value": "将来的に見込み有り"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "見込み無し",
      "validFor": null,
      "value": "見込み無し"
    }],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "picklist",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 240,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先 部門",
    "length": 80,
    "mask": null,
    "maskType": null,
    "name": "Site",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 18,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "所有者 ID",
    "length": 18,
    "mask": null,
    "maskType": null,
    "name": "OwnerId",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": ["User"],
    "relationshipName": "Owner",
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "tns:ID",
    "sortable": true,
    "type": "reference",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "作成日",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "CreatedDate",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:dateTime",
    "sortable": true,
    "type": "datetime",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 18,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "作成者 ID",
    "length": 18,
    "mask": null,
    "maskType": null,
    "name": "CreatedById",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": ["User"],
    "relationshipName": "CreatedBy",
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "tns:ID",
    "sortable": true,
    "type": "reference",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "最終更新日",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "LastModifiedDate",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:dateTime",
    "sortable": true,
    "type": "datetime",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 18,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "最終更新者 ID",
    "length": 18,
    "mask": null,
    "maskType": null,
    "name": "LastModifiedById",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": ["User"],
    "relationshipName": "LastModifiedBy",
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "tns:ID",
    "sortable": true,
    "type": "reference",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": true,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "System Modstamp",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "SystemModstamp",
    "nameField": false,
    "namePointing": false,
    "nillable": false,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:dateTime",
    "sortable": true,
    "type": "datetime",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "最終活動日",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "LastActivityDate",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:date",
    "sortable": true,
    "type": "date",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "最終閲覧日",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "LastViewedDate",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:dateTime",
    "sortable": true,
    "type": "datetime",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 0,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": false,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "最終参照日",
    "length": 0,
    "mask": null,
    "maskType": null,
    "name": "LastReferencedDate",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:dateTime",
    "sortable": true,
    "type": "datetime",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 60,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "Data.com キー",
    "length": 20,
    "mask": null,
    "maskType": null,
    "name": "Jigsaw",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 60,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": false,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "Jigsaw Company ID",
    "length": 20,
    "mask": null,
    "maskType": null,
    "name": "JigsawCompanyId",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": false,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": "JigsawCompany",
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": false,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 120,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "取引先ソース",
    "length": 40,
    "mask": null,
    "maskType": null,
    "name": "AccountSource",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [{
      "active": true,
      "defaultValue": false,
      "label": "広告",
      "validFor": null,
      "value": "広告"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "イベント / セミナー",
      "validFor": null,
      "value": "イベント / セミナー"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "従業員からの紹介",
      "validFor": null,
      "value": "従業員からの紹介"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "Google AdWords",
      "validFor": null,
      "value": "Google AdWords"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "その他",
      "validFor": null,
      "value": "その他"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "パートナー",
      "validFor": null,
      "value": "パートナー"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "リスト購入",
      "validFor": null,
      "value": "リスト購入"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "展示会",
      "validFor": null,
      "value": "展示会"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "Webセミナー",
      "validFor": null,
      "value": "Webセミナー"
    }, {
      "active": true,
      "defaultValue": false,
      "label": "Webサイト",
      "validFor": null,
      "value": "Webサイト"
    }],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "picklist",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }, {
    "aggregatable": true,
    "aiPredictionField": false,
    "autoNumber": false,
    "byteLength": 240,
    "calculated": false,
    "calculatedFormula": null,
    "cascadeDelete": false,
    "caseSensitive": false,
    "compoundFieldName": null,
    "controllerName": null,
    "createable": true,
    "custom": false,
    "defaultValue": null,
    "defaultValueFormula": null,
    "defaultedOnCreate": false,
    "dependentPicklist": false,
    "deprecatedAndHidden": false,
    "digits": 0,
    "displayLocationInDecimal": false,
    "encrypted": false,
    "externalId": false,
    "extraTypeInfo": null,
    "filterable": true,
    "filteredLookupInfo": null,
    "formulaTreatNullNumberAsZero": false,
    "groupable": true,
    "highScaleNumber": false,
    "htmlFormatted": false,
    "idLookup": false,
    "inlineHelpText": null,
    "label": "産業区分の説明",
    "length": 80,
    "mask": null,
    "maskType": null,
    "name": "SicDesc",
    "nameField": false,
    "namePointing": false,
    "nillable": true,
    "permissionable": true,
    "picklistValues": [],
    "polymorphicForeignKey": false,
    "precision": 0,
    "queryByDistance": false,
    "referenceTargetField": null,
    "referenceTo": [],
    "relationshipName": null,
    "relationshipOrder": null,
    "restrictedDelete": false,
    "restrictedPicklist": false,
    "scale": 0,
    "searchPrefilterable": false,
    "soapType": "xsd:string",
    "sortable": true,
    "type": "string",
    "unique": false,
    "updateable": true,
    "writeRequiresMasterRead": false
  }],
  "hasSubtypes": false,
  "implementedBy": null,
  "implementsInterfaces": null,
  "isInterface": false,
  "isSubtype": false,
  "keyPrefix": "001",
  "label": "取引先",
  "labelPlural": "取引先",
  "layoutable": true,
  "listviewable": null,
  "lookupLayoutable": null,
  "mergeable": true,
  "mruEnabled": true,
  "name": "Account",
  "namedLayoutInfos": [],
  "networkScopeFieldName": null,
  "queryable": true,
  "recordTypeInfos": [{
    "active": true,
    "available": true,
    "defaultRecordTypeMapping": true,
    "developerName": "マスタ",
    "master": true,
    "name": "マスタ",
    "recordTypeId": "012000000000000AAA",
    "urls": {
      "layout": "/services/data/v47.0/sobjects/Account/describe/layouts/012000000000000AAA"
    }
  }],
  "replicateable": true,
  "retrieveable": true,
  "searchLayoutable": true,
  "searchable": true,
  "supportedScopes": [{
    "label": "すべての取引先",
    "name": "everything"
  }, {
    "label": "私の取引先",
    "name": "mine"
  }, {
    "label": "私のチームの取引先",
    "name": "team"
  }],
  "triggerable": true,
  "undeletable": true,
  "updateable": true,
  "urls": {
    "compactLayouts": "/services/data/v47.0/sobjects/Account/describe/compactLayouts",
    "rowTemplate": "/services/data/v47.0/sobjects/Account/{ID}",
    "approvalLayouts": "/services/data/v47.0/sobjects/Account/describe/approvalLayouts",
    "uiDetailTemplate": "https://ID.salesforce.com/{ID}",
    "uiEditTemplate": "https://ID.salesforce.com/{ID}/e",
    "defaultValues": "/services/data/v47.0/sobjects/Account/defaultValues?recordTypeId&fields",
    "listviews": "/services/data/v47.0/sobjects/Account/listviews",
    "describe": "/services/data/v47.0/sobjects/Account/describe",
    "uiNewRecord": "https://ID.salesforce.com/001/e",
    "quickActions": "/services/data/v47.0/sobjects/Account/quickActions",
    "layouts": "/services/data/v47.0/sobjects/Account/describe/layouts",
    "sobject": "/services/data/v47.0/sobjects/Account"
  }
}

参考

サンプルコードを実行する > 項目のリストを取得する
https://developer.salesforce.com/docs/atlas.ja-jp.222.0.api_rest.meta/api_rest/quickstart_code.htm

Google Apps Script試行錯誤 Blog

2020年1月31日金曜日

LanguageApp.translateで英文中の単語ごとに翻訳したい

テーブル内でクリックしたセルの位置を知りたい

Data Studio（データポータル）で使用できる関数

SalesforceのAPIでアクセストークンを取得したい（ユーザ名,パスワード）

Salesforce APIで接続アプリケーションのIP制限の緩和を設定したい

Salesforce APIでSOQL クエリを実行したい

Salesforce APIで項目のリストを取得したい

Latest post

Google Apps Scriptの障害時はIssueTrackerを見てみる - Incidents for Apps Script are reported on Issue Tracker