This article provides a complete reference of all tables and fields in Ventoo Phone Lookup.
PhoneCountryPrefixVto
Stores country-specific normalization rules for phone numbers.
|
Field |
Type |
Description |
|---|---|---|
|
Country/Region Code |
Code[10] |
Primary key. Must match the Country/Region Code field in Business Central. |
|
Country Prefix |
Text |
International dialing code without a leading |
|
Local Prefix to Remove |
Text |
Local dialing prefix that is removed before normalization (e.g. 0). |
Keys
|
Name |
Fields |
Description |
|---|---|---|
|
Primary Key |
Country Code |
Unique identifier per country. |
PhoneDirectoryVto
The internal search directory. Stores all normalized phone numbers from customers, vendors, and contacts.
|
Field |
Type |
Description |
|---|---|---|
|
Entry No. |
Integer |
Auto-incrementing primary key. |
|
Entity Type |
Enum (EntityTypeVto) |
Type of the linked record (Customer, Vendor, or Contact). |
|
No. |
Code[20] |
Customer No., Vendor No., or Contact No. |
|
Name |
Text[100] |
Display name of the entity. |
|
Phone No. |
Text[30] |
Normalized phone number in the format +CC###. |
|
Indentation |
Integer |
Hierarchy level. Used internally. |
|
Company Name |
Text[30] |
Company name. Only set for cross-company entries. |
Keys
|
Name |
Fields |
Description |
|---|---|---|
|
Primary Key |
Entry No. |
Unique identifier. |
|
Phone Number |
Phone No. |
Enables fast exact search by normalized number. |
PhoneLookupSetupVto
Stores the global configuration as well as per-company settings for cross-company search.
|
Field |
Type |
Description |
|---|---|---|
|
Primary Key |
Code[10] |
Empty for the main configuration record. Company name for company records. |
|
Show Customers |
Boolean |
Master switch for customer results. |
|
Show Vendors |
Boolean |
Master switch for vendor results. |
|
Show Contacts |
Boolean |
Show contacts in search results. |
|
Show Purchase Quotes |
Boolean |
Show sales quotes. Only effective when Show Customers is active. |
|
Show Purchase Orders |
Boolean |
Show sales orders. Only effective when Show Customers is active. |
|
Show Invoices |
Boolean |
Show posted sales invoices. Only effective when Show Customers is active. |
|
Show Credit Memos |
Boolean |
Show posted sales credit memos. Only effective when Show Customers is active. |
|
Show Issued Reminders |
Boolean |
Show issued reminders. Only effective when Show Customers is active. |
|
Show Requests |
Boolean |
Show purchase requests. Only effective when Show Vendors is active. |
|
Show Orders (Purchase) |
Boolean |
Show purchase orders. Only effective when Show Vendors is active. |
|
Show Purchase Invoices |
Boolean |
Show posted purchase invoices. Only effective when Show Vendors is active. |
|
Show Purchase Credit Memos |
Boolean |
Show posted purchase credit memos. Only effective when Show Vendors is active. |
|
Document Age Filter |
Enum (DocumentAgeFilterVto) |
Restricts the displayed document history to a rolling time period. |
|
Search Multiple Companies |
Boolean |
Enables cross-company search. |
|
Include in Search |
Boolean |
Company-specific: Whether this company is included in the search. |
|
Company Name |
Text[30] |
Company-specific: Name of the company. |
Keys
|
Name |
Fields |
Description |
|---|---|---|
|
Primary Key |
Primary Key |
Unique identifier. Empty = main configuration. |
PhoneLookupVto
Input table for the search entry page. Contains the caller's number passed by the phone system as a filter parameter.
|
Field |
Type |
Description |
|---|---|---|
|
Phone No. |
Text[30] |
The incoming caller's number, passed as a URL filter parameter by the phone system. |
PhoneNumberResultsVto
Stores the hierarchical search results of the current search.
|
Field |
Type |
Description |
|---|---|---|
|
Entry No. |
Integer |
Auto-incrementing primary key. |
|
Entity Type |
Enum (EntityTypeVto) |
Entity or document type of this entry. |
|
No. |
Code[20] |
Record key, or document count for category rows. |
|
Name |
Text[100] |
Entity name, category label, or document description. |
|
Phone No. |
Text[30] |
Normalized phone number. Only set for level-0 entries. |
|
Indent |
Integer |
0 = Entity, 1 = Document category, 2 = Individual document. |
|
Document Date |
Date |
Date of the individual document. Only set for level-2 entries. |
|
Amount |
Decimal |
Document amount (level 2) or category total (level 1). |
|
Company Name |
Text[30] |
Company name for cross-company navigation. |
Keys
|
Name |
Fields |
Description |
|---|---|---|
|
Primary Key |
Entry No. |
Unique identifier. |
PossibleMatchBufferVto
Temporary buffer for similarity matches. Populated during the search and cleared after the results are displayed. Structure is identical to PhoneNumberResultsVto.
|
Field |
Type |
Description |
|---|---|---|
|
Entry No. |
Integer |
Auto-incrementing primary key. |
|
Entity Type |
Enum (EntityTypeVto) |
Entity type of the possible match. |
|
No. |
Code[20] |
Record key. |
|
Name |
Text[100] |
Display name of the entity. |
|
Phone No. |
Text[30] |
Normalized phone number of the possible match. |
|
Company Name |
Text[30] |
Company name of the possible match. |
Table Extensions
Ventoo Phone Lookup adds the following fields to standard Business Central tables:
Customer, Vendor, Contact
|
Field |
Field ID |
Type |
Description |
|---|---|---|---|
|
Normalized Phone Number |
70679700 |
Text[30] |
Normalized version of the Phone No. field. Populated automatically on save. |
|
Normalized Mobile Number |
70679701 |
Text[30] |
Normalized version of the Mobile Phone No. field. Populated automatically on save. |
Note: These fields are used exclusively internally and are not visible on any standard page. They serve as the basis for the automatic directory update.