Dynamics NAV 11.00 - Table 9 Country/Region

Table 9 Country/Region

Object parts

#	Field Name	Data Type	Length	Usage
1	Code	Code	10	44
2	Name	Text	50	29
6	EU Country/Region Code	Code	10	12
7	Intrastat Code	Code	10	7
8	Address Format	Option(Post Code+City,City+Post Code,City+County+Post Code,Blank Line+Post Code+City )		16
9	Contact Address Format	Option(First,After Company Name,Last )		8
10	VAT Scheme	Code	10	8
11	Last Modified Date Time new	DateTime		5
8000	Id new	GUID		13

#	Visibility	Name	Return type	LOC	Δ L	Usage
74	public	IsEUCountry	Boolean	5	0	1
75	public	GetNameInCurrentLanguage	Text	3	0	2
#	Visibility	Name	Return type	LOC	Δ L	Usage

#	Name	LOC	Δ L
1	OnInsert	1	2
2	OnModify	1	2
3	OnDelete	2	2
4	OnRename	1	2

Error Code	Context	Statement	Error Text	Hint
Error Code	Context	Statement	Error	Hint

Stats

13

Lines of code550%

6

Methods500%

9

Fields29%

Where-used

Object Type	Object No	Variable	Context
Table	9	CountryRegion	Procedure IsEUCountry
Table	249	CountryRegion	Procedure GetCountryCode
Table	7820	CountryRegion	Procedure UpdateAddressFromQBO
Table	7820	CountryRegion	Procedure UpdateAddressInQBO
Report	88	Country
Report	130	Country/Region
Report	501	Country
Report	502	Country
Report	593	Country
Report	594	Country/Region
Report	594	CountryRegion	Procedure CountryOfOrigin
Codeunit	249	CountryRegion	Procedure IsEUCountry
Codeunit	249	CountryRegion	Procedure CheckVIESForVATNo
Codeunit	365	Country	Procedure FormatAddr
Codeunit	365	Country	Procedure FormatPostCodeCity
Codeunit	365	Country	Procedure GeneratePostCodeCity
Codeunit	365	CountryRegion	Procedure SalesHeaderShipTo
Codeunit	365	CountryRegion	Procedure SalesHeaderArchShipTo
Codeunit	365	Country	Procedure OnBeforeFormatAddress
Codeunit	802	CountryRegion	Procedure BuildParameters
Codeunit	1605	CountryRegion	Procedure GetVATScheme
Codeunit	1620	CountryRegion	Procedure CheckCountryRegionCode
Codeunit	1797	CountryRegion	Procedure CreateCountryIfNeeded
Codeunit	1797	CountryRegion	Procedure SearchCountry
Codeunit	2107	CountryRegion	Procedure InsertNewCountryCode
Codeunit	2107	CountryRegion	Procedure ModifyCountryCode
Codeunit	5054	Country	Procedure CreateHeader
Codeunit	5054	Country	Procedure AddFieldsToMergeSource
Codeunit	5054	Country2	Procedure AddFieldsToMergeSource
Codeunit	5054	Country	Procedure OnAddFieldsToMergeSource
Codeunit	5054	Country	Procedure OnCreateHeaderAddFields
Codeunit	5458	CountryRegion	Procedure FindCountryRegionCode
Codeunit	5494	DummyCountryRegion	Procedure UpdateIntegrationRecords
Codeunit	5494	DummyCountryRegion	Procedure HandleUpdateReferencedIdFieldOnItem
Codeunit	5494	DummyCountryRegion	Procedure HandleGetPredefinedIdValue
Codeunit	6702	LocalCountryRegion	Procedure ValidateCountryRegion
Codeunit	6702	LocalCountryRegion	Procedure ValidateCountryRegionByName
Page	10	Rec
Page	2152	CountryRegion	Trigger OnFindRecord
Page	2352	CountryRegion	Trigger OnOpenPage
Page	2863	Rec
Page	2863	CountryRegion	Trigger OnInsertRecord
Page	2863	CountryRegion	Trigger OnModifyRecord
Page	5494	Rec
Page	5494	CountryRegion	Trigger OnInsertRecord
Page	5494	CountryRegion	Trigger OnModifyRecord
Query	19	Rec
Query	100	Rec
Query	101	Rec
Query	141	Rec
Table	11		Country/Region Code TableRelation
Table	14		Country/Region Code TableRelation
Table	18		Country/Region Code TableRelation
Table	23		Country/Region Code TableRelation
Table	27		Country/Region Purchased Code TableRelation
Table	27		Country/Region of Origin Code TableRelation
Table	32		Country/Region Code TableRelation
Table	36		VAT Country/Region Code TableRelation
Table	36		Bill-to Country/Region Code TableRelation
Table	36		Sell-to Country/Region Code TableRelation
Table	36		Ship-to Country/Region Code TableRelation
Table	38		VAT Country/Region Code TableRelation
Table	38		Pay-to Country/Region Code TableRelation
Table	38		Buy-from Country/Region Code TableRelation
Table	38		Ship-to Country/Region Code TableRelation
Table	79		Country/Region Code TableRelation
Table	79		Ship-to Country/Region Code TableRelation
Table	81		Country/Region Code TableRelation
Table	83		Country/Region Code TableRelation
Table	110		VAT Country/Region Code TableRelation
Table	110		Bill-to Country/Region Code TableRelation
Table	110		Sell-to Country/Region Code TableRelation
Table	110		Ship-to Country/Region Code TableRelation
Table	112		VAT Country/Region Code TableRelation
Table	112		Bill-to Country/Region Code TableRelation
Table	112		Sell-to Country/Region Code TableRelation
Table	112		Ship-to Country/Region Code TableRelation
Table	114		VAT Country/Region Code TableRelation
Table	114		Bill-to Country/Region Code TableRelation
Table	114		Sell-to Country/Region Code TableRelation
Table	114		Ship-to Country/Region Code TableRelation
Table	120		VAT Country/Region Code TableRelation
Table	120		Pay-to Country/Region Code TableRelation
Table	120		Buy-from Country/Region Code TableRelation
Table	120		Ship-to Country/Region Code TableRelation
Table	122		VAT Country/Region Code TableRelation
Table	122		Pay-to Country/Region Code TableRelation
Table	122		Buy-from Country/Region Code TableRelation
Table	122		Ship-to Country/Region Code TableRelation
Table	124		VAT Country/Region Code TableRelation
Table	124		Pay-to Country/Region Code TableRelation
Table	124		Buy-from Country/Region Code TableRelation
Table	124		Ship-to Country/Region Code TableRelation
Table	156		Country/Region Code TableRelation
Table	167		Bill-to Country/Region Code TableRelation
Table	169		Country/Region Code TableRelation
Table	210		Country/Region Code TableRelation
Table	222		Country/Region Code TableRelation
Table	224		Country/Region Code TableRelation
Table	225		Country/Region Code TableRelation
Table	254		Country/Region Code TableRelation
Table	263		Country/Region Code TableRelation
Table	263		Country/Region of Origin Code TableRelation
Table	270		Country/Region Code TableRelation
Table	287		Country/Region Code TableRelation
Table	288		Country/Region Code TableRelation
Table	295		Country/Region Code TableRelation
Table	297		Country/Region Code TableRelation
Table	302		Country/Region Code TableRelation
Table	304		Country/Region Code TableRelation
Table	381		Country/Region Code TableRelation
Table	730		Country/Region Code TableRelation
Table	741		Country/Region Code TableRelation
Table	753		Country/Region Code TableRelation
Table	1003		Country/Region Code TableRelation
Table	1226		Sender Bank Country/Region TableRelation
Table	1226		Recipient Bank Country/Region TableRelation
Table	1300		Country/Region Code TableRelation
Table	1303		Country/Region Code TableRelation
Table	5050		Country/Region Code TableRelation
Table	5051		Country/Region Code TableRelation
Table	5079		Default Country/Region Code TableRelation
Table	5096		Country/Region Code Filter TableRelation
Table	5105		Country/Region Code TableRelation
Table	5107		VAT Country/Region Code TableRelation
Table	5107		Bill-to Country/Region Code TableRelation
Table	5107		Sell-to Country/Region Code TableRelation
Table	5107		Ship-to Country/Region Code TableRelation
Table	5109		VAT Country/Region Code TableRelation
Table	5109		Pay-to Country/Region Code TableRelation
Table	5109		Buy-from Country/Region Code TableRelation
Table	5109		Ship-to Country/Region Code TableRelation
Table	5200		Country/Region Code TableRelation
Table	5201		Country/Region Code TableRelation
Table	5209		Country/Region Code TableRelation
Table	5475		Sell-to Country/Region Code TableRelation
Table	5477		Buy-from Country/Region Code TableRelation
Table	5495		Sell-to Country/Region Code TableRelation
Table	5505		Sell-to Country/Region Code TableRelation
Table	5507		Sell-to Country/Region Code TableRelation
Table	5714		Country/Region Code TableRelation
Table	5740		Trsf.-from Country/Region Code TableRelation
Table	5740		Trsf.-to Country/Region Code TableRelation
Table	5744		Trsf.-from Country/Region Code TableRelation
Table	5744		Trsf.-to Country/Region Code TableRelation
Table	5746		Trsf.-from Country/Region Code TableRelation
Table	5746		Trsf.-to Country/Region Code TableRelation
Table	5900		VAT Country/Region Code TableRelation
Table	5900		Bill-to Country/Region Code TableRelation
Table	5900		Country/Region Code TableRelation
Table	5900		Ship-to Country/Region Code TableRelation
Table	5970		Country/Region Code TableRelation
Table	5970		Bill-to Country/Region Code TableRelation
Table	5970		Ship-to Country/Region Code TableRelation
Table	5990		VAT Country/Region Code TableRelation
Table	5990		Bill-to Country/Region Code TableRelation
Table	5990		Country/Region Code TableRelation
Table	5990		Ship-to Country/Region Code TableRelation
Table	5992		VAT Country/Region Code TableRelation
Table	5992		Bill-to Country/Region Code TableRelation
Table	5992		Country/Region Code TableRelation
Table	5992		Ship-to Country/Region Code TableRelation
Table	5994		VAT Country/Region Code TableRelation
Table	5994		Bill-to Country/Region Code TableRelation
Table	5994		Country/Region Code TableRelation
Table	5994		Ship-to Country/Region Code TableRelation
Table	6650		VAT Country/Region Code TableRelation
Table	6650		Pay-to Country/Region Code TableRelation
Table	6650		Buy-from Country/Region Code TableRelation
Table	6650		Ship-to Country/Region Code TableRelation
Table	6660		VAT Country/Region Code TableRelation
Table	6660		Bill-to Country/Region Code TableRelation
Table	6660		Sell-to Country/Region Code TableRelation
Table	6660		Ship-to Country/Region Code TableRelation
Table	99000754		Country/Region Code TableRelation
Table	99000758		Country/Region Code TableRelation
Page	1803		TableRelation

