🔍 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.19 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.
SalesOrderHeaders: ✓ 140 fields (908.26ms)
✓ Direct curl with cross-company=true - 140 fields found
SalesOrderHeadersV2: ✓ 187 fields (1141.67ms)
✓ Direct curl with cross-company=true - 187 fields found
SalesOrderHeadersV3: ✓ 189 fields (743.71ms)
✓ Direct curl with cross-company=true - 189 fields found
SalesOrderHeadersV4: ✓ 183 fields (708.72ms)
✓ Direct curl with cross-company=true - 183 fields found
SalesOrderHeaderChargesV2: ✓ 16 fields (651.23ms)
✓ Direct curl with cross-company=true - 16 fields found
SalesOrderLines: ✓ 236 fields (801.47ms)
✓ Direct curl with cross-company=true - 236 fields found
ReleasedProductsV2: ✓ 336 fields (659.1ms)
✓ Direct curl with cross-company=true - 336 fields found
ProductMasterCharacteristics: ✓ 6 fields (615.49ms)
✓ Direct curl with cross-company=true - 6 fields found
ProductMasterCharacteristicOptions: ✓ 9 fields (615.71ms)
✓ Direct curl with cross-company=true - 9 fields found
ProductMasterOptionFinishes: ✓ 9 fields (609.72ms)
✓ Direct curl with cross-company=true - 9 fields found
ProductConfigCharacteristics: ✓ 7 fields (607.64ms)
✓ Direct curl with cross-company=true - 7 fields found
ProductConfigOptions: ✓ 6 fields (615.1ms)
✓ Direct curl with cross-company=true - 6 fields found
ProductConfigFinishes: ✓ 7 fields (609.97ms)
✓ Direct curl with cross-company=true - 7 fields found
ProductConfigCharacteristicOptions: ✓ 3 fields (607.32ms)
✓ Direct curl with cross-company=true - 3 fields found
ProductConfigOptionFinishes: ✓ 3 fields (609.48ms)
✓ Direct curl with cross-company=true - 3 fields found
InventStyleCharacteristicOptions: ✓ 4 fields (613.74ms)
✓ Direct curl with cross-company=true - 4 fields found
SalesPriceAgreements: ✓ 31 fields (652.25ms)
✓ Direct curl with cross-company=true - 31 fields found
CustomersV3: ✓ 320 fields (719.83ms)
✓ Direct curl with cross-company=true - 320 fields found
PartyLocationPostalAddressesV2: ✓ 39 fields (653.62ms)
✓ Direct curl with cross-company=true - 39 fields found
PartyContactsV3: ✓ 14 fields (619.34ms)
✓ Direct curl with cross-company=true - 14 fields found
ContactPersons: ✓ 121 fields (4255.66ms)
✓ Direct curl with cross-company=true - 121 fields found
SalesDiscountCodes: ✓ 4 fields (623.23ms)
✓ Direct curl with cross-company=true - 4 fields found
ProductSizeCodes: ✓ 4 fields (609.13ms)
✓ Direct curl with cross-company=true - 4 fields found
ProductSizeMappings: ✓ 4 fields (613.19ms)
✓ Direct curl with cross-company=true - 4 fields found
ProductSpecificOrderSettingsV3: ✓ 65 fields (1376.27ms)
✓ Direct curl with cross-company=true - 65 fields found
ProductMasterStyleTranslations: ✓ 9 fields (835.18ms)
✓ Direct curl with cross-company=true - 9 fields found
AddressStates: ✓ 8 fields (613.89ms)
✓ Direct curl with cross-company=true - 8 fields found
VendorProductDescriptionsV2: ✓ 15 fields (627.92ms)
✓ Direct curl with cross-company=true - 15 fields found
ProductFinishChargeItems: ✓ 6 fields (609.21ms)
✓ Direct curl with cross-company=true - 6 fields found
Workers: ✓ 112 fields (640.67ms)
✓ Direct curl with cross-company=true - 112 fields found
CustomerMaterials: ✓ 8 fields (608.88ms)
✓ Direct curl with cross-company=true - 8 fields found
SalesLineCustomerMaterials: ✓ 15 fields (629.66ms)
✓ Direct curl with cross-company=true - 15 fields found
SalesSpecifiers: ✓ 11 fields (615.97ms)
✓ Direct curl with cross-company=true - 11 fields found
VERTariffRates: ✗ Failed (560.09ms)
HTTP Error: 404
ProductAvailableToPromises: ✓ 9 fields (622.54ms)
✓ Direct curl with cross-company=true - 9 fields found
D365 API Field Fetch Status: ✓ 34 successful | ⚠ 1 failed
Failed endpoints will only show fields detected in code, not unused fields from D365.
Show failed endpoints details
  • VERTariffRates (failed in 560.09ms)
    HTTP Error: 404

Disable Debug Mode
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 5 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