One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Проектами»/List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table PR48 — Import/Export definitions

Таблица / Table: PR48 — «Import/Export definitions». Маска имени таблицы / Table name mask: «PR48%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR48001 NVARCHAR VSTRING 1 0 1 ImportExport Record Type   1 Да / Yes
PR48002 NVARCHAR VSTRING 2 0 2 TransactType Transaction Type   2 Да / Yes
PR48003 NVARCHAR VSTRING 3 0 3 DefinitionNo Definition Number   3 Да / Yes
PR48004 NVARCHAR VSTRING 3 0 3 FldDefinLine Field Number   4 Да / Yes
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      

Навигация / Navigation: