Table 225 "Post Code"
Base Application · Microsoft.Foundation.Address
Across versions
- BC23present
- BC241 events removed
- BC253 fields changed, 1 procedures added
- BC26-27unchanged
- BC281 events added
- BC295 fields changed
- BC30unchanged
Neighbourhood 70 connected objects and pages
Base Application · Microsoft.Foundation.Address · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 367 “Post Codes” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Post Code |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Code Δ BC25 Δ BC29 | Code[20] | Specifies the postal code that is associated with a city. | NotBlank |
| 2 | City Δ BC25 Δ BC29 | Text[30] | Specifies the city linked to the postal code in the Code field. | NotBlank |
| 3 | Search City | Code[30] | — | |
| 4 | Country/Region Code Δ BC29 | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 5 | County Δ BC25 Δ BC29 | Text[30] | Specifies a county name. | |
| 30 | Time Zone Δ BC29 | Text[180] | Specifies the time zone for the selected post code. |
Keys
- Key1: Code, City (clustered)
- Key2: City, Code
- Key3: Search City
- Key4: Country/Region Code
Events published
OnAfterValidateCity(var PostCodeRec: Record "Post Code"; var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; UseDialog: Boolean)(integration)OnAfterValidatePostCode(var PostCodeRec: Record "Post Code"; var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; UseDialog: Boolean)(integration)OnBeforeCheckClearPostCodeCityCounty(var CityTxt: Text; var PostCode: Code[20]; var CountyTxt: Text; var CountryCode: Code[10]; xCountryCode: Code[10]; var IsHandled: Boolean)(integration)OnBeforeLookupPostCode(var CityTxt: Text; var PostCode: Code[20]; var CountyTxt: Text; var CountryCode: Code[10]; var IsHandled: Boolean)(integration)OnBeforeValidateCityProcedure(var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; UseDialog: Boolean; var IsHandled: Boolean)(integration)OnBeforeValidateCityField(var PostCode: Record "Post Code"; xPostCode: Record "Post Code"; var IsHandled: Boolean)(integration)OnBeforeValidateCode(var PostCode: Record "Post Code"; xPostCode: Record "Post Code"; var IsHandled: Boolean)(integration)OnBeforeValidateCountryCode(var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; var IsHandled: Boolean)(integration)OnBeforeValidatePostCode(var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; var UseDialog: Boolean; var IsHandled: Boolean)(integration)OnValidatePostCodeOnAfterSetFilters(var PostCodeRec: Record "Post Code")(integration)OnValidateCityOnAfterSelectPostCode(var PostCodeRec: Record "Post Code"; var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; UseDialog: Boolean)(integration)OnValidatePostCodeOnAfterSelectPostCode(var PostCodeRec: Record "Post Code"; var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; UseDialog: Boolean)(integration)OnLookupPostCodeOnAfterSelectPostCode(var PostCodeRec: Record "Post Code")+ BC28 (integration)
Procedures
ValidateCity(var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; UseDialog: Boolean)ValidatePostCode(var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10]; UseDialog: Boolean)UpdateFromSalesHeader(SalesHeader: Record "Sales Header"; PostCodeChanged: Boolean)UpdateFromCustomer(Customer: Record Customer; PostCodeChanged: Boolean)UpdateFromCompanyInformation(CompanyInformation: Record "Company Information"; PostCodeChanged: Boolean)UpdateFromStandardAddress(StandardAddress: Record "Standard Address"; PostCodeChanged: Boolean)ValidateCountryCode(var CityTxt: Text[30]; var PostCode: Code[20]; var CountyTxt: Text[30]; var CountryCode: Code[10])CheckClearPostCodeCityCounty(var CityTxt: Text; var PostCode: Code[20]; var CountyTxt: Text; var CountryCode: Code[10]; xCountryCode: Code[10])LookupPostCode(var CityTxt: Text; var PostCode: Code[20]; var CountyTxt: Text; var CountryCode: Code[10])
Plus 2 local procedures.
Relations
- lookup page Page 367 “Post Codes”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
258 fields in 65 objects relate to this table (TableRelation or CalcFormula).
- Table 1001 “Job Task”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 110 “Sales Shipment Header”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 112 “Sales Invoice Header”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 114 “Sales Cr.Memo Header”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 120 “Purch. Rcpt. Header”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 122 “Purch. Inv. Header”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 124 “Purch. Cr. Memo Hdr.”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 167 “Job”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 36 “Sales Header”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 38 “Purchase Header”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 5107 “Sales Header Archive”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 5109 “Purchase Header Archive”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 5135 “Job Archive”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 5136 “Job Task Archive”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 5475 “Sales Invoice Entity Aggregate”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 5477 “Purch. Inv. Entity Aggregate”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 5495 “Sales Order Entity Buffer”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 5496 “Purchase Order Entity Buffer”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 5505 “Sales Quote Entity Buffer”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 5900 “Service Header”: Bill-to City, Bill-to Post Code, City, Post Code, Ship-to City, Ship-to Post Code
- Table 5970 “Filed Service Contract Header”: Bill-to City, Bill-to Post Code, City, Post Code, Ship-to City, Ship-to Post Code
- Table 5990 “Service Shipment Header”: Bill-to City, Bill-to Post Code, City, Post Code, Ship-to City, Ship-to Post Code
- Table 5992 “Service Invoice Header”: Bill-to City, Bill-to Post Code, City, Post Code, Ship-to City, Ship-to Post Code
- Table 5994 “Service Cr.Memo Header”: Bill-to City, Bill-to Post Code, City, Post Code, Ship-to City, Ship-to Post Code
- Table 6010 “Service Header Archive”: Bill-to City, Bill-to Post Code, City, Post Code, Ship-to City, Ship-to Post Code
- Table 6650 “Return Shipment Header”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code, Ship-to City, Ship-to Post Code
- Table 6660 “Return Receipt Header”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 8052 “Customer Subscription Contract”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code, Ship-to City, Ship-to Post Code
- Table 8057 “Subscription Header”: Bill-to City, Bill-to Post Code, End-User City, End-User Post Code, Ship-to City, Ship-to Post Code
- Table 5507 “Sales Cr. Memo Entity Buffer”: Bill-to City, Bill-to Post Code, Sell-to City, Sell-to Post Code
- Table 5508 “Purch. Cr. Memo Entity Buffer”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code
- Table 5740 “Transfer Header”: Transfer-from City, Transfer-from Post Code, Transfer-to City, Transfer-to Post Code
- Table 5744 “Transfer Shipment Header”: Transfer-from City, Transfer-from Post Code, Transfer-to City, Transfer-to Post Code
- Table 5746 “Transfer Receipt Header”: Transfer-from City, Transfer-from Post Code, Transfer-to City, Transfer-to Post Code
- Table 79 “Company Information”: City, Post Code, Ship-to City, Ship-to Post Code
- Table 8063 “Vendor Subscription Contract”: Buy-from City, Buy-from Post Code, Pay-to City, Pay-to Post Code
- Table 5940 “Service Item”: Post Code, City, Ship-to City
- Table 14 “Location”: City, Post Code
- Table 156 “Resource”: City, Post Code
- Table 18 “Customer”: City, Post Code
- Table 222 “Ship-to Address”: City, Post Code
- Table 2224 “Remit Address”: City, Post Code
- Table 224 “Order Address”: City, Post Code
- Table 23 “Vendor”: City, Post Code
- Table 270 “Bank Account”: City, Post Code
- Table 287 “Customer Bank Account”: City, Post Code
- Table 288 “Vendor Bank Account”: City, Post Code
- Table 295 “Reminder Header”: City, Post Code
- Table 297 “Issued Reminder Header”: City, Post Code
- Table 302 “Finance Charge Memo Header”: City, Post Code
- and 15 more objects (27 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 367 “Post Codes” (source table)
Extended by
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Page 367 “Post Codes” (2 calls:
ValidateCity → (object),ValidatePostCode → (object))
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Post Code"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.