MARIProject Database Structure

View Name:MARISupportSyncPartner
Based on table:MPHotlineSyncPartner
Group:Group: SupportIssue
Description:Support Module: Synchronizaion settings
ClassID: 272. See Overview of ClassIDs by table.

Field Table(Germ.field)/Type Description Related
SyncPartnerID SyncPartnerID

INT Primary

SyncPartnerName SyncPartnerName

NVARCHAR (50)

SyncActive SyncActive

SMALLINT

ExternalPartnerID ExternalPartnerID

INT

CardCode CardCode

NVARCHAR (20)

OCRD.CardCode
Company Company

SMALLINT

MARISysConnections.Company (WHERE ConnectionType=6)
LoginToPartnerUser LoginToPartnerUser

NVARCHAR (255)

LoginToPartnerPWD LoginToPartnerPWD

NVARCHAR (255)

LinkToPartner LinkToPartner

NVARCHAR (255)

MappingMode MappingMode

INT

OptionMemo OptionMemo

NTEXT

CreateDate Erstanlage

Datetime

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany