power office data model
Product
View 14 columns
IdInteger
CodeString
NameString
TypeInteger
UnitString
VatCodeString
IsActiveBoolean
CostPriceNumber
SalesPriceNumber
LastChangedDate-time
SalesAccountInteger
ProductGroupIdInteger
UnitOfMeasureCodeInteger
VatExemptSalesAccountInteger
Productgroup
View 10 columns
IdInteger
CodeString
NameString
TypeInteger
UnitString
CostPriceNumber
SalesPriceNumber
LastChangedDate-time
SalesAccountInteger
VatExemptSalesAccountInteger
Customer
View 41 columns
IdInteger
CodeInteger
NameString
SinceDate-time
IsActiveBoolean
IsPersonBoolean
IsVatFreeBoolean
LegalNameString
VatNumberString
IsArchivedBoolean
WebsiteUrlString
CreatedDateDate-time
LastChangedDate-time
PhoneNumberString
EmailAddressString
ExternalCodeInteger
UseFactoringBoolean
SendRemindersBoolean
UseInvoiceFeeBoolean
MailAddress_idInteger
ContactPersonIdInteger
MailAddress_cityString
StreetAddress_cityString
CustomerCreatedDateDate-time
InvoiceDeliveryTypeInteger
InvoiceEmailAddressString
MailAddress_zipCodeString
MailAddress_address1String
ReminderEmailAddressString
InvoiceEmailAddressCCString
MailAddress_isPrimaryBoolean
StreetAddress_zipCodeString
StreetAddress_address1String
DoNotAddLatePaymentFeesBoolean
MailAddress_countryCodeString
MailAddress_lastChangedDate-time
StreetAddress_isPrimaryBoolean
StreetAddress_countryCodeString
StreetAddress_lastChangedDate-time
DoNotAddLatePaymentInterestBoolean
TransferToDebtCollectionAgencyBoolean
Department
View 5 columns
IdInteger
CodeString
NameString
IsActiveBoolean
LastChangedDate-time
Employee
View 29 columns
IdInteger
CodeInteger
GenderInteger
LastNameString
FirstNameString
IsArchivedBoolean
CreatedDateDate-time
DateOfBirthDate-time
LastChangedDate-time
PhoneNumberString
EmailAddressString
MailAddress_idInteger
MailAddress_cityString
StreetAddress_cityString
EmployeeCreatedDateDate-time
InternationalIdTypeInteger
MailAddress_zipCodeString
PayrollEmailAddressString
MailAddress_address1String
SocialSecurityNumberString
MailAddress_isPrimaryBoolean
ReportInternationalIdBoolean
StreetAddress_zipCodeString
StreetAddress_address1String
MailAddress_countryCodeString
MailAddress_lastChangedDate-time
StreetAddress_isPrimaryBoolean
StreetAddress_countryCodeString
StreetAddress_lastChangedDate-time
Project
View 20 columns
IdInteger
CodeString
NameString
StatusInteger
ProgressInteger
FixedPriceNumber
IsBillableBoolean
IsInternalBoolean
CreatedDateDate-time
LastChangedDate-time
CustomerCodeInteger
BillingMethodInteger
ContactPersonIdInteger
PurchaseOrderNoString
AllowAllEmployeesBoolean
AllowAllActivitiesBoolean
MarkupHourlyRateEnabledBoolean
MarkupOtherExpensesEnabledBoolean
BillingHourlyRateSpecificationInteger
AttachExpenseVouchersWhenBillingBoolean
Projectactivity
View 5 columns
IdInteger
NameString
IsBillableBoolean
ProjectCodeString
ActivityCodeString
Generalledgeraccount
View 10 columns
IdInteger
CodeInteger
NameString
VatCodeString
IsActiveBoolean
LastChangedDate-time
IsProjectRequiredBoolean
IsDepartmentRequiredBoolean
VatReturnSpecificationInteger
IsVatCodeLockedAfterPostingBoolean
Supplier
View 39 columns
IdInteger
CodeInteger
NameString
SinceDate-time
IsActiveBoolean
IsPersonBoolean
LegalNameString
VatNumberString
IsArchivedBoolean
WebsiteUrlString
CreatedDateDate-time
LastChangedDate-time
PhoneNumberString
CurrencyCodeString
EmailAddressString
ExternalCodeInteger
MailAddress_idInteger
ContactPersonIdInteger
MailAddress_cityString
StreetAddress_idInteger
StreetAddress_cityString
MailAddress_zipCodeString
SupplierCreatedDateDate-time
MailAddress_address1String
StreetAddresses_0_idInteger
MailAddress_isPrimaryBoolean
StreetAddress_zipCodeString
StreetAddress_address1String
StreetAddresses_0_cityString
MailAddress_countryCodeString
MailAddress_lastChangedDate-time
StreetAddress_isPrimaryBoolean
StreetAddress_countryCodeString
StreetAddress_lastChangedDate-time
StreetAddresses_0_zipCodeString
StreetAddresses_0_address1String
StreetAddresses_0_isPrimaryBoolean
StreetAddresses_0_countryCodeString
StreetAddresses_0_lastChangedDate-time
Vatcode
View 11 columns
IdInteger
CodeString
NameString
RateNumber
ValidtoDate-time
IsActiveBoolean
IsCustomBoolean
ValidFromDate-time
DescriptionString
VatBasisRatioNumber
IsVatCompensationCodeBoolean
Outgoinginvoice
View 34 columns
IdString
CidString
StatusInteger
BalanceNumber
DueDateDate-time
OrderNoInteger
SentDateDate-time
InvoiceNoInteger
NetAmountNumber
OrderDateDate-time
VoucherNoInteger
DocumentNoString
CreatedDateDate-time
LastChangedDate-time
TotalAmountNumber
VoucherDateDate-time
CurrencyCodeString
CustomerCodeInteger
PaymentTermsInteger
CustomerEmailString
PurchaseOrderNoString
DeliveryAddress1String
BrandingThemeCodeString
CustomerReferenceString
DeliveryAddressIdInteger
DeliveryAddressCityString
InvoiceDeliveryDateDate-time
InvoiceDeliveryTypeInteger
CurrencyExchangeRateNumber
DeliveryAddressZipCodeString
IsInvoiceBeingProcessedBoolean
OurReferenceEmployeeCodeInteger
DeliveryAddressCountryCodeString
InvoiceDebtCollectionStatusInteger
Recurringinvoice
View 21 columns
IdString
StatusInteger
IsActiveBoolean
NetAmountNumber
OrderDateDate-time
SendMethodInteger
CreatedDateDate-time
LastChangedDate-time
TotalAmountNumber
CurrencyCodeString
CustomerCodeInteger
CustomerEmailString
DaysInAdvanceInteger
SendFrequencyInteger
NextInvoiceDateDate-time
BrandingThemeCodeString
SendFrequencyUnitInteger
AutoClearExclusionsBoolean
InvoiceDeliveryTypeInteger
IsInvoiceBeingProcessedBoolean
OurReferenceEmployeeCodeInteger
Invoicejournal
View 26 columns
IdString
CidString
TextString
BalanceNumber
DueDateDate-time
CurrencyString
InvoiceNoInteger
NetAmountNumber
VatAmountNumber
VoucherNoInteger
Customer_idInteger
LastChangedDate-time
TotalAmountNumber
VoucherDateDate-time
VoucherTypeInteger
CurrencyRateNumber
Customer_codeInteger
Customer_nameString
InvoiceStatusInteger
Customer_createdDateDate-time
Customer_lastChangedDate-time
HasVoucherDocumentationBoolean
InvoiceJournalSalesLinesString
CreatedFromImportJournalIdString
InvoiceDebtCollectionStatusInteger
Customer_customerCreatedDateDate-time
Invoicejournalsaleslines
View 18 columns
IdInteger
UnitString
QuantityNumber
TotalVatNumber
UnitPriceNumber
VoucherNoInteger
Product_idInteger
DescriptionString
LastChangedDate-time
Product_codeString
Product_nameString
Product_typeInteger
TotalExclusiveNumber
TotalInclusiveNumber
DiscountPercentNumber
VoucherLineTypeInteger
InvoicejournalIdString
Product_lastChangedDate-time
Accounttransactions
View 36 columns
IdInteger
DateDate-time
TextString
AmountNumber
VatCodeString
VatRateNumber
QuantityNumber
VatAmountNumber
VoucherIdString
VoucherNoInteger
DocumentNoString
IsReversedBoolean
VoucherCIDString
AccountCodeInteger
CreatedDateDate-time
DescriptionString
LastChangedDate-time
ProductCodeString
ProjectCodeString
VoucherDateDate-time
VoucherTypeInteger
CurrencyCodeString
CurrencyAmountNumber
DepartmentCodeString
VoucherDueDateDate-time
IsNoteMainEntryBoolean
IsCreatedFromEhfBoolean
SubLedgerEntryIdInteger
CustomerAccountNoInteger
ImportedVoucherNoInteger
SupplierAccountNoInteger
VoucherImagesCountInteger
VatReturnSpecificationInteger
HasVoucherDocumentationBoolean
OurReferenceEmployeeCodeInteger
CreatedFromImportJournalIdString
Customerledger
View 29 columns
IdInteger
CidString
AmountNumber
BalanceNumber
DueDateDate-time
MatchIdInteger
VoucherIdString
VoucherNoInteger
DocumentNoString
IsWriteOffBoolean
CreatedDateDate-time
Customer_idInteger
LastChangedDate-time
PostingDateDate-time
VoucherDateDate-time
VoucherTypeInteger
CurrencyCodeString
CustomerCodeInteger
Customer_codeInteger
Customer_nameString
CurrencyAmountNumber
Customer_createdDateDate-time
Customer_lastChangedDate-time
FactoringInvoiceStatusInteger
HasVoucherDocumentationBoolean
CreatedFromImportJournalIdString
InvoiceDebtCollectionStatusInteger
Customer_customerCreatedDateDate-time
IsCreatedByCurrentIntegrationBoolean
Supplierledger
View 29 columns
IdInteger
CidString
AmountNumber
BalanceNumber
DueDateDate-time
MatchIdInteger
VoucherIdString
VoucherNoInteger
DocumentNoString
IsWriteOffBoolean
CreatedDateDate-time
LastChangedDate-time
PostingDateDate-time
Supplier_idInteger
VoucherDateDate-time
VoucherTypeInteger
CurrencyCodeString
SupplierCodeInteger
Supplier_codeInteger
Supplier_nameString
CurrencyAmountNumber
IsCreatedFromEhfBoolean
Supplier_createdDateDate-time
Supplier_lastChangedDate-time
FactoringInvoiceStatusInteger
CreatedFromImportJournalIdString
InvoiceDebtCollectionStatusInteger
Supplier_supplierCreatedDateDate-time
IsCreatedByCurrentIntegrationBoolean
Voucher Type
View 3 columns
NameString
TypeNumber
DescriptionString
Vat Code
View 3 columns
NameString
TypeString
DescriptionString
Custom Dimension Value
View 3 columns
NameString
TypeString
DescriptionString
Activity
Budget
Client
Hour Type
Supplierledger Not Matched
Time Transactions
Time Tracking Entry
Trialbalance
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