CreditorTransactionsDeleted


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TransactionDeletedDate datetime 16,3 √ (getdate())
TransactionDeletedBy varchar 30 √ null
TranCount int 4 √ null
RowCount 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
CreatedDate datetime 16,3 √ null
CreatedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null

Table contained -1 rows