🔍 Dynamics 365 Field Usage Report

Comprehensive analysis of which fields are actually used in the codebase for each endpoint

← Endpoint Audit🔍 Date Filter Test
⏱️ Note: This analysis scans the entire codebase. It may take 5-10 seconds to complete...
✅ Analysis complete in 0.18 seconds

Total Endpoints

35

With Field Usage

23

Total Fields Found

116

Avg Fields/Endpoint

5
📥 Export as CSV

🏆 Top 10 Most Used Fields

These fields are used most frequently across all endpoints

#1SalesPriceAgreement
📊 32 usages across 2 endpoints
#2VERProductConfigCombinationCode
📊 25 usages across 4 endpoints
#3ItemNumber
📊 21 usages across 6 endpoints
#4OptionShortCode
📊 14 usages across 5 endpoints
#5CharacteristicShortCode
📊 13 usages across 3 endpoints
#6FinishShortCode
📊 12 usages across 3 endpoints
#7SizeCode
📊 12 usages across 2 endpoints
#8ProductSpecificOrderSettings
📊 11 usages across 1 endpoint
#9ProductMasterCharacteristicOptions
📊 10 usages across 2 endpoints
#10SalesPriceAgreements
📊 10 usages across 1 endpoint
Quick Filters:
⏱️ Fetching field data from D365 API... This may take a moment. Enable Debug Mode
D365 API Field Fetch Status: ✓ 34 successful | ⚠ 1 failed
Failed endpoints will only show fields detected in code, not unused fields from D365. Enable Debug Mode to see details.
Show failed endpoints details
  • VERTariffRates (failed in 609.42ms)
    HTTP Error: 404
ReleasedProductsV2 ✓ API
28 used / 336 total

✅ Used Fields (28)

ItemNumber
Used 3 times in 2 files
dynamics-product-manager.class.phpdynamics-api.class.php
NetProductWeight
Used 1 time in 1 file
Product Spec Config
PackingDutyQuantity
Used 1 time in 1 file
Product Spec Config
ProductVolume
Used 1 time in 1 file
Product Spec Config
ProductionConsumptionDepthConversionFactor
Used 1 time in 1 file
Product Spec Config
ProductionConsumptionWidthConversionFactor
Used 1 time in 1 file
Product Spec Config
SearchName
Used 1 time in 1 file
dynamics-api.class.php
SheaCOLRequirement
Used 1 time in 1 file
Product Spec Config
SheaCOMRequirement
Used 1 time in 1 file
Product Spec Config
SheaCartonWeight
Used 1 time in 1 file
Product Spec Config
SheaFoldedDepth
Used 1 time in 1 file
Product Spec Config
SheaFoldedHeight
Used 1 time in 1 file
Product Spec Config
SheaFolding
Used 1 time in 1 file
Product Spec Config
SheaItemAdjustableHeight
Used 1 time in 1 file
Product Spec Config
SheaItemArmHeight
Used 1 time in 1 file
Product Spec Config
SheaItemMaxArmHeight
Used 1 time in 1 file
Product Spec Config
SheaItemMaxOverallHeight
Used 1 time in 1 file
Product Spec Config
SheaItemMaxSeatHeight
Used 1 time in 1 file
Product Spec Config
SheaItemMinArmHeight
Used 1 time in 1 file
Product Spec Config
SheaItemMinOverallHeight
Used 1 time in 1 file
Product Spec Config
SheaItemMinSeatHeight
Used 1 time in 1 file
Product Spec Config
SheaItemOverallHeight
Used 1 time in 1 file
Product Spec Config
SheaItemSeatHeight
Used 1 time in 1 file
Product Spec Config
SheaSandlerWebstatus
Used 3 times in 2 files
dynamics-product-manager.class.phpdynamics-api.class.php
SheaStacking
Used 1 time in 1 file
Product Spec Config
SheaStackingQuantity
Used 1 time in 1 file
Product Spec Config
SheaTrolleyStackingQuantity
Used 1 time in 1 file
Product Spec Config
SheaWebText
Used 2 times in 1 file
dynamics-caches.class.php

❌ Unused Fields (308)

@odata.etagAlternativeItemNumberAlternativeProductColorIdAlternativeProductConfigurationIdAlternativeProductSizeIdAlternativeProductStyleIdAlternativeProductUsageConditionAlternativeProductVersionIdApprovedVendorCheckMethodApproximateSalesTaxPercentageAreTransportationManagementProcessesEnabledArrivalHandlingTimeBOMLevelBOMUnitSymbolBarcodeSetupIdBasePricePurchaseBaseSalesPriceSourceBatchMergeDateCalculationMethodBatchNumberGroupCodeBestBeforePeriodDaysBundleBuyerGroupIdCNPJCarryingCostABCCodeCatchWeightItemHandlingPolicyNameCatchWeightUnitSymbolCommissionProductGroupIdCommodityCodeIdComparisonPriceBaseUnitSymbolConstantScrapQuantityContinuityEventDurationContinuityScheduleIdCostCalculationBOMLevelCostCalculationGroupIdCostChargesQuantityCostGroupIdCustomsDescriptionCustomsExportTariffCodeCustomsImportTariffCodeDefaultDirectDeliveryWarehouseDefaultLedgerDimensionDisplayValueDefaultOrderTypeDefaultProductColorIdDefaultProductConfigurationIdDefaultProductSizeIdDefaultProductStyleIdDefaultProductVersionIdDefaultReceivingQuantityDualUseCodeEighthProductFilterCodeExemptFifthProductFilterCodeFirstProductFilterCodeFirstProductFilterGroupIdFixedCostChargesFixedPurchasePriceChargesFixedSalesPriceChargesFlushingPrincipleFourthProductFilterCodeFreightAllocationGroupIdGrossDepthGrossProductHeightGrossProductWidthHSNCodeIntrastatChargePercentageIntrastatCommodityCodeInventoryCountingReasonCodePolicyNameInventoryGSTReliefCategoryCodeInventoryReservationHierarchyNameInventoryUnitSymbolIsBatchNumberActiveIsCatchWeightProductIsDeliveredDirectlyIsDiscountPOSRegistrationProhibitedIsDualUseProductIsExemptFromAutomaticNotificationAndCancellationIsHazardousMaterialIsICMSTaxAppliedOnServiceIsInstallmentEligibleIsIntercompanyPurchaseUsageBlockedIsIntercompanySalesUsageBlockedIsIntrastatExcludedIsManualDiscountPOSRegistrationProhibitedIsPOSRegistrationBlockedIsPOSRegistrationQuantityNegativeIsPhantomIsPurchasePriceAutomaticallyUpdatedIsPurchasePriceIncludingChargesIsPurchaseWithholdingTaxCalculatedIsRestrictedForCouponsIsRetailDiscountPOSRegistrationProhibitedIsSalesPriceAdjustmentAllowedIsSalesPriceIncludingChargesIsSalesWithholdingTaxCalculatedIsScaleProductIsSelfCheckoutRegistrationBlockedIsSerialNumberActiveIsShipAloneEnabledIsTenderDiscountPOSRegistrationProhibitedIsUnitCostAutomaticallyUpdatedIsUnitCostIncludingChargesIsUnitCostProductVariantSpecificIsVariantShelfLabelsPrintingEnabledIsZeroPricePOSRegistrationAllowedItemFiscalClassificationCodeItemFiscalClassificationExceptionCodeItemModelGroupIdItemOverUnderdeliveryToleranceGroupIdKeyInPriceRequirementsAtPOSRegisterKeyInQuantityRequirementsAtPOSRegisterLandedCostTypeGroupIdLowerWarrantablePriceRangeLimitMarginABCCodeMaterialOverpickPercentageMaximumCatchWeightQuantityMaximumPickQuantityMinimumCatchWeightQuantityMustKeyInCommentAtPOSRegisterNGPCodeNecessaryProductionWorkingTimeSchedulingPropertyIdNinthProductFilterCodeNonGSTOriginCountryRegionIdOriginStateIdPKWiUCodePOSRegistrationActivationDatePOSRegistrationBlockedDatePOSRegistrationPlannedBlockedDatePackSizeCategoryIdPackageClassIdPackageHandlingTimePackingMaterialGroupIdPhysicalDimensionGroupIdPlanningFormulaItemNumberPotencyBaseAttibuteTargetValuePotencyBaseAttributeValueEntryEventPrimaryVendorAccountNumberProductCoverageGroupIdProductDimensionGroupNameProductFiscalInformationTypeProductGroupIdProductLifeCycleSeasonCodeProductLifeCycleValidFromDateProductLifeCycleValidToDateProductLifecycleStateIdProductNumberProductSearchNameProductSubTypeProductTaxationOriginProductTypeProductionConsumptionDensityConversionFactorProductionConsumptionHeightConversionFactorProductionGroupIdProductionPoolIdProductionTypeProjectCategoryIdPurchaseChargeProductGroupIdPurchaseChargesQuantityPurchaseGSTReliefCategoryCodePurchaseItemWithholdingTaxGroupCodePurchaseLineDiscountProductGroupCodePurchaseMultilineDiscountProductGroupCodePurchaseOverdeliveryPercentagePurchasePricePurchasePriceDatePurchasePriceQuantityPurchasePriceToleranceGroupIdPurchasePricingPrecisionPurchaseRebateProductGroupIdPurchaseSalesTaxItemGroupCodePurchaseSupplementaryProductProductGroupIdPurchaseUnderdeliveryPercentagePurchaseUnitSymbolQMSAllowOnlyAuthorizedPersonnelForDispensingQMSApprovedCustomerListCheckMethodQMSApprovedItemGroupIdQMSIsDispensingControlAppliedQMSOverDispensePercentageQMSUnderDispensePercentageRawMaterialPickingPrincipleRawMaterialPickingPrincipleNonLicensePlateLocationsRevRecBundleRevRecDefaultRevenueRecognitionScheduleRevRecExcludeFromCarveOutRevRecMedianPriceRevRecMedianPriceMaximumToleranceRevRecMedianPriceMinimumToleranceRevRecRevenueRecognitionEnabledRevRecRevenueTypeRevenueABCCodeSADGroupSATCodeSalesChargeProductGroupIdSalesChargesQuantitySalesGSTReliefCategoryCodeSalesItemWithholdingTaxGroupCodeSalesLineDiscountProductGroupCodeSalesMultilineDiscountProductGroupCodeSalesOverdeliveryPercentageSalesPriceSalesPriceCalculationChargesPercentageSalesPriceCalculationContributionRatioSalesPriceCalculationModelSalesPriceDateSalesPriceQuantitySalesPricingPrecisionSalesRebateProductGroupIdSalesRetailInventoryAvailabilityBufferSalesRetailInventoryAvailabilityLevelProfileSalesSalesTaxItemGroupCodeSalesSupplementaryProductProductGroupIdSalesUnderdeliveryPercentageSalesUnitSymbolScaleIndicatorSecondProductFilterCodeSecondProductFilterGroupIdSellEndDateSellStartDateSerialNumberGroupCodeServiceAccountingCodeServiceFiscalInformationCodeServiceTypeSeventhProductFilterCodeShea2019NetPricingSheaArticleSheaBifmaSheaBigSofaUpchargeAmountSheaBigSofaUpchargeApplicableSheaCAL117SheaCatalogueCollectionSheaCountryOfHarvestSheaDateOfChangeSheaDateOfRequestSheaDescriptionOfMerchandiseSheaDesignerNameSheaFabricRequiredSheaGSASuitableSheaGSAWaveSheaGSAWebStatusSheaGradedInSheaLACEYStatusSheaLeatherMinOrderQuantitySheaNetPricingNewSheaPlantScientificNameSheaQuantityOfPlantMaterialSheaReasonForChangeSheaRowTariffCodeSheaSANTariffDescriptionSheaSINSheaSandlerSupplierSheaShippingClassSheaSmallSofaUpchargeAmountSheaSmallSofaUpchargeApplicableSheaSoldInUSSheaTSCAStatusSheaUSHSTCTariffCodeSheaUnitLaceySheaUpholsteredSheaUpholsteredInUKSheaVendorPreOrderSheaWebIDSheaWhoMadeTheChangeSheawhoRequestedTheChangeShelfAdvicePeriodDaysShelfLifePeriodDaysShipStartDateShippingAndReceivingSortOrderCodeSixthProductFilterCodeStorageDimensionGroupNameTareProductWeightTaxRateTypeTaxSubstitutionCodeTenthProductFilterCodeThirdProductFilterCodeTrackedComponentsPolicyIdTrackingDimensionGroupNameTransferOrderLandedCostGroupIdTransferOrderOverdeliveryPercentageTransferOrderUnderdeliveryPercentageUnitConversionSequenceGroupIdUnitCostUnitCostDateUnitCostQuantityUpdateProductVariantLifecycleStateUpperWarrantablePriceRangeLimitVERADASuitableValueABCCodeVariableScrapPercentageVendorInvoiceLineMatchingPolicyVoyageArrivalGroupIdWarehouseBatchDetailsCapturePolicyWarehouseBomReleaseReservationRequirementRuleWarehouseFilterCodeWarehouseFilterGroupWarehouseMobileDeviceDescriptionLine1WarehouseMobileDeviceDescriptionLine2WarehouseReleaseSalesUnitRestrictedWarrantablePriceRangeBaseTypeWarrantyDurationTimeWarrantyDurationTimeUnitWillInventoryIssueAutomaticallyReportAsFinishedWillInventoryReceiptIgnoreFlushingPrincipleWillPickingWorkbenchApplyBoxingLogicWillTotalPurchaseDiscountCalculationIncludeProductWillTotalSalesDiscountCalculationIncludeProductWillWorkCenterPickingAllowNegativeInventoryYieldPercentagedataAreaId
SalesPriceAgreements ✓ API
18 used / 31 total

✅ Used Fields (18)

FromQuantity
Used 2 times in 2 files
dynamics-api.class.phpsingle-dynamics_product.php
ItemNumber
Used 3 times in 2 files
dynamics-api.class.phpdynamics-api-quote-details.class.php
Price
Used 7 times in 4 files
dynamics-api.class.phpdynamics-api-quote-details.class.phpsingle-dynamics_product.php+1 more
PriceApplicableFromDate
Used 9 times in 3 files
dynamics-api.class.phpdynamics-api-quote-details.class.phpactions.php
PriceApplicableToDate
Used 4 times in 2 files
dynamics-api.class.phpdynamics-api-quote-details.class.php
PriceCurrencyCode
Used 2 times in 2 files
dynamics-api.class.phpdynamics-api-quote-details.class.php
PriceCustomerGroupCode
Used 3 times in 2 files
dynamics-api.class.phpdynamics-api-quote-details.class.php
ProductStyleId
Used 5 times in 3 files
dynamics-api.class.phpdynamics-api-quote-details.class.phpsingle-dynamics_product.php
ToQuantity
Used 2 times in 2 files
dynamics-api.class.phpsingle-dynamics_product.php
VERProductConfigCombinationCode
Used 18 times in 5 files
AddToBasketEndpoint.phpCET-import.class.phpdynamics-api.class.php+2 more

❌ Unused Fields (21)

@odata.etagAttributeBasedPricingIdCustomerAccountNumberFixedPriceChargesIsGenericCurrencySearchEnabledPriceSiteIdPriceWarehouseIdProductColorIdProductNumberProductSizeIdProductVersionIdProductconfigurationIdQuantityUnitySymbolRecordIdSalesLeadTimeDaysSalesPriceQuantityVERItemCodeVERItemRelationWillDeliveryDateControlDisregardLeadTimeWillSearchContinuedataAreaId
ProductMasterOptionFinishes ✓ API
8 used / 9 total

✅ Used Fields (8)

FinishShortCode
Used 6 times in 4 files
dynamics-product-manager.class.phpdynamics-caches.class.phpdynamics-api.class.php+1 more
OptionShortCode
Used 4 times in 3 files
dynamics-api.class.phpdynamics-product-detail.class.phpsingle-dynamics_product.php

❌ Unused Fields (7)

@odata.etagFinishFriendlyNameFinishNameFinishStatusOptionFriendlyNameOptionNameProductNumber
CustomerMaterials ✓ API
8 used / 8 total

✅ Used Fields (8)

Collection
Used 2 times in 2 files
dynamics-com-database.class.phpactions.php
FabricName
Used 1 time in 1 file
actions.php
MaterialId
Used 3 times in 2 files
dynamics-com-database.class.phpactions.php
MaterialType
Used 5 times in 1 file
dynamics-com-database.class.php
ReferenceNumber
Used 1 time in 1 file
actions.php
VendorName
Used 2 times in 2 files
dynamics-com-database.class.phpactions.php

❌ Unused Fields (2)

@odata.etagdataAreaId
ProductMasterCharacteristics ✓ API
6 used / 6 total

✅ Used Fields (6)

CharacteristicShortCode
Used 5 times in 2 files
dynamics-finishes-gathered.class.phpdynamics-product-detail.class.php
CharacteristicStatus
Used 3 times in 2 files
dynamics-finishes-gathered.class.phpdynamics-product-detail.class.php

❌ Unused Fields (4)

@odata.etagCharacteristicFriendlyNameCharacteristicNameProductNumber
SalesOrderHeaderChargesV2 ✓ API
5 used / 16 total

✅ Used Fields (5)

ChargeDescription
Used 1 time in 1 file
actions.php
FixedChargeAmount
Used 1 time in 1 file
actions.php
SalesChargeCode
Used 1 time in 1 file
actions.php
SalesOrderNumber
Used 1 time in 1 file
actions.php

❌ Unused Fields (12)

