CreditorTransactionsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CreditorTransactionsHistorySeq int identity 4 √ null
TransactionSeq int 4 √ null
ID int 4 √ null
PostingNumber int 4 √ null
PostingSource varchar 10 √ null
InvoiceMode char 1 √ null
InvoiceNumber varchar 20 √ null
TransactionDate datetime 16,3 √ null
ChequeNumber int 4 √ null
Description varchar 50 √ null
Amount money 21,4 √ null
Discount money 21,4 √ null
DisputedFlag bit 1 √ null
DueDate datetime 16,3 √ null
TotalAllocated money 21,4 √ null
PayNextChequeRunFlag bit 1 √ null
BulkSelectedFlag bit 1 √ null
ChequeDate datetime 16,3 √ null
ReferenceTransactionSeq int 4 √ null
ChequePostingNumber int 4 √ null
PaymentMethod varchar 5 √ null
EFTPostingNumber int 4 √ null
PricesIncludeTaxFlag bit 1 √ null
AutoGeneratedFlag bit 1 √ null
BankControlGLJournalSeq int 4 √ null
CreditorControlGLJournalSeq int 4 √ null
TaxExpenseControlGLJournalSeq int 4 √ null
ForeignCurrencyCode varchar 15 √ null
ForeignCurrencyExchangeRate decimal 18,8 √ null
ForeignCurrencyAmount money 21,4 √ null
CreatedDate datetime 16,3 √ null
CreatedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
BankFeeAmount money 21,4 √ null
BankFeeAmountForeignCurrency money 21,4 √ null
BankFeeGLCode varchar 15 √ null
BankFeeDescription varchar 100 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_CreditorTransactionsHistory Primary key Asc CreditorTransactionsHistorySeq
AK_CreditorTransactionsHistory_TransactionSeq Performance Asc TransactionSeq