GeneralLedgerJournals


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GLJournalSeq int identity 4 √ null
DebtorTransactions.CreditorGLJournalSeq FK_DebtorTransactions_GeneralLedgerJournals_CreditorGLJournalSeq R
GLYear smallint 2 ((0))
tGeneralLedger.GLYear FK_GeneralLedgerJournals_GeneralLedger R
GLCode varchar 15 ('')
tGeneralLedger.GLCode FK_GeneralLedgerJournals_GeneralLedger R
GLSuballocationCode varchar 15 ('')
PostingNumber int 4 ((0))
GeneralLedgerPostingControl.PostingNumber FK_GeneralLedgerJournals_GeneralLedgerPostingControl R
GLDate datetime 16,3 (getdate())
PostingSource varchar 10 ('')
ReceiptNumber int 4 ((0))
DebtorTransactionSeq int 4 ((0))
CreditorTransactionSeq int 4 ((0))
GLAmount money 21,4 ((0))
JournalDescription varchar 255 ('')
ReverseGLJournalSeq int 4 ((0))
PayCode varchar 10 ('')
SaleInvoiceNumber int 4 ((0))
TaxCode varchar 5 ('')
TaxAmount money 21,4 ((0))
IncomeFlag bit 1 ((0))
InvoiceNumberIssued int 4 ((0))
ID int 4 ((0))
GLClassificationCode varchar 15 ('')
AdjustmentFlag bit 1 ((0))
BASPostingNumber int 4 ((0))
InvoiceLineDescription varchar 80 √ null
OrderNumber int 4 ((0))
DebtorTransactionXRefSeq int 4 √ null
GeneralLedgerJournalCreatedDate datetime 16,3 √ null
GeneralLedgerJournalCreatedByID int 4 √ null
DebtorTransactionSeqCharge int 4 ((0))
ControlJournalFlag bit 1 ((0))
TaxIncomeControlGLSeq int 4 √ null
TaxExpenseControlGLSeq int 4 √ null
ForeignCurrencyCode varchar 15 ('')
ForeignCurrencyExchangeRate decimal 18,8 √ null
ForeignCurrencyGLAmount money 21,4 √ null
ForeignCurrencyTaxAmount money 21,4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
AllowBankTransactionFlag bit 1 ((1))
BankFeeFlag bit 1 ((0))
StockMovementGLJournalSeq int 4 √ null
StockControlGLJournalSeq int 4 √ null
PostingNumberTransfer int 4 √ null
PrintVersion smallint 2 √ null
ReplicateSourceSynDatabaseCode varchar 5 √ null
ReplicateSourcePostingNumber int 4 √ null
ReplicateSourceGLJournalSeq int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_GLJournals Primary key Asc GLJournalSeq
AK_GeneralLedgerJournals_BASPostingNumber Performance Asc BASPostingNumber
AK_GeneralLedgerJournals_ControlJournalFlag_includes Performance Asc ControlJournalFlag
AK_GeneralLedgerJournals_DebtorTransactionSeqCharge Performance Asc DebtorTransactionSeqCharge
AK_GeneralLedgerJournals_DebtorTransactionXRefSeq Performance Asc DebtorTransactionXRefSeq
AK_GeneralLedgerJournals_GLYear_GLDate_includes Performance Asc/Asc GLYear + GLDate
AK_GeneralLedgerJournals_ID Performance Asc ID
AK_GeneralLedgerJournals_InvoiceNumberIssued Performance Asc InvoiceNumberIssued
AK_GeneralLedgerJournals_PostingNumberGLAmount Performance Asc/Asc PostingNumber + GLAmount
AK_GeneralLedgerJournals_PostingNumberTransfer Performance Asc/Asc GLCode + PostingNumberTransfer
AK_GeneralLedgerJournals_ReceiptNumber Performance Asc ReceiptNumber
AK_GeneralLedgerJournals_ReverseGLJournalSeq Performance Asc ReverseGLJournalSeq
AK_GLJournals_CreditorTransactionSeq Performance Asc CreditorTransactionSeq
AK_GLJournals_DebtorTransactionSeq Performance Asc DebtorTransactionSeq
AK_GLJournals_PayCode Performance Asc PayCode
AK_GLJournals_PostingNumber Performance Asc PostingNumber
AK_GLJournalsYearCodeDate Performance Asc/Asc/Asc GLYear + GLCode + GLDate

Relationships

Close relationships within degrees of separation