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 | 支払期日。 |
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 で利用可能な処理に比べてより複雑な処理を行うことができます。 |