Exact Data

Tables (9)

SalesOrderLines

  • ID (SalesOrderLineID) — UNIQUEIDENTIFIER — Foreign key → goods_delivery_columns.SalesOrderLineID
  • OrderNumber — TEXT — Foreign key → sales_order_columns.OrderNumber
  • OrderID — TEXT — Foreign key → sales_order_columns.OrderID
  • ItemCode — TEXT — Foreign key → item_master_columns.Code
  • Item — TEXT — Foreign key → item_master_columns.ID — NOT NULL
  • Timestamp — BIGINT
  • AmountDC — FLOAT
  • AmountFC — FLOAT
  • CostCenter — NVARCHAR(255)
  • CostCenterDescription — NVARCHAR(255)
  • CostPriceFC — FLOAT
  • CostUnit — NVARCHAR(255)
  • CostUnitDescription — NVARCHAR(255)
  • Created — DATETIME
  • Creator — UNIQUEIDENTIFIER
  • CreatorFullName — NVARCHAR(255)
  • CustomerItemCode — NVARCHAR(255)
  • CustomField — NVARCHAR(MAX)
  • DeliveryDate — DATETIME
  • DeliveryStatus — SMALLINT
  • DeliveryStatusDescription — NVARCHAR(255)
  • Description — NVARCHAR(MAX)
  • Discount — FLOAT
  • Division — INT
  • InvoiceStatus — SMALLINT
  • InvoiceStatusDescription — NVARCHAR(255)
  • ItemDescription — NVARCHAR(255)
  • ItemVersion — UNIQUEIDENTIFIER
  • ItemVersionDescription — NVARCHAR(255)
  • LineNumber — INT
  • Margin — FLOAT
  • Modified — DATETIME
  • Modifier — UNIQUEIDENTIFIER
  • ModifierFullName — NVARCHAR(255)
  • NetPrice — FLOAT
  • Notes — NVARCHAR(MAX)
  • Pricelist — UNIQUEIDENTIFIER
  • PricelistDescription — NVARCHAR(255)
  • Project — UNIQUEIDENTIFIER
  • ProjectCode — NVARCHAR(255)
  • ProjectDescription — NVARCHAR(255)
  • PurchaseOrder — UNIQUEIDENTIFIER
  • PurchaseOrderLine — UNIQUEIDENTIFIER
  • PurchaseOrderLineNumber — INT
  • PurchaseOrderNumber — INT
  • Quantity — FLOAT
  • QuantityDelivered — FLOAT
  • QuantityInvoiced — FLOAT
  • ShopOrder — UNIQUEIDENTIFIER
  • ShopOrderNumber — INT
  • Status — SMALLINT
  • StatusDescription — NVARCHAR(255)
  • UnitCode — NVARCHAR(50)
  • UnitDescription — NVARCHAR(255)
  • UnitPrice — FLOAT
  • UseDropShipment — BIT
  • VATAmount — FLOAT
  • VATCode — NVARCHAR(50)
  • VATCodeDescription — NVARCHAR(255)
  • VATPercentage — FLOAT

customer_columns

  • ID (AccountID) — TEXT — Primary key
  • Code — TEXT — Primary key
  • Timestamp — TEXT
  • Accountant — TEXT
  • AccountManager — TEXT
  • AccountManagerFullName — TEXT
  • AccountManagerHID — TEXT
  • ActivitySector — TEXT
  • ActivitySubSector — TEXT
  • AddressLine1 — TEXT
  • AddressLine2 — TEXT
  • AddressLine3 — TEXT
  • BankAccounts — TEXT
  • Blocked — TEXT
  • BRIN — TEXT
  • BSN — TEXT
  • BusinessType — TEXT
  • CanDropShip — TEXT
  • ChamberOfCommerce — TEXT
  • City — TEXT
  • Classification — TEXT
  • Classification1 — TEXT
  • Classification2 — TEXT
  • Classification3 — TEXT
  • Classification4 — TEXT
  • Classification5 — TEXT
  • Classification6 — TEXT
  • Classification7 — TEXT
  • Classification8 — TEXT
  • ClassificationDescription — TEXT
  • CodeAtSupplier — TEXT
  • CompanySize — TEXT
  • ConsolidationScenario — TEXT
  • ControlledDate — TEXT
  • Costcenter — TEXT
  • CostcenterDescription — TEXT
  • CostPaid — TEXT
  • Country — TEXT
  • CountryName — TEXT
  • Created — TEXT
  • Creator — TEXT
  • CreatorFullName — TEXT
  • CreditLinePurchase — TEXT
  • CreditLineSales — TEXT
  • Currency — TEXT
  • CustomField — TEXT
  • CustomerSince — TEXT
  • DatevCreditorCode — TEXT
  • DatevDebtorCode — TEXT
  • DeliveryAdvice — TEXT
  • DiscountPurchase — TEXT
  • DiscountSales — TEXT
  • Division — TEXT
  • Document — TEXT
  • DunsNumber — TEXT
  • Email — TEXT
  • EnableSalesPaymentLink — TEXT
  • EndDate — TEXT
  • EstablishedDate — TEXT
  • Fax — TEXT
  • … +102

