Table 9 "Country/Region"
Base Application · Microsoft.Foundation.Address
- 11fields
- 10procedures
- 1events
- 7Learn pages
- 13countries replace it
- 223fields reference it
- 1objects it calls
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC261 fields removed
- BC27-28unchanged
- BC2910 fields changed
- BC30unchanged
Neighbourhood 139 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 30027 “APIV2 - Countries/Regions” (5 Learn pages), Page 10 “Countries/Regions” (2).
Properties
| Property | Value |
|---|---|
| Caption | Country/Region |
| 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 Δ BC29 | Code[10] | Specifies the country/region of the address. | NotBlank |
| 2 | Name Δ BC29 | Text[50] | Specifies the country/region of the address. | |
| 4 | ISO Code Δ BC29 | Code[2] | Specifies a two-letter country code defined in ISO 3166-1. | |
| 5 | ISO Numeric Code Δ BC29 | Code[3] | Specifies a three-digit code number defined in ISO 3166-1. | |
| 6 | EU Country/Region Code Δ BC29 | Code[10] | Specifies the EU code for the country/region you are doing business with. | |
| 7 | Intrastat Code Δ BC29 | Code[10] | Specifies an INTRASTAT code for the country/region you are trading with. | |
| 8 | Address Format Δ BC29 | Enum “Country/Region Address Format” | Specifies the format of the address that is displayed on external-facing documents. You link an address format to a country/region code so that external-facing documents based on cards or documents with that country/region code use the specified address format. NOTE: If the County field is filled in… | enum Enum 8 “Country/Region Address Format” |
| 9 | Contact Address Format Δ BC29 | Option | Specifies where you want the contact name to appear in mailing addresses. | OptionCaption: First,After Company Name,Last |
| 10 | VAT Scheme Δ BC29 | Code[10] | Specifies the national body that issues the VAT registration number for the country/region in connection with electronic document sending. | |
| 11 | Last Modified Date Time | DateTime | — | not editable |
| 12 | County Name Δ BC29 | Text[30] | Specifies the name of the county. |
Keys
- Key1: Code (clustered)
- Key2: EU Country/Region Code
- Key3: Intrastat Code
- Key4: Name
Events published
OnBeforeInitAddressFormat(var CountryRegion: Record "Country/Region"; var IsHandled: Boolean)(integration)
Procedures
IsEUCountry(CountryRegionCode: Code[10]): BooleanTranslateName(LanguageCode: Code[10])GetTranslatedName(LanguageID: Integer): Text[50]GetTranslatedName(LanguageCode: Code[10]): Text[50]GetNameInCurrentLanguage(): Text[50]CreateAddressFormat(CountryCode: Code[10]; LinePosition: Integer; FieldID: Integer): IntegerCreateAddressFormatLine(CountryCode: Code[10]; FieldPosition: Integer; FieldID: Integer; LineNo: Integer)InitAddressFormat()
Plus 1 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- lookup page Page 10 “Countries/Regions”
Referenced by
223 fields in 127 objects relate to this table (TableRelation or CalcFormula).
- Table 114 “Sales Cr.Memo Header”: Bill-to Country/Region Code, Rcvd.-from Count./Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 36 “Sales Header”: Bill-to Country/Region Code, Rcvd.-from Count./Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 5107 “Sales Header Archive”: Bill-to Country/Region Code, Rcvd.-from Count./Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 6660 “Return Receipt Header”: Bill-to Country/Region Code, Rcvd.-from Count./Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 110 “Sales Shipment Header”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 112 “Sales Invoice Header”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 120 “Purch. Rcpt. Header”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 122 “Purch. Inv. Header”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 124 “Purch. Cr. Memo Hdr.”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 38 “Purchase Header”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 5109 “Purchase Header Archive”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 5900 “Service Header”: Bill-to Country/Region Code, Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 5990 “Service Shipment Header”: Bill-to Country/Region Code, Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 5992 “Service Invoice Header”: Bill-to Country/Region Code, Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 5994 “Service Cr.Memo Header”: Bill-to Country/Region Code, Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 6010 “Service Header Archive”: Bill-to Country/Region Code, Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 6650 “Return Shipment Header”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code, VAT Country/Region Code
- Table 1001 “Job Task”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 167 “Job”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 4812 “Intrastat Report Line”: Country/Region Code, Country/Region of Origin Code, Country/Region of Payment Code
- Table 5135 “Job Archive”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 5136 “Job Task Archive”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 5475 “Sales Invoice Entity Aggregate”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 5477 “Purch. Inv. Entity Aggregate”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code
- Table 5495 “Sales Order Entity Buffer”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 5496 “Purchase Order Entity Buffer”: Buy-from Country/Region Code, Pay-to Country/Region Code, Ship-to Country/Region Code
- Table 5505 “Sales Quote Entity Buffer”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 5970 “Filed Service Contract Header”: Bill-to Country/Region Code, Country/Region Code, Ship-to Country/Region Code
- Table 8052 “Customer Subscription Contract”: Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
- Table 8057 “Subscription Header”: Bill-to Country/Region Code, End-User Country/Region Code, Ship-to Country/Region Code
- Table 1226 “Payment Export Data”: Recipient Bank Country/Region, Sender Bank Country/Region
- Table 1382 “Item Templ.”: Country/Region of Origin Code, Country/Region Purchased Code
- Table 263 “Intrastat Jnl. Line”: Country/Region Code, Country/Region of Origin Code
- Table 27 “Item”: Country/Region of Origin Code, Country/Region Purchased Code
- Table 5507 “Sales Cr. Memo Entity Buffer”: Bill-to Country/Region Code, Sell-to Country/Region Code
- Table 5508 “Purch. Cr. Memo Entity Buffer”: Buy-from Country/Region Code, Pay-to Country/Region Code
- Table 5740 “Transfer Header”: Trsf.-from Country/Region Code, Trsf.-to Country/Region Code
- Table 5744 “Transfer Shipment Header”: Trsf.-from Country/Region Code, Trsf.-to Country/Region Code
- Table 5746 “Transfer Receipt Header”: Trsf.-from Country/Region Code, Trsf.-to Country/Region Code
- Table 5856 “Direct Trans. Header”: Trsf.-from Country/Region Code, Trsf.-to Country/Region Code
- Table 6219 “Sustainability Goal”: Country/Region Code, Country/Region Code Filter
- Table 6291 “Emission Source Setup”: Country Name, Country/Region Code
- Table 79 “Company Information”: Country/Region Code, Ship-to Country/Region Code
- Table 8063 “Vendor Subscription Contract”: Buy-from Country/Region Code, Pay-to Country/Region Code
- Table extension 6908 “Expense Spend Request”: Dest. Country/Region Code, Origin Country/Region Code
- Table 1003 “Job Planning Line”: Country/Region Code
- Table 11 “Country/Region Translation”: Country/Region Code
- Table 1381 “Customer Templ.”: Country/Region Code
- Table 1383 “Vendor Templ.”: Country/Region Code
- Table 1384 “Employee Templ.”: Country/Region Code
- and 77 more objects (77 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 10 “Countries/Regions” (source table)
- Page 20027 “APIV1 - Countries/Regions” (source table)
- Page 30027 “APIV2 - Countries/Regions” (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.
- Codeunit 43 “Language” (2 calls:
GetNameInCurrentLanguage → GetUserLanguageCode,GetTranslatedName → GetLanguageCode)
Countries that replace it
AU, BE, CA, CH, ES, FI, FR, IT, MX, NL, NZ, RU, US
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: "Country/Region"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.