Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

Таблица: ST08 - «Purchase Statistics». Маска имени таблицы: «ST08%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
ST08001 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
ST08002 NVARCHAR VSTRING 4 0 4 SuppCategory Supplier Category      
ST08003 NVARCHAR VSTRING 10 0 10 OrderNo Purchase Order Number      
ST08004 NVARCHAR VSTRING 1 0 1 OrderType Order Type 0 - Purchase Order Proposal / Request for Quotation
1 - Normal Order
2 - Back Order
3 - Direct Delivery to Customer
4 - Replenishment Order
   
ST08005 NVARCHAR ACCSTR 50 0 50 AccCodeStrin Accounting String      
ST08006 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
ST08007 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
ST08008 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
ST08009 DATETIME DATE 0 0 8 DeliveryDate Delivery Date      
ST08010 NVARCHAR VSTRING 6 0 6 DeliveryTime Delivery Variance Request vs. Actual      
ST08011 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
ST08012 NVARCHAR VSTRING 4 0 4 ProductGroup Product Group      
ST08013 NVARCHAR VSTRING 4 0 4 AltProdGroup Alternative Product Group      
ST08014 NUMERIC X_NUMERIC 20 8 12 PurchaseQty Purchased Quantity      
ST08015 NUMERIC MONEY 28 8 20 PriceLCU Purchase Price (Local Currency)      
ST08016 NUMERIC MONEY 28 8 20 Price Purchase Price (Invoice Currency)      
ST08017 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
ST08018 NCHAR SWITCH 1 0 1 FullyShipp01 Fully Shipped      
ST08019 DATETIME DATE 0 0 8 DelDateReq Delivery Date Requested      
ST08020 NCHAR STRING 8 0 8 SearchIndex Index Key   1 Да
ST08021 NUMERIC X_NUMERIC 20 8 12 QtySC Purchased Quantity (Stock Units)      
ST08022 NVARCHAR VSTRING 12 0 12 BatchIDDeliv Batch ID      
ST08023 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Invoice      
ST08024 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice Number      
ST08025 NVARCHAR VSTRING 10 0 10 AutoDelNoteNo Goods Received Note Number      
ST08026 NVARCHAR VSTRING 10 0 10 Pickinglist Picking List      
ST08027 NVARCHAR VSTRING 10 0 10 OrderingCustomer Customer Code Order      
ST08028 NVARCHAR VSTRING 10 0 10 InvCustomer Customer Code Invoice      
ST08029 NVARCHAR VSTRING 10 0 10 DeliveryCustomer Customer Code Delivery      
ST08030 NVARCHAR VSTRING 1 0 1 InvType Type of Invoice      
ST08031 NUMERIC X_NUMERIC 20 8 12 QtyRejected Rejected quantity      
ST08032 NVARCHAR VSTRING 4 0 4 RejectionCode Rejection Code      
ST08033 DATETIME DATE 0 0 8 OriginalRequestedDeliveryDate Original Requested Delivery Date      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Statistics | Purchase Statistics