View VMD_GLFactAnnotation

Card of view VMD_GLFactAnnotation

Name

VMD_GLFactAnnotation

Comment

See MD_GLFactAnnotation in the StarsBusiness package.

This dimension is not normally used for reporting.

Dimensional Type

Dimension


SQL query of the view VMD_GLFactAnnotation

select
MD_GLFACTNOTE_SURROGATEKEY,
MD_GLFACTNOTE_TEXT
from
MD_GLFACTANNOTATION


List of incoming view references of the view VMD_GLFactAnnotation

Name

Child Table/View

ViewReference_54

VMF_GLFact


List of referenced objects of the view VMD_GLFactAnnotation

Name

MD_GLFactAnnotation


List of diagrams containing the view VMD_GLFactAnnotation

Name

ViewsBusinessDiagram


List of permissions of the view VMD_GLFactAnnotation

Grant

User

SELECT,VIEW DEFINITION

BusinessReader


List of view columns of the view VMD_GLFactAnnotation

Name

Data Type

Comment

Length

MD_GLFactNote_SurrogateKey

numeric

 

 

MD_GLFactNote_Text

varchar(128)

Text attached to general-ledger entry (contains some explanation of the transaction). Everything here is mapped to uppercase (ugh), because GL annotations often vary with respect to case.

This field is best used in filters, not rows or columns in reports. It's too big.

128