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