@odata.etagChargeAccountingCurrencyCodeChargeCategoryChargeLineNumberChargePercentageExternalChargeAmountIsIntercompanyChargeOverrideSalesTaxSalesTaxGroupCodeSalesTaxItemGroupCodeWillInvoiceProcessingKeepChargedataAreaId
ProductMasterCharacteristicOptions ✓ API
5 used / 9 total

✅ Used Fields (5)

CharacteristicShortCode
Used 7 times in 3 files
dynamics-api.class.phpdynamics-product-detail.class.phpsingle-dynamics_product.php
OptionShortCode
Used 4 times in 3 files
dynamics-api.class.phpdynamics-product-detail.class.phpsingle-dynamics_product.php
OptionStatus
Used 3 times in 2 files
dynamics-api.class.phpdynamics-product-detail.class.php

❌ Unused Fields (6)

@odata.etagCharacteristicFriendlyNameCharacteristicNameOptionFriendlyNameOptionNameProductNumber
ProductConfigOptionFinishes ✓ API
5 used / 3 total

✅ Used Fields (5)

FinishShortCode
Used 4 times in 2 files
CET-data.class.phpdynamics-options-admin.class.php
OptionShortCode
Used 3 times in 2 files
CET-data.class.phpdynamics-options-admin.class.php

❌ Unused Fields (1)

@odata.etag
SalesDiscountCodes ✓ API
5 used / 4 total

✅ Used Fields (5)

DiscountCode
Used 1 time in 1 file
dynamics-api.class.php
DiscountPercent
Used 1 time in 1 file
dynamics-api.class.php

❌ Unused Fields (2)

@odata.etagdataAreaId
ProductFinishChargeItems ✓ API
5 used / 6 total

✅ Used Fields (5)

ChargeItemNumber
Used 4 times in 2 files
dynamics-api.class.phpsingle-dynamics_product.php
FinishShortCode
Used 2 times in 2 files
dynamics-api.class.phpsingle-dynamics_product.php
ItemNumber
Used 2 times in 2 files
dynamics-api.class.phpsingle-dynamics_product.php

❌ Unused Fields (3)

@odata.etagdataAreaIdfinishChargeTypeEnumAW
ProductSpecificOrderSettingsV3 ✓ API
4 used / 65 total

✅ Used Fields (4)

MinimumSalesOrderQuantity
Used 4 times in 2 files
dynamics-product-detail.class.phpsingle-dynamics_product.php
SalesQuantityMultiples
Used 4 times in 2 files
dynamics-product-detail.class.phpsingle-dynamics_product.php
VERProductConfigCombinationCode
Used 2 times in 1 file
dynamics-api.class.php

❌ Unused Fields (62)

@odata.etagAreInventoryDefaultOrderSettingsOverriddenAreProcurementDefaultOrderSettingsOverriddenAreSalesDefaultOrderSettingsOverriddenGUPDiscountClaimVendorAccountInventoryATPBackwardDemandTimeFenceDaysInventoryATPBackwardSupplyTimeFenceDaysInventoryATPDelayedDemandOffsetDaysInventoryATPDelayedSupplyOffsetDaysInventoryATPTimeFenceDaysInventoryLeadTimeDaysInventoryOrderPromisingMethodInventoryQuantityMultiplesInventorySiteIdInventoryWarehouseIdIsDefaultInventoryStorageDimensionOverriddenIsDefaultProcurementStorageDimensionOverriddenIsDefaultSalesStorageDimensionOverriddenIsInventoryATPIncludingPlannedOrdersIsInventoryProcessingStoppedIsInventorySiteMandatoryIsInventoryUsingWorkingDaysIsInventoryWarehouseMandatoryIsProcurementProcessingstoppedIsProcurementSiteMandatoryIsProcurementUsingWorkingDaysIsProcurementWarehouseMandatoryIsSalesATPIncludingPlannedOrdersIsSalesLeadTimeOverriddenIsSalesProcessingStoppedIsSalesSiteMandatoryIsSalesWarehouseMandatoryItemNumberMaximumInventoryOrderQuantityMaximumProcurementOrderQuantityMaximumSalesOrderQuantityMinimumInventoryOrderQuantityMinimumProcurementOrderQuantityOperationalSiteIdOrderSettingsRankProcurementLeadTimeDaysProcurementQuantityMultiplesProcurementSiteIdProcurementWarehouseIdProductColorIdProductConfigurationIdProductSizeIdProductStyleIdProductVersionIdSalesATPBackwardDemandTimeFenceDaysSalesATPBackwardSupplyTimeFenceDaysSalesATPDelayedDemandOffsetDaysSalesATPDelayedSupplyOffsetDaysSalesATPTimeFenceDaysSalesLeadTimeDaysSalesOrderPromisingMethodSalesSiteIdSalesWarehouseIdStandardInventoryOrderQuantityStandardProcurementOrderQuantityStandardSalesOrderQuantitydataAreaId
ProductConfigOptions ✓ API
3 used / 6 total

✅ Used Fields (3)

OptionName
Used 1 time in 1 file
dynamics-options-admin.class.php
OptionShortCode
Used 2 times in 1 file
dynamics-options-admin.class.php
OptionStatus
Used 2 times in 1 file
dynamics-options-admin.class.php

❌ Unused Fields (3)

@odata.etagOptionDescriptionOptionFriendlyName
ProductSizeMappings ✓ API
3 used / 4 total

✅ Used Fields (3)

ItemNumber
Used 11 times in 5 files
CompatibilityService.phpdynamics-configurator.class.phpCET-data.class.php+2 more
SizeCode
Used 9 times in 4 files
CompatibilityService.phpdynamics-configurator.class.phpCET-data.class.php+1 more

❌ Unused Fields (2)

@odata.etagdataAreaId
SalesOrderLines ✓ API
2 used / 236 total

✅ Used Fields (2)

ProductStyleId
Used 1 time in 1 file
actions.php
VERProductConfigCombinationCode
Used 1 time in 1 file
actions.php

❌ Unused Fields (234)

