Table Debtor Client

City: String
Name: String
Group: String
RowId: Integer
SWIFT: String
Account: String
Blocked: Boolean
Country: Integer
Created: Date-time
HasDocs: Boolean
Overdue: Number
Payment: String
VatZone: String
ZipCode: String
Address1: String
Currency: String
HasNotes: Boolean
UserNote: Boolean
CompanyId: Integer
CreditMax: Number
UpdatedAt: Date-time
VatNumber: String
CurBalance: Number
OverdueCur: Number
PaymentFee: Number
PriceGroup: Integer
BankAccount: String
CountryName: String
LastInvoice: Date-time
CompanyState: String
InvoiceInXML: String
UserLanguage: String
BalanceMethod: String
CurBalanceCur: Number
PricesInclVat: Boolean
EmailDocuments: Boolean
EndDiscountPct: Number
UserAttachment: Boolean
UserLangaugeId: Integer
BankAccountType: String
LineDiscountPct: Number
MicroEnterprise: Boolean
DirectDebitActive: Boolean
EEIsNotVatDeclOrg: Boolean
IsPeppolSupported: Boolean
PackagingConsumer: String

Table G L Vat Client

Vat: String
Name: String
Rate: Number
Rate2: Number
RowId: Integer
Exempt: Number
Method: String
Account: String
Blocked: Boolean
HasDocs: Boolean
TypeBuy: String
VatType: String
HasNotes: Boolean
MOSSType: String
RateType: String
CompanyId: Integer
TypeSales: String
UpdatedAt: Date-time
ModelBoxId: Integer
UsedSalesVat: Boolean
FollowAccount: Boolean
OffsetAccount: String
RateAfterDate: Number
FollowAccount2: Boolean
Rate2AfterDate: Number
VatOperationName: String
Rate2PartOfBrutto: Boolean
ShowZeroOnInvoice: Boolean

Table Creditor Client

Group: String
RowId: Integer
Account: String
Blocked: Boolean
Country: Integer
Created: Date-time
HasDocs: Boolean
Overdue: Number
Payment: String
VatZone: String
Currency: String
HasNotes: Boolean
UserNote: Boolean
CompanyId: Integer
UpdatedAt: Date-time
VatNumber: String
CurBalance: Number
OverdueCur: Number
PaymentFee: Number
CountryName: String
LastInvoice: Date-time
CompanyState: String
DeliveryTime: Integer
UserLanguage: String
BalanceMethod: String
CurBalanceCur: Number
PaymentMethod: String
EndDiscountPct: Number
UserAttachment: Boolean
UserLangaugeId: Integer
LineDiscountPct: Number
AllowMergePayment: Boolean
EEIsNotVatDeclOrg: Boolean
IsPeppolSupported: Boolean

Table Debtor Trans Client

Date: Date-time
Open: Boolean
Text: String
RowId: Integer
Amount: Number
Account: String
Invoice: Integer
Voucher: Integer
PostType: String
CompanyId: Integer
InvoiceAN: String
IsSettled: Boolean
DocumentRef: Integer
IsDCInvoice: Boolean
NumberSerie: String
PrimaryKeyId: Integer
JournalPostedId: Integer
ExchangeRegulated: Number

Table Debtor Trans Open Client

Vat: String
Date: Date-time
Name: String
Open: Boolean
Paid: Boolean
Text: String
Debit: Number
Amount: Number
OnHold: Boolean
Account: String
DueDate: Date-time
Invoice: Integer
Overdue: Number
Payment: String
Voucher: Integer
PostType: String
SendTime: Date-time
VoucherX: String
CompanyId: Integer
FeeAmount: Number
GraceDate: Date-time
InvoiceAN: String
IsSettled: Boolean
VatAmount: Number
AmountOpen: Number
HasVoucher: Boolean
DocumentRef: Integer
IsDCInvoice: Boolean
NumberSerie: String
OrderNumber: Integer
PaymentDate: Date-time
CashDiscount: Number
FromCreditor: Boolean
LastInterest: Date-time
PaymentRefId: Integer
PrimaryKeyId: Integer
PaymentCharge: Number
PaymentStatus: String
JournalPostedId: Integer
ViewInvoiceLink: String
CashDiscountDate: Date-time
SendToCollection: Boolean
PartialSettlement: Number
PaymentEndToEndId: Integer
VatOfCashDiscount: Number
CollectionsLetters: Integer
LastCollectionLetter: Date-time
PartialPaymentAmount: Number

