vGeneralLedgerSubAllocationBalances


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GLYear smallint 2 null
GLSubAllocationCode varchar 15 null
SubAllocationDescription varchar 50 null
GLCode varchar 15 null
GLDescription varchar 50 null
GLSubAllocationCurrentGLYearFlag bit 1 √ null
GLCodeFull varchar 31 null
GLDescriptionFull varchar 66 null
GLActiveFlag bit 1 null
ProfitLossFlag bit 1 null
CostCentreCode varchar 15 null
GLCOACode varchar 10 null
GLDivisionCode varchar 15 null
GLCodeStartYearBalance money 21,4 null
GLCodeLastYearMovement money 21,4 null
SubAllocationStartYearBalance money 21,4 √ null
SubAllocationLastYearMovement money 21,4 √ null
SubAllocationGLStartYearBalance money 21,4 √ null
SubAllocationGLLastYearMovement money 21,4 √ null
GLJournalSeq int 4 null
PostingNumber int 4 null
PostingDescription varchar 60 null
PostingDate datetime 16,3 √ 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
InvoiceNumberIssued int 4 null
ID int 4 null
MailNamePrimary varchar 100 null
InvoiceLineDescription varchar 80 √ null
OrderNumber int 4 null
PrintVersion smallint 2 √ null
CostCentreDescription varchar 100 null
CreditorID int 4 null
CreditorName varchar 100 null
CreditorInvoiceNumber varchar 20 null
CreditorInvoiceDescription varchar 50 null
DebtorID int 4 null
DebtorSurname varchar 30 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views