RIMD Operations

#	Trigger Type	Trigger Name	Database Access
Table 9	Procedure	IsEUCountry	GET
Table 249	Procedure	GetCountryCode	GET
Table 7820	Procedure	UpdateAddressFromQBO	FINDFIRST
Table 7820	Procedure	UpdateAddressFromQBO	FINDFIRST
Table 7820	Procedure	UpdateAddressInQBO	GET
Report 88	Procedure	WriteGrTotalsToFile	GET
Report 88	Procedure	WriteGrTotalsToFile	GET
Report 501	Trigger	OnAfterGetRecord	GET
Report 502	Trigger	OnAfterGetRecord	GET
Report 593	Procedure	WriteGrTotalsToFile	GET
Report 594	Trigger	OnAfterGetRecord	GET
Report 594	Procedure	CountryOfOrigin	GET
Codeunit 249	Procedure	IsEUCountry	GET
Codeunit 365	Procedure	FormatAddr	GET
Codeunit 365	Procedure	FormatPostCodeCity	GET
Codeunit 365	Procedure	SalesHeaderShipTo	GET
Codeunit 365	Procedure	SalesHeaderArchShipTo	GET
Codeunit 802	Procedure	BuildParameters	GET
Codeunit 1605	Procedure	GetVATScheme	GET
Codeunit 1605	Procedure	GetVATScheme	GET
Codeunit 1620	Procedure	CheckCountryRegionCode	GET
Codeunit 1797	Procedure	CreateCountryIfNeeded	GET
Codeunit 1797	Procedure	SearchCountry	FINDFIRST
Codeunit 2107	Procedure	ModifyCountryCode	GET
Codeunit 5054	Procedure	AddFieldsToMergeSource	GET
Codeunit 5054	Procedure	AddFieldsToMergeSource	GET
Codeunit 5458	Procedure	FindCountryRegionCode	GET
Codeunit 5458	Procedure	FindCountryRegionCode	COUNT
Codeunit 5458	Procedure	FindCountryRegionCode	FINDFIRST
Codeunit 5458	Procedure	FindCountryRegionCode	GET
Codeunit 6702	Procedure	ValidateCountryRegion	GET
Codeunit 6702	Procedure	ValidateCountryRegionByName	FINDFIRST
Page 2152	Trigger	OnFindRecord	FINDSET
Page 2352	Trigger	OnOpenPage	FINDSET
Page 2863	Trigger	OnInsertRecord	ISEMPTY
Page 2863	Trigger	OnModifyRecord	FINDFIRST
Page 5494	Trigger	OnInsertRecord	ISEMPTY
Page 5494	Trigger	OnModifyRecord	FINDFIRST

#	Trigger Type	Trigger Name	Database Access
Codeunit 1797	Procedure	CreateCountryIfNeeded	INSERT
Codeunit 2107	Procedure	InsertNewCountryCode	INSERT
Codeunit 5458	Procedure	FindCountryRegionCode	INSERT
Page 2863	Trigger	OnInsertRecord	INSERT
Page 2863	Trigger	OnInsertRecord	INSERT
Page 5494	Trigger	OnInsertRecord	INSERT
Page 5494	Trigger	OnInsertRecord	INSERT

#	Trigger Type	Trigger Name	Database Access
Codeunit 2107	Procedure	ModifyCountryCode	MODIFY
Page 2863	Trigger	OnInsertRecord	MODIFY
Page 2863	Trigger	OnModifyRecord	MODIFY
Page 2863	Trigger	OnModifyRecord	RENAME
Page 5494	Trigger	OnInsertRecord	MODIFY
Page 5494	Trigger	OnModifyRecord	MODIFY
Page 5494	Trigger	OnModifyRecord	RENAME

#	Trigger Type	Field Name	Trigger Name	Database Access

Table 9 Country/Region

Object parts

Stats

13

6

9

Where-used

RIMD Operations

RIMD Diagram

Reachability

Comments