@odata.etagAllowedOverdeliveryPercentageAllowedUnderdeliveryPercentageBOMIdBundleLineStatusBundleLineTypeCFOPCodeCalculateLineAmountCatalogCommissionSalesRepresentativeGroupIdConfirmedReceiptDateConfirmedShippingDateCreditNoteReasonCodeCurrencyCodeCustomerGroupCustomerRequisitionNumberCustomersLineNumberCustomsDocumentDateCustomsDocumentNameCustomsDocumentNumberDefaultLedgerDimensionDisplayValueDefaultLineNumberFromLineCreationSequenceNumberDeliveryAddressCityDeliveryAddressCityInKanaDeliveryAddressCountryRegionISOCodeDeliveryAddressCountryRegionIdDeliveryAddressCountyIdDeliveryAddressDescriptionDeliveryAddressDistrictNameDeliveryAddressDunsNumberDeliveryAddressLatitudeDeliveryAddressLocationIdDeliveryAddressLongitudeDeliveryAddressNameDeliveryAddressPostBoxDeliveryAddressStateIdDeliveryAddressStreetDeliveryAddressStreetInKanaDeliveryAddressStreetNumberDeliveryAddressTimeZoneDeliveryAddressZipCodeDeliveryBuildingComplimentDeliveryCFOPCodeDeliveryModeCodeDeliverySalesTaxGroupCodeDeliverySalesTaxItemGroupCodeDeliveryTermsIdEInvoiceDimensionAccountCodeEInvoicePropertyNumberExcludeFromMasterPlanningExternalItemNumberFiscalDocumentTypeIdFixedPriceChargesFormattedDelveryAddressFulfillmentStatusFulfillmentStoreIdFullRunCTPStatusGiftCardBuyerEmailGiftCardBuyerNameGiftCardGiftMessageGiftCardNumberGiftCardRecipientEmailGiftCardRecipientNameGiftCardTypeIntrastatCommodityCodeIntrastatPortIdIntrastatSpecialMovementCodeIntrastatStatisticValueIntrastatStatisticsProcedureCodeIntrastatTransactionCodeIntrastatTransportModeCodeInventoryLotIdInventoryReservationMethodInventoryServiceAdjustmentOffsetDatasourceInventoryServiceAdjustmentOffsetPhysicalMeasureInventoryServiceReservationIdIsDeliveryAddressOrderSpecificIsDeliveryAddressPrivateIsIntrastatTriangularDealIsLineStoppedIsPriceLockedIsSoftReservedExternallyItemBatchNumberItemNumberItemSerialNumberItemWithholdingTaxCodeGroupCodeLineAmountLineCreationSequenceNumberLineDescriptionLineDiscountAmountLineDiscountPercentageLineNumberMainAccountIdDisplayValueMultilineDiscountAmountMultilineDiscountPercentageNGPCodeOrderLineReferenceOrderedCatchWeightQuantityOrderedInventoryStatusIdOrderedSalesQuantityOverrideSalesTaxPackingUnitSymbolPlanningPriorityProductColorIdProductConfigurationIdProductSizeIdProductVersionIdProjectCategoryIdProjectIdProjectLinePropertyIdRequestedReceiptDateRequestedShippingDateRetailCalculatedLineDiscountAmountRetailCalculatedLineDiscountPercentageRetailCalculatedManualLineDiscountAmountRetailCalculatedManualLineDiscountPercentageRetailCalculatedPeriodicDiscountAmountRetailCalculatedPeriodicDiscountPercentageRetailCalculatedTenderDiscountAmountRetailCalculatedTenderDiscountPercentageRetailCalculatedTotalDiscountAmountRetailCalculatedTotalDiscountPercentageRevRecContractEndDateRevRecContractStartDateRevRecOccurrencesRevRecRevenueScheduleIdRevRecSalesDeliverNowRouteIdSalesDeliverNowSalesOrderLineCreationMethodSalesOrderLineStatusSalesOrderNumberSalesOrderPromisingMethodSalesPriceSalesPriceQuantitySalesProductCategoryNameSalesRebateProductGroupIdSalesTaxGroupCodeSalesTaxItemGroupCodeSalesUnitSymbolSanDiscountCodeSanPurchPriceSan_IntRefServiceFiscalInformationCodeServiceOrderNumberSheaRemainInventPhysicalShippingSiteIdShippingWarehouseIdShippingWarehouseLocationIdSkipCreateAutoChargesSubBillRevenueSplitSuframaDiscountPercentageSupplierVERAirFreightVERAllComColReceivedVERArriveAtWarehouseVERArriveCustomerDateVERAuthorisedForReleaseVERAuthorisedForReleaseActualDateVERAuthorisedForReleaseFreeTextVERBackMaterialCollectionVERBackMaterialColourVERBackMaterialDescriptionVERBackMaterialIdVERBackMaterialReferenceNumberVERBackMaterialStatusVERBackMaterialVendorNameVERBalanceStatusVERComColVERComColOnHoldVERComColOnHoldReasonIdVERComColReceivedDateVERCommentsVERCriticalPathDlvModeIdVERDepositReceivedVERDepositReceivedActualDateVERDirectShipmentVERDirectToCustomerVERExWorksShipmentVERExpressCourierVERFabricRequiredVERFoamStatusVERFramesFromVERFramesShipDateVERKanbanIdVERKanbanJobStatusVERLineAmountCompanyCurrencyVERLinkedToLineNumberVERMontbelTononVERPlacePreOrderWithFactoryActualDateVERPlacePreOrderWithFactoryFreeTextVERPlacePreOrderWithFactoryOriginalDateVERPlacePreOrderWithFactoryPlannedDateVERProductConfigCombinationFriendlyVERProductConfigurationNotesVERProductNameVERPurchaseOrderNumberVERReceiveInUKVERRemainSalesPhysicalVERSalesPriceCompanyCurrencyVERSampleApprovedVERSampleApprovedActualDateVERSeatMaterialCollectionVERSeatMaterialColourVERSeatMaterialDescriptionVERSeatMaterialIdVERSeatMaterialReferenceNumberVERSeatMaterialStatusVERSeatMaterialVendorNameVERSendSampleToCustomerActualDateVERSendSampleToCustomerOriginalDateVERSendSampleToCustomerPlannedDateVERSendSampleToFactoryActualDateVERSendSampleToFactoryOnHoldVERSendSampleToFactoryOnHoldReasonIdVERSendSampleToFactoryOriginalDateVERSendSampleToFactoryPlannedDateVERShipDateVERShipDateRevised1VERShipDateRevised2VERStainRequiredVERStandardStainVERThirdPartyCollectionVERThirdPartyShipmentVERUSSupplierVERUpholsterInUKVERUpholsteryWorkVERViaConsolidationCentreVERWebOrderItemIdVendorNameAliasWillAutomaticInventoryReservationConsiderBatchAttributesWillRebateCalculationExcludeLineWithholdingTaxGroupCodedataAreaId
ProductMasterStyleTranslations ✓ API
2 used / 9 total

✅ Used Fields (2)

VERProductConfigCombinationCode
Used 4 times in 2 files
dynamics-api.class.phpCET-export.class.php

❌ Unused Fields (8)

@odata.etagLanguageIdProductMasterNumberProductMasterStyleIdTranslatedStyleDescriptionTranslatedStyleNameVERAx4ItemNumberVERItemNumber
VendorProductDescriptionsV2 ✓ API
2 used / 15 total

✅ Used Fields (2)

VendorProductNumber
Used 1 time in 1 file
dynamics-product-detail.class.php

❌ Unused Fields (14)

@odata.etagItemNumberProductColorIdProductConfigurationIdProductDescriptionVendorGroupIdProductSizeIdProductStyleIdProductVersionIdVERProductConfigCombinationCodeVendorABCCodeVendorABCCodeNoteVendorAccountNumberVendorProductDescriptiondataAreaId
SalesOrderHeaders ✓ API
1 used / 140 total

✅ Used Fields (1)

SalesOrderNumber
Used 1 time in 1 file
actions.php

❌ Unused Fields (139)

@odata.etagArePricesIncludingSalesTaxAreTotalsCalculatedBankConstantSymbolBankSpecificSymbolCFPSCodeCampaignIdCashDiscountCodeChargeCustomerGroupIdCommissionCustomerGroupIdCommissionSalesRepresentativeGroupIdConfirmedReceiptDateConfirmedShippingDateContactPersonIdCreditNoteReasonCodeCurrencyCodeCustomerPaymentFinancialInterestCodeCustomerPaymentFineCodeCustomerPaymentMethodNameCustomerPaymentMethodSpecificationNameCustomerPostingProfileIdCustomerRequisitionNumberCustomerTransactionSettlementTypeCustomersOrderReferenceDefaultLedgerDimensionDisplayValueDefaultShippingSiteIdDefaultShippingWarehouseIdDeliveryAddressCityDeliveryAddressCountryRegionISOCodeDeliveryAddressCountryRegionIdDeliveryAddressCountyIdDeliveryAddressDescriptionDeliveryAddressDistrictNameDeliveryAddressDunsNumberDeliveryAddressLatitudeDeliveryAddressLocationIdDeliveryAddressLongitudeDeliveryAddressNameDeliveryAddressPostBoxDeliveryAddressStateIdDeliveryAddressStreetDeliveryAddressStreetNumberDeliveryAddressTimeZoneDeliveryAddressZipCodeDeliveryBuildingComplimentDeliveryModeCodeDeliveryReasonCodeDeliveryTermsCodeDirectDebitMandateIdEInvoiceDimensionAccountCodeEUSalesListCodeEmailExportReasonFiscalDocumentOperationTypeIdFiscalDocumentTypeIdFiscalOperationPresenceTypeFixedDueDateFixedExchangeRateFormattedDelveryAddressFormattedInvoiceAddressIntrastatPortIdIntrastatStatisticsProcedureCodeIntrastatTransactionCodeIntrastatTransportModeCodeInventoryReservationMethodInvoiceAddressCityInvoiceAddressCountryRegionIdInvoiceAddressCountyIdInvoiceAddressDistrictNameInvoiceAddressLatitudeInvoiceAddressLongitudeInvoiceAddressPostBoxInvoiceAddressStateIdInvoiceAddressStreetInvoiceAddressStreetNumberInvoiceAddressTimeZoneInvoiceAddressZipCodeInvoiceBuildingComplimentInvoiceCustomerAccountNumberInvoicePaymentAttachmentTypeInvoiceTypeIsConsolidatedInvoiceTargetIsDeliveryAddressOrderSpecificIsDeliveryAddressPrivateIsEInvoiceDimensionAccountCodeSpecifiedPerLineIsEntryCertificateRequiredIsExportSaleIsFinalUserIsInvoiceAddressPrivateIsOneTimeCustomerIsOwnEntryCertificateIssuedIsSalesProcessingStoppedIsServiceDeliveryAddressBasedLanguageIdLineDiscountCustomerGroupCodeMultilineDiscountCustomerGroupCodeNumberSequenceGroupIdOrderResponsiblePersonnelNumberOrderTakerPersonnelNumberOrderTotalAmountOrderTotalChargesAmountOrderTotalDiscountAmountOrderTotalTaxAmountOrderingCustomerAccountNumberPaymentScheduleNamePaymentTermsBaseDatePaymentTermsNamePriceCustomerGroupCodeQuotationNumberRequestedReceiptDateRequestedShippingDateSalesOrderNameSalesOrderOriginCodeSalesOrderPoolIdSalesOrderProcessingStatusSalesOrderPromisingMethodSalesOrderStatusSalesRebateCustomerGroupIdSalesTaxGroupCodeSalesUnitIdServiceFiscalInformationCodeShippingCarrierIdShippingCarrierServiceGroupIdShippingCarrierServiceIdTMACustomerGroupIdTaxExemptNumberThirdPartySalesDigitalPlatformThirdPartySalesDigitalPlatformCNPJTotalDiscountAmountTotalDiscountCustomerGroupCodeTotalDiscountPercentageTransportationBrokerIdTransportationDocumentLineIdTransportationModeIdTransportationRoutePlanIdTransportationTemplateIdURLWillAutomaticInventoryReservationConsiderBatchAttributesdataAreaId
ProductConfigFinishes ✓ API
1 used / 7 total

