Description
Used to represent stand-alone Bank Transactions– this does not include Payments.Parameters
ID
Integer
Integer
The system-wide, unique ID number for the Transaction (immutable)
accid
Integer
Integer
The parent Bank Account Nominal Code code
TransactionDate
DateTime
DateTime
The date of this Transaction
moneyin
Decimal
Decimal
If a money in Transaction, the value of the Transaction
moneyout
Decimal
Decimal
If a money out Transaction, the value of the Transaction
Vatable
Integer
Integer
0 if the Transaction will be ignored in VAT reporting
1 if the Transaction will be considered in VAT reporting
1 if the Transaction will be considered in VAT reporting
VatRate
Decimal
Decimal
The VAT rate for the Transaction
VatAmount
Decimal
Decimal
The VAT amount for the Transaction
TransactionType
Decimal
Decimal
The Nominal Code code the Transaction is raised against
Comment
String
String
The comment on the Transaction
ProjectID
Decimal
Decimal
If a Project is associated with the Transaction then the ProjectID, else 0
CustomerID
Decimal
Decimal
If the Transaction TransactionType is the Nominal Code code for the Debtors Control Account then the CustomerID for the associated Customer, else 0
SupplierID
Decimal
Decimal
If the Transaction TransactionType is the Nominal Code code for the Creditors Control Account then the SupplierID for the associated Supplier, else 0