uniconta (deprecated) data model
Debtor Client
View 46 columns
CityString
NameString
GroupString
RowIdInteger
SWIFTString
AccountString
BlockedBoolean
CountryInteger
CreatedDate-time
HasDocsBoolean
OverdueNumber
PaymentString
VatZoneString
ZipCodeString
Address1String
CurrencyString
HasNotesBoolean
UserNoteBoolean
CompanyIdInteger
CreditMaxNumber
UpdatedAtDate-time
VatNumberString
CurBalanceNumber
OverdueCurNumber
PaymentFeeNumber
PriceGroupInteger
BankAccountString
CountryNameString
LastInvoiceDate-time
CompanyStateString
InvoiceInXMLString
UserLanguageString
BalanceMethodString
CurBalanceCurNumber
PricesInclVatBoolean
EmailDocumentsBoolean
EndDiscountPctNumber
UserAttachmentBoolean
UserLangaugeIdInteger
BankAccountTypeString
LineDiscountPctNumber
MicroEnterpriseBoolean
DirectDebitActiveBoolean
EEIsNotVatDeclOrgBoolean
IsPeppolSupportedBoolean
PackagingConsumerString
G L Vat Client
View 28 columns
VatString
NameString
RateNumber
Rate2Number
RowIdInteger
ExemptNumber
MethodString
AccountString
BlockedBoolean
HasDocsBoolean
TypeBuyString
VatTypeString
HasNotesBoolean
MOSSTypeString
RateTypeString
CompanyIdInteger
TypeSalesString
UpdatedAtDate-time
ModelBoxIdInteger
UsedSalesVatBoolean
FollowAccountBoolean
OffsetAccountString
RateAfterDateNumber
FollowAccount2Boolean
Rate2AfterDateNumber
VatOperationNameString
Rate2PartOfBruttoBoolean
ShowZeroOnInvoiceBoolean
Creditor Client
View 34 columns
GroupString
RowIdInteger
AccountString
BlockedBoolean
CountryInteger
CreatedDate-time
HasDocsBoolean
OverdueNumber
PaymentString
VatZoneString
CurrencyString
HasNotesBoolean
UserNoteBoolean
CompanyIdInteger
UpdatedAtDate-time
VatNumberString
CurBalanceNumber
OverdueCurNumber
PaymentFeeNumber
CountryNameString
LastInvoiceDate-time
CompanyStateString
DeliveryTimeInteger
UserLanguageString
BalanceMethodString
CurBalanceCurNumber
PaymentMethodString
EndDiscountPctNumber
UserAttachmentBoolean
UserLangaugeIdInteger
LineDiscountPctNumber
AllowMergePaymentBoolean
EEIsNotVatDeclOrgBoolean
IsPeppolSupportedBoolean
Debtor Trans Client
View 18 columns
DateDate-time
OpenBoolean
TextString
RowIdInteger
AmountNumber
AccountString
InvoiceInteger
VoucherInteger
PostTypeString
CompanyIdInteger
InvoiceANString
IsSettledBoolean
DocumentRefInteger
IsDCInvoiceBoolean
NumberSerieString
PrimaryKeyIdInteger
JournalPostedIdInteger
ExchangeRegulatedNumber
Debtor Trans Open Client
View 48 columns
VatString
DateDate-time
NameString
OpenBoolean
PaidBoolean
TextString
DebitNumber
AmountNumber
OnHoldBoolean
AccountString
DueDateDate-time
InvoiceInteger
OverdueNumber
PaymentString
VoucherInteger
PostTypeString
SendTimeDate-time
VoucherXString
CompanyIdInteger
FeeAmountNumber
GraceDateDate-time
InvoiceANString
IsSettledBoolean
VatAmountNumber
AmountOpenNumber
HasVoucherBoolean
DocumentRefInteger
IsDCInvoiceBoolean
NumberSerieString
OrderNumberInteger
PaymentDateDate-time
CashDiscountNumber
FromCreditorBoolean
LastInterestDate-time
PaymentRefIdInteger
PrimaryKeyIdInteger
PaymentChargeNumber
PaymentStatusString
JournalPostedIdInteger
ViewInvoiceLinkString
CashDiscountDateDate-time
SendToCollectionBoolean
PartialSettlementNumber
PaymentEndToEndIdInteger
VatOfCashDiscountNumber
CollectionsLettersInteger
LastCollectionLetterDate-time
PartialPaymentAmountNumber
Debtor Invoice Client
View 63 columns
VatString
DateDate-time
NameString
OfferInteger
RowIdInteger
MarginNumber
VatPctNumber
VolumeNumber
WeightNumber
AccountString
CartonsNumber
DeletedBoolean
DueDateDate-time
FIKCodeString
PaymentString
VatPct2Number
VatPct3Number
VoucherInteger
CurrencyString
ErrorOIOBoolean
PackNoteInteger
SendTimeDate-time
VatTotalNumber
CompanyIdInteger
CostValueNumber
GraceDateDate-time
NetAmountNumber
NetWeightNumber
VatAmountNumber
VatTotal2Number
VatTotal3Number
ContactRefInteger
ErrorEmailBoolean
LineAmountNumber
SalesValueNumber
SimulationBoolean
CashPaymentBoolean
EndDiscountNumber
MarginRatioNumber
NumberSerieString
OrderNumberInteger
PaymentTextString
SendTimeOIODate-time
StockUpdateBoolean
TotalAmountNumber
VatZoneEnumInteger
VoidInvoiceInteger
WithholdingNumber
CashDiscountNumber
CostRestatedBoolean
DeliveryTimeInteger
ExchangeRateNumber
OrderCreatedDate-time
PrimaryKeyIdInteger
InvoiceNumberInteger
PricesInclVatBoolean
AmountLocalCurNumber
CreditnoteDateDate-time
EndDiscountPctNumber
IsOneTimeDebtorBoolean
JournalPostedIdInteger
SendTimeDirectDebitDate-time
DeliveryIsInvoiceAddressBoolean
Debtor Invoice Lines
View 48 columns
IdString
QtyNumber
VatString
DateDate-time
ItemString
TextString
UnitString
WeekInteger
TotalNumber
MarginNumber
VolumeNumber
WeightNumber
CartonsNumber
UnitStrString
CurrencyString
ImportedBoolean
ItemNameString
SubTotalBoolean
TotalCurNumber
CompanyIdInteger
CostPriceNumber
CostValueNumber
DCAccountString
NetAmountNumber
NetWeightNumber
PartOfBOMBoolean
CostPostedBoolean
InvoiceQtyNumber
LineNumberInteger
SalesPriceNumber
AccountNameString
GrossAmountNumber
MarginRatioNumber
NetDiscountNumber
OrderNumberInteger
StockUpdateBoolean
CostRestatedBoolean
DeliveryTimeInteger
InvoicePriceNumber
InvoiceTotalNumber
MovementTypeString
HasSeriaBatchBoolean
InvoiceNumberInteger
SalesPriceCurNumber
JournalPostedIdInteger
InvoiceNetAmountNumber
InvJournalPostedIdInteger
FormattedInvoiceQtyString
G L Account Client
View 54 columns
SumString
VatString
NameString
RowIdInteger
AccountString
BalanceNumber
BlockedBoolean
HasDocsBoolean
SumInfoString
CurrencyString
Dim1ParmInteger
Dim2ParmInteger
Dim3ParmInteger
Dim4ParmInteger
Dim5ParmInteger
HasNotesBoolean
PrevYearNumber
ThisYearNumber
UserNoteBoolean
CompanyIdInteger
DATEVAutoBoolean
PageBreakBoolean
SaveTotalInteger
UpdatedAtDate-time
CurBalanceNumber
ExternalNoString
PercentageBoolean
ReconciledDate-time
AccountTypeString
DebetCreditString
PrevBalanceNumber
CategoryParmInteger
ExternalNameString
MandatoryTaxString
HideInBalanceBoolean
PrevYearDebitNumber
SystemAccountString
ThisYearDebitNumber
PrevYearCreditNumber
ThisYearCreditNumber
UserAttachmentBoolean
AccountTypeEnumInteger
Dim1ParmDisplayString
Dim2ParmDisplayString
Dim3ParmDisplayString
Dim4ParmDisplayString
Dim5ParmDisplayString
StandardAccountString
BlockedInJournalBoolean
SaveTotalInIndexInteger
MandatoryCategoryBoolean
SystemAccountEnumInteger
CalculationExpressionString
DefaultOffsetAccountTypeString
G L Trans Client
View 22 columns
IdString
QtyNumber
VatString
DateDate-time
TextString
AmountNumber
DCTypeString
OriginString
AccountString
InvoiceInteger
VoucherInteger
AmountCurNumber
AmountVatNumber
CompanyIdInteger
DCAccountString
AmountBaseNumber
HasVoucherBoolean
DocumentRefInteger
NumberSerieString
VoucherLineInteger
DocumentDateDate-time
JournalPostedIdInteger
Project Client
View 46 columns
WIPNumber
NameString
GroupString
PhaseString
RowIdInteger
MarginNumber
NumberString
AccountString
BlockedBoolean
CreatedDate-time
EndDateDate-time
HasDocsBoolean
RevenueNumber
CurrencyString
HasNotesBoolean
UserNoteBoolean
CompanyIdInteger
CostValueNumber
OtherCostNumber
StartDateDate-time
UpdatedAtDate-time
CompletionNumber
ContactRefInteger
DebtorNameString
FixedPriceNumber
LabourCostNumber
OtherSalesNumber
SalesPriceNumber
SalesValueNumber
InvoiceAbleBoolean
LabourSalesNumber
MarginRatioNumber
ExpensesCostNumber
ExpensesSalesNumber
MaterialsCostNumber
AdjustmentCostNumber
EndDiscountPctNumber
MaterialsSalesNumber
OnAccountSalesNumber
UserAttachmentBoolean
AdjustmentSalesNumber
InvoicingMethodString
ExternalWorkCostNumber
ExternalWorkSalesNumber
MiscellaneousCostNumber
MiscellaneousSalesNumber
Inv Item Client
View 63 columns
QtyNumber
URLInteger
ItemString
NameString
UnitString
GroupString
PhotoInteger
RowIdInteger
HasEPRBoolean
UNSPSCInteger
VolumeNumber
WeightNumber
BlockedBoolean
CartonsNumber
HasDocsBoolean
HasNotesBoolean
ItemTypeString
SalesQtyNumber
UserNoteBoolean
AvailableNumber
CompanyIdInteger
CostModelString
CostPriceNumber
CostValueNumber
Currency1String
Currency2String
Currency3String
IntraUnitInteger
NetWeightNumber
SalesUnitString
UpdatedAtDate-time
QtyOnStockNumber
QtyOrderedNumber
UseStorageBoolean
AverageCostNumber
HideInSalesBoolean
PurchaseMinNumber
PurchaseQtyNumber
QtyReservedNumber
SalesPrice1Number
SalesPrice2Number
SalesPrice3Number
UseVariantsBoolean
DeliveryTimeInteger
LastMovementDate-time
PurchaseUnitString
MaxStockLevelNumber
MinStockLevelNumber
PurchasePriceNumber
SerialOrBatchString
BOMCostOfLinesBoolean
HideInPurchaseBoolean
UseAlternativeString
UserAttachmentBoolean
MandatoryVariantBoolean
PurchaseCurrencyString
IncludeInDiscountBoolean
InvoiceAttachmentInteger
ItemIncludedInBOMBoolean
MandatorySerialBatchBoolean
ProducerResponsibilityBoolean
AvailableForReservationNumber
MandatorySerialBatchMarkingBoolean
Bank Statement
Bank Statement Lines
Creditor Trans Client
Creditor Trans Open Client
Debtor Order Client
Debtor Order Line Client
Built with enterprise-grade security and compliance.
One platform instead of a data stack
ELT, a built-in warehouse, transformations, reverse ETL and an MCP endpoint in one governed place.
- 14-day free trial
- No credit card needed