GeneralLedgerJournalsUpdated


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UpdatedSeq int identity 4 √ null
TransactionUpdatedDate datetime 16,3 √ (getdate())
TransactionUpdatedBy varchar 30 √ null
TranCount int 4 √ null
RowCount int 4 √ null
GLJournalSeq int 4 √ null
GLYear smallint 2 √ null
GLCode varchar 15 √ null
GLSuballocationCode varchar 15 √ null
PostingNumber int 4 √ null
GLDate datetime 16,3 √ null
PostingSource varchar 10 √ null
ReceiptNumber int 4 √ null
DebtorTransactionSeq int 4 √ null
CreditorTransactionSeq int 4 √ null
GLAmount money 21,4 √ null
JournalDescription varchar 255 √ null
ReverseGLJournalSeq int 4 √ null
PayCode varchar 10 √ 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
GLClassificationCode varchar 15 √ null
AdjustmentFlag bit 1 √ null
BASPostingNumber int 4 √ null
InvoiceLineDescription varchar 80 √ null
OrderNumber int 4 √ null
BankFeeFlag bit 1 √ null
StockMovementGLJournalSeq int 4 √ null
StockControlGLJournalSeq int 4 √ null
PostingNumberTransfer int 4 √ null
PrintVersion smallint 2 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_GeneralLedgerJournalsUpdated Primary key Asc UpdatedSeq