GeneralLedgerFinanceReportLinks


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GLCode varchar 15 ('')
FinanceReportCode varchar 15 ('')
GeneralLedgerFinanceReports.FinanceReportCode FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel1 decimal 10,4 ((0))
GeneralLedgerFinanceReports.FinanceLevel1 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel2 decimal 10,4 ((0))
GeneralLedgerFinanceReports.FinanceLevel2 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel3 decimal 10,4 ((0))
GeneralLedgerFinanceReports.FinanceLevel3 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceDetailSeq decimal 10,4 ((0))
GeneralLedgerFinanceReports.FinanceDetailSeq FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel4 decimal 10,4 ((0.0))
GeneralLedgerFinanceReports.FinanceLevel4 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel5 decimal 10,4 ((0.0))
GeneralLedgerFinanceReports.FinanceLevel5 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel6 decimal 10,4 ((0.0))
GeneralLedgerFinanceReports.FinanceLevel6 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_GeneralLedgerFinanceReportLink Primary key Asc/Asc GLCode + FinanceReportCode

Relationships

Close relationships within degrees of separation