Table 18 Customer

Base Application, Microsoft.Sales.Customer
List17181920212223242526272829
Fields1211511643
Keys21
Procedures534111423
Events1086842412

In 28 2 marked obsolete, 3 added

GetShippedOutstandingInvoicesAmountLCY(): Decimalnew in 26
marked Pending, tag 28.0: It is no longer used in GetTotalAmountLCYCommon procedure.
GetShippedFromOrderLCYAmountLCY(): Decimalnew in 26
marked Pending, tag 28.0: It is no longer used in GetTotalAmountLCYCommon procedure.
FormatVATRegistrationNo(VATRegistrationNo: Text; CountryCode: Code[10]): Textnew in 28
added
[IntegrationEvent] OnBeforeShowContact(var Customer: Record Customer; var ContactBusinessRelation: Record "Contact Business Relation")new in 28
added
[IntegrationEvent] OnGetCustNoOpenCardOnBeforeCustomerFindFirst(var Customer: Record Customer; var IsHandled: Boolean)new in 28
added

In 27 1 marked obsolete, 2 added, 1 no longer obsolete, 1 gone

field(40; "Invoice Copies"; Integer)17-29
marked Pending, tag 27.0: This field is not used consequently and hence does not work as expected. It should be retired.
field(52; "First Transaction Date"; Date)new in 27
added
field(103; "Home Page"; Text[255])17-29changed in 27
no longer obsolete, was field(103; "Home Page"; Text[80])
LookupCustomer(var Customer: Record Customer): Booleangone after 26
gone
GetDefaultLocation(): Code[10]new in 27
added

In 26 4 gone, 1 state changed, 5 added

field(89; Picture; Blob)gone after 25
gone
field(720; "Coupled to CRM"; Boolean)new in 19
Pending to Removed, tag 26.0: Replaced by flow field Coupled to Dataverse
field(8000; Id; Guid)gone after 25
gone
field(9004; "Tax Area Display Name"; Text[100])gone after 25
gone
key(Key21; "Coupled to CRM")19 to 25
gone
LookupContactList()new in 26
added
GetVATRegistrationNo(): Text[20]new in 26
added
GetShippedOutstandingInvoicesAmountLCY(): Decimalnew in 26
added
GetShippedFromOrderLCYAmountLCY(): Decimalnew in 26
added
[IntegrationEvent] OnAfterGetVATRegistrationNo(var Customer: Record Customer; var VATRegNo: Text[20])new in 26
added

In 25 6 gone, 4 added

field(5900; "Service Zone Code"; Code[10])gone after 24
gone
field(5902; "Contract Gain/Loss Amount"; Decimal)gone after 24
gone
field(5903; "Ship-to Filter"; Code[10])gone after 24
gone
field(5910; "Outstanding Serv. Orders (LCY)"; Decimal)gone after 24
gone
field(5911; "Serv Shipped Not Invoiced(LCY)"; Decimal)gone after 24
gone
field(5912; "Outstanding Serv.Invoices(LCY)"; Decimal)gone after 24
gone
[IntegrationEvent] OnAfterDeleteRelatedData(Customer: Record Customer)new in 25
added
[IntegrationEvent] OnGetTotalAmountLCYOnAfterCalcFields(var Customer: Record Customer)new in 25
added
[IntegrationEvent] OnGetTotalAmountLCYUIOnAfterSetAutoCalcFields(var Customer: Record Customer)new in 25
added
[IntegrationEvent] OnAfterGetTotalAmountLCYCommon(var Customer: Record Customer; var TotalAmountLCY: Decimal)new in 25
added

In 24 2 marked obsolete

field(103; "Home Page"; Text[80])17-29changed in 27
marked Pending, tag 24.0: Field length will be increased to 255.
LookupCustomer(var Customer: Record Customer): Booleangone after 26
marked Pending, tag 24.0: Use SelectCustomer(var Customer: Record Customer): Boolean instead.

In 23 2 added, 1 gone

field(48; "Format Region"; Text[80])new in 23
added
[IntegrationEvent] OnBeforeCalcAvailableCreditCommon(var Rec: Record Customer; CalledFromUI: Boolean; var CreditLimitLCY: Decimal)19 to 22
gone
[IntegrationEvent] OnBeforeCalcAvailableCreditCommon(var Rec: Record Customer; CalledFromUI: Boolean; var CreditLimitLCY: Decimal; var Result: Decimal; var IsHandled: Boolean)new in 23
added

