Power BI Connector for NetSuite

Build 24.0.9062

ItemFulfillment

NetSuite のItemFulfillment テーブルです。

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

ItemFulfillment テーブルのInternalId。

AccessibilityTypeFedEx String False

ItemFulfillment テーブルのAccessibilityTypeFedEx。

The allowed values are _accessible, _inaccessible.

AncillaryEndorsementFedEx String False

ItemFulfillment テーブルのAncillaryEndorsementFedEx。

The allowed values are _addressCorrection, _carrierLeaveIfNoResponse, _changeService, _forwardingService, _returnService.

B13aFilingOptionFedEx String False

ItemFulfillment テーブルのB13aFilingOptionFedEx。

The allowed values are _filedElectronically, _manuallyAttached, _notRequired, _summaryReporting.

B13aStatementDataFedEx String False

ItemFulfillment テーブルのB13aStatementDataFedEx。

BackupEmailAddressFedEx String False

ItemFulfillment テーブルのBackupEmailAddressFedEx。

BackupEmailAddressUps String False

ItemFulfillment テーブルのBackupEmailAddressUps。

BlanketEndDateUps Datetime False

ItemFulfillment テーブルのBlanketEndDateUps。

BlanketStartDateUps Datetime False

ItemFulfillment テーブルのBlanketStartDateUps。

BookingConfirmationNumFedEx String False

ItemFulfillment テーブルのBookingConfirmationNumFedEx。

CarrierIdUps String False

ItemFulfillment テーブルのCarrierIdUps。

CreatedDate Datetime False

ItemFulfillment テーブルのCreatedDate。

CreatedFrom_ExternalId String False

ItemFulfillment テーブルのCreatedFrom_ExternalId。

CreatedFrom_InternalId String False

ItemFulfillment テーブルのCreatedFrom_InternalId。

CreatedFrom_Name String False

ItemFulfillment テーブルのCreatedFrom_Name。

CreatedFrom_Type String False

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

CreatedFromShipGroup Long False

ItemFulfillment テーブルのCreatedFromShipGroup。

CustomForm_ExternalId String False

ItemFulfillment テーブルのCustomForm_ExternalId。

CustomForm_InternalId String False

ItemFulfillment テーブルのCustomForm_InternalId。

CustomForm_Name String False

ItemFulfillment テーブルのCustomForm_Name。

CustomForm_Type String False

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

EccNumberUps String False

ItemFulfillment テーブルのEccNumberUps。

Entity_ExternalId String False

ItemFulfillment テーブルのEntity_ExternalId。

Entity_InternalId String False

ItemFulfillment テーブルのEntity_InternalId。

Entity_Name String False

ItemFulfillment テーブルのEntity_Name。

Entity_Type String False

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

EntryNumberUps String False

ItemFulfillment テーブルのEntryNumberUps。

ExportTypeUps String False

ItemFulfillment テーブルのExportTypeUps。

The allowed values are _domesticExports, _foreignExports, _foreignMilitarySales.

ExternalId String False

ItemFulfillment テーブルのExternalId。

GenerateIntegratedShipperLabel Boolean False

ItemFulfillment テーブルのGenerateIntegratedShipperLabel。

HalAddr1FedEx String False

ItemFulfillment テーブルのHalAddr1FedEx。

HalAddr2FedEx String False

ItemFulfillment テーブルのHalAddr2FedEx。

HalAddr3FedEx String False

ItemFulfillment テーブルのHalAddr3FedEx。

HalCityFedEx String False

ItemFulfillment テーブルのHalCityFedEx。

HalCountryFedEx String False

ItemFulfillment テーブルのHalCountryFedEx。

HalPhoneFedEx String False

ItemFulfillment テーブルのHalPhoneFedEx。

HalStateFedEx String False

ItemFulfillment テーブルのHalStateFedEx。

HalZipFedEx String False

ItemFulfillment テーブルのHalZipFedEx。

HandlingCost Double False

ItemFulfillment テーブルのHandlingCost。

HazmatTypeFedEx String False

ItemFulfillment テーブルのHazmatTypeFedEx。

The allowed values are _dangerousGoods, _hazmat.

HoldAtLocationFedEx Boolean False

ItemFulfillment テーブルのHoldAtLocationFedEx。

HomeDeliveryDateFedEx Datetime False

ItemFulfillment テーブルのHomeDeliveryDateFedEx。

HomeDeliveryTypeFedEx String False

ItemFulfillment テーブルのHomeDeliveryTypeFedEx。

The allowed values are _appointment, _dateCertain, _evening.

