Table 18 Customer

Base Application, Microsoft.Sales.Customer

src/Layers/W1/BaseApp/Sales/Customer/Customer.Table.al111 procedures and triggers, in source order. Copyright (c) Microsoft Corporation. MIT

No..OnValidate line 102, trigger

  1. 104callsTestNoSeries

Name.OnValidate line 118, trigger

  1. 123callsUpdateMyCustomer

City.OnLookup line 175, trigger

  1. 177raisesOnBeforeLookupCity
  2. 179callsTable 225 Post Code LookupPostCode
  3. 181raisesOnAfterLookupCity

City.OnValidate line 184, trigger

  1. 189raisesOnBeforeValidateCityIsHandled
  2. 191callsTable 225 Post Code ValidateCity
  3. 193callsCodeunit 200 Alt. Cust. VAT. Reg. Facade CheckCustomerConsistency
  4. 195raisesOnAfterValidateCity

Contact.OnLookup line 207, trigger

  1. 209callsLookupContactList

Contact.OnValidate line 212, trigger

  1. 217raisesOnBeforeValidateContactIsHandled
  2. 224writesTable 18 Customer Modify
  3. 225callsCodeunit 5056 CustCont-Update OnModify
  4. 226callsCodeunit 5056 CustCont-Update InsertNewContactPerson
  5. 227writesTable 18 Customer Modify(true)

Phone No..OnValidate line 241, trigger

  1. 251callsSetForceUpdateContact
  2. 253callsUpdateMyCustomer

Global Dimension 1 Code.OnValidate line 309, trigger

  1. 311callsValidateShortcutDimCode

Global Dimension 2 Code.OnValidate line 324, trigger

  1. 326callsValidateShortcutDimCode

Currency Code.OnValidate line 373, trigger

  1. 375callsUpdateCurrencyId

Language Code.OnValidate line 396, trigger

  1. 398callsUpdateFormatRegion

Registration Number.OnValidate line 410, trigger

  1. 415raisesOnBeforeValidateRegistrationNumberIsHandled

Payment Terms Code.OnValidate line 439, trigger

  1. 441callsUpdatePaymentTermsId

Salesperson Code.OnValidate line 462, trigger

  1. 464callsValidateSalesPersonCode

Shipment Method Code.OnValidate line 476, trigger

  1. 478callsUpdateShipmentMethodId

Shipping Agent Code.OnValidate line 491, trigger

  1. 494validatesTable 18 Customer Shipping Agent Service Code

Country/Region Code.OnValidate line 532, trigger

  1. 534callsTable 225 Post Code CheckClearPostCodeCityCounty
  2. 537callsVATRegistrationValidation
  3. 538callsCodeunit 200 Alt. Cust. VAT. Reg. Facade CheckCustomerConsistency

Payment Method Code.OnValidate line 645, trigger

  1. 647callsUpdatePaymentMethodId
  2. 652callsUpdateDirectDebitPmtTermsCode

VAT Registration No..OnValidate line 1120, trigger

  1. 1125raisesOnBeforeValidateVATRegistrationNoIsHandled
  2. 1131callsVATRegistrationValidation

Gen. Bus. Posting Group.OnValidate line 1152, trigger

  1. 1155callsTable 250 Gen. Business Posting Group ValidateVatBusPostingGroup
  2. 1156validatesTable 18 Customer VAT Bus. Posting Group

GLN.OnValidate line 1168, trigger

  1. 1173callsCodeunit 1607 GLN Calculator AssertValidCheckDigit13

Post Code.OnLookup line 1188, trigger

  1. 1190raisesOnBeforeLookupPostCode
  2. 1192callsTable 225 Post Code LookupPostCode
  3. 1194raisesOnAfterLookupPostCode

Post Code.OnValidate line 1197, trigger

  1. 1202raisesOnBeforeValidatePostCodeIsHandled
  2. 1204callsTable 225 Post Code ValidatePostCode
  3. 1206callsCodeunit 200 Alt. Cust. VAT. Reg. Facade CheckCustomerConsistency
  4. 1208raisesOnAfterValidatePostCode

E-Mail.OnValidate line 1320, trigger

  1. 1322callsValidateEmail

Tax Area Code.OnValidate line 1405, trigger

  1. 1407callsUpdateTaxAreaId

VAT Bus. Posting Group.OnValidate line 1427, trigger

  1. 1429callsUpdateTaxAreaId

Block Payment Tolerance.OnValidate line 1495, trigger

  1. 1497callsUpdatePaymentTolerance

