Opportunity
NetSuite のOpportunity テーブルです。
Columns
Name | Type | ReadOnly | Description |
InternalId [KEY] | String | True |
Opportunity テーブルのInternalId。 |
ActionItem | String | False |
Opportunity テーブルのActionItem。 |
AltSalesRangeHigh | Double | False |
Opportunity テーブルのAltSalesRangeHigh。 |
AltSalesRangeLow | Double | False |
Opportunity テーブルのAltSalesRangeLow。 |
BillAddress | String | False |
Opportunity テーブルのBillAddress。 |
BillAddressList_ExternalId | String | False |
Opportunity テーブルのBillAddressList_ExternalId。 |
BillAddressList_InternalId | String | False |
Opportunity テーブルのBillAddressList_InternalId。 |
BillAddressList_Name | String | False |
Opportunity テーブルのBillAddressList_Name。 |
BillAddressList_Type | String | False |
Opportunity テーブルのBillAddressList_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
BuyingReason_ExternalId | String | False |
Opportunity テーブルのBuyingReason_ExternalId。 |
BuyingReason_InternalId | String | False |
Opportunity テーブルのBuyingReason_InternalId。 |
BuyingReason_Name | String | False |
Opportunity テーブルのBuyingReason_Name。 |
BuyingReason_Type | String | False |
Opportunity テーブルのBuyingReason_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
BuyingTimeFrame_ExternalId | String | False |
Opportunity テーブルのBuyingTimeFrame_ExternalId。 |
BuyingTimeFrame_InternalId | String | False |
Opportunity テーブルのBuyingTimeFrame_InternalId。 |
BuyingTimeFrame_Name | String | False |
Opportunity テーブルのBuyingTimeFrame_Name。 |
BuyingTimeFrame_Type | String | False |
Opportunity テーブルのBuyingTimeFrame_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
Class_ExternalId | String | False |
Opportunity テーブルのClass_ExternalId。 |
Class_InternalId | String | False |
Opportunity テーブルのClass_InternalId。 |
Class_Name | String | False |
Opportunity テーブルのClass_Name。 |
Class_Type | String | False |
Opportunity テーブルのClass_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
CloseDate | Datetime | False |
Opportunity テーブルのCloseDate。 |
CompetitorsList_ReplaceAll | Boolean | False |
Opportunity テーブルのCompetitorsList_ReplaceAll。 |
ContribPct | String | False |
Opportunity テーブルのContribPct。 |
CreatedDate | Datetime | False |
Opportunity テーブルのCreatedDate。 |
Currency_ExternalId | String | False |
Opportunity テーブルのCurrency_ExternalId。 |
Currency_InternalId | String | False |
Opportunity テーブルのCurrency_InternalId。 |
Currency_Name | String | False |
Opportunity テーブルのCurrency_Name。 |
Currency_Type | String | False |
Opportunity テーブルのCurrency_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
CurrencyName | String | False |
Opportunity テーブルのCurrencyName。 |
CustomForm_ExternalId | String | False |
Opportunity テーブルのCustomForm_ExternalId。 |
CustomForm_InternalId | String | False |
Opportunity テーブルのCustomForm_InternalId。 |
CustomForm_Name | String | False |
Opportunity テーブルのCustomForm_Name。 |
CustomForm_Type | String | False |
Opportunity テーブルのCustomForm_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
DaysOpen | Long | False |
Opportunity テーブルのDaysOpen。 |
Department_ExternalId | String | False |
Opportunity テーブルのDepartment_ExternalId。 |
Department_InternalId | String | False |
Opportunity テーブルのDepartment_InternalId。 |
Department_Name | String | False |
Opportunity テーブルのDepartment_Name。 |
Department_Type | String | False |
Opportunity テーブルのDepartment_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
Entity_ExternalId | String | False |
Opportunity テーブルのEntity_ExternalId。 |
Entity_InternalId | String | False |
Opportunity テーブルのEntity_InternalId。 |
Entity_Name | String | False |
Opportunity テーブルのEntity_Name。 |
Entity_Type | String | False |
Opportunity テーブルのEntity_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
EntityStatus_ExternalId | String | False |
Opportunity テーブルのEntityStatus_ExternalId。 |
EntityStatus_InternalId | String | False |
Opportunity テーブルのEntityStatus_InternalId。 |
EntityStatus_Name | String | False |
Opportunity テーブルのEntityStatus_Name。 |
EntityStatus_Type | String | False |
Opportunity テーブルのEntityStatus_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
EstGrossProfit | Double | False |
Opportunity テーブルのEstGrossProfit。 |
EstGrossProfitPercent | Double | False |
Opportunity テーブルのEstGrossProfitPercent。 |
EstimatedBudget | Double | False |
Opportunity テーブルのEstimatedBudget。 |
ExchangeRate | Double | False |
Opportunity テーブルのExchangeRate。 |
ExpectedCloseDate | Datetime | False |
Opportunity テーブルのExpectedCloseDate。 |
ExternalId | String | False |
Opportunity テーブルのExternalId。 |
ForecastType_ExternalId | String | False |
Opportunity テーブルのForecastType_ExternalId。 |
ForecastType_InternalId | String | False |
Opportunity テーブルのForecastType_InternalId。 |
ForecastType_Name | String | False |
Opportunity テーブルのForecastType_Name。 |
ForecastType_Type | String | False |
Opportunity テーブルのForecastType_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
IsBudgetApproved | Boolean | False |
Opportunity テーブルのIsBudgetApproved。 |
ItemList_ReplaceAll | Boolean | False |
Opportunity テーブルのItemList_ReplaceAll。 |
Job_ExternalId | String | False |
Opportunity テーブルのJob_ExternalId。 |
Job_InternalId | String | False |
Opportunity テーブルのJob_InternalId。 |
Job_Name | String | False |
Opportunity テーブルのJob_Name。 |
Job_Type | String | False |
Opportunity テーブルのJob_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
LastModifiedDate | Datetime | False |
Opportunity テーブルのLastModifiedDate。 |
LeadSource_ExternalId | String | False |
Opportunity テーブルのLeadSource_ExternalId。 |
LeadSource_InternalId | String | False |
Opportunity テーブルのLeadSource_InternalId。 |
LeadSource_Name | String | False |
Opportunity テーブルのLeadSource_Name。 |
LeadSource_Type | String | False |
Opportunity テーブルのLeadSource_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
Location_ExternalId | String | False |
Opportunity テーブルのLocation_ExternalId。 |
Location_InternalId | String | False |
Opportunity テーブルのLocation_InternalId。 |
Location_Name | String | False |
Opportunity テーブルのLocation_Name。 |
Location_Type | String | False |
Opportunity テーブルのLocation_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
Memo | String | False |
Opportunity テーブルのMemo。 |
Partner_ExternalId | String | False |
Opportunity テーブルのPartner_ExternalId。 |
Partner_InternalId | String | False |
Opportunity テーブルのPartner_InternalId。 |
Partner_Name | String | False |
Opportunity テーブルのPartner_Name。 |
Partner_Type | String | False |
Opportunity テーブルのPartner_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
PartnersList_ReplaceAll | Boolean | False |
Opportunity テーブルのPartnersList_ReplaceAll。 |
Probability | Double | False |
Opportunity テーブルのProbability。 |
ProjAltSalesAmt | Double | False |
Opportunity テーブルのProjAltSalesAmt。 |
ProjectedTotal | Double | False |
Opportunity テーブルのProjectedTotal。 |
RangeHigh | Double | False |
Opportunity テーブルのRangeHigh。 |
RangeLow | Double | False |
Opportunity テーブルのRangeLow。 |
SalesGroup_ExternalId | String | False |
Opportunity テーブルのSalesGroup_ExternalId。 |
SalesGroup_InternalId | String | False |
Opportunity テーブルのSalesGroup_InternalId。 |
SalesGroup_Name | String | False |
Opportunity テーブルのSalesGroup_Name。 |
SalesGroup_Type | String | False |
Opportunity テーブルのSalesGroup_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
SalesReadiness_ExternalId | String | False |
Opportunity テーブルのSalesReadiness_ExternalId。 |
SalesReadiness_InternalId | String | False |
Opportunity テーブルのSalesReadiness_InternalId。 |
SalesReadiness_Name | String | False |
Opportunity テーブルのSalesReadiness_Name。 |
SalesReadiness_Type | String | False |
Opportunity テーブルのSalesReadiness_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
SalesRep_ExternalId | String | False |
Opportunity テーブルのSalesRep_ExternalId。 |
SalesRep_InternalId | String | False |
Opportunity テーブルのSalesRep_InternalId。 |
SalesRep_Name | String | False |
Opportunity テーブルのSalesRep_Name。 |
SalesRep_Type | String | False |
Opportunity テーブルのSalesRep_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
SalesTeamList_ReplaceAll | Boolean | False |
Opportunity テーブルのSalesTeamList_ReplaceAll。 |
ShipAddress | String | False |
Opportunity テーブルのShipAddress。 |
ShipAddressList_ExternalId | String | False |
Opportunity テーブルのShipAddressList_ExternalId。 |
ShipAddressList_InternalId | String | False |
Opportunity テーブルのShipAddressList_InternalId。 |
ShipAddressList_Name | String | False |
Opportunity テーブルのShipAddressList_Name。 |
ShipAddressList_Type | String | False |
Opportunity テーブルのShipAddressList_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
Source | String | False |
Opportunity テーブルのSource。 |
Status | String | False |
Opportunity テーブルのStatus。 |
Subsidiary_ExternalId | String | False |
Opportunity テーブルのSubsidiary_ExternalId。 |
Subsidiary_InternalId | String | False |
Opportunity テーブルのSubsidiary_InternalId。 |
Subsidiary_Name | String | False |
Opportunity テーブルのSubsidiary_Name。 |
Subsidiary_Type | String | False |
Opportunity テーブルのSubsidiary_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |
SyncPartnerTeams | Boolean | False |
Opportunity テーブルのSyncPartnerTeams。 |
SyncSalesTeams | Boolean | False |
Opportunity テーブルのSyncSalesTeams。 |
Tax2Total | Double | False |
Opportunity テーブルのTax2Total。 |
TaxTotal | Double | False |
Opportunity テーブルのTaxTotal。 |
Title | String | False |
Opportunity テーブルのTitle。 |
TotalCostEstimate | Double | False |
Opportunity テーブルのTotalCostEstimate。 |
TranDate | Datetime | False |
Opportunity テーブルのTranDate。 |
TranId | String | False |
Opportunity テーブルのTranId。 |
TransactionBillAddress_BillAddr1 | String | False |
Opportunity テーブルのTransactionBillAddress_BillAddr1。 |
TransactionBillAddress_BillAddr2 | String | False |
Opportunity テーブルのTransactionBillAddress_BillAddr2。 |
TransactionBillAddress_BillAddr3 | String | False |
Opportunity テーブルのTransactionBillAddress_BillAddr3。 |
TransactionBillAddress_BillAddressee | String | False |
Opportunity テーブルのTransactionBillAddress_BillAddressee。 |
TransactionBillAddress_BillAttention | String | False |
Opportunity テーブルのTransactionBillAddress_BillAttention。 |
TransactionBillAddress_BillCity | String | False |
Opportunity テーブルのTransactionBillAddress_BillCity。 |
TransactionBillAddress_BillCountry | String | False |
Opportunity テーブルのTransactionBillAddress_BillCountry。 The allowed values are _afghanistan, _alandIslands, _albania, _algeria, _americanSamoa, _andorra, _angola, _anguilla, _antarctica, _antiguaAndBarbuda, _argentina, _armenia, _aruba, _australia, _austria, _azerbaijan, _bahamas, _bahrain, _bangladesh, _barbados, _belarus, _belgium, _belize, _benin, _bermuda, _bhutan, _bolivia, _bonaireSaintEustatiusAndSaba, _bosniaAndHerzegovina, _botswana, _bouvetIsland, _brazil, _britishIndianOceanTerritory, _bruneiDarussalam, _bulgaria, _burkinaFaso, _burundi, _cambodia, _cameroon, _canada, _canaryIslands, _capeVerde, _caymanIslands, _centralAfricanRepublic, _ceutaAndMelilla, _chad, _chile, _china, _christmasIsland, _cocosKeelingIslands, _colombia, _comoros, _congoDemocraticPeoplesRepublic, _congoRepublicOf, _cookIslands, _costaRica, _coteDIvoire, _croatiaHrvatska, _cuba, _curacao, _cyprus, _czechRepublic, _denmark, _djibouti, _dominica, _dominicanRepublic, _eastTimor, _ecuador, _egypt, _elSalvador, _equatorialGuinea, _eritrea, _estonia, _ethiopia, _falklandIslands, _faroeIslands, _fiji, _finland, _france, _frenchGuiana, _frenchPolynesia, _frenchSouthernTerritories, _gabon, _gambia, _georgia, _germany, _ghana, _gibraltar, _greece, _greenland, _grenada, _guadeloupe, _guam, _guatemala, _guernsey, _guinea, _guineaBissau, _guyana, _haiti, _heardAndMcDonaldIslands, _holySeeCityVaticanState, _honduras, _hongKong, _hungary, _iceland, _india, _indonesia, _iranIslamicRepublicOf, _iraq, _ireland, _isleOfMan, _israel, _italy, _jamaica, _japan, _jersey, _jordan, _kazakhstan, _kenya, _kiribati, _koreaDemocraticPeoplesRepublic, _koreaRepublicOf, _kosovo, _kuwait, _kyrgyzstan, _laoPeoplesDemocraticRepublic, _latvia, _lebanon, _lesotho, _liberia, _libyanArabJamahiriya, _liechtenstein, _lithuania, _luxembourg, _macau, _macedonia, _madagascar, _malawi, _malaysia, _maldives, _mali, _malta, _marshallIslands, _martinique, _mauritania, _mauritius, _mayotte, _mexico, _micronesiaFederalStateOf, _moldovaRepublicOf, _monaco, _mongolia, _montenegro, _montserrat, _morocco, _mozambique, _myanmar, _namibia, _nauru, _nepal, _netherlands, _newCaledonia, _newZealand, _nicaragua, _niger, _nigeria, _niue, _norfolkIsland, _northernMarianaIslands, _norway, _oman, _pakistan, _palau, _palestinianTerritories, _panama, _papuaNewGuinea, _paraguay, _peru, _philippines, _pitcairnIsland, _poland, _portugal, _puertoRico, _qatar, _reunionIsland, _romania, _russianFederation, _rwanda, _saintBarthelemy, _saintHelena, _saintKittsAndNevis, _saintLucia, _saintMartin, _saintVincentAndTheGrenadines, _samoa, _sanMarino, _saoTomeAndPrincipe, _saudiArabia, _senegal, _serbia, _seychelles, _sierraLeone, _singapore, _sintMaarten, _slovakRepublic, _slovenia, _solomonIslands, _somalia, _southAfrica, _southGeorgia, _southSudan, _spain, _sriLanka, _stPierreAndMiquelon, _sudan, _suriname, _svalbardAndJanMayenIslands, _swaziland, _sweden, _switzerland, _syrianArabRepublic, _taiwan, _tajikistan, _tanzania, _thailand, _togo, _tokelau, _tonga, _trinidadAndTobago, _tunisia, _turkey, _turkmenistan, _turksAndCaicosIslands, _tuvalu, _uganda, _ukraine, _unitedArabEmirates, _unitedKingdomGB, _unitedStates, _uruguay, _uSMinorOutlyingIslands, _uzbekistan, _vanuatu, _venezuela, _vietnam, _virginIslandsBritish, _virginIslandsUSA, _wallisAndFutunaIslands, _westernSahara, _yemen, _zambia, _zimbabwe. |
TransactionBillAddress_BillPhone | String | False |
Opportunity テーブルのTransactionBillAddress_BillPhone。 |
TransactionBillAddress_BillState | String | False |
Opportunity テーブルのTransactionBillAddress_BillState。 |
TransactionBillAddress_BillZip | String | False |
Opportunity テーブルのTransactionBillAddress_BillZip。 |
TransactionShipAddress_ShipAddr1 | String | False |
Opportunity テーブルのTransactionShipAddress_ShipAddr1。 |
TransactionShipAddress_ShipAddr2 | String | False |
Opportunity テーブルのTransactionShipAddress_ShipAddr2。 |
TransactionShipAddress_ShipAddr3 | String | False |
Opportunity テーブルのTransactionShipAddress_ShipAddr3。 |
TransactionShipAddress_ShipAddressee | String | False |
Opportunity テーブルのTransactionShipAddress_ShipAddressee。 |
TransactionShipAddress_ShipAttention | String | False |
Opportunity テーブルのTransactionShipAddress_ShipAttention。 |
TransactionShipAddress_ShipCity | String | False |
Opportunity テーブルのTransactionShipAddress_ShipCity。 |
TransactionShipAddress_ShipCountry | String | False |
Opportunity テーブルのTransactionShipAddress_ShipCountry。 The allowed values are _afghanistan, _alandIslands, _albania, _algeria, _americanSamoa, _andorra, _angola, _anguilla, _antarctica, _antiguaAndBarbuda, _argentina, _armenia, _aruba, _australia, _austria, _azerbaijan, _bahamas, _bahrain, _bangladesh, _barbados, _belarus, _belgium, _belize, _benin, _bermuda, _bhutan, _bolivia, _bonaireSaintEustatiusAndSaba, _bosniaAndHerzegovina, _botswana, _bouvetIsland, _brazil, _britishIndianOceanTerritory, _bruneiDarussalam, _bulgaria, _burkinaFaso, _burundi, _cambodia, _cameroon, _canada, _canaryIslands, _capeVerde, _caymanIslands, _centralAfricanRepublic, _ceutaAndMelilla, _chad, _chile, _china, _christmasIsland, _cocosKeelingIslands, _colombia, _comoros, _congoDemocraticPeoplesRepublic, _congoRepublicOf, _cookIslands, _costaRica, _coteDIvoire, _croatiaHrvatska, _cuba, _curacao, _cyprus, _czechRepublic, _denmark, _djibouti, _dominica, _dominicanRepublic, _eastTimor, _ecuador, _egypt, _elSalvador, _equatorialGuinea, _eritrea, _estonia, _ethiopia, _falklandIslands, _faroeIslands, _fiji, _finland, _france, _frenchGuiana, _frenchPolynesia, _frenchSouthernTerritories, _gabon, _gambia, _georgia, _germany, _ghana, _gibraltar, _greece, _greenland, _grenada, _guadeloupe, _guam, _guatemala, _guernsey, _guinea, _guineaBissau, _guyana, _haiti, _heardAndMcDonaldIslands, _holySeeCityVaticanState, _honduras, _hongKong, _hungary, _iceland, _india, _indonesia, _iranIslamicRepublicOf, _iraq, _ireland, _isleOfMan, _israel, _italy, _jamaica, _japan, _jersey, _jordan, _kazakhstan, _kenya, _kiribati, _koreaDemocraticPeoplesRepublic, _koreaRepublicOf, _kosovo, _kuwait, _kyrgyzstan, _laoPeoplesDemocraticRepublic, _latvia, _lebanon, _lesotho, _liberia, _libyanArabJamahiriya, _liechtenstein, _lithuania, _luxembourg, _macau, _macedonia, _madagascar, _malawi, _malaysia, _maldives, _mali, _malta, _marshallIslands, _martinique, _mauritania, _mauritius, _mayotte, _mexico, _micronesiaFederalStateOf, _moldovaRepublicOf, _monaco, _mongolia, _montenegro, _montserrat, _morocco, _mozambique, _myanmar, _namibia, _nauru, _nepal, _netherlands, _newCaledonia, _newZealand, _nicaragua, _niger, _nigeria, _niue, _norfolkIsland, _northernMarianaIslands, _norway, _oman, _pakistan, _palau, _palestinianTerritories, _panama, _papuaNewGuinea, _paraguay, _peru, _philippines, _pitcairnIsland, _poland, _portugal, _puertoRico, _qatar, _reunionIsland, _romania, _russianFederation, _rwanda, _saintBarthelemy, _saintHelena, _saintKittsAndNevis, _saintLucia, _saintMartin, _saintVincentAndTheGrenadines, _samoa, _sanMarino, _saoTomeAndPrincipe, _saudiArabia, _senegal, _serbia, _seychelles, _sierraLeone, _singapore, _sintMaarten, _slovakRepublic, _slovenia, _solomonIslands, _somalia, _southAfrica, _southGeorgia, _southSudan, _spain, _sriLanka, _stPierreAndMiquelon, _sudan, _suriname, _svalbardAndJanMayenIslands, _swaziland, _sweden, _switzerland, _syrianArabRepublic, _taiwan, _tajikistan, _tanzania, _thailand, _togo, _tokelau, _tonga, _trinidadAndTobago, _tunisia, _turkey, _turkmenistan, _turksAndCaicosIslands, _tuvalu, _uganda, _ukraine, _unitedArabEmirates, _unitedKingdomGB, _unitedStates, _uruguay, _uSMinorOutlyingIslands, _uzbekistan, _vanuatu, _venezuela, _vietnam, _virginIslandsBritish, _virginIslandsUSA, _wallisAndFutunaIslands, _westernSahara, _yemen, _zambia, _zimbabwe. |
TransactionShipAddress_ShipIsResidential | Boolean | False |
Opportunity テーブルのTransactionShipAddress_ShipIsResidential。 |
TransactionShipAddress_ShipPhone | String | False |
Opportunity テーブルのTransactionShipAddress_ShipPhone。 |
TransactionShipAddress_ShipState | String | False |
Opportunity テーブルのTransactionShipAddress_ShipState。 |
TransactionShipAddress_ShipZip | String | False |
Opportunity テーブルのTransactionShipAddress_ShipZip。 |
VatRegNum | String | False |
Opportunity テーブルのVatRegNum。 |
WeightedTotal | Double | False |
Opportunity テーブルのWeightedTotal。 |
WinLossReason_ExternalId | String | False |
Opportunity テーブルのWinLossReason_ExternalId。 |
WinLossReason_InternalId | String | False |
Opportunity テーブルのWinLossReason_InternalId。 |
WinLossReason_Name | String | False |
Opportunity テーブルのWinLossReason_Name。 |
WinLossReason_Type | String | False |
Opportunity テーブルのWinLossReason_Type。 The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose. |