Table Debtor Invoice Client

Vat: String
Date: Date-time
Name: String
Offer: Integer
RowId: Integer
Margin: Number
VatPct: Number
Volume: Number
Weight: Number
Account: String
Cartons: Number
Deleted: Boolean
DueDate: Date-time
FIKCode: String
Payment: String
VatPct2: Number
VatPct3: Number
Voucher: Integer
Currency: String
ErrorOIO: Boolean
PackNote: Integer
SendTime: Date-time
VatTotal: Number
CompanyId: Integer
CostValue: Number
GraceDate: Date-time
NetAmount: Number
NetWeight: Number
VatAmount: Number
VatTotal2: Number
VatTotal3: Number
ContactRef: Integer
ErrorEmail: Boolean
LineAmount: Number
SalesValue: Number
Simulation: Boolean
CashPayment: Boolean
EndDiscount: Number
MarginRatio: Number
NumberSerie: String
OrderNumber: Integer
PaymentText: String
SendTimeOIO: Date-time
StockUpdate: Boolean
TotalAmount: Number
VatZoneEnum: Integer
VoidInvoice: Integer
Withholding: Number
CashDiscount: Number
CostRestated: Boolean
DeliveryTime: Integer
ExchangeRate: Number
OrderCreated: Date-time
PrimaryKeyId: Integer
InvoiceNumber: Integer
PricesInclVat: Boolean
AmountLocalCur: Number
CreditnoteDate: Date-time
EndDiscountPct: Number
IsOneTimeDebtor: Boolean
JournalPostedId: Integer
SendTimeDirectDebit: Date-time
DeliveryIsInvoiceAddress: Boolean

Table Debtor Invoice Lines

Id: String
Qty: Number
Vat: String
Date: Date-time
Item: String
Text: String
Unit: String
Week: Integer
Total: Number
Margin: Number
Volume: Number
Weight: Number
Cartons: Number
UnitStr: String
Currency: String
Imported: Boolean
ItemName: String
SubTotal: Boolean
TotalCur: Number
CompanyId: Integer
CostPrice: Number
CostValue: Number
DCAccount: String
NetAmount: Number
NetWeight: Number
PartOfBOM: Boolean
CostPosted: Boolean
InvoiceQty: Number
LineNumber: Integer
SalesPrice: Number
AccountName: String
GrossAmount: Number
MarginRatio: Number
NetDiscount: Number
OrderNumber: Integer
StockUpdate: Boolean
CostRestated: Boolean
DeliveryTime: Integer
InvoicePrice: Number
InvoiceTotal: Number
MovementType: String
HasSeriaBatch: Boolean
InvoiceNumber: Integer
SalesPriceCur: Number
JournalPostedId: Integer
InvoiceNetAmount: Number
InvJournalPostedId: Integer
FormattedInvoiceQty: String

Table G L Account Client

Sum: String
Vat: String
Name: String
RowId: Integer
Account: String
Balance: Number
Blocked: Boolean
HasDocs: Boolean
SumInfo: String
Currency: String
Dim1Parm: Integer
Dim2Parm: Integer
Dim3Parm: Integer
Dim4Parm: Integer
Dim5Parm: Integer
HasNotes: Boolean
PrevYear: Number
ThisYear: Number
UserNote: Boolean
CompanyId: Integer
DATEVAuto: Boolean
PageBreak: Boolean
SaveTotal: Integer
UpdatedAt: Date-time
CurBalance: Number
ExternalNo: String
Percentage: Boolean
Reconciled: Date-time
AccountType: String
DebetCredit: String
PrevBalance: Number
CategoryParm: Integer
ExternalName: String
MandatoryTax: String
HideInBalance: Boolean
PrevYearDebit: Number
SystemAccount: String
ThisYearDebit: Number
PrevYearCredit: Number
ThisYearCredit: Number
UserAttachment: Boolean
AccountTypeEnum: Integer
Dim1ParmDisplay: String
Dim2ParmDisplay: String
Dim3ParmDisplay: String
Dim4ParmDisplay: String
Dim5ParmDisplay: String
StandardAccount: String
BlockedInJournal: Boolean
SaveTotalInIndex: Integer
MandatoryCategory: Boolean
SystemAccountEnum: Integer
CalculationExpression: String
DefaultOffsetAccountType: String