In 22 7 added, 1 marked obsolete, 1 state changed, 1 gone

field(134; "Exclude from Pmt. Practices"; Boolean)new in 22
added
field(175; "Allow Multiple Posting Groups"; Boolean)new in 22
added
field(720; "Coupled to CRM"; Boolean)new in 19
marked Pending, tag 23.0: Replaced by flow field Coupled to Dataverse
field(721; "Coupled to Dataverse"; Boolean)new in 22
added
field(8000; Id; Guid)gone after 25
Pending to Removed, tag 22.0: This functionality will be replaced by the systemID field
CheckAllowMultiplePostingGroups()new in 22
added
[IntegrationEvent] OnBeforeLookupContactList(var Customer: Record Customer; var IsHandled: Boolean)19 to 21
gone
[IntegrationEvent] OnBeforeLookupContactList(var Customer: Record Customer; var IsHandled: Boolean; FieldNumber: Integer)new in 22
added
[IntegrationEvent] OnBeforeCheckAllowMultiplePostingGroups(var IsHandled: Boolean)new in 22
added
[IntegrationEvent] OnGetCustNoOpenCardOnAfterMarkCustomersWithSimilarName(var Customer: Record Customer)new in 22
added

In 21 5 added, 5 gone

field(25; "Registration Number"; Text[50])new in 21
added
CopyFromCustomerTemplate(CustomerTemplate: Record "Customer Template")gone after 20
gone
[IntegrationEvent] OnAfterCopyFromCustomerTemplate(var Customer: Record Customer; CustomerTemplate: Record "Customer Template")gone after 20
gone
[IntegrationEvent] OnAfterLookupPostCode(var Customer: Record Customer; var PostCodeRec: Record "Post Code")gone after 20
gone
[IntegrationEvent] OnBeforeValidateCity(var Customer: Record Customer; var PostCodeRec: Record "Post Code")gone after 20
gone
[IntegrationEvent] OnBeforeValidatePostCode(var Customer: Record Customer; var PostCodeRec: Record "Post Code")gone after 20
gone
[IntegrationEvent] OnAfterLookupPostCode(var Customer: Record Customer; xCustomer: Record Customer; var PostCodeRec: Record "Post Code")new in 21
added
[IntegrationEvent] OnBeforeValidateCity(var Customer: Record Customer; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)new in 21
added
[IntegrationEvent] OnBeforeValidatePostCode(var Customer: Record Customer; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)new in 21
added
[IntegrationEvent] OnBeforeValidateRegistrationNumber(var Customer: Record Customer; var IsHandled: Boolean)new in 21
added

In 20 11 added

field(133; "Intrastat Partner Type"; Enum "Partner Type")new in 20
added
GetTopCustomerHeadlineQueryDocumentTypeFilter(): Textnew in 20
added
GetBalanceAsVendor(var LinkedVendorNo: Code[20]): Decimalnew in 20
added
GetLinkedVendor(): Code[20]new in 20
added
protected SetLastModifiedDateTime()new in 20
added
[IntegrationEvent] OnAfterGetTopCustomerHeadlineQueryDocumentTypeFilter(var DocumentTypeFilter: Text)new in 20
added
[IntegrationEvent] OnAfterHasAddressIgnoreCountryCode(Customer: Record Customer; var Result: Boolean)new in 20
added
[IntegrationEvent] OnAfterHasDifferentAddress(Customer: Record Customer; OtherCustomer: Record Customer; var Result: Boolean)new in 20
added
[IntegrationEvent] OnBeforeCheckIfOrderSalesLinesExist(var Customer: Record Customer; var IsHandled: Boolean)new in 20
added
[IntegrationEvent] OnBeforeOnRename(var Customer: Record Customer; xCustomer: Record Customer; var IsHandled: Boolean)new in 20
added
[IntegrationEvent] OnGetBalanceAsVendorOnBeforeCalcBalance(var Vendor: Record Vendor)new in 20
added

In 19 1 state changed, 12 added, 2 gone

