vGeneralLedgerJournals


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GLYear smallint 2 null
GLCode varchar 15 null
GLCreatedDate datetime 16,3 √ null
GLCreatedBy varchar 50 √ null
GLModifiedDate datetime 16,3 √ null
GLModifiedBy varchar 50 √ null
GLDescription varchar 50 null
GLActiveFlag bit 1 null
GLProfitLossFlag bit 1 null
GLNormallyCreditFlag bit 1 null
GLCostCentreCode varchar 15 null
GLEnforceDescriptionFlag bit 1 null
GLHeadingFlag tinyint 1 null
GLLastYearMovement money 21,4 null
GLStartYearBalance money 21,4 null
GLCurrentBalance money 21,4 null
GLJournalSeq int 4 √ null
GLSubAllocationCode varchar 15 √ null
GLCodeFull varchar 31 √ null
PostingNumber int 4 √ null
PostingDescription varchar 60 √ null
PostingMonth int 4 √ null
PostingYear int 4 √ null
PostingDate datetime 16,3 √ null
PostingCompleteFlag bit 1 √ null
PostingDeletedFlag bit 1 √ null
PostingCreatedDate datetime 16,3 √ null
PostingCreatedBy varchar 50 √ null
GLJournalDate datetime 16,3 √ null
PostingSource varchar 10 √ null
ReceiptNumber int 4 √ null
DebtorTransactionSeq int 4 √ null
CreditorTransactionSeq int 4 √ null
PayCode varchar 10 √ null
GLJournalAmount money 21,4 √ null
GLJournalDescription varchar 255 √ null
SaleInvoiceNumber int 4 √ null
TaxCode varchar 5 √ null
TaxAmount money 21,4 √ null
IncomeFlag bit 1 √ null
InvoiceNumberIssued int 4 √ null
ID int 4 √ null
MailNamePrimary varchar 100 √ null
GLClassificationCode varchar 15 √ null
AdjustmentFlag bit 1 √ null
BASPostingNumber int 4 √ null
InvoiceLineDescription varchar 80 √ null
OrderNumber int 4 √ null
PrintVersion smallint 2 √ null
GLCOACode varchar 10 null
GLDivisionCode varchar 15 √ null
GLComment varchar 2147483647 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views