Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: SCB6 - «Work file for ATP Rescheduling». Маска имени таблицы: «SCB60000»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SCB6001 | NCHAR | STRING | 10 | 0 | 10 | Priority | NULL | |||
SCB6002 | DATETIME | DATE | 0 | 0 | 8 | OrderDate | NULL | |||
SCB6003 | DATETIME | DATE | 0 | 0 | 8 | ReqDate | NULL | |||
SCB6004 | DATETIME | DATE | 0 | 0 | 8 | IntrPlanning | Internal Planning Date | |||
SCB6005 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | NULL | 2 | Да | |
SCB6006 | NCHAR | STRING | 6 | 0 | 6 | LineNo | NULL | 3 | Да | |
SCB6007 | NCHAR | STRING | 6 | 0 | 6 | StrLineNo | NULL | 4 | Да | |
SCB6008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ReqQty | NULL | |||
SCB6009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DelQty | NULL | |||
SCB6010 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Factor | NULL | |||
SCB6011 | DATETIME | DATE | 0 | 0 | 8 | ReqDelDate | NULL | |||
SCB6012 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | NULL | |||
SCB6013 | DATETIME | DATE | 0 | 0 | 8 | CommDelDate | NULL | |||
SCB6014 | NCHAR | STRING | 10 | 0 | 10 | OrgOrdNo | NULL | |||
SCB6015 | NCHAR | STRING | 20 | 0 | 20 | OrgLineNo | NULL | |||
SCB6016 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | NULL | |||
SCB6017 | NCHAR | STRING | 1 | 0 | 1 | DelTransType | NULL | |||
SCB6018 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | NewRegQty | NULL | |||
SCB6019 | DATETIME | DATE | 0 | 0 | 8 | NewIntrPlanning | New Internal Planning Date | |||
SCB6020 | NCHAR | SWITCH | 1 | 0 | 1 | LineChecked | NULL | |||
SCB6021 | NCHAR | SWITCH | 1 | 0 | 1 | FDSItem | NULL | |||
SCB6022 | NCHAR | SWITCH | 1 | 0 | 1 | AccLineSplit | NULL | |||
SCB6023 | NCHAR | SWITCH | 1 | 0 | 1 | AccOrderSplit | NULL | |||
SCB6024 | NCHAR | SWITCH | 1 | 0 | 1 | Changed | NULL | |||
SCB6025 | NCHAR | SWITCH | 1 | 0 | 1 | UseBackODate | NULL | |||
SCB6026 | NCHAR | SWITCH | 1 | 0 | 1 | StockPlan | NULL | |||
SCB6027 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MinSplitQty | NULL | |||
SCB6028 | DATETIME | DATE | 0 | 0 | 8 | CusResDate | NULL | |||
SCB6029 | INT | INTEGER | 0 | 0 | 5 | CusLeadT | NULL | |||
SCB6030 | NCHAR | SWITCH | 1 | 0 | 1 | TopItem | NULL | |||
SCB6031 | INT | INTEGER | 0 | 0 | 3 | CusLeadT2 | NULL | |||
SCB6032 | INT | INTEGER | 0 | 0 | 1 | CusLeadTUnit | NULL | |||
SCB6033 | NCHAR | STRING | 2 | 0 | 2 | CompanyC | NULL | 1 | Да | |
SCB6034 | DATETIME | DATE | 0 | 0 | 8 | Confirmed | Confirmed Date | |||
SCB6035 | DATETIME | DATE | 0 | 0 | 8 | NewConfirmed | New Confirmed Date |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Work file for ATP Rescheduling