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»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SCB6001 | NCHAR | STRING | 10 | 0 | 10 | Priority | Priority | |||
SCB6002 | DATETIME | DATE | 0 | 0 | 8 | OrderDate | OrderDate | |||
SCB6003 | DATETIME | DATE | 0 | 0 | 8 | ReqDate | ReqDate | |||
SCB6004 | DATETIME | DATE | 0 | 0 | 8 | IntrPlanning | Internal Planning Date | |||
SCB6005 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | OrderNo | 2 | Да | |
SCB6006 | NCHAR | STRING | 6 | 0 | 6 | LineNo | LineNo | 3 | Да | |
SCB6007 | NCHAR | STRING | 6 | 0 | 6 | StrLineNo | StrLineNo | 4 | Да | |
SCB6008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ReqQty | ReqQty | |||
SCB6009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DelQty | DelQty | |||
SCB6010 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Factor | Factor | |||
SCB6011 | DATETIME | DATE | 0 | 0 | 8 | ReqDelDate | ReqDelDate | |||
SCB6012 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | StockCode | |||
SCB6013 | DATETIME | DATE | 0 | 0 | 8 | CommDelDate | CommDelDate | |||
SCB6014 | NCHAR | STRING | 10 | 0 | 10 | OrgOrdNo | OrgOrdNo | |||
SCB6015 | NCHAR | STRING | 20 | 0 | 20 | OrgLineNo | OrgLineNo | |||
SCB6016 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
SCB6017 | NCHAR | STRING | 1 | 0 | 1 | DelTransType | DelTransType | |||
SCB6018 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | NewRegQty | NewRegQty | |||
SCB6019 | DATETIME | DATE | 0 | 0 | 8 | NewIntrPlanning | New Internal Planning Date | |||
SCB6020 | NCHAR | SWITCH | 1 | 0 | 1 | LineChecked | LineChecked | |||
SCB6021 | NCHAR | SWITCH | 1 | 0 | 1 | FDSItem | FDSItem | |||
SCB6022 | NCHAR | SWITCH | 1 | 0 | 1 | AccLineSplit | AccLineSplit | |||
SCB6023 | NCHAR | SWITCH | 1 | 0 | 1 | AccOrderSplit | AccOrderSplit | |||
SCB6024 | NCHAR | SWITCH | 1 | 0 | 1 | Changed | Changed | |||
SCB6025 | NCHAR | SWITCH | 1 | 0 | 1 | UseBackODate | UseBackODate | |||
SCB6026 | NCHAR | SWITCH | 1 | 0 | 1 | StockPlan | StockPlan | |||
SCB6027 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MinSplitQty | MinSplitQty | |||
SCB6028 | DATETIME | DATE | 0 | 0 | 8 | CusResDate | CusResDate | |||
SCB6029 | INT | INTEGER | 0 | 0 | 5 | CusLeadT | CusLeadT | |||
SCB6030 | NCHAR | SWITCH | 1 | 0 | 1 | TopItem | TopItem | |||
SCB6031 | INT | INTEGER | 0 | 0 | 3 | CusLeadT2 | CusLeadT2 | |||
SCB6032 | INT | INTEGER | 0 | 0 | 1 | CusLeadTUnit | CusLeadTUnit | |||
SCB6033 | NCHAR | STRING | 2 | 0 | 2 | CompanyC | CompanyC | 1 | Да | |
SCB6034 | DATETIME | DATE | 0 | 0 | 8 | Confirmed | Confirmed Date | |||
SCB6035 | DATETIME | DATE | 0 | 0 | 8 | NewConfirmed | New Confirmed Date |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | Work file for ATP Rescheduling