✅ Used Fields (1)

❌ Unused Fields (7)

@odata.etagFinishDescriptionFinishFriendlyNameFinishNameFinishShortCodeFinishStatusInventColor
CustomersV3 ✓ API
1 used / 320 total

✅ Used Fields (1)

CustomerAccount
Used 2 times in 1 file
dynamics-api.class.php

❌ Unused Fields (319)

@odata.etagAccountStatementAddressBooksAddressBrazilianCNPJOrCPFAddressBrazilianIEAddressBuildingComplementAddressCityAddressCountryRegionISOCodeAddressCountryRegionIdAddressCountyAddressDescriptionAddressDistrictNameAddressLatitudeAddressLocationIdAddressLocationRolesAddressLongitudeAddressPostboxAddressRecordIdAddressStateAddressStreetAddressStreetNumberAddressTimeZoneAddressValidFromAddressValidToAddressZipCodeAllowOnAccountAuthorityOfficeBirthCountyCodeBirthPlaceBrazilianCCMBrazilianCNAEBrazilianCNPJOrCPFBrazilianIEBrazilianINSSCEIBrazilianNITCFDITemporaryExport_MXCURPNumberCalculateWithholdingTaxCentralBankPurposeCodeCentralBankPurposeNotesChargesGroupIdCollectionLetterCodeCollectionsContactPersonIdCommissionCustomerGroupIdCommissionSalesGroupIdCompanyChainCompanyTypeConsolidationDayContactPersonIdCredManAccountStatusIdCredManBusinessStartedCredManCollectionGroupIdCredManCreditLimitDateCredManCreditLimitExpiryDateCredManCustCreditMaxAltCredManCustUnlimitedCreditCredManCustomerSinceCredManEligibleCreditLimitCurrencyCredManEligibleCreditLimitDateCredManEligibleCreditMaxCredManExcludeCredManGroupIdCredManLastReviewDateCredManNextSchedReviewDateCredManNotesCredManStatusReasonIdCredManTitleHeldCredManWithAgencyCreditCardAddressVerificationCreditCardAddressVerificationIsAuthorizationVoidedOnFailureCreditCardAddressVerificationLevelCreditCardCVCCreditLimitCreditLimitIsMandatoryCreditRatingCustClassificationIdCustomerGroupIdCustomerPaymentFinancialInterestCodeCustomerPaymentFineCodeCustomerRebateGroupIdCustomerTMAGroupIdCustomerTypeCustomerWithholdingContributionTypeDefaultDimensionDisplayValueDefaultECommerceOperatorDefaultInventoryStatusIdDeliveryAddressBuildingComplementDeliveryAddressCityDeliveryAddressCountryRegionISOCodeDeliveryAddressCountryRegionIdDeliveryAddressCountyDeliveryAddressDescriptionDeliveryAddressDistrictNameDeliveryAddressLatitudeDeliveryAddressLocationIdDeliveryAddressLongitudeDeliveryAddressStateDeliveryAddressStreetDeliveryAddressStreetNumberDeliveryAddressTimeZoneDeliveryAddressValidFromDeliveryAddressValidToDeliveryAddressZipCodeDeliveryFreightZoneDeliveryModeDeliveryReasonDeliveryTermsDestinationCodeDiscountPriceGroupIdEInvoiceAttachmentEInvoiceRegisterElectronicInvoiceEANElectronicLocationIdEmployeeResponsibleNumberExportSaleFederalAgencyLocationCodeFederalCommentsFederalIndicatorFiscalCodeForeignCustomerForeignResidentForeignerIdFrenchSiretFulfillmentPolicyNameFullPrimaryAddressGiroTypeGiroTypeAccountStatementGiroTypeCollectionletterGiroTypeFreeTextInvoiceGiroTypeInterestNoteGiroTypeProjInvoiceHasSuframaDiscountPISandCOFINSIRS1099CIndicatorIdentificationNumberInterCompanyAutoCreateOrdersInvoiceAccountInvoiceAddressInvoiceAddressBuildingComplementInvoiceAddressCityInvoiceAddressCountryRegionISOCodeInvoiceAddressCountryRegionIdInvoiceAddressCountyInvoiceAddressDescriptionInvoiceAddressDistrictNameInvoiceAddressLatitudeInvoiceAddressLocationIdInvoiceAddressLongitudeInvoiceAddressStateInvoiceAddressStreetInvoiceAddressStreetNumberInvoiceAddressTimeZoneInvoiceAddressValidFromInvoiceAddressValidToInvoiceAddressZipCodeInvoicePostingTypeIsAllowCreateIndirectOrderLinesIsElectronicInvoiceIsExcludedFromCollectionFeeCalculationIsExcludedFromInterestChargeCalculationIsExpressBillOfLadingAcceptedIsExternallyMaintainedIsFinalUserIsFreightAccruedIsFuelSurchargeAppliedIsICMSContributorIsInSuframaRegionIsIncomingFiscalDocumentGeneratedIsOneTimeCustomerIsOrderNumberReferenceUsedIsPublicSector_ITIsPurchRequestUsedIsSalesTaxIncludedInPricesIsServiceDeliveryAddressBasedIsSimplifiedDeliveryAddressIsSimplifiedInvoiceAddressIsSimplifiedPrimaryAddressIsTransactionPostedAsShipmentIsWithholdingTaxCalculatedItemCustomerGroupIdKnownAsLanguageIdLineDiscountCodeLineOfBusinessIdMerchantIDMultiLineDiscountCodeNAFCodeNameAliasNationalRegistryNumberNatureOfAssesseeNumberSequenceGroupOnHoldStatusOrderEntryDeadlineOrganizationABCCodeOrganizationNameOrganizationNumberOrganizationNumberOfEmployeesOrganizationPhoneticNameOverrideSalesTaxPANNumberPANReferenceNumberPackingDutyLicensePackingMaterialFeeLicenseNumberPanStatusPartyCountryPartyNumberPartyStatePartyTypePaymentBankAccountPaymentCashDiscountPaymentDayPaymentFactoringAccountPaymentIdTypePaymentMethodPaymentSchedulePaymentSpecificationPaymentTermsPaymentTermsBaseDaysPaymentUseCashDiscountPersonAnniversaryDayPersonAnniversaryMonthPersonAnniversaryYearPersonChildrenNamesPersonFirstNamePersonGenderPersonHobbiesPersonInitialsPersonLastNamePersonLastNamePrefixPersonMaritalStatusPersonMiddleNamePersonPhoneticFirstNamePersonPhoneticLastNamePersonPhoneticMiddleNamePersonProfessionalSuffixPersonProfessionalTitlePreferentialCustomerPrimaryContactEmailPrimaryContactEmailDescriptionPrimaryContactEmailIsIMPrimaryContactEmailPurposePrimaryContactEmailRecordIdPrimaryContactFacebookPrimaryContactFacebookDescriptionPrimaryContactFacebookPurposePrimaryContactFaxPrimaryContactFaxDescriptionPrimaryContactFaxExtensionPrimaryContactFaxPurposePrimaryContactFaxRecordIdPrimaryContactLinkedInPrimaryContactLinkedInDescriptionPrimaryContactLinkedInPurposePrimaryContactPhonePrimaryContactPhoneDescriptionPrimaryContactPhoneExtensionPrimaryContactPhoneIsMobilePrimaryContactPhonePurposePrimaryContactPhoneRecordIdPrimaryContactTelexPrimaryContactTelexDescriptionPrimaryContactTelexPurposePrimaryContactTwitterPrimaryContactTwitterDescriptionPrimaryContactTwitterPurposePrimaryContactURLPrimaryContactURLDescriptionPrimaryContactURLPurposePrimaryContactURLRecordIdPriorityQMSApprovedCustomerGroupIdQMSApprovedCustomerListCheckMethodQMSCertificateOfAnalysisCustomerGroupIdQMSWillPrintCustomerSpecificCertificateOfAnalysisRFCNumberReceiptCalendarReceiptEmailReceiptOptionReliefGroupIdResidenceForeignCountryRegionIdSANProformaAccountSATRegistrationName_MXSalesAccountNumberSalesCurrencyCodeSalesDistrictSalesMemoSalesOrderPoolIdSalesReturnTaxGroupSalesSegmentIdSalesSubsegmentIdSalesTaxGroupSheaCustomerTypeSiteIdStateInscriptionStatisticsGroupIdSuframaNumberSupplementaryItemGroupIdTCSGroupTDSGroupTaxExemptNumberTaxRegimeCode_MXTaxRegistrationIdTotalDiscountCodeTransactionPresenceTypeVERArrivalCalendarIdVERCustomerStatusVERDepositPercentVERDuplicateOfCustomerAccountVERSendDocumentsFromEmailVERSendDocumentsFromNameVendorAccountWarehouseIdWarehouseIsASNGeneratedWarehouseIsEntireShipmentFilledWarehouseOutboundShipmentProcessingPolicyNameWithholdingTaxGroupCodeWriteoffReasondataAreaIdsheaLastTransDateAX4sheaOldAccountNumber
ContactPersons ✓ API
1 used / 121 total

