One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SC05 — Serial Numbers

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC05001 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
SC05002 NCHAR STRING 20 0 20 SerialNo Serial Number   2 Да / Yes
SC05003 NVARCHAR VSTRING 25 0 25 Description Description      
SC05004 NVARCHAR VSTRING 10 0 10 CustCode Customer Code      
SC05005 NVARCHAR VSTRING 35 0 35 CustName Customer Name      
SC05006 DATETIME DATE 0 0 8 DelDate Delivery Date      
SC05007 DATETIME DATE 0 0 8 CustWarrEx Customer Warranty Expiration Date      
SC05008 NUMERIC MONEY 28 8 20 Price Price (Local Currency)      
SC05009 NVARCHAR VSTRING 30 0 30 Remark Remark      
SC05010 NVARCHAR VSTRING 10 0 10 OrderNoDel Customer Order Number      
SC05011 NVARCHAR VSTRING 4 0 4 ProdGroup Product Group      
SC05012 NVARCHAR VSTRING 4 0 4 AltProdGroup Alternative Product Group      
SC05013 NCHAR STRING 2 0 2 AccountCode Automatic Accounting Code      
SC05014 DATETIME DATE 0 0 8 LateInspDate Last Inspection Date      
SC05015 NCHAR STRING 4 0 4 InspecInterv Inspection Interval Used in service order and defines the interval between inspections for this stock item. The leading character specifies the time unit used, where ‘W’ stands for weeks, ‘M’ for month and no leading character for number of days.    
SC05016 DATETIME DATE 0 0 8 LatesMaintDa Last Maintenance Date      
SC05017 NCHAR STRING 4 0 4 MaintInterv Maintenance Interval Used in service order and defines the maintenance interval for this serial number. The leading character specifies the time unit used where ‘W’ stands for weeks, ‘M’ for month and no leading character for number of days.    
SC05018 NVARCHAR VSTRING 20 0 20 CertificatNo Certificate Number      
SC05019 NCHAR STRING 10 0 10 ContractNumber Contract Number      
SC05020 NVARCHAR VSTRING 6 0 6 Version Version      
SC05021 NVARCHAR VSTRING 6 0 6 Release Release      
SC05022 NVARCHAR VSTRING 25 0 25 CustomSiteNo Custom Site      
SC05023 NCHAR STRING 6 0 6 ContractLineNumber Contract Line Number      
SC05024 NCHAR STRING 6 0 6 OrderLineNo Customer Order Line Number      
SC05025 NCHAR STRING 6 0 6 OrdStruLine Customer Order Sub-line number      
SC05026 NVARCHAR VSTRING 12 0 12 BatchNumber Batch Number Batch number assigned when the item was received into stock.    
SC05027 DATETIME DATE 0 0 8 WarrStartD1 Customer Warranty Start Date      
SC05028 NCHAR STRING 10 0 10 PurchOrdNo Purchase Order Number      
SC05029 NCHAR STRING 6 0 6 PurchOrdLine Purchase Order Line Number      
SC05030 NCHAR STRING 6 0 6 PurchOrdStr Purchase Order Sub-line Number      
SC05031 NVARCHAR VSTRING 10 0 10 SupplVendCod Supplier Code      
SC05032 NVARCHAR VSTRING 35 0 35 SupplVendNam Supplier Name      
SC05033 DATETIME DATE 0 0 8 ReceivedDate Date Received      
SC05034 DATETIME DATE 0 0 8 WarrStartD2 Supplier Warranty Start Date      
SC05035 DATETIME DATE 0 0 8 WarrEndDate Supplier Warranty End Date      
SC05036 DATETIME DATE 0 0 8 RepWarrStart Repair Warranty Start Date      
SC05037 DATETIME DATE 0 0 8 RepaWarrEnd Repair Warranty End Date      
SC05038 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
SC05039 NVARCHAR VSTRING 6 0 6 BinNumber Bin      
SC05040 NCHAR SWITCH 1 0 1 AllocSNFlag Allocated Serial Number      
SC05041 NVARCHAR VSTRING 6 0 6 PurschOrgWH Purchase Original in Warehouse      
SC05042 NVARCHAR VSTRING 6 0 6 PurchOrigBin Purchase Original in Bin      
SC05043 NUMERIC MONEY 28 8 20 PurcPriceLCU Purchase Price (Local Currency)      
SC05044 NCHAR STRING 20 0 20 PurchSerNo Purchase Serial Number      
SC05045 NCHAR SWITCH 1 0 1 SerialNoText Serial Number Text      
SC05046 NCHAR STRING 1 0 1 SerialNoStat Owner 0 — Own

1 — Customer

2 — Supplier

3 — Other

4 — Asset

5 — Scrapped
   
SC05047 NCHAR STRING 1 0 1 SeriaNoPlace Location 0 — In Warehouse

1 — At customer

2 — At supplier

3- On repair

4 — On Hold

A — Z — user defined Location codes from SY24
   
SC05048 NVARCHAR VSTRING 12 0 12 BatchID Batch ID Current batch ID for the item.    
SC05049 NVARCHAR VSTRING 35 0 35 FixedAssetCode Asset Code      
SC05050 NCHAR STRING 38 0 38 BOMNodeIDOrder BOM Node ID Order      
SC05051 NCHAR STRING 38 0 38 BOMNodeIDConfiguration BOM Node ID Configuration      
SC05052 NCHAR STRING 10 0 10 HumanreadableNodeID Human Readable Node ID      
SC05053 NCHAR STRING 20 0 20 ParentSerialNumber Parent Serial Number      
SC05054 NCHAR STRING 10 0 10 VersionNumber Configuration Version Number      
SC05055 NCHAR SWITCH 1 0 1 BlockForTransfer Blocked for Transfer      
SC05056 NVARCHAR VSTRING 10 0 10 DefaultEngineer Default Engineer      
SC05057 NCHAR STRING 6 0 6 Category Category      

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