Org custom fields dimension table

Bi_DimOrgCustomFields_s3

FieldName

NVARCHAR(1024)

Bi_DimOrgCustomFields_s3

FieldDesc

NVARCHAR(4000)

Bi_DimOrgCustomFields_s3

OrganizationId

VARCHAR(36)

Bi_DimOrgCustomFields_s3

PrintOnReceipt

BOOLEAN

Bi_DimOrgCustomFields_s3

FieldTypeId

VARCHAR(36)

Bi_DimOrgCustomFields_s3

FieldTypeName

NVARCHAR(1024)

Bi_DimOrgCustomFields_s3

ListId

VARCHAR(36)

Bi_DimOrgCustomFields_s3

ListName

NVARCHAR(1024)

Bi_DimOrgCustomFields_s3

ListValue

NVARCHAR(65535)

Bi_DimOrgCustomFields_s3

ListDesc

NVARCHAR(4000)

Bi_DimOrgCustomFields_s3

FieldOrder

INT

Bi_DimOrgCustomFields_s3

CustomFieldType

INT

Bi_DimOrgCustomFields_s3

Void

BOOLEAN

Bi_DimOrgCustomFields_s3

Active

BOOLEAN

Bi_DimOrgCustomFields_s3

FieldAttributes

NVARCHAR(4000)

Bi_DimOrgCustomFields_s3

GroupId

DECIMAL(19,0)

Bi_DimOrgCustomFields_s3

DefaultValue

NVARCHAR(65535)

Bi_DimOrgCustomFields_s3

AllowGuestToView

BOOLEAN

Bi_DimOrgCustomFields_s3

AllowGuestToEdit

BOOLEAN

Bi_DimOrgCustomFields_s3

DataType

NVARCHAR(1024)

Bi_DimOrgCustomFields_s3

IsRequired

BOOLEAN

Bi_DimOrgCustomFields_s3

ShowInGrid

BOOLEAN

Bi_DimOrgCustomFields_s3

EntityDefinitionFK

DECIMAL(19,0)

Bi_DimOrgCustomFields_s3

ReferenceEntityDefFK

DECIMAL(19,0)

Bi_DimOrgCustomFields_s3

SpanAcrossColumns

BOOLEAN

Bi_DimOrgCustomFields_s3

MatchRegex

NVARCHAR(1020)

Bi_DimOrgCustomFields_s3

FormatFunc

NVARCHAR(16000)

Bi_DimOrgCustomFields_s3

ValidationMsgLabel

NVARCHAR(1020)

Bi_DimOrgCustomFields_s3

updatedOn

TIMESTAMP

Bi_DimOrgCustomFields_s3

FieldCode

NVARCHAR(128)

Bi_DimOrgCustomFields_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimOrgCustomFields_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimOrgCustomFields_s3

PodName

VARCHAR(20)

Bi_DimOrgCustomFields_s3

etlgroupid

BIGINT