Таблица | Table: SC05 - «Serial Numbers». Маска имени таблицы | Table Name Mask: «SC05%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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 Contract Number 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 Contract Line Number 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 Batch Number 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 Batch ID Batch ID Current batch ID for the item.    
SC05049 NVARCHAR VSTRING 35 0 35 Fixed_Asset_Code Asset Code      
SC05050 NCHAR STRING 38 0 38 BOM_NodeID_Order BOM Node ID Order      
SC05051 NCHAR STRING 38 0 38 BOM_NodeID_Configuration BOM Node ID Configuration      
SC05052 NCHAR STRING 10 0 10 Human_readable_Node_ID Human Readable Node ID      
SC05053 NCHAR STRING 20 0 20 Parent_Serial_Number Parent Serial Number      
SC05054 NCHAR STRING 10 0 10 VersionNumber Configuration Version Number      
SC05055 NCHAR SWITCH 1 0 1 Blocked for Transfer        
SC05056 NVARCHAR VSTRING 10 0 10 DefaultEngineer Default Engineer      
SC05057 NCHAR STRING 6 0 6 Category Category      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Serial Numbers