POST 17.0/database/transactions

Description
Create Transactions

URI Parameters
None.

TransactionsUpdate

Name	Type	Additional information
ID	integer	None.
Type	byte	None.
Status	byte	None.
AddedDate	date	None.
DueDate	date	None.
StatusDate	date	None.
BankingDate	date	None.
UserID	integer	None.
ContactID	integer	None.
PropertyID	integer	None.
TenancyID	integer	None.
ProductID	integer	None.
TaxRateID	integer	None.
TaxRate	decimal number	None.
Debit	decimal number	None.
Credit	decimal number	None.
PaymentMethodID	integer	None.
Notes	string	String length: inclusive between 0 and 512
StatementID	integer	None.
InvoiceID	integer	None.
ReceiptID	integer	None.
BillID	integer	None.
CompanyAccount	byte	None.
BankAccountID	integer	None.
CommissionFee	decimal number	None.
CommissionPercentage	decimal number	None.
TransferFees	byte	None.
StatementNotes	string	String length: inclusive between 0 and 255
SiteID	integer	None.
LinkedTo	integer	None.
LinkedCascadeDelete	byte	None.
LinkGroup	integer	None.
PaymentCleared	byte	None.
PaymentClearedDate	date	None.
BankReconciliationID	integer	None.
IncludeOnBankRec	byte	None.
PaymentCollectionID	integer	None.
RentDemandSent	byte	None.
IncludeAsDebit	byte	None.
TransactionGroupID	integer	None.
ResetBalance	byte	None.
Version	byte	None.
PreviousStatus	byte	None.
PeriodStartDate	date	None.
PeriodEndDate	date	None.
CompanyID	integer	None.
TransferDeposit	byte	None.
SplitID	integer	None.
TransferOverseasTax	byte	None.
CreationMethod	byte	None.
PaymentForID	integer	None.
BankAccountBalanceExclude	byte	None.
SuspenseAccount	byte	None.
PaymentRunID	integer	None.
LinkedPropertyID	integer	None.
Exported	byte	None.
BankMatched	byte	None.
ReceivedFromContactID	integer	None.
ResetFundsHeld	byte	None.
ResetFundsHeldAmount	decimal number	None.

application/json, text/json

Sample:

{
  "id": 1,
  "type": 64,
  "status": 64,
  "addedDate": "2025-01-09T20:08",
  "dueDate": "2025-01-09T20:08",
  "statusDate": "2025-01-09T20:08",
  "bankingDate": "2025-01-09T20:08",
  "userID": 1,
  "contactID": 1,
  "propertyID": 1,
  "tenancyID": 1,
  "productID": 1,
  "taxRateID": 1,
  "taxRate": 1.0,
  "debit": 1.0,
  "credit": 1.0,
  "paymentMethodID": 1,
  "notes": "sample string 1",
  "statementID": 1,
  "invoiceID": 1,
  "receiptID": 1,
  "billID": 1,
  "companyAccount": 64,
  "bankAccountID": 1,
  "commissionFee": 1.0,
  "commissionPercentage": 1.0,
  "transferFees": 64,
  "statementNotes": "sample string 2",
  "siteID": 1,
  "linkedTo": 1,
  "linkedCascadeDelete": 64,
  "linkGroup": 1,
  "paymentCleared": 64,
  "paymentClearedDate": "2025-01-09T20:08",
  "bankReconciliationID": 1,
  "includeOnBankRec": 64,
  "paymentCollectionID": 1,
  "rentDemandSent": 64,
  "includeAsDebit": 64,
  "transactionGroupID": 1,
  "resetBalance": 64,
  "version": 64,
  "previousStatus": 64,
  "periodStartDate": "2025-01-09T20:08",
  "periodEndDate": "2025-01-09T20:08",
  "companyID": 1,
  "transferDeposit": 64,
  "splitID": 1,
  "transferOverseasTax": 64,
  "creationMethod": 64,
  "paymentForID": 1,
  "bankAccountBalanceExclude": 64,
  "suspenseAccount": 64,
  "paymentRunID": 1,
  "linkedPropertyID": 1,
  "exported": 64,
  "bankMatched": 64,
  "receivedFromContactID": 1,
  "resetFundsHeld": 64,
  "resetFundsHeldAmount": 1.0
}

application/xml, text/xml

Sample:

<TransactionsUpdate xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <ID>1</ID>
  <Type>64</Type>
  <Status>64</Status>
  <AddedDate>2025-01-09T20:08:45.8136137+00:00</AddedDate>
  <DueDate>2025-01-09T20:08:45.8136137+00:00</DueDate>
  <StatusDate>2025-01-09T20:08:45.8136137+00:00</StatusDate>
  <BankingDate>2025-01-09T20:08:45.8136137+00:00</BankingDate>
  <UserID>1</UserID>
  <ContactID>1</ContactID>
  <PropertyID>1</PropertyID>
  <TenancyID>1</TenancyID>
  <ProductID>1</ProductID>
  <TaxRateID>1</TaxRateID>
  <TaxRate>1</TaxRate>
  <Debit>1</Debit>
  <Credit>1</Credit>
  <PaymentMethodID>1</PaymentMethodID>
  <Notes>sample string 1</Notes>
  <StatementID>1</StatementID>
  <InvoiceID>1</InvoiceID>
  <ReceiptID>1</ReceiptID>
  <BillID>1</BillID>
  <CompanyAccount>64</CompanyAccount>
  <BankAccountID>1</BankAccountID>
  <CommissionFee>1</CommissionFee>
  <CommissionPercentage>1</CommissionPercentage>
  <TransferFees>64</TransferFees>
  <StatementNotes>sample string 2</StatementNotes>
  <SiteID>1</SiteID>
  <LinkedTo>1</LinkedTo>
  <LinkedCascadeDelete>64</LinkedCascadeDelete>
  <LinkGroup>1</LinkGroup>
  <PaymentCleared>64</PaymentCleared>
  <PaymentClearedDate>2025-01-09T20:08:45.8136137+00:00</PaymentClearedDate>
  <BankReconciliationID>1</BankReconciliationID>
  <IncludeOnBankRec>64</IncludeOnBankRec>
  <PaymentCollectionID>1</PaymentCollectionID>
  <RentDemandSent>64</RentDemandSent>
  <IncludeAsDebit>64</IncludeAsDebit>
  <TransactionGroupID>1</TransactionGroupID>
  <ResetBalance>64</ResetBalance>
  <Version>64</Version>
  <PreviousStatus>64</PreviousStatus>
  <PeriodStartDate>2025-01-09T20:08:45.8136137+00:00</PeriodStartDate>
  <PeriodEndDate>2025-01-09T20:08:45.8136137+00:00</PeriodEndDate>
  <CompanyID>1</CompanyID>
  <TransferDeposit>64</TransferDeposit>
  <SplitID>1</SplitID>
  <TransferOverseasTax>64</TransferOverseasTax>
  <CreationMethod>64</CreationMethod>
  <PaymentForID>1</PaymentForID>
  <BankAccountBalanceExclude>64</BankAccountBalanceExclude>
  <SuspenseAccount>64</SuspenseAccount>
  <PaymentRunID>1</PaymentRunID>
  <LinkedPropertyID>1</LinkedPropertyID>
  <Exported>64</Exported>
  <BankMatched>64</BankMatched>
  <ReceivedFromContactID>1</ReceivedFromContactID>
  <ResetFundsHeld>64</ResetFundsHeld>
  <ResetFundsHeldAmount>1</ResetFundsHeldAmount>
</TransactionsUpdate>

application/x-www-form-urlencoded
Sample: Sample not available.

Transactions

Name	Type	Additional information
ID	integer	None.
Type	byte	None.
Status	byte	None.
AddedDate	date	None.
DueDate	date	None.
StatusDate	date	None.
BankingDate	date	None.
UserID	integer	None.
ContactID	integer	None.
PropertyID	integer	None.
TenancyID	integer	None.
ProductID	integer	None.
TaxRateID	integer	None.
TaxRate	decimal number	None.
Debit	decimal number	None.
Credit	decimal number	None.
PaymentMethodID	integer	None.
Notes	string	String length: inclusive between 0 and 512
StatementID	integer	None.
InvoiceID	integer	None.
ReceiptID	integer	None.
BillID	integer	None.
CompanyAccount	byte	None.
BankAccountID	integer	None.
CommissionFee	decimal number	None.
CommissionPercentage	decimal number	None.
TransferFees	byte	None.
StatementNotes	string	String length: inclusive between 0 and 255
SiteID	integer	None.
LinkedTo	integer	None.
LinkedCascadeDelete	byte	None.
LinkGroup	integer	None.
PaymentCleared	byte	None.
PaymentClearedDate	date	None.
BankReconciliationID	integer	None.
IncludeOnBankRec	byte	None.
PaymentCollectionID	integer	None.
RentDemandSent	byte	None.
IncludeAsDebit	byte	None.
TransactionGroupID	integer	None.
ResetBalance	byte	None.
Version	byte	None.
PreviousStatus	byte	None.
PeriodStartDate	date	None.
PeriodEndDate	date	None.
CompanyID	integer	None.
TransferDeposit	byte	None.
SplitID	integer	None.
TransferOverseasTax	byte	None.
CreationMethod	byte	None.
PaymentForID	integer	None.
BankAccountBalanceExclude	byte	None.
SuspenseAccount	byte	None.
PaymentRunID	integer	None.
LinkedPropertyID	integer	None.
Exported	byte	None.
BankMatched	byte	None.
ReceivedFromContactID	integer	None.
ResetFundsHeld	byte	None.
ResetFundsHeldAmount	decimal number	None.

application/json, text/json

Sample:

