Таблица | Table: SCB6 - «Work file for ATP Rescheduling». Маска имени таблицы | Table Name Mask: «SCB60000»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
SCB6001 | NCHAR | STRING | 10 | 0 | 10 | Priority | ||||
SCB6002 | DATETIME | DATE | 0 | 0 | 8 | OrderDate | ||||
SCB6003 | DATETIME | DATE | 0 | 0 | 8 | ReqDate | ||||
SCB6004 | DATETIME | DATE | 0 | 0 | 8 | IntrPlanning | Internal Planning Date | |||
SCB6005 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | 2 | Да / Yes | ||
SCB6006 | NCHAR | STRING | 6 | 0 | 6 | LineNo | 3 | Да / Yes | ||
SCB6007 | NCHAR | STRING | 6 | 0 | 6 | StrLineNo | 4 | Да / Yes | ||
SCB6008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ReqQty | ||||
SCB6009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DelQty | ||||
SCB6010 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Factor | ||||
SCB6011 | DATETIME | DATE | 0 | 0 | 8 | ReqDelDate | ||||
SCB6012 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | ||||
SCB6013 | DATETIME | DATE | 0 | 0 | 8 | CommDelDate | ||||
SCB6014 | NCHAR | STRING | 10 | 0 | 10 | OrgOrdNo | ||||
SCB6015 | NCHAR | STRING | 20 | 0 | 20 | OrgLineNo | ||||
SCB6016 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | ||||
SCB6017 | NCHAR | STRING | 1 | 0 | 1 | DelTransType | ||||
SCB6018 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | NewRegQty | ||||
SCB6019 | DATETIME | DATE | 0 | 0 | 8 | NewIntrPlanning | New Internal Planning Date | |||
SCB6020 | NCHAR | SWITCH | 1 | 0 | 1 | LineChecked | ||||
SCB6021 | NCHAR | SWITCH | 1 | 0 | 1 | FDSItem | ||||
SCB6022 | NCHAR | SWITCH | 1 | 0 | 1 | AccLineSplit | ||||
SCB6023 | NCHAR | SWITCH | 1 | 0 | 1 | AccOrderSplit | ||||
SCB6024 | NCHAR | SWITCH | 1 | 0 | 1 | Changed | ||||
SCB6025 | NCHAR | SWITCH | 1 | 0 | 1 | UseBackODate | ||||
SCB6026 | NCHAR | SWITCH | 1 | 0 | 1 | StockPlan | ||||
SCB6027 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MinSplitQty | ||||
SCB6028 | DATETIME | DATE | 0 | 0 | 8 | CusResDate | ||||
SCB6029 | INT | INTEGER | 0 | 0 | 5 | CusLeadT | ||||
SCB6030 | NCHAR | SWITCH | 1 | 0 | 1 | TopItem | ||||
SCB6031 | INT | INTEGER | 0 | 0 | 3 | CusLeadT2 | ||||
SCB6032 | INT | INTEGER | 0 | 0 | 1 | CusLeadTUnit | ||||
SCB6033 | NCHAR | STRING | 2 | 0 | 2 | CompanyC | 1 | Да / Yes | ||
SCB6034 | DATETIME | DATE | 0 | 0 | 8 | Confirmed | Confirmed Date | |||
SCB6035 | DATETIME | DATE | 0 | 0 | 8 | NewConfirmed | New Confirmed Date |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Work file for ATP Rescheduling