field(89; Picture; Blob)gone after 25
Pending to Removed, tag 19.0: Replaced by Image field
field(720; "Coupled to CRM"; Boolean)new in 19
added
key(Key21; "Coupled to CRM")19 to 25
added
key(Key22; "IC Partner Code")new in 19
added
IsContactUpdateNeeded(): Booleannew in 19
added
protected SetDefaultSalesperson()new in 19
added
VATRegistrationValidation()new in 19
added
[IntegrationEvent] OnBeforeGetCustNoOpenCard(CustomerText: Text; ShowCustomerCard: Boolean; ShowCreateCustomerOption: Boolean; var CustomerNo: Code[20]; var IsHandled: Boolean)gone after 18
gone
[IntegrationEvent] OnBeforeValidateContact(var IsHandled: Boolean)gone after 18
gone
[IntegrationEvent] OnBeforeGetCustNoOpenCard(CustomerText: Text; ShowCustomerCard: Boolean; var ShowCreateCustomerOption: Boolean; var CustomerNo: Code[20]; var IsHandled: Boolean)new in 19
added
[IntegrationEvent] OnBeforeLookupContactList(var Customer: Record Customer; var IsHandled: Boolean)19 to 21
added
[IntegrationEvent] OnBeforeTestNoSeries(var Customer: Record Customer; xCustomer: Record Customer; var IsHandled: Boolean)new in 19
added
[IntegrationEvent] OnBeforeUpdateDirectDebitPmtTermsCode(var Customer: Record Customer; var IsHandled: Boolean)new in 19
added
[IntegrationEvent] OnBeforeValidateContact(var IsHandled: Boolean; var Customer: Record Customer)new in 19
added
[IntegrationEvent] OnBeforeCalcAvailableCreditCommon(var Rec: Record Customer; CalledFromUI: Boolean; var CreditLimitLCY: Decimal)19 to 22
added

In 18 1 changed, 2 marked obsolete, 12 added, 1 gone

field(80; "Application Method"; Enum "Application Method")17-29changed in 18
changed, was field(80; "Application Method"; Option)
CopyFromCustomerTemplate(CustomerTemplate: Record "Customer Template")gone after 20
marked Pending, tag 18.0: Will be removed with other functionality related to "old" templates. Replaced by CopyFromNewCustomerTemplate(CustomerTemplate: Record "Customer Templ.")
CheckBlockedCustOnJnls(Cust2: Record Customer; var GenJnlLine: Record "Gen. Journal Line"; Transaction: Boolean)new in 18
added
GetPrimaryContact(CustomerNo: Code[20]; var PrimaryContact: Record Contact)new in 18
added
ToPriceSource(var PriceSource: Record "Price Source")new in 18
added
CopyFromNewCustomerTemplate(CustomerTemplate: Record "Customer Templ.")new in 18
added
[IntegrationEvent] OnBeforeIsContactUpdateNeeded(Customer: Record Customer; xCustomer: Record Customer; var UpdateNeeded: Boolean)gone after 17
gone
[IntegrationEvent] OnAfterCopyFromCustomerTemplate(var Customer: Record Customer; CustomerTemplate: Record "Customer Template")gone after 20
marked Pending, tag 18.0: Will be removed with other functionality related to "old" templates. Replaced by OnAfterCopyFromNewCustomerTemplate()
[IntegrationEvent] OnBeforeIsContactUpdateNeeded(Customer: Record Customer; xCustomer: Record Customer; var UpdateNeeded: Boolean; ForceUpdateContact: Boolean)new in 18
added
[IntegrationEvent] OnAfterCopyFromNewCustomerTemplate(var Customer: Record Customer; CustomerTemplate: Record "Customer Templ.")new in 18
added
[IntegrationEvent] OnAfterOnInsert(var Customer: Record Customer; xCustomer: Record Customer)new in 18
added
[IntegrationEvent] OnBeforeCheckBlockedCustOnJnls(Customer: Record Customer; var GenJnlLine: Record "Gen. Journal Line"; Transaction: Boolean; var IsHandled: Boolean)new in 18
added
[IntegrationEvent] OnBeforeOnDelete(var Customer: Record Customer; var IsHandled: Boolean)new in 18
added
[IntegrationEvent] OnBeforeValidateVATRegistrationNo(var Customer: Record Customer; xCustomer: Record Customer; FieldNumber: Integer; var IsHandled: Boolean)new in 18
added
[IntegrationEvent] OnGetCustNoOpenCardOnAfterOnAfterCustomerFilterFromStart(var Customer: Record Customer)new in 18
added
[IntegrationEvent] OnBeforeCustBlockedErrorMessage(Cust2: Record Customer; Transaction: Boolean; var IsHandled: Boolean)new in 18
added