SSIS Components for NetSuite

Build 24.0.9062

EntityGroup

NetSuite のEntityGroup テーブルです。

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

EntityGroup テーブルのInternalId。

CalendarDefaultView String False

EntityGroup テーブルのCalendarDefaultView。

The allowed values are _daily, _weekly, _monthly.

CalendarEndTime String False

EntityGroup テーブルのCalendarEndTime。

The allowed values are _1200am, _1230am, _100am, _130am, _200am, _230am, _300am, _330am, _400am, _430am, _500am, _530am, _600am, _630am, _700am, _730am, _800am, _830am, _900am, _930am, _1000am, _1030am, _1100am, _1130am, _noon, _1230pm, _100pm, _130pm, _200pm, _230pm, _300pm, _330pm, _400pm, _430pm, _500pm, _530pm, _600pm, _630pm, _700pm, _730pm, _800pm, _830pm, _900pm, _930pm, _1000pm, _1030pm, _1100pm, _1130pm.

CalendarName String False

EntityGroup テーブルのCalendarName。

CalendarPeriod String False

EntityGroup テーブルのCalendarPeriod。

The allowed values are _10minutes, _15minutes, _20minutes, _30minutes, _oneHour.

CalendarStartTime String False

EntityGroup テーブルのCalendarStartTime。

The allowed values are _1200am, _1230am, _100am, _130am, _200am, _230am, _300am, _330am, _400am, _430am, _500am, _530am, _600am, _630am, _700am, _730am, _800am, _830am, _900am, _930am, _1000am, _1030am, _1100am, _1130am, _noon, _1230pm, _100pm, _130pm, _200pm, _230pm, _300pm, _330pm, _400pm, _430pm, _500pm, _530pm, _600pm, _630pm, _700pm, _730pm, _800pm, _830pm, _900pm, _930pm, _1000pm, _1030pm, _1100pm, _1130pm.

Comments String False

EntityGroup テーブルのComments。

Email String False

EntityGroup テーブルのEmail。

ExternalId String False

EntityGroup テーブルのExternalId。

GroupName String False

EntityGroup テーブルのGroupName。

GroupOwner_ExternalId String False

EntityGroup テーブルのGroupOwner_ExternalId。

GroupOwner_InternalId String False

EntityGroup テーブルのGroupOwner_InternalId。

GroupOwner_Name String False

EntityGroup テーブルのGroupOwner_Name。

GroupOwner_Type String False

EntityGroup テーブルのGroupOwner_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.

GroupType String False

EntityGroup テーブルのGroupType。

The allowed values are _contact, _customer, _employee, _partner, _vendor.

IsFunctionalTeam Boolean False

EntityGroup テーブルのIsFunctionalTeam。

IsInactive Boolean False

EntityGroup テーブルのIsInactive。

IsManufacturingWorkCenter Boolean False

EntityGroup テーブルのIsManufacturingWorkCenter。

IsPrivate Boolean False

EntityGroup テーブルのIsPrivate。

IsProductTeam Boolean False

EntityGroup テーブルのIsProductTeam。

IsSalesRep Boolean False

EntityGroup テーブルのIsSalesRep。

IsSalesTeam Boolean False

EntityGroup テーブルのIsSalesTeam。

IsSavedSearch Boolean False

EntityGroup テーブルのIsSavedSearch。

IssueRole_ExternalId String False

EntityGroup テーブルのIssueRole_ExternalId。

IssueRole_InternalId String False

EntityGroup テーブルのIssueRole_InternalId。

IssueRole_Name String False

EntityGroup テーブルのIssueRole_Name。

IssueRole_Type String False

EntityGroup テーブルのIssueRole_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.

IsSupportRep Boolean False

EntityGroup テーブルのIsSupportRep。

LaborResources Long False

EntityGroup テーブルのLaborResources。

MachineResources Long False

EntityGroup テーブルのMachineResources。

ParentGroupType String False

EntityGroup テーブルのParentGroupType。

The allowed values are _contact, _customer, _employee, _partner, _vendor.

RestrictionGroup_ExternalId String False

EntityGroup テーブルのRestrictionGroup_ExternalId。

RestrictionGroup_InternalId String False

EntityGroup テーブルのRestrictionGroup_InternalId。

RestrictionGroup_Name String False

EntityGroup テーブルのRestrictionGroup_Name。

RestrictionGroup_Type String False

EntityGroup テーブルのRestrictionGroup_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.

SavedSearch_ExternalId String False

EntityGroup テーブルのSavedSearch_ExternalId。

SavedSearch_InternalId String False

EntityGroup テーブルのSavedSearch_InternalId。

SavedSearch_Name String False

EntityGroup テーブルのSavedSearch_Name。

SavedSearch_Type String False

EntityGroup テーブルのSavedSearch_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.

Subsidiary_ExternalId String False

EntityGroup テーブルのSubsidiary_ExternalId。

Subsidiary_InternalId String False

EntityGroup テーブルのSubsidiary_InternalId。

Subsidiary_Name String False

EntityGroup テーブルのSubsidiary_Name。

Subsidiary_Type String False

EntityGroup テーブルの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.

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