One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Statistics»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table ST08 — Purchase Statistics

Таблица / Table: ST08 — «Purchase Statistics». Маска имени таблицы / Table name mask: «ST08%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
ST08001 NVARCHAR VSTRING 10 0 10 SupplierCode Order 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 120 0 120 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 Да / Yes
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      
ST08034 NCHAR STRING 10 0 10 InvSupplCode Invoice Supplier Code      

Навигация / Navigation: