Таблица | Table: SC05 - «Serial Numbers». Маска имени таблицы | Table Name Mask: «SC05%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | 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