Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: OR17 - «Order Text Lines». Маска имени таблицы: «OR17%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
OR17001 | NCHAR | STRING | 10 | 0 | 10 | OrderNumber | Order Number | 1 | Да | |
OR17002 | NCHAR | STRING | 6 | 0 | 6 | LineNumber | Line Number | Line number '000000' and '999999' is used for text that are related to the order and not a specific line. Line '00000' is printed before first order line and '999999' is printed after last order line. | 2 | Да |
OR17003 | NCHAR | STRING | 6 | 0 | 6 | StructLineNo | Sub-line Number | 3 | Да | |
OR17004 | NCHAR | STRING | 3 | 0 | 3 | AutSubStrtLin | Text Line Number | Line numbers with value 500 or greater will be printed after the order line in documents, lines with value 0-499 will be printed before the order line on documents. | 4 | Да |
OR17005 | NVARCHAR | VSTRING | 70 | 0 | 70 | TextLine1 | Text Line 1 | |||
OR17006 | NVARCHAR | VSTRING | 70 | 0 | 70 | TextLine2 | Text Line 2 | |||
OR17007 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnInv | Print on Invoice | |||
OR17008 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnQuo | Print on Quote | |||
OR17009 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnOr1 | Print on Confirmation | |||
OR17010 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnPic | Print on Picking List | |||
OR17011 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnDel | Print on Delivery Note | |||
OR17012 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnPro | Print on Proforma Invoice | |||
OR17013 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnShi | Print on Delivery Proposal | |||
OR17014 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGPrnOnOr2 | Print on Reports | |||
OR17015 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Print on Purchase Order | |||
OR17016 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
OR17017 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
OR17018 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
OR17019 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Discount Group | |||
OR17020 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
OR17021 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGLnNotSav | Line Saved in History | |||
OR17022 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvNoDummy | Invoice Number | |||
OR17023 | NCHAR | STRING | 4 | 0 | 4 | Version Number | Version Number | |||
OR17024 | NCHAR | STRING | 1 | 0 | 1 | PRTextGroup | Print in Project Documents |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Order | Order Text Lines