Table 18 Customer

Base Application, Microsoft.Sales.Customer

Source AL, 5,080 lines

src/Layers/W1/BaseApp/Sales/Customer/Customer.Table.allines 66 to 81 of 5,080, Copyright (c) Microsoft Corporation. MIT

table 18 Customer{    Caption = 'Customer';    DataCaptionFields = "No.", Name;    DrillDownPageID = "Customer List";    LookupPageID = "Customer Lookup";    Permissions = TableData "Cust. Ledger Entry" = r,                  TableData Job = r,                  tabledata "VAT Business Posting Group" = R,                  TableData "VAT Registration Log" = rd,                  tabledata "Payment Terms" = R,                  TableData "Price List Header" = rd,                  TableData "Price List Line" = rd,                  TableData "Sales Price" = rd,                  TableData "Sales Line Discount" = rd,                  TableData "Sales Price Access" = rd,

All 5,080 lines

Fields 165 in 29

1No.Code[20]17-29
2NameText[100]17-29
3Search NameCode[100]17-29
4Name 2Text[50]17-29
5AddressText[100]17-29
6Address 2Text[50]17-29
7CityText[30]17-29
8ContactText[100]17-29
9Phone No.Text[30]17-29

All 174 fields in 17-29

Events 63 in 29

[IntegrationEvent] OnAfterHasAnyOpenOrPostedDocuments(var Customer: Record Customer; var HasAnyDocs: Boolean)17-29
[IntegrationEvent] OnAfterLookupCity(var Customer: Record Customer; var PostCodeRec: Record "Post Code")17-29
[IntegrationEvent] OnAfterSetLastModifiedDateTime(var Customer: Record Customer)17-29
[IntegrationEvent] OnAfterValidateCity(var Customer: Record Customer; xCustomer: Record Customer)17-29
[IntegrationEvent] OnAfterValidatePostCode(var Customer: Record Customer; xCustomer: Record Customer)17-29
[IntegrationEvent] OnAfterValidateShortcutDimCode(var Customer: Record Customer; var xCustomer: Record Customer; FieldNumber: Integer; var ShortcutDimCode: Code[20])17-29
[IntegrationEvent] OnAssistEditOnBeforeExit(var Customer: Record Customer)17-29

All 72 events in 17-29

Public procedures 69 in 29

AssistEdit(OldCust: Record Customer): Boolean17-29
ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])17-29
ShowContact()17-29
SetInsertFromContact(FromContact: Boolean)17-29
CheckBlockedCustOnDocs(Cust2: Record Customer; DocType: Enum "Sales Document Type"; Shipment: Boolean; Transaction: Boolean)17-29
CheckBlockedCustOnJnls(Cust2: Record Customer; DocType: Enum "Gen. Journal Document Type"; Transaction: Boolean)17-29

All 73 procedures in 17-29

Extended in Microsoft's apps by 3

tableextension 4814 "Intrastat Report Customer"Intrastat Corenew in 21
tableextension 6450 "Serv. Customer"Base Applicationnew in 25
tableextension 8001 "Contracts Customer"Subscription Billingnew in 26

Trigger events 10

OnBeforeInsertEvent(var Rec: Record Customer; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record Customer; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record Customer; var xRec: Record Customer; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record Customer; var xRec: Record Customer; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record Customer; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record Customer; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record Customer; var xRec: Record Customer; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record Customer; var xRec: Record Customer; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record Customer; var xRec: Record Customer; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record Customer; var xRec: Record Customer; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 5 in 28

List17181920212223242526272829
Fields1211511643
Keys21
Procedures534111423
Events1086842412
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

All 97 changes in 17-29