v_DIM_REVENUECODE
The revenue code dimension contains a collection of codes that describe a revenue record.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUECODEDIMID | int | BBDW.[DIM_REVENUECODE].[REVENUECODEDIMID] | |
| REVENUEPAYMENTMETHODCODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUEPAYMENTMETHODCODE] |
| REVENUEPAYMENTMETHOD | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUEPAYMENTMETHOD] |
| REVENUETRANSACTIONTYPECODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUETRANSACTIONTYPECODE] |
| REVENUETRANSACTIONTYPE | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUETRANSACTIONTYPE] |
| REVENUEPOSTSTATUSCODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUEPOSTSTATUSCODE] |
| REVENUEPOSTSTATUS | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUEPOSTSTATUS] |
| REVENUERECEIPTTYPECODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUERECEIPTTYPECODE] |
| REVENUERECEIPTTYPE | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUERECEIPTTYPE] |
| REVENUEAPPLICATIONTYPECODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATIONTYPECODE] |
| REVENUEAPPLICATIONTYPE | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATIONTYPE] |
| REVENUEAPPLICATIONCODE | int | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATIONCODE] |
| REVENUEAPPLICATION | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[REVENUEAPPLICATION] |
| FINANCIALTRANSACTIONLINEITEMTYPECODE | int | yes | BBDW.[DIM_REVENUECODE].[FINANCIALTRANSACTIONLINEITEMTYPECODE] |
| FINANCIALTRANSACTIONLINEITEMTYPE | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[FINANCIALTRANSACTIONLINEITEMTYPE] |
| FINANCIALTRANSACTIONLINEITEMPOSTSTATUSCODE | int | yes | BBDW.[DIM_REVENUECODE].[FINANCIALTRANSACTIONLINEITEMPOSTSTATUSCODE] |
| FINANCIALTRANSACTIONLINEITEMPOSTSTATUS | nvarchar(50) | yes | BBDW.[DIM_REVENUECODE].[FINANCIALTRANSACTIONLINEITEMPOSTSTATUS] |
Definition
Copy
CREATE view [BBDW].[v_DIM_REVENUECODE] as
select
[REVENUECODEDIMID],
[REVENUEPAYMENTMETHODCODE],
[REVENUEPAYMENTMETHOD],
[REVENUETRANSACTIONTYPECODE],
[REVENUETRANSACTIONTYPE],
[REVENUEPOSTSTATUSCODE],
[REVENUEPOSTSTATUS],
[REVENUERECEIPTTYPECODE],
[REVENUERECEIPTTYPE],
[REVENUEAPPLICATIONTYPECODE],
[REVENUEAPPLICATIONTYPE],
[REVENUEAPPLICATIONCODE],
[REVENUEAPPLICATION],
[FINANCIALTRANSACTIONLINEITEMTYPECODE],
[FINANCIALTRANSACTIONLINEITEMTYPE],
[FINANCIALTRANSACTIONLINEITEMPOSTSTATUSCODE],
[FINANCIALTRANSACTIONLINEITEMPOSTSTATUS]
from [BBDW].[DIM_REVENUECODE]