Table 18 Customer in 23
- App
- Base Application
- Namespace
- Microsoft.Sales.Customer
Fields, 173Keys, 20Procedures, 66Events, 56
Versions171819202122232425262728latest
Source29
Fields, 173
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | No. | Code[20] | - | ||||
| 2 | Name | Text[100] | - | ||||
| 3 | Search Name | Code[100] | - | ||||
| 4 | Name 2 | Text[50] | - | ||||
| 5 | Address | Text[100] | - | ||||
| 6 | Address 2 | Text[50] | - | ||||
| 7 | City | Text[30] | - | ||||
| 8 | Contact | Text[100] | - | ||||
| 9 | Phone No. | Text[30] | - | ||||
| 10 | Telex No. | Text[20] | - | ||||
| 11 | Document Sending Profile | Code[20] | - | ||||
| 12 | Ship-to Code | Code[10] | - | ||||
| 14 | Our Account No. | Text[20] | - | ||||
| 15 | Territory Code | Code[10] | - | ||||
| 16 | Global Dimension 1 Code | Code[20] | - | ||||
| 17 | Global Dimension 2 Code | Code[20] | - | ||||
| 18 | Chain Name | Code[10] | - | ||||
| 19 | Budgeted Amount | Decimal | - | ||||
| 20 | Credit Limit (LCY) | Decimal | - | ||||
| 21 | Customer Posting Group | Code[20] | - | ||||
| 22 | Currency Code | Code[10] | - | ||||
| 23 | Customer Price Group | Code[10] | - | ||||
| 24 | Language Code | Code[10] | - | ||||
| 25 | Registration Number | Text[50] | - | ||||
| 26 | Statistics Group | Integer | - | ||||
| 27 | Payment Terms Code | Code[10] | - | ||||
| 28 | Fin. Charge Terms Code | Code[10] | - | ||||
| 29 | Salesperson Code | Code[20] | - | ||||
| 30 | Shipment Method Code | Code[10] | - | ||||
| 31 | Shipping Agent Code | Code[10] | - | ||||
| 32 | Place of Export | Code[20] | - | ||||
| 33 | Invoice Disc. Code | Code[20] | - | ||||
| 34 | Customer Disc. Group | Code[20] | - | ||||
| 35 | Country/Region Code | Code[10] | - | ||||
| 36 | Collection Method | Code[20] | - | ||||
| 37 | Amount | Decimal | - | ||||
| 38 | Comment | Boolean | - | ||||
| 39 | Blocked | Enum Customer Blocked | - | ||||
| 40 | Invoice Copies | Integer | - | ||||
| 41 | Last Statement No. | Integer | - | ||||
| 42 | Print Statements | Boolean | - | ||||
| 45 | Bill-to Customer No. | Code[20] | - | ||||
| 46 | Priority | Integer | - | ||||
| 47 | Payment Method Code | Code[10] | - | ||||
| 48 | Format Region | Text[80] | - | ||||
| 53 | Last Modified Date Time | DateTime | - | ||||
| 54 | Last Date Modified | Date | - | ||||
| 55 | Date Filter | Date | - | ||||
| 56 | Global Dimension 1 Filter | Code[20] | - | ||||
| 57 | Global Dimension 2 Filter | Code[20] | - | ||||
| 58 | Balance | Decimal | - | ||||
| 59 | Balance (LCY) | Decimal | - | ||||
| 60 | Net Change | Decimal | - | ||||
| 61 | Net Change (LCY) | Decimal | - | ||||
| 62 | Sales (LCY) | Decimal | - | ||||
| 63 | Profit (LCY) | Decimal | - | ||||
| 64 | Inv. Discounts (LCY) | Decimal | - | ||||
| 65 | Pmt. Discounts (LCY) | Decimal | - | ||||
| 66 | Balance Due | Decimal | - | ||||
| 67 | Balance Due (LCY) | Decimal | - | ||||
| 69 | Payments | Decimal | - | ||||
| 70 | Invoice Amounts | Decimal | - | ||||
| 71 | Cr. Memo Amounts | Decimal | - | ||||
| 72 | Finance Charge Memo Amounts | Decimal | - | ||||
| 74 | Payments (LCY) | Decimal | - | ||||
| 75 | Inv. Amounts (LCY) | Decimal | - | ||||
| 76 | Cr. Memo Amounts (LCY) | Decimal | - | ||||
| 77 | Fin. Charge Memo Amounts (LCY) | Decimal | - | ||||
| 78 | Outstanding Orders | Decimal | - | ||||
| 79 | Shipped Not Invoiced | Decimal | - | ||||
| 80 | Application Method | Enum Application Method | - | ||||
| 82 | Prices Including VAT | Boolean | - | ||||
| 83 | Location Code | Code[10] | - | ||||
| 84 | Fax No. | Text[30] | - | ||||
| 85 | Telex Answer Back | Text[20] | - | ||||
| 86 | VAT Registration No. | Text[20] | - | ||||
| 87 | Combine Shipments | Boolean | - | ||||
| 88 | Gen. Bus. Posting Group | Code[20] | - | ||||
| 89 | Picture | Blob | Removed 19.0 | ||||
| Replaced by Image field | |||||||
| 90 | GLN | Code[13] | - | ||||
| 91 | Post Code | Code[20] | - | ||||
| 92 | County | Text[30] | - | ||||
| 93 | EORI Number | Text[40] | - | ||||
| 95 | Use GLN in Electronic Document | Boolean | - | ||||
| 97 | Debit Amount | Decimal | - | ||||
| 98 | Credit Amount | Decimal | - | ||||
| 99 | Debit Amount (LCY) | Decimal | - | ||||
| 100 | Credit Amount (LCY) | Decimal | - | ||||
| 102 | Text[80] | - | |||||
| 103 | Home Page | Text[80] | - | ||||
| 104 | Reminder Terms Code | Code[10] | - | ||||
| 105 | Reminder Amounts | Decimal | - | ||||
| 106 | Reminder Amounts (LCY) | Decimal | - | ||||
| 107 | No. Series | Code[20] | - | ||||
| 108 | Tax Area Code | Code[20] | - | ||||
| 109 | Tax Liable | Boolean | - | ||||
| 110 | VAT Bus. Posting Group | Code[20] | - | ||||
| 111 | Currency Filter | Code[10] | - | ||||
| 113 | Outstanding Orders (LCY) | Decimal | - | ||||
| 114 | Shipped Not Invoiced (LCY) | Decimal | - | ||||
| 115 | Reserve | Enum Reserve Method | - | ||||
| 116 | Block Payment Tolerance | Boolean | - | ||||
| 117 | Pmt. Disc. Tolerance (LCY) | Decimal | - | ||||
| 118 | Pmt. Tolerance (LCY) | Decimal | - | ||||
| 119 | IC Partner Code | Code[20] | - | ||||
| 120 | Refunds | Decimal | - | ||||
| 121 | Refunds (LCY) | Decimal | - | ||||
| 122 | Other Amounts | Decimal | - | ||||
| 123 | Other Amounts (LCY) | Decimal | - | ||||
| 124 | Prepayment % | Decimal | - | ||||
| 125 | Outstanding Invoices (LCY) | Decimal | - | ||||
| 126 | Outstanding Invoices | Decimal | - | ||||
| 130 | Bill-to No. Of Archived Doc. | Integer | - | ||||
| 131 | Sell-to No. Of Archived Doc. | Integer | - | ||||
| 132 | Partner Type | Enum Partner Type | - | ||||
| 133 | Intrastat Partner Type | Enum Partner Type | - | ||||
| 134 | Exclude from Pmt. Practices | Boolean | - | ||||
| 140 | Image | Media | - | ||||
| 150 | Privacy Blocked | Boolean | - | ||||
| 160 | Disable Search by Name | Boolean | - | ||||
| 175 | Allow Multiple Posting Groups | Boolean | - | ||||
| 288 | Preferred Bank Account Code | Code[20] | - | ||||
| 720 | Coupled to CRM | Boolean | Pending 23.0 | ||||
| Replaced by flow field Coupled to Dataverse | |||||||
| 721 | Coupled to Dataverse | Boolean | - | ||||
| 840 | Cash Flow Payment Terms Code | Code[10] | - | ||||
| 5049 | Primary Contact No. | Code[20] | - | ||||
| 5050 | Contact Type | Enum Contact Type | - | ||||
| 5061 | Mobile Phone No. | Text[30] | - | ||||
| 5700 | Responsibility Center | Code[10] | - | ||||
| 5750 | Shipping Advice | Enum Sales Header Shipping Advice | - | ||||
| 5790 | Shipping Time | DateFormula | - | ||||
| 5792 | Shipping Agent Service Code | Code[10] | - | ||||
| 5900 | Service Zone Code | Code[10] | - | ||||
| 5902 | Contract Gain/Loss Amount | Decimal | - | ||||
| 5903 | Ship-to Filter | Code[10] | - | ||||
| 5910 | Outstanding Serv. Orders (LCY) | Decimal | - | ||||
| 5911 | Serv Shipped Not Invoiced(LCY) | Decimal | - | ||||
| 5912 | Outstanding Serv.Invoices(LCY) | Decimal | - | ||||
| 7000 | Price Calculation Method | Enum Price Calculation Method | - | ||||
| 7001 | Allow Line Disc. | Boolean | - | ||||
| 7171 | No. of Quotes | Integer | - | ||||
| 7172 | No. of Blanket Orders | Integer | - | ||||
| 7173 | No. of Orders | Integer | - | ||||
| 7174 | No. of Invoices | Integer | - | ||||
| 7175 | No. of Return Orders | Integer | - | ||||
| 7176 | No. of Credit Memos | Integer | - | ||||
| 7177 | No. of Pstd. Shipments | Integer | - | ||||
| 7178 | No. of Pstd. Invoices | Integer | - | ||||
| 7179 | No. of Pstd. Return Receipts | Integer | - | ||||
| 7180 | No. of Pstd. Credit Memos | Integer | - | ||||
| 7181 | No. of Ship-to Addresses | Integer | - | ||||
| 7182 | Bill-To No. of Quotes | Integer | - | ||||
| 7183 | Bill-To No. of Blanket Orders | Integer | - | ||||
| 7184 | Bill-To No. of Orders | Integer | - | ||||
| 7185 | Bill-To No. of Invoices | Integer | - | ||||
| 7186 | Bill-To No. of Return Orders | Integer | - | ||||
| 7187 | Bill-To No. of Credit Memos | Integer | - | ||||
| 7188 | Bill-To No. of Pstd. Shipments | Integer | - | ||||
| 7189 | Bill-To No. of Pstd. Invoices | Integer | - | ||||
| 7190 | Bill-To No. of Pstd. Return R. | Integer | - | ||||
| 7191 | Bill-To No. of Pstd. Cr. Memos | Integer | - | ||||
| 7600 | Base Calendar Code | Code[10] | - | ||||
| 7601 | Copy Sell-to Addr. to Qte From | Enum Contact Type | - | ||||
| 7602 | Validate EU Vat Reg. No. | Boolean | - | ||||
| 8000 | Id | Guid | Removed 22.0 | ||||
| This functionality will be replaced by the systemID field | |||||||
| 8001 | Currency Id | Guid | - | ||||
| 8002 | Payment Terms Id | Guid | - | ||||
| 8003 | Shipment Method Id | Guid | - | ||||
| 8004 | Payment Method Id | Guid | - | ||||
| 9003 | Tax Area ID | Guid | - | ||||
| 9004 | Tax Area Display Name | Text[100] | Removed 15.0 | ||||
| This field is not needed and it should not be used. | |||||||
| 9005 | Contact ID | Guid | - | ||||
| 9006 | Contact Graph Id | Text[250] | - | ||||
Keys, 20
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | No. | - |
| Key2 | Search Name | - |
| Key3 | Customer Posting Group | - |
| Key4 | Currency Code | - |
| Key5 | Country/Region Code | - |
| Key6 | Gen. Bus. Posting Group | - |
| Key7 | Name, Address, City | - |
| Key8 | VAT Registration No. | - |
| Key9 | Name | - |
| Key10 | City | - |
| Key11 | Post Code | - |
| Key12 | Phone No. | - |
| Key13 | Contact | - |
| Key14 | Blocked | - |
| Key15 | Primary Contact No. | - |
| Key16 | Salesperson Code | - |
| Key17 | SystemModifiedAt | - |
| Key20 | Partner Type, Country/Region Code | - |
| Key21 | Coupled to CRM | - |
| Key22 | IC Partner Code | - |
Procedures, 66
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| AssistEdit | (Record Customer) | Boolean | public | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | |
| ShowContact | () | public | - | |
| SetInsertFromContact | (Boolean) | public | - | |
| CheckBlockedCustOnDocs | (Record Customer, Enum Sales Document Type, Boolean, Boolean) | public | - | |
| CheckBlockedCustOnJnls | (Record Customer, Enum Gen. Journal Document Type, Boolean) | public | - | |
| CustBlockedErrorMessage | (Record Customer, Boolean) | public | - | |
| CustPrivacyBlockedErrorMessage | (Record Customer, Boolean) | public | - | |
| GetPrivacyBlockedGenericErrorText | (Record Customer) | Text[250] | public | - |
| DisplayMap | () | public | - | |
| GetPriceCalculationMethod | () | Enum Price Calculation Method | public | - |
| GetTotalAmountLCY | () | Decimal | public | - |
| GetTotalAmountLCYUI | () | Decimal | public | - |
| GetSalesLCY | () | Decimal | public | - |
| CalcAvailableCredit | () | Decimal | public | - |
| CalcAvailableCreditUI | () | Decimal | public | - |
| CalcOverdueBalance | () | Decimal | public | - |
| GetLegalEntityType | () | Text | public | - |
| GetLegalEntityTypeLbl | () | Text | public | - |
| SetStyle | () | Text | public | - |
| HasValidDDMandate | (Date) | Boolean | public | - |
| GetReturnRcdNotInvAmountLCY | () | Decimal | public | - |
| GetInvoicedPrepmtAmountLCY | () | Decimal | public | - |
| CalcCreditLimitLCYExpendedPct | () | Decimal | public | - |
| CreateAndShowNewInvoice | () | public | - | |
| CreateAndShowNewOrder | () | public | - | |
| CreateAndShowNewCreditMemo | () | public | - | |
| CreateAndShowNewQuote | () | public | - | |
| GetBillToCustomerNo | () | Code[20] | public | - |
| HasAddressIgnoreCountryCode | () | Boolean | public | - |
| HasAddress | () | Boolean | public | - |
| HasDifferentAddress | (Record Customer) | Boolean | public | - |
| GetCustNo | (Text) | Text | public | - |
| GetCustNoOpenCard | (Text, Boolean, Boolean) | Code[20] | public | - |
| CreateNewCustomer | (Text[100], Boolean) | Code[20] | public | - |
| SelectCustomer | (var Record Customer) | Boolean | public | - |
| LookupCustomer | (var Record Customer) | Boolean | public | - |
| OpenCustomerLedgerEntries | (Boolean) | public | - | |
| SetInsertFromTemplate | (Boolean) | public | - | |
| IsLookupRequested | () | Boolean | public | - |
| IsBlocked | () | Boolean | public | - |
| HasAnyOpenOrPostedDocuments | () | Boolean | public | - |
| GetInsertFromContact | () | Boolean | public | - |
| GetInsertFromTemplate | () | Boolean | public | - |
| SetAddress | (Text[100], Text[50], Code[20], Text[30], Text[30], Code[10], Text[100]) | public | - | |
| FindByEmail | (var Record Customer, Text) | Boolean | public | - |
| UpdateReferencedIds | () | public | - | |
| GetReferencedIds | (var Record Field) | public | - | |
| SetForceUpdateContact | (Boolean) | public | - | |
| UpdateCurrencyId | () | public | - | |
| UpdatePaymentTermsId | () | public | - | |
| UpdateShipmentMethodId | () | public | - | |
| UpdatePaymentMethodId | () | public | - | |
| UpdateTaxAreaId | () | public | - | |
| CheckBlockedCustOnJnls | (Record Customer, var Record Gen. Journal Line, Boolean) | public | - | |
| GetPrimaryContact | (Code[20], var Record Contact) | public | - | |
| ToPriceSource | (var Record Price Source) | public | - | |
| CopyFromNewCustomerTemplate | (Record Customer Templ.) | public | - | |
| IsContactUpdateNeeded | () | Boolean | public | - |
| SetDefaultSalesperson | () | protected | - | |
| VATRegistrationValidation | () | public | - | |
| GetTopCustomerHeadlineQueryDocumentTypeFilter | () | Text | public | - |
| GetBalanceAsVendor | (var Code[20]) | Decimal | public | - |
| GetLinkedVendor | () | Code[20] | public | - |
| SetLastModifiedDateTime | () | protected | - | |
| CheckAllowMultiplePostingGroups | () | public | - |
Events, 56
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterHasAnyOpenOrPostedDocuments | (var Record Customer, var Boolean) | - |
| Integration event | OnAfterLookupCity | (var Record Customer, var Record Post Code) | - |
| Integration event | OnAfterSetLastModifiedDateTime | (var Record Customer) | - |
| Integration event | OnAfterValidateCity | (var Record Customer, Record Customer) | - |
| Integration event | OnAfterValidatePostCode | (var Record Customer, Record Customer) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Customer, var Record Customer, Integer, var Code[20]) | - |
| Integration event | OnAssistEditOnBeforeExit | (var Record Customer) | - |
| Integration event | OnBeforeCheckBlockedCust | (Record Customer, Option, Option, Boolean, Boolean, var Boolean) | - |
| Integration event | OnBeforeCreateNewCustomer | (Text[100], Boolean, var Code[20], var Boolean) | - |
| Integration event | OnBeforeCalcOverdueBalance | (var Record Customer, var Decimal, var Boolean) | - |
| Integration event | OnBeforeGetInvoicedPrepmtAmountLCY | (var Record Customer, var Decimal, var Boolean) | - |
| Integration event | OnBeforeGetTotalAmountLCY | (var Record Customer, var Decimal, var Boolean) | - |
| Integration event | OnBeforeGetTotalAmountLCYUI | (var Record Customer) | - |
| Integration event | OnBeforeGetTotalAmountLCYCommon | (var Record Customer, var Decimal, var Boolean) | - |
| Integration event | OnBeforeGetSalesLCY | (var Record Customer, var Record Customer, var Decimal, var Boolean) | - |
| Integration event | OnBeforeInsert | (var Record Customer, var Boolean) | - |
| Integration event | OnBeforeLookupCity | (var Record Customer, var Record Post Code) | - |
| Integration event | OnBeforeLookupPostCode | (var Record Customer, var Record Post Code) | - |
| Integration event | OnBeforeOpenCustomerLedgerEntries | (var Record Customer, var Record Detailed Cust. Ledg. Entry, Boolean, var Boolean) | - |
| Integration event | OnBeforeSetDefaultSalesperson | (var Record Customer, var Boolean) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Customer, var Record Customer, Integer, var Code[20], var Boolean) | - |
| Integration event | OnBeforeVATRegistrationValidation | (var Record Customer, var Boolean) | - |
| Integration event | OnGetCustNoOpenCardOnBeforeCustomerFindSet | (var Record Customer) | - |
| Integration event | OnGetCustNoOpenCardOnBeforeFilterCustomer | (var Record Customer) | - |
| Integration event | OnGetCustNoOpenCardOnAfterSetCustomerFilters | (var Record Customer, var Text) | - |
| Integration event | OnMarkCustomersWithSimilarNameOnBeforeCustomerFindSet | (var Record Customer) | - |
| Integration event | OnBeforeCheckCustomerContactRelation | (Record Contact, Record Contact Business Relation, var Boolean) | - |
| Integration event | OnBeforeValidateEmail | (var Record Customer, var Boolean, Record Customer) | - |
| Integration event | OnShowContactOnBeforeOpenContactCard | (var Record Contact, var Integer) | - |
| Integration event | OnShowContactOnBeforeOpenContactList | (var Record Contact, var Integer) | - |
| Integration event | OnBeforeIsContactUpdateNeeded | (Record Customer, Record Customer, var Boolean, Boolean) | - |
| Integration event | OnAfterCopyFromNewCustomerTemplate | (var Record Customer, Record Customer Templ.) | - |
| Integration event | OnAfterOnInsert | (var Record Customer, Record Customer) | - |
| Integration event | OnBeforeCheckBlockedCustOnJnls | (Record Customer, var Record Gen. Journal Line, Boolean, var Boolean) | - |
| Integration event | OnBeforeOnDelete | (var Record Customer, var Boolean) | - |
| Integration event | OnBeforeValidateVATRegistrationNo | (var Record Customer, Record Customer, Integer, var Boolean) | - |
| Integration event | OnGetCustNoOpenCardOnAfterOnAfterCustomerFilterFromStart | (var Record Customer) | - |
| Integration event | OnBeforeCustBlockedErrorMessage | (Record Customer, Boolean, var Boolean) | - |
| Integration event | OnBeforeGetCustNoOpenCard | (Text, Boolean, var Boolean, var Code[20], var Boolean) | - |
| Integration event | OnBeforeTestNoSeries | (var Record Customer, Record Customer, var Boolean) | - |
| Integration event | OnBeforeUpdateDirectDebitPmtTermsCode | (var Record Customer, var Boolean) | - |
| Integration event | OnBeforeValidateContact | (var Boolean, var Record Customer) | - |
| Integration event | OnAfterGetTopCustomerHeadlineQueryDocumentTypeFilter | (var Text) | - |
| Integration event | OnAfterHasAddressIgnoreCountryCode | (Record Customer, var Boolean) | - |
| Integration event | OnAfterHasDifferentAddress | (Record Customer, Record Customer, var Boolean) | - |
| Integration event | OnBeforeCheckIfOrderSalesLinesExist | (var Record Customer, var Boolean) | - |
| Integration event | OnBeforeOnRename | (var Record Customer, Record Customer, var Boolean) | - |
| Integration event | OnGetBalanceAsVendorOnBeforeCalcBalance | (var Record Vendor) | - |
| Integration event | OnAfterLookupPostCode | (var Record Customer, Record Customer, var Record Post Code) | - |
| Integration event | OnBeforeValidateCity | (var Record Customer, var Record Post Code, Integer, var Boolean) | - |
| Integration event | OnBeforeValidatePostCode | (var Record Customer, var Record Post Code, Integer, var Boolean) | - |
| Integration event | OnBeforeValidateRegistrationNumber | (var Record Customer, var Boolean) | - |
| Integration event | OnBeforeLookupContactList | (var Record Customer, var Boolean, Integer) | - |
| Integration event | OnBeforeCheckAllowMultiplePostingGroups | (var Boolean) | - |
| Integration event | OnGetCustNoOpenCardOnAfterMarkCustomersWithSimilarName | (var Record Customer) | - |
| Integration event | OnBeforeCalcAvailableCreditCommon | (var Record Customer, Boolean, var Decimal, var Decimal, var Boolean) | - |