✅ Used Fields (1)

AssociatedPartyNumber
Used 1 time in 1 file
dynamics-api.class.php

❌ Unused Fields (120)

@odata.etagAddressBookNamesAlternateComplimentaryClosingPhraseAlternateSalutationPhraseAnniversaryDayAnniversaryMonthAnniversaryYearAssistantNameAssistantPhoneNumberAvailableFromTimeAvailableToTimeBillingInformationBirthDayBirthMonthBirthYearChildrenNamesCitizenshipCountryRegionContactActivitySensitivityLevelContactInformationLanguageIdContactPersonIdContactPersonNameContactPersonPartyNumberContactPersonPartyTypeContactPersonResponsiblePersonnelNumberDecisionMakingRoleCodeDisplayNameSequencePatternNameElectronicLocationIdEmploymentComputerNetworkNameEmploymentDepartmentEmploymentJobFunctionNameEmploymentJobTitleEmploymentOfficeLocationEmploymentProfessionFirstNameFormattedPrimaryAddressGenderGovernmentIdentificationNumberHasRequestedInternetAccessHobbiesIdentityCardNumberInitialsIsContactPersonExternallyMaintainedIsDefaultContactPersonIsImportedIsInactiveIsPrimaryEmailAddressIMEnabledIsPrimaryPhoneNumberMobileIsReceivingDirectMailIsVIPIsVendorPortalAccessAllowedKnownAsNameLastEditDateTimeLastNameLoyaltyLevelPhraseManagerContactPersonIdMaritalStatusMicrosoftOutlookCategoriesMiddleNameMileageDistanceNotesOrganizationIdentificationNumberPersonalCharacterTypeCodePhoneticFirstNamePhoneticLastNamePhoneticMiddleNamePrimaryAddressBuildingComplimentPrimaryAddressCityPrimaryAddressCityInKanaPrimaryAddressCountryRegionISOCodePrimaryAddressCountryRegionIdPrimaryAddressCountyIdPrimaryAddressDescriptionPrimaryAddressDistrictNamePrimaryAddressLatitudePrimaryAddressLocationIdPrimaryAddressLocationRolesPrimaryAddressLongitudePrimaryAddressPostBoxPrimaryAddressStateIdPrimaryAddressStreetPrimaryAddressStreetInKanaPrimaryAddressStreetNumberPrimaryAddressTimeZonePrimaryAddressValidFromPrimaryAddressValidToPrimaryAddressZipCodePrimaryComplimentaryClosingPhrasePrimaryEmailAddressPrimaryEmailAddressDescriptionPrimaryEmailAddressPurposePrimaryFacebookPrimaryFacebookDescriptionPrimaryFacebookPurposePrimaryFaxNumberPrimaryFaxNumberDescriptionPrimaryFaxNumberExtensionPrimaryFaxNumberPurposePrimaryLinkedInPrimaryLinkedInDescriptionPrimaryLinkedInPurposePrimaryPhoneNumberPrimaryPhoneNumberDescriptionPrimaryPhoneNumberExtensionPrimaryPhoneNumberPurposePrimarySalutationPhrasePrimaryTelexPrimaryTelexDescriptionPrimaryTelexPurposePrimaryTwitterPrimaryTwitterDescriptionPrimaryTwitterPurposePrimaryURLPrimaryURLDescriptionPrimaryURLPurposeProfessionalSuffixProfessionalTitleSearchNameSpouseNameUserRoledataAreaId
ProductSizeCodes ✓ API
1 used / 4 total

✅ Used Fields (1)

SizeCode
Used 3 times in 2 files
ProductSpecEndpoint.phpactions.php

❌ Unused Fields (3)

@odata.etagDescriptiondataAreaId
AddressStates ✓ API
1 used / 8 total

✅ Used Fields (1)

CountryRegionId
Used 1 time in 1 file
actions.php

❌ Unused Fields (7)

@odata.etagBrazilStateCodeDefaultStateForCountryRegionIntrastatCodeNameStateTimeZone
SalesLineCustomerMaterials ✓ API
1 used / 15 total

✅ Used Fields (1)

❌ Unused Fields (15)

@odata.etagCharacteristicShortCodeCollectionCustomerAccountFabricNameInventoryLotIdItemNumberLineNumberMaterialIdMaterialStatusMaterialTypeReferenceNumberSalesOrderNumberVendorNamedataAreaId
SalesOrderHeadersV2 ✓ API
0 used / 187 total

❌ Unused Fields (187)

@odata.etagArePricesIncludingSalesTaxAreTotalsCalculatedBankConstantSymbolBankSpecificSymbolBaseDocumentDateBaseDocumentItemNumberBaseDocumentLineNumberBaseDocumentNumberBaseDocumentTypeCFPSCodeCIPEcodeCampaignIdCashDiscountCodeChargeCustomerGroupIdCommissionCustomerGroupIdCommissionSalesRepresentativeGroupIdConfirmedReceiptDateConfirmedShippingDateContactPersonIdCreditNoteReasonCodeCurrencyCodeCustomerGroupCustomerPaymentFinancialInterestCodeCustomerPaymentFineCodeCustomerPaymentMethodNameCustomerPaymentMethodSpecificationNameCustomerPostingProfileIdCustomerRequisitionNumberCustomerTransactionSettlementTypeCustomersOrderReferenceDefaultLedgerDimensionDisplayValueDefaultShippingSiteIdDefaultShippingWarehouseIdDeliveryAddressCityDeliveryAddressCityInKanaDeliveryAddressCountryRegionISOCodeDeliveryAddressCountryRegionIdDeliveryAddressCountyIdDeliveryAddressDescriptionDeliveryAddressDistrictNameDeliveryAddressDunsNumberDeliveryAddressLatitudeDeliveryAddressLocationIdDeliveryAddressLongitudeDeliveryAddressNameDeliveryAddressPostBoxDeliveryAddressStateIdDeliveryAddressStreetDeliveryAddressStreetInKanaDeliveryAddressStreetNumberDeliveryAddressTimeZoneDeliveryAddressZipCodeDeliveryBuildingComplimentDeliveryModeCodeDeliveryReasonCodeDeliveryTermsCodeDirectDebitMandateIdEInvoiceDimensionAccountCodeEUSalesListCodeEmailExportReasonFiscalDocumentOperationTypeIdFiscalOperationPresenceTypeFixedDueDateFixedExchangeRateFormattedDelveryAddressFormattedInvoiceAddressFulfillmentPolicyNameFullRunCTPStatusIntrastatPortIdIntrastatStatisticsProcedureCodeIntrastatTransactionCodeIntrastatTransportModeCodeInventoryReservationMethodInvoiceAddressCityInvoiceAddressCityInKanaInvoiceAddressCountryRegionISOCodeInvoiceAddressCountryRegionIdInvoiceAddressCountyIdInvoiceAddressDistrictNameInvoiceAddressLatitudeInvoiceAddressLongitudeInvoiceAddressPostBoxInvoiceAddressStateIdInvoiceAddressStreetInvoiceAddressStreetInKanaInvoiceAddressStreetNumberInvoiceAddressTimeZoneInvoiceAddressZipCodeInvoiceBuildingComplimentInvoiceCustomerAccountNumberInvoicePaymentAttachmentTypeInvoiceTypeIsConsolidatedInvoiceTargetIsDeliveryAddressOrderSpecificIsDeliveryAddressPrivateIsEInvoiceDimensionAccountCodeSpecifiedPerLineIsEntryCertificateRequiredIsExportSaleIsFinalUserIsInvoiceAddressPrivateIsOneTimeCustomerIsOwnEntryCertificateIssuedIsSalesProcessingStoppedIsServiceDeliveryAddressBasedLanguageIdLineDiscountCustomerGroupCodeMultilineDiscountCustomerGroupCodeNumberSequenceGroupIdOrderCreationDateTimeOrderHeaderTaxAmountOrderOrAgreementCodeOrderResponsiblePersonnelNumberOrderTakerPersonnelNumberOrderTotalAmountOrderTotalChargesAmountOrderTotalDiscountAmountOrderTotalTaxAmountOrderingCustomerAccountNumberOverrideSalesTaxPaymentScheduleNamePaymentTermsBaseDatePaymentTermsNamePriceCustomerGroupCodeProjectIdQuotationNumberReportingCurrencyFixedExchangeRateRequestedReceiptDateRequestedShippingDateRevRecContractEndDateRevRecContractStartDateRevRecFollowOriginalPricingMethodRevRecLatestReverseJournalRevRecMultipleSOReallocationRevRecReallocationIdSalesOrderNameSalesOrderNumberSalesOrderOriginCodeSalesOrderPoolIdSalesOrderProcessingStatusSalesOrderPromisingMethodSalesOrderStatusSalesRebateCustomerGroupIdSalesTaxGroupCodeSalesUnitIdSanOrdProformaAccountSanSalesOrderTitleSan_IntRefServiceFiscalInformationCodeSheaCustomerTypeSheaWebQuoteNumberShippingCarrierCustomerAccountNumberShippingCarrierIdShippingCarrierServiceGroupIdShippingCarrierServiceIdSkipCreateAutoChargesSkipGlobalUnifiedPricingCalculationSubBillCreatedFromSubscriptionBillingTMACustomerGroupIdTaxExemptNumberTenderCodeThirdPartySalesDigitalPlatformThirdPartySalesDigitalPlatformCNPJTotalDiscountAmountTotalDiscountCustomerGroupCodeTotalDiscountPercentageTransportationBrokerIdTransportationDocumentLineIdTransportationModeIdTransportationRoutePlanIdTransportationTemplateIdURLVERBalanceDueVERCommissionSalesGroupId2VERCommissionSalesGroupPercentVERCommissionSalesGroupPercent2VERDeliveryNotesVERDepositPercentVEREffectiveDateVEROrderNotesVEROrderResponsibleNameVEROrderTotalAmountVEROrderTotalAmountCompanyCurrencyVERPaidAmountWillAutomaticInventoryReservationConsiderBatchAttributesdataAreaId
SalesOrderHeadersV3 ✓ API
0 used / 189 total

