Таблица | Table: SC16 - «Serial Number History». Маска имени таблицы | Table Name Mask: «SC16%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | 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 | Source Warehouse | ||||
SC16028 | NVARCHAR | VSTRING | 6 | 0 | 6 | Target Warehouse | ||||
SC16029 | NVARCHAR | VSTRING | 36 | 0 | 36 | ExternalID | External ID |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Serial Number History