IC Partner Code.OnValidate line 1543, trigger

  1. 1565callsCodeunit 27 Confirm Management GetResponseOrDefault
  2. 1575writesTable 413 IC Partner Modify
  3. 1580writesTable 413 IC Partner Modify

Primary Contact No..OnLookup line 1837, trigger

  1. 1839callsLookupContactList

Primary Contact No..OnValidate line 1842, trigger

  1. 1851callsCheckCustomerContactRelation
  2. 1859callsCopyContactPicture
  3. 1863callsUpdateMyCustomer

Price Calculation Method.OnValidate line 1957, trigger

  1. 1963callsCodeunit 7001 Price Calculation Mgt. VerifyMethodImplemented

Currency Id.OnValidate line 2256, trigger

  1. 2258callsUpdateCurrencyCode

Payment Terms Id.OnValidate line 2269, trigger

  1. 2271callsUpdatePaymentTermsCode

Shipment Method Id.OnValidate line 2282, trigger

  1. 2284callsUpdateShipmentMethodCode

Payment Method Id.OnValidate line 2295, trigger

  1. 2297callsUpdatePaymentMethodCode

Tax Area ID.OnValidate line 2307, trigger

  1. 2309callsUpdateTaxAreaCode

OnDelete line 2401, trigger

  1. 2408raisesOnBeforeOnDeleteIsHandled
  2. 2412callsCodeunit 1535 Approvals Mgmt. OnCancelCustomerApprovalRequest
  3. 2418callsCodeunit 361 MoveEntries MoveCustEntries
  4. 2420callsDeleteRelatedData
  5. 2422callsCodeunit 5056 CustCont-Update OnDelete
  6. 2424callsCodeunit 249 VAT Registration Log Mgt. DeleteCustomerLog
  7. 2426callsCodeunit 408 DimensionManagement DeleteDefaultDim
  8. 2427callsDeleteDimValuePerAccount
  9. 2429callsCodeunit 7600 Calendar Management DeleteCustomizedBaseCalendarData

OnInsert line 2432, trigger

  1. 2438raisesOnBeforeInsertIsHandled
  2. 2446callsCodeunit 310 No. Series AreRelated
  3. 2448callsCodeunit 310 No. Series GetNextNo
  4. 2452callsCodeunit 310 No. Series GetNextNo
  5. 2459callsCodeunit 5056 CustCont-Update OnInsert
  6. 2462callsSetDefaultSalesperson
  7. 2464callsCodeunit 408 DimensionManagement UpdateDefaultDim
  8. 2468callsUpdateReferencedIds
  9. 2469callsSetLastModifiedDateTime
  10. 2471raisesOnAfterOnInsert

OnModify line 2474, trigger

  1. 2476callsUpdateReferencedIds
  2. 2477callsSetLastModifiedDateTime
  3. 2478callsIsContactUpdateNeeded
  4. 2479writesTable 18 Customer Modify
  5. 2480callsCodeunit 5056 CustCont-Update OnModify

OnRename line 2488, trigger

  1. 2493raisesOnBeforeOnRenameIsHandled
  2. 2497callsCodeunit 1535 Approvals Mgmt. OnRenameRecordInApprovalRequest
  3. 2498callsCodeunit 408 DimensionManagement RenameDefaultDim
  4. 2499callsTable 97 Comment Line RenameCommentLine
  5. 2501callsSetLastModifiedDateTime
  6. 2504callsUpdateCustomerTemplateInvoiceDiscCodes
  7. 2506callsCodeunit 7600 Calendar Management RenameCustomizedBaseCalendarData

AssistEdit line 2570

  1. 2577callsCodeunit 310 No. Series LookupRelatedNoSeries
  2. 2578callsCodeunit 310 No. Series GetNextNo
  3. 2580raisesOnAssistEditOnBeforeExit

DeleteRelatedData line 2585, local

  1. 2597writesTable 97 Comment Line DeleteAll
  2. 2600writesTable 287 Customer Bank Account DeleteAll
  3. 2603writesTable 222 Ship-to Address DeleteAll
  4. 2608writesTable 459 Sales Prepayment % DeleteAll
  5. 2611writesTable 172 Standard Customer Sales Code DeleteAll(true)
  6. 2613callsCheckIfSalesOrderLinesExist
  7. 2622callsCodeunit 7030 Campaign Target Group Mgt ConverttoContact
  8. 2629writesTable 5777 Item Reference DeleteAll
  9. 2633writesTable 9657 Custom Report Selection DeleteAll
  10. 2636writesTable 9150 My Customer DeleteAll
  11. 2638raisesOnAfterDeleteRelatedData