{
  "id": 1,
  "type": 64,
  "status": 64,
  "addedDate": "2025-01-09T20:08",
  "dueDate": "2025-01-09T20:08",
  "statusDate": "2025-01-09T20:08",
  "bankingDate": "2025-01-09T20:08",
  "userID": 8,
  "contactID": 9,
  "propertyID": 10,
  "tenancyID": 11,
  "productID": 12,
  "taxRateID": 13,
  "taxRate": 14.0,
  "debit": 15.0,
  "credit": 16.0,
  "paymentMethodID": 17,
  "notes": "sample string 18",
  "statementID": 19,
  "invoiceID": 20,
  "receiptID": 21,
  "billID": 22,
  "companyAccount": 64,
  "bankAccountID": 24,
  "commissionFee": 25.0,
  "commissionPercentage": 26.0,
  "transferFees": 64,
  "statementNotes": "sample string 28",
  "siteID": 29,
  "linkedTo": 30,
  "linkedCascadeDelete": 64,
  "linkGroup": 32,
  "paymentCleared": 64,
  "paymentClearedDate": "2025-01-09T20:08",
  "bankReconciliationID": 35,
  "includeOnBankRec": 64,
  "paymentCollectionID": 37,
  "rentDemandSent": 64,
  "includeAsDebit": 64,
  "transactionGroupID": 40,
  "resetBalance": 64,
  "version": 64,
  "previousStatus": 64,
  "periodStartDate": "2025-01-09T20:08",
  "periodEndDate": "2025-01-09T20:08",
  "companyID": 46,
  "transferDeposit": 64,
  "splitID": 48,
  "transferOverseasTax": 64,
  "creationMethod": 64,
  "paymentForID": 51,
  "bankAccountBalanceExclude": 64,
  "suspenseAccount": 64,
  "paymentRunID": 54,
  "linkedPropertyID": 55,
  "exported": 64,
  "bankMatched": 64,
  "receivedFromContactID": 58,
  "resetFundsHeld": 64,
  "resetFundsHeldAmount": 60.0
}

application/xml, text/xml

Sample:

<Transactions xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <ID>1</ID>
  <Type>64</Type>
  <Status>64</Status>
  <AddedDate>2025-01-09T20:08:45.8292398+00:00</AddedDate>
  <DueDate>2025-01-09T20:08:45.8292398+00:00</DueDate>
  <StatusDate>2025-01-09T20:08:45.8292398+00:00</StatusDate>
  <BankingDate>2025-01-09T20:08:45.8292398+00:00</BankingDate>
  <UserID>8</UserID>
  <ContactID>9</ContactID>
  <PropertyID>10</PropertyID>
  <TenancyID>11</TenancyID>
  <ProductID>12</ProductID>
  <TaxRateID>13</TaxRateID>
  <TaxRate>14</TaxRate>
  <Debit>15</Debit>
  <Credit>16</Credit>
  <PaymentMethodID>17</PaymentMethodID>
  <Notes>sample string 18</Notes>
  <StatementID>19</StatementID>
  <InvoiceID>20</InvoiceID>
  <ReceiptID>21</ReceiptID>
  <BillID>22</BillID>
  <CompanyAccount>64</CompanyAccount>
  <BankAccountID>24</BankAccountID>
  <CommissionFee>25</CommissionFee>
  <CommissionPercentage>26</CommissionPercentage>
  <TransferFees>64</TransferFees>
  <StatementNotes>sample string 28</StatementNotes>
  <SiteID>29</SiteID>
  <LinkedTo>30</LinkedTo>
  <LinkedCascadeDelete>64</LinkedCascadeDelete>
  <LinkGroup>32</LinkGroup>
  <PaymentCleared>64</PaymentCleared>
  <PaymentClearedDate>2025-01-09T20:08:45.8292398+00:00</PaymentClearedDate>
  <BankReconciliationID>35</BankReconciliationID>
  <IncludeOnBankRec>64</IncludeOnBankRec>
  <PaymentCollectionID>37</PaymentCollectionID>
  <RentDemandSent>64</RentDemandSent>
  <IncludeAsDebit>64</IncludeAsDebit>
  <TransactionGroupID>40</TransactionGroupID>
  <ResetBalance>64</ResetBalance>
  <Version>64</Version>
  <PreviousStatus>64</PreviousStatus>
  <PeriodStartDate>2025-01-09T20:08:45.8292398+00:00</PeriodStartDate>
  <PeriodEndDate>2025-01-09T20:08:45.8292398+00:00</PeriodEndDate>
  <CompanyID>46</CompanyID>
  <TransferDeposit>64</TransferDeposit>
  <SplitID>48</SplitID>
  <TransferOverseasTax>64</TransferOverseasTax>
  <CreationMethod>64</CreationMethod>
  <PaymentForID>51</PaymentForID>
  <BankAccountBalanceExclude>64</BankAccountBalanceExclude>
  <SuspenseAccount>64</SuspenseAccount>
  <PaymentRunID>54</PaymentRunID>
  <LinkedPropertyID>55</LinkedPropertyID>
  <Exported>64</Exported>
  <BankMatched>64</BankMatched>
  <ReceivedFromContactID>58</ReceivedFromContactID>
  <ResetFundsHeld>64</ResetFundsHeld>
  <ResetFundsHeldAmount>60</ResetFundsHeldAmount>
</Transactions>

POST 17.0/database/transactions

Description

Request Information

URI Parameters

Body Parameters

Request Formats

application/json, text/json

application/xml, text/xml

application/x-www-form-urlencoded

Response Information

Resource Description

Response Formats

application/json, text/json

application/xml, text/xml