ODBC Driver for NetSuite

Build 23.0.8839

Transactions

NetSuite のトランザクションのビュー。

Columns

Name Type Description
InternalId [KEY] String トランザクションのInternalId。
Type String トランザクションのタイプ。

The allowed values are _assemblyBuild, _assemblyUnbuild, _binTransfer, _binWorksheet, _cashRefund, _cashSale, _check, _creditMemo, _custom, _customerDeposit, _customerPayment, _customerRefund, _deposit, _depositApplication, _estimate, _expenseReport, _inventoryAdjustment, _inventoryCostRevaluation, _inventoryTransfer, _invoice, _itemFulfillment, _itemReceipt, _journal, _opportunity, _paycheckJournal, _purchaseOrder, _requisition, _returnAuthorization, _salesOrder, _transferOrder, _vendorBill, _vendorCredit, _vendorPayment, _vendorReturnAuthorization, _workOrder, _workOrderClose, _workOrderCompletion, _workOrderIssue.

Account_InternalId String アカウントのInternalId。
Account_Name String アカウント名。
Amount Double トランザクションの金額。
BillingAddress String 請求先の住所。
BillingAccount_InternalId String 請求先アカウントのInternalId。
BillingAccount_Name String 請求先アカウント名。
CloseDate Datetime クローズされた日付。
CreatedDate Datetime 作成された日付。
CreatedFrom_InternalId String Id から作成。
Currency_InternalId String 通貨Id。
Currency_Name String 通貨名。
CustomForm_InternalId String カスタムフォームId。
CustomForm_Name String カスタムフォーム名。
DueDate Datetime 支払期日。
Email String E メールアドレス。
EndDate Datetime 終了日。
Entity_InternalId String エンティティId。
Entity_Name String エンティティ名。
Entity_Type String エンティティのタイプ。

The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, billingAccount, billingSchedule, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, charge, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customTransaction, customTransactionType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, deposit, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, globalAccountMapping, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryCostRevaluation, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemAccountMapping, 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, purchaseRequisition, resourceAllocation, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, statisticalJournalEntry, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxAcct, taxGroup, taxType, term, timeBill, timeSheet, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose.

ExchangeRate Double 為替レート。
ExpectedCloseDate Datetime 予定終了日。
ExternalId String トランザクションのExternalId。
Fob String E メールアドレス。
IntercoTransaction_InternalId String 会社間トランザクションId。
Job_InternalId Job ジョブId。
Job_Name Job ジョブ名。
LastModifiedDate Datetime 最終更新日。
LeadSource_InternalId String リードのソースId。
LeadSource_Name String リードのソース名。
LeadSource_Type String リードのソースタイプ。

The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, billingAccount, billingSchedule, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, charge, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customTransaction, customTransactionType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, deposit, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, globalAccountMapping, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryCostRevaluation, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemAccountMapping, 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, purchaseRequisition, resourceAllocation, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, statisticalJournalEntry, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxAcct, taxGroup, taxType, term, timeBill, timeSheet, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose.

Location_InternalId String ロケーションId。
Location_Name String ロケーション名。
Memo String メモ。
Message String メッセージ。
Partner_InternalId String パートナーId。
Partner_Name String パートナー名。
PnRefNum String P/N Ref。
Probability Double 取引の確率。
ProjectedAmount Double 見積金額.
PromoCode_InternalId String クーポンコードId。
PromoCode_Name String クーポンコード名。
SalesEffectiveDate Datetime セールス有効日。
SalesRep_InternalId String セールスレップId。
SalesRep_Name String セールスレップ名。
Source String ソース。
StartDate Datetime 開始日。
Status String ステータス。

The allowed values are _adp, _automatedMemorizedTransaction, _csv, _customerCenter, _ebay, _mobile, _offlineClient, _perquest, _qif, _quickbooks, _smbxml, _sync, _web, _webServices, _yahoo.

Terms_InternalId String タームId。
Terms_Name String ターム名。
Title String タイトル。
TranDate Datetime 取引日。
TranId String ドキュメント番号/Id。
TransactionNumber String トランザクション番号。

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
SavedSearchId String 保存検索のInternalId を指定します。これは、資格情報を直接クエリに提供する代わりに行う処理です。検索結果はNetSuite 側に格納され、Web API で利用可能な処理に比べてより複雑な処理を行うことができます。

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839