ValidateShortcutDimCode line 2646

  1. 2651raisesOnBeforeValidateShortcutDimCodeIsHandled
  2. 2655callsCodeunit 408 DimensionManagement ValidateDimValueCode
  3. 2657callsCodeunit 408 DimensionManagement SaveDefaultDim
  4. 2658writesTable 18 Customer Modify
  5. 2661raisesOnAfterValidateShortcutDimCode

ShowContact line 2667

  1. 2676raisesOnBeforeShowContact
  2. 2677callsCodeunit 1630 Office Management GetContact
  3. 2679raisesOnShowContactOnBeforeOpenContactCard
  4. 2689callsCodeunit 27 Confirm Management GetResponseOrDefault
  5. 2691callsCodeunit 5056 CustCont-Update InsertNewContact
  6. 2703raisesOnShowContactOnBeforeOpenContactList

LookupContactList line 2711

  1. 2719raisesOnBeforeLookupContactListIsHandled
  2. 2724callsTable 5054 Contact Business Relation FindByRelation
  3. 2739validatesTable 18 Customer Primary Contact No.

CheckBlockedCustOnDocs line 2759

  1. 2763callsIsOnBeforeCheckBlockedCustHandled
  2. 2767callsTable 18 Customer CustPrivacyBlockedErrorMessage
  3. 2777callsTable 18 Customer CustBlockedErrorMessage

CheckBlockedCustOnJnls line 2786

  1. 2790callsIsOnBeforeCheckBlockedCustHandled
  2. 2794callsTable 18 Customer CustPrivacyBlockedErrorMessage
  3. 2799callsTable 18 Customer CustBlockedErrorMessage

CheckBlockedCustOnJnls line 2808

  1. 2813raisesOnBeforeCheckBlockedCustOnJnlsIsHandled

CustBlockedErrorMessage line 2825

  1. 2831raisesOnBeforeCustBlockedErrorMessageIsHandled

DisplayMap line 2883

  1. 2887callsCodeunit 802 Online Map Management MakeSelectionIfMapEnabled

GetPriceCalculationMethod line 2894

  1. 2899callsGetCustomerPriceGroupPriceCalcMethod

GetPrimaryContact line 2912

  1. 2919callsGetContact

GetTotalAmountLCY line 2949

  1. 2955raisesOnBeforeGetTotalAmountLCYIsHandled
  2. 2962raisesOnGetTotalAmountLCYOnAfterCalcFields
  3. 2966callsGetTotalAmountLCYCommon

GetTotalAmountLCYUI line 2973

  1. 2975raisesOnBeforeGetTotalAmountLCYUI
  2. 2978raisesOnGetTotalAmountLCYUIOnAfterSetAutoCalcFields
  3. 2980callsGetTotalAmountLCYCommon

GetTotalAmountLCYCommon line 2983, local

  1. 2995raisesOnBeforeGetTotalAmountLCYCommonIsHandled
  2. 3000callsTable 37 Sales Line OutstandingInvoiceAmountFromShipment
  3. 3002callsGetInvoicedPrepmtAmountLCY
  4. 3003callsGetReturnRcdNotInvAmountLCY
  5. 3014raisesOnAfterGetTotalAmountLCYCommon

GetSalesLCY line 3022

  1. 3031raisesOnBeforeGetSalesLCYIsHandled
  2. 3035callsCodeunit 358 DateFilter-Calc CreateFiscalYearFilter

GetTopCustomerHeadlineQueryDocumentTypeFilter line 3047

  1. 3051raisesOnAfterGetTopCustomerHeadlineQueryDocumentTypeFilter

CalcAvailableCredit line 3058

  1. 3060callsCalcAvailableCreditCommon

CalcAvailableCreditUI line 3067

  1. 3069callsCalcAvailableCreditCommon

CalcAvailableCreditCommon line 3072, local

  1. 3079raisesOnBeforeCalcAvailableCreditCommonIsHandled
  2. 3086callsGetTotalAmountLCYUI
  3. 3087callsGetTotalAmountLCY

CalcOverdueBalance line 3094

  1. 3101raisesOnBeforeCalcOverdueBalanceIsHandled

SetStyle line 3136

  1. 3138callsCalcAvailableCredit

HasValidDDMandate line 3148

  1. 3152callsTable 1230 SEPA Direct Debit Mandate GetDefaultMandate

GetInvoicedPrepmtAmountLCY line 3176

  1. 3183raisesOnBeforeGetInvoicedPrepmtAmountLCYIsHandled

CreateAndShowNewInvoice line 3216

  1. 3222callsTable 36 Sales Header SetDefaultPaymentServices
  2. 3223writesTable 36 Sales Header Insert(true)
  3. 3225runsPage 43 Sales Invoice

