Columns

Columns

Table	Type	Column	Type	Size	Nulls	Auto	Default	Comments
CodeProvider	Table	ActiveFlag	bit	1			null
Interface	Table	Description	varchar	200			null
InterfaceVersionCodeSetVersion	Table	InterfaceCode	varchar	50			null
LookupCodeMappingOutbound	Table	RowVersion	int	4			((1))
InterfaceVersion	Table	Namespace	varchar	255	√		null
CodeSet	Table	Description	varchar	1000			null
ExternalSystemInterfaceVersion	Table	RowVersion	int	4			((1))
Setting	Table	ModifiedBy	varchar	100	√		null
Setting	Table	Description	varchar	2147483647	√		null
InterfaceVersionCodeSetVersion	Table	InterfaceVersion	varchar	50			null
LookupCodeMappingOutbound	Table	xsysCodeValue	varchar	50	√		null
pvLookupCodeMappingOutbound	View	InterfaceVersion	varchar	50			null
ExternalSystem	Table	RowVersion	int	4			((1))
ExternalSystem	Table	CentrallyManagedFlag	bit	1	√		null
LookupCodeMappingInbound	Table	CentrallyManagedFlag	bit	1	√		null
ExternalSystemInterfaceVersion	Table	InterfaceCode	varchar	50			null
pvLookupCodeMappingOutbound	View	InterfaceCode	varchar	50			null
LookupCodeMappingOutbound	Table	LookupCode	varchar	50			null
Interface	Table	Code	varchar	50			null
Interface	Table	ModifiedBy	varchar	100	√		null
Setting	Table	ReadOnlyFlag	bit	1			null
Interface	Table	ActiveFlag	bit	1			((1))
CodeSetVersion	Table	CodeSet	varchar	50			null
Interface	Table	CentrallyManagedFlag	bit	1	√		null
LookupCodeMappingInbound	Table	xsysCodeProvider	varchar	50			null
LookupCodeMappingInbound	Table	xsysCodeValue	varchar	50			null
pvLookupCodeMappingOutbound	View	LookupCode	varchar	50			null
Setting	Table	DataType	varchar	20			null
ExternalSystemInterfaceVersion	Table	ModifiedDate	datetime	16	√		null
CodeSetVersion	Table	DateTo	datetime	16	√		null
LookupCodeMappingInbound	Table	LookupCode	varchar	50	√		null
CodeSetVersion	Table	Version	varchar	50			null
InterfaceVersion	Table	ModifiedDate	datetime	16	√		null
ExternalSystem	Table	ActiveFlag	bit	1			((1))
InterfaceVersion	Table	CentrallyManagedFlag	bit	1	√		null
LookupCodeMappingInbound	Table	LookupTable	varchar	100			null
LookupCodeMappingOutbound	Table	xsysCodeProvider	varchar	50			null
CodeSetVersion	Table	CodeProvider	varchar	50			null
CodeSet	Table	LookupTable	varchar	100			null
Setting	Table	MultiTenantOnlyFlag	bit	1			((0))
InterfaceVersion	Table	ModifiedBy	varchar	100	√		null
CodeValue	Table	ActiveFlag	bit	1			null
LookupCodeMappingOutbound	Table	ModifiedDate	datetime	16	√		null
ExternalSystemInterfaceVersion	Table	ActiveFlag	bit	1			((1))
LookupCodeMappingOutbound	Table	CentrallyManagedFlag	bit	1	√		null
Setting	Table	RowVersion	int	4			((1))
pvLookupCodeMappingOutbound	View	LookupTable	varchar	100			null
pvLookupCodeMappingOutbound	View	xsysCodeValue	varchar	50	√		null
ExternalSystem	Table	Description	varchar	200			null
CodeProvider	Table	Description	varchar	200			null
LookupCodeMappingInbound	Table	xsysCodeSetVersion	varchar	50			null
LookupCodeMappingInbound	Table	ModifiedBy	varchar	100	√		null
ExternalSystem	Table	Code	varchar	50			null
InterfaceVersionCodeSetVersion	Table	HasOutboundMappingFlag	bit	1	√		((0))
ExternalSystemInterfaceVersion	Table	InterfaceVersion	varchar	50			null
Setting	Table	DefaultValue	varchar	1000	√		null
Setting	Table	Value	varchar	1000	√		null
InterfaceVersionCodeSetVersion	Table	HasInboundMappingFlag	bit	1	√		((0))
CodeValue	Table	Code	varchar	50			null
InterfaceVersionCodeSetVersion	Table	CodeVersion	varchar	50			null
InterfaceVersionCodeSetVersion	Table	Seq	int identity	4		√	null
InterfaceVersion	Table	Version	varchar	50			null
ExternalSystemInterfaceVersion	Table	ExternalSystemCode	varchar	50			null
Setting	Table	ModifiedDate	datetime	16	√		null
CodeValue	Table	Extra	xml	1073741823	√		null
CodeValue	Table	CodeProvider	varchar	50			null
LookupCodeMappingOutbound	Table	LookupTable	varchar	100			null
ExternalSystem	Table	ModifiedDate	datetime	16	√		null
InterfaceVersionCodeSetVersion	Table	ActiveFlag	bit	1			((1))
Interface	Table	RowVersion	int	4			((1))
LookupCodeMappingInbound	Table	RowVersion	int	4			((1))
CodeValue	Table	Description	varchar	200			null
LookupCodeMappingInbound	Table	xsysCodeSet	varchar	50			null
Setting	Table	DisplayName	varchar	100	√		null
CodeValue	Table	LookupTable	varchar	100			null
ExternalSystemInterfaceVersion	Table	ModifiedBy	varchar	100	√		null
CodeSetVersion	Table	DateFrom	datetime	16	√		null
InterfaceVersion	Table	InterfaceCode	varchar	50			null
LookupCodeMappingInbound	Table	ID	int identity	4		√	null
LookupCodeMappingOutbound	Table	xsysCodeSetVersion	varchar	50			null
CodeSet	Table	CodeProvider	varchar	50			null
InterfaceVersionCodeSetVersion	Table	CodeSet	varchar	50			null
CodeValue	Table	CodeVersion	varchar	50			null
ExternalSystem	Table	ModifiedBy	varchar	100	√		null
InterfaceVersionCodeSetVersion	Table	CodeProvider	varchar	50			null
Interface	Table	ModifiedDate	datetime	16	√		null
LookupCodeMappingOutbound	Table	ModifiedBy	varchar	100	√		null
CodeProvider	Table	Code	varchar	50			null
CodeSet	Table	ActiveFlag	bit	1			null
CodeSet	Table	CodeSet	varchar	50			null
Setting	Table	Key	varchar	100			null
ExternalSystemInterfaceVersion	Table	CentrallyManagedFlag	bit	1	√		null
InterfaceVersion	Table	RowVersion	int	4			((1))
InterfaceVersion	Table	ActiveFlag	bit	1			null
LookupCodeMappingOutbound	Table	ID	int identity	4		√	null
CodeSetVersion	Table	ActiveFlag	bit	1			null
CodeValue	Table	CodeSet	varchar	50			null
LookupCodeMappingOutbound	Table	xsysCodeSet	varchar	50			null
Setting	Table	SettingSeq	int identity	4		√	null
Setting	Table	CentrallyManagedFlag	bit	1			((0))
LookupCodeMappingInbound	Table	ModifiedDate	datetime	16	√		null