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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SC16 — Serial Number History

Таблица / Table: SC16 — «Serial Number History». Маска имени таблицы / Table name mask: «SC16%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC16001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
SC16002 NVARCHAR VSTRING 20 0 20 SerialNumber Serial Number   2 Да / Yes
SC16003 DATETIME DATE 0 0 8 TransactDate Transaction Date   3 Да / Yes
SC16004 NCHAR STRING 2 0 2 ReferenceNo Reference Number   4 Да / Yes
SC16005 NCHAR STRING 3 0 3 TransactType Transaction Type A — Stock received

B — Stock received input mode

C — Stock issues

D — Stock issues Input mode 3

E — Stock lent

F — Stock returned

G — Serial number changed

H — Configuration is created

I — Configuration is sold

J — Configuration is received

M — Attach to BOM configuration

N — Detach from BOM Configuration

Q — Warranty will expired

R — Return transactions

S — New SN is created

V — Configuration is maintained

W — Configuration is component

X — Swap

Y — Configuration is changed

Z — Scrap transactions
   
SC16006 NCHAR STRING 4 0 4 IncidentCode Incident Code      
SC16007 NCHAR STRING 4 0 4 UrgencyCode Urgency Code      
SC16008 NVARCHAR VSTRING 40 0 40 Remark Remark      
SC16009 NVARCHAR VSTRING 10 0 10 CustSuppCode Customer/Supplier Code      
SC16010 NVARCHAR VSTRING 35 0 35 CustomSuppl Customer/Supplier Name      
SC16011 NVARCHAR VSTRING 4 0 4 ActionCode Action Code      
SC16012 NVARCHAR VSTRING 4 0 4 Status Status Code      
SC16013 NCHAR STRING 10 0 10 ServiceOrder Service Order      
SC16014 DATETIME DATE 0 0 8 ServiceDate Service Date      
SC16015 NVARCHAR VSTRING 4 0 4 RemarkLineNo Remarks Line Number      
SC16016 NCHAR STRING 6 0 6 JobCode Job Code      
SC16017 NCHAR STRING 15 0 15 AnalysisCode Analysis Code      
SC16018 NCHAR STRING 7 0 7 ErrorCode Error Code      
SC16019 NCHAR STRING 10 0 10 ContractCode Contract Number      
SC16020 NCHAR STRING 6 0 6 ContractLineNumber Contract Line Number      
SC16021 NCHAR STRING 6 0 6 ContractSubLineNumber Contract Sub-line Number      
SC16022 DATETIME DATE 0 0 8 LineStartDate Contract Line Start Date      
SC16023 DATETIME DATE 0 0 8 LineEndDate Contract Line End Date      
SC16024 NCHAR STRING 35 0 35 BOMConfigurationCode BOM Configuration Code      
SC16025 NCHAR STRING 10 0 10 BOMNodeID BOM Human Readable Node ID      
SC16026 NCHAR STRING 10 0 10 VersionNumber Configuration Version Number      
SC16027 NVARCHAR VSTRING 6 0 6 SourceWarehouse Source Warehouse      
SC16028 NVARCHAR VSTRING 6 0 6 TargetWH Target Warehouse      
SC16029 NVARCHAR VSTRING 36 0 36 ExternalID External ID      

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