SSIS Components for NetSuite

Build 24.0.9062

Nexus

NetSuite のNexus テーブルです。

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

Nexus テーブルのInternalId。

Country String False

Nexus テーブルのCountry。

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.

Description String False

Nexus テーブルのDescription。

ExternalId String False

Nexus テーブルのExternalId。

State_ExternalId String False

Nexus テーブルのState_ExternalId。

State_InternalId String False

Nexus テーブルのState_InternalId。

State_Name String False

Nexus テーブルのState_Name。

State_Type String False

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

TaxAgency_ExternalId String False

Nexus テーブルのTaxAgency_ExternalId。

TaxAgency_InternalId String False

Nexus テーブルのTaxAgency_InternalId。

TaxAgency_Name String False

Nexus テーブルのTaxAgency_Name。

TaxAgency_Type String False

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

TaxAgencyPst_ExternalId String False

Nexus テーブルのTaxAgencyPst_ExternalId。

TaxAgencyPst_InternalId String False

Nexus テーブルのTaxAgencyPst_InternalId。

TaxAgencyPst_Name String False

Nexus テーブルのTaxAgencyPst_Name。

TaxAgencyPst_Type String False

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

TaxCode_ExternalId String False

Nexus テーブルのTaxCode_ExternalId。

TaxCode_InternalId String False

Nexus テーブルのTaxCode_InternalId。

TaxCode_Name String False

Nexus テーブルのTaxCode_Name。

TaxCode_Type String False

Nexus テーブルのTaxCode_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