CreateAndShowNewOrder line 3231

  1. 3237callsTable 36 Sales Header SetDefaultPaymentServices
  2. 3238writesTable 36 Sales Header Insert(true)
  3. 3240runsPage 42 Sales Order

CreateAndShowNewCreditMemo line 3246

  1. 3252writesTable 36 Sales Header Insert(true)
  2. 3254runsPage 44 Sales Credit Memo

CreateAndShowNewQuote line 3260

  1. 3266writesTable 36 Sales Header Insert(true)
  2. 3268runsPage 41 Sales Quote

UpdatePaymentTolerance line 3271, local

  1. 3277callsCodeunit 426 Payment Tolerance Management DelTolCustLedgEntry
  2. 3282callsCodeunit 426 Payment Tolerance Management CalcTolCustLedgEntry

HasAddressIgnoreCountryCode line 3301

  1. 3309raisesOnAfterHasAddressIgnoreCountryCode

HasAddress line 3316

  1. 3318callsHasAddressIgnoreCountryCode

HasDifferentAddress line 3326

  1. 3334raisesOnAfterHasDifferentAddress

GetBalanceAsVendor line 3342

  1. 3347callsGetLinkedVendor
  2. 3349raisesOnGetBalanceAsVendorOnBeforeCalcBalance

GetLinkedVendor line 3359

  1. 3364callsTable 5054 Contact Business Relation GetLinkedTables

GetCustNo line 3374

  1. 3376callsGetCustNoOpenCard

GetCustNoOpenCard line 3386

  1. 3397raisesOnBeforeGetCustNoOpenCardIsHandled
  2. 3408raisesOnGetCustNoOpenCardOnBeforeFilterCustomer
  3. 3412raisesOnGetCustNoOpenCardOnBeforeCustomerFindFirstIsHandled
  4. 3421raisesOnGetCustNoOpenCardOnBeforeCustomerFindSet
  5. 3432raisesOnGetCustNoOpenCardOnAfterOnAfterCustomerFilterFromStart
  6. 3446raisesOnGetCustNoOpenCardOnAfterSetCustomerFilters
  7. 3449callsMarkCustomersWithSimilarName
  8. 3459raisesOnGetCustNoOpenCardOnAfterMarkCustomersWithSimilarName
  9. 3470callsCreateNewCustomer
  10. 3479callsPickCustomer

MarkCustomersWithSimilarName line 3491, local

  1. 3509raisesOnMarkCustomersWithSimilarNameOnBeforeCustomerFindSet
  2. 3514callsCodeunit 10 Type Helper TextDistance

CreateNewCustomer line 3526

  1. 3536raisesOnBeforeCreateNewCustomerIsHandled
  2. 3541callsCodeunit 1381 Customer Templ. Mgt. InsertCustomerFromTemplate
  3. 3542writesTable 18 Customer Insert(true)
  4. 3546writesTable 18 Customer Modify(true)
  5. 3549callsCodeunit 1520 Workflow Event Handling RunWorkflowOnCustomerChanged

PickCustomer line 3562, local

  1. 3567callsMarkCustomersByFilters

ToPriceSource line 3617

  1. 3621validatesTable 7005 Price Source Source Type
  2. 3622validatesTable 7005 Price Source Source No.

TestNoSeries line 3625, local

  1. 3631raisesOnBeforeTestNoSeriesIsHandled
  2. 3638callsCodeunit 310 No. Series TestManual

OpenCustomerLedgerEntries line 3647

  1. 3654raisesOnBeforeOpenCustomerLedgerEntriesIsHandled
  2. 3666callsTable 21 Cust. Ledger Entry DrillDownOnEntries

IsContactUpdateNeeded line 3692

  1. 3723callsCodeunit 5056 CustCont-Update ContactNameIsBlank
  2. 3728raisesOnBeforeIsContactUpdateNeeded

HasAnyOpenOrPostedDocuments line 3751

  1. 3777raisesOnAfterHasAnyOpenOrPostedDocuments

CopyFromNewCustomerTemplate line 3785

  1. 3799validatesTable 18 Customer Payment Terms Code
  2. 3800validatesTable 18 Customer Payment Method Code
  3. 3804raisesOnAfterCopyFromNewCustomerTemplate

CopyContactPicture line 3807, local

  1. 3815callsCodeunit 27 Confirm Management GetResponseOrDefault
  2. 3820callsCodeunit 419 File Management GetServerDirectoryFilesList
  3. 3826writesTable 18 Customer Modify
  4. 3827callsCodeunit 419 File Management DeleteServerFile