InbondCodeUps String False

ItemFulfillment テーブルのInbondCodeUps。

InsideDeliveryFedEx Boolean False

ItemFulfillment テーブルのInsideDeliveryFedEx。

InsidePickupFedEx Boolean False

ItemFulfillment テーブルのInsidePickupFedEx。

IntlExemptionNumFedEx String False

ItemFulfillment テーブルのIntlExemptionNumFedEx。

IsCargoAircraftOnlyFedEx Boolean False

ItemFulfillment テーブルのIsCargoAircraftOnlyFedEx。

IsRoutedExportTransactionUps Boolean False

ItemFulfillment テーブルのIsRoutedExportTransactionUps。

ItemList_ReplaceAll Boolean False

ItemFulfillment テーブルのItemList_ReplaceAll。

LastModifiedDate Datetime False

ItemFulfillment テーブルのLastModifiedDate。

LicenseDateUps Datetime False

ItemFulfillment テーブルのLicenseDateUps。

LicenseExceptionUps String False

ItemFulfillment テーブルのLicenseExceptionUps。

The allowed values are _agr, _apr, _avs, _bag, _civ, _ctp, _enc, _gbs, _gft, _gov, _kmi, _lvs, _nlr, _rpl, _tmp, _tspa, _tsr, _tsu.

LicenseNumberUps String False

ItemFulfillment テーブルのLicenseNumberUps。

Memo String False

ItemFulfillment テーブルのMemo。

MethodOfTransportUps String False

ItemFulfillment テーブルのMethodOfTransportUps。

The allowed values are _air, _airContainerized, _auto, _fixedTransportInstallations, _mail, _passengerHandcarried, _pedestrian, _rail, _railContainerized, _roadOther, _seaBarge, _seaContainerized, _seaNoncontainerized, _truck, _truckContainerized.

PackageFedExList_ReplaceAll Boolean False

ItemFulfillment テーブルのPackageFedExList_ReplaceAll。

PackageList_ReplaceAll Boolean False

ItemFulfillment テーブルのPackageList_ReplaceAll。

PackageUpsList_ReplaceAll Boolean False

ItemFulfillment テーブルのPackageUpsList_ReplaceAll。

PackageUspsList_ReplaceAll Boolean False

ItemFulfillment テーブルのPackageUspsList_ReplaceAll。

PartiesToTransactionUps Boolean False

ItemFulfillment テーブルのPartiesToTransactionUps。

Partner_ExternalId String False

ItemFulfillment テーブルのPartner_ExternalId。

Partner_InternalId String False

ItemFulfillment テーブルのPartner_InternalId。

Partner_Name String False

ItemFulfillment テーブルのPartner_Name。

Partner_Type String False

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

PostingPeriod_ExternalId String False

ItemFulfillment テーブルのPostingPeriod_ExternalId。

PostingPeriod_InternalId String False

ItemFulfillment テーブルのPostingPeriod_InternalId。

PostingPeriod_Name String False

ItemFulfillment テーブルのPostingPeriod_Name。

PostingPeriod_Type String False

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

RecipientTaxIdUps String False

ItemFulfillment テーブルのRecipientTaxIdUps。

SaturdayDeliveryFedEx Boolean False

ItemFulfillment テーブルのSaturdayDeliveryFedEx。

SaturdayDeliveryUps Boolean False

ItemFulfillment テーブルのSaturdayDeliveryUps。

SaturdayPickupFedex Boolean False

ItemFulfillment テーブルのSaturdayPickupFedex。

SendBackupEmailFedEx Boolean False

ItemFulfillment テーブルのSendBackupEmailFedEx。

SendBackupEmailUps Boolean False

ItemFulfillment テーブルのSendBackupEmailUps。

SendShipNotifyEmailFedEx Boolean False

ItemFulfillment テーブルのSendShipNotifyEmailFedEx。

SendShipNotifyEmailUps Boolean False

ItemFulfillment テーブルのSendShipNotifyEmailUps。

ShipAddress String False

ItemFulfillment テーブルのShipAddress。

ShipAddressList_ExternalId String False

ItemFulfillment テーブルのShipAddressList_ExternalId。

ShipAddressList_InternalId String False

ItemFulfillment テーブルのShipAddressList_InternalId。

ShipAddressList_Name String False

ItemFulfillment テーブルのShipAddressList_Name。

ShipAddressList_Type String False

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

ShipDateFedEx Datetime False

ItemFulfillment テーブルのShipDateFedEx。

ShipGroupList_ReplaceAll Boolean False