❌ Unused Fields (189)

@odata.etagArePricesIncludingSalesTaxAreTotalsCalculatedBankConstantSymbolBankSpecificSymbolBaseDocumentDateBaseDocumentItemNumberBaseDocumentLineNumberBaseDocumentNumberBaseDocumentTypeCFPSCodeCIPEcodeCampaignIdCashDiscountCodeChargeCustomerGroupIdCommissionCustomerGroupIdCommissionSalesRepresentativeGroupIdConfirmedReceiptDateConfirmedShippingDateContactPersonIdCreditNoteReasonCodeCurrencyCodeCustomerGroupCustomerPaymentFinancialInterestCodeCustomerPaymentFineCodeCustomerPaymentMethodNameCustomerPaymentMethodSpecificationNameCustomerPostingProfileIdCustomerRequisitionNumberCustomerTransactionSettlementTypeCustomersOrderReferenceDefaultLedgerDimensionDisplayValueDefaultShippingSiteIdDefaultShippingWarehouseIdDeliveryAddressCityDeliveryAddressCityInKanaDeliveryAddressCountryRegionISOCodeDeliveryAddressCountryRegionIdDeliveryAddressCountyIdDeliveryAddressDescriptionDeliveryAddressDistrictNameDeliveryAddressDunsNumberDeliveryAddressLatitudeDeliveryAddressLocationIdDeliveryAddressLongitudeDeliveryAddressNameDeliveryAddressPostBoxDeliveryAddressStateIdDeliveryAddressStreetDeliveryAddressStreetInKanaDeliveryAddressStreetNumberDeliveryAddressTimeZoneDeliveryAddressZipCodeDeliveryBuildingComplimentDeliveryModeCodeDeliveryReasonCodeDeliveryTermsCodeDirectDebitMandateIdEInvoiceDimensionAccountCodeEUSalesListCodeEmailExcludeFromMasterPlanningExportReasonFiscalDocumentOperationTypeIdFiscalOperationPresenceTypeFixedDueDateFixedExchangeRateFormattedDelveryAddressFormattedInvoiceAddressFulfillmentPolicyNameFullRunCTPStatusIntrastatPortIdIntrastatStatisticsProcedureCodeIntrastatTransactionCodeIntrastatTransportModeCodeInventoryReservationMethodInvoiceAddressCityInvoiceAddressCityInKanaInvoiceAddressCountryRegionISOCodeInvoiceAddressCountryRegionIdInvoiceAddressCountyIdInvoiceAddressDistrictNameInvoiceAddressLatitudeInvoiceAddressLongitudeInvoiceAddressPostBoxInvoiceAddressStateIdInvoiceAddressStreetInvoiceAddressStreetInKanaInvoiceAddressStreetNumberInvoiceAddressTimeZoneInvoiceAddressZipCodeInvoiceBuildingComplimentInvoiceCustomerAccountNumberInvoicePaymentAttachmentTypeInvoiceTypeIsConsolidatedInvoiceTargetIsDeliveryAddressOrderSpecificIsDeliveryAddressPrivateIsEInvoiceDimensionAccountCodeSpecifiedPerLineIsEntryCertificateRequiredIsExportSaleIsFinalUserIsInvoiceAddressPrivateIsOneTimeCustomerIsOwnEntryCertificateIssuedIsSalesProcessingStoppedIsServiceDeliveryAddressBasedLanguageIdLineDiscountCustomerGroupCodeMultilineDiscountCustomerGroupCodeNumberSequenceGroupIdOrderCreationDateTimeOrderHeaderTaxAmountOrderOrAgreementCodeOrderResponsiblePersonnelNumberOrderTakerPersonnelNumberOrderTotalAmountOrderTotalChargesAmountOrderTotalDiscountAmountOrderTotalTaxAmountOrderingCustomerAccountNumberOverrideSalesTaxPaymentScheduleNamePaymentTermsBaseDatePaymentTermsNamePriceCustomerGroupCodeProjectIdQuotationNumberReportingCurrencyFixedExchangeRateRequestedReceiptDateRequestedShippingDateRetailChannelTableRevRecContractEndDateRevRecContractStartDateRevRecFollowOriginalPricingMethodRevRecLatestReverseJournalRevRecMultipleSOReallocationRevRecReallocationIdSANOrdProformaAcountSalesOrderNameSalesOrderNumberSalesOrderOriginCodeSalesOrderPoolIdSalesOrderProcessingStatusSalesOrderPromisingMethodSalesOrderStatusSalesRebateCustomerGroupIdSalesTaxGroupCodeSalesUnitIdSanSalesOrderTitleSan_IntRefServiceFiscalInformationCodeSheaCustomerTypeSheaWebQuoteNumberShippingCarrierCustomerAccountNumberShippingCarrierIdShippingCarrierServiceGroupIdShippingCarrierServiceIdSkipCreateAutoChargesSkipGlobalUnifiedPricingCalculationSubBillCreatedFromSubscriptionBillingTMACustomerGroupIdTaxExemptNumberTenderCodeThirdPartySalesDigitalPlatformThirdPartySalesDigitalPlatformCNPJTotalDiscountAmountTotalDiscountCustomerGroupCodeTotalDiscountPercentageTransportationBrokerIdTransportationDocumentLineIdTransportationModeIdTransportationRoutePlanIdTransportationTemplateIdURLVERCommissionSalesGroupId2VERCommissionSalesGroupPercentVERCommissionSalesGroupPercent2VERDeliveryNotesVERDepositPercentVEREffectiveDateVEROrderNotesVERQuotedDateVERSalesSpecifierIdVERSendDocumentsFromEmailVERSendDocumentsFromNameVERThirdPartyCollectionWillAutomaticInventoryReservationConsiderBatchAttributesdataAreaId
SalesOrderHeadersV4 ✓ API
0 used / 183 total

❌ Unused Fields (183)

