Sql tables

Tables created on SQL for data transfer from Poweroffice:

Transactions
CustomerLedger
SupplierLedger
Departments
Projects
VatCodes
Suppliers
Customers
ChartOfAccounts
Employees
ProjectStatus

Fields created per Table

Table name in SQL Name field in PowerOfice and SQL same Upload or not Type field in PowerOffice Type field in SQL Size field In SQL
CustomerLedger clientID 1 number int
CustomerLedger importedOrderNo 1 number int
CustomerLedger customerCode 1 number int
CustomerLedger hasVoucherDocumentation 1 boolean bit
CustomerLedger isWriteOff 1 boolean bit
CustomerLedger paidFromBankAccount 1 string varchar
CustomerLedger id 1 number int
CustomerLedger postingDate 1 Date datetime
CustomerLedger dueDate 1 Date datetime
CustomerLedger voucherNo 1 number int
CustomerLedger currencyCode 1 string varchar 50
CustomerLedger currencyAmount 1 number money
CustomerLedger amount 1 number money
CustomerLedger balance 1 number money
CustomerLedger voucherId 1 string (Guid) varchar 50
CustomerLedger voucherDate 1 Date datetime
CustomerLedger voucherType 1 VoucherType varchar 250
CustomerLedger documentNo 1 string varchar
CustomerLedger matchId 1 number int
CustomerLedger cID 1 string varchar
CustomerLedger lastChanged 1 Date datetime
CustomerLedger createdDate 1 Date datetime
CustomerLedger createdFromImportJournalId 1 string (Guid) varchar
CustomerLedger externalImportReference 1 string varchar
CustomerLedger customMatchingReference 1 string varchar
CustomerLedger isCreatedByCurrentIntegration 1 boolean bit
CustomerLedger factoringInvoiceStatus 1 number int
CustomerLedger factoringIntegrationName 1 string varchar
CustomerLedger invoiceDebtCollectionStatus 1 number int
CustomerLedger debtCollectionCaseCode 1 string varchar
CustomerLedger debtCollectionCaseId 1 string (Guid) varchar
CustomerLedger projectCode 1 string varchar
CustomerLedger projectName 1 string varchar
CustomerLedger departmentCode 1 string varchar
CustomerLedger departmentName 1 string varchar
CustomerLedger dim1Code 1 string varchar
CustomerLedger dim1Name 1 string varchar
CustomerLedger dim2Code 1 string varchar
CustomerLedger dim2Name 1 string varchar
CustomerLedger dim3Code 1 string varchar
CustomerLedger dim3Name 1 string varchar
SupplierLedger clientID 1 number int
SupplierLedger isCreatedFromEhf 1 boolean bit
SupplierLedger supplierCode 1 number int
SupplierLedger isWriteOff 1 boolean bit
SupplierLedger id 1 number int
SupplierLedger postingDate 1 Date datetime
SupplierLedger dueDate 1 Date datetime
SupplierLedger voucherNo 1 number int
SupplierLedger currencyCode 1 string varchar 50
SupplierLedger currencyAmount 1 number money
SupplierLedger amount 1 number money
SupplierLedger balance 1 number money
SupplierLedger voucherId 1 string (Guid) varchar 50
SupplierLedger voucherDate 1 Date datetime
SupplierLedger voucherType 1 VoucherType varchar 250
SupplierLedger documentNo 1 string varchar
SupplierLedger matchId 1 number int
SupplierLedger cID 1 string varchar
SupplierLedger lastChanged 1 Date datetime
SupplierLedger createdDate 1 Date datetime
SupplierLedger createdFromImportJournalId 1 string (Guid) varchar
SupplierLedger externalImportReference 1 string varchar
SupplierLedger customMatchingReference 1 string varchar
SupplierLedger isCreatedByCurrentIntegration 1 boolean bit
SupplierLedger factoringInvoiceStatus 1 number int
SupplierLedger factoringIntegrationName 1 string varchar
SupplierLedger invoiceDebtCollectionStatus 1 number int
SupplierLedger debtCollectionCaseCode 1 string varchar
SupplierLedger debtCollectionCaseId 1 string (Guid) varchar
SupplierLedger projectCode 1 string varchar
SupplierLedger projectName 1 string varchar
SupplierLedger departmentCode 1 string varchar
SupplierLedger departmentName 1 string varchar
SupplierLedger dim1Code 1 string varchar
SupplierLedger dim1Name 1 string varchar
SupplierLedger dim2Code 1 string varchar
SupplierLedger dim2Name 1 string varchar
SupplierLedger dim3Code 1 string varchar
SupplierLedger dim3Name 1 string varchar
Departments clientID 1 number int
Departments id 1 number int
Departments name 1 string varchar 250
Departments code 1 string varchar 50
Departments managerCode 1 number int
Departments isActive 1 boolean bit
Departments lastChanged 1 Date datetime
Departments createdFromImportJournalId 1 string (Guid) varchar
Projects clientID 1 number int
Projects id 1 number int
Projects customerCode 1 number int
Projects code 1 string varchar 50
Projects name 1 string varchar 250
Projects isBillable 1 boolean bit
Projects status 1 ProjectStatus varchar 250
Projects startDate 1 Date datetime
Projects endDate 1 Date datetime
Projects projectManagerCode 1 number int
Projects parentProjectCode 1 string varchar 50
Projects externalCode 1 number int
Projects departmentCode 1 string varchar 50
Projects locationCode 1 string varchar
Projects allowAllActivities 1 boolean bit
Projects allowAllEmployees 1 boolean bit
Projects lastChanged 1 Date datetime
Projects createdFromImportJournalId 1 string (Guid) varchar
Projects brandingThemeCode 1 string varchar
Projects contractNo 1 string varchar
Projects isInternal 1 boolean bit
Projects progress 1 number int
Projects budgetedHours 1 number int
Projects budgetedHourlyRate 1 number money
Projects budgetedExpenseHours 1 number money
Projects budgetedRevenueHours 1 number money
Projects budgetedOtherExpenses 1 number money
Projects budgetedTotalRevenue 1 number money
Projects budgetedCostOfGoods 1 number money
Projects purchaseOrderNo 1 string varchar
Projects paymentTerms 1 number int
Projects attachExpenseVouchersWhenBilling 1 boolean bit
Projects markupHourlyRateEnabled 1 boolean bit
Projects hourlyRateFactorWithMarkup 1 number money
Projects hourlyRateMarkupDescription 1 string varchar
Projects markupOtherExpensesEnabled 1 boolean bit
Projects otherExpensesFactorWithMarkup 1 number money
Projects otherExpensesMarkupDescription 1 string varchar
Projects deliveryTerms 1 string varchar
Projects billingMethod 0 ProjectBillingMethod varchar
Projects billingHourlyRateSpecification 0 HourlyRateSpecification varchar
Projects fixedPrice 1 number money
Projects billableRate 1 number money
Projects contactPersonId 1 number int
VatCodes clientID 1 number int
VatCodes id 1 number int
VatCodes code 1 string varchar 50
VatCodes name 1 string varchar 50
VatCodes description 1 string varchar 250
VatCodes rate 1 number money
VatCodes isActive 1 boolean bit
VatCodes validFrom 1 Date datetime
VatCodes validto 1 Date datetime
VatCodes isCustom 1 boolean bit
VatCodes vatBasisRatio 1 number money
Suppliers clientID 1 number int
Suppliers standardGeneralLedgerAccountCode 1 number int
Suppliers supplierCreatedDate 1 Date datetime
Suppliers name 1 string varchar 250
Suppliers legalName 1 string varchar
Suppliers contactPersonId 1 number int
Suppliers vatNumber 1 string varchar 50
Suppliers websiteUrl 1 string varchar
Suppliers since 1 Date datetime
Suppliers isPerson 1 boolean bit
Suppliers currencyCode 1 string varchar 3
Suppliers isActive 1 boolean bit
Suppliers id 1 number int
Suppliers code 1 number int
Suppliers externalCode 1 number int
Suppliers emailAddress 1 string varchar
Suppliers phoneNumber 1 string varchar
Suppliers isArchived 1 boolean bit
Suppliers lastChanged 1 Date datetime
Suppliers createdDate 1 Date datetime
Suppliers contactGroups 1 string varchar
Suppliers createdFromImportJournalId 1 string (Guid) varchar
Suppliers firstName 1 string varchar
Suppliers lastName 1 string varchar
Suppliers dateOfBirth 1 Date datetime
Suppliers socialSecurityNumber 1 string varchar
Suppliers subledgerNumberSeriesId 1 string (Guid) varchar
Suppliers reportInternationalId 1 boolean bit
Suppliers internationalIdCountryCode 1 string varchar
Suppliers internationalIdType 1 InternationalIdType varchar 250
Suppliers internationalIdNumber 1 string varchar
Suppliers externalImportReference 1 string varchar
Customers clientID 1 number int
Customers invoiceDeliveryType 1 InvoiceDeliveryType varchar 250
Customers isVatFree 1 boolean bit
Customers discountPercent 1 number float
Customers invoiceEmailAddress 1 string varchar
Customers invoiceEmailAddressCC 1 string varchar
Customers hourlyRate 1 number money
Customers invoiceBrandingThemeCode 1 string varchar
Customers paymentTerms 1 number int
Customers useFactoring 1 boolean bit
Customers departmentCode 1 string varchar
Customers sendReminders 1 boolean bit
Customers doNotAddLatePaymentFees 1 boolean bit
Customers doNotAddLatePaymentInterest 1 boolean bit
Customers reminderDeliveryType 1 InvoiceDeliveryType varchar 250
Customers noticeOfDebtCollectionDeliveryType 1 InvoiceDeliveryType varchar 250
Customers reminderEmailAddress 1 string varchar
Customers ourReferenceEmployeeCode 1 number int
Customers deliveryTerm 1 string varchar
Customers transferToDebtCollectionAgency 1 boolean bit
Customers customerCreatedDate 1 Date datetime
Customers useInvoiceFee 1 boolean bit
Customers name 1 string varchar 250
Customers legalName 1 string varchar
Customers contactPersonId 1 number int
Customers vatNumber 1 string varchar 50
Customers websiteUrl 1 string varchar
Customers since 1 Date datetime
Customers isPerson 1 boolean bit
Customers currencyCode 1 string varchar 3
Customers isActive 1 boolean bit
Customers id 1 number int
Customers code 1 number int
Customers externalCode 1 number int
Customers emailAddress 1 string varchar
Customers phoneNumber 1 string varchar
Customers isArchived 1 boolean bit
Customers lastChanged 1 Date datetime
Customers createdDate 1 Date datetime
Customers contactGroups 1 string varchar
Customers createdFromImportJournalId 1 string (Guid) varchar
Customers firstName 1 string varchar
Customers lastName 1 string varchar
Customers dateOfBirth 1 Date datetime
Customers socialSecurityNumber 1 string varchar
Customers subledgerNumberSeriesId 1 string (Guid) varchar
Customers reportInternationalId 1 boolean bit
Customers internationalIdCountryCode 1 string varchar
Customers internationalIdType 1 InternationalIdType varchar 250
Customers internationalIdNumber 1 string varchar
Customers externalImportReference 1 string varchar
Employees clientID 1 number int
Employees nationalityCountryCode 1 string varchar
Employees jobTitle 1 string varchar
Employees hiredDate 1 Date datetime
Employees startDate 1 Date datetime
Employees endDate 1 Date datetime
Employees departmentCode 1 string varchar
Employees locationCode 1 string varchar
Employees payrollBankAccountCode 1 string varchar
Employees expenseBankAccountCode 1 string varchar
Employees payrollEmailAddress 1 string varchar
Employees employeeCreatedDate 1 Date datetime
Employees managerEmployeeCode 1 number int
Employees gender 1 Gender int
Employees id 1 number int
Employees code 1 number int
Employees externalCode 1 number int
Employees emailAddress 1 string varchar
Employees phoneNumber 1 string varchar
Employees isArchived 1 boolean bit
Employees lastChanged 1 Date datetime
Employees createdDate 1 Date datetime
Employees contactGroups 1 string varchar
Employees createdFromImportJournalId 1 string (Guid) varchar
Employees firstName 1 string varchar 50
Employees lastName 1 string varchar 50
Employees dateOfBirth 1 Date datetime
Employees socialSecurityNumber 1 string varchar
Employees subledgerNumberSeriesId 1 string (Guid) varchar
Employees reportInternationalId 1 boolean bit
Employees internationalIdCountryCode 1 string varchar
Employees internationalIdType 1 InternationalIdType varchar 250
Employees internationalIdNumber 1 string varchar
Employees externalImportReference 1 string varchar
ChartOfAccounts clientID 1 number int
ChartOfAccounts id 1 number int
ChartOfAccounts code 1 number int
ChartOfAccounts name 1 string varchar 250
ChartOfAccounts vatCode 1 string varchar
ChartOfAccounts lastChanged 1 Date datetime
ChartOfAccounts isActive 1 boolean bit
ChartOfAccounts currencyCode 1 string varchar 10
ChartOfAccounts departmentCode 1 string varchar 100
ChartOfAccounts projectCode 1 string varchar 100
Transactions clientID 1 number int
Transactions id 1 number int
Transactions accountCode 1 number int
Transactions date 1 Date datetime
Transactions voucherNo 1 number int
Transactions importedVoucherNo 1 number int
Transactions voucherType 1 VoucherType varchar 50
Transactions text 1 string varchar 250
Transactions description 1 string varchar 250
Transactions vatCode 1 string varchar 50
Transactions vatAmount 1 number money
Transactions vatRate 1 number money
Transactions vatReturnSpecification 0 VatReturnSpecification varchar 100
Transactions amount 1 number money
Transactions currencyCode 1 string varchar 50
Transactions currencyAmount 1 number money
Transactions projectCode 1 string varchar 50
Transactions productCode 1 string varchar 50
Transactions departmentCode 1 string varchar 50
Transactions dim1Code 1 string varchar 50
Transactions dim2Code 1 string varchar 50
Transactions dim3Code 1 string varchar 50
Transactions voucherImagesCount 1 number int
Transactions lastChanged 1 Date datetime
Transactions createdDate 1 Date datetime
Transactions customerAccountNo 1 number int
Transactions supplierAccountNo 1 number int
Transactions employeeAccountNo 1 number int
Transactions voucherDueDate 1 Date datetime
Transactions voucherReference 1 string varchar 250
Transactions voucherCID 1 string varchar 50
Transactions voucherCreditNoteReference 1 string varchar 50
Transactions voucherId 1 string (Guid) varchar 50
Transactions documentNo 1 string varchar 50
Transactions createdFromImportJournalId 1 string (Guid) varchar 50
Transactions isCreatedFromEhf 1 boolean bit
Transactions bankTransferId 1 string (Guid) varchar 100
Transactions subLedgerEntryId 1 number int
Transactions externalImportReference 1 string varchar 50
Transactions hasVoucherDocumentation 1 boolean bit
Transactions ourReferenceEmployeeCode 1 number int
Transactions customMatchingReference 1 string varchar 100
Transactions quantity 1 number int
Transactions voucherDate 1 Date datetime
Transactions reversedVoucherNo 1 number int
Var denne artikkelen nyttig? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Har du flere spørsmål? Kontakt oss Kontakt oss