financial_columns

  • __metadata — TEXT — Primary key
  • ID — TEXT — Primary key — NOT NULL
  • Account (AccountID) — TEXT — Foreign key → customer_columns.ID
  • AccountCode — TEXT — Foreign key → customer_columns.Code
  • Timestamp — TEXT
  • AccountName — TEXT
  • AmountDC — TEXT
  • AmountFC — TEXT
  • AmountVATFC — TEXT
  • AmountVATBaseFC — TEXT
  • Asset — TEXT
  • AssetCode — TEXT
  • AssetDescription — TEXT
  • CostCenter — TEXT
  • CostCenterDescription — TEXT
  • CostUnit — TEXT
  • CostUnitDescription — TEXT
  • Created — TEXT
  • Creator — TEXT
  • CreatorFullName — TEXT
  • Currency — TEXT
  • Date — TEXT
  • Description — TEXT
  • Division — TEXT
  • Document — TEXT
  • DocumentNumber — TEXT
  • DocumentSubject — TEXT
  • DueDate — TEXT
  • EntryID — TEXT
  • EntryNumber — TEXT
  • ExchangeRate — TEXT
  • ExternalLinkDescription — TEXT
  • ExternalLinkReference — TEXT
  • ExtraDutyAmountFC — TEXT
  • ExtraDutyPercentage — TEXT
  • FinancialPeriod — TEXT
  • FinancialYear — TEXT
  • GLAccount — TEXT
  • GLAccountCode — TEXT
  • GLAccountDescription — TEXT
  • InvoiceNumber — TEXT
  • ItemDescription — TEXT
  • JournalCode — TEXT
  • JournalDescription — TEXT
  • LineNumber — TEXT
  • LineType — TEXT
  • Modified — TEXT
  • Modifier — TEXT
  • ModifierFullName — TEXT
  • Notes — TEXT
  • OffsetID — TEXT
  • OrderNumber — TEXT
  • PaymentDiscountAmount — TEXT
  • PaymentReference — TEXT
  • Project — TEXT
  • ProjectCode — TEXT
  • ProjectDescription — TEXT
  • Quantity — TEXT
  • SerialNumber — TEXT
  • Status — TEXT
  • … +13

goods_delivery_columns

  • __metadata — TEXT — Primary key
  • SalesOrderLineID — TEXT — Primary key
  • ID (DeliveryID) — TEXT — Primary key — NOT NULL
  • ItemCode — TEXT — Foreign key → item_master_columns.Code
  • Item — TEXT — Foreign key → item_master_columns.ID — NOT NULL
  • SalesOrderNumber — TEXT — Foreign key → sales_order_columns.OrderNumber
  • Timestamp — TEXT
  • Created — TEXT
  • Creator — TEXT
  • CreatorFullName — TEXT
  • CustomerItemCode — TEXT
  • Description — TEXT
  • DeliveryDate — TEXT
  • Division — TEXT
  • EntryID — TEXT
  • ItemDescription — TEXT
  • LineNumber — TEXT
  • Modified — TEXT
  • Modifier — TEXT
  • ModifierFullName — TEXT
  • Notes — TEXT
  • QuantityDelivered — TEXT
  • QuantityOrdered — TEXT
  • SalesOrderLineNumber — TEXT
  • TrackingNumber — TEXT
  • Unitcode — TEXT
  • BatchNumbers — TEXT
  • SerialNumbers — TEXT
  • StorageLocation — TEXT
  • StorageLocationCode — TEXT
  • StorageLocationDescription — TEXT

