Table MD_GLTransactionSource

Card of table MD_GLTransactionSource

Name

MD_GLTransactionSource

Dimensional Type

Dimension

Comment

Simple dimension holding transaction source codes and descriptions. The transaction source forms part of every general-ledger entry.

For more detailed information on transaction sources (e.g., for auditing purposes), there is also a field on the MF_GLFact table that contains the transaction reference number.


Check constraint name of the table MD_GLTransactionSource

CKT_MD_GLTRANSACTIONSOURCE


List of incoming references of the table MD_GLTransactionSource

Name

Child Table

Foreign Key Columns

Relationship_30

MF_GLFact

MD_GLTransSrc_SurrogateKey


List of referencing views of the table MD_GLTransactionSource

Name

Code

VW_GLInfoWithDynamicSecurity

VW_GLINFOWITHDYNAMICSECURITY


List of diagrams containing the table MD_GLTransactionSource

Name

StarsBusinessDiagram


List of columns of the table MD_GLTransactionSource

Name

Comment

Domain

Data Type

Length

MD_GLTransSrc_SurrogateKey

 

<None>

numeric

 

MD_GLTransSrc_Code

 

DW_CodeDescShort

varchar(16)

16

MD_GLTransSrc_Name

 

DW_CodeDescLong

varchar(64)

64

MD_GLTransSrc_AuditKey

 

DW_AuditKey

bigint

 

MD_GLTransSrc_Timestamp

 

<None>

timestamp

 


List of indexes of the table MD_GLTransactionSource

Name

Unique

Cluster

Primary

Foreign Key

Alternate Key

Table

MD_GLTRANSACTIONSOURCE_PK

TRUE

TRUE

TRUE

FALSE

FALSE

MD_GLTransactionSource

MD_GLTRANSACTIONSOURCE_AK

TRUE

FALSE

FALSE

FALSE

TRUE

MD_GLTransactionSource


List of keys of the table MD_GLTransactionSource

Name

Identifier_1

AltKey


Previous
Home
Next