pvwkCreditorTransactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
wkCreditorTransactionsSeq int 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
InvoiceDescriptionFull varchar 73 null
InvoiceAmount money 21,4 √ null
LocalCurrencyAmount money 21,4 null
BankFeeAmountActual money 21,4 √ null
PaymentNumber int 4 null
PaymentPostingNumber int 4 null
AmountToReconcile money 21,4 √ null
AmountToReconcileForeignCurrency money 21,4 √ null
PaidInFullFlag bit 1 √ null
BankControlGLJournalSeqActual int 4 √ null
CreditorControlGLJournalSeqAcual int 4 √ null
PostingDateActual datetime 16,3 √ null
InvoiceModePaidFlag bit 1 √ null
ModifyInProcessFlag bit 1 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views