item_master_columns

  • __metadata — TEXT — Primary key
  • Code (Item Code) — TEXT — Primary key
  • ID (ItemId) — TEXT — Primary key — NOT NULL
  • Timestamp — TEXT
  • Class_01 — TEXT
  • Class_02 — TEXT
  • Class_03 — TEXT
  • Class_04 — TEXT
  • Class_05 — TEXT
  • Class_06 — TEXT
  • Class_07 — TEXT
  • Class_08 — TEXT
  • Class_09 — TEXT
  • Class_10 — TEXT
  • CopyRemarks — TEXT
  • CostPriceCurrency — TEXT
  • CostPriceNew — TEXT
  • CostPriceStandard — TEXT
  • AverageCost — TEXT
  • Barcode — TEXT
  • Created — TEXT
  • CreatorFullName — TEXT
  • Creator — TEXT
  • CustomField — TEXT
  • Description — TEXT
  • Division — TEXT
  • EndDate — TEXT
  • ExtraDescription — TEXT
  • FreeBoolField_01 — TEXT
  • FreeBoolField_02 — TEXT
  • FreeBoolField_03 — TEXT
  • FreeBoolField_04 — TEXT
  • FreeBoolField_05 — TEXT
  • FreeDateField_01 — TEXT
  • FreeDateField_02 — TEXT
  • FreeDateField_03 — TEXT
  • FreeDateField_04 — TEXT
  • FreeDateField_05 — TEXT
  • FreeNumberField_01 — TEXT
  • FreeNumberField_02 — TEXT
  • FreeNumberField_03 — TEXT
  • FreeNumberField_04 — TEXT
  • FreeNumberField_05 — TEXT
  • FreeNumberField_06 — TEXT
  • FreeNumberField_07 — TEXT
  • FreeNumberField_08 — TEXT
  • FreeTextField_01 — TEXT
  • FreeTextField_02 — TEXT
  • FreeTextField_03 — TEXT
  • FreeTextField_04 — TEXT
  • FreeTextField_05 — TEXT
  • FreeTextField_06 — TEXT
  • FreeTextField_07 — TEXT
  • FreeTextField_08 — TEXT
  • FreeTextField_09 — TEXT
  • FreeTextField_10 — TEXT
  • GLCostsCode — TEXT
  • GLCostsDescription — TEXT
  • GLCosts — TEXT
  • GLRevenueCode — TEXT
  • … +46

purchase_order_columns

  • ID — TEXT — Primary key
  • Item — TEXT — Foreign key → item_master_columns.ID — NOT NULL
  • ItemCode — TEXT — Foreign key → item_master_columns.Code
  • Need to calculated by "Warehouse&Item" (PositionID) — TEXT — Foreign key → stock_position_columns.ID — NOT NULL
  • AmountFC — TEXT
  • AmountDC — TEXT
  • ApprovalStatus — TEXT
  • ApprovalStatusDescription — TEXT
  • Approved — TEXT
  • Approver — TEXT
  • ApproverFullName — TEXT
  • CostCenter — TEXT
  • CostCenterCode — TEXT
  • CostCenterDescription — TEXT
  • CostUnit — TEXT
  • CostUnitCode — TEXT
  • CostUnitDescription — TEXT
  • Created — TEXT
  • Creator — TEXT
  • CreatorFullName — TEXT
  • Currency — TEXT
  • DeliveryAccount — TEXT
  • DeliveryAccountCode — TEXT
  • DeliveryAccountName — TEXT
  • DeliveryAddress — TEXT
  • DeliveryContact — TEXT
  • DeliveryContactPersonFullName — TEXT
  • Description — TEXT
  • Discount — TEXT
  • Division — TEXT
  • Document — TEXT
  • DocumentNumber — TEXT
  • DocumentSubject — TEXT
  • DropShipment — TEXT
  • ExchangeRate — TEXT
  • Expense — TEXT
  • ExpenseDescription — TEXT
  • IncotermAddress — TEXT
  • IncotermCode — TEXT
  • IncotermVersion — TEXT
  • InvoicedQuantity — TEXT
  • InvoiceStatus — TEXT
  • IsBatchNumberItem — TEXT
  • IsSerialNumberItem — TEXT
  • ItemBarcode — TEXT
  • ItemDescription — TEXT
  • ItemDivisable — TEXT
  • LineNumber — TEXT
  • Modified — TEXT
  • Modifier — TEXT
  • ModifierFullName — TEXT
  • NetPrice — TEXT
  • Notes — TEXT
  • OrderDate — TEXT
  • OrderNumber — TEXT
  • OrderStatus — TEXT
  • PaymentCondition — TEXT
  • PaymentConditionDescription — TEXT
  • Project — TEXT
  • ProjectCode — TEXT
  • … +43

