V_QUERY_BBDW_REVENUELETTER
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUELETTERSYSTEMID | uniqueidentifier | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| LETTER | nvarchar(100) | yes | |
| LETTERDESCRIPTION | nvarchar(255) | yes | |
| ACKNOWLEDGEDATE | datetime | yes | |
| ACKNOWLEDGEDATEDIMID | int | yes | |
| PROCESSDATE | datetime | yes | |
| PROCESSDATEDIMID | int | yes | |
| OUTOFDATE | bit | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_REVENUELETTER] as
select
rl.[REVENUELETTERSYSTEMID],
rl.[FINANCIALTRANSACTIONFACTID],
l.[LETTER],
l.[LETTERDESCRIPTION],
rl.[ACKNOWLEDGEDATE],
rl.[ACKNOWLEDGEDATEDIMID],
rl.[PROCESSDATE],
rl.[PROCESSDATEDIMID],
rl.[OUTOFDATE]
from BBDW.[FACT_REVENUELETTER] rl
left join BBDW.[DIM_LETTER] l on rl.[LETTERDIMID] = l.[LETTERDIMID] and rl.[LETTERDIMID] <> 0