Skip to main content

Org payment option dimension table

Table Name

Column Name

Column Type

Primary Key

Mapped Dimension Table

Mapped Dimension Table Column

Bi_DimOrgPaymentOption_s3

organizationid

VARCHAR(36)

Bi_DimOrgPaymentOption_s3

paymentoptiontype

NVARCHAR(160)

Bi_DimOrgPaymentOption_s3

paymenttype

NVARCHAR(40)

Bi_DimOrgPaymentOption_s3

orgaPaymentOptionId

VARCHAR(36)

PK

Bi_DimOrgPaymentOption_s3

paymenttypedisplayname

NVARCHAR(MAX)

Bi_DimOrgPaymentOption_s3

void

INT

Bi_DimOrgPaymentOption_s3

paymentoptiontypeintid

VARCHAR(100)

Bi_DimOrgPaymentOption_s3

EtlLastUpdatedOn

TIMESTAMP

Bi_DimOrgPaymentOption_s3

EtlLastUpdatedBy

NVARCHAR(50)

Bi_DimOrgPaymentOption_s3

PodName

VARCHAR(20)

Bi_DimOrgPaymentOption_s3

groupid

BIGINT