v_FACT_FINANCIALTRANSACTIONLINEITEMSITE
Stores information about the sites that have security rights to a financial transaction line item
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINANCIALTRANSACTIONLINEITEMSITEFACTID | int | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE].FINANCIALTRANSACTIONLINEITEMSITEFACTID | |
| SITEDIMID | int | yes | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE].SITEDIMID |
| SITESYSTEMID | uniqueidentifier | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE].SITESYSTEMID | |
| FINANCIALTRANSACTIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE].FINANCIALTRANSACTIONSYSTEMID |
| FINANCIALTRANSACTIONFACTID | int | yes | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE].FINANCIALTRANSACTIONFACTID |
| FINANCIALTRANSACTIONLINEITEMSYSTEMID | uniqueidentifier | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE].FINANCIALTRANSACTIONLINEITEMSYSTEMID | |
| FINANCIALTRANSACTIONLINEITEMFACTID | int | yes | BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE].FINANCIALTRANSACTIONLINEITEMFACTID |
Definition
Copy
create view [BBDW].[v_FACT_FINANCIALTRANSACTIONLINEITEMSITE] as
select
LIS.FINANCIALTRANSACTIONLINEITEMSITEFACTID,
LIS.SITEDIMID,
LIS.SITESYSTEMID,
LIS.FINANCIALTRANSACTIONSYSTEMID,
LIS.FINANCIALTRANSACTIONFACTID,
LIS.FINANCIALTRANSACTIONLINEITEMSYSTEMID,
LIS.FINANCIALTRANSACTIONLINEITEMFACTID
from [BBDW].[FACT_FINANCIALTRANSACTIONLINEITEMSITE] LIS;