One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Stock Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SC11 — Stock Planning

Таблица: SC11 — «Stock Planning». Маска имени таблицы: «SC11%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC11001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   1 Да
SC11002 DATETIME DATE 0 0 8 IntrPlanning Internal Planning Date   2 Да
SC11003 NCHAR STRING 10 0 10 OrderNumber Order Number   3 Да
SC11004 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse   5 Да
SC11005 NUMERIC X_NUMERIC 20 8 12 Qty Quantity      
SC11006 NVARCHAR VSTRING 35 0 35 CustSuppCode Customer/Supplier Code      
SC11007 NVARCHAR VSTRING 35 0 35 CustSuppName Customer/Supplier Name      
SC11008 DATETIME DATE 0 0 8 DelDateRequ Delivery Date Requested      
SC11009 INT INTEGER 0 0 1 ConfirmShipm Confirmed Shipment 0 — Shipment has not been confirmed (sales)
1 — Shipment has been confirmed (sales)
2 — Shipment has not been confirmed (purchase)
3 — Shipment has been confirmed (purchase)
5 — Budgeted transaction
   
SC11010 NCHAR SWITCH 1 0 1 ScalaReleaFl Internal Version Flag Was used internally in earlier versions of Scala.    
SC11011 INT INTEGER 0 0 2 TransactType Transaction Type 0 — Planned orders
99 — Budget transactions
   
SC11012 NCHAR STRING 20 0 20 OrigLineNo Original Order Line Number   4 Да
SC11013 NCHAR STRING 20 0 20 OrigStructLine Target Order Line Number Drop Shipment      
SC11014 NCHAR STRING 10 0 10 TargetOrdNo Target Order Number Drop Shipment      
SC11015 NCHAR STRING 1 0 1 FLAGInOut Transaction Source 0 — Purchase Order
1 — Sales Order
2 — Service Order
4 — Stock Item Budget
A — MPC Work Order Material Lines (Issues)
B — MPC Work Order Material Lines (Receipts)
C — MPC Work Order (Receipt)
D — MPC Work Order (Issue)
E — MPC Master Planning (Receipt)
F — MPC Master Planning (Issue)
G — MPC Gross Requirement
H — MPC Forecast
I — MPC Purchase Proposal
   
SC11016 BINARY BINSTRING 1 0 1 StatNeedFill Status Need Filled      
SC11017 NVARCHAR VSTRING 12 0 12 BatchNumber Batch ID      
SC11018 INT INTEGER 0 0 1 TransaTarget Transaction Target      
SC11019 NVARCHAR VSTRING 1 0 1 DeliTranType Delivery Transaction Type   6 Да
SC11020 NCHAR SWITCH 1 0 1 InOut Receipt or Issue 0 — Receipt
1 — Issue
   
SC11021 DATETIME DATE 0 0 8 ConfirmedDD Confirmed Delivery Date      
SC11022 DATETIME DATE 0 0 8 ReservationEndDate Reservation End Date      
SC11023 NCHAR SWITCH 1 0 1 FirmedOrder Firmed order      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SC11021 0 8 0 8 0 8 0 8 0 8 0 8
SC11022 0 8 0 8 0 8 0 8 0 8 0 8
SC11023 1 1 1 1 1 1 1 1 1 1 1 1

Навигация: