#AOT
#Properties
DictTable dt=new SysDictTable(tableNum(CustTable));
FieldId _fieldId= dt.fieldNext(0);
DictField _dictField;
TreeNode node;
str message;
str field;
while(_fieldId)
{
_dictField =dt.fieldObject(_fieldId);
node = TreeNode::findNode(#ExtendedDataTypesPath #AOTDelimiter _dictField.name());
info(strFmt("Field Name %1 , Field Lable %2 and Field Type %3", _dictField.name(),_dictField.label(),_dictField.typeId()));
_fieldId= dt.fieldNext(_fieldId);
}
it return th output as
Message (16.39.18)
Field Name AccountNum , Field Lable Customer account and Field Type 99
Field Name DEL_Name , Field Lable Name and Field Type 962
Field Name DEL_Address , Field Lable Address and Field Type 5
Field Name DEL_Phone , Field Lable Telephone and Field Type 403
Field Name DEL_TeleFax , Field Lable Fax and Field Type 569
Field Name InvoiceAccount , Field Lable Invoice account and Field Type 1148
Field Name CustGroup , Field Lable Customer group and Field Type 103
Field Name LineDisc , Field Lable Line discount and Field Type 104
Field Name PaymTermId , Field Lable Terms of payment and Field Type 1099
Field Name CashDisc , Field Lable Cash discount and Field Type 1100
Field Name Currency , Field Lable Currency and Field Type 1119
Field Name InterCompanyAutoCreateOrders , Field Lable Create intercompany orders and Field Type 4589
Field Name SalesGroup , Field Lable Sales group and Field Type 69
Field Name Blocked , Field Lable Invoicing and delivery on hold and Field Type 1181
Field Name OneTimeCustomer , Field Lable One-time customer and Field Type 696
Field Name AccountStatement , Field Lable Account statement and Field Type 0
Field Name CreditMax , Field Lable Credit limit and Field Type 2850
Field Name MandatoryCreditLimit , Field Lable Mandatory credit limit and Field Type 776
Field Name DEL_Dimension , Field Lable Department and Field Type 132
Field Name VendAccount , Field Lable Vendor account and Field Type 602
Field Name DEL_Telex , Field Lable Telex number and Field Type 570
Field Name PriceGroup , Field Lable Price group and Field Type 111
Field Name MultiLineDisc , Field Lable Multiline discount and Field Type 106
Field Name EndDisc , Field Lable Total discount and Field Type 102
Field Name VATNum , Field Lable Tax exempt number and Field Type 600
Field Name DEL_CountryRegionId , Field Lable Country/region and Field Type 91
Field Name InventLocation , Field Lable Warehouse and Field Type 239
Field Name DlvTerm , Field Lable Delivery terms and Field Type 2955
Field Name DlvMode , Field Lable Mode of delivery and Field Type 2956
Field Name MarkupGroup , Field Lable Charges group and Field Type 105
Field Name ClearingPeriod , Field Lable Settle period and Field Type 1101
Field Name DEL_ZipCode , Field Lable ZIP/postal code and Field Type 643
Field Name DEL_State , Field Lable State/province and Field Type 532
Field Name DEL_County , Field Lable County and Field Type 93
Field Name DEL_URL , Field Lable Internet address and Field Type 594
Field Name DEL_Email , Field Lable E-mail and Field Type 153
Field Name DEL_CellularPhone , Field Lable Mobile phone and Field Type 405
Field Name DEL_PhoneLocal , Field Lable Extension and Field Type 404
Field Name FreightZone , Field Lable UPS zone and Field Type 2974
Field Name CreditRating , Field Lable Credit rating and Field Type 1106
Field Name TaxGroup , Field Lable Sales tax group and Field Type 556
Field Name StatisticsGroup , Field Lable Statistics group and Field Type 113
Field Name PaymMode , Field Lable Method of payment and Field Type 109
Field Name CommissionGroup , Field Lable Commission group and Field Type 66
Field Name BankAccount , Field Lable Bank account and Field Type 101
Field Name PaymSched , Field Lable Payment schedule and Field Type 360
Field Name DEL_NameAlias , Field Lable Search name and Field Type 1110
Field Name ContactPersonId , Field Lable Primary contact and Field Type 673
Field Name InvoiceAddress , Field Lable Invoice address and Field Type 1672
Field Name OurAccountNum , Field Lable Account number and Field Type 100
Field Name SalesPoolId , Field Lable Sales order pool and Field Type 1683
Field Name InclTax , Field Lable Prices include sales tax and Field Type 1770
Field Name CustItemGroupId , Field Lable Item - customer group and Field Type 1794
Field Name numberSequenceGroup , Field Lable Number sequence group and Field Type 1801
Field Name DEL_LanguageId , Field Lable Language and Field Type 1852
Field Name PaymDayId , Field Lable Payment day and Field Type 1956
Field Name LineOfBusinessId , Field Lable Line of business and Field Type 2160
Field Name DestinationCodeId , Field Lable Destination code and Field Type 2164
Field Name GiroType , Field Lable On a customer invoice and Field Type 745
Field Name SuppItemGroupId , Field Lable Supplementary item and Field Type 2114
Field Name GiroTypeInterestNote , Field Lable On an interest note and Field Type 3024
Field Name TaxLicenseNum , Field Lable Packing duty license number and Field Type 2174
Field Name WebSalesOrderDisplay , Field Lable History available and Field Type 0
Field Name PaymSpec , Field Lable Payment specification and Field Type 364
Field Name BankCentralBankPurposeText , Field Lable Notes and Field Type 2491
Field Name BankCentralBankPurposeCode , Field Lable Central bank purpose code and Field Type 2497
Field Name DEL_PrintModuleType , Field Lable Print management and Field Type 0
Field Name DEL_City , Field Lable City and Field Type 54
Field Name DEL_Street , Field Lable Street and Field Type 3153
Field Name DEL_Pager , Field Lable Pager and Field Type 3361
Field Name DEL_SMS , Field Lable SMS and Field Type 3362
Field Name InterCompanyAllowIndirectCreation , Field Lable Create indirect order lines and Field Type 1510
Field Name PackMaterialFeeLicenseNum , Field Lable License number and Field Type 3632
Field Name TaxBorderNumber_FI , Field Lable Tax border number and Field Type 4761
Field Name EinvoiceEANNum , Field Lable EAN and Field Type 314
Field Name FiscalCode , Field Lable Fiscal code and Field Type 4140
Field Name DlvReason , Field Lable Delivery reason and Field Type 4147
Field Name ForecastDMPInclude , Field Lable Demand planning and Field Type 4215
Field Name GiroTypeCollectionletter , Field Lable On a collection letter and Field Type 4320
Field Name SalesCalendarId , Field Lable Receipt calendar and Field Type 750
Field Name CustClassificationId , Field Lable Customer classification group and Field Type 2588
Field Name InterCompanyDirectDelivery , Field Lable Direct delivery and Field Type 4590
Field Name EnterpriseNumber , Field Lable Enterprise number and Field Type 4112
Field Name ShipCarrierAccount , Field Lable Carrier account number and Field Type 6044
Field Name GiroTypeProjInvoice , Field Lable On a project invoice and Field Type 1015
Field Name InventSiteId , Field Lable Site and Field Type 5441
Field Name OrderEntryDeadlineGroupId , Field Lable Order entry deadline and Field Type 5127
Field Name ShipCarrierId , Field Lable Carrier ID and Field Type 6074
Field Name ShipCarrierFuelSurcharge , Field Lable Charge fuel surcharge and Field Type 6073
Field Name ShipCarrierBlindShipment , Field Lable Blind shipment and Field Type 659
Field Name DEL_PartyType , Field Lable Record type and Field Type 0
Field Name DEL_PartyId , Field Lable Party ID and Field Type 5442
Field Name ShipCarrierAccountCode , Field Lable Account code and Field Type 6046
Field Name DEL_ProjPriceGroup , Field Lable Project price and Field Type 5878
Field Name GiroTypeFreeTextInvoice , Field Lable On a free text invoice and Field Type 745
Field Name SyncEntityId , Field Lable Entity ID and Field Type 5834
Field Name SyncVersion , Field Lable Version and Field Type 5857
Field Name Memo , Field Lable Note and Field Type 8242
Field Name SalesDistrictId , Field Lable Sales district and Field Type 8290
Field Name SegmentId , Field Lable Segment and Field Type 8292
Field Name SubsegmentId , Field Lable Subsegment and Field Type 8296
Field Name RFIDItemTagging , Field Lable Item tagging and Field Type 2389
Field Name RFIDCaseTagging , Field Lable Case tagging and Field Type 2366
Field Name RFIDPalletTagging , Field Lable Pallet tagging and Field Type 2391
Field Name CompanyChainId , Field Lable Company chain and Field Type 8245
Field Name DEL_MainContactId , Field Lable Employee responsible and Field Type 8240
Field Name CompanyIdSiret , Field Lable French Siret and Field Type 2404
Field Name DEL_CompanyIdNAF , Field Lable NAF code and Field Type 2403
Field Name Party , Field Lable Name and Field Type 7002
Field Name IdentificationNumber , Field Lable ID number and Field Type 6333
Field Name PartyCountry , Field Lable Country/region and Field Type 91
Field Name PartyState , Field Lable State/province and Field Type 532
Field Name OrgId , Field Lable National Registry number and Field Type 6345
Field Name PaymIdType , Field Lable Payment ID type and Field Type 9545
Field Name FactoringAccount , Field Lable Factoring account and Field Type 9544
Field Name DefaultDimension , Field Lable Dimension and Field Type 7830
Field Name CustExcludeCollectionFee , Field Lable Exclude collection fees and Field Type 6308
Field Name CustExcludeInterestCharges , Field Lable Exclude interest charges and Field Type 6307
Field Name CompanyNAFCode , Field Lable NAF code and Field Type 11779
Field Name BankCustPaymIdTable , Field Lable Payment ID type and Field Type 11780
Field Name GiroTypeAccountStatement , Field Lable Associated payment attachment on account statement and Field Type 7767
Field Name MainContactWorker , Field Lable Employee responsible and Field Type 14081
Field Name CreditCardAddressVerification , Field Lable Address verification and Field Type 0
Field Name CreditCardCVC , Field Lable Prompt for card verification value and Field Type 0
Field Name CreditCardAddressVerificationVoid , Field Lable Void transaction when no results are available and Field Type 14753
Field Name CreditCardAddressVerificationLevel , Field Lable Address verification status required to accept transactions and Field Type 0
Field Name CompanyType_MX , Field Lable Company type and Field Type 0
Field Name Rfc_MX , Field Lable RFC number and Field Type 18188
Field Name Curp_MX , Field Lable CURP number and Field Type 18187
Field Name StateInscription_MX , Field Lable State inscription and Field Type 18189
Field Name ResidenceForeignCountryRegionId_IT , Field Lable Residence foreign country/region and Field Type 6950
Field Name BirthCountyCode_IT , Field Lable Birth county and Field Type 18102
Field Name BirthDate_IT , Field Lable Birth date and Field Type 714
Field Name BirthPlace_IT , Field Lable Birth place and Field Type 54
Field Name EInvoice , Field Lable eInvoice and Field Type 336
Field Name EInvoiceRegister_IT , Field Lable eInvoice register and Field Type 336
Field Name CCMNum_BR , Field Lable CCM and Field Type 8818
Field Name CNPJCPFNum_BR , Field Lable CNPJ/CPF and Field Type 8824
Field Name PBACustGroupId , Field Lable Product model and Field Type 9066
Field Name IENum_BR , Field Lable IE and Field Type 9407
Field Name DEL_DistrictName_BR , Field Lable DEL_DistrictName_BR and Field Type 0
Field Name DEL_CustInvoiceType_BR , Field Lable Fiscal document type and Field Type 8989
Field Name DEL_CustCategory_BR , Field Lable Category and Field Type 0
Field Name SuframaNumber_BR , Field Lable SUFRAMA number and Field Type 8963
Field Name Suframa_BR , Field Lable SUFRAMA and Field Type 8962
Field Name CustFinalUser_BR , Field Lable Final user and Field Type 8988
Field Name DEL_InvoiceSeries_BR , Field Lable Series and Field Type 9413
Field Name InterestCode_BR , Field Lable Interest code and Field Type 9571
Field Name FineCode_BR , Field Lable Fine code and Field Type 9570
Field Name SuframaPISCOFINS_BR , Field Lable Discount PIS and COFINS and Field Type 0
Field Name DEL_EstablishmentType_BR , Field Lable Type of establishment and Field Type 9573
Field Name TaxWithholdCalculate_TH , Field Lable Calculate withholding tax and Field Type 9854
Field Name TaxWithholdGroup_TH , Field Lable Withholding tax group and Field Type 4205
Field Name ConsDay_JP , Field Lable Consolidation day and Field Type 14299
Field Name DEL_NameKana , Field Lable Kana name and Field Type 9392
Field Name DEL_PaymCode_LV , Field Lable Payment transaction code and Field Type 7398
Field Name DEL_AddressNumber_BR , Field Lable Street number and Field Type 9714
Field Name DEL_AddressComplement_BR , Field Lable Street complement and Field Type 9713
Field Name NIT_BR , Field Lable NIT and Field Type 9913
Field Name INSSCEI_BR , Field Lable INSS-CEI and Field Type 9914
Field Name CNAE_BR , Field Lable CNAE and Field Type 9916
Field Name ICMSContributor_BR , Field Lable ICMS contributor and Field Type 9875
Field Name ServiceCodeOnDlvAddress_BR , Field Lable Service on delivery address and Field Type 9980
Field Name DEL_ISS_BR , Field Lable ISS and Field Type 9983
Field Name DEL_VATRegistrationNum_CN , Field Lable VAT registration number and Field Type 7800
Field Name InventProfileType_RU , Field Lable Kind of activity and Field Type 0
Field Name InventProfileId_RU , Field Lable Inventory profile and Field Type 12002
Field Name DEL_Commissionarate_IN , Field Lable DEL_Commissionarate_IN and Field Type 0
Field Name DEL_Division_IN , Field Lable DEL_Division_IN and Field Type 0
Field Name DEL_Range_IN , Field Lable DEL_Range_IN and Field Type 0
Field Name DEL_IECNumber_IN , Field Lable IEC number and Field Type 10100
Field Name DEL_ECCNumber_IN , Field Lable ECC number and Field Type 10100
Field Name DEL_STCNumber_IN , Field Lable STC number and Field Type 10100
Field Name DEL_TIN_IN , Field Lable Tax Identification Number (TIN) and Field Type 10100
Field Name DEL_SalesTaxRegistrationNumber_IN , Field Lable Registration number and Field Type 10100
Field Name DEL_PreferentialCustomer_IN , Field Lable Preferential customer and Field Type 336
Field Name TaxWithholdCalculate_IN , Field Lable Calculate withholding tax and Field Type 336
Field Name DEL_TAN_IN , Field Lable DEL_TAN_IN and Field Type 0
Field Name DEL_TDSGroup_IN , Field Lable TDS group and Field Type 4205
Field Name DEL_TCSGroup_IN , Field Lable TCS group and Field Type 4205
Field Name DEL_ForeignCustomer_IN , Field Lable Foreign customer and Field Type 336
Field Name DEL_NatureOfAssessee_IN , Field Lable Nature of assessee and Field Type 0
Field Name DEL_PANReferenceNumber_IN , Field Lable Reference number and Field Type 10086
Field Name DEL_PANStatus_IN , Field Lable Status and Field Type 0
Field Name DEL_PANNumber_IN , Field Lable Number and Field Type 10085
Field Name DEL_TributarySubstitutionRegistry_BR , Field Lable Tributary Substitution Registry and Field Type 10196
Field Name DEL_DeliveryCustCNPJCPFNum_BR , Field Lable CNPJ/CPF and Field Type 8824
Field Name DEL_DeliveryCustCategory_BR , Field Lable Category and Field Type 0
Field Name DEL_DeliveryCustIENum_BR , Field Lable IE and Field Type 9407
Field Name UnitedVATInvoice_LT , Field Lable United VAT invoice and Field Type 10328
Field Name ForeignerId_BR , Field Lable Foreigner ID and Field Type 19838
Field Name DEL_INN_RU , Field Lable INN and Field Type 16028
Field Name DEL_CodeOKPO_RU , Field Lable Classification by OKPO and Field Type 16049
Field Name DEL_CodeOKDP_RU , Field Lable Activity category by OKWED and Field Type 16048
Field Name DEL_KPP_RU , Field Lable Registry reason code and Field Type 16279
Field Name DEL_OKATO_RU , Field Lable RCOAD and Field Type 16679
Field Name DEL_TownId_RU , Field Lable City and Field Type 16239
Field Name DEL_SettlementId_RU , Field Lable Settlement and Field Type 16237
Field Name DEL_StreetId_RU , Field Lable Street code and Field Type 16238
Field Name DEL_Flat_RU , Field Lable Apartment and Field Type 16093
Field Name DEL_Building_RU , Field Lable Building and Field Type 16090
Field Name DEL_Estate_RU , Field Lable Group of houses and Field Type 16091
Field Name DEL_FMICode_LT , Field Lable FMI reg.no and Field Type 16794
Field Name EnterpriseCode , Field Lable Enterprise code and Field Type 16789
Field Name CommercialRegisterSection , Field Lable Section of commercial register and Field Type 16745
Field Name CommercialRegisterInsetNumber , Field Lable Inset number and Field Type 16743
Field Name CommercialRegister , Field Lable Kept at commercial register and Field Type 16742
Field Name RegNum_W , Field Lable Registration number and Field Type 73
Field Name DEL_CoRegNum_CZ , Field Lable Tax registration number and Field Type 3338
Field Name IsResident_LV , Field Lable Resident and Field Type 16827
Field Name IntBank_LV , Field Lable Intermediary bank and Field Type 101
Field Name PaymentReference_EE , Field Lable Payment reference and Field Type 100296
Field Name PackageDepositExcempt_PL , Field Lable Deposit exempt and Field Type 16878
Field Name FedNonFedIndicator , Field Lable Federal/Non-Federal indicator and Field Type 0
Field Name IRS1099CIndicator , Field Lable 1099-C indicator and Field Type 100286
Field Name AgencyLocationCode , Field Lable Agency location code and Field Type 16417
Field Name FederalComments , Field Lable Comments and Field Type 16418
Field Name DEL_PSACompany , Field Lable DEL_PSACompany and Field Type 0
Field Name DEL_PSAContractNotUsed , Field Lable Contract not used and Field Type 0
Field Name DEL_PSADesignId , Field Lable Invoice format and Field Type 103821
Field Name DEL_Submited , Field Lable Submitted and Field Type 0
Field Name usePurchRequest , Field Lable Purchase request required and Field Type 15727
Field Name MCRMergedParent , Field Lable Merged parent and Field Type 99
Field Name MCRMergedRoot , Field Lable Merged root and Field Type 99
Field Name CashDiscBaseDays , Field Lable Payment terms base days and Field Type 100213
Field Name CustTradingPartnerCode , Field Lable Trading partner code and Field Type 16421
Field Name ExportSales_PL , Field Lable Export sale and Field Type 101293
Field Name FiscalDocType_PL , Field Lable Printed document and Field Type 0
Field Name ForeignResident_RU , Field Lable Foreign counteragent and Field Type 14876
Field Name GenerateIncomingFiscalDocument_BR , Field Lable Generate incoming fiscal document and Field Type 100501
Field Name InvoicePostingType_RU , Field Lable Posting type and Field Type 0
Field Name IssuerCountry_HU , Field Lable Issuer country/region and Field Type 91
Field Name LvPaymTransCodes , Field Lable Payment transaction code and Field Type 100778
Field Name MandatoryVatDate_PL , Field Lable VAT date is required and Field Type 16876
Field Name PassportNo_HU , Field Lable Passport number and Field Type 100768
Field Name PdsCustRebateGroupId , Field Lable Customer rebate group and Field Type 101010
Field Name PdsFreightAccrued , Field Lable Freight accrual and Field Type 101133
Field Name PdsRebateTMAGroup , Field Lable Customer TMA group and Field Type 101244
Field Name TaxPeriodPaymentCode_PL , Field Lable VAT report date code and Field Type 16913
Field Name UseCashDisc , Field Lable Use cash discount and Field Type 0
Field Name DIGEInvoiceIntermediator , Field Lable Electronic invoice intermediator and Field Type 102944
Field Name DIGEInvoiceAddress , Field Lable Electronic invoice address and Field Type 102943
Field Name DIGSendFinvoice , Field Lable Finvoice and Field Type 336
Field Name DIGFinvoiceSendAutomatically , Field Lable Send automatically and Field Type 336
Field Name DIGFinvoiceCollectionOnlyOneFile , Field Lable Collection letter - only one file and Field Type 336
Field Name DAXIntegrationId , Field Lable The integration key for Dynamics Connector and Field Type 102320
Field Name DefaultDirectDebitMandate , Field Lable Direct debit mandate ID and Field Type 102327
Field Name EntryCertificateRequired_W , Field Lable Entry certificate required and Field Type 102878
Field Name IssueOwnEntryCertificate_W , Field Lable Issue entry certificate and Field Type 104084
Field Name Affiliated_RU , Field Lable Affiliated and Field Type 102323
Field Name DEL_PdsRegionCode , Field Lable DEL_PdsRegionCode and Field Type 0
Field Name DEL_PdsSellableDays , Field Lable Sellable days and Field Type 101264
Field Name DEL_RegNumber_LV , Field Lable Routing number and Field Type 73
Field Name AuthorityOffice_IT , Field Lable Authority office and Field Type 19843
Field Name ForeignTaxRegistration_MX , Field Lable Tax registration ID and Field Type 13374
Field Name PresenceType_BR , Field Lable Presence type and Field Type 0
Field Name TaxGSTReliefGroupHeading_MY , Field Lable GST relief group and Field Type 104750
Field Name CustWhtContributionType_BR , Field Lable Customer contribution type and Field Type 103726
Field Name DefaultInventStatusId , Field Lable Default inventory status ID and Field Type 22893
Field Name ExpressBillOfLading , Field Lable Accepts express bill of lading and Field Type 22838
Field Name PackedExtensions , Field Lable Container and Field Type 101827
Field Name DEL_CustVendRegNum_EE , Field Lable Routing number and Field Type 73
Field Name SON_NoInvoice , Field Lable and Field Type 0
Field Name modifiedDateTime , Field Lable Modified date and time and Field Type 61449
Field Name dEL_ModifiedTime , Field Lable Modified time and Field Type 61450
Field Name modifiedBy , Field Lable Modified by and Field Type 61451
Field Name modifiedTransactionId , Field Lable Modified ID and Field Type 61452
Field Name createdDateTime , Field Lable Created date and time and Field Type 61453
Field Name dEL_CreatedTime , Field Lable Created time and Field Type 61454
Field Name createdBy , Field Lable Created by and Field Type 61455
Field Name createdTransactionId , Field Lable Created ID and Field Type 61456
Field Name dataAreaId , Field Lable Company and Field Type 61457
Field Name sequenceNum , Field Lable Sequence Number and Field Type 61460
Field Name recVersion , Field Lable Record Version and Field Type 61473
Field Name unionAllBranchId , Field Lable UnionAll branch ID and Field Type 61479
Field Name rowNumber , Field Lable Row number and Field Type 61480
Field Name relationType , Field Lable Relation type field and Field Type 61528
Field Name Partition , Field Lable Partition and Field Type 61566
Field Name RecId , Field Lable Record-ID and Field Type 61448
Field Name TableId , Field Lable Table ID and Field Type 61440
Instead of file type it does not return edt type and not sure how to get edt type with dictField?
Thanks
