GeneralLedgerFinanceReports


Columns

Column Type Size Nulls Auto Default Children Parents Comments
FinanceReportCode varchar 15 ('')
GeneralLedgerFinanceReportLinks.FinanceReportCode FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel1 decimal 10,4 ((0))
GeneralLedgerFinanceReportLinks.FinanceLevel1 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel2 decimal 10,4 ((0))
GeneralLedgerFinanceReportLinks.FinanceLevel2 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel3 decimal 10,4 ((0))
GeneralLedgerFinanceReportLinks.FinanceLevel3 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceDetailSeq decimal 10,4 ((0))
GeneralLedgerFinanceReportLinks.FinanceDetailSeq FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
SubTotalFlag bit 1 ((0))
IncludeProfitLossFlag bit 1 ((0))
GLDetailFlag bit 1 ((0))
Description varchar 255 √ ('')
CreditFlag bit 1 ((0))
Comment varchar 255 ('')
FinanceLevel4 decimal 10,4 ((0.0))
GeneralLedgerFinanceReportLinks.FinanceLevel4 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel5 decimal 10,4 ((0.0))
GeneralLedgerFinanceReportLinks.FinanceLevel5 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
FinanceLevel6 decimal 10,4 ((0.0))
GeneralLedgerFinanceReportLinks.FinanceLevel6 FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports R
PageBreakFlag bit 1 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_GeneralLedgerFinanceReport Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc FinanceReportCode + FinanceLevel1 + FinanceLevel2 + FinanceLevel3 + FinanceLevel4 + FinanceLevel5 + FinanceLevel6 + FinanceDetailSeq

Relationships

Close relationships within degrees of separation