Translations:TAS:Pokročilé/Pluginy/Input, Output/Import/SolverTech.Tasha.Plugins.IO.Database.config/9/en
Skočit na navigaci
Skočit na vyhledávání
- dbo.OBJ - table with orders
- dbo.OBJ.ID - order identifier, used to connect to dbo.OBJPol
- dbo.OBJ.Cislo - Order number
- dbo.OBJ.RefAD (sometimes dbo.OBJ.RefADdod) - subscriber number - generally ideal id for Tasha, can also be used to connect to dbo.AD
- dbo.OBJ.Firma - name of the customer, generally the ideal name for Tasha (can also be Firma2)
- dbo.OBJ.Ulice - street and customer's descriptive number (can also be Street2)
- dbo.OBJ.Obec - city of the customer
- dbo.OBJ.PSC - customer's postcode
- dbo.OBJ.KcCelkem - Total price of the order
- dbo.OBJpol - table with order items
- dbo.OBJpol.RefAg - field with order number, used to connect to dbo.OBJ
- dbo.OBJpol.Mnozstvi - Quantity of goods, ideal as demand1
- dbo.OBJpol.MJ - unit of goods, useful in conversions e.g. pcs per kg.
- dbo.OBJpol.MJKoef - Coefficient for quantity. It is used to calculate the real quantity of goods
- dbo.OBJpol.SText - name of goods
- dbo.OBJpol.Kc - price for ordered quantity without VAT
- dbo.OBJpol.KcDPH - price for ordered goods with VAT
- dbo.AD - folder table
- dbo.AD.ID - person identifier, used to connect to dbo.OBJ