sales_order_columns

  • OrderID — TEXT — Primary key
  • OrderNumber (SalesOrderNumber) — TEXT — Primary key
  • __metadata — TEXT — Primary key
  • Created by combining "Warehouse&Item" (PositionID) — TEXT — Foreign key → stock_position_columns.ID — NOT NULL
  • AmountDiscount — TEXT
  • AmountDiscountExclVat — TEXT
  • AmountFCExclVat — TEXT
  • ApprovalStatus — TEXT
  • ApprovalStatusDescription — TEXT
  • Approved — TEXT
  • Approver — TEXT
  • ApproverFullName — TEXT
  • Created — TEXT
  • Creator — TEXT
  • CreatorFullName — TEXT
  • Currency — TEXT
  • DeliverTo — TEXT
  • DeliverToContactPerson — TEXT
  • DeliverToContactPersonFullName — TEXT
  • DeliverToName — TEXT
  • DeliveryStatusDescription — TEXT
  • DeliveryAddress — TEXT
  • Document — TEXT
  • DocumentNumber — TEXT
  • DocumentSubject — TEXT
  • IncotermAddress — TEXT
  • IncotermCode — TEXT
  • IncotermVersion — TEXT
  • InvoiceStatusDescription — TEXT
  • InvoiceTo — TEXT
  • InvoiceToContactPerson — TEXT
  • InvoiceToContactPersonFullName — TEXT
  • InvoiceToName — TEXT
  • Modified — TEXT
  • Modifier — TEXT
  • ModifierFullName — TEXT
  • OrderDate — TEXT
  • OrderedBy — TEXT
  • OrderedByContactPerson — TEXT
  • OrderedByContactPersonFullName — TEXT
  • OrderedByName — TEXT
  • PaymentCondition — TEXT
  • PaymentConditionDescription — TEXT
  • PaymentReference — TEXT
  • Remarks — TEXT
  • Salesperson — TEXT
  • SalespersonFullName — TEXT
  • SelectionCode — TEXT
  • SelectionCodeCode — TEXT
  • SelectionCodeDescription — TEXT
  • ShippingMethod — TEXT
  • ShippingMethodCode — TEXT
  • ShippingMethodDescription — TEXT
  • Status — TEXT
  • StatusDescription — TEXT
  • WarehouseID — TEXT
  • WarehouseCode — TEXT
  • WarehouseDescription — TEXT
  • YourRef — TEXT
  • AmountDC — TEXT
  • … +19

serial_number_columns

  • __metadata — TEXT — Primary key
  • StockTransactionID — TEXT — Foreign key → goods_delivery_columns.ID — NOT NULL
  • ItemCode (Item Code) — TEXT — Foreign key → item_master_columns.Code
  • Item (ItemId) — TEXT — Foreign key → item_master_columns.ID — NOT NULL
  • SerialBatchNumber — TEXT
  • DraftTransactionID — TEXT
  • ParentID — TEXT
  • Quantity — TEXT
  • IsDraft — TEXT
  • StockTransactionType — TEXT
  • StockCountLine — TEXT
  • PurchaseTransaction — TEXT
  • SalesTransaction — TEXT
  • StockTransactionLocation — TEXT
  • DraftStockTransactionLocation — TEXT
  • PicklistLine — TEXT
  • SalesReturnLine — TEXT
  • PickOrderLine — TEXT
  • WarehouseTransferLine — TEXT
  • Timestamp — TEXT
  • Warehouse — TEXT
  • WarehouseCode — TEXT
  • WarehouseDescription — TEXT
  • StorageLocation — TEXT
  • StorageLocationCode — TEXT
  • StorageLocationDescription — TEXT
  • SalesOrderLine — TEXT
  • Created — TEXT
  • Creator — TEXT
  • CreatorFullName — TEXT
  • Division — TEXT
  • ItemDescription — TEXT
  • Modified — TEXT
  • Modifier — TEXT
  • ModifierFullName — TEXT
  • Remarks — TEXT

stock_position_columns

  • __metadata — TEXT — Primary key
  • ID (PositionID) — TEXT — Primary key — NOT NULL
  • ItemCode — TEXT — Foreign key → item_master_columns.Code
  • ItemId — TEXT — Foreign key → item_master_columns.ID — NOT NULL
  • Timestamp — TEXT
  • ItemDescription — TEXT
  • UnitCode — TEXT
  • UnitDescription — TEXT
  • CurrentStock — TEXT
  • PlanningIn — TEXT
  • PlanningOut — TEXT
  • ProjectedStock — TEXT
  • ReservedStock — TEXT
  • FreeStock — TEXT
  • ReorderPoint — TEXT
  • Warehouse — TEXT
  • WarehouseCode — TEXT
  • WarehouseDescription — TEXT
  • Division — TEXT