SetDefaultSalesperson line 3848, protected

  1. 3854raisesOnBeforeSetDefaultSalespersonIsHandled
  2. 3862validatesTable 18 Customer Salesperson Code

SetLastModifiedDateTime line 3865, protected

  1. 3869raisesOnAfterSetLastModifiedDateTime

VATRegistrationValidation line 3875

  1. 3887raisesOnBeforeVATRegistrationValidationIsHandled
  2. 3891callsTable 381 VAT Registration No. Format Test
  3. 3899callsTable 248 VAT Reg. No. Srv Config VATRegNoSrvIsEnabled
  4. 3901callsCodeunit 249 VAT Registration Log Mgt. ValidateVATRegNoWithVIES
  5. 3908callsCodeunit 249 VAT Registration Log Mgt. LogCustomer

ValidateEmail line 3911, local

  1. 3917raisesOnBeforeValidateEmailIsHandled
  2. 3923callsCodeunit 9520 Mail Management CheckValidEmailAddresses

SetAddress line 3936

  1. 3944callsCodeunit 5056 CustCont-Update OnModify

UpdateReferencedIds line 3980

  1. 3987callsCodeunit 5465 Graph Mgt - General Tools IsApiEnabled
  2. 3990callsUpdateCurrencyId
  3. 3991callsUpdatePaymentTermsId
  4. 3992callsUpdateShipmentMethodId
  5. 3993callsUpdatePaymentMethodId
  6. 3994callsUpdateTaxAreaId

GetReferencedIds line 4001

  1. 4005callsCodeunit 701 Data Type Management InsertFieldToBuffer
  2. 4006callsCodeunit 701 Data Type Management InsertFieldToBuffer
  3. 4007callsCodeunit 701 Data Type Management InsertFieldToBuffer
  4. 4008callsCodeunit 701 Data Type Management InsertFieldToBuffer
  5. 4009callsCodeunit 701 Data Type Management InsertFieldToBuffer

UpdateCurrencyCode line 4021, local

  1. 4028validatesTable 18 Customer Currency Code

UpdatePaymentTermsCode line 4032, local

  1. 4040validatesTable 18 Customer Payment Terms Code

UpdateShipmentMethodCode line 4043, local

  1. 4051validatesTable 18 Customer Shipment Method Code

UpdatePaymentMethodCode line 4054, local

  1. 4062validatesTable 18 Customer Payment Method Code

UpdateDirectDebitPmtTermsCode line 4141, local

  1. 4147raisesOnBeforeUpdateDirectDebitPmtTermsCodeIsHandled
  2. 4154validatesTable 18 Customer Payment Terms Code

UpdateTaxAreaId line 4161

  1. 4167callsTable 98 General Ledger Setup UseVat

UpdateTaxAreaCode line 4192, local

  1. 4201callsTable 98 General Ledger Setup UseVat

ValidateSalesPersonCode line 4212, local

  1. 4216callsTable 13 Salesperson/Purchaser VerifySalesPersonPurchaserPrivacyBlocked
  2. 4217callsTable 13 Salesperson/Purchaser GetPrivacyBlockedGenericText

CheckCustomerContactRelation line 4220, local

  1. 4225callsTable 5054 Contact Business Relation FindOrRestoreContactBusinessRelation
  2. 4228raisesOnBeforeCheckCustomerContactRelationIsHandled

CheckIfSalesOrderLinesExist line 4234, local

  1. 4239raisesOnBeforeCheckIfOrderSalesLinesExistIsHandled

UpdateCustomerTemplateInvoiceDiscCodes line 4254, local

  1. 4259writesTable 1381 Customer Templ. ModifyAll

CheckAllowMultiplePostingGroups line 4265

  1. 4269raisesOnBeforeCheckAllowMultiplePostingGroupsIsHandled

UpdateFormatRegion line 4278, local

  1. 4290validatesTable 18 Customer Format Region

GetVATRegistrationNo line 4297

  1. 4301raisesOnAfterGetVATRegistrationNo

GetDefaultLocation line 4353

  1. 4366callsCodeunit 5700 User Setup Management GetLocation

UpdateMyCustomer line 4370, local

  1. 4379writesTable 9150 My Customer ModifyAll
  2. 4385writesTable 9150 My Customer ModifyAll

DeleteDimValuePerAccount line 4406, local

  1. 4413writesTable 356 Dim. Value per Account DeleteAll(true)

IsOnBeforeCheckBlockedCustHandled line 4568, local

  1. 4570raisesOnBeforeCheckBlockedCustIsHandled