Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: PR48 - «Import/Export definitions». Маска имени таблицы: «PR48%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR48001 | NVARCHAR | VSTRING | 1 | 0 | 1 | ImportExport | Record Type | 1 | Да | |
PR48002 | NVARCHAR | VSTRING | 2 | 0 | 2 | TransactType | Transaction Type | 2 | Да | |
PR48003 | NVARCHAR | VSTRING | 3 | 0 | 3 | DefinitionNo | Definition Number | 3 | Да | |
PR48004 | NVARCHAR | VSTRING | 3 | 0 | 3 | FldDefinLine | Field Number | 4 | Да | |
PR48005 | NVARCHAR | VSTRING | 40 | 0 | 40 | DefinDescrip | Description | |||
PR48006 | NVARCHAR | VSTRING | 50 | 0 | 50 | FileName | Filename | |||
PR48007 | NVARCHAR | VSTRING | 4 | 0 | 4 | FieldData1 | Position in Record | |||
PR48008 | NVARCHAR | VSTRING | 4 | 0 | 4 | FieldData2 | Length of Field | |||
PR48009 | NVARCHAR | VSTRING | 4 | 0 | 4 | FieldData3 | Mapped Scala Field Number | |||
PR48010 | NVARCHAR | VSTRING | 4 | 0 | 4 | FieldData4 | Field Option | |||
PR48011 | NVARCHAR | VSTRING | 4 | 0 | 4 | FieldData5 | Field Data | |||
PR48012 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraData1 | Extra Data 1 | |||
PR48013 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraData2 | Extra Data 2 | |||
PR48014 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraData3 | Extra Data 3 | |||
PR48015 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraData4 | Extra Data 4 | |||
PR48016 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtraData5 | Extra Data 5 | |||
PR48017 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG1 | Delete Import File | 0 - The transaction file that is imported will not be delete and remains as is on the disk.
1 - After the transaction file has been imported it will be deleted to avoid double entry. |
||
PR48018 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG2 | Extra Option 2 | |||
PR48019 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG3 | New Sub-Projects | 0 - The sub-project specified in the import file must exist, the transaction will not be imported if the sub-project is missing.
1 - New sub-projects will be created if the sub-project specified in the import file does not exist. |
||
PR48020 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG4 | New Activity Lines | 0 - The activity line/code specified in the import file must exist, the transaction will not be imported if it's missing.
1 - New activity lines will be created if the activity line/code specified in the import file does not exist. |
||
PR48021 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG5 | Extra Option 5 | |||
PR48022 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG6 | Extra Option 6 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Import/Export definitions