Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: GLH0 - «PMS Interface File Structure Definition (Header)». Маска имени таблицы: «GLH0%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
GLH0001 | NCHAR | STRING | 3 | 0 | 3 | File Structure Code | File Structure Code | 1 | Да | |
GLH0002 | NCHAR | STRING | 32 | 0 | 32 | File Structure Name | File Structure Name | |||
GLH0003 | NCHAR | STRING | 64 | 0 | 64 | Path | Path | |||
GLH0004 | NCHAR | STRING | 12 | 0 | 12 | File Name | File Name | |||
GLH0005 | NCHAR | STRING | 3 | 0 | 3 | Data Type | Data Type | F - The file layout is for a file with fixed record length an column position/length
D - The file layout if for a Delimiter separated file, the delimiter character is defined in column GLH0006. |
||
GLH0006 | NCHAR | STRING | 3 | 0 | 3 | Delimiter | Delimiter Character | |||
GLH0007 | NCHAR | STRING | 3 | 0 | 3 | Char 2 | Option String | 3 character string where each character is a separate option:
Character 1: Text Qualifier character Character 2: General ledger transaction number series, A-Z or empty for standard counter Character 3: (Not used) |
||
GLH0008 | NCHAR | STRING | 1 | 0 | 1 | Transfer Type | Transfer Type | 0 - Revenue transfer
1 - City Ledger Transfer (Sales Ledger) |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | General Ledger | PMS Interface File Structure Definition (Header)