v_DIM_OTHERPAYMENTMETHOD
Stores information about other payment method
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| OTHERPAYMENTMETHODDIMID | int | BBDW.[DIM_OTHERPAYMENTMETHOD].[OTHERPAYMENTMETHODDIMID] | |
| OTHERPAYMENTMETHODSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_OTHERPAYMENTMETHOD].[OTHERPAYMENTMETHODSYSTEMID] |
| OTHERPAYMENTMETHOD | nvarchar(100) | yes | BBDW.[DIM_OTHERPAYMENTMETHOD].[OTHERPAYMENTMETHOD] |
| OTHERPAYMENTMETHODISACTIVE | bit | yes | BBDW.[DIM_OTHERPAYMENTMETHOD].[OTHERPAYMENTMETHODISACTIVE] |
| OTHERPAYMENTMETHODSEQUENCE | int | yes | BBDW.[DIM_OTHERPAYMENTMETHOD].[OTHERPAYMENTMETHODSEQUENCE] |
Definition
Copy
create view [BBDW].[v_DIM_OTHERPAYMENTMETHOD] as
select
[OTHERPAYMENTMETHODDIMID],
[OTHERPAYMENTMETHODSYSTEMID],
[OTHERPAYMENTMETHOD],
[OTHERPAYMENTMETHODISACTIVE],
[OTHERPAYMENTMETHODSEQUENCE]
from [BBDW].[DIM_OTHERPAYMENTMETHOD];