ErpConnector table - SuperOffice

ErpConnector Table (417)

One ERP Connector, known by its URL

Fields

Name	Description	Type	Nullable
erpconnector_id	Primary key	PK	No
URL	The URL where the connector is located and can be called	String(1023)	Yes
DisplayName	Name shown in the list	String(254)	Yes
Deleted	If set, then this is a row that has been ‘deleted’; we do not physically delete rows to avoid disaster	Bool	Yes
ConfigXml	Zero or more XML fragments to be added to the .config file, to specify any needed overrides for WCF	Clob	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ErpConnection	One connection to an ERP connector, specifying Client and other required information

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

ErpConnector erpconnectors ErpConnection table ERP Connector API Changes Get All Connectors ERP Sync Service WCF host

⌘I