v_DIM_WRITEOFF
The write-off dimension contains information about revenue write-offs.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| WRITEOFFDIMID | int | BBDW.[DIM_WRITEOFF].[WRITEOFFDIMID] | |
| WRITEOFFREASONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_WRITEOFF].[WRITEOFFREASONSYSTEMID] |
| WRITEOFFREASONCODE | nvarchar(12) | yes | BBDW.[DIM_WRITEOFF].[WRITEOFFREASONCODE] |
| WRITEOFFREASONDESCRIPTION | nvarchar(50) | yes | BBDW.[DIM_WRITEOFF].[WRITEOFFREASONDESCRIPTION] |
| WRITEOFFPOSTSTATUSCODE | tinyint | yes | BBDW.[DIM_WRITEOFF].[WRITEOFFPOSTSTATUSCODE] |
| WRITEOFFPOSTSTATUS | nvarchar(50) | yes | BBDW.[DIM_WRITEOFF].[WRITEOFFPOSTSTATUS] |
Definition
Copy
create view [BBDW].[v_DIM_WRITEOFF] as
select
[WRITEOFFDIMID],
[WRITEOFFREASONSYSTEMID],
[WRITEOFFREASONCODE],
[WRITEOFFREASONDESCRIPTION],
[WRITEOFFPOSTSTATUSCODE],
[WRITEOFFPOSTSTATUS]
from BBDW.[DIM_WRITEOFF]