@odata.etagArePricesIncludingSalesTaxAreTotalsCalculatedBankConstantSymbolBankSpecificSymbolBaseDocumentDateBaseDocumentItemNumberBaseDocumentLineNumberBaseDocumentNumberBaseDocumentTypeCFPSCodeCIPEcodeCampaignIdCashDiscountCodeChargeCustomerGroupIdCommissionCustomerGroupIdCommissionSalesRepresentativeGroupIdConfirmedReceiptDateConfirmedShippingDateContactPersonIdCreditNoteReasonCodeCurrencyCodeCustomerGroupCustomerPaymentFinancialInterestCodeCustomerPaymentFineCodeCustomerPaymentMethodNameCustomerPaymentMethodSpecificationNameCustomerPostingProfileIdCustomerRequisitionNumberCustomerTransactionSettlementTypeCustomersOrderReferenceDefaultLedgerDimensionDisplayValueDefaultShippingSiteIdDefaultShippingWarehouseIdDeliveryAddressCityDeliveryAddressCityInKanaDeliveryAddressCountryRegionISOCodeDeliveryAddressCountryRegionIdDeliveryAddressCountyIdDeliveryAddressDescriptionDeliveryAddressDistrictNameDeliveryAddressDunsNumberDeliveryAddressLatitudeDeliveryAddressLocationIdDeliveryAddressLongitudeDeliveryAddressNameDeliveryAddressPostBoxDeliveryAddressStateIdDeliveryAddressStreetDeliveryAddressStreetInKanaDeliveryAddressStreetNumberDeliveryAddressTimeZoneDeliveryAddressZipCodeDeliveryBuildingComplimentDeliveryModeCodeDeliveryReasonCodeDeliveryTermsCodeDirectDebitMandateIdEInvoiceDimensionAccountCodeEUSalesListCodeEmailExcludeFromMasterPlanningExportReasonFinTagDisplayValueFiscalDocumentOperationTypeIdFiscalOperationPresenceTypeFixedDueDateFixedExchangeRateFormattedDelveryAddressFormattedInvoiceAddressFulfillmentPolicyNameFullRunCTPStatusIntrastatPortIdIntrastatStatisticsProcedureCodeIntrastatTransactionCodeIntrastatTransportModeCodeInventoryReservationMethodInvoiceAddressCityInvoiceAddressCityInKanaInvoiceAddressCountryRegionISOCodeInvoiceAddressCountryRegionIdInvoiceAddressCountyIdInvoiceAddressDistrictNameInvoiceAddressLatitudeInvoiceAddressLongitudeInvoiceAddressPostBoxInvoiceAddressStateIdInvoiceAddressStreetInvoiceAddressStreetInKanaInvoiceAddressStreetNumberInvoiceAddressTimeZoneInvoiceAddressZipCodeInvoiceBuildingComplimentInvoiceCustomerAccountNumberInvoicePaymentAttachmentTypeInvoiceTypeIsConsolidatedInvoiceTargetIsDeliveryAddressOrderSpecificIsDeliveryAddressPrivateIsEInvoiceDimensionAccountCodeSpecifiedPerLineIsEntryCertificateRequiredIsExportSaleIsFinalUserIsInvoiceAddressPrivateIsOneTimeCustomerIsOwnEntryCertificateIssuedIsSalesProcessingStoppedIsServiceDeliveryAddressBasedLanguageIdLineDiscountCustomerGroupCodeMultilineDiscountCustomerGroupCodeNumberSequenceGroupIdOrderCreationDateTimeOrderHeaderTaxAmountOrderOrAgreementCodeOrderResponsiblePersonnelNumberOrderTakerPersonnelNumberOrderTotalAmountOrderTotalChargesAmountOrderTotalDiscountAmountOrderTotalTaxAmountOrderingCustomerAccountNumberOverrideSalesTaxPaymentScheduleNamePaymentTermsBaseDatePaymentTermsNamePriceCustomerGroupCodeProjectIdQuotationNumberReportingCurrencyFixedExchangeRateRequestedReceiptDateRequestedShippingDateRetailChannelTableSANOrdProformaAcountSalesOrderNameSalesOrderNumberSalesOrderOriginCodeSalesOrderPoolIdSalesOrderProcessingStatusSalesOrderPromisingMethodSalesOrderStatusSalesRebateCustomerGroupIdSalesTaxGroupCodeSalesUnitIdSanSalesOrderTitleSan_IntRefServiceFiscalInformationCodeSheaCustomerTypeSheaWebQuoteNumberShipmentProcessingPolicyNameShippingCarrierCustomerAccountNumberShippingCarrierIdShippingCarrierServiceGroupIdShippingCarrierServiceIdSkipCreateAutoChargesTMACustomerGroupIdTaxExemptNumberTenderCodeThirdPartySalesDigitalPlatformThirdPartySalesDigitalPlatformCNPJTotalDiscountAmountTotalDiscountCustomerGroupCodeTotalDiscountPercentageTransportationBrokerIdTransportationDocumentLineIdTransportationModeIdTransportationRoutePlanIdTransportationTemplateIdURLVERCommissionSalesGroupId2VERCommissionSalesGroupPercentVERCommissionSalesGroupPercent2VERDeliveryNotesVERDepositPercentVEREffectiveDateVEROrderNotesVERQuotedDateVERSalesSpecifierIdVERSendDocumentsFromEmailVERSendDocumentsFromNameVERThirdPartyCollectionWillAutomaticInventoryReservationConsiderBatchAttributesdataAreaId
ProductConfigCharacteristics ✓ API
0 used / 7 total

❌ Unused Fields (7)

@odata.etagCharacteristicDescriptionCharacteristicFriendlyNameCharacteristicNameCharacteristicShortCodeCharacteristicSortOrderCharacteristicStatus
ProductConfigCharacteristicOptions ✓ API
0 used / 3 total

❌ Unused Fields (3)

@odata.etagCharacteristicShortCodeOptionShortCode
InventStyleCharacteristicOptions ✓ API
0 used / 4 total

❌ Unused Fields (4)

@odata.etagCharacteristicShortCodeInventStyleOptionShortCode
PartyLocationPostalAddressesV2 ✓ API
0 used / 39 total

❌ Unused Fields (39)

@odata.etagAddressApartment_RUAssignmentDateAttentionToAddressLineBuildingComplimentBuilding_RUCityCityInKanaCountryRegionISOCodeCountryRegionIdCountyDescriptionDistrictNameDunsNumberFormattedDeliveryAddressIsLocationOwnerIsPrimaryIsPrimaryTaxRegistrationIsPrivateIsPrivatePostalAddressIsRoleBusinessIsRoleDeliveryIsRoleHomeIsRoleInvoiceLatitudeLocationIdLongitudePartyNumberPostBoxRolesStateStreetStreetInKanaStreetNumberTimeZoneValidFromValidToZipCode
PartyContactsV3 ✓ API
0 used / 14 total

❌ Unused Fields (14)

@odata.etagCountryRegionCodeDescriptionElectronicAddressIdIsInstantMessageIsMobilePhoneIsPrimaryIsPrivateLocationIdLocatorLocatorExtensionPartyNumberPurposeType
Workers ✓ API
0 used / 112 total

❌ Unused Fields (112)

@odata.etagAddressBooksAddressCityAddressCountryRegionISOCodeAddressCountryRegionIdAddressCountyAddressDistrictNameAddressLocationIdAddressNameDescriptionAddressPurposeAddressStateAddressStreetAddressValidFromAddressValidToAddressZipCodeAllowRehireAnniversaryDateTimeBirthDateCitizenshipCountryRegionDeceasedDateDisabledVerificationDateEducationElectronicLocationIdEthnicOriginIdExpatriateRulingValidFromExpatriateRulingValidToFatherBirthCountryRegionFirstNameGenderIdentityEmailIdentityProviderIsDisabledIsDisabledVeteranIsExpatriateRulingApplicableIsFulltimeStudentKnownAsLanguageIdLastNameLastNamePrefixMaritalStatusMiddleNameMilitaryServiceEndDateMilitaryServiceStartDateMotherBirthCountryRegionNameNameAliasNameSequenceDisplayAsNationalityCountryRegionNativeLanguageIdNumberOfDependentsObjectIdOfficeLocationOfficeLocationIdOriginalHireDateTimePartyNumberPartyTypePersonBirthCityPersonBirthCountryRegionPersonDetailsValidFromPersonDetailsValidToPersonUserValidFromPersonUserValidToPersonalSuffixPersonalTitlePersonnelNumberPhoneticFirstNamePhoneticLastNamePhoneticMiddleNamePrimaryAddressLocationPrimaryContactEmailPrimaryContactEmailDescriptionPrimaryContactEmailIsIMPrimaryContactEmailIsPrivatePrimaryContactEmailPurposePrimaryContactFacebookPrimaryContactFacebookDescriptionPrimaryContactFacebookIsPrivatePrimaryContactFacebookPurposePrimaryContactFaxPrimaryContactFaxDescriptionPrimaryContactFaxExtensionPrimaryContactFaxIsPrivatePrimaryContactFaxPurposePrimaryContactLinkedInPrimaryContactLinkedInDescriptionPrimaryContactLinkedInIsPrivatePrimaryContactLinkedInPurposePrimaryContactPhonePrimaryContactPhoneDescriptionPrimaryContactPhoneExtensionPrimaryContactPhoneIsMobilePrimaryContactPhoneIsPrivatePrimaryContactPhonePurposePrimaryContactTwitterPrimaryContactTwitterDescriptionPrimaryContactTwitterIsPrivatePrimaryContactTwitterPurposePrimaryContactURLPrimaryContactURLDescriptionPrimaryContactURLIsPrivatePrimaryContactURLPurposeProfessionalSuffixProfessionalTitleSeniorityDateSummaryValidFromSummaryValidToTitleIdUserVeteranStatusIdWorkerStatusWorkerTypeWorksFromHome
SalesSpecifiers ✓ API
0 used / 11 total

❌ Unused Fields (11)

@odata.etagContactNameCountryRegionEmailRepGroupRepGroupNameRepNameSpecifierSpecifierNameStatedataAreaId
VERTariffRates
0 used
⚠️ No field usage found in codebase and unable to fetch endpoint fields
ProductAvailableToPromises ✓ API
0 used / 9 total

❌ Unused Fields (9)

@odata.etagAvailableOnHandQuantityAvailableToPromiseQuantityItemNumberOnHandQuantityOnKanbanQuantityOnOrderQuantityProductColorIddataAreaId