Table G L Trans Client

Id: String
Qty: Number
Vat: String
Date: Date-time
Text: String
Amount: Number
DCType: String
Origin: String
Account: String
Invoice: Integer
Voucher: Integer
AmountCur: Number
AmountVat: Number
CompanyId: Integer
DCAccount: String
AmountBase: Number
HasVoucher: Boolean
DocumentRef: Integer
NumberSerie: String
VoucherLine: Integer
DocumentDate: Date-time
JournalPostedId: Integer

Table Project Client

WIP: Number
Name: String
Group: String
Phase: String
RowId: Integer
Margin: Number
Number: String
Account: String
Blocked: Boolean
Created: Date-time
EndDate: Date-time
HasDocs: Boolean
Revenue: Number
Currency: String
HasNotes: Boolean
UserNote: Boolean
CompanyId: Integer
CostValue: Number
OtherCost: Number
StartDate: Date-time
UpdatedAt: Date-time
Completion: Number
ContactRef: Integer
DebtorName: String
FixedPrice: Number
LabourCost: Number
OtherSales: Number
SalesPrice: Number
SalesValue: Number
InvoiceAble: Boolean
LabourSales: Number
MarginRatio: Number
ExpensesCost: Number
ExpensesSales: Number
MaterialsCost: Number
AdjustmentCost: Number
EndDiscountPct: Number
MaterialsSales: Number
OnAccountSales: Number
UserAttachment: Boolean
AdjustmentSales: Number
InvoicingMethod: String
ExternalWorkCost: Number
ExternalWorkSales: Number
MiscellaneousCost: Number
MiscellaneousSales: Number

Table Inv Item Client

Qty: Number
URL: Integer
Item: String
Name: String
Unit: String
Group: String
Photo: Integer
RowId: Integer
HasEPR: Boolean
UNSPSC: Integer
Volume: Number
Weight: Number
Blocked: Boolean
Cartons: Number
HasDocs: Boolean
HasNotes: Boolean
ItemType: String
SalesQty: Number
UserNote: Boolean
Available: Number
CompanyId: Integer
CostModel: String
CostPrice: Number
CostValue: Number
Currency1: String
Currency2: String
Currency3: String
IntraUnit: Integer
NetWeight: Number
SalesUnit: String
UpdatedAt: Date-time
QtyOnStock: Number
QtyOrdered: Number
UseStorage: Boolean
AverageCost: Number
HideInSales: Boolean
PurchaseMin: Number
PurchaseQty: Number
QtyReserved: Number
SalesPrice1: Number
SalesPrice2: Number
SalesPrice3: Number
UseVariants: Boolean
DeliveryTime: Integer
LastMovement: Date-time
PurchaseUnit: String
MaxStockLevel: Number
MinStockLevel: Number
PurchasePrice: Number
SerialOrBatch: String
BOMCostOfLines: Boolean
HideInPurchase: Boolean
UseAlternative: String
UserAttachment: Boolean
MandatoryVariant: Boolean
PurchaseCurrency: String
IncludeInDiscount: Boolean
InvoiceAttachment: Integer
ItemIncludedInBOM: Boolean
MandatorySerialBatch: Boolean
ProducerResponsibility: Boolean
AvailableForReservation: Number
MandatorySerialBatchMarking: Boolean

Table Creditor Trans Client

Table Creditor Trans Open Client

Table Debtor Order Client

Table Debtor Order Line Client

Table Bank Statement

Table Bank Statement Lines