ItemFulfillment テーブルのShipGroupList_ReplaceAll。

ShipmentWeightFedEx Double False

ItemFulfillment テーブルのShipmentWeightFedEx。

ShipmentWeightUps Double False

ItemFulfillment テーブルのShipmentWeightUps。

ShipMethod_ExternalId String False

ItemFulfillment テーブルのShipMethod_ExternalId。

ShipMethod_InternalId String False

ItemFulfillment テーブルのShipMethod_InternalId。

ShipMethod_Name String False

ItemFulfillment テーブルのShipMethod_Name。

ShipMethod_Type String False

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

ShipNotifyEmailAddress2Ups String False

ItemFulfillment テーブルのShipNotifyEmailAddress2Ups。

ShipNotifyEmailAddressFedEx String False

ItemFulfillment テーブルのShipNotifyEmailAddressFedEx。

ShipNotifyEmailAddressUps String False

ItemFulfillment テーブルのShipNotifyEmailAddressUps。

ShipNotifyEmailMessageUps String False

ItemFulfillment テーブルのShipNotifyEmailMessageUps。

ShippingCost Double False

ItemFulfillment テーブルのShippingCost。

ShipStatus String False

ItemFulfillment テーブルのShipStatus。

The allowed values are _packed, _picked, _shipped.

SignatureHomeDeliveryFedEx Boolean False

ItemFulfillment テーブルのSignatureHomeDeliveryFedEx。

TermsFreightChargeFedEx Double False

ItemFulfillment テーブルのTermsFreightChargeFedEx。

TermsInsuranceChargeFedEx Double False

ItemFulfillment テーブルのTermsInsuranceChargeFedEx。

TermsOfSaleFedEx String False

ItemFulfillment テーブルのTermsOfSaleFedEx。

The allowed values are _fob, _cf, _cif.

ThirdPartyAcctFedEx String False

ItemFulfillment テーブルのThirdPartyAcctFedEx。

ThirdPartyAcctUps String False

ItemFulfillment テーブルのThirdPartyAcctUps。

ThirdPartyCountryFedEx String False

ItemFulfillment テーブルのThirdPartyCountryFedEx。

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.

ThirdPartyCountryUps String False

ItemFulfillment テーブルのThirdPartyCountryUps。

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.

ThirdPartyTypeFedEx String False

ItemFulfillment テーブルのThirdPartyTypeFedEx。

The allowed values are _billRecipient, _billThirdParty, _noneSelected.

ThirdPartyTypeUps String False

ItemFulfillment テーブルのThirdPartyTypeUps。

The allowed values are _consigneeBilling, _noneSelected, _thirdPartyBilling.

ThirdPartyZipcodeUps String False

ItemFulfillment テーブルのThirdPartyZipcodeUps。

TranDate Datetime False

ItemFulfillment テーブルのTranDate。

TranId String False

ItemFulfillment テーブルのTranId。

TransactionShipAddress_ShipAddr1 String False

ItemFulfillment テーブルのTransactionShipAddress_ShipAddr1。

TransactionShipAddress_ShipAddr2 String False

ItemFulfillment テーブルのTransactionShipAddress_ShipAddr2。

TransactionShipAddress_ShipAddr3 String False

ItemFulfillment テーブルのTransactionShipAddress_ShipAddr3。

TransactionShipAddress_ShipAddressee String False

ItemFulfillment テーブルのTransactionShipAddress_ShipAddressee。

TransactionShipAddress_ShipAttention String False

ItemFulfillment テーブルのTransactionShipAddress_ShipAttention。

TransactionShipAddress_ShipCity String False

ItemFulfillment テーブルのTransactionShipAddress_ShipCity。

TransactionShipAddress_ShipCountry String False

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

ItemFulfillment テーブルのTransactionShipAddress_ShipIsResidential。

TransactionShipAddress_ShipPhone String False

ItemFulfillment テーブルのTransactionShipAddress_ShipPhone。

TransactionShipAddress_ShipState String False

ItemFulfillment テーブルのTransactionShipAddress_ShipState。

TransactionShipAddress_ShipZip String False

ItemFulfillment テーブルのTransactionShipAddress_ShipZip。

TransferLocation_ExternalId String False

ItemFulfillment テーブルのTransferLocation_ExternalId。

TransferLocation_InternalId String False

ItemFulfillment テーブルのTransferLocation_InternalId。

TransferLocation_Name String False

ItemFulfillment テーブルのTransferLocation_Name。

TransferLocation_Type String False

ItemFulfillment テーブルのTransferLocation_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