tGeneralLedgerHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tGeneralLedgerHistorySeq int identity 4 √ null
ModifiedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
GeneralLedgerSeq int 4 √ null
GLYear smallint 2 √ null
GLCode varchar 15 √ null
GLCreatedDate datetime 16,3 √ null
GLCreatedBy varchar 50 √ null
GLDescription varchar 50 √ null
ProfitLossFlag bit 1 √ null
NormallyCreditFlag bit 1 √ null
CostCentreCode varchar 15 √ null
EnforceDescriptionFlag bit 1 √ null
HeadingLevel tinyint 1 √ null
LastYearMovement money 21,4 √ null
StartYearBalance money 21,4 √ null
CurrentBalance money 21,4 √ null
SubLedgerControl varchar 5 √ null
ReceiptAllocationCode varchar 5 √ null
TaxCode varchar 5 √ null
TaxCodeFixedFlag bit 1 √ null
GLClassificationCode varchar 15 √ null
GovernmentReturnCategory varchar 15 √ null
RequiresSubAllocationFlag bit 1 √ null
ActiveFlag bit 1 √ null
GLCOACode varchar 10 √ null
Comment varchar 2147483647 √ null
AllowJournalsFlag varchar 1 ('Y')
JournalEntryMessage varchar 255 ('')

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_tGeneralLedgerHistory_tGeneralLedgerHistorySeq Primary key Asc tGeneralLedgerHistorySeq