ext_field table - SuperOffice

ext_field Table (319)

This table contains entries mapping an external field to an internal field. Used for database integration.

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
ext_table	The reference to the associated ext_table	FK ext_table	Yes
seq_order	The column number for this field. Strictly ascending.	Int	Yes
name	The name for this field.	String(255)	Yes
target	The target for this field. E.g. 'customer.name'.	String(64)	Yes
flags	Bitmap for flags for this entry.	Int	Yes
datatype	The datatype for this field. TODO: depreciated?	Int	Yes

Indexes

Fields	Types	Description
ext_table	FK	Index

Relationships

Table	Description
ext_table	This table contains entries used for mapping an external table to an internal table (customer or cust_company) for database integration.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ext_table table ext_datasource table extra_fields table ExtApp table ExtAppHeadingLink table ExtAppGroupLink table

⌘I