v_FACT_REVENUELETTER
Stores information about revenue letters
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUELETTERFACTID | int | BBDW.[FACT_REVENUELETTER].[REVENUELETTERFACTID] | |
| REVENUELETTERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_REVENUELETTER].[REVENUELETTERSYSTEMID] |
| FINANCIALTRANSACTIONFACTID | int | yes | BBDW.[FACT_REVENUELETTER].[FINANCIALTRANSACTIONFACTID] |
| LETTERDIMID | int | yes | BBDW.[FACT_REVENUELETTER].[LETTERDIMID] |
| ACKNOWLEDGEECONSTITUENTDIMID | int | yes | BBDW.[FACT_REVENUELETTER].[ACKNOWLEDGEECONSTITUENTDIMID] |
| ACKNOWLEDGEECONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_REVENUELETTER].[ACKNOWLEDGEECONSTITUENTSYSTEMID] |
| PROCESSDATE | datetime | yes | BBDW.[FACT_REVENUELETTER].[PROCESSDATE] |
| PROCESSDATEDIMID | int | yes | BBDW.[FACT_REVENUELETTER].[PROCESSDATEDIMID] |
| ACKNOWLEDGEDATE | datetime | yes | BBDW.[FACT_REVENUELETTER].[ACKNOWLEDGEDATE] |
| ACKNOWLEDGEDATEDIMID | int | yes | BBDW.[FACT_REVENUELETTER].[ACKNOWLEDGEDATEDIMID] |
| OUTOFDATE | bit | yes | BBDW.[FACT_REVENUELETTER].[OUTOFDATE] |
Definition
Copy
create view [BBDW].[v_FACT_REVENUELETTER] as
select
[REVENUELETTERFACTID],
[REVENUELETTERSYSTEMID],
[FINANCIALTRANSACTIONFACTID],
[LETTERDIMID],
[ACKNOWLEDGEECONSTITUENTDIMID],
[ACKNOWLEDGEECONSTITUENTSYSTEMID],
[PROCESSDATE],
[PROCESSDATEDIMID],
[ACKNOWLEDGEDATE],
[ACKNOWLEDGEDATEDIMID],
[OUTOFDATE]
from [BBDW].[FACT_REVENUELETTER];