Не забудьте посетить страницу «Наши услуги» и заказать интеграцию 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»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 15 0 15 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 Ordering customer Customer Code Order      
ST08028 NVARCHAR VSTRING 10 0 10 Invoicing customer Customer Code Invoice      
ST08029 NVARCHAR VSTRING 10 0 10 Delivery customer Customer Code Delivery      
ST08030 NVARCHAR VSTRING 1 0 1 Type of invoice Type of Invoice      
ST08031 NUMERIC X_NUMERIC 20 8 12 Rejected quantity Rejected quantity      
ST08032 NVARCHAR VSTRING 4 0 4 Rejection Code Rejection Code      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Statistics | Purchase Statistics