Таблица: SC16 - «Serial Number History». Маска имени таблицы: «SC16%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SC16001 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | 1 | Да | |
SC16002 | NVARCHAR | VSTRING | 20 | 0 | 20 | SerialNumber | Serial Number | 2 | Да | |
SC16003 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | 3 | Да | |
SC16004 | NCHAR | STRING | 2 | 0 | 2 | ReferenceNo | Reference Number | 4 | Да | |
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 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | Serial Number History